database issue trying to install

[tguadagno]

Hi,
  I am trying to install into a MySQL 5.1rc25 installation.  When I do the 'initialize database' function, I get this message...also, it mentions something about a manual database installation...but I can find no documentation on this......can anyone help? (btw, there is more in the error, but I cannot post it because the forum says I have too many images in my post...how do I get around that?)

thanks much

Check configured database settings
Backend: PEAR::MDB2
DSN (write):  OK
DB Schema:  NOT OK(Error creating database schema: MDB2 Error: unknown error Query:

........


Please try to inizialize the database manually as described in the INSTALL guide. Make sure that the configured database extists and that the user as write privileges

[dano]

Sounds like you haven't created the database if you can't find the install file.  It should be located in the root folder of your download and has that exact name 'INSTALL' all in caps.

[tguadagno]

ok, i think i fixed it.  i had created the database.  I was using the mysql5 script.  when you run that, mysql 5.1r25 gives this error

ERROR 1101 (42000): BLOB/TEXT column 'signature' can't have a default value
Query OK, 0 rows affected (0.00 sec)

so i changed the following

Code: [Select]


 `signature` text NOT NULL default " ",

to

Code: [Select]


 `signature` text NOT NULL,


in

Code: [Select]

CREATE TABLE `identities` (
 `identity_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
 `del` tinyint(1) NOT NULL DEFAULT '0',
 `standard` tinyint(1) NOT NULL DEFAULT '0',
 `name` varchar(128) NOT NULL,
 `organization` varchar(128) NOT NULL DEFAULT '',
 `email` varchar(128) NOT NULL,
 `reply-to` varchar(128) NOT NULL DEFAULT '',
 `bcc` varchar(128) NOT NULL DEFAULT '',
 `signature` text NOT NULL,
 `html_signature` tinyint(1) NOT NULL DEFAULT '0',
 `user_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
 PRIMARY KEY(`identity_id`),
 CONSTRAINT `user_id_fk_identities` FOREIGN KEY (`user_id`)
   REFERENCES `users`(`user_id`)
     ON DELETE CASCADE
     ON UPDATE CASCADE
) TYPE=INNODB CHARACTER SET utf8 COLLATE utf8_general_ci;



It seems to work now.  anyone else experiencing this?

thanks