Linode Forum
Linode Community Forums
 FAQFAQ    SearchSearch    MembersMembers      Register Register 
 LoginLogin [ Anonymous ] 
Post new topic  Reply to topic
Author Message
PostPosted: Thu Jan 21, 2010 9:56 pm 
Offline
Senior Newbie

Joined: Wed Sep 24, 2008 6:38 pm
Posts: 19
I have a linode 360. I am running lighttpd+php5+mysql-server. After I first installed phpmyadmin, I got a blank screen. So I changed php.ini to have:
display_errors = On
log_errors = Off

Now, when I run phpmyadmin, I get the following Fatal Error:

Fatal error: Allowed memory size of 262144 bytes exhausted (tried to allocate 311296 bytes) in /usr/share/phpmyadmin/libraries/common.inc.php on line 630

However, my memory_limit in php.ini is
memory_limit = 64MB

So why does it say my allowed memory size if 262144 bytes. It should say 64MB (64 x 1024 x 1024)?


Top
   
 Post subject:
PostPosted: Thu Jan 21, 2010 11:02 pm 
Offline
Senior Member

Joined: Fri May 02, 2008 8:44 pm
Posts: 1121
Drop the last B from memory_limit = 64MB. Restart lighttpd.

Just one example of how stupid PHP can be 8)


Top
   
 Post subject:
PostPosted: Fri Jan 22, 2010 12:08 am 
Offline
Senior Newbie

Joined: Wed Sep 24, 2008 6:38 pm
Posts: 19
Thanks very much for the reply. Why in the world would someone (PHP or Ubuntu?) leave a comment such as this:
memory_limit = 64MB ; Maximum amount of memory a script may consume(16MB)

in the php.ini file? Anyway, really appreciate the feedback. I changed it to
memory_limit = 64M ; Maximum amount of memory a script may consume(16MB)

and phpmyadmin works just fine.


Top
   
 Post subject:
PostPosted: Fri Jan 22, 2010 12:34 am 
Offline
Senior Member
User avatar

Joined: Sun Dec 27, 2009 11:12 pm
Posts: 1038
Location: Colorado, USA
Or use HeidiSQL or SQLyog over SSH.

Way more secure and it doesn't eat up 1/6 of your memory just for a server based SQL GUI.


Top
   
 Post subject:
PostPosted: Tue Feb 02, 2010 12:26 pm 
Offline
Newbie

Joined: Sun Jan 24, 2010 11:48 pm
Posts: 2
by the way, the HeidiSQL idea is great and worked great...I will be uninstalling phpMyAdmin right away. Here is a great link on how to get HeidiSQL up and running using a tunnel through putty (ssh)

http://www.heidisql.com/forum.php?t=167


Top
   
Display posts from previous:  Sort by  
Post new topic  Reply to topic


Who is online

Users browsing this forum: No registered users and 3 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
RSS

Powered by phpBB® Forum Software © phpBB Group