XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. Xoops Development / 
  3. Xoops Bug Reports 
  4.  / (fixed) 2.3 Could not register new user problem
Register
1
kerkyra
(fixed) 2.3 Could not register new user problem

  • 2008/9/27 23:50

  • kerkyra

  • Just can't stay away

  • Posts: 553

  • Since: 2005/2/14


hallo there, as mentioned in some other posts i had a problem in my new 2.3 site.

I was getting an error message "could not register new user" each time someone was trying to register.

I'm using php v5.2.1 and MySQL v5.0.37 .

I turned debug on and found out that i got this error msg

Quote:
INSERT INTO `guidemap_users` (`uname`, `email`, `user_avatar`, `user_regdate`, `user_viewemail`, `actkey`, `pass`, `level`, `timezone_offset`, `umode`, `uorder`, `user_mailok`) VALUES ('kostas','mail@xxx.yyy','blank.gif',13333,0,'xxxfff333','xfgcxgeeoouuuuxxxx',0,'2','nest',0,1)
Error number: 1364
Error message: Field 'user_sig' doesn't have a default value
Error message: Field 'user_bio' doesn't have a default value


so in the file register.php i added in line 142 right after

$newuser->setVar('user_mailok',$user_mailok, true);

these two lines

$newuser->setVar('user_sig','', true);
$newuser->setVar('bio','', true);

now the user registration works for me! I don't know if this is a bug or just happened to me, i hope this will help someone else with the same issue.cheers
www.guidemap.gr - Beta is out...
2
ghia
Re: (fixed) 2.3 Could not register new user problem

  • 2008/9/28 1:04

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


You should not post the data for your email and encoded password.
Change your password immediately.
3
kerkyra
Re: (fixed) 2.3 Could not register new user problem

  • 2008/9/28 1:35

  • kerkyra

  • Just can't stay away

  • Posts: 553

  • Since: 2005/2/14


no worries its just dummy data :) thanks though, appreciate it :)
www.guidemap.gr - Beta is out...
4
Marco
Re: (fixed) 2.3 Could not register new user problem

  • 2008/9/28 4:50

  • Marco

  • Home away from home

  • Posts: 1256

  • Since: 2004/3/15


thanks for that feedback
added to SF bugtracker
marco
Do synergy or die.
5
sheathe
Re: (fixed) 2.3 Could not register new user problem

  • 2008/9/28 5:40

  • sheathe

  • Just popping in

  • Posts: 5

  • Since: 2008/9/26


thank you very much for the solution
6
kerkyra
Re: (fixed) 2.3 Could not register new user problem

  • 2008/9/28 13:59

  • kerkyra

  • Just can't stay away

  • Posts: 553

  • Since: 2005/2/14


Marco i saw in the SF-bugtracker that you re suggesting to put a default value in those two fields. I tried that using phpmyadmin but MySQL gave me an error msg that those blobs can't have a default value. Thats why I came up with this solution...
www.guidemap.gr - Beta is out...
7
ghia
Re: (fixed) 2.3 Could not register new user problem

  • 2008/9/28 14:18

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


Another solution would be that NULL's are allowed for these fields in the DDL.

I find it very unusual that XOOPS insist that all fields should be NOT NULL and provide defaults for all fields.
8
phppp
Re: (fixed) 2.3 Could not register new user problem

  • 2008/9/29 8:27

  • phppp

  • XOOPS Contributor

  • Posts: 2857

  • Since: 2004/1/25


You need turn off MySQL strict mode by running following command in mysql

SET @@global.sql_mode= '';
9
ghia
Re: (fixed) 2.3 Could not register new user problem

  • 2008/9/29 9:38

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


Wouldn't it be better that XOOPS use only SQL commands that complies with strict mode?
10
phppp
Re: (fixed) 2.3 Could not register new user problem

  • 2008/9/29 11:20

  • phppp

  • XOOPS Contributor

  • Posts: 2857

  • Since: 2004/1/25


Quote:

ghia_ wrote:
Wouldn't it be better that XOOPS use only SQL commands that complies with strict mode?


Yes we are working on it.
However it is safe to turn off strict mode since even if we make XOOPS core MySQL strict mode compliant, third-party modules are not guaranteed.
(1) 2 »

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

259 user(s) are online (175 user(s) are browsing Support Forums)

Members: 0

Guests: 259

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: May 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits