No announcement yet.

Problem with repair.php output

  • Filter
  • Time
  • Show
Clear All
new posts

  • 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


    Leave a comment:

  • 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?

    Leave a comment:

  • Ben
    started a topic Problem with repair.php output

    Problem with repair.php output

    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
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.