PDA

View Full Version : WHAT IS UP WITH THESE SQL ERRORS someone explain what this means...


DarkDraco07
09-06-2002, 12:53 AM
Database error in vBulletin 2.2.7:

Invalid SQL: UPDATE user SET element='0' ,birthday='1985-6-4',signature='',customtitle='0',usertitle='Adminis trator',email='darkdraco07@msn.com',parentemail='' ,coppauser='0',homepage='http://www.darknemesis.com',icq='',aim='DarkDraco07',msn= 'DarkDraco07@msn.com',yahoo='DarkDraco07',usergrou pid='6', gender='2' WHERE userid='1', rpgclass='0' WHERE userid='1'
mysql error: You have an error in your SQL syntax near ' rpgclass='0' WHERE userid='1'' at line 1

mysql error number: 1064

Date: Thursday 05th of September 2002 07:52:21 PM
Script: http://www.darknemesis.com/forums/forums/member.php
Referer: http://www.darknemesis.com/forums/member.php?action=editprofile

DarkDraco07
09-06-2002, 01:08 AM
i get it while trying to save my profile

Erwin
09-06-2002, 01:40 AM
Look at the error statement - it tells you what the problem is. The problem here is that you are trying to save a variable called "rpgclass" and the query statement there is wrong - you are missing a quotation mark, or spelt something wrong there.

DarkDraco07
09-06-2002, 02:03 AM
in the query or in a file somewhere?

DarkDraco07
09-06-2002, 02:34 AM
nm it was in members.php