[Solved] Found a bug (French inside) ?

Scans for, and displays main/alt relations in your Guild

Moderator: PleegWat

[Solved] Found a bug (French inside) ?

Postby lesablier » Mon Aug 14, 2006 2:14 am

Hello.

When i want to update by the updMainAlt button in altmonitor configuration
it opens a new windows (in Firefox) and display me :

Fatal error: mysql_free_result(): supplied argument is not a valid MySQL result resource in /mnt/133/sdb/5/b/guilde.le.sablier/roster/lib/wowdb.php on line 205

Or when in want to update with CharacterProfiler.lua by officer button in the
/roster/admin/update.php page, it displays in this page (not in a new window)

Anybody got an idea :scratch: ?
Last edited by lesablier on Sun Aug 20, 2006 2:10 pm, edited 1 time in total.
lesablier
WR.net Journeyman
WR.net Journeyman
 
Posts: 77
Joined: Sat Jul 15, 2006 4:01 pm

Found a bug ?

Postby PleegWat » Mon Aug 14, 2006 10:28 pm

I've had this bug linked before, and have been unable to find what could cause it. Do you happen to know what character this happens on? Anything special with him?

Also, can you give a link to your roster?
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: Found a bug ?

Postby lesablier » Tue Aug 15, 2006 4:33 pm

Hello PleegWat.

The roster URL is:
http://guilde.le.sablier.free.fr/roster/index.php

It happens when ever you upload by officer way, or when you want perform
an Update Relations by the Altmonitor pannel.

Here the error code open in a new Firefox or Ie page:

Fatal error: mysql_free_result(): supplied argument is not a valid MySQL result resource in /mnt/133/sdb/5/b/guilde.le.sablier/roster/lib/wowdb.php on line 205

By the Officer use only whith the CharacterProfiler.lua in the update.phpweb page, error in the same page in Firefox or Ie :


Fatal error: mysql_free_result(): supplied argument is not a valid MySQL result resource in /mnt/133/sdb/5/b/guilde.le.sablier/roster/lib/wowdb.php on line 205

So i must remove altmonitor to perform a guild update.

All the Alt of the guild are tag with the Alt-<main name> by public note and the Reg ex is /ALT-([\w]+)/i (by default)
I've never be abble to make work the altmonitor, what ever Regex i've been choosen.


Addon update triggers is on, and i performed a lot of update.
Used Altmonitor rev 1.3.0 and check whith config.lib.php update with the \\ in the regex, same result.


I'm using the LAMP from my ISP, could it be the problem ?
Image

Regards.
(Sorry for my poor english)
Last edited by lesablier on Tue Aug 15, 2006 4:45 pm, edited 1 time in total.
lesablier
WR.net Journeyman
WR.net Journeyman
 
Posts: 77
Joined: Sat Jul 15, 2006 4:01 pm

Found a bug ?

Postby PleegWat » Tue Aug 15, 2006 5:28 pm

The LAMP from ISP shouldn't be a problem. Looking at the rosterdiag image though; it's interesting that the table listing was denied by the mysql server.

Most probably, that error means that the LIST TABLES command has been disabled for your MySQL user. If this is the case, your ISP is probably quite restrictive in the rights assignments; there may be a limit in how many queries per minute you may execute.

Does a normal update (with altmonitor disabled) work correctly? And did you have any trouble installing? Those are the only things I can think of that produce a high amount of queries.
Last edited by PleegWat on Tue Aug 15, 2006 5:30 pm, edited 1 time in total.
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: Found a bug ?

Postby lesablier » Tue Aug 15, 2006 6:53 pm

With almonitor disabled, no problem of normal update or officer update
(no problem with almonitor and normal update just with officer update)

