[ABD] Reputation System

Any abandoned Extensions will be moved to this forum.

WARNING: Extensions in this forum are not currently being supported or maintained by the original Extension author. Proceed at your own risk.
Forum rules
IMPORTANT: Extension Development Forum rules

WARNING: Extensions in this forum are not currently being supported nor updated by the original Extension author. Proceed at your own risk.
User avatar
Pico88
Registered User
Posts: 878
Joined: Sat Mar 07, 2009 10:24 pm
Location: Poland
Name: Lukasz

Re: [DEV] Reputation System

Post by Pico88 » Sat Jan 24, 2015 5:48 am

Ninja Scott wrote:I used to run this mod on the older version of phpbb. So I have data in the database.

Furthermore I have updated those tables to work with 3.1.x but I can't find where the post rep count is stored.
Image
So you can see that that post has had positive rep applied but the counter is 0.

Any ideas how to fix this or where that is store in the db?
Post rep count is stored in posts table (post_reputation).
Probably it is a bug. I'll check it later.
Please do not PM me for support.

chasseur.de.dahu
Registered User
Posts: 5
Joined: Mon Jan 19, 2015 6:29 pm

Re: [DEV] Reputation System

Post by chasseur.de.dahu » Sat Jan 24, 2015 7:54 am

bimbargo wrote:And when I disabled extension and tried to remove the data from Admin panel after about 5 minutes received the error. There are about 750 000 posts in the board.

Code: Select all

SQL ERROR [ mysql4 ]

Can't DROP 'post_reputation'; check that column/key exists [1091]

SQL

ALTER TABLE `phpbb_posts` DROP COLUMN `post_reputation`

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 855
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysql.php
LINE: 181
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 329
CALL: phpbb\db\driver\mysql->sql_query()

FILE: [ROOT]/phpbb/db/tools.php
LINE: 1428
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/phpbb/db/tools.php
LINE: 1930
CALL: phpbb\db\tools->_sql_run_sql()

FILE: [ROOT]/phpbb/db/tools.php
LINE: 857
CALL: phpbb\db\tools->sql_column_remove()

FILE: (not given by php)
LINE: (not given by php)
CALL: phpbb\db\tools->perform_schema_changes()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 517
CALL: call_user_func_array()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 463
CALL: phpbb\db\migrator->run_step()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 405
CALL: phpbb\db\migrator->process_data_step()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 358
CALL: phpbb\db\migrator->try_revert()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 354
CALL: phpbb\db\migrator->revert()

FILE: [ROOT]/phpbb/extension/base.php
LINE: 112
CALL: phpbb\db\migrator->revert()

FILE: [ROOT]/ext/pico/reputation/ext.php
LINE: 98
CALL: phpbb\extension\base->purge_step()

FILE: [ROOT]/phpbb/extension/manager.php
LINE: 356
CALL: pico\reputation\ext->purge_step()

FILE: [ROOT]/includes/acp/acp_extensions.php
LINE: 270
CALL: phpbb\extension\manager->purge_step()

FILE: [ROOT]/includes/functions_module.php
LINE: 674
CALL: acp_extensions->main()

FILE: [ROOT]/adm/index.php
LINE: 81
CALL: p_master->load_active()
I have the same error, is that this extension can be enabled / disabled on very big forums (mine: 500 000 messages, 20 0000 members)?

bimbargo
Registered User
Posts: 34
Joined: Sat Jun 03, 2006 7:48 am

Re: [DEV] Reputation System

Post by bimbargo » Sat Jan 24, 2015 8:29 am

Welcome back, Pico88 :)

Ninja Scott
Registered User
Posts: 29
Joined: Thu Jan 10, 2013 7:38 pm

Re: [DEV] Reputation System

Post by Ninja Scott » Sat Jan 24, 2015 6:02 pm

Pico88 wrote:
Ninja Scott wrote:I used to run this mod on the older version of phpbb. So I have data in the database.

Furthermore I have updated those tables to work with 3.1.x but I can't find where the post rep count is stored.
Image
So you can see that that post has had positive rep applied but the counter is 0.

Any ideas how to fix this or where that is store in the db?
Post rep count is stored in posts table (post_reputation).
Probably it is a bug. I'll check it later.
Ah that is what I was missing... So I assume that the new version is basically taking the count from post_rep_positive and the post_rep_negative from the old version and assigning the count to the post_reputation column in the new version....?

