Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: 1 [2]   Go Down

Author Topic: Online stats that work?  (Read 31770 times)

0 Members and 1 Guest are viewing this topic.

Paver

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 1609
  • Paul V.
Re: Online stats that work?
« Reply #20 on: January 16, 2006, 11:18:57 pm »

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.
Logged

Gary B

  • Coppermine novice
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 38
    • Hagerty High School
Re: Online stats that work?
« Reply #21 on: January 16, 2006, 11:29:11 pm »

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]
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]
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)
)
Logged

Paver

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 1609
  • Paul V.
Re: Online stats that work?
« Reply #22 on: January 16, 2006, 11:47:14 pm »

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.
« Last Edit: January 17, 2006, 12:22:24 am by Paver »
Logged

Gary B

  • Coppermine novice
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 38
    • Hagerty High School
Re: Online stats that work?
« Reply #23 on: January 17, 2006, 12:05:23 am »

MySQL version is 4.0.25-standard
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Online stats that work?
« Reply #24 on: January 17, 2006, 08:10:04 am »

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.
Logged

Paver

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 1609
  • Paul V.
Re: Online stats that work?
« Reply #25 on: January 17, 2006, 06:00:03 pm »

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.
Logged

DarKPLuS

  • Coppermine newbie
  • Offline Offline
  • Posts: 1
Re: Online stats that work?
« Reply #26 on: May 07, 2009, 06:24:27 pm »

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

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Online stats that work?
« Reply #27 on: May 08, 2009, 04:59:29 pm »

Board rules!. Locking.
Logged
Pages: 1 [2]   Go Up
 

Page created in 0.023 seconds with 20 queries.