After upgrading to 3.6.2 from 3.0.3 i found that signatures were not saving. Once saving a signature, going back to view your signature in the UserCp will show as just blank. All permissions set as default, and i've gone through all the permissions regarding signatures, everything seems fine. I cant seem to load anything from images to text. I've tried using the default skin, also does the same. I've tried disabling the plugins (being only 1), and still nothing. Currently using a skin i bought from 'cinvin', noone else has that bug.
I tried manually adding a signature in phpmyadmin, and it seemed to work. But i cant change it in the usercp, it will revert back to what i saved in phpmyadmin. I have also tried emptying signature cache.
I also get this error in the admincp in some places:
I tried manually adding a signature in phpmyadmin, and it seemed to work. But i cant change it in the usercp, it will revert back to what i saved in phpmyadmin. I have also tried emptying signature cache.
I also get this error in the admincp in some places:
PHP Code:
Database error in vBulletin 3.6.2:
Invalid SQL:
SELECT
user.userid, reputation, username, usergroupid, birthday_search, email,
parentemail,(options & 8) AS coppauser, homepage, icq, aim, yahoo, msn, skype, signature,
usertitle, joindate, lastpost, posts, ipaddress, lastactivity, userfield.*
FROM user AS user
LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
WHERE 1=1 AND user.usergroupid = 8
ORDER BY username ASC
LIMIT 0, 25;
MySQL Error : Column 'signature' in field list is ambiguous
Error Number : 1052
Date : Sunday, October 15th 2006 @ 09:21:37 AM
Script : forum/admincp/user.php?do=find&user[usergroupid]=8
Referrer : orum/admincp/usergroup.php?do=modify
Comment