Error with Anub'arak server - 1.7.1

by **Snykx** » Wed Oct 25, 2006 5:55 am

After a clean install of 1.7.1, I'm unable to click on the player name in the table. It reports the error "Sorry no data in database for "Snykx" of "Anub\'arak"

I think it might be trying to query with the slash in the name, and therefore (obviously) failing.

http://chuuseishin.onovia.com/roster/

If you remove the name of the server from the URL, it works just fine.

Any ideas, suggestions, or similar problems?

Edit:
Upon further investigation, the server has been entered into the config table in the database that way (with the \). Im not sure if that's supposed to happen, but I'll keep looking around.

by **Snykx** » Wed Oct 25, 2006 6:33 am

This seems to be a problem when a user updates their profile. The \ is not being put into the players table. If I manually add the \, it works just fine.

I'll submit a bug report for this.

by **RainRider** » Wed Oct 25, 2006 8:20 am

Hm, putting a backslash into the players table just makes it escape twice - once for the ' and then for \, leading to Anub\\\'Arak in your case. Or am I wrong?

I thought about using RedirectMatch in a .htaccess with some crazy regex ^^

by **Snykx** » Wed Oct 25, 2006 9:31 am

Yep, If I add the backslash, it does exactly that.

by **Snykx** » Wed Oct 25, 2006 10:10 am

For now, I removed the server from all the links.

if anyone else has this same problem and posts here, I will provide detailed directions on a temp fix.

by **RocRaRa** » Wed Oct 25, 2006 10:20 am

If you could post the temp fix it would be greatly appreciated. This is occuring for me as well due to the server being Kael'thas.

by **Snykx** » Wed Oct 25, 2006 10:46 am

Sure.

Note that this is intended as a temp fix!

memberslist.php
Change line 453 from

Code: Select all: return $tooltip.'<a href="char.php?name='.$row['name'].'&server='.$row['server'].'">'.$row['name'].'</a></div>';

to

Code: Select all: return $tooltip.'<a href="char.php?name='.$row['name'].'">'.$row['name'].'</a></div>';

Change line 464 from

Code: Select all: return '<a href="char.php?name='.$row['name'].'&server='.$row['server'].'">'.$row['name'].'</a>';

to

Code: Select all: return '<a href="char.php?name='.$row['name'].'">'.$row['name'].'</a>';

memberdetails.php
Change line 108 from

Code: Select all: $url = '<a href="?name='.$name.'&server='.$server;

to

Code: Select all: $url = '<a href="?name='.$name;

tradeskills.php
Change line 143 from

Code: Select all: <a href="char.php?name='.$row['name'].'&server='.$roster_conf['server_name'].'&action=recipes">'.$row['name'].'</a>

to

Code: Select all: <a href="char.php?name='.$row['name'].'&action=recipes">'.$row['name'].'</a>

membersinst.php
Change line 327 from

Code: Select all: print '<a href="char.php?name='.$row['name'].'&server='.$roster_conf['server_name'].'">'.$row['name'].'</a><br />'.$row['class'].' ('.$row['level'].')</td>'."\n";

to

Code: Select all: print '<a href="char.php?name='.$row['name'].'">'.$row['name'].'</a><br />'.$row['class'].' ('.$row['level'].')</td>'."\n";

That should cover all the pages. Post any problems or additional questions here

by **zanix** » Wed Oct 25, 2006 12:04 pm

Can you guys go to the page phpinfo.php
And look for what the value of these are

magic_quotes_gpc
magic_quotes_runtime
magic_quotes_sybase

by **Snykx** » Wed Oct 25, 2006 1:02 pm

Off, off and off.

by **zanix** » Wed Oct 25, 2006 1:27 pm

ok, and everyone else?

by **RainRider** » Wed Oct 25, 2006 5:56 pm

Everything "off" too. If I switch them on, I get "Guild not found".

by **zanix** » Wed Oct 25, 2006 10:58 pm

Refer to this post now stickied in the base "General Support & Feedback" forum
http://www.wowroster.net/Forums/viewtopic/t=1600.html