Unable to create or edit catagories

[electra]

Thanks for reading. I have had the gallery up and running for several months now with no problems. When I set it up I was able to create and edit categories with no problems. I went to add a new category and I get the error "Error Saving Phoca Gallery Categories" in the back end. I then tried to edit an existing category and got the same error. I checked both file and folder permissions, (644 and 755). I searched these forums, but the answers I found do not work. Running Joomla 1.5.10 and Gallery 2.2.3. Anyone have any ideas?

[electra]

I finally found the problem and manually fixed it. Thanks torquelada, you pointed me in the right direction. Consider this one closed. And many thanks to all of you that replied!

[Ruald]

electra / torquelada, can you say how you fixed this problem?

I've the same problem with Phoca Gallery 2.2.3. and cant find the problem. I found the same error in Joomla Debug mode. That column 'Date' is missing in the database, but when I look at the database SQL script it looks that that column must NOT excist.

What is wrong, the code or the database definition?

Hopefully anyone will help me. At the moment I make all new categories with PhpMyAdmin

[Jan]

Hi, the phocagallery categories table should include the date column:

Code: Select all

CREATE TABLE `#__phocagallery_categories` (
  `id` int(11) NOT NULL auto_increment,
  `parent_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 NOT NULL,
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `published` 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',
  `params` text NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `cat_idx` (`section`,`published`,`access`),
  KEY `idx_access` (`access`),
  KEY `idx_checkout` (`checked_out`)
) TYPE=MyISAM CHARACTER SET `utf8`;

If it doesn't include it, you need to add it manually to your table, see:

https://www.phoca.cz/documents/2-phoca-g ... em-solving

Jan

[Ruald]

Thanks Jan, I tought I comparedthe right install.bak with the current table definition.

I added the Date column and it all works again.

[Jan]

Great.