database issue

[Nico Knoester]

Don't want to double post (just posted this on
http://code.google.com/p/porpoise/wiki/InstallationInstructions = not
really the correct place for this issue i gues :))

------------------------

hi,

everything works great! Found only one issue and not sure if this is
important! I loaded the sql in and it gives me an error on the
constraints:

/* SQL Error: Can't create table './databasename/
#sql-104e_180a0c.frm' (errno: 150) */

for the table 'Action' and 'Animation'

original code:

-- Constraints for table action --
ALTER TABLE Action
ADD CONSTRAINT Action_ibfk_1 FOREIGN KEY (poiId) REFERENCES poi (id)
ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table animation --
ALTER TABLE Animation
ADD CONSTRAINT Animation_ibfk_1 FOREIGN KEY (poiId) REFERENCES poi
(id) ON DELETE CASCADE ON UPDATE CASCADE;

All this results in the following message when i am adding a POI to my
layar:

Database error: SQLSTATE[42S02]: Base table or view not found: 1146
Table 'database_name.layer' doesn't exist

i can not find out what goes wrong! Anyone?