Can not create category

[lofotengirl]

Hi!
I love this gallery. It still works fine at my previous site.

Now I am trying to install it to the new site. I use Joomla 1.5.26. This is really first time I faced the problem - I can not creat category
Error Saving Phoca Gallery Categories - that is what system says.

If I use Multiply Add as usually did (when category is being created automatically) - it doesn't work either. Shows mistake.
What can it be?

I will be very glad to get response. As this is the best extention I have ever used with pictures, maps and comments, and I really want to continue using it and to send some money for developer.

Thank in advance!

Olga.

[Benno]

Hi,
try to check Phoca Gallery tables.
See: Database https://www.phoca.cz/documents/2-phoca-g ... em-solving

Kind regards,
Benno

[lofotengirl]

Thanks, Benno! The tables do not exist, that is true. I want to copy them from mentioned file install.bak, I see these tables, but ....where in phpmyadmin should I copy (insert) them (I take 1 table for example) and how to update:
DROP TABLE IF EXISTS `#__phocagallery`;
CREATE TABLE `#__phocagallery` (
`id` int(11) unsigned NOT NULL auto_increment,
`catid` int(11) NOT NULL default '0',
`sid` int(11) NOT NULL default '0',
`title` varchar(250) NOT NULL default '',
`alias` varchar(255) NOT NULL default '',
`filename` varchar(250) NOT NULL default '',
`description` text,
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`hits` int(11) NOT NULL default '0',
`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 '',
`userid` int(11) NOT NULL Default '0',
`videocode` text,
`vmproductid` int(11) NOT NULL default '0',
`imgorigsize` int(11) 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 NOT NULL default '0000-00-00 00:00:00',
`ordering` int(11) NOT NULL default '0',
`params` text,
`metakey` text,
`metadesc` text,
`extlink1` text,
`extlink2` text,
`extid` varchar(255) NOT NULL default '',
`extl` varchar(255) NOT NULL default '',
`extm` varchar(255) NOT NULL default '',
`exts` varchar(255) NOT NULL default '',
`exto` varchar(255) NOT NULL default '',
`extw` varchar(255) NOT NULL default '',
`exth` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `catid` (`catid`,`published`)
) ENGINE=MyISAM CHARACTER SET `utf8`;

And other question is WHY it can happen? I installed Phoca maps before - can it be because of this?

Thank you in advance! Help poor girl, please

[Benno]

Hi,

but ....where in phpmyadmin should I copy (insert) them (I take 1 table for example) and how to update

see:

And other question is WHY it can happen?

I think there are more as one reason. Try to search this forum...

I installed Phoca maps before - can it be because of this?

No, I don't think so.

Kind regards,
Benno