PhocaGuestbook not working after Joomla update to 3.4.2

Phoca Guestbook - creating guestbooks in Joomla! CMS
TheCellist
Phoca Newbie
Phoca Newbie
Posts: 3
Joined: 01 Jul 2015, 11:01

PhocaGuestbook not working after Joomla update to 3.4.2

Post by TheCellist » 01 Jul 2015, 11:16

Hello everyone!

I've got a problem with PhocaGuestbook 3.0.4 after updating Joomla from version 3.4.1 to 3.4.2.
This is the error message I get when I try to access the guestbook on my site:

Code: Select all

1054 - Unknown column 'i.state' in 'on clause' SQL=SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems FROM j17_categories as c LEFT JOIN j17_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM j17_categories AS cat JOIN j17_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_phocaguestbook' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id LEFT JOIN `j17_phocaguestbook_items` AS i ON i.`catid` = c.id AND i.state = 1 AND (i.language = '*' OR i.language = 'de-DE') WHERE (c.extension='com_phocaguestbook' OR c.extension='system') AND c.access IN (1,1) AND c.published = 1 AND s.id=60 AND badcats.id is null GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version ORDER BY c.lft
In the backend everything seems to be working fine.
Does anyone have a clue what might have gone wrong and how I could fix this?
Thanks!

Richard67
Phoca Member
Phoca Member
Posts: 27
Joined: 23 Mar 2012, 09:51

Re: PhocaGuestbook not working after Joomla update to 3.4.2

Post by Richard67 » 01 Jul 2015, 17:15

I can confirm the issue. It seems there has something changed with Jooma! so a column state is checked, which does not exist in the phocaguestbook items table. I helped myself by adding such a column with mysql, type equal to the published column, but this can be only a temporary solution.

Richard67
Phoca Member
Phoca Member
Posts: 27
Joined: 23 Mar 2012, 09:51

Re: PhocaGuestbook not working after Joomla update to 3.4.2

Post by Richard67 » 01 Jul 2015, 17:53

Hi again,
it definitely is caused by Joomla! 3.4.2.
There is a correction which solves this problem:
http://issues.joomla.org/tracker/joomla-cms/7303
See details also here:
https://github.com/joomla/joomla-cms/pull/7303/files
Apply the change shown there at github, clear your Joomla! and browser cache if necessary, and then all works.
Last edited by Richard67 on 01 Jul 2015, 22:58, edited 1 time in total.

User avatar
Benno
Phoca Hero
Phoca Hero
Posts: 7289
Joined: 04 Dec 2008, 11:58
Location: Germany
Contact:

Re: PhocaGuestbook not working after Joomla update to 3.4.2

Post by Benno » 01 Jul 2015, 18:22

Hi,
thank you for this information.

Kind regards,
Benno

TheCellist
Phoca Newbie
Phoca Newbie
Posts: 3
Joined: 01 Jul 2015, 11:01

Re: PhocaGuestbook not working after Joomla update to 3.4.2

Post by TheCellist » 02 Jul 2015, 11:09

Richard67 wrote:Hi again,
it definitely is caused by Joomla! 3.4.2.
There is a correction which solves this problem:
http://issues.joomla.org/tracker/joomla-cms/7303
See details also here:
https://github.com/joomla/joomla-cms/pull/7303/files
Apply the change shown there at github, clear your Joomla! and browser cache if necessary, and then all works.
Thanks Richard! :| Now it is working again.
I suppose there will be another Joomla update coming soon that solves this issue?

Richard67
Phoca Member
Phoca Member
Posts: 27
Joined: 23 Mar 2012, 09:51

Re: PhocaGuestbook not working after Joomla update to 3.4.2

Post by Richard67 » 02 Jul 2015, 13:06

Yes. I just read that they plan to do a 3.4.3 with hot fixes soon, which should also include this one.

User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 41997
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: PhocaGuestbook not working after Joomla update to 3.4.2

Post by Jan » 02 Jul 2015, 13:10

Hi, thank you for the info.

Jan
If you find Phoca extensions useful, please support the project

Richard67
Phoca Member
Phoca Member
Posts: 27
Joined: 23 Mar 2012, 09:51

Re: PhocaGuestbook not working after Joomla update to 3.4.2

Post by Richard67 » 02 Jul 2015, 18:07

Hi again,
just right now 3.4.3 has been released, which contains the correction for this issue here.
https://github.com/joomla/joomla-cms/releases
Best regards

TheCellist
Phoca Newbie
Phoca Newbie
Posts: 3
Joined: 01 Jul 2015, 11:01

Re: PhocaGuestbook not working after Joomla update to 3.4.2

Post by TheCellist » 03 Jul 2015, 10:36

Wow, that was quick!
I think with this hotfix the problem is solved now. Thank you very much!

Richard67
Phoca Member
Phoca Member
Posts: 27
Joined: 23 Mar 2012, 09:51

Re: PhocaGuestbook not working after Joomla update to 3.4.2

Post by Richard67 » 03 Jul 2015, 14:02

Thanks to the one who made the correction. I did only put here the information about it.

Post Reply