Announcement

Collapse
No announcement yet.

Database error

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

  • Database error

    i have this error
    Code:
    [FONT=Consolas][SIZE=3]Database error in vBulletin 3.8.0:[/SIZE][/FONT]
    [FONT=Consolas][SIZE=3] [/SIZE][/FONT]
    [FONT=Consolas][SIZE=3]Invalid SQL:[/SIZE][/FONT]
    [FONT=Consolas][SIZE=3] [/SIZE][/FONT]
    [SIZE=3][FONT=Consolas]                        SELECT SQL_CALC_FOUND_ROWS[/FONT][/SIZE]
    [SIZE=3][FONT=Consolas]                             gm.*, user.*, gm.ipaddress AS messageipaddress[/FONT][/SIZE]
    [FONT=Consolas][SIZE=3]                             [/SIZE][/FONT]
    [SIZE=3][FONT=Consolas]                             ,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight, customavatar.width_thumb AS avwidth_thumb, customavatar.height_thumb AS avheight_thumb, filedata_thumb, NOT ISNULL(customavatar.userid) AS hascustom[/FONT][/SIZE]
    [FONT=Consolas][SIZE=3]                             [/SIZE][/FONT]
    [SIZE=3][FONT=Consolas]                        FROM groupmessage AS gm[/FONT][/SIZE]
    [SIZE=3][FONT=Consolas]                        LEFT JOIN user AS user ON (gm.postuserid = user.userid)[/FONT][/SIZE]
    [SIZE=3][FONT=Consolas]                        LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)[/FONT][/SIZE]
    [FONT=Consolas][SIZE=3]                        [/SIZE][/FONT]
    [FONT=Consolas][SIZE=3]                        [/SIZE][/FONT]
    [SIZE=3][FONT=Consolas]                        WHERE gm.groupid = 21[/FONT][/SIZE]
    [SIZE=3][FONT=Consolas]                             AND ((gm.postuserid = 17135 AND state = 'moderation') OR gm.state IN ('visible'))[/FONT][/SIZE]
    [FONT=Consolas][SIZE=3]                             [/SIZE][/FONT]
    [SIZE=3][FONT=Consolas]                        ORDER BY gm.dateline DESC[/FONT][/SIZE]
    [SIZE=3][FONT=Consolas]                        LIMIT 0, 10;[/FONT][/SIZE]
    [FONT=Consolas][SIZE=3] [/SIZE][/FONT]
    [FONT=Consolas][SIZE=3]MySQL Error   : Unknown column 'gm.groupid' in 'where clause'[/SIZE][/FONT]
    [FONT=Consolas][SIZE=3]Error Number  : 1054[/SIZE][/FONT]
    [FONT=Consolas][SIZE=3]Request Date  : Friday, January 9th 2009 @ 02:24:37 PM[/SIZE][/FONT]
    [FONT=Consolas][SIZE=3]Error Date    : Friday, January 9th 2009 @ 02:24:37 PM[/SIZE][/FONT]
    [FONT=Consolas][SIZE=3]Script        : [/SIZE][/FONT][URL="http://forum.giardinaggio.it/group.php?groupid=21"][FONT=Consolas][SIZE=3][COLOR=#0000ff]http://forum.giardinaggio.it/group.php?groupid=21[/COLOR][/SIZE][/FONT][/URL]
    [FONT=Consolas][SIZE=3]Referrer      : [/SIZE][/FONT][URL="http://forum.giardinaggio.it/member.php?u=17135"][FONT=Consolas][SIZE=3][COLOR=#0000ff]http://forum.giardinaggio.it/member.php?u=17135[/COLOR][/SIZE][/FONT][/URL]
    [FONT=Consolas][SIZE=3]IP Address    : xxxx[/SIZE][/FONT]
    [FONT=Consolas][SIZE=3]Username      : xxxx[/SIZE][/FONT]
    [FONT=Consolas][SIZE=3]Classname     : vB_Database[/SIZE][/FONT]
    [FONT=Consolas][SIZE=3]MySQL Version :[/SIZE][/FONT]
    please help me.

    tnx Mauro

  • #2
    Have you messed about the the SQL?

    Comment


    • #3
      mysql version is : 5.0.51a-3ubuntu5.4

      and an another problem is :


      SELECT groupmessage.*, socialgroup.creatoruserid AS group_ownerid
      FROM groupmessage AS groupmessage
      LEFT JOIN socialgroup AS socialgroup ON (groupmessage.groupid = socialgroup.groupid)
      WHERE groupmessage.gmid = 4153;

      MySQL Error : Unknown column 'groupmessage.groupid' in 'on clause'
      Error Number : 1054
      Request Date : Friday, January 9th 2009 @ 10:59:14 AM
      Error Date : Friday, January 9th 2009 @ 10:59:15 AM
      Script : http://forum.giardinaggio.it/group.php?do=discuss&gmid=4153
      Referrer :
      IP Address : 66.249.65.166
      Username : Non registrato
      Classname : vB_Database
      MySQL Version :

      Comment


      • #4
        You have an out of date modification. I believe older versions of vbSEO cause this error. You should be running the latest versions of all your addons and modifications.
        Translations provided by Google.

        Wayne Luke
        The Rabid Badger - a vBulletin Cloud demonstration site.
        vBulletin 5 API

        Comment


        • #5
          tnx , now try.

          Mauro

          Comment


          • #6
            Try what?
            Translations provided by Google.

            Wayne Luke
            The Rabid Badger - a vBulletin Cloud demonstration site.
            vBulletin 5 API

            Comment


            • #7
              Code:
              alter table `groupmessage` add `groupid` int(10) unsigned NOT NULL;

              Comment

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