There was an error while processing a database query

[mithos]

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 

[Joachim Müller]

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

[mithos]

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

[Nibbler]

Run this query in phpmyadmin or manually to repair it

Code Select Expand

ALTER TABLE cpg140_albums CHANGE `description` `description` TEXT NOT NULL default '';

[mithos]

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

[kegobeer]

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