Advanced search  

News:

cpg1.5.36 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.34 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: Can't create new user . MySQL-Error  (Read 12445 times)

0 Members and 1 Guest are viewing this topic.

viper68s

  • Coppermine newbie
  • Offline Offline
  • Posts: 12
Can't create new user . MySQL-Error
« 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.
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47844
  • aka "GauGau"
    • gaugau.de
Re: Can't create new user . MySQL-Error
« Reply #1 on: June 10, 2010, 08:49:36 AM »

Don't run mySQL in strict mode!
Logged

viper68s

  • Coppermine newbie
  • Offline Offline
  • Posts: 12
Re: Can't create new user . MySQL-Error
« Reply #2 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

Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15039
Re: Can't create new user . MySQL-Error
« Reply #3 on: June 10, 2010, 03:22:54 PM »

MySQL ERROR: Field 'USER_PROFILE6' doesn't have a default value "
Then give it the default value ''.
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15039
Re: Can't create new user . MySQL-Error
« Reply #4 on: June 10, 2010, 03:28:08 PM »

Some more information.


We changed the user creation in r7621 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.
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15039
Re: Can't create new user . MySQL-Error
« Reply #5 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.
Logged

viper68s

  • Coppermine newbie
  • Offline Offline
  • Posts: 12
Re: Can't create new user . MySQL-Error
« Reply #6 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 : )
Logged
Pages: [1]   Go Up
 

Page created in 0.07 seconds with 19 queries.