Joomla 6.0.0-beta1 \ PhocaGallery 5.1.3 / Installation fails

[jobrusche]

Environment Joomla 6.0.0-beta1 fresh installed _ PHP 8.3.19

The installation of PhocaGallery 5.1.3 fails with the message:

Warning
JInstaller: :Install: Error SQL Table 'a159320_t5mn1.sdaz_phocagallery_categories' doesn't exist

The same is true for PhocaDownload 5.1.3

Warning
JInstaller: :Install: Error SQL Table 'a159320_t5mn1.sdaz_phocadownload' doesn't exist

The site is available for login if required.

[jobrusche]

On my local Wampserver with PHP 8.3.20 and Joomla 6.0-beta1 both components installed correctly

[christine]

Hi,

You could try with 6.0.0-beta2-dev
https://developer.joomla.org/nightly-builds.html

Kind regards
Christine

[Benno]

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!

[jobrusche]

After adding the table phocagallery_categories via phpadmin
The installation throws another message :

Warning
JInstaller: :Install: Error SQL Duplicate column name 'image_id'

[jobrusche]

It seems this is not related to PhocaGallery or PhocaDownload because installing Akeeba also complains about a missing
table entry.

Something might be wrong with the database or database access.
Please do not spent time on this issue any longer.

Sorry for the wild goose chase.
Johan.

[christine]

Hi Johan,

It seems this is not related to PhocaGallery or PhocaDownload because installing Akeeba also complains about a missing
table entry.

As I said, you can try newer nightly builds - later.

Regarding Akeeba, here's some info:
https://www.akeeba.com/support/akeeba-b ... rrors.html

Kind regards
Christine

[jobrusche]

Now my testsite has Joomla6.0.0-beta2-dev with a clean database
and PhocaGallery 5.1.3 installs correctly now.

Thanks and regards
Johan.