Re: [Webcollab-users] unable to connect to database after installation webcollab 3.00

[Andrew S. <and...@co...>]

On Thu, 05 Jan 2012 16:34:47 +0530
Bhuvan Krishna <bh...@sw...> wrote:

> I am attaching the relavent log details from apache, postgresql and 
> webcollab. I enabled debug in the config.php and tried installing. I got 
> this error on the screen.
> 
> Database server error:
> SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "site_name" does not 
> exist LINE 1: UPDATE site_name SET manager_name='WebCollab Project 
> Managem... ^
> 
> check the attachments for more details.
> 
> Regards,
> Bhuvan

Bhuvan,

Thanks.  That's not too hard to fix.

What has happened is that you've created the database manually, but not created the tables from the
database schema.

This is why WebCollab can connect to the database, but fails to insert data into the
(non-existent) tables.

The database table schema is in [webcollab]/db and is 'schema-pgsql.sql'.  There are some
instructions in [webcollab]/docs, but basically something like this will work:

# psql -U 'database_user' -e 'database_name' < schema-pgsql.sql

I'll add another error trap to the setup program to look for this condition.

Andrew