Again: There was an error while processing a database query

[200366]

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

[Nibbler]

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)

[200366]

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

[Casper]

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.

[200366]

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