Extra Characters in Membernames, Beta-Version

Posts from previous Beta sessions

Re: Extra Characters in Membernames, Beta-Version

Postby Nefuh » Tue Dec 18, 2007 10:11 am

The Characters

Nefuh and Néfuh
Administrator of the german User2User Community for WoWRoster.
Guild Master from Scum from Hell - Horde @ EU-Anetheron.
User avatar
Nefuh
WoWRoster.net Dev Team
WoWRoster.net Dev Team
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 213
Joined: Fri Sep 15, 2006 8:34 pm
Location: Krefeld Germany

Extra Characters in Membernames, Beta-Version

Postby zanix » Tue Dec 18, 2007 10:16 am

Thanks
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

Extra Characters in Membernames, Beta-Version

Postby zanix » Tue Dec 18, 2007 10:53 am

I think I may have fixed this

Code: Select all
ALTER TABLE `roster_memberlog` CHANGE `name` `name` VARCHAR( 64 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL default ''

ALTER TABLE `roster_members` CHANGE `name` `name` VARCHAR( 64 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL default ''

ALTER TABLE `roster_players` CHANGE `name` `name` VARCHAR( 64 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL default ''

ALTER TABLE `roster_pets` CHANGE `name` `name` VARCHAR( 64 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL default ''


Pass this to SQL and try an upload
DO NOT use this with my first change
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

Extra Characters in Membernames, Beta-Version

Postby Nefuh » Tue Dec 18, 2007 11:07 am

Yes this works, now both Chars Nefuh and Néfuh are in the memberlist.

Thanks.

Greets Nefuh
Administrator of the german User2User Community for WoWRoster.
Guild Master from Scum from Hell - Horde @ EU-Anetheron.
User avatar
Nefuh
WoWRoster.net Dev Team
WoWRoster.net Dev Team
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 213
Joined: Fri Sep 15, 2006 8:34 pm
Location: Krefeld Germany

Extra Characters in Membernames, Beta-Version

Postby zanix » Tue Dec 18, 2007 11:52 am

I would like to hear from more users on this issue

This is a change that could have other unforeseen consequences
I have checked MembersList and alt relations and it seems to be ok, but I want the whole story on this change

Please test as much as you can
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

Extra Characters in Membernames, Beta-Version

Postby Holgiranemsi » Tue Dec 18, 2007 4:21 pm

I reinstalled and run the SQL-Statements to alter the tables and everything works fine. But the whole Memberlist is still not maintainable. May be this is a different problem since this happened in all tried solutions.
Holgiranemsi
WR.net Journeyman
WR.net Journeyman
 
Posts: 88
Joined: Fri Feb 16, 2007 12:28 pm

Extra Characters in Membernames, Beta-Version

Postby Holgiranemsi » Tue Dec 18, 2007 5:40 pm

Just to test I took SVN 1486 of the Memberlist and this worked again perfectly. Is there a bug in the 1500 release ?
Holgiranemsi
WR.net Journeyman
WR.net Journeyman
 
Posts: 88
Joined: Fri Feb 16, 2007 12:28 pm

Extra Characters in Membernames, Beta-Version

Postby PleegWat » Tue Dec 18, 2007 7:39 pm

What do you mean with 'is not maintainable'
I <3 /bin/bash
User avatar
PleegWat
WoWRoster.net Dev Team
WoWRoster.net Dev Team
 
Posts: 1636
Joined: Tue Jul 04, 2006 1:43 pm

Extra Characters in Membernames, Beta-Version

Postby Holgiranemsi » Tue Dec 18, 2007 9:02 pm

If I go into the Config-Pages and select "Memberlist" than on the left side all Menuchoices are shown but nothing happens if I klick on them.
In the middle of the screen I have could only restore Defaults or Save them but the functionality is not available.

Now with the rollback to SVN 1486 (Memberlist only) I could click on the menu and the screens then shows me the possible options to be set up.

I completely deleted roster 1.9x and the DB but after reinstalling 1540 the same problem came up.

After deleting everything again, installing 1540 and the deletion of the addon-directoy of Memberlist and moving those from 1486 to its place it worked.
Last edited by Holgiranemsi on Tue Dec 18, 2007 9:04 pm, edited 1 time in total.
Holgiranemsi
WR.net Journeyman
WR.net Journeyman
 
Posts: 88
Joined: Fri Feb 16, 2007 12:28 pm

Extra Characters in Membernames, Beta-Version

Postby Holgiranemsi » Wed Dec 19, 2007 5:50 am

Fixed in 1545 ;-) thanks
Holgiranemsi
WR.net Journeyman
WR.net Journeyman
 
Posts: 88
Joined: Fri Feb 16, 2007 12:28 pm

Extra Characters in Membernames, Beta-Version

Postby zanix » Wed Dec 19, 2007 7:46 am

I'm thinking the field changes might be the best way to go

I would like more input from users that have had this problem
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

Extra Characters in Membernames, Beta-Version

Postby Holgiranemsi » Thu Dec 20, 2007 6:32 pm

Hey Zanix,
so, after updateing to 1545 it works now perfectly in addition with your suggested changes to some tables. The Memberlist was fixed independently in the new release and is now available to be maintained.
We also have no more problems with those Characters in the Charnames.

Thanks a lot for looking into this and spending all that time!
Mery x-Mas, have some nice days.
Holgi
Holgiranemsi
WR.net Journeyman
WR.net Journeyman
 
Posts: 88
Joined: Fri Feb 16, 2007 12:28 pm

Extra Characters in Membernames, Beta-Version

Postby zanix » Sat Dec 22, 2007 7:15 am

It looks like this is a viable fix for this problem
I am applying it to SVN[1556]

If anyone has a problem with this change, please say so
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

Previous

Return to Archived

Who is online

Users browsing this forum: No registered users and 1 guest

cron