Re: [Phpwiki-talk] Trouble installing with Postgres

[Joby W. <joby@u.washington.edu>]

Hmm... Looks like you are actually connecting...

try:

1) psql -U postgres ldapwiki
2) \d

explanation:
1) Should connect you as the postgres user to your database.
2) \d switch lists all objects.

"phpwiki_page" is not a standard name for a table (normally "page") did 
you make this change?

jbw

Benjamin Smith wrote:
> Want to install phpwiki 1.3.x and having trouble doing so. 
> 
> Server is RH 7.1, PGSQL 7.1, apache 1.3.26. Database user/pw combination has 
> been made "ldapwiki/password", database named "ldapwiki". 
> 
> I've edited index.php so that array "DBParams" is: 
> 
> $DBParams[dbtype]='SQL'; 
> $DBParams[dsn]='pgsql://ldapwiki:password@localhost/ldapwiki'; 
> 
> And I get the below error message in my browser. Any idea why? 
> 
> 
> ############################### ERROR 
> lib/WikiDB/backend/PearDB.php:680: Fatal[256]: wikidb_backend_pgsql: fatal 
> database error
> 
>     * DB Error: no such table
>     * (LOCK TABLE phpwiki_page [nativecode=ERROR: Relation 'phpwiki_page' 
> does not exist
>     * ])
> *
> 
> 
> Fatal PhpWiki Error
> 
> lib/WikiDB/backend/PearDB.php:680: Fatal[256]: wikidb_backend_pgsql: fatal 
> database error
> 
>     * DB Error: no such table
>     * (LOCK TABLE phpwiki_page [nativecode=ERROR: Relation 'phpwiki_page' 
> does not exist
> * ])
> ############################### /ERROR 
> 
> 
> -------------------------------------------------------
> This sf.net email is sponsored by: viaVerio will pay you up to
> $1,000 for every account that you consolidate with us.
> http://ad.doubleclick.net/clk;4749864;7604308;v?
> http://www.viaverio.com/consolidator/osdn.cfm
> _______________________________________________
> Phpwiki-talk mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwiki-talk