Announcement

Collapse
No announcement yet.

Word Table

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

  • Word Table

    Hello.

    I was looking through the SQL table list for vBulletin and there is one table in the SQL database that is not in the list of tables from AdminCP.

    The table is the WORD table.

    Does anyone know what this is for?

    Thanks.

  • #2
    That table stores the actual words in post that are indexed for vB search.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment


    • #3
      Originally posted by Steve Machol View Post
      That table stores the actual words in post that are indexed for vB search.
      I'm not sure I understand that. I removed this table because it was corrupted, but my searches still work fine. I can't find anything on my site that doesn't work.

      Can vBulletin rebuild this table?

      Thanks

      Comment


      • #4
        If search is working it's because you are using fulltext search and not the default search.
        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
        Change CKEditor Colors to Match Style (for 4.1.4 and above)

        Steve Machol Photography


        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        Comment


        • #5
          Originally posted by Steve Machol View Post
          If search is working it's because you are using fulltext search and not the default search.
          Well, they way I found out it was corrupted was by switching from fulltext search to vB search. Now I find can't switch back to fulltext search.

          Can this table be rebuilt?

          Thanks.

          Comment


          • #6
            Yes it can. Which version of vB are you running?
            Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
            Change CKEditor Colors to Match Style (for 4.1.4 and above)

            Steve Machol Photography


            Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


            Comment


            • #7
              Originally posted by Steve Machol View Post
              Yes it can. Which version of vB are you running?
              3.6.5

              Comment


              • #8
                Run this query:

                CREATE word (
                wordid INT UNSIGNED NOT NULL AUTO_INCREMENT,
                title CHAR(50) NOT NULL DEFAULT '',
                PRIMARY KEY (wordid),
                UNIQUE KEY title (title)
                );
                Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                Change CKEditor Colors to Match Style (for 4.1.4 and above)

                Steve Machol Photography


                Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                Comment


                • #9
                  Originally posted by Steve Machol View Post
                  Run this query:

                  CREATE word (
                  wordid INT UNSIGNED NOT NULL AUTO_INCREMENT,
                  title CHAR(50) NOT NULL DEFAULT '',
                  PRIMARY KEY (wordid),
                  UNIQUE KEY title (title)
                  );

                  Here is the error that is returned:

                  An error occurred while attempting to execute your query. The following information was returned.
                  error number: 1064
                  error desc: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'word (
                  wordid INT UNSIGNED NOT NULL AUTO_INCREMENT,
                  title CHAR(50) NOT NULL DE' at line 1

                  Comment


                  • #10
                    That query works for me. Did you copy-n-paste it exactly? If so, then it has to be a server issue.
                    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                    Change CKEditor Colors to Match Style (for 4.1.4 and above)

                    Steve Machol Photography


                    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                    Comment


                    • #11
                      Originally posted by Steve Machol View Post
                      That query works for me. Did you copy-n-paste it exactly? If so, then it has to be a server issue.
                      Yes, I did copy and paste it exactly. The server is working fine. It's version 5.0.37.

                      Comment


                      • #12
                        Arrgghh - my bad! Try this:

                        CREATE TABLE word (
                        wordid INT UNSIGNED NOT NULL AUTO_INCREMENT,
                        title CHAR(50) NOT NULL DEFAULT '',
                        PRIMARY KEY (wordid),
                        UNIQUE KEY title (title)
                        );
                        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                        Change CKEditor Colors to Match Style (for 4.1.4 and above)

                        Steve Machol Photography


                        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                        Comment


                        • #13
                          Originally posted by Steve Machol View Post
                          Arrgghh - my bad! Try this:

                          CREATE TABLE word (
                          wordid INT UNSIGNED NOT NULL AUTO_INCREMENT,
                          title CHAR(50) NOT NULL DEFAULT '',
                          PRIMARY KEY (wordid),
                          UNIQUE KEY title (title)
                          );
                          That did it. I figured the same thing out overnight. I switched back to fulltext search and rebuilt the search index. It works fine.

                          Thanks.

                          Comment

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