I have a problem where VB crashes (see below) whenever any one tries to look at their profile, (or if admin looks at any user profile)
I'm using repair.php?check=1&iterations=4&forum=coolxxxxb
but get "This table does not support check/repair/optimize" for every table??
Error displayed in browser when trying to access any user profile =
Database error in vBulletin: Invalid SQL: SELECT user.avatarid,avatarpath,NOT ISNULL(avatardata) AS hascustom,customavatar.dateline
FROM user
LEFT JOIN avatar ON avatar.avatarid=user.avatarid
LEFT JOIN customavatar ON customavatar.userid=user.userid
WHERE user.userid='1'
mysql error: Unknown column 'customavatar.dateline' in 'field list'
mysql error number: 1054
I'm using repair.php?check=1&iterations=4&forum=coolxxxxb
but get "This table does not support check/repair/optimize" for every table??
Error displayed in browser when trying to access any user profile =
Database error in vBulletin: Invalid SQL: SELECT user.avatarid,avatarpath,NOT ISNULL(avatardata) AS hascustom,customavatar.dateline
FROM user
LEFT JOIN avatar ON avatar.avatarid=user.avatarid
LEFT JOIN customavatar ON customavatar.userid=user.userid
WHERE user.userid='1'
mysql error: Unknown column 'customavatar.dateline' in 'field list'
mysql error number: 1054
Comment