coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 install => Topic started by: parti02 on December 20, 2006, 03:44:59 PM

Title: Database Error
Post by: parti02 on December 20, 2006, 03:44:59 PM
Hi all,
for testing the gallery, i installed it on my local computer.
I create a database with MySql5:
mysqladmin -uroot -p**** create gallery

The funktion "create new user" gives an error back.

There was an error while processing a database query.
While executing query "INSERT INTO cpg1410_users(user_regdate, user_active) VALUES (NOW(), 'YES')" on 0

mySQL error: Field 'user_profile6' doesn't have a default value
File: D:\Webserver\pages\gallery\include\functions.inc.php - Line: 249

The CPG MASS IMPORT plugin show a error too in the same file.

There was an error while processing a database query.
While executing query "INSERT INTO cpg1410_categories (pos, parent, name) VALUES ('10000', '0', 'A')" on 0

mySQL error: Field 'description' doesn't have a default value
File: D:\Webserver\pages\gallery\include\functions.inc.php - Line: 249

Is it the same database problem for the 2 errors?
Must i create it by another way?

Thanks
Parti

Title: Re: Database Error
Post by: Nibbler on December 20, 2006, 04:25:13 PM
Don't run your MySQL server in strict mode if you don't know how to fix the errors it will throw at you.
Title: Re: Database Error
Post by: parti02 on December 22, 2006, 12:33:10 PM
Thx Nibbler