Re: Projects in Webui

On Tue, 2009-06-09 at 21:27 +0200, Christian Naumer wrote:
> I installed the new packages from OBS. They work fine for the things we
> use. However if I open a Project in the webui and then click on the
> notes tab I get the following error in the log:
> Jun 09 21:11:24 ogo-webui-5.5 [23182]: |ogo-webui-5.5|
> <OpenGroupware[0x0x821245c]: name=ogo-webui-5.5>: caught:
>   (Exception name:PostgreSQL72FatalError class:PostgreSQL72Exception
> reason:fatal pgsql error (channel=<0x0x8ff859c[PostgreSQL72Channel]:
> connection=<0x0x8ff879c[PGConnection]:  connection=0x0x8ff8fb8>>):
> FEHLER:  Spalte t1.company_id existiert nicht
>  info:<nil>)
> in context:
>   <0x0x91c8d7c[WOContext]: 0084a2eb3dc091c8d7c app=ogo-webui-5.5
> sn=5A8E5A8E014A2EB3AF eid=0084a2eb3dc091c8d7c.0.17.1.3.b.notes.9 rqeid=>.
> Jun 09 21:11:24 ogo-webui-5.5 [23182]: |ogo-webui-5.5| terminating
> session due to exception: 5A8E5A8E014A2EB3AF
> Jun 09 21:11:24 ogo-webui-5.5 [23182]: |ogo-webui-5.5|
> WOServerSessionStore: session 5A8E5A8E014A2EB3AF terminated.
> Which I think means a column in db was not found. Someone mentioned
> earlier that some changes to the schema are going to be made. Has this
> already happened? The error happens with a fresh install as well as with
> an update from the last packages of OBS. The database of course is
> restored from a backup and thus doesn't have any schema changes.
> We don't use the Project feature at the moment so this isn't a big
> issue. Just wanted to let you know. If you need any more info I'll try
> to help.

Yep, I'm working on removing the requirement for the Staff table which I
suspect causes this.  Although I can view notes;  any change you could
enable SQL logging and see exactly the query that is causing it to fail?

Defaults write NSGlobalDomain PGDebugEnabled YES
Defaults write NSGlobalDomain LSProfileCommands YES

That will tell me the command and the query where the error occurs.

-- 
OpenGroupware.org Users
[email protected]
http://mail.opengroupware.org/mailman/listinfo/users