Ticket #1484940 (closed Bugs: fixed)

Opened 9 months ago

Last modified 9 months ago

Installer fials to create DB Schema

Reported by: Zeron Owned by: thomasb
Priority: 5 Milestone: 0.1.1
Component: PHP backend Version: svn-trunk
Severity: normal Keywords:
Cc:

Description (last modified by till) (diff)

php 5.2.1, mysql 5.0.54 SVN trunk March 31

Pressing the Initialize Schema button gives this error:

(MDB2 Error: constraint violation Query: _doQuery: [Error message: Could not execute statement] [Last executed query: EXECUTE MDB2_STATEMENT_mysql_818413e4254374e47c39a3fa0e89f751c039e1561 USING @0, @1, @2] [Native code: 1452] [Native message: Cannot add or update a child row: a foreign key constraint fails (`roundcubemail/cache`, CONSTRAINT `user_id_fk_cache` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE)] )

Manually using mysql5.initial.sql works fine.

Change History

Changed 9 months ago by till

  • owner set to thomasb
  • description modified (diff)

@thomasb: I think that the installer should "read in" the .sql file as well. Less errors. :)

Changed 9 months ago by till

  • milestone changed from later to 0.1.1

Changed 9 months ago by thomasb

  • status changed from new to closed
  • resolution set to fixed
  • component changed from Client to PHP backend

This error is caused from the test-query that is performed to check if the DB is writeable. Now fixed with r1241

Note: See TracTickets for help on using tickets.