Announcement

Collapse
No announcement yet.

reputation reset?

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

  • 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 16th Feb '18, 12:45pm.
    https://www.vbulletin.com/forum/foru...re-waiting-for

  • #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


    • #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 customization and demonstration site.
      vBulletin 5 Documentation - Updated every Friday. Report issues here.
      vBulletin 5 API - Full / Mobile
      I am not currently available for vB Messenger Chats.

      Comment


      • #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


        • #5
          Click image for larger version

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

          Comment


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

            Comment


            • #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 customization and demonstration site.
              vBulletin 5 Documentation - Updated every Friday. Report issues here.
              vBulletin 5 API - Full / Mobile
              I am not currently available for vB Messenger Chats.

              Comment


              • #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


                • #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


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

                    Comment


                    • #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 customization and demonstration site.
                      vBulletin 5 Documentation - Updated every Friday. Report issues here.
                      vBulletin 5 API - Full / Mobile
                      I am not currently available for vB Messenger Chats.

                      Comment


                      • #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


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

                          see the last reply

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

                          Comment


                          • #14
                            Originally posted by saiff View Post
                            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

                            TalkNewsUK - My vBulletin 5.4.2 Demo - FEATURING "ROUTE BY NODE"!
                            AdminAmmo - My Cloud Demo

                            Comment


                            • #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

                              Loading...
                              Working...
                              X