updated thread count / forum information = post count is zero now ???

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Total666
    Senior Member
    • Jan 2006
    • 158
    • 3.6.x

    updated thread count / forum information = post count is zero now ???

    I was missing some posts in the forum , so I updated thread count / forum information = post count is zero now ??? any ideas ? 3.84 patch level 2 .. thanks

  • Mark.B
    vBulletin Support
    • Feb 2004
    • 24286
    • 6.0.X

    #2
    Should be noted that 3.8.4 is old and unsupported and won't work with latest versions of php.

    With that in mind...what is the php version reported in the admincp?
    MARK.B
    vBulletin Support
    ------------
    My Unofficial vBulletin 6.0.0 Demo: https://www.talknewsuk.com
    My Unofficial vBulletin Cloud Demo: https://www.adminammo.com

    Comment

    • Total666
      Senior Member
      • Jan 2006
      • 158
      • 3.6.x

      #3
      5.6.30 is the PHP version

      Comment

      • Mark.B
        vBulletin Support
        • Feb 2004
        • 24286
        • 6.0.X

        #4
        3.8.4 won't work properly on that.

        You will need to either upgrade vBulletin (3.8.11), which would involve you buying a vB4 license upgrade ($149) to enable you to gain access to the latest versions of vB3.
        OR downgrade php to 5.3.
        Note that php 5.3 is end of life and unsupported. The license upgrade is your best bet.
        MARK.B
        vBulletin Support
        ------------
        My Unofficial vBulletin 6.0.0 Demo: https://www.talknewsuk.com
        My Unofficial vBulletin Cloud Demo: https://www.adminammo.com

        Comment

        • Total666
          Senior Member
          • Jan 2006
          • 158
          • 3.6.x

          #5
          Originally posted by Mark.B
          3.8.4 won't work properly on that.

          You will need to either upgrade vBulletin (3.8.11), which would involve you buying a vB4 license upgrade ($149) to enable you to gain access to the latest versions of vB3.
          OR downgrade php to 5.3.
          Note that php 5.3 is end of life and unsupported. The license upgrade is your best bet.
          Hello , and thanks for the info , Do you think when I upgrade to VB4 my database will be ok ?

          Comment

          • Mark.B
            vBulletin Support
            • Feb 2004
            • 24286
            • 6.0.X

            #6
            Originally posted by Total666

            Hello , and thanks for the info , Do you think when I upgrade to VB4 my database will be ok ?
            There's noothung wrong with your database, otherwise you'd see errors.
            Most likely there's some php code in use that is not compatible with the version of php you are running. If so, this will have been updated in 3.8.11.

            It is impossible to say for certain, however 3.8.4 is definitely NOT compatible with php 5.6, so if you don't upgrade you will likely see other problems over time.
            MARK.B
            vBulletin Support
            ------------
            My Unofficial vBulletin 6.0.0 Demo: https://www.talknewsuk.com
            My Unofficial vBulletin Cloud Demo: https://www.adminammo.com

            Comment

            • Total666
              Senior Member
              • Jan 2006
              • 158
              • 3.6.x

              #7
              I updated to Powered by vBulletin® Version 3.8.11 Beta 3 , the posts / threads are still zero ? Ideas ?

              Comment

              • Mark.B
                vBulletin Support
                • Feb 2004
                • 24286
                • 6.0.X

                #8
                Originally posted by Total666
                I updated to Powered by vBulletin® Version 3.8.11 Beta 3 , the posts / threads are still zero ? Ideas ?
                Why a beta? You need to be on the full and final version.
                MARK.B
                vBulletin Support
                ------------
                My Unofficial vBulletin 6.0.0 Demo: https://www.talknewsuk.com
                My Unofficial vBulletin Cloud Demo: https://www.adminammo.com

                Comment

                • pet0etie
                  New Member
                  • Mar 2010
                  • 18
                  • 3.8.x

                  #9
                  did u try the "admincp > maintenance > update counters > update post count" again ?
                  if u did but the counters stay on zero, i can give u a query to use for updating the posts with one single command

                  Comment

                  • Total666
                    Senior Member
                    • Jan 2006
                    • 158
                    • 3.6.x

                    #10
                    Originally posted by Mark.B

                    Why a beta? You need to be on the full and final version.
                    RE-ran that upgrade script and now it is Powered by vBulletin® Version 3.8.11

                    Comment

                    • Total666
                      Senior Member
                      • Jan 2006
                      • 158
                      • 3.6.x

                      #11
                      Originally posted by pet0etie
                      did u try the "admincp > maintenance > update counters > update post count" again ?
                      if u did but the counters stay on zero, i can give u a query to use for updating the posts with one single command
                      I did re-run the "update the ost count " again , posts are still 0 . Script would be great ,thanks .

                      Comment

                      • pet0etie
                        New Member
                        • Mar 2010
                        • 18
                        • 3.8.x

                        #12
                        using this sql-statement would help to get the counters up-to-date again :

                        Code:
                        update user as U
                        set U.posts = ( SELECT count(*)
                                        FROM post as A,
                                             thread as B,
                                             forum as C
                                        WHERE A.userid = U.userid and A.visible = 1
                                          and A.threadid = B.threadid and B.visible = 1
                                          and B.forumid = C.forumid and (C.options & 4096) )
                        where U.userid = 95
                        use prefixes to the tables users, post, thread and forum if u use that on your forums

                        Comment

                        • Total666
                          Senior Member
                          • Jan 2006
                          • 158
                          • 3.6.x

                          #13
                          Originally posted by pet0etie
                          using this sql-statement would help to get the counters up-to-date again :

                          Code:
                          update user as U
                          set U.posts = ( SELECT count(*)
                          FROM post as A,
                          thread as B,
                          forum as C
                          WHERE A.userid = U.userid and A.visible = 1
                          and A.threadid = B.threadid and B.visible = 1
                          and B.forumid = C.forumid and (C.options & 4096) )
                          where U.userid = 95
                          use prefixes to the tables users, post, thread and forum if u use that on your forums

                          Do I run this in the admin panel ? thanks

                          Comment

                          • pet0etie
                            New Member
                            • Mar 2010
                            • 18
                            • 3.8.x

                            #14
                            u can run this in the admin panel but than u need access to execute sql-commands (which isn't allowed to everyone) ... u need special rights in the config.php-file to do this
                            other possibility is to do it by using phpmyadmin-module (if available) on your hosting-software

                            Comment

                            • pet0etie
                              New Member
                              • Mar 2010
                              • 18
                              • 3.8.x

                              #15
                              just saw one mistake in my query
                              correct version should be

                              Code:
                              update user as U
                               set U.posts = ( SELECT count(*) FROM post as A, thread as B, forum as C WHERE A.userid = U.userid and A.visible = 1 and A.threadid = B.threadid and B.visible = 1 and B.forumid = C.forumid and (C.options & 4096) )
                              FYI : first query did only update for one user (the one with userid = 95)

                              Comment

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