Error during upgrade on Joomla 3

[radik10]

Hi,

on Joomla 3, was phoca gallery component v. 4.2.x but after upgrade to PG 4.4.3 I have error - see below. On front page is not working gallery (The requested page was not found.) and error "1054 Unknown column 'c.image_id' in 'field list'"

Thanks for fix of component.
Radovan

Warning
JInstaller: :Install: Error SQL Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
Extension Update: SQL error processing query: DB function failed with error number 1118
Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
SQL =
ALTER TABLE `#__phocagallery_categories` ADD COLUMN `image_id` int(11) NOT NULL default 0;

[Jan]

Hi, check your database settings before making the SQL:

ALTER TABLE `#__phocagallery_categories` ADD COLUMN `image_id` int(11) NOT NULL default 0;

This SQL should be not affected by the warning you get as this is integer column.

Jan

[radik10]

Hi,

1 - I have tried to uninstall the component, but it ended with error - see below. After second attempt, folders were deleted on server
2 - It is not possible to install phoca gallery v4.4.3 - see below


After uninstall:

There was message about missing XML file - after second attempt:

JFolder: :delete: Path is not a folder. Path: [ROOT]/administrator/components/com_phocagallery
JFolder: :delete: Path is not a folder. Path: [ROOT]/components/com_phocagallery
Component Uninstall: Can't uninstall. Please remove manually.

After install new:
Error
Error installing component

Warning
JInstaller: :Install: Error SQL Duplicate entry '1' for key 'PRIMARY'
Extension Install: SQL error processing query: DB function failed with error number 1062
Duplicate entry '1' for key 'PRIMARY'
SQL =
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, '*');

[Jan]

Hi, sometimes, in Joomla, this needs to be done:
https://www.phoca.cz/documentation/86-j ... m-manually

Jan