ASP Developer Network - Brought to you by Steve Radich and BitShop, Inc. - http://www.bitshop.com

Menu [hide]

Error

An error occured in a database query!

Context:
File/tiki-file_galleries.php
Url/tiki-file_galleries.php?offset=0&sort_mode=files_desc
Query:
select * from `tiki_file_galleries` order by `files` desc
Values:
Message:
Error MessageUnknown column 'files' in 'order clause'


Go back

Return to home page
Search
in:
Our Sponsors
Virtual Server 2005 Info Here!
http://www.aspdeveloper.net
Need a Virtual Server 2005 Hosted Account? Why not trust ASPDeveloper's Team? We're a division of www.bitshop.com
Quality Business Internet Technology Shop - http://www.bitshop.com Sponsor of site and hosting
Quality Business Internet Technology Shop - http://www.bitshop.com Sponsor of site and hosting
Quality Business Internet Technology Shop - http://www.bitshop.com Sponsor of site and hosting
rss Wiki rss Blogs rss Articles rss Image galleries rss File galleries rss Forums rss Maps rss Directories
ASP Developer Network (since 1996) - Brought to you by Steve Radich and BitShop, Inc. - http://www.bitshop.com
Copyright © 1997-2005 by BitShop, Inc. All Rights Reserved.
No content may be reproduced in any form without written permission from BitShop, Inc.
We will be honored to assist with reproduction rights on our material if you contact us.
We also can provide print articles for your magazine, private training seminars at your site, and conference presentations.

Thank you for visiting. Please bookmark our site if you found it useful!
If you wish to make a donation it will help further the development of these free resources:
array(3) {
  [0]=>
  array(7) {
    ["file"]=>
    string(69) "Z:\Internet\WWWRoot\63.218.155.171-ASPDeveloper.net\lib\tikidblib.php"
    ["line"]=>
    int(84)
    ["function"]=>
    string(9) "sql_error"
    ["class"]=>
    string(6) "TikiDB"
    ["object"]=>
    object(FileGalLib)#22 (10) {
      ["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(16) "tikiaspdeveloper"
        ["host"]=>
        string(9) "localhost"
        ["user"]=>
        string(4) "root"
        ["password"]=>
        string(8) "isKRxjf7"
        ["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(40) "Unknown column 'files' in 'order clause'"
        ["_errorCode"]=>
        bool(false)
        ["_queryID"]=>
        bool(false)
        ["_isPersistentConnection"]=>
        bool(false)
        ["_bindInputArray"]=>
        bool(false)
        ["_evalAll"]=>
        bool(false)
        ["_affected"]=>
        bool(false)
        ["_logsql"]=>
        bool(false)
        ["databaseName"]=>
        string(16) "tikiaspdeveloper"
      }
      ["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
    }
    ["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(79) "Z:\Internet\WWWRoot\63.218.155.171-ASPDeveloper.net\lib\filegals\filegallib.php"
    ["line"]=>
    int(133)
    ["function"]=>
    string(5) "query"
    ["class"]=>
    string(6) "TikiDB"
    ["object"]=>
    object(FileGalLib)#22 (10) {
      ["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(16) "tikiaspdeveloper"
        ["host"]=>
        string(9) "localhost"
        ["user"]=>
        string(4) "root"
        ["password"]=>
        string(8) "isKRxjf7"
        ["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(40) "Unknown column 'files' in 'order clause'"
        ["_errorCode"]=>
        bool(false)
        ["_queryID"]=>
        bool(false)
        ["_isPersistentConnection"]=>
        bool(false)
        ["_bindInputArray"]=>
        bool(false)
        ["_evalAll"]=>
        bool(false)
        ["_affected"]=>
        bool(false)
        ["_logsql"]=>
        bool(false)
        ["databaseName"]=>
        string(16) "tikiaspdeveloper"
      }
      ["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
    }
    ["type"]=>
    string(2) "->"
    ["args"]=>
    array(4) {
      [0]=>
      &string(58) "select * from `tiki_file_galleries`  order by `files` desc"
      [1]=>
      &array(0) {
      }
      [2]=>
      &string(2) "50"
      [3]=>
      &string(1) "0"
    }
  }
  [2]=>
  array(7) {
    ["file"]=>
    string(75) "Z:\Internet\WWWRoot\63.218.155.171-ASPDeveloper.net\tiki-file_galleries.php"
    ["line"]=>
    int(217)
    ["function"]=>
    string(19) "list_file_galleries"
    ["class"]=>
    string(10) "FileGalLib"
    ["object"]=>
    object(FileGalLib)#22 (10) {
      ["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(16) "tikiaspdeveloper"
        ["host"]=>
        string(9) "localhost"
        ["user"]=>
        string(4) "root"
        ["password"]=>
        string(8) "isKRxjf7"
        ["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(40) "Unknown column 'files' in 'order clause'"
        ["_errorCode"]=>
        bool(false)
        ["_queryID"]=>
        bool(false)
        ["_isPersistentConnection"]=>
        bool(false)
        ["_bindInputArray"]=>
        bool(false)
        ["_evalAll"]=>
        bool(false)
        ["_affected"]=>
        bool(false)
        ["_logsql"]=>
        bool(false)
        ["databaseName"]=>
        string(16) "tikiaspdeveloper"
      }
      ["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
    }
    ["type"]=>
    string(2) "->"
    ["args"]=>
    array(5) {
      [0]=>
      &string(1) "0"
      [1]=>
      &string(2) "50"
      [2]=>
      &string(10) "files_desc"
      [3]=>
      &string(5) "admin"
      [4]=>
      &string(0) ""
    }
  }
}