query | SELECT SQL_CALC_FOUND_ROWS p.*, img.location as image_location, img.id as image_id , UNIX_TIMESTAMP(p.created) as created , UNIX_TIMESTAMP(p.param_7) as param_7, p.id as id FROM `catalog_1_item` p LEFT JOIN `catalog_file` img ON ( img.catalog_id = '1' AND img.catalog_item_id = p.id AND img.style='image' AND img.main='1' ) WHERE p.active = 1 AND p.id NOT IN () ORDER BY RAND() LIMIT 3 |
---|
result |
errno | 1064 |
error | 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 ') ORDER BY RAND() LIMIT 3' at line 2 |
insert_id | 0 |
affected rows | -1 |
Location: | #0 /webx/users/bam_bmcms/benes-michl.cz/bmcms/core/cls/CAbstractClass.cls.php 480 qy() #1 /webx/users/bam_bmcms/benes-michl.cz/bmcms/modul/catalog/cls/CCatalogItem.cls.php 476 load() #2 /webx/users/bam_bmcms/benes-michl.cz/bmcms/modul/catalog/cls/CCatalogItem.cls.php 443 load() #3 /webx/users/bam_bmcms/benes-michl.cz/bmcms/core/inc/callback.inc.php(127) : eval()'d code 1 CCatalogItemList() #4 /webx/users/bam_bmcms/benes-michl.cz/bmcms/core/inc/callback.inc.php 127 eval() #5 /webx/users/bam_bmcms/benes-michl.cz/bmcms/core/cls/ft.cls.php 965 run_callback() #6 /webx/users/bam_bmcms/benes-michl.cz/bmcms/core/cls/CAbstractClass.cls.php 431 parse() #7 /webx/users/bam_bmcms/benes-michl.cz/bmcms/modul/catalog/cls/CCatalogItem.cls.php 418 parse_callback() #8 /webx/users/bam_bmcms/benes-michl.cz/bmcms/core/inc/callback.inc.php 138 parse_callback() #9 /webx/users/bam_bmcms/benes-michl.cz/bmcms/core/cls/ft.cls.php 965 run_callback() #10 /webx/users/bam-rebustav/rebustav.cz/www/index.php 224 parse() |