Phoca Forum

Posted: **29 Jul 2014, 23:51**

Hi everyone,

Today I upgraded my Joomla 2.5 last version to the recommended version of joomla 3.3 ... Not everything went right and I have solved severals issues (template most of them) but I still have a problem with Phoca Download ... When I try to show all the categories of files through a menu item, my visitor get this message :

1146 - Table '*******.jos_phocadownload_styles' doesn't exist SQL=SELECT a.filename as filename, a.type as type, a.menulink as menulink FROM jos_phocadownload_styles AS a WHERE a.published = 1 ORDER BY a.type, a.ordering ASC

I have read diferents topics about this issue but I have no solution. Basicly, the jos_phocadownload_styles table is missing in the database (I checked it out via Phpmyadmin) ... I can create it but ... I do not know the name of the columns ... how much columns ... Actually I supppose this table is supposed to get some kind of information ... Where/how could I find these information is another question...

Thank you a lot !

Posted: **30 Jul 2014, 00:13**

Hi,

Me again ... Using the file inside of the update_package : com_phocadownload_v3.0.5.zip\install\sql\mysql\install.utf8.sql, I have found the SQL command to create and fill the table :

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

And all the categories appeared BUT ... when I try to download a file ...

1054 - Unknown column 'c.tokenhits' in 'field list' SQL=SELECT c.catid, c.filename, c.directlink, c.link_external, c.access, c.confirm_license, c.metakey, c.metadesc, cc.access as cataccess, cc.accessuserid as cataccessuserid, c.tokenhits FROM jos_phocadownload AS c, jos_phocadownload_categories AS cc WHERE c.id = 230 AND c.published = 1 AND c.approved = 1 AND c.catid = cc.id AND cc.access IN (1,1,28) AND ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2014-07-29 22:03:23' ) AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2014-07-29 22:03:23' ) ORDER BY c.ordering LIMIT 0, 1

I go to bed ... let see if tomorrow i can solve it !
Thanks for reading

Posted: **30 Jul 2014, 00:19**

It is done folks !

Thanks a lot to Benno : viewtopic.php?f=31&t=24434#p91628

It works perfectly now ! Great !
Good night

Phoca Forum

[SOLVED] jos_phocadownload_styles is missing

[SOLVED] jos_phocadownload_styles is missing

Re: jos_phocadownload_styles is missing

Re: jos_phocadownload_styles is missing