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

ASPDeveloper

Error

An error occured in a database query!

Context:
File	/tiki-print_article.php
Url	/tiki-print_article.php
Query:
update `tiki_articles` set `reads`=`reads`+1 where `articleId`=?
Values:
0	3
Message:
Error Message	Unknown column 'reads' in 'field list'

Go back

Return to home page

Our Sponsors

ASP.Net 2.0 Developers Available - The exact same people that write here on this site:
http://www.bitshop.com
ASPDeveloper.Net is part of BitShop

FREE .Net 2.0 Tutorials Available Now
http://www.aspdeveloper.net

ASP.Net 2.0 Developers Available - The exact same people that write here on this site:
http://www.bitshop.com
ASPDeveloper.Net is part of BitShop

Want to contribute to aspdeveloper.net? Contact us! suggest@aspdeveloper.net

Read the blogs, request we set up one for you FREE
http://www.aspdeveloper.net

Wiki

Blogs

Articles

Image galleries

File galleries

Forums

Maps

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(ArtLib)#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) "dell25501" ["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(38) "Unknown column 'reads' in 'field list'" ["_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(64) "update `tiki_articles` set `reads`=`reads`+1 where `articleId`=?" [1]=> &array(1) { [0]=> string(1) "3" } [2]=> &bool(false) } } [1]=> array(7) { ["file"]=> string(75) "Z:\Internet\WWWRoot\63.218.155.171-ASPDeveloper.net\lib\articles\artlib.php" ["line"]=> int(63) ["function"]=> string(5) "query" ["class"]=> string(6) "TikiDB" ["object"]=> object(ArtLib)#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) "dell25501" ["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(38) "Unknown column 'reads' in 'field list'" ["_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(2) { [0]=> &string(64) "update `tiki_articles` set `reads`=`reads`+1 where `articleId`=?" [1]=> &array(1) { [0]=> string(1) "3" } } } [2]=> array(7) { ["file"]=> string(74) "Z:\Internet\WWWRoot\63.218.155.171-ASPDeveloper.net\tiki-print_article.php" ["line"]=> int(22) ["function"]=> string(15) "add_article_hit" ["class"]=> string(6) "ArtLib" ["object"]=> object(ArtLib)#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) "dell25501" ["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(38) "Unknown column 'reads' in 'field list'" ["_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(1) { [0]=> &string(1) "3" } } }