X-Cart: shopping cart software

X-Cart forums (https://forum.x-cart.com/index.php)
-   Third Party Add-Ons for X-Cart 4 (https://forum.x-cart.com/forumdisplay.php?f=45)
-   -   SQL Error in Sitemap (https://forum.x-cart.com/showthread.php?t=23385)

flyclothing 07-18-2006 12:54 PM

SQL Error in Sitemap
I am receiving the following error when I visit http://www.flyclothing.com/fts_sitemap_cached.php

INVALID SQL: 1064 : 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 '-1' at line 1
SQL QUERY FAILURE: SELECT DISTINCT(p.productid), p.descr, p.product FROM xcart_products AS p, xcart_categories AS c, xcart_products_categories AS pc WHERE pc.productid = p.productid AND pc.categoryid = c.categoryid AND p.forsale = 'Y' AND (c.membership = '' OR c.membership ='') AND pc.categoryid = '22' ORDER BY orderby ASC LIMIT -1

The error just repeats with the pc.categoryid changing each time.

I repaired the databases, but nothing worked. I am not sure when it started to occur either, so I can't pinpoint any changes to the site caused the error.

Has anyone had similar issues and found a solution? Any help is gladly appreciated! Thank you.

balinor 07-18-2006 06:00 PM

Moving to Third Party Mods

groovico 08-06-2006 04:32 PM

Your signature suggests either x-cart 4.1. or x-cart 4.0.14, do you have the correct version of the firetanksoftware advanced x-cart sitemap installed for your version?

All times are GMT -8. The time now is 05:05 PM.

Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.