Phoca Forum

Hello:

I have a site working with Joomla 2.5 and phoca gallery 3.2.3 all ok.

I update Joomla to 3.0.3 and phoca gallery don´t work. I install phoca gallery 4.0.0 and in backend all work fine, but in frontend, when click on a menu item who must display all the images of one category i recibed this error:

Can i make something to all work? (i don´t have a recent backup....)

Thanks¡¡¡¡ and sorry about my english.

"
0 - SQL=SELECT a.filename as filename, a.type as type, a.menulink as menulink FROM jom_phocagallery_styles AS a WHERE a.published = 1 ORDER BY a.type, a.ordering ASC
No puede visitar esta página debido a:

Un marcador o favorito caducado
Un motor de búsquedas que tiene un listado caducado para este sitio
Una dirección mal escrita
Usted no tiene acceso a esta página
No se pudo encontrar el recurso solicitado.
Se ha producido un error mientras se procesaba su solicitud.
Por favor, pruebe con alguna de las páginas siguientes::

Página de inicio
Si la dificultad persiste, por favor, contacte con el administrador del sistema de este sitio y reporte el error de más abajo..

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

Call stack
# Function Location
1 JSite->dispatch() W:\wamp\www\index.php:52
2 JComponentHelper::renderComponent() W:\wamp\www\includes\application.php:218
3 JComponentHelper::executeComponent() W:\wamp\www\libraries\legacy\component\helper.php:339
4 require_once() W:\wamp\www\libraries\legacy\component\helper.php:359
5 JControllerLegacy->execute() W:\wamp\www\components\com_phocagallery\phocagallery.php:53
6 PhocaGalleryController->display() W:\wamp\www\libraries\legacy\controller\legacy.php:722
7 JControllerLegacy->display() W:\wamp\www\components\com_phocagallery\controller.php:30
8 PhocaGalleryViewCategory->display() W:\wamp\www\libraries\legacy\controller\legacy.php:685
9 PhocaGalleryRenderFront->renderAllCSS() W:\wamp\www\components\com_phocagallery\views\category\view.html.php:60
10 JDatabaseDriver->loadObjectList() W:\wamp\www\administrator\components\com_phocagallery\libraries\phocagallery\render\renderfront.php:908
11 JDatabaseDriverMysql->execute() W:\wamp\www\libraries\joomla\database\driver.php:1218
"

Hi, I will try to look at it - testing now without getting such error, try to reinstall the Phoca Gallery (and test if all tables of Phoca Gallery are stored in database )

Jan

Yeahhh¡¡¡ yeahhh¡¡¡ yeahhh¡¡¡ I solve the problem. I only install witout unistall first and the error persist¡¡

I make a backup of the phoca gallery tables, unistall gallery, install gallery and restore tables¡¡¡¡

Lot of thankss¡¡¡¡¡¡¡¡¡¡

Ok