Raised This Month: $12 Target: $400
 3% 

Issue Inventory broken


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
Robin955
Veteran Member
Join Date: Jun 2013
Old 03-17-2019 , 15:13   Inventory broken
Reply With Quote #1

PHP Code:
 L 03/17/2019 14:46:15: [StoreSQL Error on VoidQueryYou have an error in your SQL syntaxcheck 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.
Robin955 is offline
Robin955
Veteran Member
Join Date: Jun 2013
Old 03-18-2019 , 13:01   Re: Inventory broken
Reply With Quote #2

Seems like a recent mysql update.
Robin955 is offline
Maliwolf
Member
Join Date: Jul 2015
Old 03-25-2019 , 17:43   Re: Inventory broken
Reply With Quote #3

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.
Maliwolf is offline
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 04:54.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode