Error after updating from 3.75 to 3.8

Phoca Gallery - image gallery extension
mouco
Phoca Newbie
Phoca Newbie
Posts: 4
Joined: 12 Oct 2014, 09:11

Error after updating from 3.75 to 3.8

Post by mouco »

Hello,

After updating to Joomla 3.8 I am now getting the following error...

From the main menu on a Phoca Gallery Component link I get the following error before showing the gallery images.

"Notice: Undefined property: stdClass::$image_id in /home/.../public_html/components/com_phocagallery/models/categories.php on line 171"

then if I click one of the gallery page images I get the following error:

Unknown column 'c.image_id' in 'field list'

anyone have any ideas...

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

Re: Error after updating from 3.75 to 3.8

Post by Jan »

Hi, it seems like Joomla! extension manager didn't update the c_image_id column, so it needs to be udpated manually (e.g. with help of phpMyAdmin) on your server. Run this query in your database:

Code: Select all

ALTER TABLE `#__phocagallery_categories` ADD COLUMN `image_id` int(11) NOT NULL default 0;
Change the #__ to your prefix in your database.


administrator/components/com_phocagallery/update/sql/mysql\4.3.0.sql
Jan
If you find Phoca extensions useful, please support the project
mouco
Phoca Newbie
Phoca Newbie
Posts: 4
Joined: 12 Oct 2014, 09:11

Re: Error after updating from 3.75 to 3.8

Post by mouco »

Great, thank you, everything is working great now!

Thank you very much,

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

Re: Error after updating from 3.75 to 3.8

Post by Jan »

Ok
If you find Phoca extensions useful, please support the project
Post Reply