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 ?

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?

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 ?


Regards.
(Sorry for my poor english)

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.

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.

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.

Send a link on 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.

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.

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.

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 ?

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.

Yes you got it !!!

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

Normal update ok
Officer update ok no error


Update Relations Main/Rerolll
Settings have been changed

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

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.

I confirm that it works for me too.

Thx!