Error when updating to 2.2.0 to latest

LiteCart Fan
Da Sweden
Membro dal apr 2019

Got the following error when i try to update, any ideas?

Upgrade
Checking PHP version... 7.2.31 [OK]

Checking application database version... 2.2.0 [OK]

Upgrading database to 2.2.1...

Fatal error: 1062 - Duplicate entry 'control_panel_link' for key 'key' INSERT INTO lc_settings (setting_group_key, type, title, description, key, value, function, priority, date_updated, date_created) VALUES ('advanced', 'local', 'Control Panel Link', 'The URL to your control panel, e.g. cPanel.', 'control_panel_link', '?app=settings&doc=advanced&action=edit&key=control_panel_link', 'text()', 18, NOW(), NOW()); in ~/includes/library/lib_database.inc.php (Line 248)

tim
Founder
Da Sweden
Membro dal mag 2013
tim

Seems like you have ran the upgrade patches already? Or do you know any reason why this setting is already in your platform?
Is this Softaculous?

LiteCart Fan
Da Sweden
Membro dal apr 2019

Yes Tim.  I ran the upgrade via Softaculous but there were some problems due to speed between my server and softacoulus.
I tried github first but didn't get that to work.  I made a rollback on my hotell with the date two days ago so my shop is up and running,

tim
Founder
Da Sweden
Membro dal mag 2013
tim

Roll back both the files and database to your backup. Make sure the database has no leftovers from 2.2.3.2 e.g. lc_products_options_values table.

Then attempt to upgrade manually by downloading LiteCart 2.2.3.2 and going to /install/upgrade.php. Don't worry, Softaculous will detect your new version so you are not breaking compatibility with Softaculous.

It's possible there are so many database queries being made in the 2.2.3.2 upgrade patch for your store that there was a timeout. The upgrade script will attempt to set a timeout of 300 s. It's possible Softaculous aborted earlier.

If there is an error during upgrade, post it here.

If you want to do it step by step. Try first upgrading to 2.2.2. Then go for 2.2.3.2.

Always use a development platform for your major changes!

LiteCart Fan
Da Sweden
Membro dal apr 2019

Did a rollback on all the files and data but the table lc_products_options_values is still there?
The reason I used softa...... is that I thougt that the update didn't overwrite my edited files, but it did.
I have tried the github way but stopped at the thing that I should compare and merge files, that was to much for my knowledge.

LiteCart Fan
Da Sweden
Membro dal apr 2019

thanks tim
Yes i noticed that it will overwritten core files.
i have read the articles you mentioned above, specially How To Adapt To Git.
and got that to worked until #6. 
there is were my knowledge ends

tim
Founder
Da Sweden
Membro dal mag 2013
tim

Ask you questions here, I'm here to help :)

LiteCart Fan
Da Sweden
Membro dal apr 2019

Managed to update to 2.2.2
But when i try to upgrade to 2.2.3.2
i got this error

Fatal error: 1060 - Duplicate column name 'priority' ALTER TABLE lc_attribute_values ADD COLUMN priority INT(11) NOT NULL AFTER group_id; in ~/includes/library/lib_database.inc.php (Line 254)

Regards
Peter

tim
Founder
Da Sweden
Membro dal mag 2013
tim

lc_attribute_values.priority doesn't exist until 2.2.3. So you still have remains from a previous upgrade when you attempt to upgrade.
If possible, delete the database. Then restore your database backup.

If you just get frustrated you may hire my hourly services to ride this one out.

LiteCart Fan
Da Sweden
Membro dal apr 2019

Thanks tim.
I have now downgrade to 2.0.0 via rollback at my webhotell so it works, 
but theres still som fields/tables in the db that remains from the update, 
i have tried to find what fields/tables that has been updated so i can delete them 
but im a little bit short of hours per day right now.
So please quote me what you think it will cost me to have you to fix this up

tim
Founder
Da Sweden
Membro dal mag 2013
tim

One way of telling db differences is exporting the structure using phpMyAdmin from both your corrupted database and a fresh new install. Then compare the two with WinMerge or similar.

This add-on has that feature.
https://www.litecart.net/en/addons/33/deploy-changes

LiteCart Fan
Da Sweden
Membro dal apr 2019

ok, haha never thougt about that ;-)
I look into it right away, thanks

jsl
LiteCart Fan
Da Malaysia
Membro dal mar 2018
jsl

Oh gosh...

Warning: Platform database version (2.2.2) does not match platform version (2.2.3.5). Did you run /install/upgrade.php? in ~/includes/library/lib_settings.inc.php (Line 19)

what should i do from here ?

tim
Founder
Da Sweden
Membro dal mag 2013
tim

Did you run /install/upgrade.php?

jsl
LiteCart Fan
Da Malaysia
Membro dal mar 2018
jsl

Hi Tim,

I upgrade direct from Softaculous...

tim
Founder
Da Sweden
Membro dal mag 2013
tim

Can you open up an FTP client and see if any errors where logged in logs/errors.log?

Questo thread è stato chiuso per lunga inattività. Non è possibile postare su di esso.
This website uses no cookies and no third party tracking technology. We think we can do better than others and really think about your privacy.