Icy Phoenix

     
 


Post new topic  Reply to topic 
Page 1 of 1
 
 
Reply with quote Download Post 
Post 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
 



 
ReneSend private message  
Back to topPage bottom
Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.

Support us
 
Reply with quote Download Post 
Post 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
 
Mighty GorgonSend private messageSend e-mail to userVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post 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.
 



 
ReneSend private message  
Back to topPage bottom
Reply with quote Download Post 
Post 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
 
Mighty GorgonSend private messageSend e-mail to userVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post 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.
 



 
ReneSend private message  
Back to topPage bottom
Reply with quote Download Post 
Post 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
 
Mighty GorgonSend private messageSend e-mail to userVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post 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"
 



 
ReneSend private message  
Back to topPage bottom
Reply with quote Download Post 
Post 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
 
Mighty GorgonSend private messageSend e-mail to userVisit poster's website  
Back to topPage bottom
Post new topic  Reply to topic  Page 1 of 1
 


Display posts from previous:    

HideWas this topic useful?

Link this topic
URL
BBCode
HTML




 
Permissions List
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