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
1. Can you make the database changes manually ?
2. Are the changes being made in a different database to the one coppermine is actually using ? (unlikely, but i may as well ask)
yes .. i can.
I've inserted the two fields
msg_hdr_ip
msg_raw_ip
Now there are other errors:
Warning: Constant smilies_php already defined in /var/www/www.xxxxxxx.de/gallery/include/smilies.inc.php on line 20
Warning: Undefined index: pic_raw_ip in /var/www/www.xxxxxxx.de/gallery/displayimage.php on line 220
and
Warning: Undefined variable: header in /var/www/www.xxxxxxx.de/gallery/themes/water_drop/theme.php on line 1354
Warning: Undefined variable: template_tab_display in /var/www/www.xxxxxxx.de/gallery/themes/water_drop/theme.php on line 1359
Warning: Undefined variable: lang_thumb_view in /var/www/www.xxxxxxx.de/gallery/themes/water_drop/theme.php on line 1362
Warning: Undefined index: inactive_tab in /var/www/www.xxxxxxx.de/gallery/themes/water_drop/theme.php on line 1363
These warnings are not a problem, just something that needs to be sorted in the code in future versions. They do not pose a threat or create failure of the program. They will disappear when you turn debug off. :wink:
If your original problem with the database is now sorted, turn off debug, and please let us know if all is working correctly now.
After editing the database there where a lot of other problems. I decided to make a new cpg 1.2.x installation. Now it works.
Thanks for the help
Chris