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
./SQL
There is a SQL folder in the RoundCube installation with database scripts. If you use MySQL then run mysql.initial.sql.
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
Drop and recreate the database and run the script mysql.initial.sql again.
The foreign key is probably already created.
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
Created a brand new database and ran the script again with exactly the same error as before. Any other ideas?
Thanks, Paul
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