How to migrate from BF Quiz (Joomla 1.5) to BF Quiz Plus (2.5 or 3)

Assuming you have copied your BF Quiz database tables across to your Joomla 2.5 site, then install BF Quiz Plus. After that you just need to run a few SQL commands in phpMyAdmin to migrate your data. Replace jos_ with your database prefix.

RENAME TABLE `jos_bfquiz_plus` TO `jos_bfquiz_plus_old`;

RENAME TABLE `jos_bfquiz` TO `jos_bfquiz_plus`;

ALTER TABLE `jos_bfquiz_plus` CHANGE `published` `state` tinyint(3) NOT NULL default '0';

ALTER TABLE `jos_bfquiz_plus` ADD `archived` tinyint(1) NOT NULL DEFAULT '0', ADD `approved` tinyint(1) NOT NULL DEFAULT '1', ADD `access` int(11) NOT NULL DEFAULT '1', ADD `language` char(7) NOT NULL DEFAULT '', ADD `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', ADD `created_by` int(10) unsigned NOT NULL DEFAULT '0', ADD `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', ADD `modified_by` int(10) unsigned NOT NULL DEFAULT '0', ADD `publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', ADD `publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00';

RENAME TABLE `jos_bfquiz_plus_matrix` TO `jos_bfquiz_plus_matrix_old`;

RENAME TABLE `jos_bfquiz_matrix` TO `jos_bfquiz_plus_matrix`;

ALTER TABLE `jos_bfquiz_plus_matrix` CHANGE `published` `state` tinyint(3) NOT NULL default '0';

ALTER TABLE `jos_bfquiz_plus_matrix` ADD `date` datetime NOT NULL default '0000-00-00 00:00:00', ADD `checked_out` int(11) NOT NULL default '0', ADD `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', ADD `archived` tinyint(1) NOT NULL DEFAULT '0', ADD `approved` tinyint(1) NOT NULL DEFAULT '1', ADD `access` int(11) NOT NULL DEFAULT '1', ADD `language` char(7) NOT NULL DEFAULT '', ADD `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', ADD `created_by` int(10) unsigned NOT NULL DEFAULT '0', ADD `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', ADD `modified_by` int(10) unsigned NOT NULL DEFAULT '0', ADD `parent` int(11) NOT NULL, ADD `publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', ADD `publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00';

RENAME TABLE `jos_bfquiz_plus_scorerange` TO `jos_bfquiz_plus_scorerange_old`;

RENAME TABLE `jos_bfquiz_scorerange` TO `jos_bfquiz_plus_scorerange`;

ALTER TABLE `jos_bfquiz_plus_scorerange` CHANGE `published` `state` tinyint(3) NOT NULL default '0';

ALTER TABLE `jos_bfquiz_plus_scorerange` ADD `date` datetime NOT NULL default '0000-00-00 00:00:00', ADD `checked_out` int(11) NOT NULL default '0', ADD `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', ADD `archived` tinyint(1) NOT NULL DEFAULT '0', ADD `approved` tinyint(1) NOT NULL DEFAULT '1', ADD `access` int(11) NOT NULL DEFAULT '1', ADD `language` char(7) NOT NULL DEFAULT '', ADD `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', ADD `created_by` int(10) unsigned NOT NULL DEFAULT '0', ADD `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', ADD `modified_by` int(10) unsigned NOT NULL DEFAULT '0', ADD `parent` int(11) NOT NULL, ADD `publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', ADD `publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00';

RENAME TABLE `jos_bfquiz_plus_pool` TO `jos_bfquiz_plus_pool_old`;

RENAME TABLE `jos_bfquiz_pool` TO `jos_bfquiz_plus_pool`;

ALTER TABLE `jos_bfquiz_plus_pool` CHANGE `published` `state` tinyint(3) NOT NULL default '0';

ALTER TABLE `jos_bfquiz_plus_pool` ADD `date` datetime NOT NULL default '0000-00-00 00:00:00', ADD `checked_out` int(11) NOT NULL default '0', ADD `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', ADD `archived` tinyint(1) NOT NULL DEFAULT '0', ADD `approved` tinyint(1) NOT NULL DEFAULT '1', ADD `access` int(11) NOT NULL DEFAULT '1', ADD `language` char(7) NOT NULL DEFAULT '', ADD `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', ADD `created_by` int(10) unsigned NOT NULL DEFAULT '0', ADD `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', ADD `modified_by` int(10) unsigned NOT NULL DEFAULT '0', ADD `parent` int(11) NOT NULL, ADD `publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', ADD `publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00';

RENAME TABLE `jos_bfquiz_plus_email` TO `jos_bfquiz_plus_email_old`;

RENAME TABLE `jos_bfquiz_email` TO `jos_bfquiz_plus_email`;

ALTER TABLE `jos_bfquiz_plus_email` CHANGE `published` `state` tinyint(3) NOT NULL default '0';

ALTER TABLE `jos_bfquiz_plus_email` ADD `archived` tinyint(1) NOT NULL DEFAULT '0', ADD `approved` tinyint(1) NOT NULL DEFAULT '1', ADD `access` int(11) NOT NULL DEFAULT '1', ADD `language` char(7) NOT NULL DEFAULT '', ADD `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', ADD `created_by` int(10) unsigned NOT NULL DEFAULT '0', ADD `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', ADD `modified_by` int(10) unsigned NOT NULL DEFAULT '0', ADD `parent` int(11) NOT NULL, ADD `publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', ADD `publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00';

UPDATE jos_categories set `extension` = 'com_bfquiz_plus' where `extension` = 'com_bfquiz';

Go to top