This is Tiki v1.8.6 -Polaris- (c)2002-2005 by the Tiki community. Tue 29 of Dec, 2009 [10:31 UTC]
Menu
Login
 
standard | secure
Online users

Error

An error occured in a database query!

Context:
File/devwiki/tiki-file_galleries.php
Url/devwiki/tiki-file_galleries.php?offset=0&sort_mode=files_desc
Query:
select * from `tiki_file_galleries` order by `files` desc
Values:


Go back

Return to home page 
array(3) {
  [0]=>
  array(7) {
    ["file"]=>
    string(55) "/home/groups/a/am/amsn/htdocs/devwiki/lib/tikidblib.php"
    ["line"]=>
    int(84)
    ["function"]=>
    string(9) "sql_error"
    ["class"]=>
    string(6) "TikiDB"
    ["object"]=>
    object(FileGalLib)#19 (8) {
      ["db"]=>
      object(ADODB_mysql)#2 (78) {
        ["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(11) "a54091_tiki"
        ["host"]=>
        string(7) "mysql-a"
        ["user"]=>
        string(8) "a54091rw"
        ["password"]=>
        string(10) "granBoboRW"
        ["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(17) of type (mysql link)
        ["_errorMsg"]=>
        string(40) "Unknown column 'files' in 'order clause'"
        ["_errorCode"]=>
        bool(false)
        ["_queryID"]=>
        resource(104) of type (mysql result)
        ["_isPersistentConnection"]=>
        bool(false)
        ["_bindInputArray"]=>
        bool(false)
        ["_evalAll"]=>
        bool(false)
        ["_affected"]=>
        bool(false)
        ["_logsql"]=>
        bool(false)
        ["databaseName"]=>
        string(11) "a54091_tiki"
      }
      ["buffer"]=>
      NULL
      ["flag"]=>
      NULL
      ["parser"]=>
      NULL
      ["pre_handlers"]=>
      array(0) {
      }
      ["pos_handlers"]=>
      array(0) {
      }
      ["usergroups_cache"]=>
      array(0) {
      }
      ["num_queries"]=>
      int(0)
    }
    ["type"]=>
    string(2) "->"
    ["args"]=>
    array(3) {
      [0]=>
      &string(58) "select * from `tiki_file_galleries`  order by `files` desc"
      [1]=>
      &array(0) {
      }
      [2]=>
      &bool(false)
    }
  }
  [1]=>
  array(7) {
    ["file"]=>
    string(65) "/home/groups/a/am/amsn/htdocs/devwiki/lib/filegals/filegallib.php"
    ["line"]=>
    int(107)
    ["function"]=>
    string(5) "query"
    ["class"]=>
    string(6) "TikiDB"
    ["object"]=>
    object(FileGalLib)#19 (8) {
      ["db"]=>
      object(ADODB_mysql)#2 (78) {
        ["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(11) "a54091_tiki"
        ["host"]=>
        string(7) "mysql-a"
        ["user"]=>
        string(8) "a54091rw"
        ["password"]=>
        string(10) "granBoboRW"
        ["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(17) of type (mysql link)
        ["_errorMsg"]=>
        string(40) "Unknown column 'files' in 'order clause'"
        ["_errorCode"]=>
        bool(false)
        ["_queryID"]=>
        resource(104) of type (mysql result)
        ["_isPersistentConnection"]=>
        bool(false)
        ["_bindInputArray"]=>
        bool(false)
        ["_evalAll"]=>
        bool(false)
        ["_affected"]=>
        bool(false)
        ["_logsql"]=>
        bool(false)
        ["databaseName"]=>
        string(11) "a54091_tiki"
      }
      ["buffer"]=>
      NULL
      ["flag"]=>
      NULL
      ["parser"]=>
      NULL
      ["pre_handlers"]=>
      array(0) {
      }
      ["pos_handlers"]=>
      array(0) {
      }
      ["usergroups_cache"]=>
      array(0) {
      }
      ["num_queries"]=>
      int(0)
    }
    ["type"]=>
    string(2) "->"
    ["args"]=>
    array(4) {
      [0]=>
      &string(58) "select * from `tiki_file_galleries`  order by `files` desc"
      [1]=>
      &array(0) {
      }
      [2]=>
      &string(2) "10"
      [3]=>
      &string(1) "0"
    }
  }
  [2]=>
  array(7) {
    ["file"]=>
    string(61) "/home/groups/a/am/amsn/htdocs/devwiki/tiki-file_galleries.php"
    ["line"]=>
    int(218)
    ["function"]=>
    string(19) "list_file_galleries"
    ["class"]=>
    string(10) "FileGalLib"
    ["object"]=>
    object(FileGalLib)#19 (8) {
      ["db"]=>
      object(ADODB_mysql)#2 (78) {
        ["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(11) "a54091_tiki"
        ["host"]=>
        string(7) "mysql-a"
        ["user"]=>
        string(8) "a54091rw"
        ["password"]=>
        string(10) "granBoboRW"
        ["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(17) of type (mysql link)
        ["_errorMsg"]=>
        string(40) "Unknown column 'files' in 'order clause'"
        ["_errorCode"]=>
        bool(false)
        ["_queryID"]=>
        resource(104) of type (mysql result)
        ["_isPersistentConnection"]=>
        bool(false)
        ["_bindInputArray"]=>
        bool(false)
        ["_evalAll"]=>
        bool(false)
        ["_affected"]=>
        bool(false)
        ["_logsql"]=>
        bool(false)
        ["databaseName"]=>
        string(11) "a54091_tiki"
      }
      ["buffer"]=>
      NULL
      ["flag"]=>
      NULL
      ["parser"]=>
      NULL
      ["pre_handlers"]=>
      array(0) {
      }
      ["pos_handlers"]=>
      array(0) {
      }
      ["usergroups_cache"]=>
      array(0) {
      }
      ["num_queries"]=>
      int(0)
    }
    ["type"]=>
    string(2) "->"
    ["args"]=>
    array(5) {
      [0]=>
      &string(1) "0"
      [1]=>
      &string(2) "10"
      [2]=>
      &string(10) "files_desc"
      [3]=>
      &string(5) "admin"
      [4]=>
      &string(0) ""
    }
  }
}