Problem with repair.php output

[Ben]

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

[Freddie Bingham]

Your host must be using Mysql 3.22 so repair.php won't work.

Run this query in phpMyAdmin to fix your current problem.

ALTER TABLE customavatar ADD dateline INT UNSIGNED not null

This change was made in upgrade4.php and there are further changes that follow this one that you may not have. Did you upgrade from 1.1.x or a 2.0 beta?

[Ben]

Thanks freddie, but I went for the option of running the upgrade scripts as in Really messed up upgrade!! .

Seems I had really messed up the install...

All seems to be fixed now (gawd i hope so!)

But thanks for your help anyway

Ben