Page 1 of 1

error with old table name

Posted: Thu Sep 03, 2020 3:35 pm
by GlenMcCabe
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

Re: error with old table name

Posted: Thu Sep 03, 2020 5:27 pm
by kev1n
It looks like the Browse SQL hasn't been changed.
SELECT * FROM doctors WHERE id = '-1'

Re: error with old table name

Posted: Sat Sep 05, 2020 12:13 pm
by GlenMcCabe
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.

Re: error with old table name

Posted: Sun Sep 06, 2020 6:39 pm
by GlenMcCabe
Edited and cleaned up forms. Now appears to be working

Re: error with old table name

Posted: Mon Sep 07, 2020 4:34 am
by admin
.