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

This site is best viewed in a modern browser with JavaScript enabled.

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

toptomato

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:

ALTER TABLE products ADD features_list VARCHAR(250);

does anyone know how can i fix?,

thanks for any help on this -

johhny-s

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

toptomato

thank you!