Jump to content

TECHNICAL ERROR: Details: Error thrown: [object Object] Text status: error

DCS Engenharia
 Share

Recommended Posts

DCS Engenharia Newbie

DCS Engenharia

Posted
Posted (edited)

Hi guys,

 

I'm in trouble, can help me?

 

 

When trying to update to automatically format (module prestashop the upgrade) of my prestashop: 1.5.4.1 to the newest, an error occurred. 
 
When trying to revert to the backup generated by the module, also occurred. 
 
then with my PC backup and sent to Filezilla FTP. 
 
However, before that, to facilitate the new DB settings, I saved the settings.inc.php and setting.old.php in my backup. 
 
The backup system was a simple cache. the current system had Memcached system and I believe that this is the problem I'm having
 
*I have VPS.
 
post-348935-0-20312900-1390339292_thumb.png
 
error log:

Load time: 853ms
I hope it is a shared hosting
config: 378ms
constructor: 0ms
init: 451ms
checkAccess: 0ms
setMedia: 0ms
postProcess: 0ms
initHeader: 0ms
initContent: 14ms
initFooter: 0ms
display: 10ms
Hook processing: 478ms / 0.65 Mb
displayBackOfficeTop: 445ms / 0.51 Mb
moduleRoutes: 32ms / 0.14 Mb
actionDispatcher: 0ms / 0 Mb
Memory peak usage: 6.26 Mb
config: 3.97 Mb
constructor: 0 Mb
init: 0.65 Mb
checkAccess: 0 Mb
setMedia: 0 Mb
postProcess: 0 Mb
initHeader: 0 Mb
initContent: 0.24 Mb
initFooter: 0 Mb
display: 0.2 Mb


Total cache size (in Cache class): 0.17 Mb DB type: DbPDO 
SQL Queries: 29 queries 
Time spent querying: 76ms Included files: 72
Size of included files: 1.42 Mb Globals (> 1 Ko only): 749 Ko
_LANGADM ≈ 723.3 Ko
context ≈ 18.5 Ko
_SERVER ≈ 4.1 Ko
Go to Stopwatch
Go to Doubles
Go to Tables
Go to ObjectModels
Stopwatch (with SQL_NO_CACHE) (total = 29)

