Page 1 of 2

Registration error when trying to register for site

PostPosted: Fri Dec 11, 2009 1:10 pm
Author: Skell777
Recently Just started happening. The site has been working fine. Only thing that has changed is my server provider swaped the web sites IP address. Now any user that trys to register for site gets an error. Also Site seem to slow down drasticly when he switch Ip as well. Any help on these 2 problems?

Link to site is http://www.kingdomclan.com/portal.php

Error code is as followed. i may be able to post screen shot of error as well if needed.


"General Error
Could not insert data into users table

*_DEBUG MODE_*

INSERT INTO phpbb_users(username, user_realname, user_birthday,
user_gender, user_country, user_state, user_email, user_password,
phpBBSecurity_question, phpBBSecurity_answer, user_attachsig,
user_notify, user_notify_pm, user_popup_pm, user_rules, user_active,
user_actkey, user_regdate, user_id, user_split_global_announce,
user_split_announce, user_split_sticky, user_split_topic_split,
user_announcement_date_display, user_announcement_display,
user_announcement_display_forum, user_announcement_split,
user_announcement_forum, user_sub_forum, user_split_cat,
user_last_topic_title, user_sub_level_links, user_display_viewonline,
user_calendar_display_open, user_calendar_header_cells,
user_calendar_nb_row, user_calendar_birthday, user_calendar_forum,
user_last_topics_from_started, user_last_topics_from_replied,
user_last_topics_from_ended, user_last_topics_from_split,
user_last_topics_from_forum, user_style, user_lang, user_timezone,
user_summer_time, user_dateformat, user_fdow, user_allow_viewonline,
user_viewemail, user_viewpm, user_viewwebsite, user_viewmessenger,
user_viewreal, user_setbm, user_allowbbcode, user_allowhtml,
user_allowsmile, user_buddy_friend_display, user_buddy_ignore_display,
user_buddy_friend_of_display, user_buddy_ignored_by_display,
user_privmsgs_per_page, user_watched_topics_per_page,
user_topics_last_per_page, user_viewavatar, user_viewphoto,
user_viewsig, user_viewimg, user_allow_email, user_allow_pm,
user_allow_website, user_allow_messenger, user_allow_real,
user_allowavatar, user_allowphoto, user_allowsignature, user_extra,
user_posts, user_warnings, user_session_time, user_session_page,
user_lastvisit, user_level, user_new_privmsg, user_unread_privmsg,
user_last_privmsg, user_login_tries, user_last_login_try,
user_emailtime, user_rank, user_avatar, user_avatar_type, user_photo,
user_photo_type, user_icq, user_website, user_from, user_sig,
user_sig_bbcode_uid, user_aim, user_yim, user_msnm, user_skype,
user_occ, user_interests, user_newpasswd, ct_search_time,
ct_search_count, ct_last_mail, ct_last_post, ct_post_counter,
ct_last_pw_reset, ct_enable_ip_warn, ct_last_used_ip, ct_login_count,
ct_login_vconfirm, ct_last_pw_change, ct_global_msg_read,
ct_miserable_user, ct_last_ip, user_last_birthday, user_home_phone,
user_home_fax, user_work_phone, user_work_fax, user_cellular,
user_pager, user_list_option, user_allow_sig, user_points,
user_unread_topics, user_flag, user_holidays, rating_status,
user_actviate_date, user_expire_date, user_inactive_emls,
user_inactive_last_eml, phpBBSecurity_login_tries,
phpBBSecurity_pm_sent) VALUES ('[BWG]Lynx', 'Lincoln C.', '19910217',
'0', '181', '0', <a>'lincoln.coe@colinkservers.com</a>',
'8fb838a306886801bccdd74d93c45ed6', 'Check your email <img>',
'8fb838a306886801bccdd74d93c45ed6', '1', '1', '1', '1', '1260311574',
'0', 'eb9b723735c1e4f6', '1260311574', '270', '1', '1', '1', '0', '1',
'1', '1', '1', '1', '1', '1', '1', '2', '2', '0', '7', '5', '1', '1',
'3', '3', '3', '1', '1', '13', 'english', '0', '1', 'd M Y h:i a', '0',
'1', '1', '1', '1', '1', '1', '0', '1', '1', '1', '1', '1', '1', '1',
'5', '15', '15', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1',
'1', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '',
'', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '',
'', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '',
'', '', '', '', '', '', '', '', '', '', '', '')

Line : 398
File : profilcp_board_config.php"

[ Post made via Mobile Device ]

Re: Registration error when trying to register for site

PostPosted: Fri Dec 11, 2009 4:33 pm
Author: Helter
more than likely a cookie issue. Download and run cookie mod from our download section, then delete your browser cookies.
http://www.integramod.com/forum/downloa ... l&df_id=77

Re: Registration error when trying to register for site

PostPosted: Fri Dec 11, 2009 5:05 pm
Author: Skell777
roger, After I download it how to I Install it or Apply it to site, Im rather new at this kind of stuff?

[ Post made via Mobile Device ]

