Stuck on migrate

Chabi01
Topic Author
Offline
Platinum Member

8 years 3 months ago #63096 by Chabi01

Stuck on migrate was created by Chabi01

Hi,
I' m stuck on this step :

Create DB indexes
this may take a long time on big web-sites, if it timeouts (or takes >2 min) then please refresh, and click to create remaining indexes
# tables: 4 :
flexicontent_fields_item_relations (Indexing started)
flexicontent_items_versions (Indexing started)
flexicontent_templates (Indexing started)
flexicontent_favourites (1 indexes missing)
When i try to click on update, i get this :
Can't DROP 'PRIMARY'; check that column/key exists SQL=ALTER TABLE `#__flexicontent_favourites` DROP PRIMARY KEY, ADD PRIMARY KEY(`id`, `itemid`, `userid`, `type`)

Thanks for the help.

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

ggppdk
Offline
Administrator

8 years 3 months ago - 8 years 3 months ago #63101 by ggppdk

Replied by ggppdk on topic Stuck on migrate

Hello

The query checks if primary key is as needed but it assumes it also exists, will see to add some fix in this case (rare)

Manually run this in phpmyadmin:

Code:

ALTER  TABLE  `PPP_flexicontent_favourites`  ADD PRIMARY KEY(`id`, `itemid`, `userid`, `type`)

(replace PPP) with your Database prefix

Then try to access the backend again

-- 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: 8 years 3 months ago by ggppdk.

The following user(s) said Thank You: Chabi01

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