3.7.2 Custom Avatar error

[MissKalunji]

That's what i get as error :-/

Database error in vBulletin 3.7.2:

Invalid SQL:
UPDATE customavatar SET
userid = 4640,
dateline = 1216404805,
filename = 'outputvs8.gif',
width = 160,
height = 131,
filesize = 1144505,
filedata = 'GIF89a \0ƒ\0÷\0\0 \r \r \r \Z \Z \" \" $ \"% $&!\'(\"\',#(/$)0%)2&+1\'+4\'-8\',8(-5*.3+03,26-13,25-48.5=/6>/6?/5A-6>09>3;@4<D7<E8=G8>M8>[email protected];BK<DM>GH=OC>[email protected] SYJTWKUXKWWLYXL[UJ]RIbQJeRLfTNgXQe\\Rc`SccUafVfbWjaYkcZld[me]lg^mh`lkanlbmpbpmcppeqqhqqjsqiuphyoi|nh{piyqkzrlzslztm{tn|vp{wq|vq wq€yr ys zs„zt‰{vŠ{v‰|w‹}wˆ z… }† { ‚{Žƒ| „} …~ †~ †€‘ˆ‚“Šƒ”Œ…‘Œ‡‘ Š‹Ž‹‡ ’Š’•Š”˜Œ–šŽ—™‘˜˜”™—•™–˜™–š™•š›•›œ–œ —œŸ™ ™ ¡šž¢›Ÿ¢œŸ£ž ¤Ÿ ¤Ÿ¡¤Ÿ¡¤ž¢£œ£¢›¥¢š¦¡™§Ÿ˜¨ž—©

It's a lot longer then that but the board isn't taking that much character and there's no specify of which table is doing this error nothing

[Steve Machol]

What are the last 10 lines of this error?

[MissKalunji]

Same type of code...it doesn't show which table nothing like that

But when you upload an custom picture it gives this error

Warning: tempnam() [function.tempnam]: open_basedir restriction in effect. File() is not within the allowed path(s): (/home/danceha/:/usr/lib/php:/usr/local/lib/php:/tmp) in [path]/includes/class_dm_userpic.php on line 204

if the picture is animated after uploadeding won't be anymore

[Steve Machol]

1. You have open_basedir restrictions on your server. To get uploads to work you need to create a 'tmp' subdirectory under your main hosting directory and chmod it to 777. Then in the Admin CP set "Upload In Safe Mode?" to 'Yes' and point the "Safe Mode Temp Directory" to that directory. If you placed the tmp directory in the right place, the path to the Safe Mode Temp Directory will be:

/home/danceha/tmp

Also the php.ini setting for 'upload_tmp_dir' may be empty. It's possible you (as root) or your host will need to edit php.ini and set 'upload_tmp_dir' to point to the
full path to a directory on the server that is chmod'd to 1777. You will also need to restart Apache after making this change.

2. This is a Usergroup setting: Can Upload Animated Profile Picture

Also if the file being uploaded is larger than the maximum allowed size and the systen is resizing it, the animation will be lost.

[MissKalunji]

1. You have open_basedir restrictions on your server. To get uploads to work you need to create a 'tmp' subdirectory under your main hosting directory and chmod it to 777. Then in the Admin CP set "Upload In Safe Mode?" to 'Yes' and point the "Safe Mode Temp Directory" to that directory. If you placed the tmp directory in the right place, the path to the Safe Mode Temp Directory will be:

/home/danceha/tmp

That was it Thanks Again