Announcement

Collapse
No announcement yet.

MySQL Database Error When Updating Template

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

  • [Forum] MySQL Database Error When Updating Template

    I just upgraded from 4.0.4 to 4.07 and I receive this error:

    Code:
    Database error in vBulletin 4.0.7:
    
    Invalid SQL:
    
    		SELECT templateid
    		FROM vbftemplate
    		WHERE styleid =  AND title = 'footer';
    
    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 'AND title = 'footer'' at line 3
    Error Number  : 1064
    Request Date  : Saturday, October 2nd 2010 @ 12:13:44 AM
    Error Date    : Saturday, October 2nd 2010 @ 12:13:44 AM
    Script        : http://www.neohioatvriders.com/admincp/template.php?do=updatetemplate
    Referrer      : http://www.neohioatvriders.com/admincp/template.php?do=edit&templateid=946
    IP Address    : 12.177.169.227
    Username      : Mike-
    Classname     : vB_Database
    MySQL Version : 5.0.91-log
    When trying to make changes to my footer template. Why? So far it only happens when trying to update the footer template.

  • #2
    Odd, it looks like the styleid isn't being sent to the query, and it's just the footer template? Is it the default vB style or a custom one?

    Originally posted by TruthElixirX View Post
    I just upgraded from 4.0.4 to 4.07 and I receive this error:

    Code:
    Database error in vBulletin 4.0.7:
    
    Invalid SQL:
    
    		SELECT templateid
    		FROM vbftemplate
    		WHERE styleid =  AND title = 'footer';
    
    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 'AND title = 'footer'' at line 3
    Error Number  : 1064
    Request Date  : Saturday, October 2nd 2010 @ 12:13:44 AM
    Error Date    : Saturday, October 2nd 2010 @ 12:13:44 AM
    Script        : http://www.neohioatvriders.com/admincp/template.php?do=updatetemplate
    Referrer      : http://www.neohioatvriders.com/admincp/template.php?do=edit&templateid=946
    IP Address    : 12.177.169.227
    Username      : Mike-
    Classname     : vB_Database
    MySQL Version : 5.0.91-log
    When trying to make changes to my footer template. Why? So far it only happens when trying to update the footer template.
    Regards,
    Eric Sizemore


    My modifications

    Comment


    • #3
      Just the footer template, yes. Updating any other template within this style works fine. And it is a custom style. Style ID #2.

      I just left the forum, and went back an hour later and it works.

      EDIT:: It saved the template, but now when I go o the forum home page I get "500 Internal Server Error". Forum completely down. This is urgent now.

      I've ha to revert back to the back up of 4.0.4 until I figure out what problem is happening.
      Last edited by TruthElixirX; Sat 2 Oct '10, 12:21am.

      Comment


      • #4
        Bump.

        Comment


        • #5
          500 server error typically is not caused by vbulletin. Did you ask your host to investigate? Did any file permissions get changed?
          sigpic
          Nation of Blue - Kentucky Wildcats Sports


          Some CMS Goodness: Add Avatar to Article

          Comment

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