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: There was an error while processing a database query  (Read 8441 times)

0 Members and 1 Guest are viewing this topic.

mithos

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
There was an error while processing a database query
« on: November 29, 2005, 01:33:54 am »

Hi i was trying to create a category but it always says
There was an error while processing a database query
What is the problem? I recently started using MySQL5.
Apache 2.0.55.
PHP 5.1.1.

i hope you can get me some answers  ;D

Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: There was an error while processing a database query
« Reply #1 on: November 29, 2005, 01:36:16 am »

enable debug_mode in coppermine's config to see the actual error message.
Logged

mithos

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
Re: There was an error while processing a database query
« Reply #2 on: November 29, 2005, 02:02:53 am »

While executing query "INSERT INTO cpg140_albums (category, title, uploads, pos) VALUES ('0', 'Rinion', 'NO',  '1')" on 0

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

im getting this error message in debug mode
Logged

Nibbler

  • Guest
Re: There was an error while processing a database query
« Reply #3 on: November 29, 2005, 02:15:35 am »

Run this query in phpmyadmin or manually to repair it

Code: [Select]
ALTER TABLE cpg140_albums CHANGE `description` `description` TEXT NOT NULL default '';
Logged

mithos

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
Re: There was an error while processing a database query
« Reply #4 on: November 29, 2005, 03:05:36 am »

another problem when i am going to add info after I upload a picture

While executing query "INSERT INTO cpg140_pictures (pid, aid, filepath, filename, filesize, total_filesize, pwidth, pheight, ctime, owner_id, owner_name, title, caption, keywords, approved, user1, user2, user3, user4, pic_raw_ip, pic_hdr_ip, position) VALUES ('', '1', 'userpics/10001/', 'Stefan.jpg', '24431', '35899', '600', '450', '1133229832', '1', 'Rinion','Rinion själv', 'admin', '', 'YES', '', '', '', '', '127.0.0.1', '127.0.0.1', '0')" on 0

mySQL error: Out of range value adjusted for column 'pid' at row 1
Logged

kegobeer

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 4637
  • Beer - it does a body good!
    • The Kazebeer Family Website
Re: There was an error while processing a database query
« Reply #5 on: November 29, 2005, 03:46:51 am »

another problem when i am going to add info after I upload a picture

While executing query "INSERT INTO cpg140_pictures (pid, aid, filepath, filename, filesize, total_filesize, pwidth, pheight, ctime, owner_id, owner_name, title, caption, keywords, approved, user1, user2, user3, user4, pic_raw_ip, pic_hdr_ip, position) VALUES ('', '1', 'userpics/10001/', 'Stefan.jpg', '24431', '35899', '600', '450', '1133229832', '1', 'Rinion','Rinion själv', 'admin', '', 'YES', '', '', '', '', '127.0.0.1', '127.0.0.1', '0')" on 0

mySQL error: Out of range value adjusted for column 'pid' at row 1


Not related to the first problem.  This is because you have MySQL 5 running in strict mode.  Check out this link:
http://forums.belution.com/en/sql/000/095/94.shtml
Logged
Do not send me a private message unless I ask for one.  Make your post public so everyone can benefit.

There are no stupid questions
But there are a LOT of inquisitive idiots
Pages: [1]   Go Up
 

Page created in 0.018 seconds with 19 queries.