reputation reset?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • saiff
    Senior Member
    • Mar 2010
    • 551

    reputation reset?

    how do I clear the reputation?

    It has reached very high numbers. this is an example of a user (2147483647)


    Version 5.4.0
    Last edited by saiff; Fri 16 Feb '18, 12:45pm.
    https://www.vbulletin.com/forum/foru...re-waiting-for
  • saiff
    Senior Member
    • Mar 2010
    • 551

    #2
    now I wanted to integrate two members from (/admincp/usertools.php?do=merge&
    ) taken out of this error


    Error Invalid SQL: UPDATE reputation SET whoadded = 232602 WHERE whoadded = 193980 /**user_updatereputation2**/;

    Exception trace:
    ## /home/vbvb2/public_html/vb/core/vb/database.php(1189) Exception Thrown
    #0 /home/vbvb2/public_html/vb/core/vb/database/mysqli.php(201): vB_Database->halt()
    #1 /home/vbvb2/public_html/vb/core/vb/database.php(542): vB_Database_MySQLi->execute_query(true, Object(mysqli))
    #2 /home/vbvb2/public_html/vb/core/vb/db/query/stored.php(111): vB_Database->query_write('\n\t\t\t\tUPDATE rep...')
    #3 /home/vbvb2/public_html/vb/core/vb/db/assertor.php(304): vB_dB_Query_Stored->execSQL()
    #4 /home/vbvb2/public_html/vb/core/vb/api/user.php(3960): vB_dB_Assertor->assertQuery('user_updaterepu...', Array)
    #5 /home/vbvb2/public_html/vb/core/admincp/usertools.php(297): vB_Api_User->merge(193980, 232602)
    #6 /home/vbvb2/public_html/vb/includes/api/interface/collapsed.php(142): require_once('/home/vbvb2/pu...')
    #7 /home/vbvb2/public_html/vb/includes/vb5/frontend/controller/relay.php(39): Api_Interface_Collapsed->relay('admincp/usertoo...')
    #8 [internal function]: vB5_Frontend_Controller_Relay->admincp('usertools.php')
    #9 /home/vbvb2/public_html/vb/index.php(74): call_user_func_array(Array, Array)
    https://www.vbulletin.com/forum/foru...re-waiting-for

    Comment

    • Wayne Luke
      vBulletin Technical Support Lead
      • Aug 2000
      • 73981

      #3
      The error above doesn't have anything to do with the amount of reputation. What version of MySQL are you using?

      There is no reset per se. You can adjust the values under Settings -> Options -> User Reputation Options and then rebuild it under Maintenance -> General Update Tools.
      Translations provided by Google.

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

      Comment

      • saiff
        Senior Member
        • Mar 2010
        • 551

        #4
        10.1.31-MariaDB

        I rebuilt the Reputation, but the problem is not solved.

        * the problem has existed since I used vb4
        https://www.vbulletin.com/forum/foru...re-waiting-for

        Comment

        • saiff
          Senior Member
          • Mar 2010
          • 551

          #5
          Click image for larger version

Name:	exx.jpg
Views:	136
Size:	119.8 KB
ID:	4386656screenshot example
          Attached Files
          Last edited by saiff; Sun 18 Feb '18, 12:18pm.
          https://www.vbulletin.com/forum/foru...re-waiting-for

          Comment

          • saiff
            Senior Member
            • Mar 2010
            • 551

            #6
            I'm waiting for your help
            thank you
            https://www.vbulletin.com/forum/foru...re-waiting-for

            Comment

            • Wayne Luke
              vBulletin Technical Support Lead
              • Aug 2000
              • 73981

              #7
              I don't know what is causing the error you're receiving. It is not caused because someone has too many Reputation points so resetting Reputation will do nothing to fix the issue. The query is just updating the Userid from one user record to reflect the user it is being merged into.

              That is a valid query. Could be an issue with your version of MariaDB and the comments. You would have to discuss this with your server administrator. They may have more information about your version of MariaDB. We don't do a lot of explicit testing on it and if we did, it would be the latest version only. MariaDB is supposed to be a drop-in replacement for MySQL and shouldn't require any special handling. This issue doesn't occur on MySQL as far as I am aware.
              Translations provided by Google.

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

              Comment

              • saiff
                Senior Member
                • Mar 2010
                • 551

                #8
                thank you wayne

                I'll talk to the server administrator and let you know.


                the reputation I want to reset it because it has reached its maximum, so it is not working, if there is a way to reset it would be a good thing
                https://www.vbulletin.com/forum/foru...re-waiting-for

                Comment

                • saiff
                  Senior Member
                  • Mar 2010
                  • 551

                  #9
                  hi,
                  the server administrator says that we have the latest version compatible with cpanel.


                  Server version: 10.1.31-MariaDB MariaDB Server

                  https://www.vbulletin.com/forum/foru...re-waiting-for

                  Comment

                  • saiff
                    Senior Member
                    • Mar 2010
                    • 551

                    #10
                    help please
                    https://www.vbulletin.com/forum/foru...re-waiting-for

                    Comment

                    • Wayne Luke
                      vBulletin Technical Support Lead
                      • Aug 2000
                      • 73981

                      #11
                      There is no way to reset the reputation of users built into the system. You can only rebuild it as stated in my first reply.

                      Adjust the numbers under Settings -> Options -> User Reputation Options so it gives out points slower. Then update everyone's reputation under Maintenance -> General Update Tools.

                      The database error you posted is unrelated to the amount of reputation a user has. It is caused by a configuration problem on your server.
                      Translations provided by Google.

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

                      Comment

                      • saiff
                        Senior Member
                        • Mar 2010
                        • 551

                        #12
                        hello,

                        I tried to integrate two other members and I succeeded. I hope I failed on two others
                        https://www.vbulletin.com/forum/foru...re-waiting-for

                        Comment

                        • saiff
                          Senior Member
                          • Mar 2010
                          • 551

                          #13
                          I found this solution. can it also be good for vb5?

                          see the last reply

                          https://www.vbulletin.com/forum/foru...re-waiting-for

                          Comment

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

                            #14
                            Originally posted by saiff
                            I found this solution. can it also be good for vb5?

                            see the last reply

                            https://www.vbulletin.com/forum/foru...max-2147483647
                            More than likely, since the back-end workings of the reputation system haven't really changed much.

                            We can't support any such changes though. Back up your database (or as a minimum, the reputation table) first.
                            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

                            • saiff
                              Senior Member
                              • Mar 2010
                              • 551

                              #15
                              I rebuilt the reputation but the problem is not solved.
                              I integrated two members without problems, but two others failed.
                              https://www.vbulletin.com/forum/foru...re-waiting-for

                              Comment

                              Related Topics

                              Collapse

                              Working...