Error after updating from 3.75 to 3.8

Before you ask see the Phoca Gallery User Manual
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 » 25 Sep 2017, 18:25

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: 39060
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Error after updating from 3.75 to 3.8

Post by Jan » 29 Sep 2017, 09:43

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 » 29 Sep 2017, 16:27

Great, thank you, everything is working great now!

Thank you very much,

Robert

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

Re: Error after updating from 3.75 to 3.8

Post by Jan » 02 Oct 2017, 12:54

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

Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests