[ABD] Users Reputation System Mod

A place for MOD Authors to post and receive feedback on MODs still in development. No MODs within this forum should be used within a live environment! No new topics are allowed in this forum.
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

IMPORTANT: MOD Development Forum rules

On February 1, 2009 this forum will be set to read only as part of retiring of phpBB2.
Locked
go99live
Registered User
Posts: 206
Joined: Mon May 01, 2006 7:18 pm
Contact:

Post by go99live »

when i click on the votes link i get this error..Can some one please help me

Code: Select all

Could not obtain reputation stats for this user

DEBUG MODE

SQL Error : 1054 Unknown column 'r.user_id_2' in 'where clause'

SELECT COUNT(user_id) AS total_count FROM phpbb_reputation AS r WHERE r.user_id = 161 OR r.user_id_2 = 161

Line : 519
File : reputation.php

User avatar
Pogue Moran
Registered User
Posts: 40
Joined: Mon Mar 27, 2006 7:33 pm
Contact:

Post by Pogue Moran »

go99live wrote: when i click on the votes link i get this error..Can some one please help me

Code: Select all

Could not obtain reputation stats for this user

DEBUG MODE

SQL Error : 1054 Unknown column 'r.user_id_2' in 'where clause'

SELECT COUNT(user_id) AS total_count FROM phpbb_reputation AS r WHERE r.user_id = 161 OR r.user_id_2 = 161

Line : 519
File : reputation.php


Golive usually when you get an unknown column error it means that the sql table doesn't exist. Did you run the sql queries for this mod?

ricky92
Registered User
Posts: 32
Joined: Mon Dec 11, 2006 4:43 pm
Location: Naples, Italy
Contact:

Post by ricky92 »

Can anyone help me? When I go to anoyone's profile I get this error:

Code: Select all

Fatal error: Cannot redeclare get_reputation_medals() in phpBB2/includes/functions_reputation.php on line 32

User avatar
SAFFLEUR
Registered User
Posts: 323
Joined: Thu Nov 24, 2005 5:56 am
Location: Lenoir NC
Contact:

Post by SAFFLEUR »

This is a fabulous Mod you have written here anton. I hope it gets approved soon and released to the database.

I had gotten an error earlier, redeclaring the bbcode function but just include_once fixed it fine.

Again, great Mod 8)

cj1
Registered User
Posts: 26
Joined: Sun Nov 05, 2006 9:46 am

Post by cj1 »

Works very well, thank you. :)

spectre_z2000
Registered User
Posts: 10
Joined: Mon Jul 24, 2006 3:21 am
Contact:

Post by spectre_z2000 »

I am getting this:


Could not obtain post/user information.

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' u.user_reputation FROM phpbb_posts p, phpbb_users u, phpbb_posts_text pt WHER' at line 1

SELECT u.username, u.user_points, u.user_rich, u.user_richest, u.user_cash, u.user_id, u.user_posts, u.user_from, u.user_from_flag, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_custom_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, u.user_birthday, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid, , u.user_reputation FROM phpbb_posts p, phpbb_users u, phpbb_posts_text pt WHERE p.topic_id = 32 AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC LIMIT 0, 15

Line : 625
File : viewtopic.php
NOOERB

jw1re
Registered User
Posts: 4
Joined: Sat Dec 09, 2006 9:47 pm

Post by jw1re »

same here
Image

jw1re
Registered User
Posts: 4
Joined: Sat Dec 09, 2006 9:47 pm

Post by jw1re »

WHEN TRYING TO VIEW A POST

Code: Select all

Could not query reputation config information

DEBUG MODE

SQL Error : 1146 Table 'fallenabov_i10ph.phpbb_reputation_config' doesn't exist

SELECT * FROM phpbb_reputation_config

Line : 31
File : reputation_common.php
Last edited by jw1re on Sun Jan 07, 2007 1:53 am, edited 2 times in total.
Image

jw1re
Registered User
Posts: 4
Joined: Sat Dec 09, 2006 9:47 pm

Post by jw1re »

IN CONTROL PANEL

Code: Select all

phpBB : Critical Error

Could not query config information in admin_board

DEBUG MODE

SQL Error : 1146 Table 'fallenabov_i10ph.phpbb_reputation_config' doesn't exist

SELECT * FROM phpbb_reputation_config

Line : 45
File : admin_reputation.php
Image

ryan1918dotcom
I've Been Banned!
Posts: 478
Joined: Wed Dec 10, 2003 3:10 am
Location: michigan
Contact:

Post by ryan1918dotcom »

What can they do with the points?
Image
http://www.ryan1918.com More than security.

User avatar
champsabin
Registered User
Posts: 59
Joined: Sun Jan 14, 2007 12:46 am

Post by champsabin »

i dont get it ,how do u install this?(i'm a noob :( )
could someone tell me how to do it step by step?
plz? Thank you

User avatar
champsabin
Registered User
Posts: 59
Joined: Sun Jan 14, 2007 12:46 am

Post by champsabin »

i cant even install the lastest version of phpbb
plz someone help

charades
Registered User
Posts: 23
Joined: Fri Oct 20, 2006 12:03 am

Post by charades »

Can anyone help me please...

I have installed it but whenever I click + or - sign it gives me this

Fatal error: Cannot redeclare class bbcode in
XXX/forums/includes/bbcode.php on line 107

I appreciate any help in resolving this issue
Dawn to Dusk....
..Musical Journey on it's own .. only at http://www.suraurtaal.com

Register Today!

http://www.creative-castle.com! ....We Aspire.. What you Desire....

User avatar
stickerboy
Former Team Member
Posts: 7349
Joined: Mon Mar 29, 2004 2:27 pm
Location: Airdrie, UK (127.0.0.1)
Name: Kenny Cameron
Contact:

Post by stickerboy »

@spectre_z2000 - Remove one of the comma's and that should fix it:

Code: Select all

pt.bbcode_uid, , u.user_reputation 
@jw1re - you haven't run the sql queries
they can be found in the MOD here:

Code: Select all

upload\reputation_mod_install_db_v100.php
upload\reputation_mod_install_users_v100.php
Upload the files to your forums root folder and point your browser to that location eg. http://www.myforums.com/phpBB/reputatio ... b_v100.php
Delete the files after they have ben run :wink:

@champsabin - The instructions on how to install this MOD are in the download - "install_reputation_system_v100.txt".
Although you may want to check out this Knowledge Base Article

@charades - open reputation.php and chne this line

Code: Select all

include($phpbb_root_path . 'includes/bbcode.'.$phpEx); 
to this

Code: Select all

include_once($phpbb_root_path . 'includes/bbcode.'.$phpEx); 
If that fails, try removing it from reputation.php altogether :wink:
I'm a web-designing code-decrypting tech-support musician
|| Twitter || Flickr || phpBB Snippets ||
Formerly known as cherokee red

falafelboy
Registered User
Posts: 29
Joined: Fri Oct 06, 2006 10:36 pm
Location: canada
Contact:

Post by falafelboy »

Hi,

The mod is looking great. I would add that an ajax addition would be amazing for the voting.

But on to my problem: When I click the reputation button to add or remove for a user, I get the following error in a new window:
Not Found
The requested URL /forum/reputation,a,add,u,2.html&p=73&c=ba13d6ad was not found on this server.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.


Any ideaS?

thanks.

Locked

Return to “[2.0.x] MODs in Development”