after enabling the modules, errors are

BLOB/TEXT column 'link' can't have a default value query: CREATE TABLE ....

i checked the database in the server,no table is created coz this problem.

my environment:mysql 5.0.22 php 5.2.1

only found the related doc,but didn't work http://drupal.org/node/130890

help is urgent...thanks

Comments

alex_b’s picture

alex_b commented

Seems to be a mysql 5 related problem. It would be great if you could try the faulty query on your mysql client and find out the bad part in it. As leech is not tested for use on mysql5 you are likely to run into similar problems down the road.

aron novak’s picture

aron novak
Primary language Hungarian
Location Hungary, Budapest
commented
Assigned: Unassigned » aron novak
Status: Active » Closed (won't fix)

This issue is not the issue of leech module. The problem is discussed here: http://bugs.mysql.com/bug.php?id=25520 . Not all the MySQL storage engines behaves same. So everone who struggle with this problem should read this mysql bug ticket.

alex_b’s picture

alex_b commented
Title: can't creat table in drupal 5.1 » Can't create table in drupal 5.1 - default value for TEXT column defined
Priority: Critical » Normal
Status: Closed (won't fix) » Active

Sorry, Aron, we'll have to reopen this. MySQL 5 won't support default values for BLOB or TEXT columns. leech will be the mountain that has to move here :)

freemagshow: Unfortunately there are no plans to support Mysql5 soon. That said, patches implementing 5.x support are always appreciated. If you manage to get it working, let us know!

aron novak’s picture

aron novak
Primary language Hungarian
Location Hungary, Budapest
commented

Sorry, but MySQL 5 in a Linux environment support default values for BLOB or TEXT columns! So it's depending on the storage engine, the Windows version perhaps uses default storage engines / settings. Not every MySQL 5 user is affected at all.