Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> Installation Help
Author Message
Blues
Regular
Regular



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

PostPosted: Sat Jun 17, 2006 4:46 pm Reply with quote

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?
 
View user's profile Send private message Visit poster's website
Blues







PostPosted: Sat Jun 17, 2006 4:48 pm Reply with quote

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?
 
Guardian2003
Site Admin



Joined: Aug 28, 2003
Posts: 6799
Location: Ha Noi, Viet Nam

PostPosted: Sat Jun 17, 2006 6:22 pm Reply with quote

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.
 
View user's profile Send private message Send e-mail
Blues







PostPosted: Sat Jun 17, 2006 7:06 pm Reply with quote

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.
 
Blues







PostPosted: Sat Jun 17, 2006 7:44 pm Reply with quote

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
 
gregexp
The Mouse Is Extension Of Arm



Joined: Feb 21, 2006
Posts: 1497
Location: In front of a screen....HELP! lol

PostPosted: Sat Jun 17, 2006 7:48 pm Reply with quote

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.

_________________
For those who stand shall NEVER fall and those who fall shall RISE once more!! 
View user's profile Send private message Send e-mail Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number
Blues







PostPosted: Sat Jun 17, 2006 8:26 pm Reply with quote

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.
 
gregexp







PostPosted: Sat Jun 17, 2006 10:30 pm Reply with quote

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.
 
Blues







PostPosted: Sun Jun 18, 2006 7:54 am Reply with quote

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]
 
Blues







PostPosted: Mon Jun 19, 2006 2:31 pm Reply with quote

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.
 
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> Installation Help

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©