nuBuilder Forum

Posted: **Mon Nov 25, 2013 5:53 pm**

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.

Posted: **Mon Nov 25, 2013 9:15 pm**

Rui,
can you better explain when you get this message?

Posted: **Mon Nov 25, 2013 11:34 pm**

Hi massiws,

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);

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!

Posted: **Tue Nov 26, 2013 4:07 am**

Rui,
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;

Also, it's a better choice to get only two fields you need from database.

Hope this helps,
Max

Posted: **Tue Nov 26, 2013 5:41 pm**

Hi Max,

Probably you are right!

Thanks for your help! I will test it.

Posted: **Sat Dec 21, 2013 4:45 pm**

nuBuilder Forum

An error occurred

An error occurred

Re: An error occurred

Re: An error occurred

Re: An error occurred

Re: An error occurred

Re: An error occurred