[ABD] Reputation System

Lghtning4u · Post by **Lghtning4u** » Sun Jan 27, 2013 10:44 pm

vulkan3 wrote:When you press the Clear Reputation System has an error , and no buttons reputation

General Error
SQL ERROR [ mysql4 ]

����������� ������� 'post_rs_count' � 'field list' [1054]

SQL

UPDATE phpbb_posts SET post_rs_count = 0

BACKTRACE

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

FILE: [ROOT]/includes/db/dbal.php
LINE: 757
CALL: trigger_error()

FILE: [ROOT]/includes/db/mysql.php
LINE: 175
CALL: dbal->sql_error()

FILE: [ROOT]/includes/acp/acp_reputation.php
LINE: 83
CALL: dbal_mysql->sql_query()

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

FILE: [ROOT]/adm/index.php
LINE: 74
CALL: p_master->load_active()

This error is coming up, what is the fix?

Pico88 · Post by **Pico88** » Mon Jan 28, 2013 6:12 am

vulkan3 wrote:When you press the Clear Reputation System has an error , and no buttons reputation

Code: Select all

General Error
SQL ERROR [ mysql4 ]

����������� ������� 'post_rs_count' � 'field list' [1054]

SQL

UPDATE phpbb_posts SET post_rs_count = 0

BACKTRACE

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

FILE: [ROOT]/includes/db/dbal.php
LINE: 757
CALL: trigger_error()

FILE: [ROOT]/includes/db/mysql.php
LINE: 175
CALL: dbal->sql_error()

FILE: [ROOT]/includes/acp/acp_reputation.php
LINE: 83
CALL: dbal_mysql->sql_query()

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

FILE: [ROOT]/adm/index.php
LINE: 74
CALL: p_master->load_active()

Open: includes/acp/acp_reputation.php
Find and delete:

Code: Select all

$db->sql_query('UPDATE ' . POSTS_TABLE . ' SET post_rs_count = 0');

vulkan3 · Post by **vulkan3** » Mon Jan 28, 2013 1:13 pm

Find

Code: Select all

<div class="inner"><span class="corners-top"><span></span></span>

Add after

Code: Select all

{postrow.L_RS_HIDE_POST}

Has several occurrences ( 3 times ) which one to choose, and that's what the instructions are very many recurring entries but does not specify exactly what kind of occurrence of use

Lghtning4u · Post by **Lghtning4u** » Mon Jan 28, 2013 6:18 pm

Pico88 wrote:

vulkan3 wrote:When you press the Clear Reputation System has an error , and no buttons reputation

Code: Select all

General Error
SQL ERROR [ mysql4 ]

����������� ������� 'post_rs_count' � 'field list' [1054]

SQL

UPDATE phpbb_posts SET post_rs_count = 0

BACKTRACE

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

FILE: [ROOT]/includes/db/dbal.php
LINE: 757
CALL: trigger_error()

FILE: [ROOT]/includes/db/mysql.php
LINE: 175
CALL: dbal->sql_error()

FILE: [ROOT]/includes/acp/acp_reputation.php
LINE: 83
CALL: dbal_mysql->sql_query()

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

FILE: [ROOT]/adm/index.php
LINE: 74
CALL: p_master->load_active()

Open: includes/acp/acp_reputation.php
Find and delete:

Code: Select all

$db->sql_query('UPDATE ' . POSTS_TABLE . ' SET post_rs_count = 0');

Thanks Pico

That did the trick. Just curious, but the file /includes/acp/acp_reputation.php was not an edited file according to the install_mod.xml. Will that be changed?

Also, I still can't see the icon_rate_good.gif and icon_rate_bad.gif on the posts. Everything else seems to be working.

MichaelMC · Post by **MichaelMC** » Mon Jan 28, 2013 7:00 pm

MichaelMC wrote:Yes, i've done it but as usually receive following error:
Install new version of UMIL
After downloading and install UMIL last version receive the same result ("Reputation system" mod is absent).

Run "install_reputation.php" > redirect me to the ACP automatically.

Still got this error.....Any advice please.

Lghtning4u · Post by **Lghtning4u** » Mon Jan 28, 2013 7:36 pm

MichaelMC wrote:
MichaelMC wrote:Yes, i've done it but as usually receive following error:
Install new version of UMIL
After downloading and install UMIL last version receive the same result ("Reputation system" mod is absent).

Run "install_reputation.php" > redirect me to the ACP automatically.
Still got this error.....Any advice please.

Make sure you are uploading "install_reputation.php" into your root directory. Pointing your browser to http://www.yourdomain.com/install_reputation.php will take you to the ACP and you should see the following

MichaelMC · Post by **MichaelMC** » Mon Jan 28, 2013 7:52 pm

Lghtning4u, it's should appear direclty after run istall_reputation.php?

Pico88 · Post by **Pico88** » Mon Jan 28, 2013 8:06 pm

Did you upload umil dir correctly?

EDIT:
@Lghtning4u, give us a link to your board and create testing account

MichaelMC · Post by **MichaelMC** » Mon Jan 28, 2013 8:09 pm

Pico88 wrote:Did you upload umil dir correctly?

EDIT:
@Lghtning4u, give us a link to your board and create testing account

Yes, like it says in instruction.

Pico88 · Post by **Pico88** » Mon Jan 28, 2013 8:13 pm

So you should see a page like some post above (post made by Lghtning4u).
If you don't see it, you do sth wrong.
You can give us a link to your board and create testing account.

MichaelMC · Post by **MichaelMC** » Mon Jan 28, 2013 9:06 pm

Yea, it's work, problem solved.
It was server side problem. I've run it on my base server and it's work fine.
But have a few mistakes on a screen:

I tried it on my three servers and problem was solved on each of them.

Lghtning4u · Post by **Lghtning4u** » Mon Jan 28, 2013 9:07 pm

Pico88 wrote:Did you upload umil dir correctly?

EDIT:
@Lghtning4u, give us a link to your board and create testing account

Pico

I sent up an account for testing
http://americanfreedomdefenders.com/phpbb/index.php

Username = test account
PW = picotest

Pico88 · Post by **Pico88** » Tue Jan 29, 2013 6:57 am

1. Did you enable post reputation in all forums? Probably not
2. Check permissions.

If you read the topic, you will found clues or answears what to do.

In the first post I wrote:Due to a lack of time I will not reply for any issues/questions, which were solved. Read (search) the whole topic before asking.

Lghtning4u · Post by **Lghtning4u** » Tue Jan 29, 2013 3:17 pm

Pico88 wrote:1. Did you enable post reputation in all forums? Probably not
2. Check permissions.

If you read the topic, you will found clues or answears what to do.

In the first post I wrote:Due to a lack of time I will not reply for any issues/questions, which were solved. Read (search) the whole topic before asking.

Yes, I did enable post reputation in all forum, check permissions numerous times and although I haven't read all 50+ pages here no clues or answers are clear or I wouldn't have posted.

RaidersTalk · Post by **RaidersTalk** » Wed Jan 30, 2013 6:30 pm

I received this error after installing the MOD when I clicked a topic:

Fatal error: Cannot redeclare class reputation in /home/content/72/10025972/html/raiderstalk.com/includes/functions_reputation.php on line 20

I had backed up my forum before the install but now when I restore I still get that error. How do I fix it?

advertisements