| ||||||||||
Shopping cart software Solutions for online shops and malls | ||||||||||
|
#1
|
|||||||||
|
|||||||||
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.
__________________
Jonathan Flyclothing, LLC PO Box 1490 Gilbert, AZ 85299-1571 P 480.422.7350 F 888.359.2568 www.flysportsgear.com?MMCF_xcartforum (X-Cart 4.5.2) FOR SALE |
|||||||||
#2
|
|||||||
|
|||||||
Moving to Third Party Mods
__________________
Padraic Ryan Ryan Design Studio Professional E-Commerce Development |
|||||||
#3
|
|||||||||
|
|||||||||
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?
__________________
Groovico Used by X-carters the world over: Marketing Manager Pro Bundle For X-cart Featured Product Manager for X-cart Feed manager pro for X-cart http://www.firetanksoftware.com Celebrating 7 Years of providing quality X-cart Add ons and X-cart Mods for x-cart 3.X to X-cart 4.4.X |
|||||||||
|
|||
X-Cart forums © 2001-2020
|