Migration problem Phocadownload

[fwd]

Hi,
I'm migrating to J 3.4 with PG and Phoca Download (4.1.2 and 3.0.6).
There are messages (from the frontend) like
1146 - Table 'd4845_xbxb.l0wd6_phocadownload_styles' doesn't exist SQL=SELECT a.filename as filename, a.type as type, a.menulink as menulink FROM l0wd6_phocadownload_styles AS a WHERE a.published = 1 ORDER BY a.type, a.ordering ASC
after sql import from backup. Table is missing.
I have solved the issue in PG according to the answer here:
viewtopic.php?f=1&t=33788

Well, I need to create a similar table phocadownload_styles, but don't know the sructure, resp. the SQL command to create it. Not able to find it in the doc.

Thanks for your help.

[Jan]

Hi, the same for Phoca Download.

If you will upgrade with help of this guide:

https://www.phoca.cz/documents/50-phoca/ ... o-joomla-3

the styles table will be set automatically.

If you will do this manually, the SQL you will find here:
administrator\components\com_phocadownload\install\sql\mysql\install.utf8.sql

Code: Select all

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, '*');

Change #__ to your prefix.
Jan

[fwd]

Solved. It works now. Thanks for your great support Jan.

[Jan]

Ok