Announcement

Collapse
No announcement yet.

Word Table

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

  • howardh
    replied
    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.

    Leave a comment:


  • Steve Machol
    replied
    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)
    );

    Leave a comment:


  • howardh
    replied
    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.

    Leave a comment:


  • Steve Machol
    replied
    That query works for me. Did you copy-n-paste it exactly? If so, then it has to be a server issue.

    Leave a comment:


  • howardh
    replied
    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

    Leave a comment:


  • Steve Machol
    replied
    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)
    );

    Leave a comment:


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

    Leave a comment:


  • Steve Machol
    replied
    Yes it can. Which version of vB are you running?

    Leave a comment:


  • howardh
    replied
    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.

    Leave a comment:


  • Steve Machol
    replied
    If search is working it's because you are using fulltext search and not the default search.

    Leave a comment:


  • howardh
    replied
    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

    Leave a comment:


  • Steve Machol
    replied
    That table stores the actual words in post that are indexed for vB search.

    Leave a comment:


  • howardh
    started a topic Word Table

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