Sorry ... after searching in this forum for this error i found a lot of them, but they didn't solve my problem.
There was an error while processing a database query.
While executing query "SELECT msg_id, msg_author, msg_body, UNIX_TIMESTAMP(msg_date) AS msg_date, author_id, author_md5_id, msg_raw_ip, msg_hdr_ip FROM cpg11d_comments WHERE pid='235' ORDER BY msg_id ASC" on 0
mySQL error: Unknown column 'msg_raw_ip' in 'field list'
Datei: /var/www/www.xxxxxxxx.de/gallery/include/functions.inc.php - Zeile: 105
Warning: Constant smilies_php already defined in /var/www/www.xxxxxxxx.de/gallery/include/smilies.inc.php on line 20
Warning: Undefined index: pic_raw_ip in /var/www/www.xxxxxxxx.de/gallery/displayimage.php on line 220
It is right. In the table 'cpg11d_comments' i cant't find this field.
I made an update from 1.1.x to 1.2.1. Following the tips in the readme file the update seems to be ok.
ALTER TABLE cpg11d_comments add msg_raw_ip tinytext Already Done
ALTER TABLE cpg11d_comments add msg_hdr_ip tinytext Already Done
ALTER TABLE cpg11d_pictures add pic_raw_ip tinytext Already Done
ALTER TABLE cpg11d_pictures add pic_hdr_ip tinytext Already Done
INSERT INTO cpg11d_config VALUES ('thumb_use', 'any') Already Done
INSERT INTO cpg11d_config VALUES ('show_private', '0') Already Done
INSERT INTO cpg11d_config VALUES ('first_level', '1') Already Done
INSERT INTO cpg11d_config VALUES ('display_film_strip', '1') Already Done
INSERT INTO cpg11d_config VALUES ('max_film_strip_items', '5') Already Done
INSERT INTO cpg11d_config VALUES ('comment_email_notification', '0') Already Done
CREATE TABLE cpg11d_banned ( ban_id int(11) NOT NULL auto_increment, user_id int(11) DEFAULT NULL, ip_addr tinytext DEFAULT NULL, expiry datetime DEFAULT NULL, PRIMARY KEY (ban_id) ) TYPE=MyISAM Already Done
Can anyone help me?
If you need more informations please ask.
THX
Chris