Online stats that work?

[Paver]

Turn on debug info in your config and see if there's any more information in the debug info when you include 'onlinestats' and get this error, something related to what exactly causes this error.  If you use phpMyAdmin, you could try this query there just to make absolutely sure something is not typed incorrectly.

[Gary B]

Ok I turned the plugin back on and go the error message here is the only part of the debug file that was different with it turned on:

Code Select Expand

LIMIT 0 ,12 (0s)
    [55] => SELECT count(*) from cpg_comments where pid=3280 and msg_id!=0 (0s)
    [56] => SELECT count(*) from cpg_comments where pid=3279 and msg_id!=0 (0s)
    [57] => SELECT count(*) from cpg_comments where pid=3278 and msg_id!=0 (0.001s)
    [58] => SELECT count(*) from cpg_comments where pid=3277 and msg_id!=0 (0s)
    [59] => SELECT count(*) from cpg_comments where pid=3276 and msg_id!=0 (0s)
    [60] => SELECT count(*) from cpg_comments where pid=3275 and msg_id!=0 (0s)
    [61] => SELECT count(*) from cpg_comments where pid=3274 and msg_id!=0 (0s)
    [62] => SELECT count(*) from cpg_comments where pid=3273 and msg_id!=0 (0s)
    [63] => SELECT count(*) from cpg_comments where pid=3272 and msg_id!=0 (0s)
    [64] => SELECT count(*) from cpg_comments where pid=3271 and msg_id!=0 (0s)
    [65] => SELECT count(*) from cpg_comments where pid=3270 and msg_id!=0 (0s)
    [66] => SELECT count(*) from cpg_comments where pid=3269 and msg_id!=0 (0s)
    [67] => SELECT COUNT(*) FROM `parkho2_xmb1`.phpbb_users (0.001s)
)


Here is what it looks like with the plugin disabled

Code Select Expand

LIMIT 0 ,12 (0s)
    [55] => SELECT count(*) from cpg_comments where pid=3280 and msg_id!=0 (0s)
    [56] => SELECT count(*) from cpg_comments where pid=3279 and msg_id!=0 (0s)
    [57] => SELECT count(*) from cpg_comments where pid=3278 and msg_id!=0 (0s)
    [58] => SELECT count(*) from cpg_comments where pid=3277 and msg_id!=0 (0s)
    [59] => SELECT count(*) from cpg_comments where pid=3276 and msg_id!=0 (0s)
    [60] => SELECT count(*) from cpg_comments where pid=3275 and msg_id!=0 (0s)
    [61] => SELECT count(*) from cpg_comments where pid=3274 and msg_id!=0 (0s)
    [62] => SELECT count(*) from cpg_comments where pid=3273 and msg_id!=0 (0s)
    [63] => SELECT count(*) from cpg_comments where pid=3272 and msg_id!=0 (0s)
    [64] => SELECT count(*) from cpg_comments where pid=3271 and msg_id!=0 (0s)
    [65] => SELECT count(*) from cpg_comments where pid=3270 and msg_id!=0 (0s)
    [66] => SELECT count(*) from cpg_comments where pid=3269 and msg_id!=0 (0s)
)

[Paver]

Well, that confirms that the last query is causing the problem.  But it doesn't tell us anything more.  I have the same query (but with my unbridged users table), and it works fine.  I'm using Coppermine 1.4.3 and MySQL 4.1.15.  I don't know if there were be any MySQL 5 issues involved (if you're using version 5).  It's such a simple query.

[Gary B]

MySQL version is 4.0.25-standard

[Joachim Müller]

I updated the plugin thread http://forum.coppermine-gallery.net/index.php?topic=26532.0 as Paver suggested.
There should be only one thread that discusses the plugin, please end the discussion on this thread (try resolving existing issues, but don't start new ones), I will lock this thread soon. Discuss all new issues with the plugin on the thread I refered to above. Thanks to Paver for his contributions and support.

[Paver]

Gary B: GauGau is right.  Let me sum up what I would suggest for your problem, and then it's up to you.  If you discover more troubleshoting info, please post in the plugin thread (with a quick summary and link to this thread if it's related).

That query is so simple as I said.  There's a COUNT() function and a table and that's it.  If you copy that query to phpMyAdmin and it executes fine, then I don't know why Coppermine cannot execute it.  I assume your bridge with phpBB is working correctly otherwise.  Do you have any other plugins or mods installed?  Are there any issues with your bridge?  I assume Coppermine uses a similar query in the user manager or groups manager.  You could try gonig to those pages and checking the debug info looking for queries that reference the same table as the one having issues here.  I don't know enough about bridges but could it be this table you mentioned is in a different database with different connection info and this plugin doesn't initiate this connection before running this query?  All the previous queries to this problematic one are with Coppermine core tables so that's one difference with this query: it uses an explicit database name and a non-Coppermine table.

The original mod thread that Nibbler posted (linked in the first post of this thread) mentions you have to change things for your bridge, but I doubt that that's necessary in the current plugin version but I really don't know.

So those are my suggestions for things to consider.  Please try out what you can - troubleshoot the problem.  Then, when you have more information, summarize what you did & what you found and post in the plugin thread.

Over and out.

[DarKPLuS]

hi i installed this. its really good thank you very much)
i want to place it in the sidebar. how can i do this ?

[Joachim Müller]

Board rules!. Locking.