PS3 MySQL Syntax Error Showing Product Results
Using Power Store 3
After adding new categories and they are showing up on the customer pages, I'm getting the following error on all Category links:
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 'ANDProductID IN (SELECT ProductID FROM ps3_productcategories AND(CategoryID = 8)' at line 1
Error produced from URL: Products_Results.php?Search=1&ProductCategoryID=8
Link to error is originating from www.orbishosting.com under Shop
I've also reloaded a fresh copy of Product_Results.php from the PowerStore300 archive and still producing same results
Similar note, browsing the products (which were uploaded directly to ps3_products table) on Product_Results.php, choosing a category, say "Camping", there is one item assigned to this category and I can trace the Item to Category in the database, but the item content section of this page is blank, nothing happens.