jonmig Posted September 18, 2013 Share Posted September 18, 2013 (edited) hi guys Whilst setting up Prestashop v1.5.5 I've experienced this new error (sigh!) please can anybody assist in this latest dilemna Fatal error: Uncaught Out of memory (Needed 16777188 bytes)<br /><br /><pre> SELECT COUNT(DISTINCT l.id_lang) FROM `expresta_lang` l JOIN expresta_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1) WHERE l.`active` = 1 LIMIT 1</pre> thrown in /web1/user43131/website/classes/db/Db.php on line 613 cheers Mike Edited September 18, 2013 by jonmig (see edit history) Link to comment Share on other sites More sharing options...
Dh42 Posted September 18, 2013 Share Posted September 18, 2013 Your server has run out of memory. It seems to be set at only 16mb, I would suggest increasing it to 128mb, contact your host. They will know what to do. 1 Link to comment Share on other sites More sharing options...
PrestaHeroes USA Posted September 18, 2013 Share Posted September 18, 2013 I am pretty sure I have more memory on my watch than 16MB here is a nice tutorial on how to increase your php memory.... http://blog.dh42.com/speed-prestashop-php-ini/ 1 Link to comment Share on other sites More sharing options...
jonmig Posted September 18, 2013 Author Share Posted September 18, 2013 (edited) Fatal error: Uncaught Out of memory (Needed 16777188 bytes)<br /><br /><pre> SELECT COUNT(DISTINCT l.id_lang) FROM `expresta_lang` l JOIN expresta_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1) WHERE l.`active` = 1 LIMIT 1</pre> thrown in /web1/user43131/website/classes/db/Db.php on line 613 Edited September 18, 2013 by jonmig (see edit history) Link to comment Share on other sites More sharing options...
jonmig Posted September 18, 2013 Author Share Posted September 18, 2013 (edited) Thanks guys I have spoken with the tech dept of my hosting company and they have increased the memory to 64mb and I also followed the link that El Patron kindly posted but so far there is no improvement, apparently though I am about the 3rd person this week with the same problem reported to my hosts so they are looking into this in great depth so as soon as I have any positive results I will post back please any further suggestions/help is much appreciated. cheers Mike Edited September 18, 2013 by jonmig (see edit history) Link to comment Share on other sites More sharing options...
PrestaHeroes USA Posted September 18, 2013 Share Posted September 18, 2013 start with 256 mb...also my watch is a manual windup... 2 Link to comment Share on other sites More sharing options...
jonmig Posted September 19, 2013 Author Share Posted September 19, 2013 hi El Patron which file do you recommend changing to 256mb? cheers Mike Link to comment Share on other sites More sharing options...
PrestaHeroes USA Posted September 19, 2013 Share Posted September 19, 2013 Hey Mike, it would be the php.ini...there may be work arounds like placing a 'minor' php.ini or php5.ini file with the updates in your root directory. The other alternative is to get the hosting company to up it for you... tip: search outside of prestashop for better information as this is outside of the ps cms. Link to comment Share on other sites More sharing options...
jonmig Posted September 19, 2013 Author Share Posted September 19, 2013 (edited) hi El Patron Thank you is there only one php.ini file ,it seems to be in my cgi-bin folder and the line I've found is (plz see attached) is this what you are referring to ? (I changed it from 16mb to 64mb but it hasn't done anything!) Edited September 19, 2013 by jonmig (see edit history) Link to comment Share on other sites More sharing options...
PrestaHeroes USA Posted September 19, 2013 Share Posted September 19, 2013 create a file with the following code and upload to your website. navigate to your website, it will give you lots of information but it will also tell you where it is reading the php.ini from and taking out the guess work. Note: this may take a reboot of the server...some values do, some don't... <?php // Show all information, defaults to INFO_ALL phpinfo(); ?> Link to comment Share on other sites More sharing options...
jonmig Posted September 19, 2013 Author Share Posted September 19, 2013 (edited) hi El Patron how does one reboot the server ,surely thats something I don't have control of ?.. I edited the php.ini file to 128mb last night and today everythings working ,however it didn't work straight away when I changed the value so I was thinking maybe the host tech dept had done something today but I haven't been able to contact them yet to confirm ... cheers Mike Edited September 19, 2013 by jonmig (see edit history) Link to comment Share on other sites More sharing options...
PrestaHeroes USA Posted September 19, 2013 Share Posted September 19, 2013 to reboot...via ssh (requires geek access) have your hosting provider boot it or..if it's in the room...turn it off and back on glad you rolling...though 256bm would have been a better bet and which I suggested earlier... good luck! and happy learning 1 Link to comment Share on other sites More sharing options...
jonmig Posted September 19, 2013 Author Share Posted September 19, 2013 (edited) Ok I've changed it to 256mb as recommended Thank you El Patron (you're a true gentleman!) cheers Mike Edited September 19, 2013 by jonmig (see edit history) 1 Link to comment Share on other sites More sharing options...
aee156 Posted February 3, 2017 Share Posted February 3, 2017 (edited) I do have it set at 2048M you can see it. I posted a link but then thought that was probably not a smart idea, so I will pm it to you El Patron Please take a look at the above link and let me know what you think. Edited February 3, 2017 by aee156 (see edit history) Link to comment Share on other sites More sharing options...
PrestaHeroes USA Posted February 3, 2017 Share Posted February 3, 2017 I do have it set at 2048M you can see it. I posted a link but then thought that was probably not a smart idea, so I will pm it to you El Patron Please take a look at the above link and let me know what you think. Hi for best results make sure to start new topic when either old or marked solved, both of which this post is...lol Use this free module to see your php at runtime. but 2048mb is obvisouly not what is happening at runtime unless you selling elephants...lol https://www.prestaheroes.com/en-us/free-prestashop-modules/prestashop-module-display-phpinfo-phpini Link to comment Share on other sites More sharing options...
bellini13 Posted February 4, 2017 Share Posted February 4, 2017 you cannot allocate 2gb of memory to the PHP process, if you only have 2gb of memory available to the server. you will most certainly run out of memory and ruin or corrupt your operating system. Link to comment Share on other sites More sharing options...
PrestaHeroes USA Posted February 4, 2017 Share Posted February 4, 2017 total memory / instance = number of concurrent instance - server overhead...I'm waiting for pthreads..... Link to comment Share on other sites More sharing options...
aee156 Posted February 5, 2017 Share Posted February 5, 2017 I changed my php memory to 256M and the stores still have the same issue. There are only 2 stores that are having issues, I have a bunch of other stores that are fine. Same versions too. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now