Page 1 of 1

Phocagallery 4.3.6 1054 the page cannot be found

Posted: 18 Aug 2017, 12:57
by 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.

Re: Phocagallery 4.3.6 1054 the page cannot be found

Posted: 22 Aug 2017, 15:31
by 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

Re: Phocagallery 4.3.6 1054 the page cannot be found

Posted: 22 Aug 2017, 18:50
by tommi74
nachtrag zur fehlerfindung: da kommt eine fehlermeldung: 1054 - Unknown column 'c.image_id' in 'field list'

Re: Phocagallery 4.3.6 1054 the page cannot be found

Posted: 23 Aug 2017, 11:42
by 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

Re: Phocagallery 4.3.6 1054 the page cannot be found

Posted: 23 Aug 2017, 18:10
by 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

Re: Phocagallery 4.3.6 1054 the page cannot be found

Posted: 24 Aug 2017, 13:13
by 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.

Re: Phocagallery 4.3.6 1054 the page cannot be found

Posted: 24 Aug 2017, 15:09
by 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

Re: Phocagallery 4.3.6 1054 the page cannot be found

Posted: 24 Aug 2017, 20:04
by 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.

Re: Phocagallery 4.3.6 1054 the page cannot be found

Posted: 27 Aug 2017, 10:55
by 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