I have errors.

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

I have errors.

Postby EvilEvil » Mon Jan 22, 2007 5:07 pm

Two things happened between the time my roster was working and when it stopped working. BC and a server switch. I'm not real sure that this can be fixed (I'm hoping) but if not maybe someone could tell me how to purge all thats been uploaded but keep the settings same. anyways on to the error.

Invalid query result passed

* File: /home/evilevil/public_html/roster/lib/commonfunctions.lib.php
o line 248
o function called: backtrace
* File: /home/evilevil/public_html/roster/lib/wowdb.php
o line 133
o function called: die_quietly
o args: Invalid query result passed, Roster DB Layer
* File: /home/evilevil/public_html/roster/memberslist.php
o line 630
o function called: fetch_assoc
o args:
* File: /home/evilevil/public_html/roster/memberslist.php
o line 376
o function called: tradeskill_icons
o args: Array ( [member_id] => 72 [name] => Guran [class] => Warlock [note] => [nisnull] => 1 [level] => 60 [guild_rank] => 2 [guild_title] => Elder [zone] => Hillsbrad Foothills [last_online] => Sun Jan 7th, 9:55 AM [race] => Undead [RankName] => Sergeant [RankInfo] => 3 [risnull] => 0 [exp] => 5:415500:0 [server] => Emerald Dream [clientLocale] => enUS [RankIcon] => Interface/PvPRankBadges/PvPRank03 [Rankexp] => 34.9 [hearth] => Cenarion Hold [hisnull] => 0 [last_update] => 01/07/07 13:24:37 [luisnull] => 0 )
* File: /home/evilevil/public_html/roster/index.php
o line 174
o function called: include_once
o args: /home/evilevil/public_html/roster/memberslist.php

theres also a pvplog error but I'm not real conserned about that. dont use it anyways. If needed that error too.

edit : and this is after I fixed the files in the lib folder. I think the errors were slightly different before.
Last edited by EvilEvil on Mon Jan 22, 2007 5:08 pm, edited 1 time in total.
EvilEvil
WR.net Apprentice
WR.net Apprentice
 
Posts: 6
Joined: Mon Jul 24, 2006 9:43 pm

I have errors.

Postby PleegWat » Mon Jan 22, 2007 5:36 pm

Something is going wrong when creating the tradeskill icons. The resulting database error is not being caught properly. Try inserting this code in memberslist.php on line 628:

Code: Select all
      if( !$sql_prof )
      {
         return 'Error while fetching professions for '.$row['name'].'. MySQL said: '.$wowdb->error();
      }
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

Re: I have errors.

Postby EvilEvil » Mon Jan 22, 2007 6:06 pm

definately looks better. now the whole thing is showing and in the profession field it says "Error while fetching professions for Guran. MySQL said: 0:"
for the characters that have been updated. no more huge red error box.

Thanks much. :thumleft:
I can probably remove the profession field if need be, or if you have any other suggestion I'd be glad to try them.
Image
EvilEvil
WR.net Apprentice
WR.net Apprentice
 
Posts: 6
Joined: Mon Jul 24, 2006 9:43 pm

Re: I have errors.

Postby EvilEvil » Mon Jan 22, 2007 6:49 pm

Actaully It looks like Im having problems with siggen too. Which was mainly my concern. Im just gonna do a full reinstallation. Something got pooched big time. Thank you for the help though.
Image
EvilEvil
WR.net Apprentice
WR.net Apprentice
 
Posts: 6
Joined: Mon Jul 24, 2006 9:43 pm

I have errors.

Postby PleegWat » Mon Jan 22, 2007 7:06 pm

Hm, if it returns error code 0 then it isn't the query that's going wrong. No idea what it would be then. Reinstalling probably gets rid of it still.
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


Return to General Support & Feedback

Who is online

Users browsing this forum: No registered users and 0 guests

cron