No problem to install the roster (except the error on line 300, because no update of the guild was perfomed but it's for anybody)

I've demand to my isp the limitation on queries and waiting for his response.
lesablier
WR.net Journeyman
WR.net Journeyman
 
Posts: 77
Joined: Sat Jul 15, 2006 4:01 pm

Found a bug ?

Postby PleegWat » Tue Aug 15, 2006 7:35 pm

Could you attach a characterprofiler.lua here or PM one to me? Then I can try it here and make sure it's not an altmonitor problem.
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: Found a bug ?

Postby lesablier » Tue Aug 15, 2006 10:02 pm

Send a link on PM
lesablier
WR.net Journeyman
WR.net Journeyman
 
Posts: 77
Joined: Sat Jul 15, 2006 4:01 pm

Found a bug ?

Postby PleegWat » Tue Aug 15, 2006 11:21 pm

Well, it works fine with me. So it's probably a problem with your host.

Try, for debugging purposes only, to edit the lib/wowdb.php and add at line 79 (in the query function)

Code: Select all
echo $querystr


Tell me roughly how many output lines this produces and give the last few.
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: Found a bug ?

Postby lesablier » Tue Aug 15, 2006 11:29 pm

Ok here the result for altmonitor on debug mode

Two files , one in the normal update and the other when performing a "Officer use only" only

Thanks for you patience.
Attachments
update-officer.zip
Officer update debug log
(2.63 KiB) Downloaded 262 times
update_normal.zip
Normal update debug log
(59.02 KiB) Downloaded 274 times
Last edited by lesablier on Tue Aug 15, 2006 11:43 pm, edited 1 time in total.
lesablier
WR.net Journeyman
WR.net Journeyman
 
Posts: 77
Joined: Sat Jul 15, 2006 4:01 pm

Found a bug ?

Postby PleegWat » Wed Aug 16, 2006 2:32 am

Ah, I think I've got it. At the very bottom of the update.php, I free the result for the update query. I assume it's possible for mysql to return true there for a successful query and not return a resource at all, since there isn't anything to fetch after an update.

Try deleting it, it's the last real code line, line 262.
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: Found a bug ?

Postby lesablier » Thu Aug 17, 2006 3:44 am

Hello

i've try to delete the line but still the same result.
line 262 => $output .= "<ul>\n";

Normal update=>ok

Officer update=>Fatal error: mysql_free_result(): supplied argument is not a valid MySQL result resource in /mnt/133/sdb/5/b/guilde.le.sablier/roster/lib/wowdb.php on line 207

I've check with my ISP, SHOW TABLES is not block on php/mysql .

It works with the CharacterProfiler.lua that i've PM you ? in usUS ou frFR ?
:scratch: :scratch:
lesablier
WR.net Journeyman
WR.net Journeyman
 
Posts: 77
Joined: Sat Jul 15, 2006 4:01 pm

Found a bug ?

Postby PleegWat » Thu Aug 17, 2006 11:11 pm

Wrong update.php; you need the update.php in addons/AltMonitor/update.php. The line you should remove reads:

Code: Select all
$wowdb->free_result($result); 


Sorry, my fault for not making that more clear.

EDIT: I looked it up, but that line is indeed in error. There's no result for update queries, so I don't need to free it.
Last edited by PleegWat on Thu Aug 17, 2006 11:14 pm, edited 1 time in total.
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: Found a bug ?

Postby lesablier » Fri Aug 18, 2006 1:24 am

:cheers: :thumright: Yes you got it !!! :thumleft: :cheers:

Remark the 262 line of update.php (/roster/addons/AltMonitor/)

Normal update ok
Officer update ok no error :thumright:


Update Relations Main/Rerolll
:thumright: Settings have been changed :thumright:

Update Relations (4th selection in config menu)
Open a new window displaying the relation between alt and main ok

My regex => /ALT-([\w]+)/i work with my player note Alt-mainame
http://guilde.le.sablier.free.fr/roster ... AltMonitor

i'm very very very happy for your mod and would like to thank you again for your time spent on my problem :salute:

LeSablier.

PS: if you want the logs files, i can upload here if you want and tell me if i must perform some other tests for you, no problem at all !!!
Thank you very much.
Last edited by lesablier on Fri Aug 18, 2006 1:42 am, edited 1 time in total.
lesablier
WR.net Journeyman
WR.net Journeyman
 
Posts: 77
Joined: Sat Jul 15, 2006 4:01 pm

Re: Found a bug ?

Postby Remind » Tue Sep 26, 2006 12:50 am

I confirm that it works for me too.

Thx!
Remind
WR.net Apprentice
WR.net Apprentice
 
Posts: 12
Joined: Thu Sep 14, 2006 1:25 am


Return to AltMonitor

Who is online

Users browsing this forum: No registered users and 1 guest

cron