Page 1 of 1
error after upgrading to ver 4.3.1
Posted: 12 Sep 2016, 21:58
by rhhollin
I just upgraded a site from joomla 2.5 to version 3.62, and in the process upgraded Phoca Gallery from ver 3.2.8 to the current version 4.3.1. I am using the Joomlashack Vintage template with the site. When I try to open the gallery in the web site, I get the following error message:
"1146 - Table 'dvhss030_db.#__phocagallery_styles' doesn't exist SQL=SELECT a.filename as filename, a.type as type, a.menulink as menulink FROM #__phocagallery_styles AS a WHERE a.published = 1 ORDER BY a.type, a.ordering ASC"
The photos on the site all seem to have updated OK and all of the control panel functions seem to be OK, I just cannot open the gallery in the site. Any suggestions are appreciated!
Re: error after upgrading to ver 4.3.1
Posted: 12 Sep 2016, 22:29
by Jan
Hi, seems like the migrate was not 100%, did you follow this guide:
https://www.phoca.cz/documents/50-phoca/ ... o-joomla-3
Seems like this table "phocagallery_styles" is missing in your database and needs to be added manually.
Just run the SQL query for creating this table in your database:
administrator\components\com_phocagallery\install\sql\mysql\install.utf8.sql
Code: Select all
INSERT INTO `#__phocagallery_styles` (`id`, `title`, `alias`, `filename`, `menulink`, `type`, `published`, `checked_out`, `checked_out_time`, `ordering`, `params`, `language`) VALUES
(1, 'Phocagallery', 'phocagallery', 'phocagallery.css', '', 1, 1, 0, '0000-00-00 00:00:00', 1, NULL, '*'),
(2, 'Rating', '', 'rating.css', NULL, 1, 1, 0, '0000-00-00 00:00:00', 2, NULL, '*'),
(3, 'Default', '', 'default.css', NULL, 2, 1, 0, '0000-00-00 00:00:00', 3, NULL, '*');
#__ - change #__ to your database prefix.
Jan
Re: error after upgrading to ver 4.3.1
Posted: 13 Sep 2016, 07:09
by rhhollin
Jan - thanks for the quick reply. I used the software Migrate Me PLUS to upgrade from Joomla 2.5 to Joomla 3.6.2 and it duplicated all of the existing Phoca Gallery tables for the new Joomla 3.6.2 development site. However, I am guessing that since I did not upload the new version of Phoca Gallery to the old site prior to running the Migrate Me PLUS program, I am missing the table in question. As such, don't I have to run a SQL CREATE TABLE command before I run the INSERT INTO command above? I do not understand your instruction to run the SQL query for creating the table, i.e.: administration\components\com_phocagallery\install\sql\mysql\install.utf8.sql. Thanks for the assistance and hopefully I will get it with further explanation.
Re: error after upgrading to ver 4.3.1
Posted: 13 Sep 2016, 12:23
by Jan
Hi, if some specific Phoca Gallery table is missing in database, you need to create it manually. For this, there are SQL instructions inside the file:
administration\components\com_phocagallery\install\sql\mysql\install.utf8.sql
Jan
Re: error after upgrading to ver 4.3.1
Posted: 14 Sep 2016, 03:42
by rhhollin
Jan - Thanks for the further explanation. After looking more closely at the database in phpMyAdmin, I realized that my migration program had apparently had in fact not brought over several tables. As such, I went back to my joomla 2.5 site and updated the Phoca Gallery extension on that site and ran the upgrade again. This time it worked better and the new site is almost working as it should. At this point I am using a menu with the categories view. The resulting page shows a thumbnail image from each of the four subcategories, but the descriptive text is cut off. The category name is not displayed and an error message is displayed above the page that states:
Notice: Undefined property: stdClass::$image_id in /home/dvhss030/public_html/mmp_upgrade/components/com_phocagallery/models/categories.php on line 171
Selecting one of the subcategory images does bring up the correct page with all of the thumbnails for that subcategory correctly displayed. Clicking on each a thumbnail will bring up the image viewer correctly and the slide program function performs correctly.
Your help in getting me through this process is much appreciated!!
Re: error after upgrading to ver 4.3.1
Posted: 14 Sep 2016, 12:46
by Jan
Hi, this seems like not only some tables were missing but some columns in current tables are missing too. For example categories table includes this column:
image_id
I would suggest to make migration of Phoca Gallery with help of this guide:
How to migrate extensions from Joomla! 2.5 to Joomla! 3 