16.847 ms 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 ((SELECT COUNT(*) FROM ps_module_shop ms WHERE ms.id_module = m.id_module AND ms.id_shop IN (1)) = 1) AND (h.name != "displayPayment") AND (hm.id_shop = 1) ORDER BY hm.`position`
in /var/www/comprasuniversitarias/public_html/classes/Hook.php:296
USING FILESORT - 89 rows browsed
15.349 ms 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)
in /var/www/comprasuniversitarias/public_html/classes/Configuration.php:116
560 rows browsed
14.935 ms 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)
in /var/www/comprasuniversitarias/public_html/classes/Configuration.php:116
560 rows browsed
10.302 ms 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 = 2 LEFT JOIN `ps_country_shop` `c` ON a.id_country = c.id_country AND c.id_shop = 1 WHERE (a.id_country = 58) LIMIT 1
in /var/www/comprasuniversitarias/public_html/classes/ObjectModel.php:212
1 row browsed
2.123 ms SELECT SQL_NO_CACHE * FROM `ps_hook_alias`
in /var/www/comprasuniversitarias/public_html/classes/Hook.php:142
86 rows browsed
1.841 ms SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (SELECT COUNT(*) FROM `ps_module_shop` ms WHERE m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1) as total FROM `ps_module` m
in /var/www/comprasuniversitarias/public_html/classes/module/Module.php:163
89 rows browsed
1.435 ms 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` = 2) ORDER BY t.`position` ASC
in /var/www/comprasuniversitarias/public_html/classes/Tab.php:230
USING FILESORT - 105 rows browsed
1.306 ms SELECT SQL_NO_CACHE id_tab, class_name FROM `ps_tab`
in /var/www/comprasuniversitarias/public_html/classes/Tab.php:260
105 rows browsed
1.062 ms SELECT SQL_NO_CACHE * FROM `ps_tab` a WHERE (a.id_tab = 6) LIMIT 1
in /var/www/comprasuniversitarias/public_html/classes/ObjectModel.php:212
1 row browsed
0.96 ms 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
in /var/www/comprasuniversitarias/public_html/classes/shop/Shop.php:602
USING FILESORT - 1 row browsed
0.867 ms SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `ps_lang` l INNER 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
in /var/www/comprasuniversitarias/public_html/classes/Language.php:774
4 rows browsed
0.852 ms 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 = '192.241.165.63' OR su.domain_ssl = '192.241.165.63') AND s.active = 1 AND s.deleted = 0 ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
in /var/www/comprasuniversitarias/public_html/classes/shop/Shop.php:317
USING FILESORT - 1 row browsed
0.816 ms SELECT SQL_NO_CACHE t.`class_name`, t.`module` FROM `ps_tab` t WHERE t.`module` IS NOT NULL AND t.`module` != ""
in /var/www/comprasuniversitarias/public_html/classes/Tab.php:206
105 rows browsed
0.749 ms SELECT SQL_NO_CACHE * FROM `ps_quick_access` qa LEFT JOIN `ps_quick_access_lang` qal ON (qa.`id_quick_access` = qal.`id_quick_access` AND qal.`id_lang` = 2) ORDER BY `name` ASC
in /var/www/comprasuniversitarias/public_html/classes/QuickAccess.php:65
USING FILESORT - 5 rows browsed
0.655 ms 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)
in /var/www/comprasuniversitarias/public_html/classes/Language.php:670
2 rows browsed
0.642 ms SELECT SQL_NO_CACHE * FROM `ps_shop` a WHERE (a.id_shop = 1) LIMIT 1
in /var/www/comprasuniversitarias/public_html/classes/ObjectModel.php:212
1 row browsed
0.628 ms SELECT SQL_NO_CACHE domain FROM ps_shop_url WHERE main=1 AND id_shop = 1 LIMIT 1
in /var/www/comprasuniversitarias/public_html/classes/shop/ShopUrl.php:151
1 row browsed
0.627 ms SELECT SQL_NO_CACHE * FROM `ps_access` a LEFT JOIN `ps_tab` t ON t.id_tab = a.id_tab WHERE `id_profile` = 0
in /var/www/comprasuniversitarias/public_html/classes/Profile.php:143
1 row browsed
0.461 ms 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
in /var/www/comprasuniversitarias/public_html/classes/ObjectModel.php:212
1 row browsed
0.457 ms 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
in /var/www/comprasuniversitarias/public_html/classes/shop/Shop.php:200
1 row browsed
0.42 ms SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions` WHERE `id_shop` IN (1)
in /var/www/comprasuniversitarias/public_html/classes/module/Module.php:1507
1 row browsed
0.391 ms SELECT SQL_NO_CACHE `id_parent` FROM `ps_tab` WHERE LOWER(class_name) = 'adminlogin' LIMIT 1
in /var/www/comprasuniversitarias/public_html/classes/Tab.php:171
105 rows browsed
0.374 ms SELECT SQL_NO_CACHE `id_hook` FROM `ps_hook` WHERE `name` = 'displayBackOfficeTop' OR `name` = 'backofficetop' LIMIT 1
in /var/www/comprasuniversitarias/public_html/classes/Hook.php:125
2 rows browsed
0.369 ms 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 = 2) LIMIT 1
in /var/www/comprasuniversitarias/public_html/classes/ObjectModel.php:212
1 row browsed
0.329 ms SELECT SQL_NO_CACHE module FROM ps_tab_module_preference WHERE `id_tab` = 6 AND `id_employee` = 0
in /var/www/comprasuniversitarias/public_html/classes/Tab.php:518
1 row browsed
0.298 ms SELECT SQL_NO_CACHE * FROM `ps_tab_lang` WHERE `id_tab` = 6
in /var/www/comprasuniversitarias/public_html/classes/ObjectModel.php:219
2 rows browsed
0.282 ms SELECT SQL_NO_CACHE `id_parent` FROM `ps_tab` WHERE LOWER(class_name) = 'adminlogin' LIMIT 1
in /var/www/comprasuniversitarias/public_html/classes/Tab.php:171
105 rows browsed
0.281 ms SELECT SQL_NO_CACHE domain_ssl FROM ps_shop_url WHERE main = 1 AND id_shop=1 LIMIT 1
in /var/www/comprasuniversitarias/public_html/classes/shop/ShopUrl.php:163
1 row browsed
0.261 ms SELECT SQL_NO_CACHE id_required_field, object_name, field_name FROM ps_required_field
in /var/www/comprasuniversitarias/public_html/classes/ObjectModel.php:1143
8 rows browsed
Doubles (IDs replaced by "XX") (total = 27)

2 SELECT 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)
2 SELECT `id_parent` FROM `ps_tab` WHERE LOWER(class_name) = 'adminlogin' LIMIT XX
1 SELECT * FROM `ps_access` a LEFT JOIN `ps_tab` t ON t.id_tab = a.id_tab WHERE `id_profile` = XX
1 SELECT * FROM `ps_currency` a LEFT JOIN `ps_currency_shop` `c` ON a.id_currency = c.id_currency AND c.id_shop = XX WHERE (a.id_currency = XX) LIMIT XX
1 SELECT t.`class_name`, t.`module` FROM `ps_tab` t WHERE t.`module` IS NOT NULL AND t.`module` != ""
1 SELECT * FROM `ps_tab_lang` WHERE `id_tab` = XX
1 SELECT `id_hook` FROM `ps_hook` WHERE `name` = 'displayBackOfficeTop' OR `name` = 'backofficetop' LIMIT XX
1 SELECT * FROM `ps_tab` a WHERE (a.id_tab = XX) LIMIT XX
1 SELECT * FROM `ps_hook_module_exceptions` WHERE `id_shop` IN (XX)
1 SELECT module FROM ps_tab_module_preference WHERE `id_tab` = XX AND `id_employee` = XX
1 SELECT * FROM `ps_tab` t LEFT JOIN `ps_tab_lang` tl ON (t.`id_tab` = tl.`id_tab` AND tl.`id_lang` = XX) ORDER BY t.`position` ASC
1 SELECT * FROM `ps_quick_access` qa LEFT JOIN `ps_quick_access_lang` qal ON (qa.`id_quick_access` = qal.`id_quick_access` AND qal.`id_lang` = XX) ORDER BY `name` ASC
1 SELECT id_tab, class_name FROM `ps_tab`
1 SELECT m.`id_module`, m.`name`, (SELECT COUNT(*) FROM `ps_module_shop` ms WHERE m.`id_module` = ms.`id_module` AND ms.`id_shop` = XX) as total FROM `ps_module` m
1 SELECT * FROM `ps_hook_alias`
1 SELECT l.*, ls.`id_shop` FROM `ps_lang` l LEFT JOIN `ps_lang_shop` ls ON (l.id_lang = ls.id_lang)
1 SELECT * FROM `ps_country` a LEFT JOIN `ps_country_lang` `b` ON a.id_country = b.id_country AND b.id_lang = XX LEFT JOIN `ps_country_shop` `c` ON a.id_country = c.id_country AND c.id_shop = XX WHERE (a.id_country = XX) LIMIT XX
1 SELECT 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 = XX AND s.active = XX AND s.deleted = XX AND su.main = XX LIMIT XX
1 SELECT id_required_field, object_name, field_name FROM ps_required_field
1 SELECT * FROM `ps_shop` a WHERE (a.id_shop = XX) LIMIT XX
1 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
1 SELECT * FROM `ps_lang` a LEFT JOIN `ps_lang_shop` `c` ON a.id_lang = c.id_lang AND c.id_shop = XX WHERE (a.id_lang = XX) LIMIT XX
1 SELECT 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 ((SELECT COUNT(*) FROM ps_module_shop ms WHERE ms.id_module = m.id_module AND ms.id_shop IN (XX)) = XX) AND (h.name != "displayPayment") AND (hm.id_shop = XX) ORDER BY hm.`position`
1 SELECT COUNT(DISTINCT l.id_lang) FROM `ps_lang` l INNER JOIN ps_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = XX) WHERE l.`active` = XX LIMIT XX
1 SELECT domain_ssl FROM ps_shop_url WHERE main = XX AND id_shop=XX LIMIT XX
1 SELECT domain FROM ps_shop_url WHERE main=XX AND id_shop = XX LIMIT XX
1 SELECT 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 = 'XX.XX.XX.XX' OR su.domain_ssl = 'XX.XX.XX.XX') AND s.active = XX AND s.deleted = XX ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
Tables stress

7 tab
5 shop_url
4 shop
3 lang_shop
3 lang
2 module_shop
2 tab_lang
2 hook
2 module
2 configuration
2 configuration_lang
1 currency_shop
1 currency
1 hook_module_exceptions
1 quick_access
1 tab_module_preference
1 quick_access_lang
1 access
1 country_shop
1 hook_module
1 country
1 theme
1 required_field
1 country_lang
1 hook_alias
1 shop_group
ObjectModel instances

1 Tab
1 Currency
1 Language
1 Employee
1 Country
1 Shop
Included files

1 admin135/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/Autoload.php
8 cache/class_index.php
9 tools/profiling/Controller.php
10 classes/controller/Controller.php
11 tools/profiling/ObjectModel.php
12 classes/ObjectModel.php
13 tools/profiling/Hook.php
14 classes/Hook.php
15 tools/profiling/Db.php
16 classes/db/Db.php
17 tools/profiling/Tools.php
18 classes/Tools.php
19 classes/Context.php
20 classes/shop/Shop.php
21 classes/db/DbPDO.php
22 classes/Configuration.php
23 classes/cache/Cache.php
24 classes/Validate.php
25 classes/db/DbQuery.php
26 config/defines_uri.inc.php
27 classes/Language.php
28 classes/Country.php
29 classes/Collection.php
30 classes/Cookie.php
31 classes/Rijndael.php
32 classes/Employee.php
33 classes/Link.php
34 classes/shop/ShopUrl.php
35 config/smarty.config.inc.php
36 tools/smarty/Smarty.class.php
37 tools/smarty/sysplugins/smarty_internal_data.php
38 tools/smarty/sysplugins/smarty_internal_templatebase.php
39 tools/smarty/sysplugins/smarty_internal_template.php
40 tools/smarty/sysplugins/smarty_resource.php
41 tools/smarty/sysplugins/smarty_internal_resource_file.php
42 tools/smarty/sysplugins/smarty_cacheresource.php
43 tools/smarty/sysplugins/smarty_internal_cacheresource_file.php
44 config/smartyadmin.config.inc.php
45 admin135/functions.php
46 ./images.inc.php
47 classes/Dispatcher.php
48 classes/Tab.php
49 controllers/admin/AdminLoginController.php
50 classes/controller/AdminController.php
51 classes/Translate.php
52 translations/br/admin.php
53 classes/Profile.php
54 classes/Currency.php
55 classes/module/Module.php
56 modules/jirafe/jirafe.php
57 modules/jirafe/jirafe15.php
58 modules/jirafe/vendor/jirafe-php-client/src/Jirafe/Autoloader.php
59 themes/TemaA/modules/jirafe/translations/br.php
60 modules/jirafe/vendor/jirafe-php-client/src/Jirafe/Platform/Prestashop15.php
61 modules/jirafe/vendor/jirafe-php-client/src/Jirafe/Platform/Prestashop14.php
62 modules/jirafe/vendor/jirafe-php-client/src/Jirafe/Platform/Ecommerce.php
63 modules/jirafe/vendor/jirafe-php-client/src/Jirafe/Platform/Interface.php
64 classes/Media.php
65 classes/QuickAccess.php
66 cache/smarty/compile/70/1e/d3/701ed3baa01947984da9a07c71deacbef4209d23.file.content.tpl.php
67 tools/smarty/plugins/modifier.escape.php
68 tools/smarty/plugins/modifier.date_format.php
69 tools/smarty/plugins/shared.make_timestamp.php
70 cache/smarty/compile/bc/6b/22/bc6b22c2960f7b56cc7ec0ab1fd64f272fe4514b.file.layout.tpl.php
71 cache/smarty/compile/63/88/af/6388af606ecd0e786eb25cd764e695632d5d7d3d.file.header.tpl.php
72 cache/smarty/compile/39/1f/58/391f58cc9995dee8e04271a723dfca0864821d1d.file.footer.tpl.php

SETTINGS.INC.PHP:

 

<?php
define('_DB_SERVER_', 'localhost');
define('_DB_NAME_', 'X');
define('_DB_USER_', 'Y');
define('_DB_PASSWD_', 'Z');
define('_DB_PREFIX_', 'ps_');
define('_MYSQL_ENGINE_', 'InnoDB');
define('_PS_CACHING_SYSTEM_', 'MCached'); #Error here?
define('_PS_CACHE_ENABLED_', '0');        #Error here?
define('_MEDIA_SERVER_1_', '');
define('_MEDIA_SERVER_2_', '');
define('_MEDIA_SERVER_3_', '');
define('_COOKIE_KEY_', 't8jZOnm4h5oFy13DPAbXQozf1n29O0Id2W4uxyH4VnbejEBefi2f3mqv');
define('_COOKIE_IV_', 'MStHV9DU');
define('_PS_CREATION_DATE_', '2013-05-15');
define('_PS_VERSION_', '1.5.4.1');
define('_RIJNDAEL_KEY_', 'wAunF9Dwvyfc0pKfUxyK5PYf0BTAVTkt');
define('_RIJNDAEL_IV_', 'ipl4KyWiXpHi0PKnPYrs5w==');
Edited by [email protected] (see edit history)
Link to comment
Share on other sites
 Share
Go to topic listing
×
×
  • Create New...