PDA

View Full Version : Error when updating Profile


TheEn|gma
06-02-2007, 03:00 PM
Was changing a few things hit saved changes and got the following errors( I asterisk'd my IP;) ):

Database error in vBulletin 3.6.7:

Invalid SQL:
UPDATE user SET
parentemail = '',
icq = '',
msn = '',
aim = '',
yahoo = '',
skype = '',
homepage = 'http://www.eaglessquad.co.uk',
birthday_search = '1989-08-14',
birthday = '08-14-1989',
showbirthday = 1,
usertitle = '<font color=\"red\"><b>Total QW Staff</b></font>',
customtitle = 0,
xfire = ''
WHERE userid = 1265;

MySQL Error : Unknown column 'xfire' in 'field list'
Error Number : 1054
Date : Saturday, June 2nd 2007 @ 06:54:40 AM
Script : http://www.totalquakewars.com/forums/profile.php?do=updateprofile
Referrer : http://www.totalquakewars.com/forums/profile.php?do=editprofile
IP Address : **.**.***.***
Username : TheEnigma
Classname : vb_database

I don't know much SQL but it looks like you've got different names in your SQL Insert into statement compared to the xfire field in the db.

Link
06-03-2007, 12:59 AM
*Points at TheEnigma* - You broke it!!!

Kradath
06-04-2007, 07:04 PM
I also get an database error.

Xbomber
06-06-2007, 04:46 AM
Noooooooo!

[MyIS]Crrrazzzy
06-12-2007, 06:55 PM
fixed

MiiQ
06-12-2007, 08:33 PM
Crrrazzzy;23390']fixed

...not ;)

InsertNameHere has not specified contact details for this medium.

When trying to check someone's name/nick/address.

Kradath
06-12-2007, 09:19 PM
The most is working now, except xFire.

[MyIS]Crrrazzzy
06-12-2007, 11:51 PM
hunh?

Link
06-13-2007, 04:29 AM
He means that for the most part, the profile page is working, however, the xfire text field does not save to the database. By the looks of it, default is "0". I can't change it from that, either using my actual xfire username, or various random ones.

Kradath
06-13-2007, 05:23 AM
Excactly that happens.

MiiQ
06-13-2007, 12:41 PM
And almost everyone seems to have Google Talk.