Page 1 of 1

Fatal error - after upgrade

Posted: 25 Jul 2015, 13:56
by MDM
Please can you help.

I upgraded phocadownloads from to joomla 3.3.6 and I now have an error when I go to the component in admin.

Fatal error: require_once(): Failed opening required '/serverlocation/htdocs/folderlocation/administrator/components/com_phocadownloadDScontroller.php' (include_path='.:/usr/lib/php5.5') in /serverlocation/htdocs/folderlocation/administrator/components/com_phocadownload/phocadownload.php on line 16

Please can someone help?

Cheers MDM

Re: Fatal error - after upgrade

Posted: 26 Jul 2015, 19:46
by Jan
Hi, which version of Phoca Download you have installed, seems like some obsolete?

Jan

Re: Fatal error - after upgrade

Posted: 27 Jul 2015, 10:43
by MDM
Hi Jan

I have upgraded from Joomla 2.5.6 to Joomla 3.3.6, I have phocadownloads 2.1.6 installed.

Do I need to uninstall Phocadownloads and reinstall a new version and if so how do I ensure I do not loose any of the uploads already updated as there are about 100.

Kind regards
MDM

Re: Fatal error - after upgrade

Posted: 27 Jul 2015, 11:06
by Benno

Re: Fatal error - after upgrade

Posted: 27 Jul 2015, 19:00
by MDM
Thank you, I have followed the upgrade instructions unfortunately some of my links are now working.

The below should be a list of phocadownloads from category newsletters

http://oxcivicsoc.mayodigitalmedia.co.u ... ewsletters

The below direct link works fine

http://oxcivicsoc.mayodigitalmedia.co.u ... g_form.pdf

Thank you in advance.

MDM

Re: Fatal error - after upgrade

Posted: 03 Aug 2015, 00:52
by Jan
Hi, you get the following database error there:
Table 'db574863231.viwc1_phocadownload_styles' doesn't exist SQL=SELECT a.filename as filename, a.type as type, a.menulink as menulink FROM viwc1_phocadownload_styles AS a WHERE a.published = 1 ORDER BY a.type, a.ordering ASC

This means, that the phocadownload_styles table is not included in your database. So it needs to be done manually. Normally, where the migration is done by the guide, the table is installed in the step of installation of Phoca Download 3 in new site. But if something went wrong there, it needs to be added manually to the database.

Try to see similar posts.

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, '*');
This code needs to be added to the database (change the #__ to your prefix)

Jan

Jan