patronbutiken LiteCart Fan Dari Sweden Anggota sejak Apr 2019 patronbutiken 24 Jun 2020 00:10 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 Dari Sweden Anggota sejak Mei 2013 tim 24 Jun 2020 03:26 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?
patronbutiken LiteCart Fan Dari Sweden Anggota sejak Apr 2019 patronbutiken 24 Jun 2020 11:15 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 Dari Sweden Anggota sejak Mei 2013 tim 24 Jun 2020 15:17 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!
patronbutiken LiteCart Fan Dari Sweden Anggota sejak Apr 2019 patronbutiken 24 Jun 2020 23:21 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.
tim Founder Dari Sweden Anggota sejak Mei 2013 tim 25 Jun 2020 00:07 It's possible you need to empty the database before inserting them back. Softaculous or any service will all overwrite the core files. These articles has some valuable information for you. https://wiki.litecart.net/how_to_upgrade https://wiki.litecart.net/how_to_prevent_losing_changes_when_upgrading https://wiki.litecart.net/how_to_adapt_to_git
patronbutiken LiteCart Fan Dari Sweden Anggota sejak Apr 2019 patronbutiken 25 Jun 2020 00:43 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 Dari Sweden Anggota sejak Mei 2013 tim 25 Jun 2020 01:50 Ask you questions here, I'm here to help :)
patronbutiken LiteCart Fan Dari Sweden Anggota sejak Apr 2019 patronbutiken 26 Jun 2020 19:16 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 Dari Sweden Anggota sejak Mei 2013 tim 2 Jul 2020 22:32 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.
patronbutiken LiteCart Fan Dari Sweden Anggota sejak Apr 2019 patronbutiken 2 Jul 2020 23:05 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 Dari Sweden Anggota sejak Mei 2013 tim 2 Jul 2020 23:09 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
patronbutiken LiteCart Fan Dari Sweden Anggota sejak Apr 2019 patronbutiken 2 Jul 2020 23:27 ok, haha never thougt about that ;-) I look into it right away, thanks
jsl LiteCart Fan Dari Malaysia Anggota sejak Mar 2018 jsl 1 Agu 2020 19:25 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 Dari Sweden Anggota sejak Mei 2013 tim 1 Agu 2020 19:41 Did you run /install/upgrade.php?
jsl LiteCart Fan Dari Malaysia Anggota sejak Mar 2018 jsl 1 Agu 2020 19:52 Hi Tim, I upgrade direct from Softaculous...
tim Founder Dari Sweden Anggota sejak Mei 2013 tim 2 Agu 2020 14:52 Can you open up an FTP client and see if any errors where logged in logs/errors.log?