Print

[JCDenton]

I have had no problems until today trying to add an album to a category. I created a new category today but when trying to add an album I get an error message - 'There was an error while processing a database query.'
Here is the error -

Critical error

There was an error while processing a database query.

While executing query "INSERT INTO cd2006_albums (category, title, uploads, pos) VALUES ('7', '1440x900', 'NO', '1')" on 0 mySQL error: Field 'description' doesn't have a default value


File: D:\cpg144\include\functions.inc.php - Line: 248


Any ideas?

[Nibbler]

What version are you using ? Update to latest stable version, currently 1.4.4

[JCDenton]

I have been using the stable version for awhile now. I have had no problems in the past - it is only today that this error occured.

VERSION INFO :
------------------
PHP version: 4.3.10 - OK
------------------
mySQL version: 5.0.19-nt
------------------
Coppermine version: 1.4.4(stable)

[JCDenton]

Surfing through the forums I see that someone else is having the exact same difficulty - http://forum.coppermine-gallery.net/index.php?topic=28854.0;topicseen

I have tried checking and repairing all the tables in my database (though I do not think it is a DB issue as all other functions that query the DB seem to update without error)

The only other thing that I can think of is that I restarted my web server this morning - I checked the MYSQL logs though and everything shutdown and came up fine without any error, my Apache logs report everything fine as well. I have not added any new software to my machine or made any configuration changes.

If anyone else has any idea as to what is going on it would be greatly appreciated.

[Nibbler]

The update script has code to correct that, it that didnt work then run the query manually.

Code: [Select]

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

[JCDenton]

Thanks Nibbler, you are a genious!  That worked perfectly.