INVALID SQL: 1054 : Unknown column 'c.cdseo_url' in 'field list' SQL QUERY FAILURE:
SELECT
c.cdseo_url,
c.categoryid,
c.category
FROM
xcart_categories AS c
LEFT JOIN xcart_category_memberships AS cm ON cm.categoryid = c.categoryid
WHERE
c.avail = 'Y' AND
c.parentid = '0' AND
(cm.membershipid = 0 OR cm.membershipid IS NULL)
ORDER BY
c.order_by asc
INVALID SQL: 1054 : Unknown column 'c.cdseo_url' in 'field list' SQL QUERY FAILURE:
SELECT
c.cdseo_url,
c.category,
c.categoryid
FROM
xcart_categories AS c
LEFT JOIN xcart_category_memberships AS cm ON cm.categoryid = c.categoryid
WHERE
c.parentid = '' AND
c.avail = 'Y' AND
(cm.membershipid = 0 OR cm.membershipid IS NULL)
ORDER BY
c.order_by asc
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 'JOIN xcart_product_memberships AS pm ON pc.productid = pm.productid
WHERE
' at line 10 SQL QUERY FAILURE:
SELECT DISTINCT
p.cdseo_url,
p.productid,
p.descr,
p.product
FROM
xcart_products_categories AS pc
LEFT JOIN xcart_products AS p ON pc.productid = p.productid AND pc.categoryid =
LEFT JOIN xcart_product_memberships AS pm ON pc.productid = pm.productid
WHERE
p.forsale = 'Y' AND
(pm.membershipid = 0 OR pm.membershipid IS NULL)
ORDER BY
p.product asc
LIMIT 0, 4
Site Map
- Alchemy and Ice
We have a lot of old Gift Certificates on our system which need clearing. Currently, we are going through Gift Certificates from late 2008, small value Gift certificates are being deleted. However larger value Gift Certificate holders will receive a new Gift Certificate email notification reminding them of the code and value. These Gift Certificates will be deleted within 30 days of the reminder email being sent out. Gift Certificates are valid for 12 months but we realise that emails which are sent electronically can be easily lost in your inbox over time. Which is why we have this respite before they are deleted from the system.