Support > cpg1.5 install

Can't create new user . MySQL-Error

(1/2) > >>

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é:

--- Quote from: viper68s on June 10, 2010, 08:38:47 am ---MySQL ERROR: Field 'USER_PROFILE6' doesn't have a default value "

--- End quote ---
Then give it the default value ''.

Αndré:
Some more information.


We changed the user creation in r7621 from

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

--- Code: ---INSERT INTO {$CONFIG['TABLE_USERS']} (user_regdate) VALUES (NOW())
--- End code ---
(short version).


We should add a default value for that column imo.

Navigation

[0] Message Index

[#] Next page