Installing the module on one machine running Windows and MySQL 5.0.37 gave the following error message:
user warning: BLOB/TEXT column 'message' can't have a default value query:
CREATE TABLE invite ( email varchar(64) NOT NULL default '', reg_code
varchar(64) NOT NULL default '', uid int(10) unsigned NOT NULL default '0', mid
int(11) unsigned NOT NULL default '0', expiry int(11) NOT NULL default '0',
timestamp int(11) NOT NULL default '0', received tinyint(3) unsigned NOT NULL
default '0', message text NOT NULL default '', PRIMARY KEY (email), UNIQUE
(reg_code) ) /*!40100 DEFAULT CHARACTER SET utf8 */; in
C:\drupal\includes\database.mysqli.inc on line 151.
user warning: Table 'drupal_db.invite' doesn't exist query: ALTER TABLE invite
ADD INDEX (uid) in C:\drupal\includes\database.mysqli.inc on line
151.
The module did not work after this unsuccessful installation.
Installation on another machine running Linux and MySQL 5.0.38-Debian_1-log succeeded.
I have tried executing the CREATE TABLE query in a MySQL console. On both machines I got the warning: BLOB/TEXT column 'message' can't have a default value. But on the first machine the table was not created, while on the second one it was.
Comments
Comment #1
smk-ka commentedFixed, thanks.
--
Stefan Kudwien
www.unleashedmind.com
Comment #2
(not verified) commented