SQL Error 1146 Table TABLE_CUSTOMERS_ADMIN_NOTES doesn't exist

[utefan]

Hello everyone:

I am seeing the following SQL error in my store this morning. This is the error message I am seeing:

1146 Table 'site_table.TABLE_CUSTOMERS_ADMIN_NOTES' doesn't exist
in:
[select * from TABLE_CUSTOMERS_ADMIN_NOTES where customers_id = '3822']

I am confused by this error because I don't have a table called TABLE_CUSTOMERS_ADMIN_NOTES in my database. I'm not sure where this SQL statement is coming from. Does anyone know which PHP file might be making this call? I checked he forums and haven't been able to find anything related to this issue.

Thank you.

[utefan]

Nevermind. I found it. Looks like it is a superorders.php issue.

[mc12345678]

It's typically located in the admin directory. Two options: install mydebug backtrace (assuming it works with ZC 1.3.9) and the access your admin again, search using tools->developers toolkit from the admin for that table name, 3) also to investigate identify who accessed your site to place (or remove the table define) the file(s) on your server...

[utefan]

Hi: Thanks for the tip. I didn't know about the backtrace function. I think that will come in handy for me on some other items as well. I've upgraded my super orders to a newer version. That seems to have knocked out the issue. Very good suggestion on the security side. I should look at that too. Thanks again.

[mc12345678]

Glad it helped. Thank lat9 for developing that solution which is now included in more recent versions of ZC to which I'd recommend upgrading: http://www.zen-cart.com/entry.php?3-...d-of-upgrading