AlliedModders - [Issue] Inventory broken

AlliedModders (https://forums.alliedmods.net/index.php)

- Store (https://forums.alliedmods.net/forumdisplay.php?f=157)

- - Issue Inventory broken (https://forums.alliedmods.net/showthread.php?t=315028)

Inventory broken

PHP Code:


		
			
 L 03/17/2019 - 14:46:15: [Store] SQL Error on VoidQuery: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'first_created' in 'field list'')' at line 1')' at line 1')' at line 1')' at line' at line 1

spammed with this, i cant do !inv and its related to my loadouts. if i change loadout i can change my equipped items.

I cant goto "inventory" somehow it bugged after a couple months.

deleting the loadouts in sql it still didnt re create and fix the issue after server restart.

Re: Inventory broken

Seems like a recent mysql update.

Re: Inventory broken

It is because of "sql_mode=only_full_group_by"
If you are part of a shared web server, you will not be able to remove this restriction.