Fatal error - after upgrade

Phoca Download - download manager
MDM
Phoca Newbie
Phoca Newbie
Posts: 3
Joined: 03 Jul 2015, 12:07

Fatal error - after upgrade

Post 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
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 48566
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Fatal error - after upgrade

Post by Jan »

Hi, which version of Phoca Download you have installed, seems like some obsolete?

Jan
If you find Phoca extensions useful, please support the project
MDM
Phoca Newbie
Phoca Newbie
Posts: 3
Joined: 03 Jul 2015, 12:07

Re: Fatal error - after upgrade

Post 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
User avatar
Benno
Phoca Hero
Phoca Hero
Posts: 9611
Joined: 04 Dec 2008, 11:58
Location: Germany
Contact:

Re: Fatal error - after upgrade

Post by Benno »

MDM
Phoca Newbie
Phoca Newbie
Posts: 3
Joined: 03 Jul 2015, 12:07

Re: Fatal error - after upgrade

Post 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
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 48566
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Fatal error - after upgrade

Post 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
If you find Phoca extensions useful, please support the project
Post Reply