Hi,
I have backedup my SC database and rebuilt the server from scrach. Inetialy I installed 5038 and upgraded to 6000 and patched it with 6003 last week before I rebuilt. I downloaded the latest build from your website 6003 and installed it. It worked but did not restore the database. I removed it completely and installed 5036 and upgraded it to 6000 and patched it to 6003, still the same error. The error indicates that there is a syntax error within the mysql. It is very urgent that I get the system up and running ASAP.
Kind regards,
Logs are as follow;
C:\Documents and Settings\Administrator>cd c:\AdventNet\ME\SupportCenter\bin
For Windows users : bin>restoreData -c [backup file]
For Linux users : bin]#sh restoreData.sh -c [backup file]
******************************************************************************** * FYI [SEVERE]: Please don't kill this utility until the operation is completed requestScheme is http Please wait extracting backup file Jun 12, 2007 1:12:44 PM com.adventnet.j2ee.deployment.service.internal.JarExtrac tor extract INFO: Extraction for c:\Backup_scp_6000_06_06_2007_14_43.data to C:\AdventNet\M E\SupportCenter\bin\.. Active DB Server = mysql Database connectionProp : useUnicode=true characterEncoding=UTF-8
Database not started. Starting ......... Jun 12, 2007 1:12:54 PM com.adventnet.db.adapter.DBInitializer startDBServer INFO: Command to start DB server [cmd, /c, "..\bin\startDB.bat", 33356]
************************************************************* Backpup data : Wed Jun 06 14:43:19 BST 2007 Database name : supportcenter Total Tables : 709 Build Number : 6000 *************************************************************
Please wait ! Deleting table data in Progress.. 0-----------------------50------------------------100(%) ===================================================
Please wait ! Restoring in Progress................... 0-----------------------50------------------------100(%) ===================QUERY = INSERT INTO errorlog (ERRORLOGID,OCCURREDTIME,MESSAGE ,ERRORMODULE,PROBABLECAUSE) VALUES(1504, 1179281310475, N'Spam mail filter condi tion matched', N'Helpdesk', N' Mail Filter condition matched. Hence not creating a new request. \n Sender Name : Sales Department\n From Address : sales@teamsen sationsnature.com\n Title : SPAM: ORIGINAL VIAGRA AND CIALIS\n Description : Inv estment Tracker stock Report
Diamant Art Corp. (SYMBOL: DIAAF.OB) is set to explode on Thursday 02/15/07 All signs pointing to bullish market.
Recommendations: Very strong buy!
SYMBOL: DIAAF.OB WED. CLOSE: $0. 0008 SHORT TERM ARGET: $0.0019 LONG '); java.sql.BatchUpdateException: Syntax error or access violation, message from s erver: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'N' Mail Filter co ndition matched. Hence not creating a new request. \n Sender Na' at line 1" at com.mysql.jdbc.Statement.executeBatch(Statement.java:1057) at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreTableData(Rest oreSDBackup.java:247) at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(Resto reSDBackup.java:120) at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup. java:80) at com.adventnet.servicedesk.tools.RestoreDialog.main(RestoreDialog.java :317) Unable to restore database : Syntax error or access violation, message from ser ver: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'N' Mail Filter cond ition matched. Hence not creating a new request. \n Sender Na' at line 1"