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


Author: Sc00byPostPosted: Sun Apr 22, 2007 12:46 am    Post subject:

cool!, that fixed it.

Much appreciated

Cheers
Sc00by Very Happy



Nuke Cops -> BBtoNuke Installation

All times are GMT - 8 Hours

Page 1 of 1

Powered by phpBB © 2001,2002 phpBB Group
NukeCops  
•  Home •  Downloads •  Gallery •  Your Account •  Forums • 

Author: Evaders99PostPosted: Fri Apr 20, 2007 11:28 am    Post subject:

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

Author: Sc00byPostPosted: 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

cheers
Sc00by

Author: eXistenZePostPosted: 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...

Author: Sc00byPostPosted: 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.

Cheers
Sc00by

Author: eXistenZePostPosted: 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...

Author: Evaders99PostPosted: Sat Apr 21, 2007 7:43 pm    Post subject:

In includes/usercp_register.php

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, 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)

Nuke Cops -> BBtoNuke Installation

Author: Sc00by PostPosted: 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:

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
Code:


FIND inline

$user_timezone, $reg_date,

CHANGE TO

$user_timezone, '$reg_date',
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.051 Seconds - 354 pages served in past 5 minutes. Nuke Cops Founded by Paul Laudanski (Zhen-Xjell)
added by Evaders - DO NOT REMOVE
:: FI Theme :: PHP-Nuke theme by coldblooded (www.nukemods.com) ::