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
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.
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
It's a MySQL 5 issue, run the following query on your database
ALTER TABLE `cpg140_albums` CHANGE `description` `description` TEXT NOT NULL default '';
Hi,
thanks!! That works fine!
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. :)