Advanced search  

News:

cpg1.5.44 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter recently discovered vulnerabilities. It is important that all users who run version cpg1.5.42 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 13008 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: 15268
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: 15268
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: 15268
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.074 seconds with 20 queries.