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

0 Members and 1 Guest are viewing this topic.

wuschel_lux

  • Translator
  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 93
    • volleyball.lu - 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', '', '', '', '', '83.99.85.59', '83.99.85.59', '0', '')' in include/picmgmt.inc.php on line 173

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

File: /home/www/web858/web858u62/html/include/functions.inc.php - Line: 272

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

Thanks for your support

Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
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.
Logged
Pages: [1]   Go Up
 

Page created in 0.016 seconds with 19 queries.