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

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

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,

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

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

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

Hello

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