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.

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();
      }


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.
I can probably remove the profession field if need be, or if you have any other suggestion I'd be glad to try them.

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.

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.