Chapter 11. Migrating from BF Auction Pro to BF Auction Plus

How to migrate from BF Auction Pro (Joomla 1.5) to BF Auction Plus (Joomla 3)

Install BF Auction Plus on the new website, then run the following SQL commands in phpMyAdmin. I'm assuming you have copied the BF Auction Pro tables from your Joomla 1.5 site to your new Joomla 3 site, as well as the entries from the jos_categories table. It is best to do this on a staging/development copy of your site, not on the live website. Note, replace jos_ with your table prefix.

DROP TABLE jos_bfauction_plus;

RENAME TABLE `jos_bfauction_pro` TO `jos_bfauction_plus`;

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

ALTER TABLE `jos_bfauction_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 `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', ADD `image6` varchar(255) NOT NULL, ADD `image7` varchar(255) NOT NULL, ADD `image8` varchar(255) NOT NULL, ADD `image9` varchar(255) NOT NULL, ADD `image10` varchar(255) NOT NULL, ADD `image11` varchar(255) NOT NULL, ADD `image12` varchar(255) NOT NULL, ADD `image13` varchar(255) NOT NULL, ADD `image14` varchar(255) NOT NULL, ADD `image15` varchar(255) NOT NULL, ADD `image16` varchar(255) NOT NULL, ADD `image17` varchar(255) NOT NULL, ADD `image18` varchar(255) NOT NULL, ADD `image19` varchar(255) NOT NULL, ADD `image20` varchar(255) NOT NULL, ADD `imageShared` int(11) NOT NULL default '0', ADD `saleType` tinyint(1) NOT NULL default '0', ADD `address1` varchar(255) NOT NULL default '', ADD `address2` varchar(255) NOT NULL default '', ADD `city` varchar(255) NOT NULL default '', ADD `region` varchar(255) NOT NULL default '', ADD `postcode` varchar(255) NOT NULL default '', ADD `country` varchar(255) NOT NULL default '', ADD `phone` varchar(255) NOT NULL default '', ADD `relistid` int(11) NOT NULL default '0', ADD `quantity` int(11) NOT NULL default '1', ADD `quantityPurchased` int(11) NOT NULL default '0', ADD `deliveryOption` varchar(255) NOT NULL, ADD `supplier` varchar(255) NOT NULL, ADD `costPrice` FLOAT( 10, 2 ) NOT NULL DEFAULT '0', ADD `featured` tinyint(3) unsigned NOT NULL DEFAULT '0', ADD `alias` varchar(255) NOT NULL DEFAULT '', ADD `metakey` text NOT NULL, ADD `metadesc` text NOT NULL, ADD `metadata` text NOT NULL, ADD `params` text NOT NULL, ADD `url` varchar(250) NOT NULL DEFAULT '', ADD `created_by_alias` varchar(255) NOT NULL DEFAULT '';

DROP TABLE jos_bfauction_plus_bid;

RENAME TABLE `jos_bfbid_pro` TO `jos_bfauction_plus_bid`;

ALTER TABLE `jos_bfauction_plus_bid` ADD `quantity` int(11) NOT NULL default '1', ADD `deliveryOption` varchar(255) NOT NULL;

DROP TABLE jos_bfauction_plus_email;

RENAME TABLE `jos_bfauction_email` TO `jos_bfauction_plus_email`;

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

ALTER TABLE `jos_bfauction_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';

DROP TABLE jos_bfauctionplus_watchlist;

RENAME TABLE `jos_bfauctionpro_watchlist` TO `jos_bfauctionplus_watchlist`;

ALTER TABLE `jos_bfauctionplus_watchlist` ADD `emailSent` tinyint(1) NOT NULL default '0', ADD `emailDate` datetime NOT NULL default '0000-00-00 00:00:00';

UPDATE jos_categories set `extension` = 'com_bfauction_plus' where `extension` = 'com_bfauction_pro';

Go to top