Contido
Migrating form Joomla 2.5 to Joomla 3.8.
Joomla 4 is approaching, but by now we have to work with Joomla 3.
Anyway, some folk that still have their sites made with Joomla 2.5 and are demanding to migrate them to Joomla 3.8. It’s common that many are using PhocaDownload, an excellent download manager very recommended and available since Joomla 1.5. Obviously, in these cases, I had to migrate the PhocaDownload extension from versions 2.1.x (compatible with Joomla 2.5) to versions 3.1.x (compatible with Joomla 3).
There are some instructions to migrate from Joomla 2.5 to Joomla 3 but the process is way more easier than this and goes without surprises.
The problem. ‘1146 Table ‘#__phocadownload_styles’ doesn’t exist’
Anyway, after the migration, when we try to access any PhocaDownload frontend menu item we get a error message:
1146 Table '#__phocadownload_styles' doesn't exist
And this is it, the table doesn’t exists in the database, but the fix is easy.
You must execute this SQL code (you can use phpMyAdmin, for instance), replacing ‘#__’ by your database prefix:
CREATE TABLE IF NOT EXISTS `#__phocadownload_styles` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) NOT NULL DEFAULT '',
`alias` varchar(255) NOT NULL DEFAULT '',
`filename` varchar(255) NOT NULL DEFAULT '',
`menulink` text,
`type` tinyint(1) NOT NULL DEFAULT '0',
`published` tinyint(1) NOT NULL DEFAULT '0',
`checked_out` int(11) unsigned NOT NULL DEFAULT '0',
`checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`ordering` int(11) NOT NULL DEFAULT '0',
`params` text,
`language` char(7) NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8 ;
INSERT INTO `#__phocadownload_styles` (`id`, `title`, `alias`, `filename`, `menulink`, `type`, `published`, `checked_out`, `checked_out_time`, `ordering`, `params`, `language`) VALUES
(1, 'Phocadownload', 'phocadownload', 'phocadownload.css', NULL, 1, 1, 0, '0000-00-00 00:00:00', 1, NULL, '*'),
(2, 'Rating', 'rating', 'rating.css', NULL, 1, 1, 0, '0000-00-00 00:00:00', 2, NULL, '*'),
(3, 'Button', 'button', 'button.css', NULL, 1, 0, 0, '0000-00-00 00:00:00', 3, NULL, '*'),
(4, 'Button (Rounded Corners)', '', 'buttonrc.css', NULL, 1, 0, 0, '0000-00-00 00:00:00', 4, NULL, '*'),
(5, 'Default', 'default', 'default.css', NULL, 2, 1, 0, '0000-00-00 00:00:00', 1, NULL, '*'),
(6, 'Bootstrap', '', 'bootstrap.min.css', NULL, 1, 0, 0, '0000-00-00 00:00:00', 5, NULL, '*');And problem solved!.
comments powered by Disqus