Error After Upgrade - Could Not Obtain Topic Information
| Article |
|---|
 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
|
|
Rene [ Tue 31 Aug, 2010 23:22 ]
|
 |
Sponsors
|
Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.
|
|
Error After Upgrade - Could Not Obtain Topic Information
| Comments |
|---|
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...
|
|
Mighty Gorgon [ Thu 02 Sep, 2010 16:42 ]
|
|
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...
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.
|
|
Rene [ Thu 02 Sep, 2010 20:22 ]
|
|
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.
|
|
Mighty Gorgon [ Thu 02 Sep, 2010 22:32 ]
|
|
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.
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.
|
|
Rene [ Thu 02 Sep, 2010 23:27 ]
|
|
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.
|
|
Mighty Gorgon [ Thu 02 Sep, 2010 23:53 ]
|
|
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"
|
|
Rene [ Sat 04 Sep, 2010 15:22 ]
|
|
Re: Error After Upgrade - Could Not Obtain Topic Information |
Did you carefully follow these instructions?
Readme
|
|
Mighty Gorgon [ Wed 15 Sep, 2010 22:29 ]
|
|
|
|
 Was this topic useful?
 Was this topic useful?
|
Page 1 of 1
|
|
|
