Beste,
Ik krijg in mijn database de fout.
Fatal error: Out of memory (allocated 5767168) (tried to allocate 262204 bytes) in /var/www/html/phpMyAdmin-3.2.5-all-languages/sql.php on line 301
weet iemand wat deze fout betekend want google is niet heel erg hulpzaam met deze fout.
- Vaage mysql fout
-
01-03-2010, 13:02 #1
- Berichten
- 170
- Lid sinds
- 16 Jaar
Vaage mysql fout
-
-
01-03-2010, 13:14 #2
- Berichten
- 660
- Lid sinds
- 19 Jaar
-
01-03-2010, 13:40 #3
- Berichten
- 170
- Lid sinds
- 16 Jaar
Ron bedankt,
voor mensen die in de toekomst deze foutmelding hebben.
PHP Fatal error: Out of memory (allocated 49545216) (tried to allocate 77824 bytes) in /home/xxxxx/public_html/xyz/admin.php(1758) on line 40
The first thing I could think of was to restart the Apache httpd service. This immediately solved the issue. but I knew this is not a permanent fix for the issue. When I researched further, I got to know that the error comes when certain PHP scripts require more memory than PHP was allowed by default.
So the solution is to increase the memory allocated for PHP. How to do that? There are 4 possible ways -
1. Try looking for the php.ini file. You might find some redundant php.ini files, so make sure you have got the one which is actually being read by PHP. o be sure, create a new php file in your root folder, say “check.php” and have phpInfo(); within the php open and close tags. Execute this file to get the information on where the php.ini is residing. Normally it will be in /usr/local/lib/php.ini
Open the php.ini file in a text editor like TextPad (not in Notepad) and change the values for memory_limit. By default you should see memory_limit = 8M. Try changing it to 12M. If it doesn’t work, increase it to 16M or even 24M and so on.
2. In case you can’t find the php.ini file or do not have access to it, then open up the file which was throwing the error (admin.php in my case) and add a line below just after ini_set(’memory_limit’, ‘12M’);
3. You can even consider adding a line in .htaccess file which will resolve the issue.
php_value memory_limit 32M
4. Or else, Try adding this line to your wp-config.php file:
Increasing memory allocated to PHP
define('WP_MEMORY_LIMIT', '32M');
If none of the above things solve your issue, then talk to you host. If you have a host like Knownhost who is fast and knows what needs to be done, you do not have to worry much.
Note: I am now worrying on which PHP script required an increase in memory allocation. The analysis won’t be so easy though.
Wesley
Plaats een
- + Advertentie
- + Onderwerp
Marktplaats
Webmasterforum
- Websites algemeen
- Sitechecks
- Marketing
- Domeinen algemeen
- Waardebepaling
- CMS
- Wordpress
- Joomla
- Magento
- Google algemeen
- SEO
- Analytics
- Adsense
- Adwords
- HTML / XHTML
- CSS
- Programmeren
- PHP
- Javascript
- JQuery
- MySQL
- Ondernemen algemeen
- Belastingen
- Juridisch
- Grafisch ontwerp
- Hosting Algemeen
- Hardware Info
- Offtopic