Picture counter not working

rukiddin · November 27, 2003, 09:53:58 PM

I just recently installed CPG 1.2.0 and the only problem I seem to be having is that the picture counter is all whacked out.

I'm running on a Mac OS X server (Panther v. 1.3) and the problem is different in each gallery.

The header counters seem ok (where it counts all the images in the gallery) it's just the individual album counters that are out of whack.

Here's what I am seeing:

(https://coppermine-gallery.com/forum/proxy.php?request=http%3A%2F%2Fwww.mcneillfamily.org%2Fcounter.jpg&hash=50986f7c52230cce43b568a782f0ad328afbd0c4)

Any help would be appreciated.

Joachim Müller · November 28, 2003, 09:03:23 AM

just reset it: while in admin mode, there's a link saying "edit pics" next to each album thumbnail - Notice the "Reset view counter" checkbox?

GauGau

rukiddin · December 02, 2003, 05:34:39 AM

GauGau,

Thanks for the response. However doesn't the "reset view counter" only reset the view counter? The problem I am having is with the count of total number of pictures on the main page. I tried doing what you suggested, but it had no effect.

Any other ideas?

Joachim Müller · December 02, 2003, 07:59:21 AM

unless you modified index.php, the total count of pics in the album should come from a query run against the pictures table (usually cpg11d_pictures).
Could you go into phpMyAdmin and do such a query manually?
Do you have multiple installs of coppermine on your server?

GauGau

rukiddin · December 08, 2003, 05:26:46 AM

I'm not that familiar with PHP (yet), so I don't know how to do a query manually.

I wasn't running multiple copies of coppermine, but I have since installed mutiple copies and they all have the same problem.

You can see examples of the problem at www.mcneillfamily.org

Mike

Joachim Müller · December 08, 2003, 08:00:35 AM

QuoteCoppermine critical error:
Unable to connect to database !

MySQL said: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

GauGau

rukiddin · December 16, 2003, 03:48:14 AM

I had reset the server and hadn't realized the SQL server was not set to start up automatically. Fixed now.

But the problem with the counters still exists.

Mike

Joachim Müller · December 16, 2003, 11:01:07 AM

Quote from: "gaugau"Could you go into phpMyAdmin and do such a query manually?

Did you do that? Do you have phpMyAdmin at all? It's a very good and easy-to-use tool (get it free, same license as coppermine).
Just install it and look at your pictures table with it. You'll need it to track down if the problem is coppermine-related of mySQL-related.
If you don't want to fuzz about it, switch stats off.

GauGau

rukiddin · December 16, 2003, 04:43:48 PM

I don't think it's installed yet. I'll hunt it down though. What is wierd is that the counter seems to work in other places. Just not on that main screen.

Thanks

Mike

News:

Picture counter not working