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.
Error upgrading to 2.0.0b1
Forum rules
Before creating a new support thread, please take a look in the board3 Portal FAQ and use the search!
Many questions have already been answered.
Before creating a new support thread, please take a look in the board3 Portal FAQ and use the search!
Many questions have already been answered.
-
Topic author - Active Member
- Posts: 2
- Joined: 13. March 2009 07:45
- phpBB.de User: Tiller
- phpBB.com User: Tiller
-
- Portal Enthusiast
- Posts: 149
- Joined: 8. September 2011 01:16
Re: Error upgrading to 2.0.0b1
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:
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 */;
-
Topic author - Active Member
- Posts: 2
- Joined: 13. March 2009 07:45
- phpBB.de User: Tiller
- phpBB.com User: Tiller
Re: Error upgrading to 2.0.0b1
That worked! Thanks for your help.