[Forum] problem after upgrade

[Yasser Hamed]

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

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

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

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

[Wayne Luke]

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.