Field 'cart' doesn't have a default value

I am using apache V2.2, mysql V5 and php V5.26 on a windows XP SP2. Installation went fine and I can access the front and backend. However, when I tried to create a new customer in either the front or backend I get the same message,

Error: Field 'cart' doesn't have a default value
Error No: 1364
insert into customer set firstname = 'xxxx', lastname = 'xxxxxxx', email = 'xxxxxx@excite.com', telephone = 'xxxxx xxxxxx', fax = 'xxxxx xxxxxx', newsletter = '0', password = 'e2241a3a6d76d7c6464680e41235dbc8', status = '1', date_added = now()

In the above error message I have replaced sensitive information with x's.

I thought it might be that the 'cart' field has null as a default value but when I tried to change this the mysql admin reported an error stating that the text / blob field could not have a default value.

Suggestions would be appreciated

Check here for a possible solution:
http://forum.opencart.com/index.php/top ... ml#msg5124

For a fix see: http://code.google.com/p/open-cart/issues/detail?id=9