I am currently experiencing some problems with the install of the mod, 'Alternative repuation system 2' to be put onto my forum.
I have followed all the guidelines in the readme. When it comes to me going to the plug in manager and installing these first of all,
The 'Alternative Reputation System Recount Tool' when i try to install this via plug in manager, It says plug in activated then when it takes me back to the plug in manager nothing has changed and infact it hasnt been activated.
When I come to activate the 'Alternative Reputation System' I get the following SQL error:
mySQL error: 1060
Duplicate column name 'reported'
Query: ALTER TABLE reputation ADD `reported` CHAR( 3 ) NOT NULL, ADD `reason` VARCHAR( 255 ) NOT NULL, ADD `showtoall` VARCHAR( 3 ) DEFAULT 'yes' NOT NULL, ADD `reportedby` SMALLINT( 6 ) NOT NULL
As always, Help is very much appreciated and I would love to have this fixed and installed. Thanks guys.
Quote:The 'Alternative Reputation System Recount Tool' when i try to install this via plug in manager, It says plug in activated then when it takes me back to the plug in manager nothing has changed and infact it hasnt been activated.
Have u made sure that your board wasn't changed? i mean if you still have the old system after doing that.
regards
zaher1988 Wrote:Quote:The 'Alternative Reputation System Recount Tool' when i try to install this via plug in manager, It says plug in activated then when it takes me back to the plug in manager nothing has changed and infact it hasnt been activated.
Have u made sure that your board wasn't changed? i mean if you still have the old system after doing that.
regards
I dont understand what you mean? I have recently upgraded to 1.1.1??
i meant upon activating, you see that the activate/deactivate button is still activate right ?
so have you tried to go to your board, have a look what reputation system is being used at that time, is it ARS or the default
regards
zaher1988 Wrote:i meant upon activating, you see that the activate/deactivate button is still activate right ?
so have you tried to go to your board, have a look what reputation system is being used at that time, is it ARS or the default
regards
Yes thats correct. The main reputation system which was originally being used on my board has dissapeared from posts. Their isnt a way to send rep to others from posts anymore. However the reputation window is still their in the user cp.
okay,
in the posts, do u see the reputation system then way it is on my board?
regards
*btw you have posted the code, in the wrong board
it should be in the thread on my board
Antony Wrote:The 'Alternative Reputation System Recount Tool' when i try to install this via plug in manager, It says plug in activated then when it takes me back to the plug in manager nothing has changed and infact it hasnt been activated.
That plugin is just a tool. It recounts the reputation points. I made it so that it will stay deactivated, so you don't have to click deactivate and activate to use it again.
Antony Wrote:When I come to activate the 'Alternative Reputation System' I get the following SQL error:
mySQL error: 1060
Duplicate column name 'reported'
Query: ALTER TABLE reputation ADD `reported` CHAR( 3 ) NOT NULL, ADD `reason` VARCHAR( 255 ) NOT NULL, ADD `showtoall` VARCHAR( 3 ) DEFAULT 'yes' NOT NULL, ADD `reportedby` SMALLINT( 6 ) NOT NULL
Have you used ARS before? It seems that the plugin wasn't deactivated correctly. I have some manual instructions on how you can make sure it works correctly (Because I don't know for sure which things are still there and which aren't)
Quote:If you want to do this:
Make sure you have access to a phpmyadmin similar tool.
* Browse through the table mybb_settings and delete all rows starting with nars_
* Browse through the table mybb_settinggroups and delete the row named Alternative Reputation System Settings
* Browse through the table mybb_templates and delete the following templates: 'reputation2', 'reputation_add_ars', 'reputation_update', 'reputation2_report', 'reputation2_delete', 'nars_report', 'nars_not_enough_posts', 'nars_empty_comment'
* Look at the structure of the table mybb_reputation and delete the fields reported , reason , showtoall , reportedby
* Look at the structure of the table mybb_users and delete the field reportwarnings
* Browse the table mybb_datachache and edit the row called plugins. Delete s:4:"nars";s:4:"nars"; and you'll see something like this: a:1:{s:6:"active";a:12:{. You might have other numbers. But you have to diminish the last one after a: with 1. (this will "deactivate" the plugin")
Now the template changes. I assume you know how to edit the templates.
* index template: delete $nars_report
* member_profile template: replace <!-- NARS_2_4 --> with <td class="trow1"><strong>$lang->rating</strong></td>
<td class="trow1">$ratestars $ratelink</td>
* postbit template: replace nars_replink with replink
Now the file changes.
* open jscripts/general.js and find: reputation2.php replace with reputation.php
After that you can install the file again like stated in the README instructions.
zaher1988 Wrote:okay,
in the posts, do u see the reputation system then way it is on my board?
regards
Nope I dont.
Smethead Wrote:Antony Wrote:The 'Alternative Reputation System Recount Tool' when i try to install this via plug in manager, It says plug in activated then when it takes me back to the plug in manager nothing has changed and infact it hasnt been activated.
That plugin is just a tool. It recounts the reputation points. I made it so that it will stay deactivated, so you don't have to click deactivate and activate to use it again.
Antony Wrote:When I come to activate the 'Alternative Reputation System' I get the following SQL error:
mySQL error: 1060
Duplicate column name 'reported'
Query: ALTER TABLE reputation ADD `reported` CHAR( 3 ) NOT NULL, ADD `reason` VARCHAR( 255 ) NOT NULL, ADD `showtoall` VARCHAR( 3 ) DEFAULT 'yes' NOT NULL, ADD `reportedby` SMALLINT( 6 ) NOT NULL
Have you used ARS before? It seems that the plugin wasn't deactivated correctly. I have some manual instructions on how you can make sure it works correctly (Because I don't know for sure which things are still there and which aren't)
Quote:If you want to do this:
Make sure you have access to a phpmyadmin similar tool.
* Browse through the table mybb_settings and delete all rows starting with nars_
* Browse through the table mybb_settinggroups and delete the row named Alternative Reputation System Settings
* Browse through the table mybb_templates and delete the following templates: 'reputation2', 'reputation_add_ars', 'reputation_update', 'reputation2_report', 'reputation2_delete', 'nars_report', 'nars_not_enough_posts', 'nars_empty_comment'
* Look at the structure of the table mybb_reputation and delete the fields reported , reason , showtoall , reportedby
* Look at the structure of the table mybb_users and delete the field reportwarnings
* Browse the table mybb_datachache and edit the row called plugins. Delete s:4:"nars";s:4:"nars"; and you'll see something like this: a:1:{s:6:"active";a:12:{. You might have other numbers. But you have to diminish the last one after a: with 1. (this will "deactivate" the plugin")
Now the template changes. I assume you know how to edit the templates.
* index template: delete $nars_report
* member_profile template: replace <!-- NARS_2_4 --> with <td class="trow1"><strong>$lang->rating</strong></td>
<td class="trow1">$ratestars $ratelink</td>
* postbit template: replace nars_replink with replink
Now the file changes.
* open jscripts/general.js and find: reputation2.php replace with reputation.php
After that you can install the file again like stated in the README instructions.
Thanks for the help.. If i took the steps you have done above could this totally reck my board up? I'm kinda new with phpmyadmin and just dont want my whole board messing up because of it.
Thanks again.
If you follow the steps exactly like they are written above, nothing will go wrong with your board.
Except the last step in the phpmyadmin where you have to edit the active plugins, you don't need to do that if the plugin isn't activated.
It's also possible that you can't find all things in the database, but everything you can find must be removed anyway.