HUGE problem with new user registration !!! SOLVED !!! :D

Private Joined: Sep 10, 2003 Posts: 47 Location: Holland

I have set up a new nukephp site version 6.8 with protector 1.3b
and copermine.
I also used a script top copy all my exsisting users from my phpbb forum.

The problem now is that if a new user registers he gets this:

New User Account Created!

Welcome! You are now registered as a member.

Your request for a new account has been processed. You'll receive an email in the next few seconds with a activation link that should be visited in the next 24 hours to be able to activate your account.

Thank you for registering at The Cybertron Archive!

---------------------------------------------

Than you go to your mail box click the link and fill out the username and passworde and sec code.

After that you will see this

+++++++++++++++++++++++++
New User Activation Error

There is no user in the database with this information.

You can register a new user from here
+++++++++++++++++++++++++

I have also been looking in the nuke_users and nuke_user_temp but I cant find any thing that could cause this problem.

The only thing I have found is that in stead of the short user ID numbers for example user 33 the numbers have changed to 876785233

Could this be the problem ???

For example I have 750 users and with that longer ID number
with lots of digits 9879788966

If A user regesters it would be normal that he gets 751 in stead of 8709870987. Can it be that if I use 751 as an empty record it will continue to regester new members again.

I realy need some help out here I have spend 4 damm days trying to find a solution and no one does or is willing to help me out on this. It also can be that some people dont even know this problem.

Try for your selves http://www.tfarchive.org and register.

PS.
I have taken a look at my config.php and I think that it is correct

Code:

$dbhost = "localhost";
$dbuname = "my user";
$dbpass = "password";
$dbname = "the DB";
$prefix = "nuke";
$user_prefix = "nuke";
$dbtype = "MySQL";
$sitekey = "example*fa28367-dz589769.3a2fcc+e9";

Below is the script I used to copy phpbb to phpnuke

Code:

<?php
/****************************************************************
* phpBB2 to BB2Nuke (c) 2003 Andareed
* Fixed June 2003 UKForums - http://www.ruleit.co.uk/nuke
*
* This converter is released under the GNU GPL license
*
* You will need to manually edit/update your config table
****************************************************************/

// MODIFY THE ENTRIES BELOW TO YOU DATABASE!!!

set_time_limit(0);
include ("config.php");

//phpBB2 variables
$p_user="XXXXX";
$p_pass="XXXXX";
$p_db="XXXXX";
$p_host="localhost";
$p_prefix="phpbb";

// DO NOT MODIFY ANYTHING BELOW !!!

//PHP-Nuke Variables from config.php
$n_user="$dbuname";
$n_pass="$dbpass";
$n_db="$dbname";
$n_host="$dbhost";
$n_prefix="$prefix";

//connect to db's
$p_con=mysql_connect($p_host,$p_user,$p_pass);
$n_con=mysql_connect($n_host,$n_user,$n_pass);

error_reporting(E_ALL);

// DELETE OLD TABLE DATA

mysql_select_db($n_db,$n_con) or mysql_error();
mysql_query("DELETE FROM {$n_prefix}_bbauth_access",$n_con) or mysql_error();
mysql_query("DELETE FROM {$n_prefix}_bbbanlist",$n_con) or mysql_error();
mysql_query("DELETE FROM {$n_prefix}_bbcategories",$n_con) or mysql_error();
//mysql_query("DELETE FROM {$n_prefix}_bbconfig",$n_con) or mysql_error();
mysql_query("DELETE FROM {$n_prefix}_bbdisallow",$n_con) or mysql_error();
mysql_query("DELETE FROM {$n_prefix}_bbforum_prune",$n_con) or mysql_error();
mysql_query("DELETE FROM {$n_prefix}_bbforums",$n_con) or mysql_error();
mysql_query("DELETE FROM {$n_prefix}_bbgroups",$n_con) or mysql_error();
mysql_query("DELETE FROM {$n_prefix}_bbposts",$n_con) or mysql_error();
mysql_query("DELETE FROM {$n_prefix}_bbposts_text",$n_con) or mysql_error();
mysql_query("DELETE FROM {$n_prefix}_bbprivmsgs",$n_con) or mysql_error();
mysql_query("DELETE FROM {$n_prefix}_bbprivmsgs_text",$n_con) or mysql_error();
mysql_query("DELETE FROM {$n_prefix}_bbranks",$n_con) or mysql_error();
mysql_query("DELETE FROM {$n_prefix}_bbsearch_results",$n_con) or mysql_error();
//mysql_query("DELETE FROM {$n_prefix}_bbsearch_wordlist",$n_con) or mysql_error();
//mysql_query("DELETE FROM {$n_prefix}_bbsearch_wordmatch",$n_con) or mysql_error();
mysql_query("DELETE FROM {$n_prefix}_bbsessions",$n_con) or mysql_error();
mysql_query("DELETE FROM {$n_prefix}_bbsmilies",$n_con) or mysql_error();
mysql_query("DELETE FROM {$n_prefix}_bbthemes",$n_con) or mysql_error();
mysql_query("DELETE FROM {$n_prefix}_bbthemes_name",$n_con) or mysql_error();
mysql_query("DELETE FROM {$n_prefix}_bbtopics",$n_con) or mysql_error();
mysql_query("DELETE FROM {$n_prefix}_bbtopics_watch",$n_con) or mysql_error();
mysql_query("DELETE FROM {$n_prefix}_bbuser_group",$n_con) or mysql_error();
mysql_query("DELETE FROM {$n_prefix}_users",$n_con) or mysql_error();
mysql_query("DELETE FROM {$n_prefix}_bbvote_desc",$n_con) or mysql_error();
mysql_query("DELETE FROM {$n_prefix}_bbvote_results",$n_con) or mysql_error();
mysql_query("DELETE FROM {$n_prefix}_bbvote_voters",$n_con) or mysql_error();
mysql_query("DELETE FROM {$n_prefix}_bbwords",$n_con) or mysql_error();

