upgraded from 3.2.0 to 3.2.1 and meta keywords stopped!

[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.

[Jan]

Hi, what you exactly means with meta keyword generation?

[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

[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

[Jan]

Hi, fixed in 3.2.2