Can't Login into CRM

[pharao.ramses@…]

Hello,
I installed lx-office CRM after I had installed ERP. ERP works well. I use
the user ots for login. The database which I created during installation of
ERP are "ots".
The install.php-Script find this user; all tables are installed
successfully. If I now want to login I get following error:

select id,pre,workphone,status from employee where login='ots' and
pwd='lxsystem' : DB Error: unknown error

conf.php
<?

$user="ots";
$pass="ots";
$host="localhost";
$dbname="ots";
$dns="pgsql://$user:$pass@$host/$dbname";
$bgcol[1]="#ddddff";
$bgcol[2]="#ddffdd";
$bgcol[3]="#ff6666";
$bgcol[4]="#fffa05";
$typcolT?="#f3f702";
$typcolM?="#18f204";
$typcolS?="#07d3f7";
$typcolP?="#f70727";
$typcolP?="#ea0bd0";
$typcolD?="#fffa05";
$typcolX?="#fa05ff";
$showErr = true;

?>

I queried the postgresql-Table employee:

ots=# select * from employee;

id | login | name | addr1 | addr2 | addr3 | addr4 | workphone |

homephone | startdate | enddate | notes | role | sales | pwd | msrv |
postf | kennw | postf2 | abteilung | position | interv | pre | vertreter |
mailsign | email | status

---

376 | ots | ots | | | | | |

| 2004-08-15 | | | user | t | lxsystem | |

| | | | | | | |

| |

389 | crmadm | Crm Admin | | | | | |

| 2004-08-16 | | | user | t | lxsystem | |

| | | | | | | |

| | 1

(2 rows)

Result of query in postgresql:

ots=# select id,pre,workphone,status from employee where login='ots' and
pwd='lxsystem';

id | pre | workphone | status

---

376 | | |

(1 row)

What's wrong??

Regards

There is no bug.

The Rights are ok?

psql -U ots ots
ots=# \d
.
ots=#select id,pre,workphone,status from employee where login='ots' and
pwd='lxsystem';