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

4 years 6 months ago - 4 years 6 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:

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

4 years 6 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 review. Thanks!

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

4 years 6 months ago - 4 years 6 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):
$index_cmds = array();

And after it add:
$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 review. Thanks!

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

4 years 6 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 review. Thanks!

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

4 years 6 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.

4 years 5 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.

4 years 5 months ago #65249 by ggppdk
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


-- 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 review. Thanks!

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

4 years 3 months ago #65833 by kath

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


same here, thanks for the above temp. fix, cheers,
k :)

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

Moderators: vistamediajoomlacornerggppdk
© 2018 Flexicontent. All Rights Reserved.