|
Article ID:
226 |
Categories:
Error Messages
Configuration
|
Products:
XC Connect (Windows Server)
|
Date Created:
09/03/2007 05:16 PM |
Date Updated:
09/03/2007 05:16 PM |
|
| Error while upgrading XCN Server to 3.2.010 - DBException: Could not execute the query: select xc_user.xc_user_id, xc_user.guid, ..... |
| |
Error during upgrade to 3.2.010: "DBException: Could not execute the query: select xc_user.xc_user_id, xc_user.guid,..." |
| |
The error indicates that there is an issue with the database. The following instructions will resolve the issue:
1. open a DOS terminal window (Start -> Run -> enter "cmd"
2. at the prompt, enter: "cd c:\xcnetwork\common"
3. at the c:\xcnetwork\common prompt enter: "c:\mysql\bin\mysql -u xcnetwork xcnetwork"
4. you will now be at a "mysql" prompt. Please enter: "source update_database_3_2.sql"
This will cause a data dump to occur, possibly flagging errors, all of which can be ignored. There error flags are there is because the process is going through every command, some of which is not being used by XC.
5. Stop and restart the XCN Server
Start -> Programs -> Xchange Network Server -> Stop server
and after the various DOS windows have closed,
Start -> Programs -> Xchange Network Server -> Start server |
| |
| |
| Click here to send specific feedback about this article. |
|
