Guild with special character

Installation issues with WoWRoster

Guild with special character

Postby azbiohaz » Fri Jan 05, 2007 6:00 am

The guild name when WoWRoster updates shows up 'Touchè' rather than 'Touchè' in the bottom where it shows SQL Queries. I have looked for the forums but only have found special character regarding siggen. Thanks for your help.
Last edited by azbiohaz on Fri Jan 05, 2007 8:12 am, edited 3 times in total.
azbiohaz
WR.net Apprentice
WR.net Apprentice
 
Posts: 7
Joined: Fri Jan 05, 2007 5:52 am

Guild with special character

Postby jgl75 » Fri Jan 05, 2007 8:07 am

I have the same issue...

I cannot upload my guild informations because of it...
jgl75
WR.net Apprentice
WR.net Apprentice
 
Posts: 1
Joined: Mon Aug 21, 2006 11:59 am

Guild with special character

Postby azbiohaz » Sat Jan 06, 2007 5:26 pm

Is there anything I can do to try and fix this?
azbiohaz
WR.net Apprentice
WR.net Apprentice
 
Posts: 7
Joined: Fri Jan 05, 2007 5:52 am

Guild with special character

Postby ds » Sat Jan 06, 2007 5:58 pm

I could be totally wrong but try something like this:

Find in File: update.php (About line 291)
Code: Select all
            // Only allow realms specified in config
            
if( $realm_name == $roster_conf['server_name'])
            { 


Change to:
Code: Select all
            // Only allow realms specified in config
            
if( $realm_name == utf8_encode($roster_conf['server_name']))
            { 


Might be other places it will error out, but at least this might give an idea if this is the correct direction or not.
Image
ds
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 297
Joined: Sat Jul 08, 2006 9:58 am

Guild with special character

Postby azbiohaz » Sat Jan 06, 2007 7:24 pm

I tried this and still receiving the same error.

Code: Select all
SELECT `config_name`, `config_value` FROM `roster_config` ORDER BY `id` ASC;
SELECT * FROM `roster_guild` WHERE `guild_name` = 'Touchè' AND `server` = 'Maiev'
SELECT `guild_id`, `guild_dateupdatedutc` FROM `roster_guild` WHERE `guild_name` = 'Touchè' AND `server` ='Maiev'


Thanks for your help
azbiohaz
WR.net Apprentice
WR.net Apprentice
 
Posts: 7
Joined: Fri Jan 05, 2007 5:52 am

Guild with special character

Postby zanix » Sat Jan 06, 2007 7:36 pm

Enter Touchè as your guild name in Roster config
If that doesn't work, then enter Touchè

Let me know what works and what does not
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: 5543
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Guild with special character

Postby azbiohaz » Sat Jan 06, 2007 7:58 pm

Yea I've tried both and neither seem to work. After inserting Touchè I get:
Code: Select all
SELECT `config_name`, `config_value` FROM `roster_config` ORDER BY `id` ASC;
SELECT * FROM `roster_guild` WHERE `guild_name` = 'Touch�¨' AND `server` = 'Maiev'
SELECT `guild_id`, `guild_dateupdatedutc` FROM `roster_guild` WHERE `guild_name` = 'Touch�¨' AND `server` ='Maiev'


After doing just Touchè, I get the problem above. Thanks for your help
azbiohaz
WR.net Apprentice
WR.net Apprentice
 
Posts: 7
Joined: Fri Jan 05, 2007 5:52 am

Guild with special character

Postby zanix » Sat Jan 06, 2007 8:21 pm

Very odd

Try this, using phpmyadmin
Go to your Roster database
Under the table 'roster_config'
Edit the row 'guild_name' and enter your guild name
Try both ways I said
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: 5543
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Guild with special character

Postby azbiohaz » Sat Jan 06, 2007 9:53 pm

Wow I feel like a complete IDIOT. I forgot to update my characterprofiler and it was not compatible with the newest Guildprofiler so it was not saving the guild information. Thanks for your help Zanix, sorry I'm such an idiot.
azbiohaz
WR.net Apprentice
WR.net Apprentice
 
Posts: 7
Joined: Fri Jan 05, 2007 5:52 am

Guild with special character

Postby zanix » Sat Jan 06, 2007 10:05 pm

... :scratch: :roll: :thumright:
No problem, glad I could help

By the way, which worked, were you able to enter Touchè in Roster Config?
Or did you have to use Touchè
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: 5543
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Guild with special character

Postby azbiohaz » Sat Jan 06, 2007 10:47 pm

I was able to use my actual guild name Touchè
azbiohaz
WR.net Apprentice
WR.net Apprentice
 
Posts: 7
Joined: Fri Jan 05, 2007 5:52 am

Guild with special character

Postby zanix » Sat Jan 06, 2007 10:56 pm

Ah, nice
That means the config panel converts it correctly
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: 5543
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Guild with special character

Postby dmentia » Fri Jan 12, 2007 1:39 am

I am having the same issue. I get this error:

Could not find guild in database. Please update members first.

My SQL Queries are:

SELECT `config_name`, `config_value` FROM `roster_config` ORDER BY `id` ASC;
SELECT * FROM `roster_guild` WHERE `guild_name` = 'Èvil Inc' AND `server` = 'Dethecus'

My Guild Name is Èvil Inc. I am useing the most upto date downloads and they are intalled as instructed.
dmentia
WR.net Apprentice
WR.net Apprentice
 
Posts: 12
Joined: Mon Dec 25, 2006 10:19 pm

Guild with special character

Postby dmentia » Sun Jan 14, 2007 4:25 pm

Ok, I have done some tinkering and what not, I re-installed the roster, database tables and addons. This is the error I am now getting. I have the latest files available for download. So what gives?

Parsing files

Parsed CharacterProfiler in 1.73 seconds

Could not find guild in database. Please update members first.NOT Updating Guild list for ȶil Inc
Data is from GuildProfiler v
The version of GuildProfiler used to capture data for this guild is older than the minimum version allowed for upload.
Please ensure you are running at least v2.0.0
Guild: Èvil Inc @ Server: Dethecus Ignored
dmentia
WR.net Apprentice
WR.net Apprentice
 
Posts: 12
Joined: Mon Dec 25, 2006 10:19 pm

Guild with special character

Postby dmentia » Wed Jan 17, 2007 12:51 am

Can I get any support at all? I have been over everything I can find and there is nothing that gives me any hint as to how to fixes this. I have tried re-downloading and installing everything and get the same error.
dmentia
WR.net Apprentice
WR.net Apprentice
 
Posts: 12
Joined: Mon Dec 25, 2006 10:19 pm

Next

Return to Installation

Who is online

Users browsing this forum: No registered users and 0 guests