install errer
freeng - May 5, 2008 - 10:02
| Project: | Tribune |
| Version: | 6.x-1.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed |
Jump to:
Description
user warning: BLOB/TEXT column 'referenced_by' can't have a default value query: CREATE TABLE tribune ( post_id int(11) unsigned NOT NULL auto_increment, login varchar(32) NOT NULL, info varchar(128) NOT NULL, message text NOT NULL, post_time varchar(14) NOT NULL, is_alone int(2) NOT NULL default '0', post_rank int(11) unsigned NOT NULL default '0', parsed_message text NOT NULL, referenced_by text NOT NULL default '', last_modified int(11) NOT NULL default '0', PRIMARY KEY (post_id) ) /*!40100 DEFAULT CHARACTER SET utf8 */; in E:\drupal\sites\all\modules\tribune\tribune.install on line 43.
I'm Chinese,so my database used UTF8.What's the problem about?
#1
Okay, it worked for me but it seems like default values aren't allowed for TEXT columns (I don't understand why it worked for me, actually).
It is corrected in the CVS repository, but if you don't have access to the repository, all you have to do is delete the « default '' » part at line 40 in tribune.install (or you can wait until the tarball is updated).
The problem is not related with UTF8 as UTF8 is always used anyway, for any language.
Thanks for the report !
#2
Automatically closed -- issue fixed for two weeks with no activity.