Announcement

Collapse
No announcement yet.

Users with 2,147,483,650 posts

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

  • #16
    Thats a query with a subquery no?

    Thanks for the help Jason

    Comment


    • #17
      Originally posted by Zachery View Post
      Thats a query with a subquery no?

      Thanks for the help Jason
      Yeah, it's called a "Correlated Subquery". It's where the subquery actually references a table that appears in the outer query.
      Jason Litka - Utter Ramblings

      Comment


      • #18
        Jason - you _saved_my_ass! Worked flawlessly.

        If you're ever in OC, beers are on me

        Thanks guys.

        Comment


        • #19
          Originally posted by wiredinoc View Post
          Jason - you _saved_my_ass! Worked flawlessly.

          If you're ever in OC, beers are on me

          Thanks guys.
          I'm glad to hear that it worked out for you. One thing though, where is "OC"? I'm not familiar with that abbreviation?
          Jason Litka - Utter Ramblings

          Comment


          • #20
            California, Orange County.

            Comment


            • #21
              Ahh... I don't get out that way very often. I've got an Uncle in So Cal but I haven't been out to visit him in years.
              Jason Litka - Utter Ramblings

              Comment


              • #22
                Originally posted by Floris View Post
                This is a known bug in 3.6, upgrading to 3.6.5 will resolve this.

                http://www.vbulletin.com/forum/proje...?issueid=21292
                thx, but in my site, this problem persist
                some other suggestion?

                Comment


                • #23
                  Please upgrade to 3.6.7PL1 then if you still have this problem start your own thread.
                  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


                  • #24
                    Originally posted by Hi MaTT View Post
                    thx, but in my site, this problem persist
                    some other suggestion?
                    Upgrading will fix the cause of the problem but it will not repair your data. Any corrupted users will still have the high post count.

                    I made a post over here that gives a query you can run that will "fix" the users with 2,147,483,650 posts.
                    Jason Litka - Utter Ramblings

                    Comment

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