Database error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Ron G
    Senior Member
    • Jun 2002
    • 145
    • 4.0.x

    [Forum] Database error

    When I try to change the articles on the Home page from the default to my own, I am unable to do so and I get a database error:

    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 6
    Error Number : 1064

    I am using MySQL 5.0 This happens every time I try to modify an article. Any suggestions?
  • Dody
    Senior Member
    • Aug 2004
    • 1896
    • 3.8.x

    #2
    Would you please post the whole error.
    while(true){
    if(
    $someone->needsHelp() && $i->canHelp()) $post->help();
    if(
    $i->findBug()) $post->bug();
    }

    Comment

    • Ron G
      Senior Member
      • Jun 2002
      • 145
      • 4.0.x

      #3
      Sure:

      Database error in vBulletin 4.0.0:

      Invalid SQL:

      SELECT
      data.thumbnail_width, data.thumbnail_height, data.width, data.height
      FROM attachment AS attach
      INNER JOIN filedata AS data ON (data.filedataid = attach.filedataid)
      WHERE
      attach.attachmentid =;

      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 6
      Error Number : 1064
      Request Date : Wednesday, December 23rd 2009 @ 10:52:19 AM
      Error Date : Wednesday, December 23rd 2009 @ 10:52:20 AM
      Script : http://www.immigration-information.com/forums/content/40-welcome-to-the-new-cms-read-me-first.html
      Referrer : http://www.immigration-information.com/forums/content.php?r=40-Welcome-to-the-new-CMS-Read-me-first/edit
      IP Address : 72.54.122.214
      Username : Ron Gotcher
      Classname : vB_Database
      MySQL Version : 5.0.81-log

      Comment

      • Dody
        Senior Member
        • Aug 2004
        • 1896
        • 3.8.x

        #4
        Looks like a bug for me.
        while(true){
        if(
        $someone->needsHelp() && $i->canHelp()) $post->help();
        if(
        $i->findBug()) $post->bug();
        }

        Comment

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