Support Call: 421
ABG Madness - The store
FA Licah Fox
ADM Cyrel Vandroth
Mar 20, 2011
This call is referring to the original abg.rebelsquadrons.org section.
Something has changed in the past 14 days that has broken the ABG store and ABG blackmarket.
When attempting to use the store, one receives an error message: "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 'range, damage, cost, hide FROM abgstoreitems WHERE type = '14' AND cost <= '' at line 1"
Tracking through the ABG's php documents, one finds the source of that MySQL statement. (Lines 62-67 of /abg/httpdocs/store/store.php )
$items = data ("id, name, class, description, range, damage, cost, hide
WHERE type = '$catid' AND cost <= '$currMoney'
ORDER BY cost DESC
This code (save for my JUST noodling with it in an attempt to fix the problem) has not changed in months, yet it just recently broke. Every other MySQL query on that page seems to have worked. Taking off the WHERE, AND, and ORDER keywords do not solve the issue. I have checked the MySQL database, and those are the correct collumn headings for the abgstoreitems database.
I honestly don't know what the flying monkey tits is wrong here. Josh took a quick look at it, and was similarly perplexed.
Mar 20, 2011
Should be all set. "range" is a reserved word for the MySQL we just upgraded to, must not have been for the earlier version. (ADM Licah Fox)