An error occurred

[ruiascensao]

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.

[massiws]

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

[ruiascensao]

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!

[massiws]

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

[ruiascensao]

Hi Max,

Probably you are right!

Thanks for your help! I will test it.

[massiws]

.