Announcement

Collapse
No announcement yet.

SQL table missing ?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • SQL table missing ?

    Haven't had any trouble in the past but for some reason this is haunting me now. It's with the profile album.

    Database error in vBulletin 3.8.3:
    Invalid SQL:
    SELECT SQL_CALC_FOUND_ROWS picturecomment.*, user.*, picturecomment.ipaddress AS messageipaddress ,deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason ,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight, customavatar.width_thumb AS avwidth_thumb, customavatar.height_thumb AS avheight_thumb, filedata_thumb, NOT ISNULL(customavatar.userid) AS hascustom
    FROM picturecomment AS picturecomment
    LEFT JOIN user AS user ON (picturecomment.postuserid = user.userid)
    LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
    LEFT JOIN deletionlog AS deletionlog ON (picturecomment.commentid = deletionlog.primaryid AND deletionlog.type = 'picturecomment')

    WHERE picturecomment.pictureid = 375
    AND (picturecomment.state IN ('visible','moderation','deleted'))
    ORDER BY picturecomment.dateline
    LIMIT 0, 10;
    MySQL Error : Table 'fairban2_Lion01.picturecomment' doesn't exist Error Number : 1146

    Do I just need to add in tables that disappeared or does this look like I screwed something else up.
    I did have album pics moderated and when in moderation I could see them fine but after approving I get this after clicking on thumbnail. Thanks.

  • #2
    You can find any tables that you need to create in your install directory of your vbulletin zip, those can be found in the mysql-schema.php file
    Code:
    CREATE TABLE picturecomment (
    commentid INT UNSIGNED NOT NULL AUTO_INCREMENT,
    pictureid INT UNSIGNED NOT NULL DEFAULT '0',
    postuserid INT UNSIGNED NOT NULL DEFAULT '0',
    postusername varchar(100) NOT NULL DEFAULT '',
    dateline INT UNSIGNED NOT NULL DEFAULT '0',
    state ENUM('visible','moderation','deleted') NOT NULL DEFAULT 'visible',
    title VARCHAR(255) NOT NULL DEFAULT '',
    pagetext MEDIUMTEXT,
    ipaddress INT UNSIGNED NOT NULL DEFAULT '0',
    allowsmilie SMALLINT NOT NULL DEFAULT '1',
    reportthreadid INT UNSIGNED NOT NULL DEFAULT '0',
    messageread SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    PRIMARY KEY (commentid),
    KEY pictureid (pictureid, dateline, state),
    KEY postuserid (postuserid, pictureid, state)
    );
    Gentoo Geek

    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...
    X