An error has ocurried Unknown field :picture

DavidinDavidin
in Support
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";

Comments

  • ThomasThomas
    Log-in to mysql and then
    use fop2;
select * from visual_phonebook;
    do you see the picture column?

    also goto 
    /var/www/html/fop2/
    edit config.php

    Change 
    define('DEBUG',false);
    to 
    define('DEBUG',true);
    save and upload, goto [url=http://YOUR_SERVER_IP/fop2/phonebook.php]http://YOUR_SERVER_IP/fop2/phonebook.php[/url]
    and paste the output here
  • DavidinDavidin
    1)

    mysql> use fop2;
    Database changed
    mysql> select * from visual_phonebook;
    ERROR 1146 (42S02):Table 'fop2.visual_phonebook' doesn´t exist


    2)edit config.php

    notice
    /var/www/html/fop2/lib/dblib.php (line 233)

    mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource
    notice
    /var/www/html/fop2/lib/dblib.php (line 233)

    mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource

    An error has occurred

    Unknown field: picture
    notice
    /var/www/html/fop2/lib/dblib.php (line 344)

    mysql_num_fields(): supplied argument is not a valid MySQL result resource
    notice
    /var/www/html/fop2/lib/dblib.php (line 333)

    mysql_num_rows(): supplied argument is not a valid MySQL result resource

    No records found
    notice
    /var/www/html/fop2/lib/dblib.php (line 244)

    mysql_fetch_row(): supplied argument is not a valid MySQL result resource
  • ThomasThomas
    Hows about
    mysql -u root -proot
use fop2;

    copy all and paste to console screen
    CREATE TABLE `visual_phonebook` (
  `id` int(11) NOT NULL auto_increment,
  `firstname` varchar(50) default NULL,
  `lastname` varchar(50) default NULL,
  `company` varchar(100) default NULL,
  `phone1` varchar(25) default NULL,
  `phone2` varchar(25) default NULL,
  `picture` varchar(100) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

    and then
    show columns from visual_phonebook;
+-----------+--------------+------+-----+---------+----------------+
| Field     | Type         | Null | Key | Default | Extra          |
+-----------+--------------+------+-----+---------+----------------+
| id        | int(11)      | NO   | PRI | NULL    | auto_increment |
| firstname | varchar(50)  | YES  |     | NULL    |                |
| lastname  | varchar(50)  | YES  |     | NULL    |                |
| company   | varchar(100) | YES  |     | NULL    |                |
| phone1    | varchar(25)  | YES  |     | NULL    |                |
| phone2    | varchar(25)  | YES  |     | NULL    |                |
| picture   | varchar(100) | YES  |     | NULL    |                |
+-----------+--------------+------+-----+---------+----------------+
7 rows in set (0.00 sec)

    for testing
    insert into visual_phonebook(firstname, lastname, phone1) values('john', 'doe', '0141123456');
select * from visual_phonebook;
+----+-----------+----------+---------+------------+--------+---------+
| id | firstname | lastname | company | phone1     | phone2 | picture |
+----+-----------+----------+---------+------------+--------+---------+
|  1 | john      | doe      | NULL    | 0141123456 | NULL   | NULL    |
+----+-----------+----------+---------+------------+--------+---------+
1 row in set (0.00 sec)
  • DavidinDavidin
    Ok Thanks!!!

    But not everything is correct.
    This error has not been solved.

    notice
    /var/www/html/fop2/lib/dblib.php (line 233)

    mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource
    dblib.php

    /**
    * Fetch results by associative array
    *
    * @param mixed $query Select query or database result
    * @return array Row
    */
    public function fetch_assoc($query = false) {
    $this->res_type($query);
    return mysql_fetch_assoc($query); <<<<<<<<
    LINE 233
    }
  • ThomasThomas
    I suppose you could do something like
    public function fetch_assoc($query = false) {
        $this->res_type($query);
	 if($query and !is_bool($query)) { 
  		return mysql_fetch_assoc($query); 
	 } 
 }
    But my PHP isn't very good so if Nicolas could confirm that this isn't going to bork anything :D
  • DavidinDavidin
    OKKKKKK !!!!! tHANKS tHOMAS.Error solved.
Sign In or Register to comment.

© Asternic Corp 2024