update 3.2 to 4.2 (joomla upgrade)

[micker]

hello after upgrade to j3 i update phoca dans to 4.2
all seems work but link to categorie display this error
'comite.jos_phocagallery_styles' n'existe pas SQL=SELECT a.filename as filename, a.type as type, a.menulink as menulink FROM jos_phocagallery_styles AS a WHERE a.published = 1 ORDER BY a.type, a.ordering ASC
..
do you have an idea ?

[Benno]

Hi,
yes, the table jos_phocagallery_styles is missing in your data base. You can create it easily with help of phpMyAdmin.
See: https://www.phoca.cz/documents/16-joomla ... ase-column

Kind regards,
Benno

[micker]

cool the solution is
execute in phpmyadmin
just adapte #_ to your prefix bdd

Code: Select all

CREATE TABLE IF NOT EXISTS `#__phocagallery_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 `#__phocagallery_styles` (`id`, `title`, `alias`, `filename`, `menulink`, `type`, `published`, `checked_out`, `checked_out_time`, `ordering`, `params`, `language`) VALUES
(1, 'Phocagallery', 'phocagallery', 'phocagallery.css', '', 1, 1, 0, '0000-00-00 00:00:00', 1, NULL, '*'),
(2, 'Rating', '', 'rating.css', NULL, 1, 1, 0, '0000-00-00 00:00:00', 2, NULL, '*'),
(3, 'Default', '', 'default.css', NULL, 2, 1, 0, '0000-00-00 00:00:00', 3, NULL, '*'),
(4, 'Bootstrap', '', 'bootstrap.min.css', NULL, 1, 0, 0, '0000-00-00 00:00:00', 4, NULL, '*');

it strange that missing on update

[Benno]

Well done!

Kind regards,
Benno