|
A
|
algreilly 1/11/2011 |
|
STDuffy: On one of my tables only, I get the following error appear when I try and save on the edit record page: ---------------- <<< Record was NOT edited >>> Table 'databasename.leads' doesn't exist ---------------- (I have replaced my real database name for security reasons on this post) It is correct that this table does not exist - it is in fact called 'lms_leads' instead. Also it does actually update the record as when I go to the list page or edit it is there. I have tried a full re-build, even tried renaming my project and uploading to separate area. I have tried with security on and off. I have also tried searching for all references of 'leads' versus 'lms_leads' across all of the code and I get the same number of results so it is not even a wrong reference in the code. My other tables are fine. Any ideas? |
|
|
S
|
stduffy author 1/11/2011 |
|
Thanks for the reply. I have worked it out and it is nothing to do with PHPRunner - there was an old trigger statement that was not updated in MySQL which referenced the wrong table. STDuffy: Back in your TABLES section, did you "RESET QUERY" at all? I would try that, and rebuild the project. I have seen when a table has been dropped or edited and the "reset query" is not used that you will get that result when adding or editing a record. Regards, |
|