[SOLVED, INVALID] Strange: 3 different table structures for jos_flexicontent_fields_item_relations

More
7 years 11 months ago - 7 years 11 months ago #64898 by wiebe
hi there,

I am currently updating all joomla/flexicontent installations I have running on my servers.
Most of them still had a flexicontent version 2.1.2
Now when I have upgraded some of them it turns out I have three variants of the table jos_flexicontent_fields_item_relations

one has

`field_id` int(11) NOT NULL DEFAULT '0',
`item_id` int(11) NOT NULL DEFAULT '0',
`valueorder` int(11) NOT NULL DEFAULT '1',
`value` mediumtext NOT NULL,

another one has also the field

`suborder` int(11) NOT NULL DEFAULT '1',

and a third one also the fields

`value_integer` bigint(20) DEFAULT NULL,
`value_decimal` decimal(65,15) DEFAULT NULL,
`value_datetime` datetime DEFAULT NULL,

while all three versions are 'working', I start to feel a bit insecure... this does not look right
I want to prevent I will run into problems later, so which structure is the proper one and what should I do to the others?

kind regards,

Wiebe
Last edit: 7 years 11 months ago by ggppdk.

Please Log in or Create an account to join the conversation.

More
7 years 11 months ago #64899 by ggppdk
Hello

all these (new) columns should exist in the websites that are FLEXIcontent v3.1.0 / v3.1.1

`suborder` int(11) NOT NULL DEFAULT '1',
`value_integer` bigint(20) DEFAULT NULL,
`value_decimal` decimal(65,15) DEFAULT NULL,
`value_datetime` datetime DEFAULT NULL,


-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

Please Log in or Create an account to join the conversation.

More
7 years 11 months ago #64900 by wiebe
OMG... I thought it was ok to upgrade directly form 2.12 to 3.11 but I probably missed somewhere some "ALTER TABLE" statements
where could I find these?
it is quite possible this also goes for some other tables

Please Log in or Create an account to join the conversation.

More
7 years 11 months ago - 7 years 11 months ago #64901 by ggppdk
Hello

yes it is ok to upgrade,
- from any previous version of FLEXIcontent to v3.1.1

Otherwise we would have code to block the upgrade with a message

In your case go the joomla installer and just reupload the package
- the installation script checks and adds any missing columns

also you can use "Install from URL" which is faster:
github.com/FLEXIcontent/flexicontent-cck/archive/v3.1.1.zip


A note: v3.1.0 / v3.1.1 now have a latest updatesite check, any new versions will appear in new updates screen of Joomla

Also if you do not get the new columns to be created, then send me a PM with super admin access, i would like to see if there is a bug


-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...
Last edit: 7 years 11 months ago by ggppdk.

Please Log in or Create an account to join the conversation.

More
7 years 11 months ago #64903 by wiebe
hi,

You wrote:
- the installation script checks and adds any missing columns

except in my case it didn't
as I mentioned earlier I have several cases where i did this update and only have those 4 fields which were also part of the Flexicontent 2 structure
the ALTER TABLE statements - I can find them now in the file script.php where for some reason not executed
is there a way to provoke this?

cheers,
Wiebe

Please Log in or Create an account to join the conversation.

More
7 years 11 months ago #64904 by ggppdk
Hello

please send me a PM with super-admin access i would like to see this


-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

Please Log in or Create an account to join the conversation.

Moderators: vistamediajoomlacornerggppdk
Time to create page: 0.451 seconds
Save
Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Essential
These cookies are needed to make the website work correctly. You can not disable them.
Display
Accept
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline