Announcement

Collapse
No announcement yet.

Invalid SQL: SELECT title FROM thread WHERE threadid=

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

  • Invalid SQL: SELECT title FROM thread WHERE threadid=

    Invalid SQL: SELECT title FROM thread WHERE threadid=
    mysql error: You have an error in your SQL syntax near '' at line 1

    >.>

    Everyday I get this and I no one can post
    o.O

  • #2
    How does line 1 from your database.sql look like?
    Do you have any source code modifications installed?

    Comment


    • #3
      Is that the complete error message? There should be more. Also what are you doing when you get this error?
      Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
      Change CKEditor Colors to Match Style (for 4.1.4 and above)

      Steve Machol Photography


      Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


      Comment


      • #4
        Originally posted by xiphoid
        How does line 1 from your database.sql look like?
        Do you have any source code modifications installed?
        # --------------------------------------------------------
        #
        # Table structure for table `thread`
        #
        CREATE TABLE thread (
        threadid int(10) unsigned NOT NULL auto_increment,
        title varchar(100) NOT NULL default '',
        lastpost int(10) unsigned NOT NULL default '0',
        forumid smallint(5) unsigned NOT NULL default '0',
        pollid int(10) unsigned NOT NULL default '0',
        articleid int(10) unsigned NOT NULL default '0',
        open tinyint(4) NOT NULL default '0',
        replycount int(10) unsigned NOT NULL default '0',
        postusername varchar(50) NOT NULL default '',
        postuserid int(10) unsigned NOT NULL default '0',
        lastposter varchar(50) NOT NULL default '',
        dateline int(10) unsigned NOT NULL default '0',
        views int(10) unsigned NOT NULL default '0',
        iconid smallint(5) unsigned NOT NULL default '0',
        notes varchar(250) NOT NULL default '',
        visible smallint(6) NOT NULL default '0',
        sticky smallint(6) NOT NULL default '0',
        votenum smallint(5) unsigned NOT NULL default '0',
        votetotal smallint(5) unsigned NOT NULL default '0',
        attach smallint(5) unsigned NOT NULL default '0',
        PRIMARY KEY (threadid),
        KEY iconid (iconid),
        KEY forumid (forumid,visible,sticky,lastpost)
        ) TYPE=MyISAM;
        # --------------------------------------------------------



        Originally posted by Steve Machol
        Is that the complete error message? There should be more. Also what are you doing when you get this error?
        Database error in vBulletin 2.2.8:

        Invalid SQL: SELECT title FROM thread WHERE threadid=
        mysql error: You have an error in your SQL syntax near '' at line 1

        mysql error number: 1064

        Date: Sunday 24th of November 2002 09:30:17 AM
        Script: http://forums.forestsages.com/newthread.php
        Referer: http://forums.forestsages.com/newthread.php?amp;action=newthread&forumid=33
        Last edited by Forest Sage; Sun 24th Nov '02, 10:03am.
        o.O

        Comment


        • #5
          Reupload the original newthread.php file from the 2.2.8 zip file. Make sure you upload in ASCII and overwrite the one on the server.
          Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
          Change CKEditor Colors to Match Style (for 4.1.4 and above)

          Steve Machol Photography


          Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


          Comment

          widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
          Working...
          X