Unable to create Albums

[chakoe]

Hi @ll,

i just started to install a web Server with the following configuration:

Windows 2003 Standard Server
Apache 2.0.55
PHP 5.1.1
MySQL 5.0.16
PHPMyAdmin 2.7.0pl1

Everthing works fine.
I am able to Setup my coppermine Gallery,the message, that coppermine was succesfully configured, appears.
But when I try to creat an Album, the following errormessage appears:

( It is translated from German)

There was error executing a database-query....

Can anyone help me?

Thanks in advance

[Joachim Müller]

enable debug-mode in coppermine's config, then reproduce the error and post the actual error message you get (not the debug output). A link and non-admin test user account might help as well.

[chakoe]

Hi,

i switched to debug mode an reproduced the error.

The following appeared:

While executing query "INSERT INTO cpg140_albums (category, title, uploads, pos) VALUES ('0', 'neues', 'NO',  '1')" on 0

mySQL error: Field 'description' doesn't have a default value

In file: .....htdocs\coppermine\include\functions.inc.php - Row: 248

[Nibbler]

It's a MySQL 5 issue, run the following query on your database

Code Select Expand

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

[chakoe]

Hi,

thanks!! That works fine!

[Bifrost]

I try to alter the field configuration and get this error message:

Mysql Error Number 1101
TEXT/BLOB column 'description' can not have a default value

I have 5.0.15 mySQL

I notice that on the redefinition the type of text is defined as:
CHARACTER SET latin1 COLLATE latin1_swedish_ci 

Any sugestions greatly appreciated.

To make by, I set it as allow null, which seems to work. But I ignore if it may bring some consecuences...
Please confirm if this is an aceptable workaround.