mariovaldez.net

I have No problem to connect to my DB but when Oscpwin try to retrieve table liste, i have this message : "An error occured while processing database query. Sql Error : incorrect table name" though i have all the oscommerce tables (categories,manufacturers,languages, etc..) corresponding with the correct name installed.

Thank you to help me understanding.

Djihel

Djihel:

> I have No problem to connect to my DB but when Oscpwin
> try to retrieve table liste, i have this message : "An error
> occured while processing database query. Sql Error : incorrect
> table name" though i have all the oscommerce tables
> (categories,manufacturers,languages, etc..) corresponding
> with the correct name installed.
> Thank you to help me understanding.

Hi. Please open the Configuration window, in the first tab (Network) look for the option "Log SQL queries to file". Try to connect. After it fails, if the application still works, go to the "Tools" menu, select "SQL log file" option and copy all the content of the SQL log window. Send the content to mario@mariovaldez.org. (There are no passwords or other sensitive information in the log). If the application does not work after the failure, then use your Window Explorer and look for a file named OSCDEBUG.TXT in the directory where OSPMWin is installed. Send the file to mario@mariovaldez.org.

The SQL log contain information about the queries send to the SQL server and the data returned, including error conditions. That would let me find out what is causing your problem.


Regards,

Mario A. Valdez-Ramirez.