My SQL Error 1101 - BLOB/TEXT cannot have default value
Posted: Thu Oct 12, 2006 4:00 am
Hi,
I am developing an application using PHP and MySQL. I had an older version of MySQL - 4.0 and installed Joomla CMS and it installed smoothly. I upgraded the MySQL version to the newer one - 5.1 and when I run the same Joomla installer, it gives me this error, when it tries to set up the database:
My SQL Error 1101 - BLOB/TEXT cannot have default value
Any idea why this may happen?
Thanks
I am developing an application using PHP and MySQL. I had an older version of MySQL - 4.0 and installed Joomla CMS and it installed smoothly. I upgraded the MySQL version to the newer one - 5.1 and when I run the same Joomla installer, it gives me this error, when it tries to set up the database:
My SQL Error 1101 - BLOB/TEXT cannot have default value
Any idea why this may happen?
Thanks