Page 1 of 1
Upgrading DB error
Posted: Mon Jul 17, 2023 4:59 pm
by Graeme59
DB Error updating to 3.39
/home/virtual/vps-d5d7c7/e/e4ce592d4f/public_html/upgrade/data/upg_data/30300_db.sqlDuplicate key name 'regroup_idx'
no sure what to do?
Graeme
Re: Upgrading DB error
Posted: Mon Jul 17, 2023 5:03 pm
by alfa24
You should add the if not exists clause to the SQL instruction that tries to recreate the index.
Re: Upgrading DB error
Posted: Mon Jul 17, 2023 5:09 pm
by Graeme59
Hi,
Thanks for getting back to me
how do I do that?
Graeme
Re: Upgrading DB error
Posted: Mon Jul 17, 2023 5:13 pm
by alfa24
3.3.9 is not public, so I don't have the code. Find the wrong SQL and correct adding the workaround I suggested if you are able. Otherwise you can ask a developer. If you need me, you can contact me privately.