Announcement

Collapse
No announcement yet.

problem after upgrade

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

  • [Forum] problem after upgrade

    Hello
    Yesterday I did an upgrade vb 405, problems have emerged very much in the database
    When I add a new thread

    Code:
    Database error in vBulletin 4.0.5:
    
    Invalid SQL:
    
    SELECT
    fd.thumbnail_dateline, fd.filesize, IF (fd.thumbnail_filesize> 0, 1, 0) AS hasthumbnail, fd.thumbnail_filesize,
    a.dateline, a.state, a.attachmentid, a.counter, a.contentid, a.filename, a.userid, a.settings, a.displayorder,
    at.contenttypes
    FROM attachment AS a
    INNER JOIN filedata AS fd ON (fd.filedataid = a.filedataid)
    LEFT JOIN attachmenttype AS at ON (at.extension = fd.extension)
    WHERE
    a.posthash = 'c390f33ff81ecda979c6a60b5520afe5'
    AND
    a.userid IN (1)
    AND
    a.contenttypeid =
    
    ORDER BY a.contentid, a.displayorder;
    
    MySQL Error: 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 'ORDER BY a.contentid, a.displayorder' at line 15
    Error Number: 1064
    Request Date: Wednesday, August 4th 2010 @ 07:25:48 PM
    Error Date: Wednesday, August 4th 2010 @ 07:25:48 PM
    Script: http://www.coffeemate1.com/vb/newthread.php?do=newthread&f=36
    Referrer: http://www.coffeemate1.com/vb/forumdisplay.php?f=36
    IP Address: 
    Username: alaml almgro7
    Classname: vB_Database
    MySQL Version: 5.0.91-community-log
    When I open a Private Messages
    Code:
    Database error in vBulletin 4.0.5:
    
    Invalid SQL:
    ();
    
    MySQL Error: 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 ')' at line 1
    Error Number: 1064
    Request Date: Wednesday, August 4th 2010 @ 07:25:00 PM
    Error Date: Wednesday, August 4th 2010 @ 07:25:00 PM
    Script: http://www.coffeemate1.com/vb/private.php
    Referrer: http://www.coffeemate1.com/vb/showthread.php?t=5939
    IP Address:
    Username: alaml almgro7
    Classname: vB_Database
    MySQL Version: 5.0.91-community-log
    When I Add new reply
    Code:
    Database error in vBulletin 4.0.5:
    
    Invalid SQL:
    INSERT INTO searchgroup (username, contenttypeid, groupid, userid, dateline)
    VALUES ('äÇÏÑ æÌæÏí', 0, 5939, 282, 1280939032)
    ON DUPLICATE KEY UPDATE username = VALUES (username), contenttypeid = VALUES (contenttypeid), groupid = VALUES (groupid), userid = VALUES (userid), dateline = VALUES (dateline);
    
    MySQL Error: Table 'name_vb.searchgroup' doesn't exist
    Error Number: 1146
    Request Date: Wednesday, August 4th 2010 @ 07:23:52 PM
    Error Date: Wednesday, August 4th 2010 @ 07:23:52 PM
    Script: http://www.coffeemate1.com/vb/newreply.php?do=postreply&t=5939
    Referrer: http://www.coffeemate1.com/vb/showthread.php?t=5939
    IP Address:
    Username: alaml almgro7
    Classname: vB_Database
    MySQL Version: 5.0.91-community-log
    I hope you help me to solve problems
    Yasser Hamdy

  • #2
    It appears you missed some pretty critical upgrade steps. When upgrading, make sure to start with upgrade.php and it will step you through all upgrade processes as needed.
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API

    Comment

    Related Topics

    Collapse

    Working...
    X