Upgraded to 1.9.2.2, now have front page problems.

Upgraded Magento from 1.9.2.1 to 1.9.2.2, using MegaMall theme.
 
Now on the front page, the following modules are completely failing to load:
MegaMenu
All product sliders
 
Attempting to access the config menu for JM Sildeshow or JM MEgamenu Groups results in just spinning “Please Wait” or a 404.
I’m guessing this is due to security updates in Magento 1.9.2.2.  Please advise on how to correct this issue.
 
Search and rest of website is fine, seems to only be these extensions.

6 answers

Profile photo of kylesasser 80.00 $tone October 29, 2015
Public

I have read the attached document, however when I attempt to go to System -> Blocks, i get the following error:
 

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'website_magento.magento_permission_block' doesn't exist, query was: SELECT COUNT(*) FROM `magento_permission_block` AS `main_table`

I checked the database, and that table does indeed not exist, and it doesn’t exist with a fresh 1.9.2.2 installation either.  Please advise on a solution.

#2
Profile photo of Mall Staff 184060.00 $tone October 30, 2015
Public

Hi kylesasser,
How did you upgrade the Magento core in your site?
Seem you are make wrong upgrade the Magento core in your site to Magento version 1.9.2.2
For this case, you can try down load the patch SUPEE-6788 at https://www.magentocommerce.com/download
and update it to your site by guide from Magento.
Let’s do it and contact me if you need further assistance!
Regards,
Mall.
 

#3
Profile photo of kylesasser 80.00 $tone October 30, 2015
Public

We went into System -> Magento Connect, check for upgrades, and then upgraded Mage_Core_All.  I will attempt the patch and see if that corrects the issue.

#4
Profile photo of kylesasser 80.00 $tone October 30, 2015
Public

 Thanks, this helped.
I downloaded the patch SUPEE-6788, attempted to install and it failed, so I reverted it and then reran it.  This created the necessary database tables.
I then created the following blocks which brought my front page back:
joomlart_jmslideshow/list
joomlart_jmproducts/list
joomlart_jmproductsslider/list
jmmegamenu/jmmegamenu
cms/block
Hopefully this will help some people in the future.

#5

Please login or Register to Submit Answer

Written By

Comments