Hi,
Try to create the missing database table manually, e.g. with help of phpMyAdmin.
Run this query for Phoca Gallery:
Code: Select all
CREATE TABLE IF NOT EXISTS `#__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',
`image_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,
`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,
`editor` varchar(50) DEFAULT NULL,
`ordering` int(11) NOT NULL DEFAULT '0',
`access` tinyint(3) unsigned NOT NULL DEFAULT '0',
`count` int(11) NOT NULL DEFAULT '0',
`hits` 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 '',
`extid` varchar(255) NOT NULL DEFAULT '',
`exta` varchar(255) NOT NULL DEFAULT '',
`extu` varchar(255) NOT NULL DEFAULT '',
`extauth` varchar(255) NOT NULL DEFAULT '',
`imgurclient` varchar(255) NOT NULL DEFAULT '',
`imguralbum` varchar(255) NOT NULL DEFAULT '',
`extfbuid` int(11) NOT NULL DEFAULT '0',
`extfbcatid` varchar(255) NOT NULL DEFAULT '',
`params` text,
`metakey` text,
`metadesc` text,
`metadata` text,
`language` char(7) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `cat_idx` (`section`,`published`,`access`),
KEY `idx_access` (`access`),
KEY `idx_checkout` (`checked_out`)
) DEFAULT CHARSET=utf8 ;
and this query for Phoca Download:
Code: Select all
CREATE TABLE IF NOT EXISTS `#__phocadownload` (
`id` int(11) unsigned NOT NULL auto_increment,
`catid` int(11) NOT NULL default '0',
`sectionid` int(11) NOT NULL default '0',
`sid` int(11) NOT NULL default '0',
`owner_id` int(11) NOT NULL default 0,
`title` varchar(250) NOT NULL default '',
`alias` varchar(255) NOT NULL default '',
`project_name` varchar(255) NOT NULL default '',
`filename` varchar(250) NOT NULL default '',
`filename_play` varchar(250) NOT NULL default '',
`filename_preview` varchar(250) NOT NULL default '',
`filesize` int(11) NOT NULL default 0,
`author` varchar(255) NOT NULL default '',
`author_email` varchar(255) NOT NULL default '',
`author_url` varchar(255) NOT NULL default '',
`license` varchar(255) NOT NULL default '',
`license_url` varchar(255) NOT NULL default '',
`image_filename` varchar(255) NOT NULL default '',
`image_filename_spec1` varchar(255) NOT NULL default '',
`image_filename_spec2` varchar(255) NOT NULL default '',
`image_download` varchar(255) NOT NULL default '',
`video_filename` varchar(255) NOT NULL default '',
`link_external` varchar(255) NOT NULL default '',
`mirror1link` varchar(255) NOT NULL default '',
`mirror1title` varchar(255) NOT NULL default '',
`mirror1target` varchar(10) NOT NULL default '',
`mirror2link` varchar(255) NOT NULL default '',
`mirror2title` varchar(255) NOT NULL default '',
`mirror2target` varchar(10) NOT NULL default '',
`description` text,
`features` text,
`changelog` text,
`notes` text,
`userid` int(11) NOT NULL default '0',
`version` varchar(255) NOT NULL default '',
`directlink` tinyint(1) NOT NULL default '0',
`date` datetime NOT NULL,
`publish_up` datetime NOT NULL,
`publish_down` datetime NOT NULL,
`hits` int(11) NOT NULL default '0',
`textonly` tinyint(1) NOT NULL default '0',
`published` tinyint(1) NOT NULL default '0',
`approved` tinyint(1) NOT NULL default '0',
`checked_out` int(11) NOT NULL default '0',
`checked_out_time` datetime,
`ordering` int(11) NOT NULL default '0',
`access` int(11) unsigned NOT NULL default '0',
`confirm_license` int(11) NOT NULL default '0',
`unaccessible_file` int(11) NOT NULL default '0',
`token` char(64) default NULL,
`tokenhits` int(11) NOT NULL default 0,
`tags_string` varchar(255) NOT NULL default '',
`params` text,
`metakey` text,
`metadesc` text,
`metadata` text,
`language` char(7) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `catid` (`catid`,`published`)
) default CHARSET=utf8;
replace #_ with your database prefix before.
Kind regards,
Benno
Grüß Dich Christine!
