Error Saving Phoca Gallery Categories

[djmainframe]

Hey guys, I am gettinig error when i want to create a category. please let me know why this is happening.

error: Error Saving Phoca Gallery Categories

Joomla 1.5.3
Phoca Gallery 1.8.2

[djmainframe]

tables are created in mysql database

[Jan]

see your database, if there are the phoca gallery tables (maybe there were not created while installing)
https://www.phoca.cz/phocagallery/user-m ... stallation

[Jan]

Ok, good luck

[Patrick73]

Same problem here. I have done all the steps mentioned above, but no luck. The MySQL tables have been created correctly, but I still get the same error message. I am using Phoca Gallery 2.6.2 with Joomla 1.5.8. I don't have an older version of the component, so I can't even try the solution hinted in the previous post.

Any idea? Thanks!

[Jan]

Hi, try to enable debug mode, so you should get the wrong SQL query which should add more information.

Jan

[Patrick73]

Hi Jan,

Thanks for the quick reply. So I enabled the Debug mode in Joomla! and got the following error message:

500 - An error has occurred.

JDatabaseMySQL::query: 1054 - Unknown column 'metakey' in 'field list' SQL=INSERT INTO `jos_phocagallery_categories` ( `id`,`parent_id`,`owner_id`,`title`,`alias`,`image`,`image_position`,`description`,`date`,`published`,`approved`,`checked_out`,`checked_out_time`,`ordering`,`access`,`hits`,`accessuserid`,`uploaduserid`,`deleteuserid`,`userfolder`,`latitude`,`longitude`,`zoom`,`geotitle`,`metakey`,`metadesc`,`extid`,`exta`,`extu` ) VALUES ( '0','0','0','Photos, 2nd Grade, B-8','photos-2nd-grade-b-8','','left','','2010-01-22 16:19:49','1','1','0','0','1','1','0','-1','-2','-2','','','','','','','','','','' )

Call stack
# Function Location
1 JAdministrator->dispatch() /home/turquoi1/public_html/administrator/index.php:67
2 JComponentHelper->renderComponent() /home/turquoi1/public_html/administrator/includes/application.php:130
3 require_once() /home/turquoi1/public_html/libraries/joomla/application/component/helper.php:162
4 JController->execute() /home/turquoi1/public_html/administrator/components/com_phocagallery/admin.phocagallery.php:40
5 PhocaGalleryCpControllerPhocaGalleryc->save() /home/turquoi1/public_html/libraries/joomla/application/component/controller.php:236
6 PhocaGalleryCpModelPhocaGalleryC->store() /home/turquoi1/public_html/administrator/components/com_phocagallery/controllers/phocagalleryc.php:217
7 JTable->store() /home/turquoi1/public_html/administrator/components/com_phocagallery/models/phocagalleryc.php:108
8 JDatabaseMySQL->insertObject() /home/turquoi1/public_html/libraries/joomla/database/table.php:289
9 JDatabaseMySQL->query() /home/turquoi1/public_html/libraries/joomla/database/database/mysql.php:539
10 JError->raiseError() /home/turquoi1/public_html/libraries/joomla/database/database/mysql.php:229
11 JError->raise() /home/turquoi1/public_html/libraries/joomla/error/error.php:171
12 JException->__construct() /home/turquoi1/public_html/libraries/joomla/error/error.php:136

and indeed 'metakey' does not appear in the install.bak file that I copied and pasted as SQL queries.

DROP TABLE IF EXISTS `#__phocagallery_categories`;
CREATE TABLE `#__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,
`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 default '0000-00-00 00:00:00',
`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 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',
`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 '',
`params` text,
`extid` varchar(255) NOT NULL default '',
`exta` varchar(255) NOT NULL default '',
`extu` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `cat_idx` (`section`,`published`,`access`),
KEY `idx_access` (`access`),
KEY `idx_checkout` (`checked_out`)
) TYPE=MyISAM CHARACTER SET `utf8`;

Is the install.bak file correct in 2.6.2?

Thanks!
Patrick

[Jan]

Hi, it is missing there. I am planning to add it there, but still not found time for doing it (as I am not able to answer all the posts here )

You should add the following:

`metakey` text,
`metadesc` text,

code into phocagallery and phocagallery_categories table.


Jan

[Jan]

Ok

[Patrick73]

Thanks a lot! That works just fine now
Patrick