Advanced search  


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.

Pages: [1]   Go Down

Author Topic: Unused fields in albums table?  (Read 3176 times)

0 Members and 1 Guest are viewing this topic.


  • Translator
  • Coppermine frequent poster
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 100
Unused fields in albums table?
« on: December 06, 2003, 01:36:17 am »

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


  • VIP
  • Coppermine addict
  • ***
  • Offline Offline
  • Posts: 831
    • Dragonfly CMS
Unused fields in albums table?
« Reply #1 on: December 06, 2003, 01:50:33 am »

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?
Pages: [1]   Go Up

Page created in 0.017 seconds with 19 queries.