Phocagallery 4.3.6 1054 the page cannot be found

[mikjus]

Hi

Just updated Joomla to 3.7.5 and after that Phocagallery to 4.3.6 and plugin to 4.3.4. Dont even remember what was old versio but 4.1.something?

I can go to category view in gallery but when i try to open some category it gives me error 1054 the page cannot be found. Same for all categories. I can open images from gallery administration.

[tommi74]

Ich habe auch Probleme seit ich auf Joomla 3.7.5 upgedatet habe.

Nun kann ich keine Bilder von Phocagallery auf der Homepage darstellen. Es kommt wie hier geschrieben eine Fehlermeldung.

Erbitte hier um hilfestellung.
vielen Dank

[tommi74]

nachtrag zur fehlerfindung: da kommt eine fehlermeldung: 1054 - Unknown column 'c.image_id' in 'field list'

[christine]

Hi mikjus & tommy74,

update to J 3.7.5 does not (in generell) have any influence of previous version of J 3.7.4 as J.3.7.5 was a bug fix release for the 3.x series of Joomla! which addresses a single bug that prevents new installations of Joomla! 3.7.4 with remote databases:
https://www.joomla.org/announcements/re ... lease.html

Try to "repair the database" in backend.

Kind regards, Christine

[tommi74]

Hallo
Datenbank reparieren hat nicht geholfen. Was kann ich noch tun?
ich kann doch mit meiner Joomla Version ja nicht zurück.

gibt es vielleicht einen hinweis wo man in der Datenbank schauen kann wo das Problem ist und eventuell reparieren kann.

viele Grüße
THomas

[mikjus]

I downgraded phoca gallery to 4.3.1 and it works again. If i try to update to 4.3.6, i get 1054 error.

When updating to 4.3.6 it gives me files copy error in end but gives no details.

[Jan]

Hallo, kannst du hier die exakte Fehlermeldung schreiben (auch mit dem SQL) - dies kann man darstellen, wenn man "debug mode" in Global Configuration einschaltet.

Jan

[jorge.neto]

hello, i have the same error. what i do?

error:
1054
Unknown column 'c.image_id' in 'field list'
The Page you are looking for doesn't exist or an other error occurred. Go back, or head over to Página inicial to choose a new direction.

Essa página não pode ser vista porque:

um bookmark/favorito desatualizado
um mecanismo de busca com informação desatualizada sobre esse site
um endereço digitado errado
você não tem permissão para ver esta página
O ítem solicitado não foi encontrado.
Ocorreu um erro ao processar sua solicitação.

[Jan]

Hi, enable debug mode (in Joomla! Global Configuration) to get more detailed information about the error and let me know it.

Seems like your Joomla! didn't install the update properly, see:
administrator\components\com_phocagallery\update\sql\mysql\4.3.0.sql

You need to run this SQL query e.g. in your phpMyAdmin - in your database to complete the phoca gallery database tables:

Code: Select all

ALTER TABLE `#__phocagallery_categories` ADD COLUMN `image_id` int(11) NOT NULL default 0;

#__ should be changed to your prefix - e.g. - jos_


Jan