Icy Phoenix

Quote:

DEBUG MODE

SQL Error : 1054 Unknown column 'f.forum_similar_topics' in 'field list'

SELECT t.topic_id, t.topic_title, t.topic_status, t.topic_replies, t.topic_time, t.topic_type, t.topic_vote, t.topic_last_post_id, t.title_compl_infos, t.topic_first_post_id, t.topic_calendar_time, t.topic_calendar_duration, t.topic_reg, f.forum_name, f.forum_status, f.forum_id, f.forum_similar_topics, f.forum_topic_views, f.forum_kb_mode, f.auth_view, f.auth_read, f.auth_post, f.auth_reply, f.auth_edit, f.auth_delete, f.auth_sticky, f.auth_announce, f.auth_pollcreate, f.auth_vote, f.auth_attachments, f.auth_download, t.topic_attachment, f.forum_rules, f.auth_ban, f.auth_greencard, f.auth_bluecard, fr.*, COUNT(p2.post_id) AS prev_posts FROM ip_topics t, ip_forums f, ip_forums_rules fr, ip_posts p, ip_posts p2 WHERE p.post_id = '24391' AND t.topic_id = p.topic_id AND p2.topic_id = p.topic_id AND p2.post_id <= '24391' AND f.forum_id = t.forum_id AND fr.forum_id = t.forum_id GROUP BY p.post_id, t.topic_id, t.topic_title, t.topic_status, t.topic_replies, t.topic_time, t.topic_type, t.topic_vote, t.topic_last_post_id, f.forum_name, f.forum_status, f.forum_id, f.auth_view, f.auth_read, f.auth_post, f.auth_reply, f.auth_edit, f.auth_delete, f.auth_sticky, f.auth_announce, f.auth_pollcreate, f.auth_vote, f.auth_attachments, f.auth_download, t.topic_attachment, f.auth_ban, f.auth_greencard, f.auth_bluecard ORDER BY p.post_id ASC

Line : 259
File : viewtopic.php

Mighty Gorgon wrote: [View Post]

Can you please tell me which version did you have and which one are you updating to?

I think you are trying to install an SVN version...

Mighty Gorgon wrote: [View Post]

Unfortunately it seems you didn't update correctly. Please restore the old db (I hope you have a backup) and try again to update by carefully following instructions.

Quote:

# INSERT INTO `ip_config` (config_name, config_value) VALUES ('link_this_topic', '0')
+++ Fehler: Duplicate entry 'link_this_topic' for key 1

# ALTER TABLE `ip_cms_blocks` ADD `border` TINYINT(1) SET DEFAULT '1' AFTER `border_explain`
+++ Fehler: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SET DEFAULT '1' AFTER `border_explain`' at line 1

# ALTER TABLE `ip_cms_blocks` ADD `titlebar` TINYINT(1) SET DEFAULT '1' AFTER `border`
+++ Fehler: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SET DEFAULT '1' AFTER `border`' at line 1

# UPDATE `ip_cms_blocks` SET border= '0' WHERE border_explain= '0,0,0,0'
+++ Fehler: Unknown column 'border_explain' in 'where clause'

# UPDATE `ip_cms_blocks` SET border= '1' WHERE border_explain= '1,1,1,1'
+++ Fehler: Unknown column 'border_explain' in 'where clause'

# UPDATE `ip_cms_blocks` SET titlebar= '0' WHERE titlebar_explain= '0,0'
+++ Fehler: Unknown column 'titlebar_explain' in 'where clause'

# UPDATE `ip_cms_blocks` SET titlebar= '1' WHERE titlebar_explain= '1,1'
+++ Fehler: Unknown column 'titlebar_explain' in 'where clause'

# ALTER TABLE ip_registration_desc DROP `reg_option1`
+++ Fehler: Can't DROP 'reg_option1'; check that column/key exists

# ALTER TABLE ip_registration_desc DROP `reg_option2`
+++ Fehler: Can't DROP 'reg_option2'; check that column/key exists

# ALTER TABLE ip_registration_desc DROP `reg_option3`
+++ Fehler: Can't DROP 'reg_option3'; check that column/key exists

# INSERT INTO ip_config VALUES ('ip_version', '1.3.0.53a')
+++ Fehler: Duplicate entry 'ip_version' for key 1