ctodd's Blog

Re: conf.php file is not created by phocoa

Unless I'm missing something, I am running Propel 1.3 :

[root@is2 ~]# pear list -a
Installed packages, channel __uri:
==================================
(no packages installed)
Installed packages, channel pear.horde.org:
===========================================
Package Version State
Yaml    1.0.1   stable
Installed packages, channel pear.phing.info:
============================================
Package Version State
phing   2.3.3   stable
Installed packages, channel pear.php.net:
=========================================
Package          Version State
Archive_Tar      1.3.2   stable
Console_Getopt   1.2.3   stable
Log              1.9.11  stable
Mail             1.1.14  stable
Mail_Mime        1.5.2   stable
Mail_mimeDecode  1.5.0   stable
Net_SMTP         1.3.2   stable
Net_Socket       1.0.9   stable
PEAR             1.6.2   stable
PhpDocumentor    1.4.2   stable
Structures_Graph 1.0.2   stable
XML_RPC          1.5.1   stable
Installed packages, channel pear.phpdb.org:
===========================================
Package          Version State
creole           1.1.0   stable
propel_generator 1.3.0   stable
propel_runtime   1.3.0   stable
Installed packages, channel pecl.php.net:
=========================================
(no packages installed)

Creole error when running propel-gen

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]

Working with PostgreSQL

MySQL is my database of choice, but to get through the blog sample, I've used Postgres since this is a "known working config". The first issue I ran into is that the syntax in the example is specific to Postgres 8.x and I happened to have 7.4 installed.

Since I'm not as familiar with running postgresql as mysql, there was considerable pain in getting the server setup properly. I know this isn't the responsibility of the phocoa project, but a short primer and/or cheat sheet on getting a working server config would really be helpful. Some of the struggles I found were setting passwords and access permissions.

Chris

conf.php file is not created by phocoa

I'm revisiting phocoa after a break, and just upgraded my install to the latest :

phocoa 0.2.3
smarty 2.6.22
phing   2.3.3   stable
Yaml    1.0.1   stable
creole           1.1.0   stable
propel_generator 1.3.0   stable
propel_runtime   1.3.0   stable

I'm running through the blog install from scratch and found that the conf file blog/blog/conf/blog-conf.php is not being created and causing an error:

Fatal error: Uncaught exception 'PropelException' with message 'Unable to open configuration file: '/var/www/blog/blog/conf/blog-conf.php'' in /usr/share/pear/propel/Propel.php:272 Stack trace: #0

Creating an empty file causes this error to go away. I didn't recall anything in the install doc discussing this. Now I get the following error :

Warning: Invalid argument supplied for foreach() in /usr/share/pear/propel/Propel.php on line 250
Module 404: invocation path 'blog' could not be found.

Is this an issue with my setup, bug, or other user error?

Chris