vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=252)
-   -   Error Number : 1064 (https://vborg.vbsupport.ru/showthread.php?t=260380)

VBIran 03-14-2011 09:26 PM
Error Number : 1064
 
Code:
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 [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 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 .


All times are GMT. The time now is 09:59 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.00933 seconds
  • Memory Usage 1,734KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (7)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete