Interview Question in Sql Server Views


 

Interview Question :: An error occurred trying to update the database


An error occurred trying to update the database
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 '-mtk_99k_org_auth_access ( group_id mediumint(8) DEFAULT '0' NOT NULL, for' at line 1


I have no clue how to view the Syntax or w/e
this is for a phpbb installation somebody please help me :]
Answers to "An error occurred trying to update the database"
RE: An error occurred trying to update the database?

Hi there!



Without getting any more information it'll be pretty hard to figure out what exactly went wrong. Do you have any file and/or line numbers given to you by the error message?



The message basically says that there is a character in or to the left of the above chunk of SQL code in the phpbb source code file. If you don't have any more information, you'd probably be better off at phpbb's support board.



Tell them where and when exactly you got the error message (e. g. "page 2 of the setup wizzard"), so they can try to troubleshoot the problem together with you. Do not tell them any passwords you entered. If your password or database user name have any special characters in them, tell them wich ones, but again, do not give them the full user name or password.



Find their support board here: http://www.phpbb.com/support/



hth



Christian
 
Vote for this answer ::  
Update Alert Setting