I changed a table name from doctors to professionals and I am getting errors such as
[0] :
===USER==========
globeadmin
===PDO MESSAGE===
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'ccchubda_tdrupload.doctors' doesn't exist
===SQL===========
SELECt * FROM doctors WHERE id = '-1'
===BACK TRACE====
/home1/ccchubda/public_html/ccchublive/nucommon.php - line 264 (nuRunQuery)
/home1/ccchubda/public_html/ccchublive/nuapi.php - line 23 (nuSetHashList)
How can I fix this?
Thanks
Welcome to the nuBuilder Forums!
Register and log in to access exclusive forums and content available only to registered users.
Register and log in to access exclusive forums and content available only to registered users.
error with old table name
-
- nuBuilder Team
- Posts: 4307
- Joined: Sun Oct 14, 2018 6:43 pm
- Has thanked: 71 times
- Been thanked: 448 times
- Contact:
Re: error with old table name
It looks like the Browse SQL hasn't been changed.
SELECT * FROM doctors WHERE id = '-1'
-
- Posts: 114
- Joined: Sun Sep 29, 2019 12:40 pm
Re: error with old table name
Kevin
The SQL is fine. I have looked at the zzz table of forms and there are references to doctors in the sfo_table column. I will delete, amend or recreate the forms as required.
The SQL is fine. I have looked at the zzz table of forms and there are references to doctors in the sfo_table column. I will delete, amend or recreate the forms as required.
-
- Posts: 114
- Joined: Sun Sep 29, 2019 12:40 pm