girlyscorpions@yahoo Posted March 15, 2014 Share Posted March 15, 2014 I am new to this and my issue is described but I can not make this work. I am trying to add a new product and the page comes up blank. I have finally figured out how to turn on the error reporting but when i just turn on the suggested error reporting, nothing comes up, I still get just a blank page. So after further research I went back and turned on all error reporting and got the information below. However, none of that means anything to me and I have no clue what is the issue... Can someone please take alook at the following and tell me why I can not add a new product please. It is: Load time: 971msI hope it is a shared hostingconfig: 389ms constructor: 0ms init: 159ms checkAccess: 0ms setMedia: 2ms postProcess: 58ms initHeader: 11ms initContent: 319ms initFooter: 0ms display: 33ms Hook processing: 118ms / 2.04 MbdisplayBackOfficeHeader: 93ms / 1.91 Mb moduleRoutes: 24ms / 0.13 Mb displayBackOfficeFooter: 0ms / 0 Mb actionDispatcher: 0ms / 0 Mb displayBackOfficeTop: 0ms / 0 Mb actionAdminControllerSetMedia: 0ms / 0 Mb Memory peak usage: 14.5 Mbconfig: 8.2 Mb (9.3 Mb) constructor: 0 Mb (9.3 Mb) init: 2.93 Mb (11.2 Mb) checkAccess: 0 Mb (11.2 Mb) setMedia: 0 Mb (11.2 Mb) postProcess: 0 Mb (11.2 Mb) initHeader: 0.3 Mb (11.5 Mb) initContent: 2.56 Mb (14.1 Mb) initFooter: 0 Mb (14.1 Mb) display: 0.27 Mb (14.5 Mb) Total cache size (in Cache class): 0.23 Mb DB type: DbPDOSQL Queries: 40 queriesTime spent querying: 101ms Included files: 91Size of included files: 2.1 Mb Globals (> 1 Ko only): 774 Ko_LANGADM ≈ 740.7 Ko _SERVER ≈ 6.7 Ko HTTP_SERVER_VARS ≈ 6.7 Ko HTTP_ENV_VARS ≈ 6.1 Ko _ENV ≈ 6.1 Ko HTTP_COOKIE_VARS ≈ 2.4 Ko _COOKIE ≈ 2.4 Ko Go to Stopwatch Go to Doubles Go to Tables Go to ObjectModels Display queries table Stopwatch (with SQL_NO_CACHE) (total = 40)11.312 ms SELECT SQL_NO_CACHE a.`id_ps_advice`, a.`selector`, a.`location`, al.`html` 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` = 21 AND ((a.`start_day` = 0 AND a.`stop_day` = 0) OR (15 >= a.`start_day` AND 15 <= a.`stop_day`)))in /hermes/bosoraweb061/b2493/ipg.bossesgallerycom/bossesgallery/modules/gamification/classes/Advice.php:962 rows browsed7.862 ms SELECT SQL_NO_CACHE `id_product_attribute` FROM `ps_product_attribute` WHERE `id_product` = 0in /hermes/bosoraweb061/b2493/ipg.bossesgallerycom/bossesgallery/classes/Product.php:19431 row browsed6.686 ms SELECT SQL_NO_CACHE module FROM ps_tab_module_preference WHERE `id_tab` = 21 AND `id_employee` = 1in /hermes/bosoraweb061/b2493/ipg.bossesgallerycom/bossesgallery/classes/Tab.php:5341 row browsed5.984 ms SELECT SQL_NO_CACHE id_shop FROM `ps_employee_shop` WHERE `id_employee` = 1in /hermes/bosoraweb061/b2493/ipg.bossesgallerycom/bossesgallery/classes/ObjectModel.php:12911 row browsed5.95 ms 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 1in /hermes/bosoraweb061/b2493/ipg.bossesgallerycom/bossesgallery/classes/Language.php:8051 row browsed5.242 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 = 1 LEFT JOIN `ps_country_shop` `c` ON a.id_country = c.id_country AND c.id_shop = 1 WHERE (a.id_country = 21) LIMIT 1in /hermes/bosoraweb061/b2493/ipg.bossesgallerycom/bossesgallery/classes/ObjectModel.php:2121 row browsed4.946 ms SELECT SQL_NO_CACHE t.`class_name`, t.`module` FROM `ps_tab` t WHERE t.`module` IS NOT NULL AND t.`module` != ""in /hermes/bosoraweb061/b2493/ipg.bossesgallerycom/bossesgallery/classes/Tab.php:222102 rows browsed4.208 ms SELECT SQL_NO_CACHE * FROM `ps_hook_alias`in /hermes/bosoraweb061/b2493/ipg.bossesgallerycom/bossesgallery/classes/Hook.php:18286 rows browsed3.9 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 = 'www.bossesgallery.com' OR su.domain_ssl = 'www.bossesgallery.com') AND s.active = 1 AND s.deleted = 0 ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESCin /hermes/bosoraweb061/b2493/ipg.bossesgallerycom/bossesgallery/classes/shop/Shop.php:320USING FILESORT - 1 row browsed3.712 ms SELECT SQL_NO_CACHE * FROM `ps_employee` a LEFT JOIN `ps_employee_shop` `c` ON a.id_employee = c.id_employee AND c.id_shop = 1 WHERE (a.id_employee = 1) LIMIT 1in /hermes/bosoraweb061/b2493/ipg.bossesgallerycom/bossesgallery/classes/ObjectModel.php:2121 row browsed3.347 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` = 1) ORDER BY t.`position` ASCin /hermes/bosoraweb061/b2493/ipg.bossesgallerycom/bossesgallery/classes/Tab.php:246USING FILESORT - 102 rows browsed3.246 ms SELECT SQL_NO_CACHE domain, domain_ssl FROM ps_shop_url WHERE main = 1 AND id_shop = 1 LIMIT 1in /hermes/bosoraweb061/b2493/ipg.bossesgallerycom/bossesgallery/classes/shop/ShopUrl.php:1541 row browsed2.718 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 /hermes/bosoraweb061/b2493/ipg.bossesgallerycom/bossesgallery/classes/Language.php:6981 row browsed2.642 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 /hermes/bosoraweb061/b2493/ipg.bossesgallerycom/bossesgallery/classes/Hook.php:339USING FILESORT - 67 rows browsed2.617 ms 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.namein /hermes/bosoraweb061/b2493/ipg.bossesgallerycom/bossesgallery/classes/Hook.php:1300 rows browsed2.572 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 /hermes/bosoraweb061/b2493/ipg.bossesgallerycom/bossesgallery/classes/Configuration.php:116402 rows browsed2.079 ms SELECT SQL_NO_CACHE id_tab, class_name FROM `ps_tab`in /hermes/bosoraweb061/b2493/ipg.bossesgallerycom/bossesgallery/classes/Tab.php:276102 rows browsed1.686 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 = 1) LIMIT 1in /hermes/bosoraweb061/b2493/ipg.bossesgallerycom/bossesgallery/classes/ObjectModel.php:2121 row browsed1.613 ms SELECT SQL_NO_CACHE `version` FROM `ps_module` WHERE `name` = 'gamification' LIMIT 1in /hermes/bosoraweb061/b2493/ipg.bossesgallerycom/bossesgallery/modules/gamification/gamification.php:1431 row browsed1.577 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` = 1) WHERE t.`id_tab` = 21 LIMIT 1in /hermes/bosoraweb061/b2493/ipg.bossesgallerycom/bossesgallery/classes/Tab.php:2031 row browsed1.472 ms SELECT SQL_NO_CACHE DISTINCT pl.name as name FROM `ps_product_lang` pl WHERE (pl.id_product = 0) AND (pl.id_lang = 1 AND pl.id_shop = 1 ) LIMIT 1in /hermes/bosoraweb061/b2493/ipg.bossesgallerycom/bossesgallery/classes/Product.php:51520 rows browsed1.446 ms SELECT SQL_NO_CACHE `id_employee` FROM `ps_employee` WHERE `id_employee` = 1 AND `passwd` = 'd8193ba2d1cbb96ea7fab360fd3d9ebe' AND active = 1 LIMIT 1in /hermes/bosoraweb061/b2493/ipg.bossesgallerycom/bossesgallery/classes/Employee.php:2231 row browsed1.347 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 1in /hermes/bosoraweb061/b2493/ipg.bossesgallerycom/bossesgallery/classes/ObjectModel.php:2121 row browsed1.051 ms 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` min /hermes/bosoraweb061/b2493/ipg.bossesgallerycom/bossesgallery/classes/module/Module.php:17167 rows browsed1.035 ms SELECT SQL_NO_CACHE COUNT(*) FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product` = 0 LIMIT 1in /hermes/bosoraweb061/b2493/ipg.bossesgallerycom/bossesgallery/classes/Product.php:19861 row browsed0.998 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` = 1) WHERE t.`id_tab` = 9 LIMIT 1in /hermes/bosoraweb061/b2493/ipg.bossesgallerycom/bossesgallery/classes/Tab.php:2031 row browsed0.922 ms SELECT SQL_NO_CACHE * FROM `ps_tab_lang` WHERE `id_tab` = 21in /hermes/bosoraweb061/b2493/ipg.bossesgallerycom/bossesgallery/classes/ObjectModel.php:2191 row browsed0.882 ms SELECT SQL_NO_CACHE * FROM `ps_shop_group` a WHERE (a.id_shop_group = 1) LIMIT 1in /hermes/bosoraweb061/b2493/ipg.bossesgallerycom/bossesgallery/classes/ObjectModel.php:2121 row browsed0.833 ms SELECT SQL_NO_CACHE * FROM `ps_image` i LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image`) WHERE i.`id_product` = 0 AND il.`id_lang` = 1 ORDER BY i.`position` ASCin /hermes/bosoraweb061/b2493/ipg.bossesgallerycom/bossesgallery/classes/Image.php:142USING FILESORT - 1 row browsed0.795 ms SELECT SQL_NO_CACHE * FROM `ps_image_type`WHERE 1 AND products = 1 ORDER BY `name` ASCin /hermes/bosoraweb061/b2493/ipg.bossesgallerycom/bossesgallery/classes/ImageType.php:101USING FILESORT - 8 rows browsed0.781 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.namein /hermes/bosoraweb061/b2493/ipg.bossesgallerycom/bossesgallery/classes/shop/Shop.php:622USING FILESORT - 1 row browsed0.772 ms SELECT SQL_NO_CACHE t.`id_lang`, t.`name` FROM ps_tag t LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag) WHERE pt.`id_product`=0in /hermes/bosoraweb061/b2493/ipg.bossesgallerycom/bossesgallery/classes/Tag.php:1611 row browsed0.76 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` = 1) ORDER BY `name` ASCin /hermes/bosoraweb061/b2493/ipg.bossesgallerycom/bossesgallery/classes/QuickAccess.php:65USING FILESORT - 5 rows browsed0.708 ms SELECT SQL_NO_CACHE * FROM `ps_country` a LEFT JOIN `ps_country_shop` `c` ON a.id_country = c.id_country AND c.id_shop = 1 WHERE (a.id_country = 21) LIMIT 1in /hermes/bosoraweb061/b2493/ipg.bossesgallerycom/bossesgallery/classes/ObjectModel.php:2121 row browsed0.667 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 1in /hermes/bosoraweb061/b2493/ipg.bossesgallerycom/bossesgallery/classes/shop/Shop.php:1991 row browsed0.655 ms SELECT SQL_NO_CACHE * FROM `ps_tab` a WHERE (a.id_tab = 21) LIMIT 1in /hermes/bosoraweb061/b2493/ipg.bossesgallerycom/bossesgallery/classes/ObjectModel.php:2121 row browsed0.566 ms SELECT SQL_NO_CACHE `id_parent` FROM `ps_tab` WHERE LOWER(class_name) = 'adminproducts' LIMIT 1in /hermes/bosoraweb061/b2493/ipg.bossesgallerycom/bossesgallery/classes/Tab.php:178102 rows browsed0.536 ms SELECT SQL_NO_CACHE * FROM `ps_shop` a WHERE (a.id_shop = 1) LIMIT 1in /hermes/bosoraweb061/b2493/ipg.bossesgallerycom/bossesgallery/classes/ObjectModel.php:2121 row browsed0.502 ms SELECT SQL_NO_CACHE * FROM `ps_country_lang` WHERE `id_country` = 21in /hermes/bosoraweb061/b2493/ipg.bossesgallerycom/bossesgallery/classes/ObjectModel.php:2191 row browsed0.38 ms SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions` WHERE `id_shop` IN (1)in /hermes/bosoraweb061/b2493/ipg.bossesgallerycom/bossesgallery/classes/module/Module.php:15711 row browsed Doubles (IDs replaced by "XX") (total = 1)2 SELECT * FROM `ps_tab` t LEFT JOIN `ps_tab_lang` tl ON (t.`id_tab` = tl.`id_tab` AND tl.`id_lang` = XX) WHERE t.`id_tab` = XX LIMIT XX Tables stress7 tab4 shop_url4 tab_lang4 shop3 hook3 module3 lang_shop3 lang2 product_attribute2 hook_alias2 module_shop2 shop_group2 country2 employee_shop2 country_shop2 country_lang2 employee1 product_attribute_shop1 tab_module_preference1 product_lang1 configuration_lang1 image_type1 product_tag1 tag1 quick_access_lang1 image_lang1 image1 advice_lang1 configuration1 theme1 hook_module1 currency1 currency_shop1 tab_advice1 advice1 hook_module_exceptions1 quick_access ObjectModel instances3 Country2 ShopGroup1 Product1 ProductDownload1 Category1 Tab1 Employee1 Language1 Shop1 Currency Included files1 admin5143/index.php2 config/config.inc.php3 config/defines.inc.php4 config/settings.inc.php5 config/autoload.php6 config/alias.php7 classes/Autoload.php8 cache/class_index.php9 tools/profiling/Controller.php10 classes/controller/Controller.php11 tools/profiling/ObjectModel.php12 classes/ObjectModel.php13 tools/profiling/Hook.php14 classes/Hook.php15 tools/profiling/Db.php16 classes/db/Db.php17 tools/profiling/Tools.php18 classes/Tools.php19 classes/Context.php20 classes/shop/Shop.php21 classes/db/DbPDO.php22 classes/cache/Cache.php23 classes/Validate.php24 classes/db/DbQuery.php25 config/defines_uri.inc.php26 classes/Configuration.php27 classes/Language.php28 classes/Country.php29 classes/Collection.php30 classes/Cookie.php31 classes/Rijndael.php32 classes/Employee.php33 classes/Link.php34 classes/shop/ShopUrl.php35 config/smarty.config.inc.php36 tools/smarty/Smarty.class.php37 tools/smarty/sysplugins/smarty_internal_data.php38 tools/smarty/sysplugins/smarty_internal_templatebase.php39 tools/smarty/sysplugins/smarty_internal_template.php40 tools/smarty/sysplugins/smarty_resource.php41 tools/smarty/sysplugins/smarty_internal_resource_file.php42 tools/smarty/sysplugins/smarty_cacheresource.php43 tools/smarty/sysplugins/smarty_internal_cacheresource_file.php44 config/smartyadmin.config.inc.php45 admin5143/functions.php46 ./images.inc.php47 classes/Dispatcher.php48 classes/Tab.php49 controllers/admin/AdminProductsController.php50 classes/controller/AdminController.php51 classes/Translate.php52 translations/en/admin.php53 classes/Profile.php54 classes/Currency.php55 classes/Category.php56 classes/stock/StockAvailable.php57 classes/shop/ShopGroup.php58 classes/module/Module.php59 modules/gamification/gamification.php60 modules/gamification/classes/Badge.php61 modules/gamification/classes/Advice.php62 modules/gamification/classes/Condition.php63 modules/gamification/classes/GamificationTools.php64 classes/Media.php65 modules/paypalusa/paypalusa.php66 classes/PaymentModule.php67 modules/paypalusa/backward_compatibility/backward.php68 modules/paypalusa/backward_compatibility/Display.php69 classes/controller/FrontController.php70 classes/QuickAccess.php71 classes/helper/Helper.php72 classes/Product.php73 classes/Combination.php74 classes/Pack.php75 classes/ProductDownload.php76 classes/Image.php77 classes/ImageType.php78 classes/Tag.php79 cache/smarty/compile/a2/4a/9e/a24a9ea83a7e4945899233e3ea06aa2163b7d7a9.file.informations.tpl.php80 tools/smarty/plugins/modifier.escape.php81 cache/smarty/compile/72/ab/81/72ab8179296dfe44c6552aaafb2dcdd7b3ce6930.file.check_fields.tpl.php82 cache/smarty/compile/22/3c/6f/223c6f7591334994cb8496f431ef2af07b0abb08.file.checkbox.tpl.php83 cache/smarty/compile/f0/1e/7f/f01e7f65082d0be4f0ff02e58ad9df7a390fa87c.file.textarea_lang.tpl.php84 tools/smarty/plugins/modifier.replace.php85 classes/helper/HelperForm.php86 cache/smarty/compile/08/1a/a3/081aa3a5121e18fe31c24221fe17432bfc0d723a.file.form.tpl.php87 cache/smarty/compile/f5/b9/75/f5b9754cf6185b734f692a0d27a9b49e8e2639ff.file.toolbar.tpl.php88 cache/smarty/compile/1d/ac/a9/1daca933cdfef8557105c93b7f06b4b1d8bb1e83.file.content.tpl.php89 cache/smarty/compile/3e/f0/79/3ef079539db6ce46da0365a75a3daa3dc3d6b229.file.layout.tpl.php90 cache/smarty/compile/92/37/92/92379266583794238c701e031308db5868953ec2.file.header.tpl.php91 cache/smarty/compile/38/ed/3d/38ed3d92478540c7dbe5fd3f9caf93d375934be0.file.footer.tpl.php Link to comment Share on other sites More sharing options...
vekia Posted March 15, 2014 Share Posted March 15, 2014 in fact this is not error report, this is profiling report and its not related to error reporting. have you got possiblity to check server php error log file? Link to comment Share on other sites More sharing options...
girlyscorpions@yahoo Posted March 16, 2014 Author Share Posted March 16, 2014 (edited) I'm not sure what you are asking. I read the other forums and found out I had to turn on error reporting by changing the file config/defines.inc.php. I finally found this file and changed the define('_PS_MODE_DEV_',false); to define('_PS_MODE_DEV_',true); I did this but got NO results, the page was still blank, nothing on it and no error reporting! So I did some more research and found another forum that told me to change the "false" to "true" on 2 more lines in this file. I did this and finally got something to show up, which is what I copied and pasted into this forum. I have no idea what this means and I really don't know what you are asking when you say "have you got possiblity to check server php error log file?" I checked the Logs section in prestashop but I found no other logs other than the ones about the few default categories/products that I deleted. This is all I have so far, what else should I try? Thank you in advance for helping me figure this out. Edited March 16, 2014 by girlyscorpions@yahoo (see edit history) Link to comment Share on other sites More sharing options...
Recommended Posts