Error
An error occured in a database query!

Context:
File/tiki-read_article.php
Url/tiki-read_article.php?articleId=14closing
Query:
update `tiki_articles` set `reads`=`reads`+1 where articleId=14closing
Values:
Message:
Error MessageUnknown column '14closing' in 'where clause'


Go back

Return to home page
Feedback
 
array(3) {
  [0]=>
  array(7) {
    ["file"]=>
    string(58) "/hsphere/local/home/austms/anziam.org.au/lib/tikidblib.php"
    ["line"]=>
    int(115)
    ["function"]=>
    string(9) "sql_error"
    ["class"]=>
    string(6) "TikiDB"
    ["object"]=>
    object(ArtLib)#12 (11) {
      ["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(23) "austms_anziam_ikit_prod"
        ["host"]=>
        string(27) "mysql7.quadrahosting.com.au"
        ["user"]=>
        string(11) "austms_ikit"
        ["password"]=>
        string(12) "ava8adr02016"
        ["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"]=>
        string(16) "ADODB_Error_PEAR"
        ["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(16) of type (mysql link)
        ["_errorMsg"]=>
        string(44) "Unknown column '14closing' in 'where clause'"
        ["_errorCode"]=>
        bool(false)
        ["_queryID"]=>
        resource(184) 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
    }
    ["type"]=>
    string(2) "->"
    ["args"]=>
    array(3) {
      [0]=>
      &string(70) "update `tiki_articles` set `reads`=`reads`+1 where articleId=14closing"
      [1]=>
      &NULL
      [2]=>
      &bool(false)
    }
  }
  [1]=>
  array(7) {
    ["file"]=>
    string(64) "/hsphere/local/home/austms/anziam.org.au/lib/articles/artlib.php"
    ["line"]=>
    int(87)
    ["function"]=>
    string(5) "query"
    ["class"]=>
    string(6) "TikiDB"
    ["object"]=>
    object(ArtLib)#12 (11) {
      ["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(23) "austms_anziam_ikit_prod"
        ["host"]=>
        string(27) "mysql7.quadrahosting.com.au"
        ["user"]=>
        string(11) "austms_ikit"
        ["password"]=>
        string(12) "ava8adr02016"
        ["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"]=>
        string(16) "ADODB_Error_PEAR"
        ["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(16) of type (mysql link)
        ["_errorMsg"]=>
        string(44) "Unknown column '14closing' in 'where clause'"
        ["_errorCode"]=>
        bool(false)
        ["_queryID"]=>
        resource(184) 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
    }
    ["type"]=>
    string(2) "->"
    ["args"]=>
    array(1) {
      [0]=>
      &string(70) "update `tiki_articles` set `reads`=`reads`+1 where articleId=14closing"
    }
  }
  [2]=>
  array(7) {
    ["file"]=>
    string(62) "/hsphere/local/home/austms/anziam.org.au/tiki-read_article.php"
    ["line"]=>
    int(27)
    ["function"]=>
    string(15) "add_article_hit"
    ["class"]=>
    string(6) "ArtLib"
    ["object"]=>
    object(ArtLib)#12 (11) {
      ["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(23) "austms_anziam_ikit_prod"
        ["host"]=>
        string(27) "mysql7.quadrahosting.com.au"
        ["user"]=>
        string(11) "austms_ikit"
        ["password"]=>
        string(12) "ava8adr02016"
        ["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"]=>
        string(16) "ADODB_Error_PEAR"
        ["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(16) of type (mysql link)
        ["_errorMsg"]=>
        string(44) "Unknown column '14closing' in 'where clause'"
        ["_errorCode"]=>
        bool(false)
        ["_queryID"]=>
        resource(184) 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
    }
    ["type"]=>
    string(2) "->"
    ["args"]=>
    array(1) {
      [0]=>
      &string(9) "14closing"
    }
  }
}