(mysql): SELECT product_categories.*, IF( product_categories.Id = 0, 1, 0 ) AS selected, CONCAT( '/attachment/', IF( img.DirectoryPath IS NULL, '', CONCAT( img.DirectoryPath, '/' ) ), img.Id, '_', img.FileName ) AS ImgPath, img.Name AS ImgName FROM product_categories LEFT JOIN prodcat_image ON prodcat_image.CategoryId = product_categories.Id LEFT JOIN attachments AS img ON img.ParentId = prodcat_image.AttachmentId AND img.CopyId = 2 WHERE product_categories.Disabled IS NULL AND product_categories.ParentId = AND product_categories.Deleted IS NULL GROUP BY product_categories.Id ORDER BY product_categories.SortBy ASC  
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 'AND product_categories.Deleted IS NULL GROUP BY product_categories.I' at line 14

Warning: Invalid argument supplied for foreach() in /var/www/nyomdaker/site/modules/_menu.php on line 228
(mysql): SELECT attachments.Id AS DocId, CONCAT( '/attachment/', IF( attachments.DirectoryPath IS NULL, '', CONCAT( attachments.DirectoryPath, '/' ) ), attachments.Id, '_', attachments.FileName ) AS DocPath, attachments.Name AS DocName FROM attachments WHERE ParentId IS NULL AND Deleted IS NULL AND attachments.Id IN (SELECT AttachmentId FROM prodcat_document WHERE CategoryId=) GROUP BY attachments.Id  
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 ') GROUP BY attachments.Id' at line 12
(mysql): SELECT SQL_CALC_FOUND_ROWS products.*, img.Id AS ImgId, CONCAT( '/attachment/', IF( img.DirectoryPath IS NULL, '', CONCAT( img.DirectoryPath, '/' ) ), img.Id, '_', img.FileName ) AS ImgPath, CONCAT( '/attachment/', IF( img.DirectoryPath IS NULL, '', CONCAT( img.DirectoryPath, '/' ) ), (img.Id+1), '_', REPLACE(img.FileName,'copy_2','copy_3') ) AS NImgPath, CONCAT( '/attachment/', IF( doc.DirectoryPath IS NULL, '', CONCAT( doc.DirectoryPath, '/' ) ), doc.Id, '_', doc.FileName ) AS DocPath, doc.Name AS DocName, img.Name AS ImgName, img.Width AS ImgWidth FROM products LEFT JOIN product_image ON product_image.ProductId = products.Id LEFT JOIN attachments AS img ON img.ParentId = product_image.AttachmentId AND img.CopyId = 2 LEFT JOIN product_document ON product_document.ProductId = products.Id LEFT JOIN attachments AS doc ON doc.Id = product_document.AttachmentId WHERE products.CategoryId = AND products.Deleted IS NULL GROUP BY products.Id ORDER BY products.SortBy ASC  
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 'AND products.Deleted IS NULL GROUP BY products.Id ORDER BY p' at line 22
Nyomdaker - Termékek