Support for Phoca Extensions
https://www.phoca.cz/forum/
and indeed 'metakey' does not appear in the install.bak file that I copied and pasted as SQL queries.500 - An error has occurred.
JDatabaseMySQL::query: 1054 - Unknown column 'metakey' in 'field list' SQL=INSERT INTO `jos_phocagallery_categories` ( `id`,`parent_id`,`owner_id`,`title`,`alias`,`image`,`image_position`,`description`,`date`,`published`,`approved`,`checked_out`,`checked_out_time`,`ordering`,`access`,`hits`,`accessuserid`,`uploaduserid`,`deleteuserid`,`userfolder`,`latitude`,`longitude`,`zoom`,`geotitle`,`metakey`,`metadesc`,`extid`,`exta`,`extu` ) VALUES ( '0','0','0','Photos, 2nd Grade, B-8','photos-2nd-grade-b-8','','left','','2010-01-22 16:19:49','1','1','0','0','1','1','0','-1','-2','-2','','','','','','','','','','' )
Call stack
# Function Location
1 JAdministrator->dispatch() /home/turquoi1/public_html/administrator/index.php:67
2 JComponentHelper->renderComponent() /home/turquoi1/public_html/administrator/includes/application.php:130
3 require_once() /home/turquoi1/public_html/libraries/joomla/application/component/helper.php:162
4 JController->execute() /home/turquoi1/public_html/administrator/components/com_phocagallery/admin.phocagallery.php:40
5 PhocaGalleryCpControllerPhocaGalleryc->save() /home/turquoi1/public_html/libraries/joomla/application/component/controller.php:236
6 PhocaGalleryCpModelPhocaGalleryC->store() /home/turquoi1/public_html/administrator/components/com_phocagallery/controllers/phocagalleryc.php:217
7 JTable->store() /home/turquoi1/public_html/administrator/components/com_phocagallery/models/phocagalleryc.php:108
8 JDatabaseMySQL->insertObject() /home/turquoi1/public_html/libraries/joomla/database/table.php:289
9 JDatabaseMySQL->query() /home/turquoi1/public_html/libraries/joomla/database/database/mysql.php:539
10 JError->raiseError() /home/turquoi1/public_html/libraries/joomla/database/database/mysql.php:229
11 JError->raise() /home/turquoi1/public_html/libraries/joomla/error/error.php:171
12 JException->__construct() /home/turquoi1/public_html/libraries/joomla/error/error.php:136
DROP TABLE IF EXISTS `#__phocagallery_categories`;
CREATE TABLE `#__phocagallery_categories` (
`id` int(11) NOT NULL auto_increment,
`parent_id` int(11) NOT NULL default 0,
`owner_id` int(11) NOT NULL default 0,
`title` varchar(255) NOT NULL default '',
`name` varchar(255) NOT NULL default '',
`alias` varchar(255) NOT NULL default '',
`image` varchar(255) NOT NULL default '',
`section` varchar(50) NOT NULL default '',
`image_position` varchar(30) NOT NULL default '',
`description` text,
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`published` tinyint(1) NOT NULL default '0',
`approved` 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',
`editor` varchar(50) default NULL,
`ordering` int(11) NOT NULL default '0',
`access` tinyint(3) unsigned NOT NULL default '0',
`hits` int(11) NOT NULL default '0',
`count` int(11) NOT NULL default '0',
`accessuserid` text,
`uploaduserid` text,
`deleteuserid` text,
`userfolder` text,
`latitude` varchar(20) NOT NULL default '',
`longitude` varchar(20) NOT NULL default '',
`zoom` int(3) NOT NULL default '0',
`geotitle` varchar(255) NOT NULL default '',
`params` text,
`extid` varchar(255) NOT NULL default '',
`exta` varchar(255) NOT NULL default '',
`extu` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `cat_idx` (`section`,`published`,`access`),
KEY `idx_access` (`access`),
KEY `idx_checkout` (`checked_out`)
) TYPE=MyISAM CHARACTER SET `utf8`;
)