Visual Phonebook - An error has occured

[FreshConnexions]

Hi,

I have installed fop2 and configured as below:

cd /var/www/html/fop2
mysqladmin -u root -peLaStIx.2oo7 create fop2
mysql -u root -peLaStIx.2oo7 < mysql.db
mysql -u root -peLaStIx.2oo7 -e
"grant all privileges on fop2.* to fop2@'localhost'
identified by 'myPassw0rd'"

edit: /var/www/html/fop2/config.php
<?
// Database connection details
$DBHOST = 'localhost';
$DBNAME = 'fop2';
$DBUSER = 'fop2';
$DBPASS = 'myPassw0rd';

Whenever i open visual phonebook or try and add an entry i get a message saying an error has occured

Runing PHP 5.2 and sql 5.0

if i do **mysql -u root -pXXXXX fop2 -e "desc visual_phonebook" ** i get;

[root@elastix ~]# mysql -u root -peLaStIx.2oo7 fop2 -e "desc visual_phonebook"
+-----------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------+------------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| firstname | varchar(50) | YES | MUL | NULL | |
| lastname | varchar(50) | YES | | NULL | |
| company | varchar(100) | YES | | NULL | |
| phone1 | varchar(50) | YES | | NULL | |
| phone2 | varchar(50) | YES | | NULL | |
| owner | varchar(50) | YES | | | |
| private | enum('yes','no') | YES | | no | |
| picture | varchar(100) | YES | | NULL | |
| context | varchar(150) | YES | | | |
+-----------+------------------+------+-----+---------+----------------+

Any ideas where i have gone wrong.

Thanks Dan

[nicolas]

So you CAN open the phonebook, it appears with no records, and when you try to add it gives you an error. Can you write that error exactly? There is one command that lackats the "fop2" database but you have the table created as you have shown..