Advanced search  

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]

Pages: [1]   Go Down

Author Topic: Can't create a new album  (Read 422 times)

0 Members and 1 Guest are viewing this topic.

maciekmaciek

  • Coppermine newbie
  • Offline Offline
  • Posts: 1
Can't create a new album
« on: May 18, 2019, 12:44:28 am »

Hi, many thanks for the excellent gallery! I run it since 12 years and start to appreciate how nicely the photos start to look old :)

Now I've migrated my 1.5x gallery to a new server, and have upgraded it to 1.6.06. The process has been chaotic to some degree, but the gallery works: I can watch the photos, statistics, login as the admin, create a category etc. But I can't create a new album. A spinner shows up after typing the album's intended name and pressing the "OK" button, and nothing happens.

I can add the photos to the existing albums, albeit I've set up the permissions too generously.
Logged

ron4mac

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Posts: 1188
Re: Can't create a new album
« Reply #1 on: May 18, 2019, 04:04:13 am »

Link to gallery, please.
Logged

ron4mac

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Posts: 1188
Re: Can't create a new album
« Reply #2 on: May 27, 2019, 12:29:46 pm »

This issue was being caused by a field in the _albums table that was left over from CPG 1.3.  Removing the field was apparently missed in the CPG 1.4 upgrade mechanism. The field was last_addition (a date field) and its default value (0000-00-00 00:00:00) is not, by default, allowed in newer database engines. Removing the field from the table solved the problem.
Logged

gmc

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 784
    • GMC Design Photo Gallery
Re: Can't create a new album
« Reply #3 on: June 10, 2019, 02:39:17 am »

From what I have seen, the policy has been not to delete 'obsolete' fields from the database as part of an upgrade...
I identified a number of obsolete fields going back to 1.3 days when I coded 'Gallery Merge' for 1.5. When merging an older gallery, I ignored the fields, but many older galleries likely still contain them.

_USERS: 'user_favpics'
_CATEGORIES: 'subcat_count', 'alb_count', 'pic_count', 'stat_uptodate'
_ALBUMS: 'pic_count', 'last_addition', 'stat_uptodate'
_PICTURES: 'owner_name'

I think 'last_addition' is the only date field - and affected if enforcing new standards at database level.  Plugins may have also added date fields to various tables over time that may or may not still be used.

Not sure the right answer - but the gremlin is out there...
Logged
Thanks!
Greg
My Coppermine Gallery
Need a web hosting account? See my gallery for an offer for CPG Forum users.
Send me money
Pages: [1]   Go Up
 

Page created in 0.023 seconds with 20 queries.