Re: [Phpwebsite-developers] postgres

[Andy H. <ah...@ht...>]

-----BEGIN PGP SIGNED MESSAGE-----


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
On 01-Apr-2003, Matthew McNaney wrote message "Re: [Phpwebsite-developers]
postgres"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>> Is the postgres support supposed to work?
> 
> Absolutely. 'Supposed to' being the key phrase. Don told me about the
> error in setup and that has been fixed. If you would like to lend a hand,
> point out any incompatibilities and I will be happy to repair them.




Ok, finally got around to trying it again.  I downloaded the cvs tarball last
night and installed it.  I got further this time, it created the config file,
and prompted me to create the admin user.  At the module install screen, I
select all and click install button.  The next screen gives me: 



phpWebSite Core Installation: Version 0.9.1 RC1

SQL: CREATE TABLE branch_sites ( branchName varchar(20) NOT NULL default '',
configFile varchar(255) NOT NULL default '', IDhash varchar(32) NOT NULL
default '', modsInstalled text, branchDir text NOT NULL, branchHttp
varchar(255) NOT NULL default '')
unknown error

- From psql, I chopped that into a single line and tried it manually. 

phpws=# CREATE TABLE branch_sites ( branchName varchar(20) NOT NULL default '',
configFile varchar(255) NOT NULL default '', IDhash varchar(32) NOT NULL
default '', modsInstalled text, branchDir text NOT NULL, branchHttp 
varchar(255) NOT NULL default '');
ERROR:  No namespace has been selected to create in


I'm not pgsql expert, so I have no idea what it is.  If you don't either, I
don't mind doing the leg work and trying to figure it out if you need.  Let me
know.



~~ 
Andy Harrison
ah##@httpsite.com
ICQ: 123472  AIM/Y!: AHinMaine
[full headers for details]

-----BEGIN PGP SIGNATURE-----
Version: PGP 6.5.8

iQCVAwUBPpQf6lPEkLgodAWVAQE/SgP/UPGS4X8vXk8A7WzaAkasy70qrsYbi4ts
P90KNq04qBjmO5uxBRLMDSbxeJi1OzV2NH7hzE2r+xas12hsp7lTUA3775cfNlPJ
0umbRN25kae+By4Xx4ndYwhz+8Z2g+U8HJCKuyz9+FJBaVOrxC3TS7iZEPv71pcQ
WvD8hYEdJHE=
=pocE
-----END PGP SIGNATURE-----