Jump to content

vietnam

Members
  • Posts

    188
  • Joined

  • Last visited

Everything posted by vietnam

  1. I have the same issue and i would want to optimize to have it loading in less then 3-5 seconds I have a loooot of SQL request, but i don`t know what i can do about it. And also initContent takes a lot to process, but i don`t know how can i help making it better. initContent: 8.57s The only thing is to disable Advanced Top Menu because i see that is making 20 duble SQL request, but i paid some money for it and i consider it usefull. Load time: 9.631s You'd better run your shop on a toaster config: 550ms constructor: 0ms init: 74ms checkAccess: 0ms setMedia: 1ms postProcess: 0ms initHeader: 0ms initContent: 8.57s initFooter: 136ms display: 299ms Hook processing: 8.264s / 18.07 Mb displayTop: 5.224s / 3.77 Mb displayFooterProduct: 1.633s / 0.93 Mb displayLeftColumn: 586ms / 1.21 Mb displayRightColumn: 296ms / 1.59 Mb displayHeader: 191ms / 7.89 Mb displayFooter: 136ms / 0.54 Mb moduleRoutes: 96ms / 1.12 Mb displayMyAccountBlock: 48ms / 0.89 Mb actionProductOutOfStock: 43ms / 0 Mb displayLeftColumnProduct: 11ms / 0.12 Mb actionDispatcher: 0ms / 0 Mb displayRightColumnProduct: 0ms / 0 Mb actionFrontControllerSetMedia: 0ms / 0 Mb displayProductButtons: 0ms / 0 Mb DisplayOverrideTemplate: 0ms / 0 Mb displayProductTab: 0ms / 0 Mb displayProductTabContent: 0ms / 0 Mb Memory peak usage: 39.38 Mb config: 11.5 Mb constructor: 0 Mb init: 7.18 Mb checkAccess: 0 Mb setMedia: 0 Mb postProcess: 0 Mb initHeader: 0.01 Mb initContent: 16.13 Mb initFooter: 0.56 Mb display: 2.34 Mb Total cache size (in Cache class): 1.18 Mb DB type: DbPDO SQL Queries: 463 queries Time spent querying: 415ms Included files: 194 Size of included files: 2.53 Mb Globals (> 1 Ko only): 264 Ko _MODULES ≈ 191.5 Ko HTTP_SERVER_VARS ≈ 13.8 Ko _SERVER ≈ 13.8 Ko HTTP_ENV_VARS ≈ 13 Ko _ENV ≈ 13 Ko _REQUEST ≈ 3.9 Ko _COOKIE ≈ 3.9 Ko HTTP_COOKIE_VARS ≈ 3.9 Ko _MODULE ≈ 2.4 Ko Doubles (IDs replaced by "XX") (total = 140) 133 SELECT * FROM `ps_category` a LEFT JOIN `ps_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = XX LEFT JOIN `ps_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = XX WHERE (a.id_category = XX) AND (b.id_shop = XX) LIMIT XX 47 SELECT ate.*, atel.*, cl.link_rewrite, cl.meta_title, cal.link_rewrite as category_link_rewrite, cal.name as category_name, m.name as manufacturer_name, s.name as supplier_name FROM `ps_pm_advancedtopmenu_elements` ate LEFT JOIN `ps_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = XX) LEFT JOIN ps_cms c ON (c.id_cms = ate.`id_cms`) LEFT JOIN ps_cms_shop cms_shop ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = XX) LEFT JOIN ps_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = XX) LEFT JOIN ps_category ca ON (ca.id_category = ate.`id_category`) LEFT JOIN ps_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = XX AND cal.id_shop = XX ) LEFT JOIN `ps_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`) LEFT JOIN ps_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = XX) LEFT JOIN `ps_supplier` s ON (ate.`id_supplier` = s.`id_supplier`) LEFT JOIN ps_supplier_shop supplier_shop ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = XX) WHERE ate.`active` = XX AND ate.`id_column` = XX AND ((ate.`id_manufacturer` = XX AND ate.`id_supplier` = XX AND ate.`id_category` = XX AND ate.`id_cms` = XX) OR c.id_cms IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL) AND (cms_shop.`id_shop` = XX OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = XX OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = XX OR supplier_shop.`id_shop` IS NULL) ORDER BY ate.`position` 20 SELECT atmc.*, atmcl.*, cl.link_rewrite, cl.meta_title, cal.link_rewrite as category_link_rewrite, cal.name as category_name, m.name as manufacturer_name, s.name as supplier_name FROM `ps_pm_advancedtopmenu_columns` atmc LEFT JOIN `ps_pm_advancedtopmenu_columns_lang` atmcl ON (atmc.`id_column` = atmcl.`id_column` AND atmcl.`id_lang` = XX) LEFT JOIN ps_cms c ON (c.id_cms = atmc.`id_cms`) LEFT JOIN ps_cms_shop cms_shop ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = XX) LEFT JOIN ps_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = XX) LEFT JOIN ps_category ca ON (ca.id_category = atmc.`id_category`) LEFT JOIN ps_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = XX AND cal.id_shop = XX ) LEFT JOIN `ps_manufacturer` m ON (atmc.`id_manufacturer` = m.`id_manufacturer`) LEFT JOIN ps_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = XX) LEFT JOIN `ps_supplier` s ON (atmc.`id_supplier` = s.`id_supplier`) LEFT JOIN ps_supplier_shop supplier_shop ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = XX) WHERE atmc.`active` = XX AND atmc.`id_wrap` = XX AND ((atmc.`id_manufacturer` = XX AND atmc.`id_supplier` = XX AND atmc.`id_category` = XX AND atmc.`id_cms` = XX) OR c.id_cms IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL) ORDER BY atmc.`position` 15 SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX 15 SELECT product_shop.`price`, product_shop.`ecotax`, product_attribute_shop.id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `ps_product` p INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX) LEFT JOIN `ps_product_attribute` `pa` ON pa.`id_product` = p.`id_product` LEFT 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 = XX) WHERE (p.`id_product` = XX) 15 SELECT * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.id_product = b.id_product AND b.id_lang = XX LEFT JOIN `ps_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = XX WHERE (a.id_product = XX) AND (b.id_shop = XX) LIMIT XX 15 SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX 15 SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) LIMIT XX 14 SELECT name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = XX) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = XX) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = XX) WHERE pf.id_product = XX ORDER BY f.position ASC 12 SELECT * FROM `ps_manufacturer` a LEFT JOIN `ps_manufacturer_lang` `b` ON a.id_manufacturer = b.id_manufacturer AND b.id_lang = XX LEFT JOIN `ps_manufacturer_shop` `c` ON a.id_manufacturer = c.id_manufacturer AND c.id_shop = XX WHERE (a.id_manufacturer = XX) LIMIT XX 8 SELECT atmcw.*, atmcwl.* FROM `ps_pm_advancedtopmenu_columns_wrap` atmcw LEFT JOIN `ps_pm_advancedtopmenu_columns_wrap_lang` atmcwl ON (atmcw.`id_wrap` = atmcwl.`id_wrap` AND atmcwl.`id_lang` = XX) WHERE atmcw.`active` = XX AND atmcw.`id_menu` = XX ORDER BY atmcw.`position` Tables stress 213 category_lang 206 category 136 category_shop 85 manufacturer 81 manufacturer_shop 69 supplier 68 cms_lang 68 cms 68 cms_shop 68 supplier_shop 55 product_shop 47 pm_advancedtopmenu_elements_lang 47 pm_advancedtopmenu_elements 41 product 23 stock_available 23 product_attribute 23 product_lang 22 product_attribute_shop 20 pm_advancedtopmenu_columns 20 pm_advancedtopmenu_columns_lang 16 feature_product 16 hook 15 product_group_reduction_cache 14 feature_lang 14 feature 14 feature_value_lang 13 manufacturer_lang ObjectModel instances 137 Category 48 Product classes/Link.php [101] controllers/front/ProductController.php [82] modules/feeder/feeder.php [68] modules/pm_advancedtopmenu/pm_advancedtopmenu.php [1652] classes/Cart.php [1688] classes/Link.php [99] modules/productscategory/productscategory.php [104] classes/Link.php [101] classes/Link.php [101] classes/Link.php [101] classes/Link.php [101] classes/Link.php [101] classes/Link.php [101] classes/Link.php [101] classes/Link.php [101] classes/Link.php [101] classes/Link.php [101] classes/Link.php [101] classes/Link.php [101] classes/Link.php [101] classes/Link.php [101] classes/Link.php [101] classes/Link.php [101] classes/Link.php [101] classes/Link.php [101] classes/Link.php [101] classes/Link.php [101] classes/Link.php [101] classes/Link.php [101] classes/Link.php [101] classes/Link.php [101] classes/Link.php [101] classes/Link.php [101] classes/Link.php [101] classes/Link.php [101] classes/Link.php [101] classes/Link.php [101] classes/Link.php [101] classes/Link.php [101] classes/Link.php [101] classes/Link.php [101] classes/Link.php [101] classes/Link.php [101] classes/Link.php [101] classes/Link.php [101] classes/Link.php [101] classes/Link.php [101] modules/sendtoafriend/sendtoafriend.php [67] 21 Manufacturer 15 Carrier 10 Address 4 GroupCore 3 Shop 3 Country 2 Customer 2 Language 2 ShopGroup 1 Warehouse 1 Tax 1 Currency 1 Cart
  2. I also subscribe. 4000 products, and 230 categories and the website is like not moving at all.
  3. It takes about 10 seconds to load a page and i don`t know what to do. This is with memcache activated, CCC activated, everything. i have made a second install on the shared hosting that i have and i am dubbuing, but i don`t really understand what can i do to make it load more fast What does initContent: 7.414s , this seems one of the slow things happening there Also there are SQL Queries: 529 queries , wich i imagine is too much. I attached the file with the profiling for the website Load time: 8.04s You'd better run your shop on a toaster config: 409ms constructor: 0ms init: 44ms checkAccess: 0ms setMedia: 0ms postProcess: 0ms initHeader: 0ms initContent: 7.414s initFooter: 101ms display: 70ms Hook processing: 7.585s / 20.83 Mb displayTop: 3.058s / 4.94 Mb actionProductListOverride: 2.286s / 1.4 Mb displayHeader: 1.575s / 8.31 Mb displayRightColumn: 377ms / 1.6 Mb displayFooter: 101ms / 0.56 Mb moduleRoutes: 97ms / 1.13 Mb displayLeftColumn: 83ms / 2 Mb displayMyAccountBlock: 8ms / 0.89 Mb DisplayOverrideTemplate: 0ms / 0 Mb actionDispatcher: 0ms / 0 Mb actionFrontControllerSetMedia: 0ms / 0 Mb Memory peak usage: 40.04 Mb config: 11.24 Mb constructor: 0 Mb init: 4.99 Mb checkAccess: 0 Mb setMedia: 0 Mb postProcess: 0 Mb initHeader: 0.01 Mb initContent: 19.22 Mb initFooter: 0.58 Mb display: 1.62 Mb Total cache size (in Cache class): 1.27 Mb DB type: DbPDO SQL Queries: 529 queries Time spent querying: 415ms Included files: 193 Size of included files: 2.5 Mb Globals (> 1 Ko only): 275 Ko _MODULES ≈ 207.6 Ko _SERVER ≈ 12.8 Ko HTTP_SERVER_VARS ≈ 12.7 Ko HTTP_ENV_VARS ≈ 12 Ko _ENV ≈ 12 Ko _REQUEST ≈ 3.6 Ko _COOKIE ≈ 3.6 Ko HTTP_COOKIE_VARS ≈ 3.6 Ko _MODULE ≈ 2.4 Ko slow report.zip
  4. Eu am la cei de la gazduire.ro si este foarte ok. Siteul merge putin cam greu, dar de ce imi place de ei : La suport tehnic ii gasesc tot timpul pe live chat ca sa ii "bat" la cap cu problemele mele . Am un shared hosting si tot timpul mai am nevoie de niste mici modificari ca sa il fac sa mearga.
  5. Iar ultima arhiva nu merge http://www.prestashop.com/download/lang_packs/gzip/1.5.3.1/ro.gzip
  6. Si eu caut acelasi lucru, am inceput sa editez manual dar sunt peste vreo 1000 de campuri, iar sa facem cu totii aceiasi munca nu este atat de sustenabil.
  7. Prestashop 1.5.4 RC will adress the fact that is impossible to import products ? http://www.prestashop.com/forums/topic/231737-impossible-to-import-products-in-prestashop-15/
  8. Damien Metzger Feb 13 to me Hello, I checked it out and I can indeed reproduce your issue, but there is nothing in the error log. I need to investigate further. Regards, Damien Metzger Directeur Technique This was one month ago ... Ulisses Ramos is waiting for 6 months . Loic Lefevre investigated a little 6 months ago into this bug http://forge.prestas...owse/PSCFV-4286 and them nothing happened. At least say that is impossible to fix and then i know that i have to search for other alternatives because i will never be able to use prestashop.
  9. I tried just to see how it`s it. The theme works to install, there are some stuff that dont look good because it`s for 1.4.9 but overall it`s working ok the theme
  10. For over 30 hours i tried to upgrade to 1.5. The most common errors. I upgrade, and then when i log in the back office, all the menus are open and nothing`s works. My Solution - Download prestashop 1.5.0.17 and copy all the files from admin to the website, something is wrong there and not all files are copied. I tried the other variant, with Fresh install. Install ok, imposible to bring the products, categories, features, aliases, etc to the new version. I tried with the upgraded version database, that i got from upgrading, i save the backup and tried to import : 1. Full database import - Fails 2. Bits of database import - Fails. They are very interconnected, impossible to figure it what it`s connected to what. If you import only ps_category ps_category_lang ps_category_group And the 2 others it will not work CVS import did not work, importing like stupid and not holding the corect ID per product that was written on the CVS file. : Example of product 00002155 On the products page, i see only html code, the jquery tmy editor or what WYSIWYG it`s not working The left tabs on the Product page are not working. I tried to click images, atributes, no tab it`s working, tries to load, and then get me back on the same page. Thanks prestashop team, you did a really amazing product with Prestashop 1.5 , but it`s only good for people that want to start a new online shop. The upgrade process it`s simply impossible.
  11. I tried to do it logically,and selected what i think are correlated. You can see on the attachments what i exported. What is working to import: Customer Service Groups Manufactures Suppliers currencies price ranges weight ranges What is not working and i get a white page : Addresses tab Products ! Categories ! Half working Shopping Carts :Load page,but all shopping carts are 0 $ and no products Orders : all orders, but when i click and go inside, no css carriers - no carrier imported shipping - no shipping method features - no features displayed atributes and something - no atributes displayed what i selected.zip
  12. And this is not something new, it`s happening every time a new version comes out. STEP 1 : Try to upgrade, normally, and fails, something is wrong STEP 2 : Do a clean install and try to move you products - IMPOSSIBLE. Even STEP 3 Fails. I upgraded to 1.5.0.17, saved a backup, and performed a clean install. Then the only think is to drop everything and load the new database, right ? NO The back office is a white page And i try to normally upgrade, one column at a time, but it`s impossible too. If i export only ps_manufacturer ps_manufacturer_lang, and import, it loads correctly. But if i want to export ps_product and ps_product_lang it will not work, because they need also 4732 other tables, that i don`t have a clue what they need. And if i import all of them, i will have the white screen again. So why don`t you make a more simple export. Something like : EXPORT PRODUCTS and CATEGORY and PHOTOS AND MANUFACUTRER AND SUPLIER , and it will export only the 48 sql tables that are necessary for products to load correctly. It`s 2 AM Sunday and on Monday i will get fired if i will not find a solution, to fix this impossible puzzle Just separate the settings, modules, technical stuff from the simple stuff.
  13. After the upgrae, i reverted to 1.4.9 and now i get 500 Internal Server Error in back office or front office. I tried to search for a usefull error log but there is no one in the error log i only hav this [sat Sep 15 22:14:51 2012] [error] [client 86.120.148.157] File does not exist: /home/mobila/public_html/feronerie-mobilier.com/500.shtml
  14. It did not work for me. I had to copy via FTP the classes and cache folder. After that it worked
  15. I get this 2 errors Also i cannot acces in BO customers, some modules are not working, etc
  16. And now the frontoffice looks like this Warning: array_key_exists() [function.array-key-exists]: The first argument should be either a string or an integer in /home/mobila/public_html/feronerie-mobilier.com/classes/Currency.php on line 413 Line 413 says " public static function getCurrencyInstance($id) { if (!array_key_exists($id, self::$currencies)) self::$currencies[(int)($id)] = new Currency($id); return self::$currencies[(int)($id)]; } Fatal error: Cannot access empty property in /home/mobila/public_html/feronerie-mobilier.com/classes/controller/FrontController.php on line 300 line 300 says : "if ($cart->{Configuration::get('PS_TAX_ADDRESS_TYPE')})" And this is with the default theme Another thing is that Cannot acces customers When tring to see a customer http://www.feronerie-mobilier.com/admin3gs/index.php?controller=admincustomers&id_customer=187&viewcustomer&token=1a9c52062d87c8b920a56da42bafae6b i get
  17. I did the upgrade, and now i have this : FIXED It was because something happen and prestashop upgrader did not upgraded this files PrestaShop versiune originală: 18 files modifications has been detected, including 14 from core and native module: A se vedea sau a ascunde lista Core fişier (e) (14) cache/class_index.php classes/Tools.php config/defines.inc.php img/logo.jpg img/logo_stores.gif modules/themeinstallator/export/index.php modules/themeinstallator/import/index.php modules/themeinstallator/index.php modules/themeinstallator/themeinstallator.php override/classes/_Tools.php override/classes/index.php override/controllers/index.php override/index.php pdf/invoice.tpl
  18. I am afraid to install it because my theme it`s compatible with 1.4x and i will not spend another 70 euros for another theme http://addons.prestashop.com/en/high-tech/3287-electronics-prestashop-theme---prs020027.html
  19. I solved it. With a bit of reading from here http://dev.mysql.com/doc/refman/5.1/en/select.html i figure it out how to compare the 2 products. Now i will have to figure it how to exclude the disabled products (Solved) This is directly for ps_ If you have another database, you have to change ps_ with your database. (Solved that too ) So the code is like this This is working with 1.4.9
  20. I want to modify admintracking.php in a way that shows me the products that don`t have a image yet. I know how can i see all the products that have images, using this SQL statement : But the reverse is not possible I was thinking of something like "select products that are only in ps_product, and are not in ps_image" But i don`t know how can i do something like this. If you have a idea, please help me
  21. Theme PRS020027 it`s not working with SVN version of 1.5 ( ! ) Warning: layout.tpl is missing in your theme directory in C:\wamp\www\SVN1.5\classes\Tools.php on line 1680 Call Stack # Time Memory Function Location 1 0.0009 367464 {main}( ) ..\index.php:0 2 0.1657 6046904 DispatcherCore->dispatch( ) ..\index.php:29 3 0.2101 7752144 ControllerCore->run( ) ..\Dispatcher.php:348 4 0.7508 22279264 FrontControllerCore->display( ) ..\Controller.php:186 5 0.7512 22282352 ToolsCore::displayAsDeprecated( ) ..\FrontController.php:575 6 0.7512 22286816 trigger_error ( ) ..\Tools.php:1680 ( ! ) Fatal error: Uncaught exception 'SmartyException' with message 'Unable to load template file 'C:\wamp\www\SVN1.5/themes/PRS020027/header.tpl'' in C:\wamp\www\SVN1.5\tools\smarty\sysplugins\smarty_internal_templatebase.php on line127 ( ! ) SmartyException: Unable to load template file 'C:\wamp\www\SVN1.5/themes/PRS020027/header.tpl' in C:\wamp\www\SVN1.5\tools\smarty\sysplugins\smarty_internal_templatebase.php on line 127 Call Stack # Time Memory Function Location 1 0.0009 367464 {main}( ) ..\index.php:0 2 0.1657 6046904 DispatcherCore->dispatch( ) ..\index.php:29 3 0.2101 7752144 ControllerCore->run( ) ..\Dispatcher.php:348 4 0.7508 22279264 FrontControllerCore->display( ) ..\Controller.php:186 5 0.8524 22359208 Smarty_Internal_TemplateBase->display( ) ..\FrontController.php:577 6 0.8524 22359336 Smarty_Internal_TemplateBase->fetch( ) ..\smarty_internal_templatebase.php:37
  22. I need to make a lightweight version of Admin products I don`t need to lose 3 to 5 seconds to load a lot of unnecessary stuff. For example i will never change the Category`s because the categories are added when i import once a week the products. I don`t need to change the price, because is imported the same. I have attached a file with some of the unnecessary fileds, but i cannot figure it where can i remove the warning, because now when i try to save i get an error, because it tells me that i cannot have a product without a default category. And i don`t need to chenge the category, so i don`t need for him to load, and then save. I only need to add description, manufacturer, images and features to the products. The AdminProducts.pphp attached is for the latest prestashop 1.4.8.2 AdminProducts.php
  23. I`m not sure if this a good thing, like to have a page with 44000 internal links. What do you think
×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More