MODULE ERROR (3)
Error: Error running sql query: {SELECT
Inventory.item_ID
FROM
Inventory
LEFT JOIN
InventoryLookup
ON
InventoryLookup.item_ID = Inventory.item_ID
LEFT JOIN
InventoryCategories
ON
InventoryCategories.category_ID = InventoryLookup.category_ID
WHERE
InventoryLookup.category_ID =
ORDER BY
Inventory.item_Name ASC, Inventory.item_Family_Code ASC}. 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 'ORDER BY
Inventory.item_Name ASC, Inventory.item_Family_Code ASC' at line 15
File: /var/www/vhosts/thinkroadmaster.com/httpdocs/fw/core/core.class.php
Line: 176
Stack Trace:
#0 /var/www/vhosts/thinkroadmaster.com/httpdocs/fw/core/core.class.php(176): Core::dbQuery()
#1 /var/www/vhosts/thinkroadmaster.com/httpdocs/fw/modules/inventory.class.php(281): Core::dbQuery('SELECT??????Inv...', 3)
#2 /var/www/vhosts/thinkroadmaster.com/httpdocs/displays/inventory.php(41): Inventory->totalInventoryByCategory()
#3 /var/www/vhosts/thinkroadmaster.com/httpdocs/displays/includes.php(69): include('/var/www/vhosts...')
#4 /var/www/vhosts/thinkroadmaster.com/httpdocs/templates/template-interior.php(158): include('/var/www/vhosts...')
#5 /var/www/vhosts/thinkroadmaster.com/httpdocs/fw/core/core.class.php(252): include('/var/www/vhosts...')
#6 /var/www/vhosts/thinkroadmaster.com/httpdocs/site(36): Core->displayPage('interior')
#7 {main}