|
Page 1 of 1
|
 Rene 
Joined: November 2007
Posts: 124
|
 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
|
#1 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.
|
| |
Mighty Gorgon
Luca Libralato
Joined: August 2006
Posts: 7191
Location:  Borgo San Michele
|
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...
____________ Luca
SEARCH is the quickest way to get support.
Icy Phoenix ColorizeIt - CustomIcy - HON
|
#2 Thu 02 Sep, 2010 16:42 |
|
Rene
Joined: November 2007
Posts: 124
|
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.
|
#3 Thu 02 Sep, 2010 20:22 |
|
Mighty Gorgon
Luca Libralato
Joined: August 2006
Posts: 7191
Location: Borgo San Michele
|
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.
____________ Luca
SEARCH is the quickest way to get support.
Icy Phoenix ColorizeIt - CustomIcy - HON
|
#4 Thu 02 Sep, 2010 22:32 |
|
Rene
Joined: November 2007
Posts: 124
|
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.
|
#5 Thu 02 Sep, 2010 23:27 |
|
Mighty Gorgon
Luca Libralato
Joined: August 2006
Posts: 7191
Location: Borgo San Michele
|
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.
____________ Luca
SEARCH is the quickest way to get support.
Icy Phoenix ColorizeIt - CustomIcy - HON
|
#6 Thu 02 Sep, 2010 23:53 |
|
Rene
Joined: November 2007
Posts: 124
|
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"
|
#7 Sat 04 Sep, 2010 15:22 |
|
Mighty Gorgon
Luca Libralato
Joined: August 2006
Posts: 7191
Location: Borgo San Michele
|
Re: Error After Upgrade - Could Not Obtain Topic Information
Did you carefully follow these instructions?
Readme
____________ Luca
SEARCH is the quickest way to get support.
Icy Phoenix ColorizeIt - CustomIcy - HON
|
#8 Wed 15 Sep, 2010 22:29 |
|
|
|
Page 1 of 1
|
 Was this topic useful?
 Was this topic useful?
| Link this topic |
|---|
| URL |
|
| BBCode |
|
| HTML |
|
You cannot post new topics
You cannot reply to topics
You cannot edit your posts
You cannot delete your posts
You cannot vote in polls
You cannot attach files
You can download files
You cannot post calendar events
|
|
|
|
