molenwiek

Error

An error occured in a database query!

Context:
File	/tiki-view_articles.php
Url	/tiki-view_articles.php
Query:
select `tiki_articles`.*, `users_users`.`avatarLibName`, `tiki_article_types`.`use_ratings`, `tiki_article_types`.`show_pre_publ`, `tiki_article_types`.`show_post_expire`, `tiki_article_types`.`heading_only`, `tiki_article_types`.`allow_comments`, `tiki_article_types`.`show_image`, `tiki_article_types`.`show_avatar`, `tiki_article_types`.`show_author`, `tiki_article_types`.`show_pubdate`, `tiki_article_types`.`show_expdate`, `tiki_article_types`.`show_reads`, `tiki_article_types`.`show_size`, `tiki_article_types`.`show_topline`, `tiki_article_types`.`show_subtitle`, `tiki_article_types`.`show_linkto`, `tiki_article_types`.`show_image_caption`, `tiki_article_types`.`show_lang`, `tiki_article_types`.`creator_edit` from `tiki_articles`, `tiki_article_types` left join `users_users` on `tiki_articles`.`author` = `users_users`.`login` where `tiki_articles`.`type` = `tiki_article_types`.`type` and (`tiki_articles`.`publishDate`? or `tiki_article_types`.`show_post_expire`='y') order by `publishDate` desc
Values:
0	1280639665
1	1280639665
Message:
Error Message	Unknown column 'tiki_articles.author' in 'on clause'

Go back

Return to home page

array(3) { [0]=> array(7) { ["file"]=> string(54) "/domains/molenwiek.nl/tikiwiki-1.9.0/lib/tikidblib.php" ["line"]=> int(84) ["function"]=> string(9) "sql_error" ["class"]=> string(6) "TikiDB" ["object"]=> object(TikiLib)#6 (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(6) "molenw" ["host"]=> string(19) "mysql1.greenhost.nl" ["user"]=> string(6) "molenw" ["password"]=> string(12) "7hqd4cycagjt" ["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(52) "Unknown column 'tiki_articles.author' in 'on clause'" ["_errorCode"]=> bool(false) ["_queryID"]=> bool(false) ["_isPersistentConnection"]=> bool(false) ["_bindInputArray"]=> bool(false) ["_evalAll"]=> bool(false) ["_affected"]=> bool(false) ["_logsql"]=> bool(false) ["databaseName"]=> string(6) "molenw" } ["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"]=> string(10) "1280639665" } ["type"]=> string(2) "->" ["args"]=> array(3) { [0]=> &string(1119) "select `tiki_articles`.*, `users_users`.`avatarLibName`, `tiki_article_types`.`use_ratings`, `tiki_article_types`.`show_pre_publ`, `tiki_article_types`.`show_post_expire`, `tiki_article_types`.`heading_only`, `tiki_article_types`.`allow_comments`, `tiki_article_types`.`show_image`, `tiki_article_types`.`show_avatar`, `tiki_article_types`.`show_author`, `tiki_article_types`.`show_pubdate`, `tiki_article_types`.`show_expdate`, `tiki_article_types`.`show_reads`, `tiki_article_types`.`show_size`, `tiki_article_types`.`show_topline`, `tiki_article_types`.`show_subtitle`, `tiki_article_types`.`show_linkto`, `tiki_article_types`.`show_image_caption`, `tiki_article_types`.`show_lang`, `tiki_article_types`.`creator_edit` from `tiki_articles`, `tiki_article_types` left join `users_users` on `tiki_articles`.`author` = `users_users`.`login` where `tiki_articles`.`type` = `tiki_article_types`.`type` and (`tiki_articles`.`publishDate`? or `tiki_article_types`.`show_post_expire`='y') order by `publishDate` desc" [1]=> &array(2) { [0]=> int(1280639665) [1]=> int(1280639665) } [2]=> &bool(false) } } [1]=> array(7) { ["file"]=> string(52) "/domains/molenwiek.nl/tikiwiki-1.9.0/lib/tikilib.php" ["line"]=> int(2346) ["function"]=> string(5) "query" ["class"]=> string(6) "TikiDB" ["object"]=> object(TikiLib)#6 (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(6) "molenw" ["host"]=> string(19) "mysql1.greenhost.nl" ["user"]=> string(6) "molenw" ["password"]=> string(12) "7hqd4cycagjt" ["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(52) "Unknown column 'tiki_articles.author' in 'on clause'" ["_errorCode"]=> bool(false) ["_queryID"]=> bool(false) ["_isPersistentConnection"]=> bool(false) ["_bindInputArray"]=> bool(false) ["_evalAll"]=> bool(false) ["_affected"]=> bool(false) ["_logsql"]=> bool(false) ["databaseName"]=> string(6) "molenw" } ["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"]=> string(10) "1280639665" } ["type"]=> string(2) "->" ["args"]=> array(4) { [0]=> &string(1119) "select `tiki_articles`.*, `users_users`.`avatarLibName`, `tiki_article_types`.`use_ratings`, `tiki_article_types`.`show_pre_publ`, `tiki_article_types`.`show_post_expire`, `tiki_article_types`.`heading_only`, `tiki_article_types`.`allow_comments`, `tiki_article_types`.`show_image`, `tiki_article_types`.`show_avatar`, `tiki_article_types`.`show_author`, `tiki_article_types`.`show_pubdate`, `tiki_article_types`.`show_expdate`, `tiki_article_types`.`show_reads`, `tiki_article_types`.`show_size`, `tiki_article_types`.`show_topline`, `tiki_article_types`.`show_subtitle`, `tiki_article_types`.`show_linkto`, `tiki_article_types`.`show_image_caption`, `tiki_article_types`.`show_lang`, `tiki_article_types`.`creator_edit` from `tiki_articles`, `tiki_article_types` left join `users_users` on `tiki_articles`.`author` = `users_users`.`login` where `tiki_articles`.`type` = `tiki_article_types`.`type` and (`tiki_articles`.`publishDate`? or `tiki_article_types`.`show_post_expire`='y') order by `publishDate` desc" [1]=> &array(2) { [0]=> int(1280639665) [1]=> int(1280639665) } [2]=> &string(2) "10" [3]=> &int(0) } } [2]=> array(7) { ["file"]=> string(59) "/domains/molenwiek.nl/tikiwiki-1.9.0/tiki-view_articles.php" ["line"]=> int(117) ["function"]=> string(13) "list_articles" ["class"]=> string(7) "TikiLib" ["object"]=> object(TikiLib)#6 (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(6) "molenw" ["host"]=> string(19) "mysql1.greenhost.nl" ["user"]=> string(6) "molenw" ["password"]=> string(12) "7hqd4cycagjt" ["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(52) "Unknown column 'tiki_articles.author' in 'on clause'" ["_errorCode"]=> bool(false) ["_queryID"]=> bool(false) ["_isPersistentConnection"]=> bool(false) ["_bindInputArray"]=> bool(false) ["_evalAll"]=> bool(false) ["_affected"]=> bool(false) ["_logsql"]=> bool(false) ["databaseName"]=> string(6) "molenw" } ["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"]=> string(10) "1280639665" } ["type"]=> string(2) "->" ["args"]=> array(9) { [0]=> &int(0) [1]=> &string(2) "10" [2]=> &string(16) "publishDate_desc" [3]=> &string(0) "" [4]=> &string(10) "1280639665" [5]=> &NULL [6]=> &string(0) "" [7]=> &string(0) "" [8]=> &string(1) "y" } } }