Error saving filename when updating image record in back end

[bilon]

I've succesfully created couple of categories, using Images -> Multipple Add button. They work fine in front end. But when I try to change some attribute (for example Description) of an existing image, I get "Error saving filename" error. The same error I get when trying to add new image using Images - New button.

Using Joomla 1.5.15, Phoca Gallery 2.6.2

[Jan]

Hi, try to enable debug mode, maybe you will get more info.

Jan

[bilon]

Thanks for your hint. Here is result:

JDatabaseMySQL::query: 1054 - Unknown column 'metakey' in 'field list' SQL=UPDATE `jos_phocagallery` SET `catid`='6',`title`='had-khuat',`alias`='had-khuat',`filename`='ostrovy/koh-phangan/bottle-beach/had-khuat.jpg',`description`='xxx',`date`='2010-04-04 14:44:34',`hits`='4',`latitude`='',`longitude`='',`zoom`='0',`geotitle`='',`videocode`='',`vmproductid`='0',`imgorigsize`='124092',`published`='1',`approved`='1',`checked_out`='0',`checked_out_time`='0',`ordering`='1',`metakey`='',`metadesc`='',`extlink1`='',`extlink2`='' WHERE id='26'

It looks there's some discrepancy between version of phoca table jos_phocagallery and command issued against it.

[bilon]

Hi, I've finally found source of those problems. I faced some problems during installation, so I did manual installation. When installing database, I followed your instructions on the page
https://www.phoca.cz/documents/2-phoca-g ... em-solving
I did exactly as is written there, so I installed just "create table" commands and I have skipped "alter table" commands (because it was fresh installation). But the columns causing the error are added through "alter table" commands, so they are missing in my tables.

So, what are the exact instructions for fresh database installation?

[bilon]

Hello, is there anybody able to answer my question about database installation?

[Jan]

Hi, try to add the following lines:

ALTER TABLE `#__phocagallery` ADD `metakey` text AFTER `params`;
ALTER TABLE `#__phocagallery_categories` ADD `metakey` text AFTER `params` ;
ALTER TABLE `#__phocagallery` ADD `metadesc` text AFTER `params`;
ALTER TABLE `#__phocagallery_categories` ADD `metadesc` text AFTER `params` ;

change #__ to jos_

These lines are not added while installation so they needs to be added. This will be solved in next version.

Jan

[bilon]

Thanks, it works!

[Jan]

Ok