Search the Community
Showing results for tags 'huge'.
-
Hi everyone! I will get straight to the point, I have a .csv file of thousands of articles and stuff and when I tried importing it myself I basically didn't get far over a long period of time. The csv formats articles into following rows: ID;name;price;stock;category;name_of_the_file_for_the_picture;width;height;measurement_unit;manufacturer;alternative_IDs_of_manufacturer_weight The problems I faced were: - There's a bunch of categories and I will probably have to manually create them because one goes into another one and It's just way too complicated. - A bunch of errors regarding the validation of strings for example the name of the article can have special characters therefor It just didn't work with them - I basically haven't done it before and I'd be very glad if someone would guide me through it in the comment section below. I am just getting into prestashop but I have been on the web dev market for quite a while. In hopes of solving the problem, thank you for taking your time to read this. - a newbie
-
When trying to click the products page, it wont load I'm just getting the classic memory limit error at 264mb, So I increased the memory limit to 512mb, and the new error comes at 536mb Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 256 bytes) in /var/www/vhosts/mylaggywebsite/httpdocs/classes/db/DbPDO.php on line 103 My the webhost ofcourse prevents going any higher than that. So that is a HUGE/MAJOR problem meaning the site is useless, since products cannot be added/deleted/modifyed anymore. The categories is a database designed on a OCcommerce platform running only 128mb, and then migrated to Prestashop running 256mb default. The front office works fine, categories and existing products show as they should, and running it all in a development inviroment it can work both BO and FO. The category database is about cars and are actually buildt up in this syntax Brand>model>Engine Size>Year><---multiple subcategories here for spareparts--> I'm confident the problem with the backoffice product page NOT loading even though it should only load 50 products at a time, it tries to load ALL categories and ALL products at once. Which ofcourse is just a design/coding flaw. Does anyone have any suggestions on how to sort this problem, or just make a workaround to actually make the products page work, so it would be possible to edit products ?
- 2 replies
-
- category
- backoffice
- (and 4 more)
-
Hi, Server information Prestashop version: 1.4.6.2 > friendly URL enabled Server information: Linux #1 SMP Wed Jul 20 19:47:12 MSD 2011 x86_64 Server software version: Apache/2.2.21 (Unix) mod_ssl/2.2.21 OpenSSL/0.9.8e-fips-rhel5 DAV/2 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 PHP version: 5.2.17 MySQL version: 5.1.56 In Phpmyadmin some table sizes: ps_product_lang: 183 Mb / Rows:213,519 ps_search_index: 143 Mb / Rows:3,205,165 ps_product_tag: 71 MB / Rows:610,164 ps_search_word: 64 MB / Rows:665,284 ps_category_product: 18 Mb / Rows:186,405 ps_product: 15 Mb / Rows:37,352 For instance, ps_product_lang: in Prestashop I activated two languages in back office. Others disabled. 37.000 products published in one language. As you see, the table size 183 Mb. and runs 213,519 rows. ps_search_index, table 143 Mb and have more than 3 million rows I think in e-commerce, 37.000 product is not a big number for Prestashop. But website working too slow, giving 500 internal server errors (mostly importing .csv), Server Overload, cpu has been maxed out, reached 100% of the memory errors... They occured maybe because of these table sizes, cache sizes ... Do you think these table sizes normal? Could someone inform me whats wrong about these tables? Regards Aybars Note:In my website Prestashop collecting everything.Sample; my tools/smarty/cache folder 8.7 Gb. After cleaning up, a few days later its again 8,9,10 ... gigabyte. ((( (Force compile: No / Cache: Yes / Use cache: No)
- 7 replies
-
- ps_product_lang
- ps_search_index
- (and 8 more)