User table confusion

Regular Joined: Jun 17, 2006 Posts: 81 Location: MD

OK, so I have gone through the steps of basically creating a new database within phpmyadmin and then to begin the installation of Nuke using RavenNuke 76 ver 2.02

After some errors and corrections I was finally able to get everything installed. Now, some history. I have a forum running on phpbb v 2.0.18 at the moment, and I was planning to migrate to php-nuke, but I had to keep the other up for the time being.

I exported the tables, except for some of the Mod hacks like Medal Mod and easy Mod. I then dropped the nuke_bb equivelent and imported the old phpbb version, afterwards renaming the tables as required.

After a while I got the forums up as well as posts, and now it appears the users are there as well. However, here is where I am confused. There is a user administration within Nuke, but also one within the forums administration?

I can't edit the forum users from the nuke user admin panel? I also can't login to either, but can administrate. I believe I am missing a step, or simply not understanding how these two seperate entities operate. I renamed the phpbb user table to nuke_user as I thought I was supposed to.

I have some experience administrating another forum, but all the installation was done by another member. I am used to logging in as a normal user, with moderator rights, and then having to add admin.php to the end of the address and enter another username and password to get to the admin controls within Nuke. I would really like to have something similar.

As of right now, no users can log on to the site from the main page using their previous username and password on the phpbb board.

Can someone please help me understand what I am missing?

Posted: Sat Jun 17, 2006 4:48 pm

And another note:

All the other tables required renaming the phpbb_"tablename" file to nuke_bb"tablename"

However, there was no nuke_bbusers table, so I renamed the phpbb_users table to nuke_users

Was that correct, or is that part of my problem?

Posted: Sat Jun 17, 2006 6:22 pm

phpNuke uses a version of phpBB that is ported to work with phpnuke.
In essence, phpnuke 'wraps' phpBB within it and shares some data between the nuke_users table and the phpbb tables to prevent the need to log-in twice. i.e. users do not have to log into phpnuke and then also have to log in to the ported phpbb forum.
I believe there were a number of posts here regarding moving from the stand alone phpbb version and phpnuke but I presume you ran a search for those already?

Maybe someone here who has already done this may help but I do not think it is quite as simple as renaming tables due to the way phpnuke shares its user data.

Posted: Sat Jun 17, 2006 7:06 pm

Everything I have found up to this point has pointed to the bbtonuke script/site that is no longer accessible.

At this point, I can see all the users in the table, but I can't login from either nuke or phpbb.

Posted: Sat Jun 17, 2006 7:44 pm

Now I am getting the following error when attempting to setup the forum configuration. I was attempting to apply a name to the cookie.

Failed to update general configuration for ('allow_login_for_profile',1);

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 'allow_login_for_profile',1);'' at line 3

UPDATE nuke_bbconfig SET config_value = '(''allow_login_for_profile'',1);' WHERE config_name = '('allow_login_for_profile',1);'

Line : 69
File : admin_board.php

Posted: Sat Jun 17, 2006 7:48 pm

yes u must import the phpbb_users to the nuke_users table

but heres the REAL kicker...u must examine the table structure and then make the alterations as needed...ill work on an update script for u to run..but back up the database first.

Posted: Sat Jun 17, 2006 8:26 pm

darklord wrote:

yes u must import the phpbb_users to the nuke_users table

but heres the REAL kicker...u must examine the table structure and then make the alterations as needed...ill work on an update script for u to run..but back up the database first.

Not sure I understand...are you saying I need to merge them, and make ID changes as required. Or do I drop the nuke_users and rename the phpbb_users to nuke_users. I have alreay renamed the phpbb user table and imported it to the database. But I can't log in anywhere.

Posted: Sat Jun 17, 2006 10:30 pm

i believe the STRUCTURE is different and we need to compare the tables to make sure we dont put password where username is... Laughing

just a simple structure alteration...i need to see the structure of ur phpbb_users table and i have the raven nuke table so all i need is ur structure.

Posted: Sun Jun 18, 2006 7:54 am

Code:

-- 


-- Table structure for table `phpbb_users`


-- 





CREATE TABLE `phpbb_users` (


  `user_id` mediumint(8) NOT NULL default '0',


  `user_active` tinyint(1) default '1',


  `username` varchar(25) NOT NULL default '',


  `user_password` varchar(32) NOT NULL default '',


  `user_session_time` int(11) NOT NULL default '0',


  `user_session_page` smallint(5) NOT NULL default '0',


  `user_lastvisit` int(11) NOT NULL default '0',


  `user_regdate` int(11) NOT NULL default '0',


  `user_level` tinyint(4) default '0',


  `user_posts` mediumint(8) unsigned NOT NULL default '0',


  `user_timezone` decimal(5,2) NOT NULL default '0.00',


  `user_style` tinyint(4) default NULL,


  `user_lang` varchar(255) default NULL,


  `user_dateformat` varchar(14) NOT NULL default 'd M Y H:i',


  `user_new_privmsg` smallint(5) unsigned NOT NULL default '0',


  `user_unread_privmsg` smallint(5) unsigned NOT NULL default '0',


  `user_last_privmsg` int(11) NOT NULL default '0',


  `user_emailtime` int(11) default NULL,


  `user_viewemail` tinyint(1) default NULL,


  `user_viewquickreply` tinyint(1) NOT NULL default '0',


  `user_attachsig` tinyint(1) default NULL,


  `user_allowhtml` tinyint(1) default '1',


  `user_allowbbcode` tinyint(1) default '1',


  `user_allowsmile` tinyint(1) default '1',


  `user_allowavatar` tinyint(1) NOT NULL default '1',


  `user_allow_pm` tinyint(1) NOT NULL default '1',


  `user_allow_viewonline` tinyint(1) NOT NULL default '1',


  `user_notify` tinyint(1) NOT NULL default '1',


  `user_notify_pm` tinyint(1) NOT NULL default '0',


  `user_popup_pm` tinyint(1) NOT NULL default '0',


  `user_rank` int(11) default '0',


  `user_avatar` varchar(100) default NULL,


  `user_avatar_type` tinyint(4) NOT NULL default '0',


  `user_email` varchar(255) default NULL,


  `user_icq` varchar(15) default NULL,


  `user_website` varchar(100) default NULL,


  `user_from` varchar(100) default NULL,


  `user_sig` text,


  `user_sig_bbcode_uid` varchar(10) default NULL,


  `user_aim` varchar(255) default NULL,


  `user_yim` varchar(255) default NULL,


  `user_msnm` varchar(255) default NULL,


  `user_occ` varchar(100) default NULL,


  `user_interests` varchar(255) default NULL,


  `user_actkey` varchar(32) default NULL,


  `user_newpasswd` varchar(32) default NULL,


  `user_show_quickreply` tinyint(1) NOT NULL default '1',


  `user_quickreply_mode` tinyint(1) NOT NULL default '1',


  `user_open_quickreply` tinyint(1) NOT NULL default '1',


  `user_birthday` int(8) NOT NULL default '0',


  PRIMARY KEY  (`user_id`),


  KEY `user_session_time` (`user_session_time`)


) TYPE=MyISAM;

Here is the structure-only export of the phpbb_users table.[/code]

Posted: Mon Jun 19, 2006 2:31 pm

Can anyone offer some assistance as to setting up my User table correctly? As stated above, it says I have x number of users, but I can't edit them and they don' appear to be valid from within the Nuke admin panel.