Advanced search  

News:

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.
[more]

Pages: [1]   Go Down

Author Topic: There was an error while processing a database query  (Read 8391 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.019 seconds with 19 queries.