| |
|
Query Failure: SELECT c.Id, c.propsetId, c.ParentId, c.propsetId, c.Title, c.NavName, c.SortName, REPLACE(c.TextAlternative,'
', '
') AS TextAlternative, c.Short, Short AS Short1 , c.Short2, c.Short3, c.Short4, c.Short5, c.Url, c.ParagraphBreaks, IF (c.ParagraphBreaks <> 'html', REPLACE(c.Content,'
', '
'), c.Content) AS Content, IF (c.ParagraphBreaks <> 'html', REPLACE(c.Content,'
', '
'), c.Content) AS Content1, IF (
c.FileName = '',
'javascript:alert(\'Sorry, file not available\');',
CONCAT('tools/software/original/public/filedownload.php?code=', SUBSTRING_INDEX(c.FileName, ':::', -1))
) AS FileLink,
IF (
c.FileName = '',
'javascript:alert(\'Sorry, file not available\');',
CONCAT('tools/local/secureupload/content/FileName/', SUBSTRING_INDEX(c.FileName, ':::', -1))
) AS FileDirect,
IF (
c.FileName = '',
'[none]',
SUBSTRING_INDEX(c.FileName, ':::', 1)
) AS FileDisplay
, c.Thumbnail, CONCAT(c.Id, 't_', c.Thumbnail) AS Thumb, CONCAT(
'tools/local/imageupload/',
IF (
c.Thumbnail = '',
'spacer.gif',
CONCAT('content/Thumbnail/size1/', SUBSTRING_INDEX(c.Thumbnail, ':::', -1))
)
) AS AutoThumb, CONCAT(
'tools/local/imageupload/',
IF (
c.MainImage = '',
'spacer.gif',
CONCAT('content/MainImage/size1/', SUBSTRING_INDEX(c.MainImage, ':::', -1))
)
) AS AutoImage,
IF (
c.MainImage = '',
'../../../spacer.gif',
SUBSTRING_INDEX(c.MainImage, ':::', -1)
) AS AutoImageFile,
IF (
c.MainImage = '',
'[none]',
SUBSTRING_INDEX(c.MainImage, ':::', 1)
) AS AutoImageDisplay
, c.MainImage, CONCAT(c.Id, '_', c.FileName) AS Src, IF (c.FileName <> '', CONCAT('tools/local/imageupload/', c.Id, '_', c.FileName), 'images/spacer.gif') AS AutoSrc, IF (c.Url <> '', c.Url, CONCAT('pages/', c.Id, '/', REPLACE(c.Title,' ', '_'), '.htm')) AS AutoLink, c.Heading, c.Summary, IF (c.DisplayDate = '0000-00-00 00:00:00', '', DATE_FORMAT(c.DisplayDate, '%c/%e/%Y')) AS DisplayDate , UNIX_TIMESTAMP(c.DisplayDate) AS DisplayDateRaw , UNIX_TIMESTAMP(c.StartLive) AS StartLive, IF (c.ParagraphBreaks <> 'html', REPLACE(c.Content2,'
', '
'), c.Content2) AS Content2, IF (c.ParagraphBreaks <> 'html', REPLACE(c.Content3,'
', '
'), c.Content3) AS Content3, IF (c.ParagraphBreaks <> 'html', REPLACE(c.Content4,'
', '
'), c.Content4) AS Content4, IF (c.ParagraphBreaks <> 'html', REPLACE(c.Content5,'
', '
'), c.Content5) AS Content5, pr.Id AS ProductId, pr.ItemId, pr.Price, pr.PriceNote, pr.Weight, pr.Taxable, pr.Shipping, pr.Availability, pr.QuantityAvailable, pr.ProductType, pr.DiscountedPrice, pr.DiscountQuantity, pr.NonTaxableAmount, pr.Options, pr.RecurringPrice, pr.RecurringPeriod FROM (content c, propset ps , product pr, crossreference cr) WHERE (c.propsetId = ps.id AND ( 1 = 0 OR (
(
(
cr.ParentId IN () AND cr.ChildId = c.Id
) OR (
cr.ChildId IN () AND cr.ParentId = c.Id AND cr.Reversible = 'yes'
)
)
)
)
AND c.ProductId = pr.Id AND (c.LiveOverride = 'always' OR
(c.LiveOverride = 'by date' AND
(c.StartLive <= NOW() AND
(c.EndLive >= NOW() OR c.EndLive = '0000-00-00 00:00:00')
)
)
)) GROUP BY c.Id ORDER BY c.SortName, c.Title
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 ') AND cr.ChildId = c.Id
) OR (
cr.ChildId IN () AND cr.ParentId = c.I' at line 44 | | |
