AJAX Attribute Manager

DB: [1060] Duplicate column name 'sort_order' - AJAX Attribute Manager

DB: [1060] Duplicate column name 'sort_order'

by LeeFoster » Thu Sep 23, 2021 9:45 am

I just updated Attribute manager to the latest version and now I am getting the error -

Fatal error: DB: [1060] Duplicate column name 'sort_order' in C:\xampp\htdocs\360v3\includes\system\versioned\1.0.8.1\database_core.php on line 44

Phoenix is version 1.0.8.5
LeeFoster
VIP Member
VIP Member
Posts: 228
Joined: Sun Feb 28, 2021 9:41 pm
Contact:

Re: DB: [1060] Duplicate column name 'sort_order'

by raiwa » Thu Sep 23, 2021 2:16 pm

Hi Lee,

The latest version AJAX-AttributeManager-V3.3.5_CE_Phoenix is flagged for Phoenix 1.0.8.0 and you may get more issues with Phoenix 1.0.8.5. Using addons which are not updated to your Phoenix version is on your own risk.
However this error should not be due to Ajax attributes manager. The latest version supports the core sort order and should correct update the database. Maybe something went wrong during update.
Please check your database attributes and options tables for a duplicated "sort_order" column and if you find any duplicated, just delete one of them.
Public Phoenix Change Log Cheat Set on Google Sheets
https://docs.google.com/spreadsheets/d/ ... sp=sharing

Need Help?viewtopic.php?f=10&t=27
raiwa
PhoenixCart Developer
PhoenixCart Developer
Posts: 1184
Joined: Sat Dec 21, 2019 8:08 am
Contact:

Re: DB: [1060] Duplicate column name 'sort_order'

by LeeFoster » Thu Sep 23, 2021 5:11 pm

raiwa wrote:Hi Lee,
Please check your database attributes and options tables for a duplicated "sort_order" column and if you find any duplicated, just delete one of them.
I checked my entire database, 17 tables have the column sort_order in them. None of them have it twice.

I will carry on looking
LeeFoster
VIP Member
VIP Member
Posts: 228
Joined: Sun Feb 28, 2021 9:41 pm
Contact:

Re: DB: [1060] Duplicate column name 'sort_order'

by LeeFoster » Thu Sep 23, 2021 5:27 pm

Strangely the error has gone away, that said I don't see anything when I go to the attributes tab though I suspect this is down to the Phoenix version as you mentioned.
LeeFoster
VIP Member
VIP Member
Posts: 228
Joined: Sun Feb 28, 2021 9:41 pm
Contact: