After upgrade 1.6.1.1 cannot login to Back Office

[René Kuenen]

Hello,

 

I have upgraded from 1.5.6.3 to 1.6.1.1 and now I cannot login to the BO.

The front office gives me the 500 Internal server error in stead of the maintenance page.

 

Before upgrade I did empty cache, database optimization.

Server performance = Low

Disable non-native modules = Yes

Upgrade the "default" theme = Yes

Upgrade the default e-mails = No

 

I get the login screen and when I input the credentials the screen removes the login and password bar and stays that way.

If I input wrong credentials it gives me the normal screen with the comment for wrong credentials. (see attachments)

 

I turned on Debug  in defines.inc.php, not error what so ever.

 

What should I do to resolve this problem?

Thanks in advance.

 

Regards René

Edited September 19, 2015 by René Kuenen (see edit history)

[René Kuenen]

I have set the debug profiling on.

This is the result. Maybe it helps....

 

Caught redirection to index.php?controller=AdminLogin&token=4bb531d43dd0db66c870bdc444a2537a

Load Time 708 ms - Unicorn powered webserver! Querying Time 110 ms Queries 37 Memory Peak Usage 20.3 Mb Included Files 120 files - 3.25 Mb PrestaShop Cache 0.57 Mb Global vars 1.73 Mb

 

PrestaShop Version 1.6.1.1 PHP Version 5.4.0 (OK) MySQL Version 5.5.34-cll-lve (Consider upgrading) Memory Limit 512M Max Execution Time 90s Smarty Cache enabled Smarty Compilation auto

 

  Time Cumulated Time Memory Usage Memory Peak Usage config 270ms 270 ms 13.92Mb 14.03Mb __construct 0 ms 270 ms - Mb 14.03Mb init 301ms 571 ms 4.87 Mb 19.07Mb checkAccess 0 ms 571 ms - Mb 19.07Mb setMedia 127ms 698 ms 0.61 Mb 19.79Mb postProcess 0 ms 698 ms - Mb 19.79Mb initHeader 4 ms 702 ms 0.22 Mb 19.93Mb initContent 4 ms 706 ms 0.22 Mb 20.31Mb initFooter 2 ms 708 ms 0.04 Mb 20.31Mb

 

Hook Time Memory Usage __construct 109ms 5.00 Mb hookdisplayBackOfficeHeader 23ms - Mb hookactionAdminControllerSetMedia 1 ms - Mb hookbackofficeheader 0 ms - Mb hookmoduleRoutes 0 ms - Mb 5 hooks 133ms 5.00 Mb

 

Module Time Memory Usage smartblog 33 ms 2.25 Mb paypal 32 ms 1.25 Mb themeconfigurator 26 ms - Mb gamification 17 ms - Mb emptycache 8 ms 0.50 Mb dashactivity 7 ms 0.25 Mb ganalytics 4 ms 0.25 Mb dashgoals 3 ms 0.25 Mb dashtrends 3 ms 0.25 Mb 9 modules 133 ms 5.00 Mb

 

1. Stopwatch SQL
2. Doubles
3. Tables stress
4. ObjectModel instances
5. Included Files

Stopwatch SQL - 37 queries Query Time (ms) Rows Filesort Group By Location SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m 20.6 92     /classes/module/Module.php:277 SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop
FROM `ps_configuration` c
LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`) 9.9 4578     /classes/Configuration.php:148 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='compile' LIMIT 1 9.7 0     /classes/SmartyCustom.php:95 SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "paypal" LIMIT 1 8.5 1     /classes/module/Module.php:2569 SELECT SQL_NO_CACHE id_tab, class_name FROM `ps_tab` 7.4 114     /classes/Tab.php:296 SELECT SQL_NO_CACHE a.`id_ps_advice`, a.`selector`, a.`location`, al.`html`, a.`weight`
FROM `ps_advice` a
LEFT JOIN `ps_advice_lang` al ON al.`id_advice` = a.`id_advice`
LEFT JOIN `ps_tab_advice` at ON at.`id_advice` = a.`id_advice`
WHERE (
a.`validated` = 1 AND
a.`hide` = 0 AND
al.`id_lang` = 1 AND
at.`id_tab` = 1 AND
((a.`start_day` = 0 AND a.`stop_day` = 0) OR (19 >= a.`start_day` AND 19 <= a.`stop_day`))) 5.4 39     /modules/gamification/classes/Advice.php:99 SELECT SQL_NO_CACHE version FROM `ps_module` WHERE name = 'paypal' LIMIT 1 5.3 1     /modules/paypal/paypal.php:224 SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit`
FROM `ps_module` m
INNER JOIN ps_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1)
INNER JOIN `ps_module_shop` ms ON ms.`id_module` = m.`id_module`
INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module`
INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook`
WHERE (h.name != "displayPayment") AND (hm.id_shop = 1)
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position` 4.7 61 Yes Yes /classes/Hook.php:355 SELECT SQL_NO_CACHE l.*, ls.`id_shop`
FROM `ps_lang` l
LEFT JOIN `ps_lang_shop` ls ON (l.id_lang = ls.id_lang) 4.1 1     /classes/Language.php:777 SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions`
WHERE `id_shop` IN (1) 3.1 851     /classes/module/Module.php:2142 SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `ps_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `ps_hook_alias` ha
INNER JOIN `ps_hook` h ON ha.name = h.name 2.7 0     /classes/Hook.php:131 SELECT SQL_NO_CACHE t.`class_name`, t.`module`
FROM `ps_tab` t
WHERE t.`module` IS NOT NULL AND t.`module` != "" 2.6 114     /classes/Tab.php:236 SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit`
FROM `ps_module` m
INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module`
INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook`
WHERE (h.name != "displayPayment") AND (hm.id_shop = 1)
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position` 2.3 92 Yes Yes /classes/Hook.php:355 SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1 2.3 1     /classes/shop/Shop.php:1067 SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `ps_meta` m
LEFT JOIN `ps_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 )
ORDER BY LENGTH(ml.url_rewrite) DESC 1.7 32 Yes   /classes/Dispatcher.php:452 SELECT SQL_NO_CACHE gs.*, s.*, gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri
FROM ps_shop_group gs
LEFT JOIN ps_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN ps_shop_url su
ON s.id_shop = su.id_shop AND su.main = 1
WHERE s.deleted = 0
AND gs.deleted = 0
ORDER BY gs.name, s.name 1.7 1 Yes   /classes/shop/Shop.php:663 SELECT SQL_NO_CACHE *
FROM `ps_tab` a
LEFT JOIN `ps_tab_lang` `b` ON a.`id_tab` = b.`id_tab` AND b.`id_lang` = 1
WHERE (a.`id_tab` = 1) LIMIT 1 1.6 1     /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE t.*, tl.name
FROM `ps_tab` t
LEFT JOIN `ps_tab_lang` tl ON (t.`id_tab` = tl.`id_tab` AND tl.`id_lang` = 1)
WHERE 1
ORDER BY t.`position` ASC 1.5 114 Yes   /classes/Tab.php:263 SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 13) LIMIT 1 1.4 1     /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM ps_shop_url su
LEFT JOIN ps_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'in2sound.nl' OR su.domain_ssl = 'in2sound.nl')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC 1.4 1 Yes   /classes/shop/Shop.php:334 SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m 1.4 92     /classes/module/Module.php:277 SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `ps_lang` l
JOIN ps_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1)
WHERE l.`active` = 1 LIMIT 1 1 1     /classes/Language.php:894 SELECT SQL_NO_CACHE *
FROM `ps_currency` a
LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 1) LIMIT 1 1 1     /Adapter/Adapter_EntityMapper.php:61 UPDATE `ps_employee`
SET `last_connection_date` = CURRENT_DATE()
WHERE `id_employee` = 0 AND `last_connection_date`< CURRENT_DATE() 1 1     /classes/Employee.php:494 SELECT SQL_NO_CACHE *
FROM `ps_access` a
LEFT JOIN `ps_tab` t ON t.id_tab = a.id_tab
WHERE `id_profile` = 0 1 1     /classes/Profile.php:143 SELECT SQL_NO_CACHE gs.*, s.*, gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri
FROM ps_shop_group gs
LEFT JOIN ps_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN ps_shop_url su
ON s.id_shop = su.id_shop AND su.main = 1
WHERE s.deleted = 0
AND gs.deleted = 0
ORDER BY gs.name, s.name 0.9 1 Yes   /classes/shop/Shop.php:663 SELECT SQL_NO_CACHE * FROM `ps_hook_alias` 0.9 86     /classes/Hook.php:187 SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl, t.id_theme, t.name, t.directory
FROM ps_shop s
LEFT JOIN ps_shop_url su ON (s.id_shop = su.id_shop)
LEFT JOIN ps_theme t ON (t.id_theme = s.id_theme)
WHERE s.id_shop = 1
AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1 0.9 1     /classes/shop/Shop.php:203 SELECT SQL_NO_CACHE `version` FROM `ps_module` WHERE `name` = 'gamification' LIMIT 1 0.7 1     /modules/gamification/gamification.php:154 SELECT SQL_NO_CACHE `id_parent`
FROM `ps_tab`
WHERE LOWER(class_name) = 'admindashboard' LIMIT 1 0.6 114     /classes/Tab.php:191 SELECT SQL_NO_CACHE *
FROM `ps_tab` t
LEFT JOIN `ps_tab_lang` tl
ON (t.`id_tab` = tl.`id_tab` AND tl.`id_lang` = 1)
WHERE t.`id_tab` = 1 LIMIT 1 0.6 1     /classes/Tab.php:217 SELECT SQL_NO_CACHE *
FROM `ps_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1 0.5 1     /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE *
FROM `ps_lang` a
LEFT JOIN `ps_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1
WHERE (a.`id_lang` = 1) LIMIT 1 0.5 1     /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE domain, domain_ssl
FROM ps_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1 0.5 1     /classes/shop/ShopUrl.php:169 SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "gamification" LIMIT 1 0.5 1     /classes/module/Module.php:2569 SELECT SQL_NO_CACHE *
FROM `ps_theme` a
WHERE (a.`id_theme` = 2) LIMIT 1 0.4 1     /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 64 AND `id_shop` = 1 LIMIT 1 0.4 1     /classes/module/Module.php:2219

Doubles 2 SELECT gs.*, s.*, gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri
                FROM ps_shop_group gs
                LEFT JOIN ps_shop s
                    ON s.id_shop_group = gs.id_shop_group
                LEFT JOIN ps_shop_url su
                    ON s.id_shop = su.id_shop AND su.main = XX
                
                WHERE s.deleted = XX
                    AND gs.deleted = XX
                    
                ORDER BY gs.name, s.name 2                 SELECT m.`id_module`, m.`name`, (
                    SELECT id_module
                    FROM `ps_module_shop` ms
                    WHERE m.`id_module` = ms.`id_module`
                    AND ms.`id_shop` = XX
                    LIMIT XX
                ) as mshop
                FROM `ps_module` m

Tables stress 8 module 7 tab 5 shop_url 5 shop 5 module_shop 4 hook 3 tab_lang 3 lang 3 lang_shop 2 hook_alias 2 hook_module 2 configuration 2 theme 2 shop_group 1 hook_module_exceptions 1 currency_shop 1 advice 1 advice_lang 1 smarty_last_flush 1 tab_advice 1 currency 1 access 1 meta 1 configuration_lang 1 meta_lang 1 country_lang 1 country_shop 1 country

ObjectModel instances Name Instances Source Shop 2 /config/config.inc.php [114]
/classes/controller/AdminController.php [1924] Tab 1 /classes/Dispatcher.php [307] Currency 1 /classes/controller/AdminController.php [494] Language 1 /config/config.inc.php [198] Employee 1 /config/config.inc.php [182] Theme 1 /config/config.inc.php [115] Country 1 /config/config.inc.php [142]

