PDA

View Full Version : Error Number : 1064


VBIran
03-14-2011, 09:26 PM
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
03-14-2011, 10:17 PM
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
03-14-2011, 10:27 PM
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
03-14-2011, 10:29 PM
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
03-14-2011, 10:39 PM
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 :
http://im.gg/uploaded/14032011-588960.PNG

--------------- Added 1300146885 at 1300146885 ---------------

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
03-15-2011, 12:05 AM
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
03-15-2011, 10:37 PM
I have blog and cms but i disable cms but i can access BLOG and CMS at all .