Sudden SQL error

Dragonfly integration forum

Sudden SQL error

Postby RottGutt » Fri Nov 10, 2006 9:27 am

I just started getting the following SQL error:

Code: Select all
On /index.php?name=wowrosterdf&file=addon&roster_addon_name=reputation&factionfilter=Stormpike+Guard
While executing query " AND r.name='Stormpike Guard' ORDER BY max_rep desc, r.standing DESC, curr_rep DESC"

the following error occuredYou have an error in your SQL syntaxcheck the manual that corresponds to your MySQL server version for the right syntax to use near 'AND r.name='Stormpike Guard' ORDER BY max_rep desc, r.standing DESC, curr_rep DE' at line 1

In
: /home/freak6/public_html/modules/wowrosterdf/lib/wowdb.php on line59


My line 59 reads:

Code: Select all
return $db->sql_query($querystr); 


I get the error no matter which Faction I select. Any clues on how to rectify this? It just started doing it for no reason that I can think of.

RottGutt
RottGutt
WR.net Journeyman
WR.net Journeyman
 
Posts: 92
Joined: Sun Aug 13, 2006 12:07 am

Sudden SQL error

Postby zanix » Fri Nov 10, 2006 2:08 pm

Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5546
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Re: Sudden SQL error

Postby RottGutt » Fri Nov 10, 2006 11:37 pm

zanix wrote:http://www.wowroster.net/Forums/viewtopic/p=9619.html#9619


Thank you zanix! I do not know how I missed that post!

RottGutt
RottGutt
WR.net Journeyman
WR.net Journeyman
 
Posts: 92
Joined: Sun Aug 13, 2006 12:07 am


Return to Dragonfly

Who is online

Users browsing this forum: No registered users and 1 guest

cron