You are missing our premiere tool bar navigation system! Register and use it for FREE!

NukeCops  
•  Home •  Downloads •  Gallery •  Your Account •  Forums • 
Readme First
- Readme First! -

Read and follow the rules, otherwise your posts will be closed
Modules
· Home
· FAQ
· Buy a Theme
· Advertising
· AvantGo
· Bookmarks
· Columbia
· Community
· Donations
· Downloads
· Feedback
· Forums
· PHP-Nuke HOWTO
· Private Messages
· Search
· Statistics
· Stories Archive
· Submit News
· Surveys
· Theme Gallery
· Top
· Topics
· Your Account
Who's Online
There are currently, 405 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) [ ]
 Forum FAQ  •  Search  •   •  Memberlist  •  Usergroups   •  Register  •  Profile •    •  Log in to check your private messages  •  Log in

 
Post new topic  Reply to topicprinter-friendly view
View previous topic Log in to check your private messages View next topic
Author Message
Sc00by
Nuke Soldier
Nuke Soldier


Joined: Nov 03, 2005
Posts: 13


PostPosted: Fri Apr 20, 2007 10:30 am Reply with quoteBack to top

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 Sad
Find all posts by Sc00byView user's profileSend private message
Evaders99
Site Admin
Site Admin


Joined: Aug 17, 2003
Posts: 12482


PostPosted: Fri Apr 20, 2007 11:28 am Reply with quoteBack to top

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

_________________
Helping those that help themselves
Read FIRST or DIE!

"Fighting is terrible, but not as terrible as losing the will to fight."
Star Wars Rebellion Network - Need Help? Evaders Squadron Coding
Find all posts by Evaders99View user's profileSend private messageVisit poster's websiteAIM Address
Sc00by
Nuke Soldier
Nuke Soldier


Joined: Nov 03, 2005
Posts: 13


PostPosted: Fri Apr 20, 2007 11:42 am Reply with quoteBack to top

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
Find all posts by Sc00byView user's profileSend private message
eXistenZe
Sergeant
Sergeant


Joined: Mar 03, 2007
Posts: 127


PostPosted: Fri Apr 20, 2007 12:53 pm Reply with quoteBack to top

Shouldn't that Apr 20, 2007 be quoted? The way it is SQL receives 2 fields instead of one...
Find all posts by eXistenZeView user's profileSend private message
Sc00by
Nuke Soldier
Nuke Soldier


Joined: Nov 03, 2005
Posts: 13


PostPosted: Sat Apr 21, 2007 2:15 am Reply with quoteBack to top

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
Find all posts by Sc00byView user's profileSend private message
eXistenZe
Sergeant
Sergeant


Joined: Mar 03, 2007
Posts: 127


PostPosted: Sat Apr 21, 2007 4:44 am Reply with quoteBack to top

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...
Find all posts by eXistenZeView user's profileSend private message
Evaders99
Site Admin
Site Admin


Joined: Aug 17, 2003
Posts: 12482


PostPosted: Sat Apr 21, 2007 7:43 pm Reply with quoteBack to top

In includes/usercp_register.php

Code:


FIND inline

$user_timezone, $reg_date,

CHANGE TO

$user_timezone, '$reg_date',

_________________
Helping those that help themselves
Read FIRST or DIE!

"Fighting is terrible, but not as terrible as losing the will to fight."
Star Wars Rebellion Network - Need Help? Evaders Squadron Coding
Find all posts by Evaders99View user's profileSend private messageVisit poster's websiteAIM Address
Sc00by
Nuke Soldier
Nuke Soldier


Joined: Nov 03, 2005
Posts: 13


PostPosted: Sun Apr 22, 2007 12:46 am Reply with quoteBack to top

cool!, that fixed it.

Much appreciated

Cheers
Sc00by Very Happy
Find all posts by Sc00byView user's profileSend private message
Display posts from previous:      
Post new topic  Reply to topicprinter-friendly view
View previous topic Log in to check your private messages View next topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2005 phpBB Group

Ported by Nuke Cops © 2003 www.nukecops.com
:: FI Theme :: PHP-Nuke theme by coldblooded (www.nukemods.com) ::
Powered by TOGETHER TEAM srl ITALY http://www.togetherteam.it - DONDELEO E-COMMERCE http://www.DonDeLeo.com - TUTTISU E-COMMERCE http://www.tuttisu.it
Web site engine's code is Copyright © 2002 by PHP-Nuke. All Rights Reserved. PHP-Nuke is Free Software released under the GNU/GPL license.
Page Generation: 0.042 Seconds - 355 pages served in past 5 minutes. Nuke Cops Founded by Paul Laudanski (Zhen-Xjell)
:: FI Theme :: PHP-Nuke theme by coldblooded (www.nukemods.com) ::