500 internal server error after upgrade

[SqualaDesign]

Hello,

 

I have upgraded a shop from v1.5.6.2 to v1.6 (latest) via the 1-Click upgrade.  All went well however after re-enabling the shop the homepage is not being displayed.  Instead I get the message '500 Server Error' in front end

 

I can log into the back end and edit products and other pasts of the store.

 

Can anyone tell me how I can sort this out? 

 

Any help appreciated.

[fred-vinapresta]

Hi, empty the .htaccess file at the root of your website, then try to connect to the admin and active/unactive firendly url to regenerate it

[SqualaDesign]

Hi, empty the .htaccess file at the root of your website, then try to connect to the admin and active/unactive firendly url to regenerate it

 

Thanks but i try that metod:

• delete cache
• empty .htaccess at the root of web site
• active/unactive friendly URL
• set permission folders all are 755 and files 644

The server works very good and other prestahop web site are fine!

 

I have no idea

Edited March 10, 2015 by SqualaDesign (see edit history)

[ralaper]

I have the same mistake,you can execute this sql script,it's work fine

 

SET FOREIGN_KEY_CHECKS=0;

 

-- ----------------------------

-- Table structure for request_sql

-- ----------------------------

DROP TABLE IF EXISTS `request_sql`;

CREATE TABLE `request_sql` (

  `id_request_sql` int(11) NOT NULL AUTO_INCREMENT,

  `name` varchar(200) NOT NULL,

  `sql` text NOT NULL,

  PRIMARY KEY (`id_request_sql`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

 

-- ----------------------------

-- Records of request_sql

-- ----------------------------

 

-- ----------------------------

-- Table structure for required_field

-- ----------------------------

DROP TABLE IF EXISTS `required_field`;

CREATE TABLE `required_field` (

  `id_required_field` int(11) NOT NULL AUTO_INCREMENT,

  `object_name` varchar(32) NOT NULL,

  `field_name` varchar(32) NOT NULL,

  PRIMARY KEY (`id_required_field`),

  KEY `object_name` (`object_name`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

 

-- ----------------------------

-- Records of required_field

-- ----------------------------