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
enable debug_mode in coppermine's config to see the actual error message.
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
Run this query in phpmyadmin or manually to repair it
ALTER TABLE cpg140_albums CHANGE `description` `description` TEXT NOT NULL default '';
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
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