Group.php Error, Database Error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Brain64
    New Member
    • Nov 2008
    • 9

    Group.php Error, Database Error

    Invalid SQL:
    SELECT cat.socialgroupcategoryid AS categoryid, cat.title, COUNT(socialgroup.groupid)
    AS total

    FROM socialgroupcategory AS cat
    LEFT JOIN socialgroup AS socialgroup
    ON (socialgroup.socialgroupcategoryid = cat.socialgroupcategoryid)

    WHERE socialgroup.groupid IS NOT NULL

    GROUP BY cat.socialgroupcategoryid
    ORDER BY total
    LIMIT 0, 40;

    MySQL Error : Unknown column 'socialgroup.socialgroupcategoryid' in 'on
    clause'
    Error Number : 1054
    Request Date : Friday, November 14th 2008 @ 04:20:51 PM
    Error Date : Friday, November 14th 2008 @ 04:20:51 PM
    Script : http://vfkfansite.com/forums/group.php
    Referrer :
    IP Address : Took out my IP
    Username : Matt.php
    Classname : vB_Database
    MySQL Version : 5.0.51a-community

    ------------------


    Anyone know how to fix this?
  • Steve Machol
    Former Customer Support Manager
    • Jul 2000
    • 154488

    #2
    Looks like a bad upgrade. What did you do exactly prior to this problem starting?
    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

    • Brain64
      New Member
      • Nov 2008
      • 9

      #3
      I was switching hosting and it refused to work afterwords.

      Comment

      • Steve Machol
        Former Customer Support Manager
        • Jul 2000
        • 154488

        #4
        It sounds like you did not make a complete backup of the database. What is the last table listed?
        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

        • Brain64
          New Member
          • Nov 2008
          • 9

          #5
          http://privatepaste.com/6918VIV6fw That is it.
          Last edited by Brain64; Sat 15 Nov '08, 5:59am.

          Comment

          • Steve Machol
            Former Customer Support Manager
            • Jul 2000
            • 154488

            #6
            That is not a vB table. What is the last vB table?
            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

            • Brain64
              New Member
              • Nov 2008
              • 9

              #7
              I have the one's starting with zp and zp_activity, that what you mean?

              Comment

              • Steve Machol
                Former Customer Support Manager
                • Jul 2000
                • 154488

                #8
                I mean there is no such tabkle name in vB. Sorry that was not clear.
                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

                • Brain64
                  New Member
                  • Nov 2008
                  • 9

                  #9
                  I am not understanding what you want from me.

                  Comment

                  • Steve Machol
                    Former Customer Support Manager
                    • Jul 2000
                    • 154488

                    #10
                    I don't want anything from you. I am trying to help you. Please read my previous responses. I'm not sure what else I can tell you.
                    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

                    • Brain64
                      New Member
                      • Nov 2008
                      • 9

                      #11
                      I know, but what tables are you looking for? :\

                      Comment

                      • Dilly
                        Senior Member
                        • Mar 2005
                        • 1812

                        #12
                        Steve has a habit of not being clear. ;-)

                        Try posting a list of the forums that were created when you uploaded the backup (or which tables are listed in the backup). We can then tell you whether the backup was complete or not.

                        Comment

                        • Brain64
                          New Member
                          • Nov 2008
                          • 9

                          #13
                          Well, sorry for the absence. But it worked again until now this is the current error:
                          Database error in vBulletin 3.8.0 Beta 3:

                          Invalid SQL:
                          SELECT cat.socialgroupcategoryid AS categoryid, cat.title, COUNT(socialgroup.groupid) AS total

                          FROM socialgroupcategory AS cat
                          LEFT JOIN socialgroup AS socialgroup
                          ON (socialgroup.socialgroupcategoryid = cat.socialgroupcategoryid)

                          WHERE socialgroup.groupid IS NOT NULL

                          GROUP BY cat.socialgroupcategoryid
                          ORDER BY total
                          LIMIT 0, 40;

                          MySQL Error : Unknown column 'socialgroup.socialgroupcategoryid' in 'on clause'
                          Error Number : 1054
                          Request Date : Sunday, November 23rd 2008 @ 04:20:49 PM
                          Error Date : Sunday, November 23rd 2008 @ 04:20:49 PM
                          Script : Site
                          Referrer : Site
                          IP Address : MYIP
                          Username : Brain
                          Classname : vB_Database
                          MySQL Version : 5.0.51a-community

                          Comment

                          Related Topics

                          Collapse

                          Working...