Included Files # Filename 1 /admin5977/index.php 2 /config/config.inc.php 3 /config/defines.inc.php 4 /config/settings.inc.php 5 /config/autoload.php 6 /config/alias.php 7 /classes/PrestaShopAutoload.php 8 /cache/class_index.php 9 /config/bootstrap.php 10 /Core/Business/Core_Business_ContainerBuilder.php 11 /Core/Foundation/IoC/Core_Foundation_IoC_Container.php 12 /Adapter/Adapter_ServiceLocator.php 13 /classes/controller/Controller.php 14 /classes/ObjectModel.php 15 /Core/Foundation/Database/Core_Foundation_Database_EntityInterface.php 16 /classes/db/Db.php 17 /classes/Tools.php 18 /classes/Context.php 19 /classes/shop/Shop.php 20 /classes/db/DbPDO.php 21 /classes/Configuration.php 22 /classes/Validate.php 23 /classes/cache/Cache.php 24 /Adapter/Adapter_EntityMapper.php 25 /classes/db/DbQuery.php 26 /classes/Theme.php 27 /config/defines_uri.inc.php 28 /tools/htmlpurifier/HTMLPurifier.standalone.php 29 /classes/Language.php 30 /classes/Country.php 31 /classes/PrestaShopCollection.php 32 /classes/Cookie.php 33 /classes/Rijndael.php 34 /classes/Employee.php 35 /classes/Link.php 36 /classes/shop/ShopUrl.php 37 /config/smarty.config.inc.php 38 /tools/smarty/Smarty.class.php 39 /tools/smarty/sysplugins/smarty_internal_data.php 40 /tools/smarty/sysplugins/smarty_internal_templatebase.php 41 /tools/smarty/sysplugins/smarty_internal_template.php 42 /tools/smarty/sysplugins/smarty_resource.php 43 /tools/smarty/sysplugins/smarty_internal_resource_file.php 44 /tools/smarty/sysplugins/smarty_cacheresource.php 45 /tools/smarty/sysplugins/smarty_internal_cacheresource_file.php 46 /classes/SmartyCustom.php 47 /config/smartyadmin.config.inc.php 48 /admin5977/functions.php 49 /images.inc.php 50 /classes/Dispatcher.php 51 /classes/Hook.php 52 /classes/Group.php 53 /tools/mobile_Detect/Mobile_Detect.php 54 /config/db_slave_server.inc.php 55 /classes/module/Module.php 56 /modules/smartblog/smartblog.php 57 /modules/smartblog/classes/BlogCategory.php 58 /modules/smartblog/classes/Blogcomment.php 59 /modules/smartblog/classes/BlogPostCategory.php 60 /modules/smartblog/classes/BlogTag.php 61 /modules/smartblog/classes/SmartBlogPost.php 62 /modules/smartblog/classes/BlogImageType.php 63 /modules/smartblog/controllers/admin/AdminAboutUsController.php 64 /classes/controller/ModuleAdminController.php 65 /classes/controller/AdminController.php 66 /classes/Translate.php 67 /themes/in2sound/modules/smartblog/translations/nl.php 68 /modules/smartblog/translations/nl.php 69 /classes/Tab.php 70 /controllers/admin/AdminDashboardController.php 71 /translations/nl/admin.php 72 /classes/Profile.php 73 /classes/Currency.php 74 /modules/themeconfigurator/themeconfigurator.php 75 /themes/in2sound/modules/themeconfigurator/translations/nl.php 76 /modules/themeconfigurator/translations/nl.php 77 /modules/gamification/gamification.php 78 /modules/gamification/classes/Badge.php 79 /modules/gamification/classes/Advice.php 80 /modules/gamification/classes/Condition.php 81 /modules/gamification/classes/GamificationTools.php 82 /themes/in2sound/modules/gamification/translations/nl.php 83 /modules/gamification/translations/nl.php 84 /classes/Media.php 85 /modules/emptycache/emptycache.php 86 /modules/emptycache/classes/modulesamdha.php 87 /themes/in2sound/modules/emptycache/translations/nl.php 88 /modules/emptycache/translations/nl.php 89 /cache/smarty/compile/36/0d/59/360d59ba6a1fae6ae8d417710552169bf1a8d744.file.addjs.tpl.php 90 /modules/paypal/paypal.php 91 /modules/paypal/api/paypal_lib.php 92 /modules/paypal/api/paypal_connect.php 93 /modules/paypal/paypal_logos.php 94 /modules/paypal/paypal_orders.php 95 /modules/paypal/paypal_tools.php 96 /modules/paypal/paypal_login/paypal_login.php 97 /modules/paypal/paypal_login/PayPalLoginUser.php 98 /modules/paypal/classes/PaypalCapture.php 99 /classes/PaymentModule.php 100 /themes/in2sound/modules/paypal/translations/nl.php 101 /modules/paypal/translations/nl.php 102 /modules/ganalytics/ganalytics.php 103 /themes/in2sound/modules/ganalytics/translations/nl.php 104 /modules/ganalytics/translations/nl.php 105 /cache/smarty/compile/f3/87/a4/f387a4c145a9b7cf43e928487f4d8ec75e734038.file.login_addons.tpl.php 106 /modules/dashactivity/dashactivity.php 107 /themes/in2sound/modules/dashactivity/translations/nl.php 108 /modules/dashactivity/translations/nl.php 109 /modules/dashtrends/dashtrends.php 110 /themes/in2sound/modules/dashtrends/translations/nl.php 111 /modules/dashtrends/translations/nl.php 112 /modules/dashgoals/dashgoals.php 113 /themes/in2sound/modules/dashgoals/translations/nl.php 114 /modules/dashgoals/translations/nl.php 115 /translations/nl/errors.php 116 /cache/smarty/compile/58/4a/53/584a538139f8df0e2d07ffac61dcb4ea9a3cee53.file.modal.tpl.php
 

