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

More
7 years 5 months ago - 7 years 5 months ago #64838 by clutchmarketing
I am also have DB issues after I upgraded: I first get this:


After I update, I get this
Attachments:
Last edit: 7 years 5 months ago by clutchmarketing.

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

More
7 years 5 months ago #64839 by ggppdk
Hello

The task has code to DROP the old PRIMARY key !

this is not happening for some reason,
would like to see why,

you may send a PM with super admin access to the website


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

More
7 years 5 months ago #64862 by ggppdk
Hello

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

Regards


-- 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 5 months ago #64863 by clutchmarketing
That worked perfectly. Thanks so much for your help.

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

More
7 years 4 months ago #65245 by mijim
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.

Moderators: vistamediajoomlacornerggppdk
Time to create page: 1.287 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