Getting an error when running the _list.php on a particular table.
Really weird as I haven't messed around with any SQL code in the Project but it still seems to be generating something weird.
It says that databasename.date_reported doesn't exist - well it doesn't! There is no table with that name anywhere and neither is it referenced in the project. The error then lists the SQL which works fine if you only copy the UPPER CASE - for some reason the lower case after it has got in there somehow and this is wrong.
Any ideas?
---------------------
There is the error:
Error type 256
Error description Table 'db135912188.date_reported' doesn't exist
URL peak-nutrition.co.uk/backoffice/dfail/DFAIL_RTS_list.php
Error file /homepages/42/d98560499/htdocs/PN/backoffice/dfail/include/dbconnection.php
Error line 26
SQL query select `ORDER_ID`, `EMAIL_ADDRESS`, `DATE_DFAIL`, `DATE_REPORTED`, `DATE_CONTACT`, `CONTACT_TEXT`, `REPLACEMENT_ORDER_ID`, `REPLACEMENT_DATE`, `ITEM_LOST`, `CLAIMED`, `STATUS`, `TICKET_ID` From `DFAIL_RTS` date_contact, date_reported, date_dfail, email_address, order_id
