Phoca Forum

Hello Phoca Gallery users,

When I want to create a Category in Phoca Gallery I get the next error; Error Saving Phoca Gallery Categories
I manually ran the install.bak script in myphpadmin after it wasn't installed and I got the known error; mysql_num_rows(): supplied argument is not a valid MySQL result resource in/...... After the running of the sript in myPHPadmin ther were no errors, until I wanted to create a Category;

I think it has something to do with de database because I get the next error when I activate the errorreport:
500
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','testerdetest','testerdetest','','left','','2010-05-12 17:16:29','1','1','0','0','1','0','0','0','-2','-2','','','','','','','','','','' )
It looks like there is no metakey and metadesc in the database. This fields were not in de install.bak script i used from the download.

Do i have to create them in the jos_phocagallery_categories? How do i do that? Manually or with a script?

Or is there a simple solution.

I hope anyone can help me

Best regards,
Manuel Putmans
The Netherlands

Hi, check the latest version - the metakey and metadesc are included in install.bak file:

CREATE TABLE `#__phocagallery` ...
`metakey` text,
`metadesc` text,

CREATE TABLE `#__phocagallery_categories` ...
`metakey` text,
`metadesc` text,


Jan

Hello Jan,

Is this the exact script I have to run in myPHPadmin, Or do i have to run an update?

Can you help me. I don't know much about databases. What should I do exactly.

Thank you for your support.

Manuel

No, this is a part of install.bak file. So the whole query should be run