Phoca Forum

Hi All,

Need some help i have upgraded to phoca 4.1.2 and joomla 3.4 (from 2.5.28) i can get the back end working fine all my categories and images are there however when i try and set category view in the front end i get the following error

TABLE '######_######.J25_PHOCAGALLERY_STYLES' DOESN'T EXIST SQL=SELECT A.FILENAME AS FILENAME, A.TYPE AS TYPE, A.MENULINK AS MENULINK FROM J25_PHOCAGALLERY_STYLES AS A WHERE A.PUBLISHED = 1 ORDER BY A.TYPE, A.ORDERING ASC
GO BACK HOM

All the tables exists and i have tried everything, im getting to the point now where i may need to try another component but i really like phoca.

Thanks in advance for any help

Hi,

TABLE '######_######.J25_PHOCAGALLERY_STYLES' DOESN'T EXIST SQL=SELECT A.FILENAME AS FILENAME, A.TYPE AS TYPE, A.MENULINK AS MENULINK FROM J25_PHOCAGALLERY_STYLES AS A WHERE A.PUBLISHED = 1 ORDER BY A.TYPE, A.ORDERING ASC

All the tables exists...[...]

See: https://www.phoca.cz/documents/16-joomla ... ase-column

Kind regards,
Benno

I have tried that a few tinmes but still it does not work.
Thanks

Can no one help?

Hi,
1.) do you have followed this migration guide step by step? https://www.phoca.cz/documents/50-phoca/ ... o-joomla-3
2.) do you have created the missing table j25_phocagallery_styles manually now?

Kind regards,
Benno

Hi,

Yes i have done this.

Thanks Mark

Hi, the error says that the table is missing which means it was not created, try to take a look into your database and check if it really exists.

Jan

Hi Jan,

I have followed the instructions what would stop this table creating?


Thanks Mark

Hi, see:
viewtopic.php?f=1&t=34561#p113200

Jan

Hi,
I tried to ugrade Phoca Gallery 4.1.1 in Joomla 3.9.6 and it didn't work.
in Categories I get the msg: Unknown column 'a.image_id' in 'group statement'
now, it Version doesn't show a version.

Also, I'm not able to add youtube videos as I did before ??? It seems to require an API, which I have but I don't see a where to add it in Phoca Gallery ???

Thanks for your help! Joan