tried to add column, got Fatal Error: Allowed memory size exhausted -
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:
does anyone know how can i fix?,
ALTER TABLE products ADD features_list VARCHAR(250);
thanks for any help on this -
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
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)