Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

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

0 Members and 1 Guest are viewing this topic.

eolica

  • Translator
  • Coppermine frequent poster
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 100
    • http://www.ilvaldinoto.net
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.
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?
Logged
Sesto Avolio

DJMaze

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

Page created in 0.017 seconds with 19 queries.