Announcement

Collapse
No announcement yet.

Error 1146 News

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

  • Error 1146 News

    Im getting this error when trying to post a message, although the message still posts.

    PHP Code:
    Database error in vBulletin 3.5.1:
    Invalid SQL:
    UPDATE session SET newposts newposts+1 WHERE NOT ISNULL(newposts);
    MySQL Error Table 'jelsoft.session' doesn't exist
    Error Number : 1146
    Date : Saturday, January 28th 2006 @ 05:11:59 PM
    Script : http://www.jerseyparties.com/forums/newreply.php
    Referrer : 
    IP Address : 
    Username : Kevin
    Classname : vb_database 

    I did a search and ran this query
    PHP Code:
    CREATE TABLE postindex (
    wordid INT UNSIGNED NOT NULL DEFAULT '0',
    postid INT UNSIGNED NOT NULL DEFAULT '0',
    intitle SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    score SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    UNIQUE KEY wordid (wordidpostid)
    ); 
    That Steve mentioned in this thread. http://www.vbulletin.com/forum/showt...highlight=1146 With no luck.

    Suggestions ?
    Last edited by kevnj; Sun 29th Jan '06, 10:20am.

  • #2
    That thread had a different table. You should not have run that query.

    vBulletin reports that the session table is missing. Open a new support ticket so we can help you better with this matter.

    Comment

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