Unused fields in albums table? Unused fields in albums table?
 

News:

CPG Release 1.6.28
added submissions from {406man}
cleaned up a few PHP (8.4) deprecations
fixed PHP deprecation in calendar
removed security vulnerability
(please upgrade when possible)

Main Menu

Unused fields in albums table?

Started by eolica, December 06, 2003, 01:36:17 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

eolica

I'm converting a postnuke block listing categories to list categories (with number of albums) in coppermine.

To show some infos the block looks in the various tables, and I'm using  last_addition to mark categories with new entries.

But it doesn't work.
Why?
Because last_addition is always 0000-00-00 00:00:00 :!:
While looking to the database I've seen that also pic_count is always 0.
A bug of the port? No. Looking to the database for the CPG 1.2 standalone I see that they are both kept at the default value also there.

General bug or reserved for future use?
Sesto Avolio

DJMaze

A lot of fields are in database which are never used.

Since we took over the dev. of the Great Big Greg we also still don't have a clue.

But these fields are actualy not needed cos a query COUNT(*) does it already.
And the last picture always has the highest ID
There are 2 kinds of users in this world: satisfied and complainers.
Why do we never hear something from the satisfied users?
http://coppermine-gallery.net/forum/index.php?topic=24315.0