 | Cannot register |  |
 Posted: 11/18/2006 9:48 PM |
 |
|
|
|
|
| Citation |
| Posts |
940 |
| Word Cnt. |
48,215 |
| BDay |
Mar 4 |
| Sign |
Pisces |
| Sex |
 |
|
|
|
Joined: Mar 20, 2006
Local time: 12:38 PM
|
|
|
|
|
 |
I called a friend of mine to see if she could use the weather code and when she tried to register on the hobbies board she got a Debug.
I tried myself on hobbies and kitchen and found this on both.
Could not insert data into users table
DEBUG MODE
SQL Error : 1110 Column 'user_regip' specified twice
INSERT INTO phpbbhob_users (user_id, username, user_zipcode, user_regdate, user_password, user_email, user_regip, user_regip,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_show_quickreply, user_quickreply_mode, user_open_quickreply,user_lang, user_style, user_level, user_allow_pm, user_active, user_actkey) VALUES (8, 'maryann', 'HOU', 1163903379, '5d41402abc4b2a76b9719d911017c592', 'kiradawn@gmail.com', '46f0701d', '46f0701d', '', '', '', 'Texas', 'KeeKee''s alternate', '', '', '', 0, 0, '', '', '', 1, 1, 1, 1, 1, 0, 1, 1, 0, 'D M d, Y g:i a', 1, 1, 1,'english', 1, 0, 1, 0, '76dce25')
Line : 668
File : usercp_register.php
I do have the log ip on register mod installed could that be a problem?
Any idea? |
|
|
|
|
| Back to Top |
|
|
| Re: Cannot register | |
| Posted: 11/19/2006 4:18 AM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
 |
|
|
|
Joined: Sep 25, 2004
Local time: 1:38 PM
Location: St Pete, FL
|
|
|
|
|
|
Ok, the following code was added twice in the usercp_register.php file in both your Kitchen and Hobbies boards. I removed the duplication so all should be working again. I checked the other files and found no duplicated code so there's no telling what caused this...
This came from the logIPonReg/install.txt MOD script...
| Code:
|
#
#-----[ OPEN ]------------------------------------------
#
includes/usercp_register.php
#
#-----[ FIND ]------------------------------------------
# this is only a partial match
#
$sql = "INSERT INTO " . USERS_TABLE . "
#
#-----[ IN-LINE FIND ]---------------------------------
#
user_icq,
#
#-----[ IN-LINE BEFORE, ADD ]---------------------------
#
user_regip,
#
#-----[ FIND ]------------------------------------------
# this is only a partial match
#
VALUES ($user_id,
#
#-----[ IN-LINE FIND ]---------------------------------
#
. "', '" . str_replace("\'", "''", $icq)
#
#-----[ IN-LINE BEFORE, ADD ]---------------------------
#
. "', '" . $userdata['session_ip']
|
 |
|
|
|
|
| Back to Top |
|
|
| Re: Cannot register | |
| Posted: 11/19/2006 6:55 PM |
|
|
|
|
|
| Citation |
| Posts |
940 |
| Word Cnt. |
48,215 |
| BDay |
Mar 4 |
| Sign |
Pisces |
| Sex |
|
|
|
|
Joined: Mar 20, 2006
Local time: 12:38 PM
|
|
|
|
|
|
| I thought I tested after installing and all was well on test and pasadena so went on with the live ones. All is well now though. One more done with. |
|
|
|
|
| Back to Top |
|
|
| Re: Cannot register | |
| Posted: 11/20/2006 4:25 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 1:38 PM
Location: St Pete, FL
|
|
|
|
|
|
Yes, this is one more success story. I love it when it works out that way...
 |
|
|
|
|
| Back to Top |
|
|
| Information | |
|
Calendar
