Announcement

Collapse
No announcement yet.

VB 4.0.6 Data Base Error

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

  • [Forum] VB 4.0.6 Data Base Error

    I am getting reports from members on my forum that they only get this page when they open the site. At first I thought it was a Firefox and Chrome issue, but now I am getting reports on IE8 and Safari on Mac.
    Attached Files

  • #2
    Sometimes I also get this, I upgraded PHP memory limit to 256M... maybe that helped but not sure.

    Good luck.
    I could sell you my unused vB4 Suite license, but I'm not so cruel...

    Comment


    • #3
      Originally posted by CLSSY56 View Post
      I am getting reports from members on my forum that they only get this page when they open the site. At first I thought it was a Firefox and Chrome issue, but now I am getting reports on IE8 and Safari on Mac.
      Can you view the page source for your forum and copy/paste here the full MySQL error please?

      Comment


      • #4
        Here's the message:

        Code:
        <!--
        Database error in vBulletin 4.0.6:
        
        Invalid SQL:
        
          SELECT albumpicture.*, album.*, user.username, user.usergroupid,
          IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid 
          FROM attachment AS albumpicture
          LEFT JOIN album AS album ON(album.albumid = albumpicture.contentid)
          LEFT JOIN user AS user ON(user.userid = album.userid)
          LEFT JOIN userlist AS userlist ON(userlist.userid = album.userid AND userlist.relationid = '0' AND userlist.type = 'buddy')
          WHERE album.state = 'public' and albumpicture.contenttypeid = 8
          WHERE  (album.state = 'public' OR (NOT ISNULL(userlist.relationid) AND album.state = 'private'))
          ORDER BY RAND()
          LIMIT 0, 5;
        
        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 'WHERE  (album.state = 'public' OR (NOT ISNULL(userlist.relationid) AND album.sta' at line 8
        Error Number  : 1064
        Request Date  : Monday, August 23rd 2010 @ 11:06:39 AM
        Error Date    : Monday, August 23rd 2010 @ 11:06:39 AM
        Script        : http://www.horizonrcflyers.com/
        Referrer      : 
        IP Address    : 114.X.X.X
        Username      : Unregistered
        Classname     : vB_Database
        MySQL Version : 
        -->
        Obviously something wrong in the user picture albums....
        To be updated...

        Comment


        • #5
          I couldn't find this query in the standard vB.
          Have you installed any 3rd party add-on which is displaying the album pictures? Try to disable it.

          Comment


          • #6
            It looks like one of those album addons that grabs the pictures.

            Comment

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