|
| Technical information |
| Error type | 256 |
| Error description | Unknown column 'Forenames' in 'field list' |
| URL | statbooks.co.uk/Companies/disqualified_officers_list.php? |
| Error file | /home/statbook/public_html/Companies/connections/Connection.php |
| Error line | 668 |
| SQL query | select count(*) from (SELECT
`ID`, `Comp_Num`, `RT`, `AO`, `RO`, `C`, `CI`, `OAT`, `NAT`, `NPN`, `PN`, `Unique_PN`, `PBY`, `PBM`, `PBD`, `FBY`, `FBM`, `FBD`, `Old_PCode`, `New_Pcode`, `PCA`, `PCD`, `OS_PCode`, `PCS`, `Appoint`, `Resign`, `Changed`, `Updated`, `VDL`, `Address_Data`, `Title`, `Forenames`, `Surname`, `Honours`, `Care_of`, `PO Box`, `Sub_Property`, `Property`, `Dep_Road`, `Address1`, `Sub_Locality`, `Address2`, `Post_Town`, `County`, `Country`, `AQ`, `Occupation`, `Nationality`, `Residency`, `Source`
FROM `Officers` WHERE ( ( ( ( ID is null ) or ( ID > 0 ) or ( ID=0 ) or ( ID < 0 ) ) ) ) and ( Source ='DIS' ) ) a |
| #0 |
connections/Connection.php:668 |
Connection->triggerError |
0. Unknown column 'Forenames' in 'field list' |
| #1 |
connections/MySQLiConnection.php:168 |
MySQLiConnection->query |
0. select count(*) from (SELECT
`ID`, `Comp_Num`, `RT`, `AO`, `RO`, `C`, `CI`, `OAT`, `NAT`, `NPN`, `PN`, `Unique_PN`, `PBY`, `PBM`, `PBD`, `FBY`, `FBM`, `FBD`, `Old_PCode`, `New_Pcode`, `PCA`, `PCD`, `OS_PCode`, `PCS`, `Appoint`, `Resign`, `Changed`, `Updated`, `VDL`, `Address_Data`, `Title`, `Forenames`, `Surname`, `Honours`, `Care_of`, `PO Box`, `Sub_Property`, `Property`, `Dep_Road`, `Address1`, `Sub_Locality`, `Address2`, `Post_Town`, `County`, `Country`, `AQ`, `Occupation`, `Nationality`, `Residency`, `Source`
FROM `Officers` WHERE ( ( ( ( ID is null ) or ( ID > 0 ) or ( ID=0 ) or ( ID < 0 ) ) ) ) and ( Source ='DIS' ) ) a |
| #2 |
connections/Connection.php:635 |
Connection->getFetchedRowsNumber |
0. SELECT
`ID`, `Comp_Num`, `RT`, `AO`, `RO`, `C`, `CI`, `OAT`, `NAT`, `NPN`, `PN`, `Unique_PN`, `PBY`, `PBM`, `PBD`, `FBY`, `FBM`, `FBD`, `Old_PCode`, `New_Pcode`, `PCA`, `PCD`, `OS_PCode`, `PCS`, `Appoint`, `Resign`, `Changed`, `Updated`, `VDL`, `Address_Data`, `Title`, `Forenames`, `Surname`, `Honours`, `Care_of`, `PO Box`, `Sub_Property`, `Property`, `Dep_Road`, `Address1`, `Sub_Locality`, `Address2`, `Post_Town`, `County`, `Country`, `AQ`, `Occupation`, `Nationality`, `Residency`, `Source`
FROM `Officers` WHERE ( ( ( ( ID is null ) or ( ID > 0 ) or ( ID=0 ) or ( ID < 0 ) ) ) ) and ( Source ='DIS' ) |
| #3 |
classes/datasource/table.php:621 |
DataSourceTable->getCount |
0. DsCommand |
| #4 |
classes/listpage.php:2793 |
ListPage->calculateRecordCount |
N/A |
| #5 |
classes/listpage.php:2205 |
ListPage->prepareForBuildPage |
N/A |
| #6 |
disqualified_officers_list.php:158 |
Global scope |
N/A |