Welcome to the nuBuilder Forums!

Register and log in to access exclusive forums and content available only to registered users.

error with old table name

Questions related to using nuBuilder Forte.
Post Reply
GlenMcCabe
Posts: 114
Joined: Sun Sep 29, 2019 12:40 pm

error with old table name

Unread post 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
kev1n
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

Unread post by kev1n »

It looks like the Browse SQL hasn't been changed.
SELECT * FROM doctors WHERE id = '-1'
GlenMcCabe
Posts: 114
Joined: Sun Sep 29, 2019 12:40 pm

Re: error with old table name

Unread post 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.
GlenMcCabe
Posts: 114
Joined: Sun Sep 29, 2019 12:40 pm

Re: error with old table name

Unread post by GlenMcCabe »

Edited and cleaned up forms. Now appears to be working
admin
Site Admin
Posts: 2815
Joined: Mon Jun 15, 2009 2:23 am
Been thanked: 25 times

Re: error with old table name

Unread post by admin »

.
Post Reply