[Simonas Invertus]

I had the same issue, after update one of the module was so old that it could not function properly and it crashed my ability to log in into backOffice.

So i analysed errors with firebug in firefox find out the module which was causing the issues and deleted that module directory from the server.

 

From this log I am not sure which module causes the problem. 

[René Kuenen]

Thanks Simonas,

 

Can you tell me witch module give you the trubble, maybe we have the same one. 

[Simonas Invertus]

I had old auction module.

I do not think that you have it.

[Emmanuel D]

I René,

 

I do have the same problem.

 

I just modifyed yesterday the carriers and since that time, impossbile to access the BO. Error 500.

 

Front is just fine.

 

The same site is well running under local PC.

 

Di you find a solution ?

 

OVH told me that this is not heir fault as the front is woking well.

 

Regards,

 

Emmanuel.

[Emmanuel D]

For you info, I even tried to restore backups from past days and even whith these files, it does not work when it was perfectly working the other days.

[René Kuenen]

I did not solve my problem.

I had to rollback to my Back-up.

 

Did you also rollback your database?

[Emmanuel D]

Hi,

 

I rolled-back my database several time and it was not working.

 

I finally found the problem in enabling the debogue mode.

In "defines.inc.php" juste put "true" for debogue mode.

 

/* Debug only */

if (!defined('_PS_MODE_DEV_')) {

define('_PS_MODE_DEV_', false);

}

 

 

I could find the problem : I restored a backup version where inside a module, I had the name of a php file in minus letters instead of minus/capital letters.

 

The module could not call the file when launching the BO and it was the problem.

 

Hope this will help.

 

Emmanuel.

[Appwards]

The same thing happened for me using PS 1.6.1.1.

It triggered when I disabled all non-Prestashop modules.

 

The only way I managed to solve it is by temporarily changing the code of /tools/profiling/Controller.php and adding "return;" as the first line in the run() method.

After that the site worked again and so I removed the "return;" again.

The site kept working from there on.