sql issue

Requests, feedback, and general discussion about WoWRoster
DO NOT post topics about WoWRoster AddOns here!

sql issue

Postby civette » Mon Mar 19, 2007 9:28 pm

Hi,

I got an issue to upload the profile of one of my guildmates....

His name is "ßoroxor" (with a beta and not a B) within the lua this becomes "ßoroxor"

When uploading, he has a message "ßoroxor is not in the list of guild members so their data will not be inserted.", altough he is....

The query checking this is (in lib/wowdb.lua) "SELECT `member_id` FROM `roster_members` WHERE `name` = 'ßoroxor' AND `guild_id` = '1'" and it returns nothing because the name field in that table is "ßoroxor"... So I tested following : I replaced in the DB "ßoroxor" by "ßoroxor".

On upload, I get the same the same message "ßoroxor is not in the list of guild members so their data will not be inserted."

Running the query with phpmyadmin returns 1 row, the same query trough the web page returns nothing...

Any idea of what to check ?

Thx,
civette
WR.net Apprentice
WR.net Apprentice
 
Posts: 8
Joined: Tue Jul 04, 2006 5:28 pm

sql issue

Postby civette » Tue Mar 20, 2007 7:06 pm

Anyway, it works now....

Re uploaded the guild
civette
WR.net Apprentice
WR.net Apprentice
 
Posts: 8
Joined: Tue Jul 04, 2006 5:28 pm


Return to General Support & Feedback

Who is online

Users browsing this forum: No registered users and 1 guest

cron