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
