Re: Projects in Webui

Adam Tauno Williams schrieb:

> 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=
?
Yep here it comes... I pasted the last few transactions before the
error. Hope this is enough.


>=20
> Defaults write NSGlobalDomain PGDebugEnabled YES
> Defaults write NSGlobalDomain LSProfileCommands YES
>=20
> That will tell me the command and the query where the error occurs.

 0.000s project::get-team
Jun 09 19:52:35 ogo-webui-5.5 [7575]: PG0x0x9dfafdc SQL: SELECT DISTINCT
t1.access_right, t1.company_id, t1.db_status, t1.has_access, t1.info,
t1.project_company_assignment_id, t1.project_id FROM
project_company_assignment t1 WHERE t1.project_id IN (675680)
  0.002s project::get-company-assignments
  0.000s project::get-status
  0.000s project::check-get-permission
0.013s project::get
Jun 09 19:52:35 ogo-webui-5.5 [7575]: PG0x0x9dfafdc SQL: COMMIT TRANSACTI=
ON
Jun 09 19:52:35 ogo-webui-5.5 [7575]: PG0x0x9dfafdc SQL: BEGIN TRANSACTIO=
N
Jun 09 19:52:35 ogo-webui-5.5 [7575]: PG0x0x9dfafdc SQL: SELECT
t1.abstract, t1.contact, t1.creation_date, t1.current_owner_id,
t1.date_id, t1.db_status, t1.document_id, t1.file_size, t1.file_type,
t1.first_owner_id, t1.is_folder, t1.is_index_doc, t1.is_note,
t1.is_object_link, t1.lastmodified_date, t1.object_link,
t1.object_version, t1.parent_document_id, t1.project_id, t1.status,
t1.title, t1.version_count FROM  doc t1 WHERE ((t1.parent_document_id IS
NULL AND t1.abstract IS NULL)) AND (t1.project_id IN (675680))
0.005s project::get-root-document
Jun 09 19:52:35 ogo-webui-5.5 [7575]: PG0x0x9dfafdc SQL: SELECT
t1.company_id, t1.login FROM  person t1 WHERE t1.is_person =3D 1
Jun 09 19:52:35 ogo-webui-5.5 [7575]: PG0x0x9dfafdc SQL: SELECT
t1.document_id, t1.parent_document_id, t1.title, t1.file_type FROM  doc
t1 WHERE t1.project_id =3D 675680 AND t1.is_folder =3D 1
Jun 09 19:52:35 ogo-webui-5.5 [7575]: PG0x0x9dfafdc SQL: SELECT
t1.db_status, t1.end_date, t1.is_fake, t1.kind, t1.name, t1.number,
t1.object_version, t1.owner_id, t1.project_id, t1.start_date, t1.status,
t1.team_id, t1.url FROM  project t1 WHERE project_id=3D675680
Jun 09 19:52:35 ogo-webui-5.5 [7575]: PG0x0x9dfafdc SQL: SELECT DISTINCT
t1.anniversary, t1.assistant_name, t1.associated_categories,
t1.associated_company, t1.associated_contacts, t1.birthday,
t1.boss_name, t1.company_id, t1.contact_id, t1.db_status, t1.degree,
t1.department, t1.description, t1.dir_server, t1.email_alias, t1.fileas,
t1.firstname, t1.freebusy_url, t1.im_address, t1.pop3_account,
t1.is_account, t1.is_customer, t1.is_extra_account, t1.is_intra_account,
t1.is_locked, t1.is_person, t1.is_private, t1.is_readonly,
t1.is_template_user, t1.keywords, t1.login, t1.middlename, t1.name,
t1.name_affix, t1.name_title, t1.number, t1.object_version,
t1.occupation, t1.office, t1.owner_id, t1.partner_name, t1.password,
t1.priority, t1.salutation, t1.sensitivity, t1.sex, t1.show_email2_as,
t1.show_email3_as, t1.show_email_as, t1.source_url, t1.template_user_id,
t1.url FROM  person t1 WHERE t1.company_id IN (11770)
  0.008s project::get-owner
  0.000s project::get-team
Jun 09 19:52:35 ogo-webui-5.5 [7575]: PG0x0x9dfafdc SQL: SELECT DISTINCT
t1.access_right, t1.company_id, t1.db_status, t1.has_access, t1.info,
t1.project_company_assignment_id, t1.project_id FROM
project_company_assignment t1 WHERE t1.project_id IN (675680)
  0.002s project::get-company-assignments
  0.000s project::get-status
  0.000s project::check-get-permission
0.013s project::get
Jun 09 19:52:35 ogo-webui-5.5 [7575]: PG0x0x9dfafdc SQL: SELECT
t1.abstract, t1.contact, t1.creation_date, t1.current_owner_id,
t1.date_id, t1.db_status, t1.document_id, t1.file_size, t1.file_type,
t1.first_owner_id, t1.is_folder, t1.is_index_doc, t1.is_note,
t1.is_object_link, t1.lastmodified_date, t1.object_link,
t1.object_version, t1.parent_document_id, t1.project_id, t1.status,
t1.title, t1.version_count FROM  doc t1 WHERE ((t1.parent_document_id IS
NULL AND t1.abstract IS NULL)) AND (t1.project_id IN (675680))
0.003s project::get-root-document
Jun 09 19:52:35 ogo-webui-5.5 [7575]: PG0x0x9dfafdc SQL: SELECT
t1.abstract, t1.company_id, t1.creation_date, t1.current_owner_id,
t1.date_id, t1.db_status, t1.document_id, t1.file_type,
t1.first_owner_id, t1.is_folder, t1.is_note, t1.lastmodified_date,
t1.object_version, t1.parent_document_id, t1.project_id, t1.status,
t1.title, t1.version_count FROM  note t1 WHERE t1.parent_document_id=3D67=
5700
Jun 09 19:52:35 ogo-webui-5.5 [7575]: |ogo-webui-5.5|
<OpenGroupware[0x0x8aca8b4]: name=3Dogo-webui-5.5>: caught:
  (Exception name:PostgreSQL72FatalError class:PostgreSQL72Exception
reason:fatal pgsql error (channel=3D<0x0x9dfafdc[PostgreSQL72Channel]:
connection=3D<0x0x9dfb1bc[PGConnection]:  connection=3D0x0x9dfb9e0>>):
FEHLER:  Spalte t1.company_id existiert nicht
 info:<nil>)
in context:
  <0x0x9d643ec[WOContext]: 0064a2ebd8309d643ec app=3Dogo-webui-5.5
sn=3D1D971D97014A2EBD7C eid=3D0064a2ebd8309d643ec.0.17.1.3.b.notes.9 rqei=
d=3D>.

--=20
Dr. Christian Naumer
Senior Scientist Analytics & Engineering

B.R.A.I.N Aktiengesellschaft
Darmstaedter Str. 34-36, D-64673 Zwingenberg
e-mail [email protected], homepage www.brain-biotech.de
fon +49-6251-9331-30  /   fax +49-6251-9331-11

Sitz der Gesellschaft: Zwingenberg/Bergstrasse
Registergericht AG Darmstadt, HRB 24758
Vorstand: Dr. Holger Zinke (Vorsitz), Dr. J=FCrgen Eck
Vorsitzender des Aufsichtsrats: Ulrich Putsch
-- 
OpenGroupware.org Users
[email protected]
http://mail.opengroupware.org/mailman/listinfo/users