Looks like you might have a composite primary key for the ARRAY error? As far as i know cake does not support this, you would have to create a new unq primary key I think.
On Sep 22, 1:18 am, chrisbdaemon <[EMAIL PROTECTED]> wrote: > Hey, I'm trying to migrate a site's database from MySQL to PostgreSQL > and I created a schema from the already existing MySQL database and > the models I created for it. I put in the PostgreSQL connection > parameters into the configuration file and tried to do a 'php cake.php > schema run create' to create the new tables in the postgresql database > and I got some errors. Most of them were different instances of these > errors: > > Warning: pg_query(): Query failed: ERROR: syntax error at or near "," > LINE 10: CREATE INDEX dst_ind ON "calls"("phone_number_id");, > ^ in > [snip]/cake1.2/cake/libs/model/datasources/dbo/dbo_postgres.php on > line 152 > > Warning: pg_query(): Query failed: ERROR: syntax error at or near > "Array" > LINE 8: PRIMARY KEY (Array)); > ^ in [snip]/cake1.2/cake/libs/model/datasources/ > dbo/dbo_postgres.php on line 152 > > Warning: pg_query(): Query failed: ERROR: syntax error at or near "," > LINE 11: CREATE UNIQUE INDEX filename ON "reviews"("filename");, > ^ in > [snip]/cake1.2/cake/libs/model/datasources/dbo/dbo_postgres.php on > line 152 > > This is with CakePHP 1.2.0.7296 RC2 running on a MacBook with Mac OS X > 10.5.5 with a freshly compiled PHP 5.2.6 > > I've been trying to use more and more features of the code generator > but it doesn't quite seem to be finished yet as far as testing and > debugging goes. However, I have noticed quite a few things fixed and > whoever is working on it, I appreciate it as well as many others I'm > sure. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---