DB Error (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 \'\' at line 1 SQL=SELECT a.*, m.reference_field, m.value AS field_translation FROM mos_fg_images AS a LEFT JOIN mos_nok_content AS m ON ((m.reference_id=a.id) AND (reference_table=\'fg_images\') AND (m.published=1) AND (m.language_id=3)) WHERE (state=1)AND(galleryid=82) ORDER BY ; - Query:

SELECT a.*, m.reference_field, m.value AS field_translation FROM mos_fg_images AS a LEFT JOIN mos_nok_content AS m ON ((m.reference_id=a.id) AND (reference_table='fg_images') AND (m.published=1) AND (m.language_id=3)) WHERE (state=1)AND(galleryid=82) ORDER BY ;

array(4) {
  [0]=>
  array(7) {
    ["file"]=>
    string(67) "/var/www/vhosts/palazzograssi.it/httpdocs/includes/global_utils.php"
    ["line"]=>
    int(591)
    ["function"]=>
    string(10) "logDBError"
    ["class"]=>
    string(6) "Logger"
    ["object"]=>
    object(Logger)#8 (2) {
      ["_log"]=>
      array(14) {
        [0]=>
        array(2) {
          ["level"]=>
          int(1024)
          ["message"]=>
          string(136) "2010-09-09 13:38:37:000000 - ObjectFactory::getInstances() - Translation needed, request language french, default language italian, id=3"
        }
        [1]=>
        array(2) {
          ["level"]=>
          int(1024)
          ["message"]=>
          string(231) "2010-09-09 13:38:37:000000 - /var/www/vhosts/palazzograssi.it/httpdocs/components/com_sef/sef.php(86) - [FbSEFHelper] -> process() - URL:'/index.php?option=com_fabergallery&task=view&id=82&Itemid=25&Itemid=152&lang=fr' is a CMS URL"
        }
        [2]=>
        array(2) {
          ["level"]=>
          int(1024)
          ["message"]=>
          string(233) "2010-09-09 13:38:37:000000 - /var/www/vhosts/palazzograssi.it/httpdocs/components/com_sef/sef.php(86) - [FbSEFHelper] -> process() - Internal URL is set:'index.php?option=com_fabergallery&task=view&id=82&Itemid=25&Itemid=152&lang=fr'"
        }
        [3]=>
        array(2) {
          ["level"]=>
          int(1024)
          ["message"]=>
          string(243) "2010-09-09 13:38:37:000000 - /var/www/vhosts/palazzograssi.it/httpdocs/components/com_sef/sef.php(86) - [FbSEFHelper] -> process() - Detected language 'fr' in URL 'index.php?option=com_fabergallery&task=view&id=82&Itemid=25&Itemid=152&lang=fr'"
        }
        [4]=>
        array(2) {
          ["level"]=>
          int(1024)
          ["message"]=>
          string(191) "2010-09-09 13:38:37:000000 - /var/www/vhosts/palazzograssi.it/httpdocs/components/com_sef/sef.class.php(807) - [FbSEFAlias] -> lookupOutgoing() - Alias not found or Error lookup incoming url:"
        }
        [5]=>
        array(2) {
          ["level"]=>
          int(1024)
          ["message"]=>
          string(262) "2010-09-09 13:38:37:000000 - /var/www/vhosts/palazzograssi.it/httpdocs/components/com_sef/sef.php(86) - [FbSEFHelper] -> process() - No alias found for url: index.php?option=com_fabergallery&task=view&id=82&Itemid=25&Itemid=152&lang=fr, automap function disabled"
        }
        [6]=>
        array(2) {
          ["level"]=>
          int(1024)
          ["message"]=>
          string(136) "2010-09-09 13:38:37:000000 - ObjectFactory::getInstances() - Translation needed, request language french, default language italian, id=3"
        }
        [7]=>
        array(2) {
          ["level"]=>
          int(1024)
          ["message"]=>
          string(162) "2010-09-09 13:38:37:000000 - /var/www/vhosts/palazzograssi.it/httpdocs/includes/global_utils.php(644) - ObjectCache::set() - ObjectCache::set(mosMambot,18,french)"
        }
        [8]=>
        array(2) {
          ["level"]=>
          int(1024)
          ["message"]=>
          string(136) "2010-09-09 13:38:37:000000 - ObjectFactory::getInstances() - Translation needed, request language french, default language italian, id=3"
        }
        [9]=>
        array(2) {
          ["level"]=>
          int(1024)
          ["message"]=>
          string(159) "2010-09-09 13:38:38:000000 - /var/www/vhosts/palazzograssi.it/httpdocs/includes/global_utils.php(644) - ObjectCache::set() - ObjectCache::set(mosMenu,1,french)"
        }
        [10]=>
        array(2) {
          ["level"]=>
          int(1024)
          ["message"]=>
          string(183) "2010-09-09 13:38:38:000000 - /var/www/vhosts/palazzograssi.it/httpdocs/includes/mambo.php(2726) - MenuHandler::getMenuItem() - Item menu not found, invalid paramters value. Menuid:152"
        }
        [11]=>
        array(2) {
          ["level"]=>
          int(1024)
          ["message"]=>
          string(208) "2010-09-09 13:38:38:000000 - /var/www/vhosts/palazzograssi.it/httpdocs/components/com_fabergallery/fabergallery.php(192) - MenuHandler::getMenuItem() - Item menu not found, invalid paramters value. Menuid:152"
        }
        [12]=>
        array(2) {
          ["level"]=>
          int(1024)
          ["message"]=>
          string(230) "2010-09-09 13:38:38:000000 - /var/www/vhosts/palazzograssi.it/httpdocs/components/com_fabergallery/fabergallery.php(216) - ObjectFactory::getInstances() - Translation needed, request language french, default language italian, id=3"
        }
        [13]=>
        array(2) {
          ["level"]=>
          int(256)
          ["message"]=>
          string(869) "2010-09-09 13:38:38:000000 - /var/www/vhosts/palazzograssi.it/httpdocs/components/com_fabergallery/fabergallery.php(216) - ObjectFactory::getInstances() - DB Error (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 \'\' at line 1 SQL=SELECT a.*, m.reference_field, m.value AS field_translation FROM mos_fg_images AS a LEFT JOIN mos_nok_content AS m ON ((m.reference_id=a.id) AND (reference_table=\'fg_images\') AND (m.published=1) AND (m.language_id=3)) WHERE (state=1)AND(galleryid=82) ORDER BY ; - Query:
SELECT a.*, m.reference_field, m.value AS field_translation FROM mos_fg_images AS a LEFT JOIN mos_nok_content AS m ON ((m.reference_id=a.id) AND (reference_table='fg_images') AND (m.published=1) AND (m.language_id=3)) WHERE (state=1)AND(galleryid=82) ORDER BY ;
" } } ["_debug_level"]=> int(1) } ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> &object(mlDatabase)#4 (10) { ["_sql"]=> string(261) "SELECT a.*, m.reference_field, m.value AS field_translation FROM mos_fg_images AS a LEFT JOIN mos_nok_content AS m ON ((m.reference_id=a.id) AND (reference_table='fg_images') AND (m.published=1) AND (m.language_id=3)) WHERE (state=1)AND(galleryid=82) ORDER BY ;" ["_errorNum"]=> int(1064) ["_errorMsg"]=> string(412) "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 '' at line 1 SQL=SELECT a.*, m.reference_field, m.value AS field_translation FROM mos_fg_images AS a LEFT JOIN mos_nok_content AS m ON ((m.reference_id=a.id) AND (reference_table='fg_images') AND (m.published=1) AND (m.language_id=3)) WHERE (state=1)AND(galleryid=82) ORDER BY ;" ["_table_prefix"]=> string(4) "mos_" ["_users_table_prefix"]=> string(4) "mos_" ["_resource"]=> resource(22) of type (mysql link) ["_cursor"]=> bool(false) ["_debug"]=> int(0) ["_ticker"]=> int(0) ["_log"]=> array(0) { } } } } [1]=> array(6) { ["file"]=> string(86) "/var/www/vhosts/palazzograssi.it/httpdocs/components/com_fabergallery/fabergallery.php" ["line"]=> int(216) ["function"]=> string(12) "getInstances" ["class"]=> string(13) "ObjectFactory" ["type"]=> string(2) "::" ["args"]=> array(1) { [0]=> &array(5) { ["classname"]=> string(13) "mosFaberImage" ["whereSQL"]=> string(26) "(state=1)AND(galleryid=82)" ["limitStart"]=> int(0) ["limit"]=> int(10) ["orderSQL"]=> string(0) "" } } } [2]=> array(4) { ["file"]=> string(86) "/var/www/vhosts/palazzograssi.it/httpdocs/components/com_fabergallery/fabergallery.php" ["line"]=> int(35) ["function"]=> string(11) "showGallery" ["args"]=> array(3) { [0]=> &string(2) "82" [1]=> &object(stdClass)#16 (3) { ["canEdit"]=> int(0) ["canEditOwn"]=> int(0) ["canPublish"]=> int(0) } [2]=> &int(1) } } [3]=> array(4) { ["file"]=> string(51) "/var/www/vhosts/palazzograssi.it/httpdocs/index.php" ["line"]=> int(273) ["args"]=> array(1) { [0]=> string(86) "/var/www/vhosts/palazzograssi.it/httpdocs/components/com_fabergallery/fabergallery.php" } ["function"]=> string(12) "require_once" } }