mariovaldez.net
http://www.mariovaldez.net/webapps/forums/

An error ocurred....incorrect table name....
http://www.mariovaldez.net/webapps/forums/viewtopic.php?f=14&t=278
Page 1 of 1

Author:  djihel [ 31 Jan 2006, 03:12 ]
Post subject:  An error ocurred....incorrect table name....

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

Author:  mvaldez [ 02 Feb 2006, 07:27 ]
Post subject:  Send me a SQL log file from OSCPMWin...

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.

:arrow: 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.

Page 1 of 1 All times are UTC - 7 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/