Error with Anub'arak server - 1.7.1

Installation issues with WoWRoster

Error with Anub'arak server - 1.7.1

Postby 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.
Last edited by Snykx on Wed Oct 25, 2006 6:00 am, edited 1 time in total.
User avatar
Snykx
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 29
Joined: Wed Oct 18, 2006 10:09 am

Error with Anub'arak server - 1.7.1

Postby 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.
User avatar
Snykx
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 29
Joined: Wed Oct 18, 2006 10:09 am

Error with Anub'arak server - 1.7.1

Postby 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 ^^
RainRider
WR.net Apprentice
WR.net Apprentice
 
Posts: 50
Joined: Thu Jul 20, 2006 11:47 pm

Error with Anub'arak server - 1.7.1

Postby Snykx » Wed Oct 25, 2006 9:31 am

Yep, If I add the backslash, it does exactly that.
User avatar
Snykx
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 29
Joined: Wed Oct 18, 2006 10:09 am

Error with Anub'arak server - 1.7.1

Postby 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.
User avatar
Snykx
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 29
Joined: Wed Oct 18, 2006 10:09 am

Re: Error with Anub'arak server - 1.7.1

Postby 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.
RocRaRa
WR.net Apprentice
WR.net Apprentice
 
Posts: 1
Joined: Wed Oct 25, 2006 8:55 am

Re: Error with Anub'arak server - 1.7.1

Postby 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'].'&amp;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'].'&amp;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.'&amp;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'].'&amp;server='.$roster_conf['server_name'].'&amp;action=recipes">'.$row['name'].'</a

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


membersinst.php
Change line 327 from
Code: Select all
print '<a href="char.php?name='.$row['name'].'&amp;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 :)
User avatar
Snykx
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 29
Joined: Wed Oct 18, 2006 10:09 am

Error with Anub'arak server - 1.7.1

Postby 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
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

Re: Error with Anub'arak server - 1.7.1

Postby Snykx » Wed Oct 25, 2006 1:02 pm

Off, off and off.
User avatar
Snykx
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 29
Joined: Wed Oct 18, 2006 10:09 am

Error with Anub'arak server - 1.7.1

Postby zanix » Wed Oct 25, 2006 1:27 pm

ok, and everyone else?
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

Error with Anub'arak server - 1.7.1

Postby RainRider » Wed Oct 25, 2006 5:56 pm

Everything "off" too. If I switch them on, I get "Guild not found".
Last edited by RainRider on Wed Oct 25, 2006 6:07 pm, edited 2 times in total.
RainRider
WR.net Apprentice
WR.net Apprentice
 
Posts: 50
Joined: Thu Jul 20, 2006 11:47 pm

Error with Anub'arak server - 1.7.1

Postby 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
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


Return to Installation

Who is online

Users browsing this forum: No registered users and 0 guests

cron