forum.coppermine-gallery.net

Support => cpg1.5.x Support => cpg1.5 install => Topic started by: viper68s on June 10, 2010, 08:38:47 am

Title: Can't create new user . MySQL-Error
Post by: viper68s on June 10, 2010, 08:38:47 am

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.

Title: Re: Can't create new user . MySQL-Error
Post by: Joachim Müller on June 10, 2010, 08:49:36 am

Don't run mySQL in strict mode!

Title: Re: Can't create new user . MySQL-Error
Post by: viper68s on June 10, 2010, 02:00:40 pm

Hi Joachim, Thanx for the reply.

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

Marcus

Title: Re: Can't create new user . MySQL-Error
Post by: Αndré on June 10, 2010, 03:22:54 pm

Quote from: viper68s on June 10, 2010, 08:38:47 am

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

Then give it the default value ''.

Title: Re: Can't create new user . MySQL-Error
Post by: Αndré on June 10, 2010, 03:28:08 pm

Some more information.


We changed the user creation in r7621 (http://coppermine.svn.sourceforge.net/viewvc/coppermine/trunk/cpg1.5.x/usermgr.php?r1=7620&r2=7621) from

Code: [Select]

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

Code: [Select]

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


We should add a default value for that column imo.

Title: Re: Can't create new user . MySQL-Error
Post by: Αndré on June 10, 2010, 03:36:46 pm

You live and learn:

Quote

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 (http://coppermine.svn.sourceforge.net/viewvc/coppermine/trunk/cpg1.5.x/usermgr.php?r1=7666&r2=7665&pathrev=7666).

Title: Re: Can't create new user . MySQL-Error
Post by: viper68s on June 14, 2010, 12:25:36 pm

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