Icy Phoenix

Old Support Topics - Error After Upgrade - Could Not Obtain Topic Information

Rene [ Tue 31 Aug, 2010 23:22 ]
Post subject: Error After Upgrade - Could Not Obtain Topic Information

Could not obtain topic information

Hey,

I just upgraded my old IP to the new Version. So long everythink is working fine but everytime when I click on a topic the following message appears:

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

How can I fix this error? If it helps I can create a Forum and FTP User for you.

Regards
Rene

Mighty Gorgon [ Thu 02 Sep, 2010 16:42 ]
Post subject: Re: Error After Upgrade - Could Not Obtain Topic Information

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...

Rene [ Thu 02 Sep, 2010 20:22 ]
Post subject: Re: Error After Upgrade - Could Not Obtain Topic Information

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...

Update Version is: ip_20100117_13053a
Old Version according the ip_version entry in ip_config db table: 1.2.0.27

Do think I can solve the problem by restarting the db upgrade script from the install folder? Maybe I can post the results of the db upgrade script.

Mighty Gorgon [ Thu 02 Sep, 2010 22:32 ]
Post subject: Re: Error After Upgrade - Could Not Obtain Topic Information

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.

Rene [ Thu 02 Sep, 2010 23:27 ]
Post subject: Re: Error After Upgrade - Could Not Obtain Topic Information

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.

Hi, is it also possible to rerun only the db update script? I also have a backup but it would be much faster to only restart the db upgrade.

Mighty Gorgon [ Thu 02 Sep, 2010 23:53 ]
Post subject: Re: Error After Upgrade - Could Not Obtain Topic Information

I can't say if that is the only error.

Make a test, and if it doesn't work, restore your old DB and start again.

Rene [ Sat 04 Sep, 2010 15:22 ]
Post subject: Re: Error After Upgrade - Could Not Obtain Topic Information

I restarted the update and now it is working. What ever was missing.

Following SQL could not be run. Can you tell me if this is a problem?

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

I also have an error with the gallery. When I open a category all thumbnails are shown but some pictures (not all) are not displayed. Here I can the error "picture does not exist"

Mighty Gorgon [ Wed 15 Sep, 2010 22:29 ]
Post subject: Re: Error After Upgrade - Could Not Obtain Topic Information

Did you carefully follow these instructions?

Readme