[SOLVED] DB-index issues with upgrade from J2.5 / FC 2.x to J3.6 / FC3.1.0RC2

ggppdk
Offline
Administrator

7 years 5 months ago - 7 years 5 months ago #64843 by ggppdk

Replied by ggppdk on topic DB-index issues with upgrade from J2.5 / FC 2.x to J3.6 / FC3.1.0RC2

Hello

i found that under some cases the SQL code for indexes is executed in wrong order,
to fix now in your website:

edit
administrator/components/com_flexicontent/controller.php

Find (about line 879):

Code:

$index_cmds = array();

And after it add:

Code:

$index_cmds['indexdrop'] = array();   // !! important add 'indexdrop' to 'index_cmds', before 'indexadd' !!
$index_cmds['indexadd'] = array();

I have added fix to our code so that it exists in our next release

-- 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 5 months ago by ggppdk.

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

ggppdk
Offline
Administrator

7 years 5 months ago #64862 by ggppdk

Replied by ggppdk on topic DB-index issues with upgrade from J2.5 / FC 2.x to J3.6 / FC3.1.0RC2

Hello

@clutchmarketing
if you have applied the fix and it worked, you should post back feedback about it, that it worked

Regards

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

clutchmarketing
Offline
New Member

7 years 5 months ago #64863 by clutchmarketing

Replied by clutchmarketing on topic DB-index issues with upgrade from J2.5 / FC 2.x to J3.6 / FC3.1.0RC2

That worked perfectly. Thanks so much for your help.

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

mijim
Offline
Senior Member

7 years 4 months ago #65245 by mijim

Replied by mijim on topic [SOLVED] DB-index issues with upgrade from J2.5 / FC 2.x to J3.6 / FC3.1.0RC2

Hello,

I had the very same issue.
Adding the code in controller.php solved it straightaway.

Many thanks
Antoine

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

ggppdk
Offline
Administrator

7 years 4 months ago #65249 by ggppdk

Replied by ggppdk on topic [SOLVED] DB-index issues with upgrade from J2.5 / FC 2.x to J3.6 / FC3.1.0RC2

Hello

The fix is included in v3.1.2,
would like to release v3.1.2 soon

hhmm, will remove some non needed enhancement issues from it and move them to v3.1.3

The following user(s) said Thank You: Chabi01

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