Author Topic: No database tables created on install (Read 4264 times)

pjamedia · « **on:** March 15, 2009, 12:57:19 PM »

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 · « **Reply #1 on:** March 15, 2009, 01:02:39 PM »

./SQL

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

pjamedia · « **Reply #2 on:** March 15, 2009, 01:18:09 PM »

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 · « **Reply #3 on:** March 15, 2009, 02:27:32 PM »

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

The foreign key is probably already created.

pjamedia · « **Reply #4 on:** March 15, 2009, 02:36:46 PM »

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 · « **Reply #5 on:** March 15, 2009, 03:10:09 PM »

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

Thanks, Paul

pjamedia · « **Reply #6 on:** March 15, 2009, 07:02:23 PM »

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