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!
Join our community by registering and logging in.
As a member, you'll get access to exclusive forums, resources, and content available only to registered users.
Join our community by registering and logging in.
As a member, you'll get access to exclusive forums, resources, and content available only to registered users.
error with old table name
-
- nuBuilder Team
- Posts: 4566
- Joined: Sun Oct 14, 2018 6:43 pm
- Has thanked: 76 times
- Been thanked: 529 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