No database tables created on install

[pjamedia]

I have just installed RC (current version) and the config applied successfully but no database tables were created - I checked in phpmyadin. I didn't see an option to create the tables through the installer pages. Any ideas where I go next?

Thanks, Paul A

[rosali]

./SQL

There is a SQL folder in the RoundCube installation with database scripts. If you use MySQL then run mysql.initial.sql.

[pjamedia]

Ran the script and all tables created apart from one. This is the error:

 SQL query:

-- Table structure for table `contacts`
CREATE TABLE `contacts` (
`contact_id` int( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
`changed` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
`del` tinyint( 1 ) NOT NULL DEFAULT '0',
`name` varchar( 128 ) NOT NULL ,
`email` varchar( 128 ) NOT NULL ,
`firstname` varchar( 128 ) NOT NULL ,
`surname` varchar( 128 ) NOT NULL ,
`vcard` text NULL ,
`user_id` int( 10 ) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY ( `contact_id` ) ,
CONSTRAINT `user_id_fk_contacts` FOREIGN KEY ( `user_id` ) REFERENCES `users` ( `user_id` ) /*!40008 ON DELETE CASCADE ON UPDATE CASCADE */
)/*!40000 ENGINE=INNODB *//*!40101 CHARACTER SET utf8 COLLATE utf8_general_ci */

MySQL said: Documentation
#1005 - Can't create table './db279724712/contacts.frm' (errno: 150)

Paul A

[Julius Caesar]

Drop and recreate the database and run the script mysql.initial.sql again.

The foreign key is probably already created.

[pjamedia]

I dropped all the tables and re ran the script and it staled at the same point. I even created a new script starting at the table creation through to the end and ran this and it fell over at exactly the same point. I will try deleting the database and starting again.

Cheers, Paul

[pjamedia]

Created a brand new database and ran the script again with exactly the same error as before. Any other ideas?

Thanks, Paul

[pjamedia]

I have resolved this. I chose to use mysql v5 instead of v4 and the sql script applied successfully. I am now working perfectly!

Thanks for all who gave advice,

Paul A