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}

 
Home    About RM    Contact RM    Technical Information    Terms & Conditions    Privacy Policy
    New Products    Exterior Products    Interior Products