error after migrating to joomla 3

[libby]

Hi
I have migrated to Joomla 3 and installed Phoca gallery 4.0.1

When I try and access the gallery category menu pages through the front end I get an Error:0
and
Strict Standards: ...
In the back-end I get the following when I access the Phoca control panel:
Strict Standards: ...

Can you advise please?

[libby]

When I switch debug on I get this:

Error: 0

SQL=SELECT a.filename as filename, a.type as type, a.menulink as menulink FROM xxx_phocagallery_styles AS a WHERE a.published = 1 ORDER BY a.type, a.ordering ASC

[Jan]

Hi, see:
https://www.phoca.cz/documents/50-phoca/ ... tic-method

Jan

[libby]

Hi Jan
I can switch off the errors but I posted them because the gallery is not working.

I have menu items going to Phoca categories and these do not work. I have tried creating new menu items and I get the same error.

I click on the menu item eg: index.php?option=com_phocagallery&view=category&id=11&Itemid=499

and I get Error:0
with debug on I get the following:

0 SQL=SELECT a.filename as filename, a.type as type, a.menulink as menulink FROM xxx_phocagallery_styles AS a WHERE a.published = 1 ORDER BY a.type, a.ordering ASC

I have also tried to create a list of categories - same result.

I am guessing that the phoca database tables have not upgraded - but I am unsure how to fix that.

[Jan]

Hi, then you need to check the database, e.g. per phpMyAdmin, if it includes all the tables, see:
https://www.phoca.cz/documents/16-joomla ... ent-errors
https://www.phoca.cz/documents/2-phoca-g ... em-solving
Jan