Problems with contacts & projects in Sugarcrm Version 5.1.0a (Build 4837)

[tenzintrepp]

Hello

If I click in SugarCRM on new Task or new Project only a Blank Page shows up. So I cant make any new entries.

When I try to add a Project in the small "New Project"-left Module I get this error:

Error retrieving project tasks Query Failed:SELECT id FROM project_task WHERE project_id = '' AND deleted = 0::MySQL error 1054: Unknown column 'project_id' in 'where clause'

I made a Screencast to show my Problem

Thank you for help


My System Infos:
Betriebssystem: Linux 2.6.9-55.0.2.ELsmp
IP Adresse: 194.126.200.24
Servername: server14
Apache: 2.2.9 (Unix)
PHP Versionen: 5.2.6
Perl: 5.8.8
Perl-Pfad: /usr/bin/perl
Sendmail-Pfad: /usr/sbin/sendmail
mySQL Version: 5.0.51a-community

[andopes]

Hi tenzintrepp

How did you get this installation?
is it a clean installation or had you upgraded another one?
Did you install any package into it?
According to your screencast there is a missed relationship.
Try to do the following:
Go to Admin -> Repair
Rebuild Extension
Rebuild Relationship
Repair Database

Take a look at the sugarcrm.log at the root of system.
Check if the last lines (focus on date time of the records) contains any error.

Let us know the tail of the sugarcrm.log