UBB.Developers Forums UBB.threads 7 Development How Do I? MySQL Error with Avatars

I could post this on InfoPops board but its so much more fun here

I get this when trying to upload an Avatar
Script: C:\wwwroot\ubbthreads\changebasic.php
Line#: 479
SQL Error: You have an error in your SQL syntax near '\'http://emeraldforestseattle.com/fgifs/6.gif\' ,U_PicWidth = \'49\', U_PicHeig' at line 24
SQL Error #: 1064
Query: UPDATE w3t_Users SET U_Password = 'Things that make ya go hmmm-edited', U_LastOn = '1094433446', U_Email = '[email protected]', U_Fakeemail = '[email protected]', U_Name = 'Michael', U_Signature = 'ChAoS Emerald Forest Gaming Servers Official STFU Thread ', U_Homepage = 'EmeraldForestSeattle.com', U_Occupation = 'Staying Ailve', U_Hobbies = 'Skiiing,Camping,Anything in the waterand anything that is electronic!', U_Location = 'Great NorthWest', U_Bio = '', U_Extra1 = '', U_Extra2 = '[email protected]', U_Extra3 = '', U_Extra4 = '', U_Extra5 = '', U_Visible = 'no', U_AcceptPriv = 'yes', U_OnlineFormat = 'yes', U_Birthday = '3/17/1966', U_ShowBday = '0' ,U_Picture = \'http://emeraldforestseattle.com/fgifs/6.gif\' ,U_PicWidth = \'49\', U_PicHeight = \'49\' WHERE U_Number = '6'

I am not the only one getting this error by the way and I am not sure but I believe this part "6.gif" is from an old avatar that I used in the past (not my current one) if that is of any relevance

Aww Crap- I tried to upload this Avatar to my forums and got the above error and apparently even though I got the error it must have worked and to my surprise I must have linked my profile to this board -lmao But on my board its still the same prior Avatar.

Feel free to moderate if you feel its uhh--inappropriate
I will be going back to the old Avatar once I get the eror fixed

You didn't say what version - but if it's 6.5 beta 6 you'll have to fix this bug:
http://www.ubbcentral.com/boards/showfla...p;fpart=1#38388
before you can edit your avatar.

Thanks it worked and now my honor is once again restored (and my Avatar)

[]JoshPet said:
You didn't say what version - but if it's 6.5 beta 6 you'll have to fix this bug:
http://www.ubbcentral.com/boards/showfla...p;fpart=1#38388
before you can edit your avatar. [/]

the link doesnt work...
and I need to find this fix.

Infopop purged all the 6.5 beta bugs. but it was fixed in 6.5. final.

yeah, but my licence has expired and i'm not planning on upgrading just yet.
I dont suppose anyone knows by memory what this fix was?

I don't exactly

\'http://emeraldforestseattle.com/fgifs/6.gif\' ,U_PicWidth = \'49\', U_PicHeight = \'49\' WHERE U_Number = '6'

It had to do with a call to addslashes for the avatar stuff being applied twice. If you want to send me a PM with access I'll have a look.