Error Number : 1064

[VBIran]

Database error in vBulletin 4.1.1:

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.contentid = 15344
						AND
					a.contenttypeid = 
			) UNION ALL (
				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 = 'b43b4c4d2ebeee8ee56161ec0e95fd64'
						AND
					a.userid IN (16,1)
						AND
					a.contenttypeid = 
			)
ORDER BY 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 ') UNION ALL (
				SELECT
					fd.thumbnail_dateline, fd.filesize, IF(fd.thumbn' at line 13
Error Number  : 1064
Request Date  : Tuesday, March 15th 2011 @ 01:51:51 AM
Error Date    : Tuesday, March 15th 2011 @ 01:51:51 AM
Script        : http://X.com/editpost.php?p=Y&do=editpost
Referrer      : 
IP Address    : M
Username      : Z
Classname     : vB_Database
MySQL Version : 5.0.92-community-log

Hi,
I get this error when i trying to edit post .
I upgrade vbulletin from 3.8 to latest version and all of plugins are disabled .

[Lynne]

Did you get any errors when doing the upgrade? Did you run all the update counters you were told to do after the upgrade? Have you tried rerunning the upgrade script?

[VBIran]

Yes i get some errors in types.php in line 427 .
I try to remove
if (!sizeof($this->contenttypes))
{
throw (new vB_Exception_Critical('No contenttypes found'));
}
Then i go to upgrade.php again ! the error is gone and upgrade completed .
No i dont update the counters.

[Lynne]

It sounds like you don't have any contenttypes then. You need to do the whole upgrade and also do all the counter updating (although I dont' think this issue is with the counters, but you will have issues later on if you don't do that part of the upgrade).

Check your database and see if you have a table called contenttype and how many rows are in it. Also, do you have the forum or suite?

[VBIran]

I have suite version . i am in latest version of vbulletin . upgrade to latest version again?
i have contenttypes that contains
contenttypeid
class
packageid
canplace
cansearch
cantag
canattach
isaggregator
with Indexes : PRIMARY , packageclass
and this :


--------------- Added [DATE]1300146885[/DATE] at [TIME]1300146885[/TIME] ---------------

This problem exists in new thread page too.
I get this error before i remove the line of 427 in types.php :
No contenttypes found on line 427 in /home/x/public_html/vb/vb/types.php

[Lynne]

Is that the only row in your contenttype table? There should be 20 rows if you have the suite.

(I would guess you cannot access your CMS either. Or your blogs?)

[VBIran]

I have blog and cms but i disable cms but i can access BLOG and CMS at all .