Error
An error occured in a database query!

Context:
File/tiki-browse_image.php
Url/tiki-browse_image.php?offset=0&sort_mode=created_desc&desp=-1&galleryId=0&imageId=&popup=y
Query:
update tiki_images set hits=hits+1 where imageId=
Values:
Message:
Error MessageYou 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


Go back

Return to home page 
array(3) {
  [0]=>
  array(7) {
    ["file"]=>
    string(44) "/home1/asaross/public_html/lib/tikidblib.php"
    ["line"]=>
    int(115)
    ["function"]=>
    string(9) "sql_error"
    ["class"]=>
    string(6) "TikiDB"
    ["object"]=>
    object(ImageGalsLib)#12 (17) {
      ["db"]=>
      object(ADODB_mysql)#2 (77) {
        ["databaseType"]=>
        string(5) "mysql"
        ["dataProvider"]=>
        string(5) "mysql"
        ["hasInsertID"]=>
        bool(true)
        ["hasAffectedRows"]=>
        bool(true)
        ["metaTablesSQL"]=>
        string(11) "SHOW TABLES"
        ["metaColumnsSQL"]=>
        string(20) "SHOW COLUMNS FROM %s"
        ["fmtTimeStamp"]=>
        string(13) "'Y-m-d H:i:s'"
        ["hasLimit"]=>
        bool(true)
        ["hasMoveFirst"]=>
        bool(true)
        ["hasGenID"]=>
        bool(true)
        ["isoDates"]=>
        bool(true)
        ["sysDate"]=>
        string(9) "CURDATE()"
        ["sysTimeStamp"]=>
        string(5) "NOW()"
        ["hasTransactions"]=>
        bool(false)
        ["forceNewConnect"]=>
        bool(false)
        ["poorAffectedRows"]=>
        bool(true)
        ["clientFlags"]=>
        int(0)
        ["substr"]=>
        string(9) "substring"
        ["nameQuote"]=>
        string(1) "`"
        ["_genIDSQL"]=>
        string(38) "update %s set id=LAST_INSERT_ID(id+1);"
        ["_genSeqSQL"]=>
        string(33) "create table %s (id int not null)"
        ["_genSeq2SQL"]=>
        string(26) "insert into %s values (%s)"
        ["_dropSeqSQL"]=>
        string(13) "drop table %s"
        ["database"]=>
        string(16) "asaross_www_prod"
        ["host"]=>
        string(9) "localhost"
        ["user"]=>
        string(12) "asaross_root"
        ["password"]=>
        string(11) "Quandamooka"
        ["debug"]=>
        bool(false)
        ["maxblobsize"]=>
        int(262144)
        ["concat_operator"]=>
        string(1) "+"
        ["length"]=>
        string(6) "length"
        ["random"]=>
        string(6) "rand()"
        ["upperCase"]=>
        string(5) "upper"
        ["fmtDate"]=>
        string(7) "'Y-m-d'"
        ["true"]=>
        string(1) "1"
        ["false"]=>
        string(1) "0"
        ["replaceQuote"]=>
        string(2) "\'"
        ["charSet"]=>
        bool(false)
        ["metaDatabasesSQL"]=>
        string(0) ""
        ["uniqueOrderBy"]=>
        bool(false)
        ["emptyDate"]=>
        string(6) " "
        ["emptyTimeStamp"]=>
        string(6) " "
        ["lastInsID"]=>
        bool(false)
        ["hasTop"]=>
        bool(false)
        ["readOnly"]=>
        bool(false)
        ["genID"]=>
        int(0)
        ["raiseErrorFn"]=>
        bool(false)
        ["cacheSecs"]=>
        int(3600)
        ["arrayClass"]=>
        string(18) "ADORecordSet_array"
        ["noNullStrings"]=>
        bool(false)
        ["numCacheHits"]=>
        int(0)
        ["numCacheMisses"]=>
        int(0)
        ["pageExecuteCountRows"]=>
        bool(true)
        ["uniqueSort"]=>
        bool(false)
        ["leftOuter"]=>
        bool(false)
        ["rightOuter"]=>
        bool(false)
        ["ansiOuter"]=>
        bool(false)
        ["autoRollback"]=>
        bool(false)
        ["fnExecute"]=>
        bool(false)
        ["fnCacheExecute"]=>
        bool(false)
        ["blobEncodeType"]=>
        bool(false)
        ["rsPrefix"]=>
        string(13) "ADORecordSet_"
        ["autoCommit"]=>
        bool(true)
        ["transOff"]=>
        int(0)
        ["transCnt"]=>
        int(0)
        ["fetchMode"]=>
        bool(false)
        ["_oldRaiseFn"]=>
        bool(false)
        ["_transOK"]=>
        NULL
        ["_connectionID"]=>
        resource(13) of type (mysql link)
        ["_errorMsg"]=>
        string(146) "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"
        ["_errorCode"]=>
        bool(false)
        ["_queryID"]=>
        resource(122) of type (mysql result)
        ["_isPersistentConnection"]=>
        bool(false)
        ["_bindInputArray"]=>
        bool(false)
        ["_evalAll"]=>
        bool(false)
        ["_affected"]=>
        bool(false)
        ["_logsql"]=>
        bool(false)
      }
      ["buffer"]=>
      NULL
      ["flag"]=>
      NULL
      ["parser"]=>
      NULL
      ["pre_handlers"]=>
      array(0) {
      }
      ["pos_handlers"]=>
      array(0) {
      }
      ["postedit_handlers"]=>
      array(0) {
      }
      ["usergroups_cache"]=>
      array(0) {
      }
      ["num_queries"]=>
      int(0)
      ["now"]=>
      NULL
      ["_sql"]=>
      NULL
      ["havegd"]=>
      bool(true)
      ["gdinfo"]=>
      array(13) {
        ["GD Version"]=>
        string(26) "bundled (2.1.0 compatible)"
        ["FreeType Support"]=>
        bool(true)
        ["FreeType Linkage"]=>
        string(13) "with freetype"
        ["T1Lib Support"]=>
        bool(true)
        ["GIF Read Support"]=>
        bool(true)
        ["GIF Create Support"]=>
        bool(true)
        ["JPEG Support"]=>
        bool(true)
        ["PNG Support"]=>
        bool(true)
        ["WBMP Support"]=>
        bool(true)
        ["XPM Support"]=>
        bool(true)
        ["XBM Support"]=>
        bool(true)
        ["WebP Support"]=>
        bool(true)
        ["JIS-mapped Japanese Font Support"]=>
        bool(false)
      }
      ["gdversion"]=>
      string(3) "2.1"
      ["haveimagick"]=>
      bool(false)
      ["uselib"]=>
      string(2) "gd"
      ["canrotate"]=>
      bool(false)
    }
    ["type"]=>
    string(2) "->"
    ["args"]=>
    array(3) {
      [0]=>
      &string(49) "update tiki_images set hits=hits+1 where imageId="
      [1]=>
      &NULL
      [2]=>
      &bool(false)
    }
  }
  [1]=>
  array(7) {
    ["file"]=>
    string(56) "/home1/asaross/public_html/lib/imagegals/imagegallib.php"
    ["line"]=>
    int(467)
    ["function"]=>
    string(5) "query"
    ["class"]=>
    string(6) "TikiDB"
    ["object"]=>
    object(ImageGalsLib)#12 (17) {
      ["db"]=>
      object(ADODB_mysql)#2 (77) {
        ["databaseType"]=>
        string(5) "mysql"
        ["dataProvider"]=>
        string(5) "mysql"
        ["hasInsertID"]=>
        bool(true)
        ["hasAffectedRows"]=>
        bool(true)
        ["metaTablesSQL"]=>
        string(11) "SHOW TABLES"
        ["metaColumnsSQL"]=>
        string(20) "SHOW COLUMNS FROM %s"
        ["fmtTimeStamp"]=>
        string(13) "'Y-m-d H:i:s'"
        ["hasLimit"]=>
        bool(true)
        ["hasMoveFirst"]=>
        bool(true)
        ["hasGenID"]=>
        bool(true)
        ["isoDates"]=>
        bool(true)
        ["sysDate"]=>
        string(9) "CURDATE()"
        ["sysTimeStamp"]=>
        string(5) "NOW()"
        ["hasTransactions"]=>
        bool(false)
        ["forceNewConnect"]=>
        bool(false)
        ["poorAffectedRows"]=>
        bool(true)
        ["clientFlags"]=>
        int(0)
        ["substr"]=>
        string(9) "substring"
        ["nameQuote"]=>
        string(1) "`"
        ["_genIDSQL"]=>
        string(38) "update %s set id=LAST_INSERT_ID(id+1);"
        ["_genSeqSQL"]=>
        string(33) "create table %s (id int not null)"
        ["_genSeq2SQL"]=>
        string(26) "insert into %s values (%s)"
        ["_dropSeqSQL"]=>
        string(13) "drop table %s"
        ["database"]=>
        string(16) "asaross_www_prod"
        ["host"]=>
        string(9) "localhost"
        ["user"]=>
        string(12) "asaross_root"
        ["password"]=>
        string(11) "Quandamooka"
        ["debug"]=>
        bool(false)
        ["maxblobsize"]=>
        int(262144)
        ["concat_operator"]=>
        string(1) "+"
        ["length"]=>
        string(6) "length"
        ["random"]=>
        string(6) "rand()"
        ["upperCase"]=>
        string(5) "upper"
        ["fmtDate"]=>
        string(7) "'Y-m-d'"
        ["true"]=>
        string(1) "1"
        ["false"]=>
        string(1) "0"
        ["replaceQuote"]=>
        string(2) "\'"
        ["charSet"]=>
        bool(false)
        ["metaDatabasesSQL"]=>
        string(0) ""
        ["uniqueOrderBy"]=>
        bool(false)
        ["emptyDate"]=>
        string(6) " "
        ["emptyTimeStamp"]=>
        string(6) " "
        ["lastInsID"]=>
        bool(false)
        ["hasTop"]=>
        bool(false)
        ["readOnly"]=>
        bool(false)
        ["genID"]=>
        int(0)
        ["raiseErrorFn"]=>
        bool(false)
        ["cacheSecs"]=>
        int(3600)
        ["arrayClass"]=>
        string(18) "ADORecordSet_array"
        ["noNullStrings"]=>
        bool(false)
        ["numCacheHits"]=>
        int(0)
        ["numCacheMisses"]=>
        int(0)
        ["pageExecuteCountRows"]=>
        bool(true)
        ["uniqueSort"]=>
        bool(false)
        ["leftOuter"]=>
        bool(false)
        ["rightOuter"]=>
        bool(false)
        ["ansiOuter"]=>
        bool(false)
        ["autoRollback"]=>
        bool(false)
        ["fnExecute"]=>
        bool(false)
        ["fnCacheExecute"]=>
        bool(false)
        ["blobEncodeType"]=>
        bool(false)
        ["rsPrefix"]=>
        string(13) "ADORecordSet_"
        ["autoCommit"]=>
        bool(true)
        ["transOff"]=>
        int(0)
        ["transCnt"]=>
        int(0)
        ["fetchMode"]=>
        bool(false)
        ["_oldRaiseFn"]=>
        bool(false)
        ["_transOK"]=>
        NULL
        ["_connectionID"]=>
        resource(13) of type (mysql link)
        ["_errorMsg"]=>
        string(146) "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"
        ["_errorCode"]=>
        bool(false)
        ["_queryID"]=>
        resource(122) of type (mysql result)
        ["_isPersistentConnection"]=>
        bool(false)
        ["_bindInputArray"]=>
        bool(false)
        ["_evalAll"]=>
        bool(false)
        ["_affected"]=>
        bool(false)
        ["_logsql"]=>
        bool(false)
      }
      ["buffer"]=>
      NULL
      ["flag"]=>
      NULL
      ["parser"]=>
      NULL
      ["pre_handlers"]=>
      array(0) {
      }
      ["pos_handlers"]=>
      array(0) {
      }
      ["postedit_handlers"]=>
      array(0) {
      }
      ["usergroups_cache"]=>
      array(0) {
      }
      ["num_queries"]=>
      int(0)
      ["now"]=>
      NULL
      ["_sql"]=>
      NULL
      ["havegd"]=>
      bool(true)
      ["gdinfo"]=>
      array(13) {
        ["GD Version"]=>
        string(26) "bundled (2.1.0 compatible)"
        ["FreeType Support"]=>
        bool(true)
        ["FreeType Linkage"]=>
        string(13) "with freetype"
        ["T1Lib Support"]=>
        bool(true)
        ["GIF Read Support"]=>
        bool(true)
        ["GIF Create Support"]=>
        bool(true)
        ["JPEG Support"]=>
        bool(true)
        ["PNG Support"]=>
        bool(true)
        ["WBMP Support"]=>
        bool(true)
        ["XPM Support"]=>
        bool(true)
        ["XBM Support"]=>
        bool(true)
        ["WebP Support"]=>
        bool(true)
        ["JIS-mapped Japanese Font Support"]=>
        bool(false)
      }
      ["gdversion"]=>
      string(3) "2.1"
      ["haveimagick"]=>
      bool(false)
      ["uselib"]=>
      string(2) "gd"
      ["canrotate"]=>
      bool(false)
    }
    ["type"]=>
    string(2) "->"
    ["args"]=>
    array(1) {
      [0]=>
      &string(49) "update tiki_images set hits=hits+1 where imageId="
    }
  }
  [2]=>
  array(7) {
    ["file"]=>
    string(48) "/home1/asaross/public_html/tiki-browse_image.php"
    ["line"]=>
    int(198)
    ["function"]=>
    string(13) "add_image_hit"
    ["class"]=>
    string(12) "ImageGalsLib"
    ["object"]=>
    object(ImageGalsLib)#12 (17) {
      ["db"]=>
      object(ADODB_mysql)#2 (77) {
        ["databaseType"]=>
        string(5) "mysql"
        ["dataProvider"]=>
        string(5) "mysql"
        ["hasInsertID"]=>
        bool(true)
        ["hasAffectedRows"]=>
        bool(true)
        ["metaTablesSQL"]=>
        string(11) "SHOW TABLES"
        ["metaColumnsSQL"]=>
        string(20) "SHOW COLUMNS FROM %s"
        ["fmtTimeStamp"]=>
        string(13) "'Y-m-d H:i:s'"
        ["hasLimit"]=>
        bool(true)
        ["hasMoveFirst"]=>
        bool(true)
        ["hasGenID"]=>
        bool(true)
        ["isoDates"]=>
        bool(true)
        ["sysDate"]=>
        string(9) "CURDATE()"
        ["sysTimeStamp"]=>
        string(5) "NOW()"
        ["hasTransactions"]=>
        bool(false)
        ["forceNewConnect"]=>
        bool(false)
        ["poorAffectedRows"]=>
        bool(true)
        ["clientFlags"]=>
        int(0)
        ["substr"]=>
        string(9) "substring"
        ["nameQuote"]=>
        string(1) "`"
        ["_genIDSQL"]=>
        string(38) "update %s set id=LAST_INSERT_ID(id+1);"
        ["_genSeqSQL"]=>
        string(33) "create table %s (id int not null)"
        ["_genSeq2SQL"]=>
        string(26) "insert into %s values (%s)"
        ["_dropSeqSQL"]=>
        string(13) "drop table %s"
        ["database"]=>
        string(16) "asaross_www_prod"
        ["host"]=>
        string(9) "localhost"
        ["user"]=>
        string(12) "asaross_root"
        ["password"]=>
        string(11) "Quandamooka"
        ["debug"]=>
        bool(false)
        ["maxblobsize"]=>
        int(262144)
        ["concat_operator"]=>
        string(1) "+"
        ["length"]=>
        string(6) "length"
        ["random"]=>
        string(6) "rand()"
        ["upperCase"]=>
        string(5) "upper"
        ["fmtDate"]=>
        string(7) "'Y-m-d'"
        ["true"]=>
        string(1) "1"
        ["false"]=>
        string(1) "0"
        ["replaceQuote"]=>
        string(2) "\'"
        ["charSet"]=>
        bool(false)
        ["metaDatabasesSQL"]=>
        string(0) ""
        ["uniqueOrderBy"]=>
        bool(false)
        ["emptyDate"]=>
        string(6) " "
        ["emptyTimeStamp"]=>
        string(6) " "
        ["lastInsID"]=>
        bool(false)
        ["hasTop"]=>
        bool(false)
        ["readOnly"]=>
        bool(false)
        ["genID"]=>
        int(0)
        ["raiseErrorFn"]=>
        bool(false)
        ["cacheSecs"]=>
        int(3600)
        ["arrayClass"]=>
        string(18) "ADORecordSet_array"
        ["noNullStrings"]=>
        bool(false)
        ["numCacheHits"]=>
        int(0)
        ["numCacheMisses"]=>
        int(0)
        ["pageExecuteCountRows"]=>
        bool(true)
        ["uniqueSort"]=>
        bool(false)
        ["leftOuter"]=>
        bool(false)
        ["rightOuter"]=>
        bool(false)
        ["ansiOuter"]=>
        bool(false)
        ["autoRollback"]=>
        bool(false)
        ["fnExecute"]=>
        bool(false)
        ["fnCacheExecute"]=>
        bool(false)
        ["blobEncodeType"]=>
        bool(false)
        ["rsPrefix"]=>
        string(13) "ADORecordSet_"
        ["autoCommit"]=>
        bool(true)
        ["transOff"]=>
        int(0)
        ["transCnt"]=>
        int(0)
        ["fetchMode"]=>
        bool(false)
        ["_oldRaiseFn"]=>
        bool(false)
        ["_transOK"]=>
        NULL
        ["_connectionID"]=>
        resource(13) of type (mysql link)
        ["_errorMsg"]=>
        string(146) "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"
        ["_errorCode"]=>
        bool(false)
        ["_queryID"]=>
        resource(122) of type (mysql result)
        ["_isPersistentConnection"]=>
        bool(false)
        ["_bindInputArray"]=>
        bool(false)
        ["_evalAll"]=>
        bool(false)
        ["_affected"]=>
        bool(false)
        ["_logsql"]=>
        bool(false)
      }
      ["buffer"]=>
      NULL
      ["flag"]=>
      NULL
      ["parser"]=>
      NULL
      ["pre_handlers"]=>
      array(0) {
      }
      ["pos_handlers"]=>
      array(0) {
      }
      ["postedit_handlers"]=>
      array(0) {
      }
      ["usergroups_cache"]=>
      array(0) {
      }
      ["num_queries"]=>
      int(0)
      ["now"]=>
      NULL
      ["_sql"]=>
      NULL
      ["havegd"]=>
      bool(true)
      ["gdinfo"]=>
      array(13) {
        ["GD Version"]=>
        string(26) "bundled (2.1.0 compatible)"
        ["FreeType Support"]=>
        bool(true)
        ["FreeType Linkage"]=>
        string(13) "with freetype"
        ["T1Lib Support"]=>
        bool(true)
        ["GIF Read Support"]=>
        bool(true)
        ["GIF Create Support"]=>
        bool(true)
        ["JPEG Support"]=>
        bool(true)
        ["PNG Support"]=>
        bool(true)
        ["WBMP Support"]=>
        bool(true)
        ["XPM Support"]=>
        bool(true)
        ["XBM Support"]=>
        bool(true)
        ["WebP Support"]=>
        bool(true)
        ["JIS-mapped Japanese Font Support"]=>
        bool(false)
      }
      ["gdversion"]=>
      string(3) "2.1"
      ["haveimagick"]=>
      bool(false)
      ["uselib"]=>
      string(2) "gd"
      ["canrotate"]=>
      bool(false)
    }
    ["type"]=>
    string(2) "->"
    ["args"]=>
    array(1) {
      [0]=>
      &NULL
    }
  }
}