Advanced search  

News:

cpg1.5.42 maintenance release - upgrade recommended
The Coppermine development team is releasing an update for Coppermine in order to fix several minor issues. All fixes are not security critical, so if your gallery is running fine with cpg1.5.36, cpg1.5.38 or cpg1.5.40 you don't need to upgrade. If you are running an older version than cpg1.5.36, you must update to this latest version as soon as possible because of the security impact!
[more]

Pages: [1]   Go Down

Author Topic: Can't create new user . MySQL-Error  (Read 12689 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: 15211
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: 15211
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: 15211
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.095 seconds with 20 queries.