- - Readme First! Read and follow the rules, otherwise your posts will be closed
There are currently, 431 guest(s) and 0 member(s) that are online. You are Anonymous user. You can register for free by clicking here
Nuke Cops :: View topic - Major new user problem after 2.0.22 update (from 2.0.15)
Major new user problem after 2.0.22 update (from 2.0.15)
Posted: Fri Apr 20, 2007 10:30 am Post subject: Major new user problem after 2.0.22 update (from 2.0.15)
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:
Could not insert data into users table
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', email@example.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.
Posted: Fri Apr 20, 2007 11:28 am Post subject:
Did you run the upgrade script correctly?
Can users register through the Your_Account module?
Posted: Fri Apr 20, 2007 11:42 am Post subject:
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
Posted: Fri Apr 20, 2007 12:53 pm Post subject:
Shouldn't that Apr 20, 2007 be quoted? The way it is SQL receives 2 fields instead of one...
Posted: Sat Apr 21, 2007 2:15 am Post subject:
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.
Posted: Sat Apr 21, 2007 4:44 am Post subject:
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...
Posted: Sat Apr 21, 2007 7:43 pm Post subject:
Posted: Sun Apr 22, 2007 12:46 am Post subject:
cool!, that fixed it.
All times are GMT - 8 Hours
© 2001,2002 phpBB Group