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
AJAX Attribute Manager
DB: [1060] Duplicate column name 'sort_order' - AJAX Attribute Manager
-
- VIP Member
- Posts: 228
- Joined: Sun Feb 28, 2021 9:41 pm
- Contact:
Re: DB: [1060] Duplicate column name 'sort_order'
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.
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
https://docs.google.com/spreadsheets/d/ ... sp=sharing
Need Help?viewtopic.php?f=10&t=27
-
- PhoenixCart Developer
- Posts: 1184
- Joined: Sat Dec 21, 2019 8:08 am
- : Buy Me A Beverage
- Contact:
Re: DB: [1060] Duplicate column name 'sort_order'
I checked my entire database, 17 tables have the column sort_order in them. None of them have it twice.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 will carry on looking
-
- VIP Member
- Posts: 228
- Joined: Sun Feb 28, 2021 9:41 pm
- Contact:
Re: DB: [1060] Duplicate column name 'sort_order'
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.
-
- VIP Member
- Posts: 228
- Joined: Sun Feb 28, 2021 9:41 pm
- Contact: