Hi,
I'm having the following error message:
"Error Reference: 988996b
An error occurred while running the following query:
DROP TABLE ___nu152937998313cb___".
There is no table ___nu152937998313cb___ .
Any idea why I'm having this error message?
Thank you.
Welcome to the nuBuilder forums!
Please register and login to view forums and other content only available to registered users.
Please register and login to view forums and other content only available to registered users.
An error occurred
-
- Posts: 503
- Joined: Thu May 24, 2012 2:08 am
- Location: Milan, Italy
- Contact:
-
- Posts: 177
- Joined: Tue Nov 15, 2011 2:24 pm
Re: An error occurred
Hi massiws,
For example, in the Form "Custom Code"-> After Save I have some select/updates to the database like:
When I save the form I get this king of message in the "Debug" interface from the administrator.
I check the database and I don't see that table.
Usually there is a lot of those tables when I run querys/ reports and now I don't see them anymore.
Any idea what's happening?
Thanks for you help!
For example, in the Form "Custom Code"-> After Save I have some select/updates to the database like:
Code: Select all
$pa = "SELECT * FROM po WHERE po_id='$recordID'";
$porow = db_fetch_object($pa);
$inventoryID = $porow->po_inventoryid;
$postatus = $porow->po_status;
nuRunQuery($pa);
I check the database and I don't see that table.
Usually there is a lot of those tables when I run querys/ reports and now I don't see them anymore.
Any idea what's happening?
Thanks for you help!
BR
Rui
Rui
-
- Posts: 503
- Joined: Thu May 24, 2012 2:08 am
- Location: Milan, Italy
- Contact:
Re: An error occurred
Rui,
maybe there is an error in your code:
Also, it's a better choice to get only two fields you need from database.
Hope this helps,
Max
maybe there is an error in your code:
Code: Select all
$pa = "SELECT po_inventoryid, po_status FROM po WHERE po_id='$recordID'";
// nuDebug($pa); // uncomment this to debug in "Setup > Debug"
nuRunQuery($pa);
$porow = db_fetch_object($pa);
$inventoryID = $porow->po_inventoryid;
$postatus = $porow->po_status;
Hope this helps,
Max
-
- Posts: 177
- Joined: Tue Nov 15, 2011 2:24 pm
-
- Posts: 503
- Joined: Thu May 24, 2012 2:08 am
- Location: Milan, Italy
- Contact: