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: Upload problem - SQL error  (Read 8007 times)

0 Members and 1 Guest are viewing this topic.


  • Translator
  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 93
    • - photo gallery & shop
Upload problem - SQL error
« on: February 26, 2017, 08:14:27 pm »

Hi all,

I have an error found today while uploading pictures. on 16.02.2017 upload was possible without problems.

Please find below the error message:

Code: [Select]
Critical error
There was an error while processing a database query.

While executing query 'INSERT INTO cpg_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 ('875', 'userpics/13581/', '20170212132438_TK_CopueDeLuxJeunes_027.jpg', '747745', '1144718', '2048', '1356', '1488136052', '3581', '', '', '', 'YES', '', '', '', '', '', '', '0', '')' in include/ on line 173

mySQL error: Field 'price' doesn't have a default value

File: /home/www/web858/web858u62/html/include/ - Line: 272

A test-user is also created withe username and password 'tester' and debugging enabled.

Thanks for your support



  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15765
Re: Upload problem - SQL error
« Reply #1 on: June 30, 2017, 01:52:59 pm »

The "price" field doesn't exist in a standard Coppermine gallery. It was probably added by a mod or plugin, like the cpgShop plugin (haven't checked that). To fix this issue, you need to set a standard value for that field on your MySQL database.
Pages: [1]   Go Up

Page created in 0.016 seconds with 19 queries.