Support Call: 421
Subject ABG Madness - The store
Status Closed
Assigned To FA Licah Fox
Logged By ADM Cyrel Vandroth
Logged On Mar 20, 2011
Call Text 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
FROM abgstoreitems
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.
Action History
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)