2.0.20 to 2.0.21 language pack error

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

OK, I am looking over the nuke_users table, and I happened to have found the pre-migartion nuke_users table and started comparing it to the phpbb_users table. I am curious as to how I would have to bump these up and make it work.

Code:

--
-- Table structure for table `phpbb_users`
--

DROP TABLE IF EXISTS `phpbb_users`;
CREATE TABLE IF NOT EXISTS `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;

Code:

--
-- Table structure for table `nuke_users`
--

CREATE TABLE `nuke_users` (
`user_id` int(11) NOT NULL auto_increment,
`name` varchar(60) NOT NULL default '',
`username` varchar(25) NOT NULL default '',
`user_email` varchar(255) NOT NULL default '',
`femail` varchar(255) NOT NULL default '',
`user_website` varchar(255) NOT NULL default '',
`user_avatar` varchar(255) NOT NULL default '',
`user_regdate` varchar(20) NOT NULL default '',
`user_icq` varchar(15) default NULL,
`user_occ` varchar(100) default NULL,
`user_from` varchar(100) default NULL,
`user_interests` varchar(150) NOT NULL default '',
`user_sig` varchar(255) default NULL,
`user_viewemail` tinyint(2) default NULL,
`user_theme` int(3) default NULL,
`user_aim` varchar(18) default NULL,
`user_yim` varchar(25) default NULL,
`user_msnm` varchar(25) default NULL,
`user_password` varchar(40) NOT NULL default '',
`storynum` tinyint(4) NOT NULL default '10',
`umode` varchar(10) NOT NULL default '',
`uorder` tinyint(1) NOT NULL default '0',
`thold` tinyint(1) NOT NULL default '0',
`noscore` tinyint(1) NOT NULL default '0',
`bio` tinytext NOT NULL,
`ublockon` tinyint(1) NOT NULL default '0',
`ublock` tinytext NOT NULL,
`theme` varchar(255) NOT NULL default '',
`commentmax` int(11) NOT NULL default '4096',
`counter` int(11) NOT NULL default '0',
`newsletter` int(1) NOT NULL default '0',
`user_posts` int(10) NOT NULL default '0',
`user_attachsig` int(2) NOT NULL default '0',
`user_rank` int(10) NOT NULL default '0',
`user_level` int(10) NOT NULL default '1',
`broadcast` tinyint(1) NOT NULL default '1',
`popmeson` tinyint(1) NOT NULL default '0',
`user_active` tinyint(1) default '1',
`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_timezone` tinyint(4) NOT NULL default '10',
`user_style` tinyint(4) default NULL,
`user_lang` varchar(255) NOT NULL default 'english',
`user_dateformat` varchar(14) NOT NULL default 'D M d, Y g:i a',
`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_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 '0',
`user_notify_pm` tinyint(1) NOT NULL default '0',
`user_popup_pm` tinyint(1) NOT NULL default '0',
`user_avatar_type` tinyint(4) NOT NULL default '3',
`user_sig_bbcode_uid` varchar(10) default NULL,
`user_actkey` varchar(32) default NULL,
`user_newpasswd` varchar(32) default NULL,
`points` int(10) default '0',
`last_ip` varchar(15) NOT NULL default '0',
`user_login_tries` smallint(5) unsigned NOT NULL default '0',
`user_last_login_try` int(11) NOT NULL default '0',
PRIMARY KEY (`user_id`),
KEY `uname` (`username`),
KEY `user_session_time` (`user_session_time`)
) TYPE=MyISAM AUTO_INCREMENT=4 ;

Now, when looking at the accounts created after installing RavenNuke, I see only 3:

Code:

INSERT INTO `nuke_users` VALUES (1, '', 'Anonymous', '', '', '', 'blank.gif', 'Nov 10, 2000', '', '', '', '', '', 0, 0, '', '', '', '', 10, '', 0, 0, 0, '', 0, '', '', 4096, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 10, NULL, 'english', 'D M d, Y g:i a', 0, 0, 0, NULL, 1, 1, 1, 1, 1, 1, 1, 1, 0, 3, NULL, NULL, NULL, 0, '0', 0, 0);
INSERT INTO `nuke_users` VALUES (2, '', 'secondch', 'secondchancerescue@rochester.rr.com', '', '', 'blank.gif', 'Jun 17, 2006', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, 'df912c4ac61267ef1f486b09d71180a9', 10, '', 0, 0, 0, '', 0, '', '', 4096, 0, 0, 0, 0, 0, 1, 1, 0, 1, 0, 0, 0, 10, NULL, 'english', 'D M d, Y g:i a', 0, 0, 0, NULL, 1, 1, 1, 1, 1, 1, 0, 0, 0, 3, NULL, NULL, NULL, 0, '0', 0, 0);
INSERT INTO `nuke_users` VALUES (3, '', 'secondch', 'secondchancerescue@rochester.rr.com', '', '', 'blank.gif', 'Jun 17, 2006', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, 'df912c4ac61267ef1f486b09d71180a9', 10, '', 0, 0, 0, '', 0, '', '', 4096, 0, 0, 0, 0, 0, 1, 1, 0, 1, 0, 0, 0, 10, NULL, 'english', 'D M d, Y g:i a', 0, 0, 0, NULL, 1, 1, 1, 1, 1, 1, 0, 0, 0, 3, NULL, NULL, NULL, 0, '0', 0, 0);

Based on the difference in fields within the two tables, do I need to go through each user's line in the phpbb_users table and ensure there is a value for each field outlined in the nuke_users table? Not sure if that makes sense, but what I am getting at is do I have to "line by line" manually match up the fields to ensure they are accurate?

fkelly · Posted: Thu Jun 22, 2006 7:44 pm

As you are seeing, doing a conversion like this is a complicated and intricate task. You are missing at least several fields from the latest RavenNuke user table -- user_last_login and user_login_tries I think they are. And there are many differences between your user table which is converted from PHPBB and the nuke one. Some may not cause a problem but others can come back to haunt you at any point.

You can get the Nuke user table structure from the latest release of Ravennuke. Look in the installation directory and the sql directory within that and I think it's rn76_core_pl32.sql. I would post it if I had more time but I don't tonight. You might want to back your current table up and then delete all the fields that aren't in the rn76 table and add in those that are in rn76 but not in yours.

gregexp · Posted: Thu Jun 22, 2006 9:41 pm

i will post back in just a few with a working update script ..it will be a simple update the users table and then change the name to nuke_users

so back up ur database be4 runnin this script....i cant say this is a FULL phpbb to nuke sql conversion but it will make ur transition of users

gregexp · Posted: Thu Jun 22, 2006 10:25 pm

forgive me but i cant find a way to do this via phpmyadmin..im thinkin though that a php script can do this with a bit more ease then phpmyadmin...my THEORY is that to make a phpscript designed to pull all the data out of the database...assign variables too that data and the insert it into the new database table.
As I cannot find a way to alter the table structure in how it is made up.

Therfore we need to find a way to "buffer" the information and then insert in into your nuke_users table.
I will be working on this but now it is bedtime.
See you tomorrow.

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

Still unable to access the phpbb admin section. Looked over some files, but no luck at this point.

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

Guys,

Not to discredit all the help I have received thus far, as it has been incredible, but would it be easier for me to simply delete everything and re-install?

Furthermore, if I took this step, what tables would I need to convert/rename and import? Or would I simply copy/paste some of the script, such as the actual posts themselves from the phpbb_ table to the nuke_ table?

I have just come to terms that this may eventually lkead to more problems down the road if I don't ensure I have cleaned all the code.

v/r

Matt