www.webdeveloper.com
Results 1 to 3 of 3

Thread: tried to add column, got Fatal Error: Allowed memory size exhausted -

  1. #1
    Join Date
    Mar 2010
    Posts
    281

    tried to add column, got Fatal Error: Allowed memory size exhausted -

    Hey Everyone,
    i was trying to add a column to the product table in ZenCart and got this error:

    Fatal error: Allowed memory size of 262144 bytes exhausted (tried to allocate 32 bytes) in /var/www/phpmyadmin/libraries/sqlparser.lib.php on line

    the SQL statement i was using was real straight ahead, simple:
    PHP Code:
    ALTER TABLE products ADD features_list VARCHAR(250); 
    does anyone know how can i fix?,

    thanks for any help on this -

  2. #2
    Join Date
    Dec 2012
    Posts
    21
    Does your products table have lots and lots of rows? Sometimes PHPMyAdmin struggles with these kinds of operations on big tables.

    One option is to increase the amount of memory php has access to by editing your php.ini. Increase the value of "memory_limit"

    The better solution would be to connect to the database through something better than phpmyadmin; either either the command line on the server, or from NaviCat or something on your computer.

    Also, typically a big varchar is 255, not 250

  3. #3
    Join Date
    Mar 2010
    Posts
    281
    thank you!

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles