Advanced search  


cpg1.5.46 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter recently discovered vulnerabilities. It is important that all users who run version cpg1.5.44 or older update to this latest version as soon as possible.

Pages: [1]   Go Down

Author Topic: Upload problem - SQL error  (Read 1389 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: 15587
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.026 seconds with 20 queries.