php error happened
Technical information | |
Error type | 256 |
Error description | Unknown column 'files' in 'field list' |
URL | asprunner.com/forums/forumreplies_list.php?mastertable=forumtopics&masterkey1=20907&orderby=acreated&scheme=blue_light |
Error file | C:\inetpub\wwwroot\asprunner.com\public_html\forums\connections\Connection.php |
Error line | 668 |
SQL query | SELECT `topic`, `topic` as `topic2`, `startedby`, `startedby` as `startedby2`, `id`, `categoryid`, `views`, `activity`, `pinned`, "" as `color`, `question`, `created`, `solved`, "" as `image`, `migrate_alias`, `locked`, "" as `ai`, `files`, (select COUNT(*) FROM forumreplies AS r WHERE r.topicid = forumtopics.id) as `forumreplies` FROM `forumtopics` WHERE ( ( ( forumtopics.id=20907 ) ) ) and ( 1=1 ) order by pinned desc, activity desc limit 0, 1 |
Call stack | |||
File: line | Function | Arguments | |
#0 | connections\Connection.php:668 | Connection->triggerError | 0. Unknown column 'files' in 'field list' |
#1 | connections\MySQLiConnection.php:168 | MySQLiConnection->query | 0. SELECT `topic`, `topic` as `topic2`, `startedby`, `startedby` as `startedby2`, `id`, `categoryid`, `views`, `activity`, `pinned`, "" as `color`, `question`, `created`, `solved`, "" as `image`, `migrate_alias`, `locked`, "" as `ai`, `files`, (select COUNT(*) FROM forumreplies AS r WHERE r.topicid = forumtopics.id) as `forumreplies` FROM `forumtopics` WHERE ( ( ( forumtopics.id=20907 ) ) ) and ( 1=1 ) order by pinned desc, activity desc limit 0, 1 |
#2 | connections\dbfunctions\MySQLFunctions.php:130 | MySQLFunctions->limitedQuery | 0. MySQLiConnection 1. SELECT `topic`, `topic` as `topic2`, `startedby`, `startedby` as `startedby2`, `id`, `categoryid`, `views`, `activity`, `pinned`, "" as `color`, `question`, `created`, `solved`, "" as `image`, `migrate_alias`, `locked`, "" as `ai`, `files`, (select COUNT(*) FROM forumreplies AS r WHERE r.topicid = forumtopics.id) as `forumreplies` FROM `forumtopics` WHERE ( ( ( forumtopics.id=20907 ) ) ) and ( 1=1 ) order by pinned desc, activity desc limit 0, 1 2. 0 3. 1 4. 1 |
#3 | connections\Connection.php:608 | Connection->limitedQuery | 0. SELECT
`topic`, `topic` as `topic2`, `startedby`, `startedby` as `startedby2`, `id`, `categoryid`, `views`, `activity`, `pinned`, "" as `color`, `question`, `created`, `solved`, "" as `image`, `migrate_alias`, `locked`, "" as `ai`, `files`, (select COUNT(*) FROM forumreplies AS r WHERE r.topicid = forumtopics.id) as `forumreplies`
FROM `forumtopics` WHERE ( ( ( forumtopics.id=20907 ) ) ) and ( 1=1 ) order by pinned desc, activity desc 1. 0 2. 1 3. 1 |
#4 | classes\datasource\table.php:632 | DataSourceTable->getListImpl | 0. DsCommand |
#5 | classes\datasource\datasource.php:44 | DataSource->getList | 0. DsCommand |
#6 | classes\runnerpage.php:2491 | RunnerPage->getMasterRecord | N/A |
#7 | classes\runnerpage.php:2179 | RunnerPage->processMasterKeyValue | N/A |
#8 | classes\listpage.php:526 | ListPage->processMasterKeyValue | N/A |
#9 | classes\runnerpage.php:1267 | RunnerPage->__construct | 0. Array ( [pageName] => list [pageType] => list [id] => 1 [flyId] => 2 [mode] => 0 [xt] => XTempl Object [firstTime] => [sortBy] => [requestGoto] => 0 [masterPageType] => [masterPage] => [masterId] => [masterTable] => forumtopics [masterKeysReq] => Array [dashElementName] => [dashTName] => [dashPage] => [tName] => forumreplies [origTName] => forumreplies [gPageSize] => 1000 [nSecOptions] => 2 [recsPerRowList] => 1 [mainTableOwnerID] => userid [exportTo] => [printFriendly] => [deleteRecs] => 1 [arrKeyFields] => Array [panelSearchFields] => Array [listGridLayout] => 1 [createLoginPage] => 1 [noRecordsFirstPage] => [totalsFields] => Array [listAjax] => 1 [arrRecsPerPage] => Array [isScrollGridBody] => [viewPDF] => [audit] => ) |
#10 | classes\listpage.php:210 | ListPage->__construct | 0. Array ( [pageName] => list [pageType] => list [id] => 1 [flyId] => 2 [mode] => 0 [xt] => XTempl Object [firstTime] => [sortBy] => [requestGoto] => 0 [masterPageType] => [masterPage] => [masterId] => [masterTable] => forumtopics [masterKeysReq] => Array [dashElementName] => [dashTName] => [dashPage] => [tName] => forumreplies [origTName] => forumreplies [gPageSize] => 1000 [nSecOptions] => 2 [recsPerRowList] => 1 [mainTableOwnerID] => userid [exportTo] => [printFriendly] => [deleteRecs] => 1 [arrKeyFields] => Array [panelSearchFields] => Array [listGridLayout] => 1 [createLoginPage] => 1 [noRecordsFirstPage] => [totalsFields] => Array [listAjax] => 1 [arrRecsPerPage] => Array [isScrollGridBody] => [viewPDF] => [audit] => ) |
#11 | classes\listpage_simple.php:15 | ListPage_Simple->__construct | 0. Array ( [pageName] => list [pageType] => list [id] => 1 [flyId] => 2 [mode] => 0 [xt] => XTempl Object [firstTime] => [sortBy] => [requestGoto] => 0 [masterPageType] => [masterPage] => [masterId] => [masterTable] => forumtopics [masterKeysReq] => Array [dashElementName] => [dashTName] => [dashPage] => [tName] => forumreplies [origTName] => forumreplies [gPageSize] => 1000 [nSecOptions] => 2 [recsPerRowList] => 1 [mainTableOwnerID] => userid [exportTo] => [printFriendly] => [deleteRecs] => 1 [arrKeyFields] => Array [panelSearchFields] => Array [listGridLayout] => 1 [createLoginPage] => 1 [noRecordsFirstPage] => [totalsFields] => Array [listAjax] => 1 [arrRecsPerPage] => Array [isScrollGridBody] => [viewPDF] => [audit] => ) |
#12 | classes\listpage.php:2468 | ListPage::createListPage | 0. forumreplies 1. Array ( [pageName] => [pageType] => list [id] => 1 [flyId] => 0 [mode] => 0 [xt] => XTempl Object [firstTime] => [sortBy] => [requestGoto] => 0 [masterPageType] => [masterPage] => [masterId] => [masterTable] => forumtopics [masterKeysReq] => Array [dashElementName] => [dashTName] => [dashPage] => ) |
#13 | forumreplies_list.php:135 | Global scope | N/A |