Announcement

Collapse
No announcement yet.

Database Error while rebuilding Search Index

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

  • Lynne
    replied
    You can add it, but I don't know that it's going to fix your problem. It needs to be filled in. I honestly don't know how you were running 3.8 without it. This is from install/mysql-schema.php (do not run this query, you can just get the info you need to create the field from it). As you can see, not only do you have to create the field, but the field is used for two keys.
    Code:
    CREATE TABLE " . TABLE_PREFIX . "groupmessage (
        gmid INT UNSIGNED NOT NULL auto_increment,
        discussionid 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 UNSIGNED NOT NULL DEFAULT '0',
        reportthreadid INT UNSIGNED NOT NULL DEFAULT '0',
        PRIMARY KEY  (gmid),
        KEY postuserid (postuserid, discussionid, state),
        KEY discussionid (discussionid, dateline, state)
    )

    Leave a comment:


  • Abhik
    replied
    Any more help please?

    Leave a comment:


  • Abhik
    replied
    Is there any data that I could use to create that field in the "groupmessage" table?

    Leave a comment:


  • Abhik
    replied
    Yes, I just upgraded to vbulletin 4.0.3. But, I was using 3.8.x since they came out.

    Is there any data that I could use to create that field in the "groupmessage" table?

    Leave a comment:


  • Lynne
    replied
    I don't know how you can't have a discussionid field in the groupmessage table. That field has been around since the 3.8 days. Did you just do an upgrade?

    Leave a comment:


  • Abhik
    replied
    That's not working.. Still showing the error.
    I guess it's kinda related to corrupt MySQL tables.

    Anymore help?

    Leave a comment:


  • ChopSuey
    replied
    http://www.vbulletin.com/forum/showt...89#post1957989

    Check second post

    Leave a comment:


  • Abhik
    started a topic [Forum] Database Error while rebuilding Search Index

    Database Error while rebuilding Search Index

    Hello,
    I was trying to rebuild Search Index for Group Messages and got the database error below

    Code:
    Database error in vBulletin 4.0.3:
    
    Invalid SQL:
    
                    SELECT m.*, 
                        d.firstpostid,
                        fp.title as discussiontitle, 
                        fp.postuserid as discussionuserid,
                        fp.postusername as discussionusername, 
                        fp.dateline as discussiondateline
                    FROM mst_groupmessage AS m JOIN mst_discussion d ON m.discussionid = d.discussionid JOIN mst_groupmessage fp ON d.firstpostid = fp.gmid
                    WHERE m.gmid >= 0 AND m.gmid <= 3;
    
    MySQL Error   : Unknown column 'm.discussionid' in 'on clause'
    Error Number  : 1054
    Request Date  : Saturday, May 8th 2010 @ 08:53:40 AM
    Error Date    : Saturday, May 8th 2010 @ 08:53:40 AM
    Script        : http://www.domain.com/admincp/misc.php?do=doindextypes
    Referrer      : http://www.domain.com/admincp/misc.php
    IP Address    : xxx.xxx.xxx.xxx
    Username      : xxxxxxxxxxx
    Classname     : vB_Database
    MySQL Version : 5.0.90-community
    How can I fix this?

    Thanks

Related Topics

Collapse

Working...
X