Major new user problem after 2.0.22 update (from 2.0.15)

Nuke Soldier Joined: Nov 03, 2005 Posts: 13

I have updated bbtonuke from 2.0.15 to 2.0.22 step by step and once finished I have just realised that no new users can register.

When I click submit on the forums new user reg form i get:

Code:

Could not insert data into users table

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '20, 2007, 'english', 1, 0, 1, 0, '77d89d')' at line 2

INSERT INTO nuke_users (user_id, username, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_sig_bbcode_uid, user_avatar, user_avatar_type, user_viewemail, user_aim, user_yim, user_msnm, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_timezone, user_dateformat, user_lang, user_style, user_level, user_allow_pm, user_active, user_actkey) VALUES (289, 'mcmc2', 1177092508, '2c07555a483791505569a0948643f7f3', not@telling.com', '', '', '', '', '', '', '', '', 0, 0, '', '', '', 1, 1, 1, 1, 1, 0, 1, 1, 0, Apr 20, 2007, 'english', 1, 0, 1, 0, '77d89d')

Line : 647
File : usercp_register.php

I am really stuck and need to get this working pronto!!

Any help greatly appreciated.

Cheers
Sc00by

Site Admin Joined: Aug 17, 2003 Posts: 12482

Did you run the upgrade script correctly?
Can users register through the Your_Account module?

Nuke Soldier Joined: Nov 03, 2005 Posts: 13

Thanks for the quick reply.

I have reverted back to the original usercp_register.php file from 2.0.15 and this fixes the problem, i can't see any other problems it kicks up and even the visual confirmation code works.

i run a high traffic site and was under a lot of pressure when this error kicked up so to have it working again is a godsend so i am not going to play about with it while its working

cheers
Sc00by

Sergeant Joined: Mar 03, 2007 Posts: 127

Shouldn't that Apr 20, 2007 be quoted? The way it is SQL receives 2 fields instead of one...

Nuke Soldier Joined: Nov 03, 2005 Posts: 13

I see what you mean, thats the bit that its complaining about.

I compared the same bit (probabl the wrong bit) beteen the new and currently live (and working) file but could not see what the problem could be.

An ideas on how fix?

As per my previous post I am running an old file to get round the problem but I would like to have the latest running as theres probably been some bug fixes between now and then.

Cheers
Sc00by

Sergeant Joined: Mar 03, 2007 Posts: 127

Well... I'm not a code expert, but I did update bbtonuke a few times and never had problems...
Try again... You must update every 0.01 files...

Site Admin Joined: Aug 17, 2003 Posts: 12482

In includes/usercp_register.php

Code:

FIND inline

$user_timezone, $reg_date,

CHANGE TO

$user_timezone, '$reg_date',

Nuke Soldier Joined: Nov 03, 2005 Posts: 13

cool!, that fixed it.

Much appreciated

Cheers
Sc00by