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

News:

CPG Release 1.6.27
change DB IP storage fields to accommodate IPv6 addresses
remove use of E_STRICT (PHP 8.4 deprecated)
update README to reflect new website
align code with new .com CPG website
correct deprecation in captcha

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