Page 10 of 12

Re: [DEV] Reputation System

Posted: Sat Jan 24, 2015 5:48 am
by Pico88
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.

Re: [DEV] Reputation System

Posted: Sat Jan 24, 2015 7:54 am
by chasseur.de.dahu
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)?

Re: [DEV] Reputation System

Posted: Sat Jan 24, 2015 8:29 am
by bimbargo
Welcome back, Pico88 :)

Re: [DEV] Reputation System

Posted: Sat Jan 24, 2015 6:02 pm
by Ninja Scott
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....?

Re: [DEV] Reputation System

Posted: Fri Jan 30, 2015 12:51 pm
by serek
Hi Ɓukasz,
are you interested in Polish translation? If yes, should I just clone master on github and send you a pull request?

Re: [DEV] Reputation System

Posted: Tue Feb 03, 2015 4:11 pm
by lukiaensyl
How's development coming along? Can't wait to use this EXT!

Re: [DEV] Reputation System

Posted: Wed Feb 04, 2015 1:28 pm
by 2600
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.

Re: [DEV] Reputation System

Posted: Wed Feb 04, 2015 5:33 pm
by bimbargo
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.

Re: [DEV] Reputation System

Posted: Fri Feb 06, 2015 3:49 pm
by 2600
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?

Re: [DEV] Reputation System

Posted: Fri Feb 06, 2015 5:43 pm
by Holger
My 3.0.12 has 53K users and 620K posts, the backup is 350MB (gzip)

Re: [DEV] Reputation System

Posted: Fri Feb 06, 2015 8:08 pm
by bimbargo
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 :(

Re: [DEV] Reputation System

Posted: Fri Feb 06, 2015 10:34 pm
by JupiterGPL
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

Re: [DEV] Reputation System

Posted: Sun Feb 08, 2015 4:49 pm
by John Q. Public
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.

Re: [DEV] Reputation System

Posted: Sun Feb 08, 2015 6:58 pm
by bimbargo
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.

Re: [DEV] Reputation System

Posted: Fri Feb 27, 2015 6:18 pm
by floxx
Is the development of this extension is abandonned...?