Page 1 of 1

upgraded from 3.2.0 to 3.2.1 and meta keywords stopped!

Posted: 10 Jul 2012, 00:57
by justingbauer
i upgraded from 3.2.0 to 3.2.1 and meta keyword generation for my phoca gallery directories topped generating.

any ideas what the problem could be?

can i downgrade phoca to the old version without messing things up? i've never had to downgrade a version of phoca gallery before.

Re: upgraded from 3.2.0 to 3.2.1 and meta keywords stopped!

Posted: 10 Jul 2012, 14:55
by Jan
Hi, what you exactly means with meta keyword generation?

Re: upgraded from 3.2.0 to 3.2.1 and meta keywords stopped!

Posted: 15 Jul 2012, 21:58
by justingbauer
for a number of categories i have inputed meta keywords. after upgrading the keywords stopped generating in the sites frontend. i downgraded back to 3.2.0 and it is working again

Re: upgraded from 3.2.0 to 3.2.1 and meta keywords stopped!

Posted: 18 Jul 2012, 15:27
by Jan
Hi, thank you for this info (this is related to optimization of SQL queries in 3.2.1). Will be fixed in next version. For now you can do a quick fix:

In:
components\com_phocagallery\models\category.php

go to line cca: 204 and change the code

FROM:

Code: Select all

$query = 'SELECT c.id, c.title, c.alias, c.published, c.approved, c.parent_id, c.deleteuserid, c.accessuserid, c.uploaduserid, c.access,' .
TO:

Code: Select all

$query = 'SELECT c.id, c.title, c.alias, c.published, c.approved, c.parent_id, c.deleteuserid, c.accessuserid, c.uploaduserid, c.access, c.metakey, c.metadesc,' .
Thank you, Jan

Re: upgraded from 3.2.0 to 3.2.1 and meta keywords stopped!

Posted: 01 Oct 2012, 14:32
by Jan
Hi, fixed in 3.2.2