An error has ocurried Unknown field :picture
After configuring the visual phonebook in the paragraph : Configuring Visual phonebook,the error continued.
((((my MYSQL root password is 'root')))
[root@centos init.d]# service mysqld start
Iniciando MySQL: [ OK ]
[root@centos fop2]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.0.77 Source distribution
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> show databases;
+
+
| Database |
+
+
| information_schema |
| fop2 |
| mysql |
| test |
+
+
4 rows in set (0.01 sec)
mysql> use fop2
Database changed
mysql> show tables;
Empty set (0.00 sec)
[root@centos fop2]# mysql -u root -proot < mysql.db
mysql> GRANT ALL on fop2.* TO fop2@localhost IDENTIFIED BY 'root';
Query OK, 0 rows affected (0.00 sec)
mysql> exit
Bye.
[root@centos fop2]# service fop2 restart
Shutting dows Flash Operator Panel 2: [ OK ]
Starting Flash Operator Panel 2: [ OK ]
config.php
<?
// Database connection details
$DBHOST = 'localhost';
$DBNAME = 'fop2';
$DBUSER = 'fop2';
$DBPASS = 'root';
$language="en";
((((my MYSQL root password is 'root')))
[root@centos init.d]# service mysqld start
Iniciando MySQL: [ OK ]
[root@centos fop2]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.0.77 Source distribution
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> show databases;
+
+
| Database |
+
+
| information_schema |
| fop2 |
| mysql |
| test |
+
+
4 rows in set (0.01 sec)
mysql> use fop2
Database changed
mysql> show tables;
Empty set (0.00 sec)
[root@centos fop2]# mysql -u root -proot < mysql.db
mysql> GRANT ALL on fop2.* TO fop2@localhost IDENTIFIED BY 'root';
Query OK, 0 rows affected (0.00 sec)
mysql> exit
Bye.
[root@centos fop2]# service fop2 restart
Shutting dows Flash Operator Panel 2: [ OK ]
Starting Flash Operator Panel 2: [ OK ]
config.php
<?
// Database connection details
$DBHOST = 'localhost';
$DBNAME = 'fop2';
$DBUSER = 'fop2';
$DBPASS = 'root';
$language="en";
Comments
There is no need to restart the fop2 service if you change the php config files or even the php scripts themselves. Have you tried to connect to mysql via command line with the user you created? Everything seems to be ok... can you run other php/mysql scripts like phpmyadmin, etc?
I don't understand this.