User avatar
serek
Registered User
Posts: 50
Joined: Fri Jan 30, 2015 12:47 pm
Location: London
Name: Serge Victor
Contact:

Re: [DEV] Reputation System

Post by serek » Fri Jan 30, 2015 12:51 pm

Hi Łukasz,
are you interested in Polish translation? If yes, should I just clone master on github and send you a pull request?

lukiaensyl
Registered User
Posts: 31
Joined: Tue Oct 28, 2014 8:47 pm

Re: [DEV] Reputation System

Post by lukiaensyl » Tue Feb 03, 2015 4:11 pm

How's development coming along? Can't wait to use this EXT!

User avatar
John connor
Registered User
Posts: 2252
Joined: Fri Nov 14, 2014 5:14 pm
Location: U S Of A
Name: Aaron
Contact:

Re: [DEV] Reputation System

Post by John connor » Wed Feb 04, 2015 1:28 pm

I actually use this on a live board without any trouble that I know of. At least everything seems to be working and there are no errors in ACP.

bimbargo
Registered User
Posts: 34
Joined: Sat Jun 03, 2006 7:48 am

Re: [DEV] Reputation System

Post by bimbargo » Wed Feb 04, 2015 5:33 pm

John connor wrote:I actually use this on a live board without any trouble that I know of. At least everything seems to be working and there are no errors in ACP.
How big is your board, John connor? Because I couldn't install this extension on my board with 750 000 posts and 16 500 users. And in addition I don't want to lose likes from previous version for phpbb 3.0.12.

User avatar
John connor
Registered User
Posts: 2252
Joined: Fri Nov 14, 2014 5:14 pm
Location: U S Of A
Name: Aaron
Contact:

Re: [DEV] Reputation System

Post by John connor » Fri Feb 06, 2015 3:49 pm

Not very big at all. I just installed phpBB in November of last year.

I have a question. With a board that big how big are your backups?

Holger
Registered User
Posts: 1756
Joined: Tue Mar 12, 2002 3:54 pm
Location: Hannover

Re: [DEV] Reputation System

Post by Holger » Fri Feb 06, 2015 5:43 pm

My 3.0.12 has 53K users and 620K posts, the backup is 350MB (gzip)

bimbargo
Registered User
Posts: 34
Joined: Sat Jun 03, 2006 7:48 am

Re: [DEV] Reputation System

Post by bimbargo » Fri Feb 06, 2015 8:08 pm

17 000 users, 750 000 posts, database is 1.1GB. That's mine board. I couldn't install this extension. I missed it, my users missed too :(

User avatar
JupiterGPL
Registered User
Posts: 126
Joined: Thu Jun 08, 2006 4:52 pm
Contact:

Re: [DEV] Reputation System

Post by JupiterGPL » Fri Feb 06, 2015 10:34 pm

I love this EXT. But one thing I did was change the actual thumb image. Users can see the Thumbs up or down a bit easier than the image that comes with this EXT.

If you like this image, feel free to use it. Just replace the original file located in the Rep Ext files:
/ext/pico/reputation/styles/prosilver/theme/images/icons_rating.png


Image

John Q. Public
Registered User
Posts: 11
Joined: Mon Jan 05, 2009 7:03 pm

Re: [DEV] Reputation System

Post by John Q. Public » Sun Feb 08, 2015 4:49 pm

bimbargo wrote:Because I couldn't install this extension on my board with 750 000 posts and 16 500 users.
Oh, please don't say this is going to be one of those extensions that has to modify existing posts. I'd really like to use it, but yeah, if it has to add fields to the Posts or Users table, there's a good chance it's going to time out and maybe break them on big boards. I had a bad experience with one of those a while back.

If it has to do that and it can't be done incrementally, could there at least be a warning on the extension page? Broken databases aren't fun.

bimbargo
Registered User
Posts: 34
Joined: Sat Jun 03, 2006 7:48 am

Re: [DEV] Reputation System

Post by bimbargo » Sun Feb 08, 2015 6:58 pm

This extension try to modify both post and user tables by adding new columns. I install it by bypassing these two steps and adding these columns by hand. It was the only one possible variant for me. It was the same with previous MOD for phpbb 3.0.12.

floxx
Registered User
Posts: 38
Joined: Thu Nov 03, 2011 9:51 pm

Re: [DEV] Reputation System

Post by floxx » Fri Feb 27, 2015 6:18 pm

Is the development of this extension is abandonned...?

Locked

Return to “Abandoned Extensions”