forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: mithos on November 29, 2005, 01:33:54 am

Title: There was an error while processing a database query
Post by: mithos 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

Title: Re: There was an error while processing a database query
Post by: Joachim Müller on November 29, 2005, 01:36:16 am

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

Title: Re: There was an error while processing a database query
Post by: mithos 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

Title: Re: There was an error while processing a database query
Post by: Nibbler 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 '';

Title: Re: There was an error while processing a database query
Post by: mithos 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

Title: Re: There was an error while processing a database query
Post by: kegobeer on November 29, 2005, 03:46:51 am

Quote from: mithos 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

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