DB error

List faction reputation for members

Moderator: ds

DB error

Postby Troublegum » Fri Feb 23, 2007 10:23 am

Hi guys, is it me/my installation that is wrong or is Reputation not synced with recent db-changes? When trying to select a faction I get:

Database Error

1054: Unknown column 'r.value' in 'field list'
SQL:
SELECT m.name member, r.faction, r.name fct_name, r.value, ( substring( r.value, 1, locate('/', r.value)-1) + 0 ) AS curr_rep, ( substring( r.value, locate('/', r.value)+1, length(r.value)-locate('/', r.value)) + 0 ) AS max_rep, r.standing FROM `wowroster_reputation` r, wowroster_members m WHERE r.member_id = m.member_id AND r.name='Argent Dawn' ORDER BY max_rep desc, r.standing DESC, curr_rep DESC
File: membersRep.php
Line: 47
Troublegum
WR.net Apprentice
WR.net Apprentice
 
Posts: 15
Joined: Thu Dec 14, 2006 9:07 am

DB error

Postby danbk » Sat Aug 25, 2007 3:29 am

I get the same error. Was there ever anything mentioned about this?
danbk
WR.net Apprentice
WR.net Apprentice
 
Posts: 14
Joined: Tue Jul 04, 2006 6:09 pm

DB error

Postby ds » Sat Aug 25, 2007 3:45 am

First I have heard of this... I am not getting this error in my v1.7.3 roster Install.
Image
ds
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 297
Joined: Sat Jul 08, 2006 9:58 am


Return to Reputation

Who is online

Users browsing this forum: No registered users and 0 guests

cron