Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › PowerStore › Powerstore General / Announcements › PS3 MySQL Syntax Error Showing Product Results

View all replies to this thread

PS3 MySQL Syntax Error Showing Product Results

Thread began 4/19/2010 5:18 pm by myron364647 | Last modified 4/20/2010 6:47 am by myron364647 | 1291 views | 2 replies

4/19/2010 5:18 pmmyron364647

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.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.