// START EXPORTING/IMPORTING

global $row,$result,$count;
mysql_select_db($p_db,$p_con);

// phpbb_auth_access
mysql_select_db($p_db,$p_con);
$result=mysql_query("SELECT * FROM {$p_prefix}_auth_access",$p_con);
$count=mysql_num_fields($result);
mysql_select_db($n_db,$n_con) or mysql_error();
while($row=mysql_fetch_array($result))
{
fixQuotes();
mysql_query("INSERT INTO {$n_prefix}_bbauth_access SET
group_id='{$row['group_id']}',
forum_id='{$row['forum_id']}',
auth_view='{$row['auth_view']}',
auth_read='{$row['auth_read']}',
auth_post='{$row['auth_post']}',
auth_reply='{$row['auth_reply']}',
auth_edit='{$row['auth_edit']}',
auth_delete='{$row['auth_delete']}',
auth_sticky='{$row['auth_sticky']}',
auth_announce='{$row['auth_announce']}',
auth_vote='{$row['auth_vote']}',
auth_pollcreate='{$row['auth_pollcreate']}',
auth_attachments='{$row['auth_attachments']}',
auth_mod='{$row['auth_mod']}'
",$n_con) or mysql_error();
}
mysql_free_result($result);

// phpbb_banlist
mysql_select_db($p_db,$p_con);
$result=mysql_query("SELECT * FROM {$p_prefix}_banlist",$p_con);
$count=mysql_num_fields($result);
mysql_select_db($n_db,$n_con) or mysql_error();
while($row=mysql_fetch_array($result))
{
fixQuotes();
mysql_query("INSERT INTO {$n_prefix}_banlist SET
ban_id='{$row['ban_id']}',
ban_userid='{$row['ban_userid']}',
ban_ip='{$row['ban_ip']}',
ban_email='{$row['ban_email']}'
",$n_con) or mysql_error();
}
mysql_free_result($result);

// phpbb_categories
mysql_select_db($p_db,$p_con);
$result=mysql_query("SELECT * FROM {$p_prefix}_categories",$p_con);
$count=mysql_num_fields($result);
mysql_select_db($n_db,$n_con) or mysql_error();
while($row=mysql_fetch_array($result))
{
fixQuotes();
mysql_query("INSERT INTO {$n_prefix}_bbcategories SET
cat_id='{$row['cat_id']}',
cat_title='{$row['cat_title']}',
cat_order='{$row['cat_order']}'
",$n_con) or mysql_error();
}
mysql_free_result($result);

// phpbb_config
/*mysql_select_db($p_db,$p_con);
$result=mysql_query("SELECT * FROM {$p_prefix}_config",$p_con);
$count=mysql_num_fields($result);
mysql_select_db($n_db,$n_con) or mysql_error();
while($row=mysql_fetch_array($result))
{
fixQuotes();
mysql_query("INSERT INTO {$n_prefix}_bbconfig SET
config_name='{$row['config_name']}',
config_value='{$row['config_value']}'
",$n_con) or mysql_error();
}
mysql_free_result($result);*/

// phpbb_disallow
mysql_select_db($p_db,$p_con);
$result=mysql_query("SELECT * FROM {$p_prefix}_disallow",$p_con);
$count=mysql_num_fields($result);
mysql_select_db($n_db,$n_con) or mysql_error();
while($row=mysql_fetch_array($result))
{
fixQuotes();
mysql_query("INSERT INTO {$n_prefix}_bbdisallow SET
disallow_id='{$row['disallow_id']}',
disallow_username='{$row['disallow_username']}'
",$n_con) or mysql_error();
}
mysql_free_result($result);

// phpbb_forum_prune
// FIXED BY UKFORUMS
mysql_select_db($p_db,$p_con);
$result=mysql_query("SELECT * FROM {$p_prefix}_forum_prune",$p_con);
$count=mysql_num_fields($result);
mysql_select_db($n_db,$n_con) or mysql_error();
while($row=mysql_fetch_array($result))
{

fixQuotes();
mysql_query("INSERT INTO {$n_prefix}_bbforum_prune SET
prune_id='{$row['prune_id']}',
forum_id='{$row['forum_id']}',
prune_days='{$row['prune_days']}',
prune_freq='{$row['prune_freq']}'
",$n_con) or mysql_error();
}
mysql_free_result($result);

// phpbb_forums
mysql_select_db($p_db,$p_con);
$result=mysql_query("SELECT * FROM {$p_prefix}_forums",$p_con);
$count=mysql_num_fields($result);
mysql_select_db($n_db,$n_con) or mysql_error();
while($row=mysql_fetch_array($result))
{
fixQuotes();
mysql_query("INSERT INTO {$n_prefix}_bbforums SET
forum_id='{$row['forum_id']}',
cat_id='{$row['cat_id']}',
forum_name='{$row['forum_name']}',
forum_desc='{$row['forum_desc']}',
forum_status='{$row['forum_status']}',
forum_order='{$row['forum_order']}',
forum_posts='{$row['forum_posts']}',
forum_topics='{$row['forum_topics']}',
forum_last_post_id='{$row['forum_last_post_id']}',
prune_next='{$row['prune_next']}',
prune_enable='{$row['prune_enable']}',
auth_view='{$row['auth_view']}',
auth_read='{$row['auth_read']}',
auth_post='{$row['auth_post']}',
auth_reply='{$row['auth_reply']}',
auth_edit='{$row['auth_edit']}',
auth_delete='{$row['auth_delete']}',
auth_sticky='{$row['auth_sticky']}',
auth_announce='{$row['auth_announce']}',
auth_vote='{$row['auth_vote']}',
auth_pollcreate ='{$row['auth_pollcreate']}',
auth_attachments ='{$row['auth_attachments']}'
",$n_con) or mysql_error();
}
mysql_free_result($result);

// phpbb_groups
mysql_select_db($p_db,$p_con);
$result=mysql_query("SELECT * FROM {$p_prefix}_groups",$p_con);
$count=mysql_num_fields($result);
mysql_select_db($n_db,$n_con) or mysql_error();
while($row=mysql_fetch_array($result))
{
fixQuotes();
mysql_query("INSERT INTO {$n_prefix}_bbgroups SET
group_id='{$row['group_id']}',
group_type='{$row['group_type']}',
group_name='{$row['group_name']}',
group_description='{$row['group_description']}',
group_moderator='{$row['group_moderator']}',
group_single_user='{$row['group_single_user']}'
",$n_con) or mysql_error();
}
mysql_free_result($result);

// phpbb_posts
mysql_select_db($p_db,$p_con);
$result=mysql_query("SELECT * FROM {$p_prefix}_posts",$p_con);
$count=mysql_num_fields($result);
mysql_select_db($n_db,$n_con) or mysql_error();
while($row=mysql_fetch_array($result))
{
fixQuotes();
mysql_query("INSERT INTO {$n_prefix}_bbposts SET
post_id='{$row['post_id']}',
topic_id='{$row['topic_id']}',
forum_id='{$row['forum_id']}',
poster_id='{$row['poster_id']}',
post_time='{$row['post_time']}',
poster_ip='{$row['poster_ip']}',
post_username='{$row['post_username']}',
enable_bbcode='{$row['enable_bbcode']}',
enable_html='{$row['enable_html']}',
enable_smilies='{$row['enable_smilies']}',
enable_sig='{$row['enable_sig']}',
post_edit_time='{$row['post_edit_time']}',
post_edit_count='{$row['post_edit_count']}'
",$n_con) or mysql_error();
}
mysql_free_result($result);

// phpbb_posts_text
mysql_select_db($p_db,$p_con);
$result=mysql_query("SELECT * FROM {$p_prefix}_posts_text",$p_con);
$count=mysql_num_fields($result);
mysql_select_db($n_db,$n_con) or mysql_error();
while($row=mysql_fetch_array($result))
{
fixQuotes();
mysql_query("INSERT INTO {$n_prefix}_bbposts_text SET
post_id='{$row['post_id']}',
bbcode_uid='{$row['bbcode_uid']}',
post_subject='{$row['post_subject']}',
post_text='{$row['post_text']}'
",$n_con) or mysql_error();
}
mysql_free_result($result);

// phpbb_privmsgs
mysql_select_db($p_db,$p_con);
$result=mysql_query("SELECT * FROM {$p_prefix}_privmsgs",$p_con);
$count=mysql_num_fields($result);
mysql_select_db($n_db,$n_con) or mysql_error();
while($row=mysql_fetch_array($result))
{
fixQuotes();

mysql_query("INSERT INTO {$n_prefix}_bbprivmsgs SET
privmsgs_id='{$row['privmsgs_id']}',
privmsgs_type='{$row['privmsgs_type']}',
privmsgs_subject='{$row['privmsgs_subject']}',
privmsgs_from_userid='{$row['privmsgs_from_userid']}',
privmsgs_to_userid='{$row['privmsgs_to_userid']}',
privmsgs_date='{$row['privmsgs_date']}',
privmsgs_ip='{$row['privmsgs_ip']}',
privmsgs_enable_bbcode='{$row['privmsgs_enable_bbcode']}',
privmsgs_enable_html='{$row['privmsgs_enable_html']}',
privmsgs_enable_smilies='{$row['privmsgs_enable_smilies']}',
privmsgs_attach_sig='{$row['privmsgs_attach_sig']}'
",$n_con) or mysql_error();
}
mysql_free_result($result);

// phpbb_privmsgs_text
mysql_select_db($p_db,$p_con);
$result=mysql_query("SELECT * FROM {$p_prefix}_privmsgs_text",$p_con);
$count=mysql_num_fields($result);
mysql_select_db($n_db,$n_con) or mysql_error();
while($row=mysql_fetch_array($result))
{
fixQuotes();
mysql_query("INSERT INTO {$n_prefix}_bbprivmsgs_text SET
privmsgs_text_id='{$row['privmsgs_text_id']}',
privmsgs_bbcode_uid='{$row['privmsgs_bbcode_uid']}',
privmsgs_text='{$row['privmsgs_text']}'
",$n_con) or mysql_error();
}
mysql_free_result($result);

// phpbb_ranks
mysql_select_db($p_db,$p_con);
$result=mysql_query("SELECT * FROM {$p_prefix}_ranks",$p_con);
$count=mysql_num_fields($result);
mysql_select_db($n_db,$n_con) or mysql_error();
while($row=mysql_fetch_array($result))
{
fixQuotes();
mysql_query("INSERT INTO {$n_prefix}_bbranks SET
rank_id='{$row['rank_id']}',
rank_title='{$row['rank_title']}',
rank_min='{$row['rank_min']}',
rank_special='{$row['rank_special']}',
rank_image='{$row['rank_image']}'
",$n_con) or mysql_error();
}
mysql_free_result($result);

// phpbb_search_results
mysql_select_db($p_db,$p_con);
$result=mysql_query("SELECT * FROM {$p_prefix}_search_results",$p_con);
$count=mysql_num_fields($result);
mysql_select_db($n_db,$n_con) or mysql_error();
while($row=mysql_fetch_array($result))
{
fixQuotes();
mysql_query("INSERT INTO {$n_prefix}_bbsearch_results SET
search_id='{$row['search_id']}',
session_id='{$row['session_id']}',
search_array='{$row['search_array']}'
",$n_con) or mysql_error();
}
mysql_free_result($result);

// phpbb_search_wordlist
/*mysql_select_db($p_db,$p_con);
$result=mysql_query("SELECT * FROM {$p_prefix}_search_wordlist",$p_con);
$count=mysql_num_fields($result);
mysql_select_db($n_db,$n_con) or mysql_error();
while($row=mysql_fetch_array($result))
{
fixQuotes();
mysql_query("INSERT INTO {$n_prefix}_bbsearch_wordlist SET
word_text='{$row['word_text']}',
word_id='{$row['word_id']}',
word_common='{$row['word_common']}'
",$n_con) or mysql_error();
}
mysql_free_result($result);*/

// phpbb_search_wordmatch
/*mysql_select_db($p_db,$p_con);
$result=mysql_query("SELECT * FROM {$p_prefix}_search_wordmatch",$p_con);
$count=mysql_num_fields($result);
mysql_select_db($n_db,$n_con) or mysql_error();
while($row=mysql_fetch_array($result))
{
fixQuotes();
mysql_query("INSERT INTO {$n_prefix}_bbsearch_wordmatch SET
post_id='{$row['post_id']}',
word_id='{$row['word_id']}',
title_match='{$row['title_match']}'
",$n_con) or mysql_error();
}
mysql_free_result($result);*/

// phpbb_sessions
mysql_select_db($p_db,$p_con);
$result=mysql_query("SELECT * FROM {$p_prefix}_sessions",$p_con);
$count=mysql_num_fields($result);
mysql_select_db($n_db,$n_con) or mysql_error();
while($row=mysql_fetch_array($result))
{
fixQuotes();
mysql_query("INSERT INTO {$n_prefix}_bbsessions SET
session_id='{$row['session_id']}',
session_user_id='{$row['session_user_id']}',
session_start='{$row['session_start']}',
session_time='{$row['session_time']}',
session_ip='{$row['session_ip']}',
session_page='{$row['session_page']}',
session_logged_in='{$row['session_logged_in']}'
",$n_con) or mysql_error();
}
mysql_free_result($result);

// phpbb_smilies
mysql_select_db($p_db,$p_con);
$result=mysql_query("SELECT * FROM {$p_prefix}_smilies",$p_con);
$count=mysql_num_fields($result);
mysql_select_db($n_db,$n_con) or mysql_error();
while($row=mysql_fetch_array($result))
{
fixQuotes();
mysql_query("INSERT INTO {$n_prefix}_bbsmilies SET
smilies_id='{$row['smilies_id']}',
code='{$row['code']}',
smile_url='{$row['smile_url']}',
emoticon='{$row['emoticon']}'
",$n_con) or mysql_error();
}
mysql_free_result($result);

// phpbb_themes
mysql_select_db($p_db,$p_con);
$result=mysql_query("SELECT * FROM {$p_prefix}_themes",$p_con);
$count=mysql_num_fields($result);
mysql_select_db($n_db,$n_con) or mysql_error();
while($row=mysql_fetch_array($result))
{
fixQuotes();
mysql_query("INSERT INTO {$n_prefix}_bbthemes SET
themes_id='{$row['themes_id']}',
template_name='{$row['template_name']}',
style_name='{$row['style_name']}',
head_stylesheet='{$row['head_stylesheet']}',
body_background='{$row['body_background']}',
body_bgcolor='{$row['body_bgcolor']}',
body_text='{$row['body_text']}',
body_link='{$row['body_link']}',
body_vlink='{$row['body_vlink']}',
body_alink='{$row['body_alink']}',
body_hlink='{$row['body_hlink']}',
tr_color1='{$row['tr_color1']}',
tr_color2='{$row['tr_color2']}',
tr_color3='{$row['tr_color3']}',
tr_class1='{$row['tr_class1']}',
tr_class2='{$row['tr_class2']}',
tr_class3='{$row['tr_class3']}',
th_color1='{$row['th_color1']}',
th_color2='{$row['th_color2']}',
th_color3='{$row['th_color3']}',
th_class1='{$row['th_class1']}',
th_class2='{$row['th_class2']}',
th_class3='{$row['th_class3']}',
td_color1='{$row['td_color1']}',
td_color2='{$row['td_color2']}',
td_color3='{$row['td_color3']}',
td_class1='{$row['td_class1']}',
td_class2='{$row['td_class2']}',
td_class3='{$row['td_class3']}',
fontface1='{$row['fontface1']}',
fontface2='{$row['fontface2']}',
fontface3='{$row['fontface3']}',
fontsize1='{$row['fontsize1']}',
fontsize2='{$row['fontsize2']}',
fontsize3='{$row['fontsize3']}',
fontcolor1='{$row['fontcolor1']}',
fontcolor2='{$row['fontcolor2']}',
fontcolor3='{$row['fontcolor3']}',
span_class1='{$row['span_class1']}',
span_class2='{$row['span_class2']}',
span_class3='{$row['span_class3']}',
img_size_poll='{$row['img_size_poll']}',
img_size_privmsg='{$row['img_size_privmsg']}'
",$n_con) or mysql_error();
}
mysql_free_result($result);

// phpbb_themes_name
mysql_select_db($p_db,$p_con);
$result=mysql_query("SELECT * FROM {$p_prefix}_themes_name",$p_con);
$count=mysql_num_fields($result);
mysql_select_db($n_db,$n_con) or mysql_error();
while($row=mysql_fetch_array($result))
{
fixQuotes();
mysql_query("INSERT INTO {$n_prefix}_bbthemes_name SET
themes_id='{$row['themes_id']}',
tr_color1_name='{$row['tr_color1_name']}',
tr_color2_name='{$row['tr_color2_name']}',
tr_color3_name='{$row['tr_color3_name']}',
tr_class1_name='{$row['tr_class1_name']}',
tr_class2_name='{$row['tr_class2_name']}',
tr_class3_name='{$row['tr_class3_name']}',
th_color1_name='{$row['th_color1_name']}',
th_color2_name='{$row['th_color2_name']}',
th_color3_name='{$row['th_color3_name']}',
th_class1_name='{$row['th_class1_name']}',
th_class2_name='{$row['th_class2_name']}',
th_class3_name='{$row['th_class3_name']}',
td_color1_name='{$row['td_color1_name']}',
td_color2_name='{$row['td_color2_name']}',
td_color3_name='{$row['td_color3_name']}',
td_class1_name='{$row['td_class1_name']}',
td_class2_name='{$row['td_class2_name']}',
td_class3_name='{$row['td_class3_name']}',
fontface1_name='{$row['fontface1_name']}',
fontface2_name='{$row['fontface2_name']}',
fontface3_name='{$row['fontface3_name']}',
fontsize1_name='{$row['fontsize1_name']}',
fontsize2_name='{$row['fontsize2_name']}',
fontsize3_name='{$row['fontsize3_name']}',
fontcolor1_name='{$row['fontcolor1_name']}',
fontcolor2_name='{$row['fontcolor2_name']}',
fontcolor3_name='{$row['fontcolor3_name']}',
span_class1_name='{$row['span_class1_name']}',
span_class2_name='{$row['span_class2_name']}',
span_class3_name='{$row['span_class3_name']}'
",$n_con) or mysql_error();
}
mysql_free_result($result);

// phpbb_topics
mysql_select_db($p_db,$p_con);
$result=mysql_query("SELECT * FROM {$p_prefix}_topics",$p_con);
$count=mysql_num_fields($result);
mysql_select_db($n_db,$n_con) or mysql_error();
while($row=mysql_fetch_array($result))
{
fixQuotes();
mysql_query("INSERT INTO {$n_prefix}_bbtopics SET
topic_id='{$row['topic_id']}',
forum_id='{$row['forum_id']}',
topic_title='{$row['topic_title']}',
topic_poster='{$row['topic_poster']}',
topic_time='{$row['topic_time']}',
topic_views='{$row['topic_views']}',
topic_replies='{$row['topic_replies']}',
topic_status='{$row['topic_status']}',
topic_vote='{$row['topic_vote']}',
topic_type='{$row['topic_type']}',
topic_first_post_id='{$row['topic_first_post_id']}',
topic_last_post_id='{$row['topic_last_post_id']}',
topic_moved_id='{$row['topic_moved_id']}'
",$n_con) or mysql_error();
}
mysql_free_result($result);

// phpbb_topics_watch
mysql_select_db($p_db,$p_con);
$result=mysql_query("SELECT * FROM {$p_prefix}_topics_watch",$p_con);
$count=mysql_num_fields($result);
mysql_select_db($n_db,$n_con) or mysql_error();
while($row=mysql_fetch_array($result))
{
fixQuotes();
mysql_query("INSERT INTO {$n_prefix}_bbtopics_watch SET
topic_id='{$row['topic_id']}',
user_id='{$row['user_id']}',
notify_status='{$row['notify_status']}'
",$n_con) or mysql_error();
}
mysql_free_result($result);

// phpbb_user_group
mysql_select_db($p_db,$p_con);
$result=mysql_query("SELECT * FROM {$p_prefix}_user_group",$p_con);
$count=mysql_num_fields($result);
mysql_select_db($n_db,$n_con) or mysql_error();
while($row=mysql_fetch_array($result))
{
fixQuotes();
mysql_query("INSERT INTO {$n_prefix}_bbuser_group SET
group_id='{$row['group_id']}',
user_id='{$row['user_id']}',
user_pending='{$row['user_pending']}'
",$n_con) or mysql_error();
}
mysql_free_result($result);

// phpbb_users
//FIXED BY UKFORUMS
mysql_select_db($p_db,$p_con);
$result=mysql_query("SELECT * FROM {$p_prefix}_users",$p_con);
$count=mysql_num_fields($result);
mysql_select_db($n_db,$n_con) or mysql_error();
while($row=mysql_fetch_array($result))
{
fixQuotes();
$row['user_regdate'] = date("M j, Y", $row['user_regdate']);
mysql_query("INSERT INTO {$n_prefix}_users SET
user_id='{$row['user_id']}',
user_active='{$row['user_active']}',
name='{$row['username']}',
username='{$row['username']}',
user_password='{$row['user_password']}',
user_session_time='{$row['user_session_time']}',
user_session_page='{$row['user_session_page']}',
user_lastvisit='{$row['user_lastvisit']}',
user_regdate='{$row['user_regdate']}',
user_level='{$row['user_level']}',
user_posts='{$row['user_posts']}',
user_timezone='{$row['user_timezone']}',
user_style='{$row['user_style']}',
user_lang='{$row['user_lang']}',
user_dateformat='{$row['user_dateformat']}',
user_new_privmsg='{$row['user_new_privmsg']}',
user_unread_privmsg='{$row['user_unread_privmsg']}',
user_last_privmsg='{$row['user_last_privmsg']}',
user_emailtime='{$row['user_emailtime']}',
user_viewemail='{$row['user_viewemail']}',
user_attachsig='{$row['user_attachsig']}',
user_allowhtml='{$row['user_allowhtml']}',
user_allowbbcode='{$row['user_allowbbcode']}',
user_allowsmile='{$row['user_allowsmile']}',
user_allowavatar='{$row['user_allowavatar']}',
user_allow_pm='{$row['user_allow_pm']}',
user_allow_viewonline='{$row['user_allow_viewonline']}',
user_notify='{$row['user_notify']}',
user_notify_pm='{$row['user_notify_pm']}',
user_popup_pm='{$row['user_popup_pm']}',
user_rank='{$row['user_rank']}',
user_avatar='{$row['user_avatar']}',
user_avatar_type='{$row['user_avatar_type']}',
user_email='{$row['user_email']}',
user_icq='{$row['user_icq']}',
user_website='{$row['user_website']}',
user_from='{$row['user_from']}',
user_sig='{$row['user_sig']}',
user_sig_bbcode_uid='{$row['user_sig_bbcode_uid']}',
user_aim='{$row['user_aim']}',
user_yim='{$row['user_yim']}',
user_msnm='{$row['user_msnm']}',
user_occ='{$row['user_occ']}',
user_interests='{$row['user_interests']}',
user_actkey='{$row['user_actkey']}',
user_newpasswd='{$row['user_newpasswd']}'
",$n_con) or mysql_error();
}
mysql_free_result($result);

// phpbb_vote_desc
mysql_select_db($p_db,$p_con);
$result=mysql_query("SELECT * FROM {$p_prefix}_vote_desc",$p_con);
$count=mysql_num_fields($result);
mysql_select_db($n_db,$n_con) or mysql_error();
while($row=mysql_fetch_array($result))
{
fixQuotes();
mysql_query("INSERT INTO {$n_prefix}_bbvote_desc SET
vote_id='{$row['vote_id']}',
topic_id='{$row['topic_id']}',
vote_text='{$row['vote_text']}',
vote_start='{$row['vote_start']}',
vote_length='{$row['vote_length']}'
",$n_con);
}
mysql_free_result($result);

// phpbb_vote_results
mysql_select_db($p_db,$p_con);
$result=mysql_query("SELECT * FROM {$p_prefix}_vote_results",$p_con);
$count=mysql_num_fields($result);
mysql_select_db($n_db,$n_con);
while($row=mysql_fetch_array($result))
{
fixQuotes();
mysql_query("INSERT INTO {$n_prefix}_bbvote_results SET
vote_id='{$row['vote_id']}',
vote_option_id='{$row['vote_option_id']}',
vote_option_text='{$row['vote_option_text']}',
vote_result='{$row['vote_result']}'
",$n_con);
}
mysql_free_result($result);

// phpbb_vote_voters
mysql_select_db($p_db,$p_con);
$result=mysql_query("SELECT * FROM {$p_prefix}_vote_voters",$p_con);
$count=mysql_num_fields($result);
mysql_select_db($n_db,$n_con);
while($row=mysql_fetch_array($result))
{
fixQuotes();
mysql_query("INSERT INTO {$n_prefix}_bbvote_voters SET
vote_id='{$row['vote_id']}',
vote_user_id='{$row['vote_user_id']}',
vote_user_ip='{$row['vote_user_ip']}'
",$n_con);
}
mysql_free_result($result);

// phpbb_words
mysql_select_db($p_db,$p_con);
$result=mysql_query("SELECT * FROM {$p_prefix}_words",$p_con);
$count=mysql_num_fields($result);
mysql_select_db($n_db,$n_con);
while($row=mysql_fetch_array($result))
{
fixQuotes();
mysql_query("INSERT INTO {$n_prefix}_bbwords SET
word_id='{$row['word_id']}',
word='{$row['word']}',
replacement='{$row['replacement']}'
",$n_con);
}
mysql_free_result($result);

function fixQuotes()
{
global $row,$result,$count;
for($i=0;$i<$count;$i++)
{
$field=mysql_field_name($result,$i);
$row[$field]=str_replace("'","\'",$row[$i]);
}
}

phpinfo();
?>

Can any one help me with this Rolling Eyes

Posted: Thu Sep 11, 2003 6:54 am

This is the second time I have heard something like this recently, cross reference with http://nukecops.com/postlite9490-.html and maybe between you and blith you can come up with a few leads.

-sting

Private Joined: Sep 10, 2003 Posts: 47 Location: Holland

You mean there is no solution for this Shocked

Dammm bye bye 3 weeks work Crying or Very sad

Posted: Thu Sep 11, 2003 11:08 am

Quote:

You mean there is no solution for this

I didn't say that. . .
give us a wee bit more time to go through all the support staff members and find out if anyone has an idea.

-sting

Posted: Thu Sep 11, 2003 11:19 am

I just registered at your site. I got the confirmation email.
I clicked the link in the email and got this

Quote:

mike3169: Your account has been activated. Please login from this link using your assigned Nickname and Password.

However, it won't let me loggin. You can check your DB to see what my user_id is.

Have you tried the Your Accoutn tweak from nukescripts.net?
Also, you say you imported all your Data from an existing phpB into Nuke, there may be something wrong there that is the cause of this all.

You can delete the user accounts mikem and mike3169 from your site, I was just testing for you. mikem will probably stil be in the user_temp table.

Private Joined: Sep 10, 2003 Posts: 47 Location: Holland

Tanx for testing guys. I will first try the account tweek.

If that helps than its done. I will reply after I have runned the tweek to inform you guys about the progress.

Grts,
Sky Very Happy

NSN Your Account 650
Description: Features in the 3.0.2e version:
+ Fixed password issue.
+ Fixed alignment issue.
+ Fixed missing navbar in userinfo page.
+ Forced login to use username in database. i.e. Test not test
+ Added Reason for Denial message.
+ Added Reason for Deletion message.
+ Added Reason for Suspension message.
- Added Group membership expiration date to UserInfo page.
- Admins can allow user self deletion.
- Admins can block user email changes.
- Admins can block user theme changes.
- Admins can choose to bypass email activation.
- Admins can now modify pending user details.
- Admins can now view pending user details.
- Admins can resend Activation Email.
- Admins can suspend users.
- Allows for Required User approval by Admin.
- Blocks usernames with preset strings in them.
- Corrected incorrect username on UserInfo page.
- Fixed deleted/suspended users cookies still being active.
- Improved cookie killer routine for suspended and deleted accounts.
- Improved NavBar scripting.
- Optionally send the admin an email when someone registers.
- Optionally send the admin an email when someone unregisters.
- Provides for servers without mail support.
- Repaired a couple of other minor issues.
- Users can be promoted to Admins by SuperUser ONLY.
Version: 3.0.2e Filesize: 55.98 Kb
Added on: 24-May-2003 Downloads: 7314
HomePage | Details
Category: NukeScripts Scripts -> Tweaks -> 6.5.0
http://www.nukescripts.net/modules.php?name=Downloads&op=search&query=

Lieutenant Joined: Sep 09, 2003 Posts: 158

I have this exact problem....I ran the Your Accounts MOD but still no joy Crying or Very sad

Private Joined: Sep 10, 2003 Posts: 47 Location: Holland

Yep I did run the tweek but it didnt have any effect at all the only thig I see when I update my DB is this:

nuke_users 170.727 Kb Optimized! 0.129 Kb
nuke_users_config 2.04 Kb Already optimized 0 Kb
nuke_users_temp 4.848 Kb Optimized! 0.645 Kb

Now wat can it be Rolling Eyes

EDIT by Skywarp :

Oke I have tryed to add a user via the admin.php. But after I filled out the whole thing for the new user I get a blank admin page.

I tryed to add a user also via the tweek tool (modules.php?name=Your_Account&file=admin) and than I get an sql error. There is no error displyed. It only gives a error like :

Code:

SQL Error
[ Go Back ]

Weird but it looks like the user DB is locked for some reason or there is a value set that is incorrect.

Any idee's wat this can be ? Rolling Eyes

Posted: Fri Sep 12, 2003 12:10 am

skywarp wrote:

I have set up a new nukephp site version 6.8 with protector 1.3b and copermine.

Um... your META file says you're running PHP-Nuke 6.9. Are you sure it's 6.8 Question

Code:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>The Cybertron Archive </title>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=ISO-8859-1">
<META HTTP-EQUIV="EXPIRES" CONTENT="0">
<META NAME="RESOURCE-TYPE" CONTENT="DOCUMENT">
<META NAME="DISTRIBUTION" CONTENT="GLOBAL">
<META NAME="AUTHOR" CONTENT="The Cybertron Archive">
<META NAME="COPYRIGHT" CONTENT="Copyright (c) 2003 by The Cybertron Archive">
<META NAME="KEYWORDS" CONTENT="News, news, New, new, Technology, technology, Headlines, headlines, Nuke, nuke, PHP-Nuke, phpnuke, php-nuke, Geek, geek, Geeks, geeks, Hacker, hacker, Hackers, hackers, Linux, linux, Windows, windows, Software, software, Download, download, Downloads, downloads, Free, FREE, free, Community, community, MP3, mp3, Forum, forum, Forums, forums, Bulletin, bulletin, Board, board, Boards, boards, PHP, php, Survey, survey, Kernel, kernel, Comment, comment, Comments, comments, Portal, portal, ODP, odp, Open, open, Open Source, OpenSource, Opensource, opensource, open source, Free Software, FreeSoftware, Freesoftware, free software, GNU, gnu, GPL, gpl, License, license, Unix, UNIX, *nix, unix, MySQL, mysql, SQL, sql, Database, DataBase, Blogs, blogs, Blog, blog, database, Mandrake, mandrake, Red Hat, RedHat, red hat, Slackware, slackware, SUSE, SuSE, suse, Debian, debian, Gnome, GNOME, gnome, Kde, KDE, kde, Enlightenment, enlightenment, Interactive, interactive, Programming, programming, Extreme, extreme, Game, game, Games, games, Web Site, web site, Weblog, WebLog, weblog, Guru, GURU, guru, Oracle, oracle, db2, DB2, odbc, ODBC, plugin, plugins, Plugin, Plugins">
<META NAME="DESCRIPTION" CONTENT="The Cybertron Archive, an archive for Transformer fans world wide.">
<META NAME="ROBOTS" CONTENT="INDEX, FOLLOW">
<META NAME="REVISIT-AFTER" CONTENT="1 DAYS">
<META NAME="RATING" CONTENT="GENERAL">
<META NAME="GENERATOR" CONTENT="PHP-Nuke 6.9 - Copyright 2003 by http://phpnuke.org">
<LINK REL="StyleSheet" HREF="themes/Tca/style/style.css" TYPE="text/css">

If you're running Nuke 6.9, be aware that there LOTS of bogus, hacked, and corrupt copies floating around. It's possible the registration name and password is being spoofed by hackers - ppl tend to use the same ones on every site they visit, so this is valuable info to perps...

Private Joined: Sep 10, 2003 Posts: 47 Location: Holland

Is there a way to down grade ?

Posted: Fri Sep 12, 2003 12:54 am

skywarp wrote:

Is there a way to down grade ?

The easiest way is to do a restore from a recent backup...

Nuke Soldier Joined: Sep 09, 2003 Posts: 32

wait wait i had the very same problem after a using bbtonuke. all of a sudden one new user was generated with an id like 83773628 , after that people would recieve the mail but when they clicked the link nothing would happen .. the login problem described above.
all i had to do was pull up the table nuke_user in mysqladmin and manually delete the user with the highID. afterwards registrations started to get assigned lower ids again and everything works well again.
why the high id was assigned , i dont know but thats what fixed it for me.

Private Joined: Sep 10, 2003 Posts: 47 Location: Holland

backup ??? Sad

whoops

uhhhh wat is a backup Rolling Eyes

I have one but that is the compleet mysql backup Very Happy

but i guess if i set that one back i will lose all the work.

I also tryed to remove all users with high ID's and yes if you do that some peeps can reg again but they will get an high ID again.

Rolling Eyes

Is there some sort of limit or so? I dont think so Cool