Can't create new user . MySQL-Error

[viper68s]

After i couldn't find a releiable solution of this problem, i am creating this new thread for this issue.

There is a thread (http://forum.coppermine-gallery.net/index.php/topic,64457.0.html)  but it is not specifying the solution in my case.

As i described in my earlier thread (http://forum.coppermine-gallery.net/index.php?topic=65424.new;topicseen#new)

I installed a fresh downloaded "CPG1.5.6" on a Windows2003 Server with IIS 6.0 /  PHP 5.2.3 and MySql 5.0.37.

After solving the problem with "show-stopper"... i tried to create a new user but it end up with following error message:

" While executing query 'INSERTINTO CPG15x_USERS (USER_REGDATE) VALUES (Now()) 'in usermgr.php on line 984

MySQL ERROR: Field 'USER_PROFILE6' doesn't have a default value "

The Server is behind a proxy but it has internet access.

Thanx for your kindly help.

[Joachim Müller]

Don't run mySQL in strict mode!

[viper68s]

Hi Joachim, Thanx for the reply.

Unfortunatly it didn't help, even i disable the 'Strict Mode' Off.

Marcus

[Αndré]

MySQL ERROR: Field 'USER_PROFILE6' doesn't have a default value "

Then give it the default value ''.

[Αndré]

Some more information.


We changed the user creation in r7621 from

Code Select Expand

INSERT INTO {$CONFIG['TABLE_USERS']}(user_regdate, user_active, user_profile6) VALUES (NOW(), 'YES', '')
to

Code Select Expand

INSERT INTO {$CONFIG['TABLE_USERS']} (user_regdate) VALUES (NOW())
(short version).


We should add a default value for that column imo.

[Αndré]

You live and learn:

MySQL-ERROR
MySQL says:
BLOB/TEXT column 'user_profile6' can't have a default value

I'll commit another approach soon. Please have a look at r7666.

[viper68s]

Sorry Andre for the late reply, i have been busy pastly in office but I will give a look. thank you again : )