Re: Registration error when trying to register for site

PostPosted: Fri Dec 11, 2009 6:38 pm
Author: MWE_001
upload it to Root of your website and browse to that directory/file and run it. Do NOT change any of the settings that appear on the run screen unless you are sure you know what you are changing. The ones that it gives on run will work more than fine for you.

So for example your website is mysite.com you would upload it to Root ( where all your files and folders for IM are) navigate to http : //mysite.com/cookieMOD/cookie.php (<------ Omit the spaces obviously), then a screen will appear with some info on it. You should see a little white box under the settings, simply click that little white box and off you go.

And as Helter has pointed out, after you run it, DELETE IT! Then delete your browser cookies and that should fix the issue.

Re: Registration error when trying to register for site

PostPosted: Mon Dec 14, 2009 1:21 pm
Author: Skell777
Didn't seem to work. Program said it install successfully

Here is other error i get when trying to create and account manually in Admin control panel/User/Manage


"Could not insert data into users table

DEBUG MODE

INSERT INTO phpbb_users (user_id, username, user_regdate, user_active) VALUES (270, 'new_user', 1260811188,'0')

Line : 124
File : admin_users.php"

I deleted my cookie's on my computer and also the link on the bottom of the site when you log in. Is there another spot Im suppose to do it in? If not I would say it did not seem to fix the problem. Any other idea's?

[ Post made via Mobile Device ]

Re: Registration error when trying to register for site

PostPosted: Mon Dec 14, 2009 1:51 pm
Author: Helter
ok, looks like you may have corupted files in root/profilcp
Have you added any mods or changed anything in acp/P.C.P.?

rename your root/profilcp folder to profilcp_ and reupload a new profilcp folder with all new files, then using your ftp, empty the cache folder of all except index.html and .htaccess

Re: Registration error when trying to register for site

PostPosted: Wed Dec 16, 2009 2:13 pm
Author: Skell777
how do i get a fresh copy of profilcp folder? Do I downlaod the whole integramod 141 install folder and just extract that file?

[ Post made via Mobile Device ]

Re: Registration error when trying to register for site

PostPosted: Thu Dec 17, 2009 2:53 pm
Author: Skell777
Ok I did what you suggested, I renamed profilecp and downloaded a full copy of Integramod 141 and extracted all files. Then took extracted profile cp and uploaded it FTP into my site data base. Then I deleted cookies from my computer and tried to register account again and still got same error message as listed above. The long one. Are there more idea's I may be able to try. It seems like now that its broken 5 million people keep emailing me because they want to register. LOL

any other idea's? Or did I do something wrong that I Did not list above.

Re: Registration error when trying to register for site

PostPosted: Fri Dec 18, 2009 2:03 pm
Author: Skell777
Another file I can try?

[ Post made via Mobile Device ]

Re: Registration error when trying to register for site

PostPosted: Fri Dec 18, 2009 3:15 pm
Author: CaNNon
Did you redo any CT edits needed in the replaced files?

Code: Select all
SECURITY ALERT » » » »CBACK CrackerTracker has detected a potential attack on this site with a worm or exploit script so the Security System stopped the script.  

Re: Registration error when trying to register for site

PostPosted: Sat Dec 19, 2009 10:10 am
Author: Skell777
Im not sure what your asking? I did not make any changes to Cracker tracker. Should I? If so how?

I know there are a lot of bugs with cracker tracker but every time I get one Im not sure how to fix it. Even if Im reading the info off of integramod.com

Meaning I think Im suppose to edit script text file or something. not real sure..

Re: Registration error when trying to register for site

PostPosted: Sat Dec 19, 2009 12:27 pm
Author: Helter
looks like youve altered your register link.

correct settings in ACP/General Admin/Qbar/

Field name: Register
Shortcut]whatever you want to see in the nav bar[/i]
Mouse over]Register_explain[/color]

phpBB prog: Yes
New Window]No[/color]
Program URL: profile.php?mode=profil&sub=profile_prefer&mod=0

It is possible that youve corrupted root/includes/def_qbar.php
try replacing it with a new copy

Re: Registration error when trying to register for site

PostPosted: Sun Dec 20, 2009 11:41 am
Author: Skell777
Ok I did that, It seems to be all the same info but i copy and pasted it from your post anyways. The qbar went back to all the original stuff.

So lets recap what we have tried..

-I ran Cookie fixer
-I reuploaded root/profilcp
-I reuploaded includes/def_qbar.php
-I checked settings in ACP/General Admin/Qbar/

Any other idea's. this is a major bummer lol

[ Post made via Mobile Device ]

Re: Registration error when trying to register for site

PostPosted: Sun Dec 20, 2009 12:42 pm
Author: Helter
if you send me your ftp and phpmyadmin info, Ill take a look. I out of ideas without looking at the offending code.

Re: Registration error when trying to register for site

PostPosted: Sun Dec 20, 2009 5:03 pm
Author: Skell777
rgr i will pm them to you, thank you very much for your time.

[ Post made via Mobile Device ]