Page 1 of 1
Unable to create or edit catagories
Posted: 05 Apr 2009, 17:00
by 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?
Re: Unable to create or edit catagories
Posted: 08 Apr 2009, 23:25
by 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!
Re: Unable to create or edit catagories
Posted: 13 Apr 2009, 21:01
by 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
Re: Unable to create or edit catagories
Posted: 15 Apr 2009, 18:20
by 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
Re: Unable to create or edit catagories
Posted: 16 Apr 2009, 14:03
by 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.
Re: Unable to create or edit catagories
Posted: 18 Apr 2009, 22:52
by Jan
Great.