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: Critical error in batch new files  (Read 5374 times)

0 Members and 1 Guest are viewing this topic.

Hanna.

  • Coppermine frequent poster
  • ***
  • Country: us
  • Offline Offline
  • Gender: Female
  • Posts: 227
  • webstar
Critical error in batch new files
« on: April 04, 2019, 09:42:58 pm »

Hi. I have been experiencing difficulties adding files through batch new files at one of the coppermine galleries I add files to. Unfortunately, I cannot provide more information other than attached screenshot - as the error does not expose entirely.

Any ideas what this might be? I am willing to provide login if needed.
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Critical error in batch new files
« Reply #1 on: April 09, 2019, 01:24:54 pm »

PM sent.
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Critical error in batch new files
« Reply #2 on: April 11, 2019, 04:55:22 pm »

Here's the issue:
Code: [Select]
While executing query 'INSERT INTO kkpix_pictures (aid, filepath, filename, filesize, total_filesize, pwidth, pheight, ctime, owner_id, title, caption, keywords, approved, user1, user2, user3, user4, pic_raw_ip, pic_hdr_ip, position, guest_token) VALUES ('47', 'Photoshoots/2019 An Le/', '001.jpg', '1532682', '1994635', '2480', '3260', '1554994187', '1', '', '', '', 'YES', '', '', '', '', '', '', '0', '')' in include/picmgmt.inc.php on line 184

database error: 1364 : Field 'date_upl' doesn't have a default value

Datei: /home/minowncu/public_html/kO40nEk79tx18U/gallery/include/functions.inc.php - Zeile: 250

"date_upl" must have been added by you or a plugin, it doesn't exist in vanilla Coppermine. However, adding a default value to that field with a tool like phpMyAdmin should fix the issue.
Logged

Hanna.

  • Coppermine frequent poster
  • ***
  • Country: us
  • Offline Offline
  • Gender: Female
  • Posts: 227
  • webstar
Re: Critical error in batch new files
« Reply #3 on: April 12, 2019, 11:55:13 pm »

Here's the issue:
Code: [Select]
While executing query 'INSERT INTO kkpix_pictures (aid, filepath, filename, filesize, total_filesize, pwidth, pheight, ctime, owner_id, title, caption, keywords, approved, user1, user2, user3, user4, pic_raw_ip, pic_hdr_ip, position, guest_token) VALUES ('47', 'Photoshoots/2019 An Le/', '001.jpg', '1532682', '1994635', '2480', '3260', '1554994187', '1', '', '', '', 'YES', '', '', '', '', '', '', '0', '')' in include/picmgmt.inc.php on line 184

database error: 1364 : Field 'date_upl' doesn't have a default value

Datei: /home/minowncu/public_html/kO40nEk79tx18U/gallery/include/functions.inc.php - Zeile: 250

"date_upl" must have been added by you or a plugin, it doesn't exist in vanilla Coppermine. However, adding a default value to that field with a tool like phpMyAdmin should fix the issue.

This is the coppermine that was reset by accident with the date stamps and ended up messed up all together. I wonder if I should start over this particular gallery as it appears to have tracks of wrongs from that date-incident.
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Critical error in batch new files
« Reply #4 on: April 16, 2019, 02:21:25 pm »

It's up to you if you want to start from scratch. I personally would try to fix the issue(s), starting by adding a default value for that field (or just drop the field, if it's not needed anymore).
Logged
Pages: [1]   Go Up
 

Page created in 0.02 seconds with 21 queries.