In phocoa 0.2.3, I get the following error when reverse-engineering the blog database. "ORDER BY name" is hard coded into the creole file PgSQLDatabaseInfo.php. I looked to ensure that I was using the latest version of creole and I see that "creole is dead" as Nov 08, and propel is using PDO is the replacement. Initially I need to address this error, but I'd be interested in how to move forward with PDO in Propel/Phocoa.
Chris
propel > creole:
[echo] +-----------------------------------------------+
[echo] | |
[echo] | Generating XML from Creole connection ! |
[echo] | |
[echo] +-----------------------------------------------+
[propel-creole-transform] Propel - CreoleToXMLSchema starting
[propel-creole-transform] Your DB settings are:
[propel-creole-transform] driver : (default)
[propel-creole-transform] URL : pgsql://blog:blog@localhost/blog
[propel-creole-transform] DB connection established
[propel-creole-transform] Processing database
[propel-creole-transform] Processing table: blog
[PHP Error] pg_query(): Query failed: ERROR: column "name" does not exist at character 430 [line 96 of /usr/share/pear/creole/drivers/pgsql/metadata/PgSQLDatabaseInfo.php]
[propel-creole-transform] There was an error building XML from metadata: Could not list sequences [Native Error: ERROR: column "name" does not exist at character 430]
This Topic Is Locked To Guest Posts
It's been a while since this topic was active, if you'd like to get it going again, please post as a registered member
