You are viewing the PKP Support Forum | PKP Home Wiki

An error occurred creating the tables. Error 1101: BLOB/TEXT

Are you responsible for making OCS work -- installing, upgrading, migrating or troubleshooting? Do you think you've found a bug? Post in this forum.

Moderators: jmacgreg, michael, John

Forum rules
The Public Knowledge Project Support Forum is moving to http://forum.pkp.sfu.ca

This forum will be maintained permanently as an archived historical resource, but all new questions should be added to the new forum. Questions will no longer be monitored on this old forum after March 30, 2015.

An error occurred creating the tables. Error 1101: BLOB/TEXT

Postby GennadyK » Tue Apr 24, 2007 10:48 am

Hi there,

When I attempt to install OCS, I get the following error message during database creation:

Code: Select all
An error occurred creating the tables. Error 1101: BLOB/TEXT column 'intro' can't have a default value

I have already manually created the database, and checked the "database exists" box... has anyone else encountered this problem?

I am using the following:
PHP Version 5.1.4
Open Conference Systems: Version 1.1.7
Web: IIS 6.0
Server API CGI/FastCGI
OS: Windows 2003

Thanks for your help!
Posts: 19
Joined: Tue Apr 24, 2007 9:16 am

Postby asmecher » Wed Apr 25, 2007 10:30 am

Hi Gennady,

This appears to be specific to the newest releases of MySQL. Try applying the patch at http://pkp.sfu.ca/ocs/download/blob-defaults.diff and restarting the installation process.

Alec Smecher
Open Journal Systems Team
Don't miss the First International PKP Scholarly Publishing Conference
July 11 - 13, 2007, Vancouver, BC, Canada
Posts: 10015
Joined: Wed Aug 10, 2005 12:56 pm

Return to OCS Technical Support

Who is online

Users browsing this forum: Yahoo [Bot] and 4 guests