Error upgrading to 2.0.0b1

[tiller]

Your Portal Version: 1.0.6
Your phpBB Type: Standard phpBB3
MODs installed: Yes
Your knowledge: Basic Knowledge
Boardlink: http://www.udiclan.net

What have you done before the problem was there?


What have you already tryed to solve the problem?


Description and Message
I downloaded the latest version from https://github.com/board3/Board3-Portal. I copied all the files into the correct directories and ran www.myboard/install

During the installation I received this error:

Board3 Portal
PHP Version: 5.2.17
DBMS: MySQL(i) 5.1.56
phpBB3 Version: 3.0.10

Converting from Board3 Portal 1.0.6 & adding basic set of modules
SQL ERROR Table 'mydatabase.phpbb_portal_modules' doesn't exist

Any thoughts on how to fix it? The board runs fine under 1.0.6.

Thank you.

[Shorty1968]

I am assuming that you mydatabase. the prefix. 've set for myself before phpbb_portal_modules?
make a database backup and execute the sql command in phpmyadmin or MQSL Dumper:

Code: Select all

DROP TABLE IF EXISTS `mydatabase.phpbb_portal_modules`;
CREATE TABLE `mydatabase.phpbb_portal_modules` (
  `module_id` int(3) unsigned NOT NULL auto_increment,
  `module_classname` varchar(64) collate utf8_bin NOT NULL default '',
  `module_column` tinyint(3) NOT NULL default '0',
  `module_order` tinyint(3) NOT NULL default '0',
  `module_name` varchar(255) collate utf8_bin NOT NULL default '',
  `module_image_src` varchar(255) collate utf8_bin NOT NULL default '',
  `module_image_width` int(3) NOT NULL default '0',
  `module_image_height` int(3) NOT NULL default '0',
  `module_group_ids` varchar(255) collate utf8_bin NOT NULL default '',
  `module_status` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`module_id`)
) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

/*!40000 ALTER TABLE `phpbb_portal_modules` DISABLE KEYS */;
INSERT INTO `mydatabase.phpbb_portal_modules` (`module_id`,`module_classname`,`module_column`,`module_order`,`module_name`,`module_image_src`,`module_image_width`,`module_image_height`,`module_group_ids`,`module_status`) VALUES ('1','main_menu','1','1','M_MENU','portal_menu.png','16','16','','1');
INSERT INTO `mydatabase.phpbb_portal_modules` (`module_id`,`module_classname`,`module_column`,`module_order`,`module_name`,`module_image_src`,`module_image_width`,`module_image_height`,`module_group_ids`,`module_status`) VALUES ('2','stylechanger','1','2','BOARD_STYLE','portal_style.png','16','16','','0');
INSERT INTO `mydatabase.phpbb_portal_modules` (`module_id`,`module_classname`,`module_column`,`module_order`,`module_name`,`module_image_src`,`module_image_width`,`module_image_height`,`module_group_ids`,`module_status`) VALUES ('3','birthday_list','1','4','BIRTHDAYS','portal_birthday.png','16','16','','1');
INSERT INTO `mydatabase.phpbb_portal_modules` (`module_id`,`module_classname`,`module_column`,`module_order`,`module_name`,`module_image_src`,`module_image_width`,`module_image_height`,`module_group_ids`,`module_status`) VALUES ('22','who_is_online_block','3','1','PORTAL_WHO_IS_ONLINE_BLOCK','portal_friends.png','16','16','','1');
INSERT INTO `mydatabase.phpbb_portal_modules` (`module_id`,`module_classname`,`module_column`,`module_order`,`module_name`,`module_image_src`,`module_image_width`,`module_image_height`,`module_group_ids`,`module_status`) VALUES ('5','search','1','3','PORTAL_SEARCH','portal_search.png','16','16','','1');
INSERT INTO `mydatabase.phpbb_portal_modules` (`module_id`,`module_classname`,`module_column`,`module_order`,`module_name`,`module_image_src`,`module_image_width`,`module_image_height`,`module_group_ids`,`module_status`) VALUES ('7','topposters','1','8','TOPPOSTERS','portal_top_poster.png','16','16','','1');
INSERT INTO `mydatabase.phpbb_portal_modules` (`module_id`,`module_classname`,`module_column`,`module_order`,`module_name`,`module_image_src`,`module_image_width`,`module_image_height`,`module_group_ids`,`module_status`) VALUES ('8','latest_members','3','3','LATEST_MEMBERS','portal_members.png','16','16','','1');
INSERT INTO `mydatabase.phpbb_portal_modules` (`module_id`,`module_classname`,`module_column`,`module_order`,`module_name`,`module_image_src`,`module_image_width`,`module_image_height`,`module_group_ids`,`module_status`) VALUES ('9','link_us','1','9','LINK_US','portal_link_us.png','16','16','','0');
INSERT INTO `mydatabase.phpbb_portal_modules` (`module_id`,`module_classname`,`module_column`,`module_order`,`module_name`,`module_image_src`,`module_image_width`,`module_image_height`,`module_group_ids`,`module_status`) VALUES ('10','welcome','2','1','PORTAL_WELCOME','','0','0','1,2,3,4,5,6,7','1');
INSERT INTO `mydatabase.phpbb_portal_modules` (`module_id`,`module_classname`,`module_column`,`module_order`,`module_name`,`module_image_src`,`module_image_width`,`module_image_height`,`module_group_ids`,`module_status`) VALUES ('11','recent','2','2','PORTAL_RECENT','','0','0','','0');
INSERT INTO `mydatabase.phpbb_portal_modules` (`module_id`,`module_classname`,`module_column`,`module_order`,`module_name`,`module_image_src`,`module_image_width`,`module_image_height`,`module_group_ids`,`module_status`) VALUES ('12','announcements','2','3','GLOBAL_ANNOUNCEMENTS','','16','16','','1');
INSERT INTO `mydatabase.phpbb_portal_modules` (`module_id`,`module_classname`,`module_column`,`module_order`,`module_name`,`module_image_src`,`module_image_width`,`module_image_height`,`module_group_ids`,`module_status`) VALUES ('13','news','2','4','LATEST_NEWS','','0','0','1,2,3,4,5,6,7','1');
INSERT INTO `mydatabase.phpbb_portal_modules` (`module_id`,`module_classname`,`module_column`,`module_order`,`module_name`,`module_image_src`,`module_image_width`,`module_image_height`,`module_group_ids`,`module_status`) VALUES ('14','poll','2','5','PORTAL_POLL','','0','0','1,2,3,4,5,6,7','1');
INSERT INTO `mydatabase.phpbb_portal_modules` (`module_id`,`module_classname`,`module_column`,`module_order`,`module_name`,`module_image_src`,`module_image_width`,`module_image_height`,`module_group_ids`,`module_status`) VALUES ('16','user_menu','3','2','USER_MENU','portal_user.png','16','16','','1');
INSERT INTO `mydatabase.phpbb_portal_modules` (`module_id`,`module_classname`,`module_column`,`module_order`,`module_name`,`module_image_src`,`module_image_width`,`module_image_height`,`module_group_ids`,`module_status`) VALUES ('17','statistics','1','5','STATISTICS','portal_statistics.png','16','16','','1');
INSERT INTO `mydatabase.phpbb_portal_modules` (`module_id`,`module_classname`,`module_column`,`module_order`,`module_name`,`module_image_src`,`module_image_width`,`module_image_height`,`module_group_ids`,`module_status`) VALUES ('18','calendar','3','5','PORTAL_CALENDAR','portal_calendar.png','16','16','','1');
INSERT INTO `mydatabase.phpbb_portal_modules` (`module_id`,`module_classname`,`module_column`,`module_order`,`module_name`,`module_image_src`,`module_image_width`,`module_image_height`,`module_group_ids`,`module_status`) VALUES ('19','leaders','3','4','THE_TEAM','portal_team.png','16','16','','1');
INSERT INTO `mydatabase.phpbb_portal_modules` (`module_id`,`module_classname`,`module_column`,`module_order`,`module_name`,`module_image_src`,`module_image_width`,`module_image_height`,`module_group_ids`,`module_status`) VALUES ('20','latest_bots','1','6','LATEST_BOTS','portal_bots.png','16','16','','1');
INSERT INTO `mydatabase.phpbb_portal_modules` (`module_id`,`module_classname`,`module_column`,`module_order`,`module_name`,`module_image_src`,`module_image_width`,`module_image_height`,`module_group_ids`,`module_status`) VALUES ('21','links','3','6','PORTAL_LINKS','portal_links.png','16','16','','0');
INSERT INTO `mydatabase.phpbb_portal_modules` (`module_id`,`module_classname`,`module_column`,`module_order`,`module_name`,`module_image_src`,`module_image_width`,`module_image_height`,`module_group_ids`,`module_status`) VALUES ('23','who_was_here','2','6','PORTAL_WHO_WAS_HERE','','16','16','','1');
INSERT INTO `mydatabase.phpbb_portal_modules` (`module_id`,`module_classname`,`module_column`,`module_order`,`module_name`,`module_image_src`,`module_image_width`,`module_image_height`,`module_group_ids`,`module_status`) VALUES ('24','custom','1','10','Flag Counter','portal_counter.png','16','16','','1');
/*!40000 ALTER TABLE `phpbb_portal_modules` ENABLE KEYS */;

[tiller]

That worked! Thanks for your help.