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.

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: 4565
Joined: Sun Oct 14, 2018 6:43 pm
Has thanked: 76 times
Been thanked: 529 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: 2829
Joined: Mon Jun 15, 2009 2:23 am
Been thanked: 30 times

Re: error with old table name

Unread post by admin »

.
Post Reply