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

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

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