Icy Phoenix
Old Support Topics - [Solved]Icy Phoenix RC 2 Error: Could Not Obtain Topic Information
Danielc [ Sun 31 May, 2009 06:20 ]
Post subject: [Solved]Icy Phoenix RC 2 Error: Could Not Obtain Topic Information
Hello Everybody...
Before all, i tried to search this problem, and i found a similar case, i read it but i can't solve my problem..
In the main page, i'm using IP 1.2.0.27c. I decided to test the latest version of IP: RC2. My web page is danielc.host22.com , but i'm doing my tests in danielc.host22.com/ip/ ...
In the first time, i tried to update my IP setup using the steps in this page, but i had some errors, and i decided to begin again. Later, i found another steps in the readme file, but i don't know of these steps are correct, so i didn't follow these. In this time, i tried to do a fresh installation, but updating my BD and using it. The problem is that i can view the forums and see the title of topics there, but when i try to view a topic, i get the following error:
Could not obtain topic information
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.* FROM ip_topics t, ip_forums f, ip_forums_rules fr WHERE t.topic_id = '15' AND f.forum_id = t.forum_id AND fr.forum_id = t.forum_id
Line : 259
File : viewtopic.php
Thanks and sorry for my english xD, i'm from Colombia.
Limun [ Sun 31 May, 2009 10:40 ]
Post subject: Re: Icy Phoenix RC 2 Error: Could Not Obtain Topic Information
can you check if you have this in your database
a column
forum_similar_topics in ip_forums table
you can try this
ALTER TABLE ip_forums ADD `forum_similar_topics` TINYINT(1) NOT NULL DEFAULT '0' AFTER `forum_notify`;
Danielc [ Sun 31 May, 2009 14:08 ]
Post subject: Re: Icy Phoenix RC 2 Error: Could Not Obtain Topic Information
I don't know so much about MySQL, and i don't know where i must paste the code, but i tried to do this manually. I think that it worked, but now, i get the following error:
Could not obtain topic information
DEBUG MODE
SQL Error : 1054 Unknown column 'f.forum_topic_views' 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.* FROM ip_topics t, ip_forums f, ip_forums_rules fr WHERE t.topic_id = '15' AND f.forum_id = t.forum_id AND fr.forum_id = t.forum_id
Thanks!
Line : 259
File : viewtopic.php
Limun [ Sun 31 May, 2009 14:39 ]
Post subject: Re: Icy Phoenix RC 2 Error: Could Not Obtain Topic Information
seems that your update didnt went good :shock: somehow
as i see your database are missing lot tables
anyway now its this suposed to be (you can do it in your phpmyadmin if you click on "SQL" in tabs on top )
ALTER TABLE phpbb_forums ADD `forum_topic_views` TINYINT(1) NOT NULL DEFAULT '1' AFTER `forum_similar_topics`;
Danielc [ Sun 31 May, 2009 14:48 ]
Post subject: Re: Icy Phoenix RC 2 Error: Could Not Obtain Topic Information
There are a lot of errors . Now it says this:
Could not obtain topic information
DEBUG MODE
SQL Error : 1054 Unknown column 'f.forum_kb_mode' 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.* FROM ip_topics t, ip_forums f, ip_forums_rules fr WHERE t.topic_id = '15' AND f.forum_id = t.forum_id AND fr.forum_id = t.forum_id
Line : 259
File : viewtopic.php
I don't know why it didn't update correctly, but i have seen that my server has a delay. Sometimes, when i access to the ACP, it says some errors, but when i refresh the page, it loads correctly. Could this affect the update progress? .
Anyway, thanks for the help.
Limun [ Sun 31 May, 2009 15:01 ]
Post subject: Re: Icy Phoenix RC 2 Error: Could Not Obtain Topic Information
this one now (i wonder when it stop)
ALTER TABLE ip_forums ADD `forum_kb_mode` TINYINT(1) NOT NULL DEFAULT '0' AFTER `forum_sort_box`;
but i have seen that my server has a delay. Sometimes, when i access to the ACP, it says some errors, but when i refresh the page, it loads correctly. Could this affect the update progress? .
i have no idea :?
Danielc [ Sun 31 May, 2009 15:05 ]
Post subject: Re: Icy Phoenix RC 2 Error: Could Not Obtain Topic Information
MMM, it seems that another column is missing.
MySQL said: Documentation
#1054 - Unknown column 'forum_sort_box' in 'ip_forums'
Lopalong [ Sun 31 May, 2009 15:06 ]
Post subject: Re: Icy Phoenix RC 2 Error: Could Not Obtain Topic Information
I don't know why it didn't update correctly.
Did you install a fresh copy of IP-RC2 and are now trying to run it with a "Copy" or the original of your ip27* database ?
Limun [ Sun 31 May, 2009 15:13 ]
Post subject: Re: Icy Phoenix RC 2 Error: Could Not Obtain Topic Information
MMM, it seems that another column is missing.
MySQL said: Documentation
#1054 - Unknown column 'forum_sort_box' in 'ip_forums'
than first this
ALTER TABLE ip_forums ADD `forum_sort_box` TINYINT(1) NOT NULL DEFAULT '0' AFTER `forum_tags`;
and then
ALTER TABLE ip_forums ADD `forum_kb_mode` TINYINT(1) NOT NULL DEFAULT '0' AFTER `forum_sort_box`;
but this go to infinity
i have better idea
lets try again
database_update.php (upload install folder of RC2 in your danielc.host22.com/ip/...)
and log in as admin and than do a update danielc.host22.com/ip/install/database_update.php
Danielc [ Sun 31 May, 2009 15:16 ]
Post subject: Re: Icy Phoenix RC 2 Error: Could Not Obtain Topic Information
I don't know why it didn't update correctly.
Did you install a fresh copy of IP-RC2 and are now trying to run it with a "Copy" or the original of your ip27* database ?
MMM, yes, something like that. But i updated my copy of ip 1.27 database ..
Anyway, i did some changes. There was another two columns missing, so i add these seeing your screenshot. Now the error is the following:
Could not obtain forum information
DEBUG MODE
SQL Error : 1054 Unknown column 'forum_thanks' in 'field list'
SELECT forum_thanks FROM ip_forums WHERE forum_id = '1' LIMIT 1
Line : 300
File : viewtopic.php
EDIT:
Before posting here, i tried to execute database_update again, but it says that my version is up to date...
It seems that forum_thanks is the last column missing...
EDIT 2: Yes, it was the last one. Now it seems to work fine. Thanks for everybody!!
Limun [ Sun 31 May, 2009 15:20 ]
Post subject: Re: Icy Phoenix RC 2 Error: Could Not Obtain Topic Information
ALTER TABLE ip_forums ADD `forum_thanks` TINYINT(1) NOT NULL DEFAULT '0' AFTER `forum_postcount`;
well i have no other ideas then continue to add column by column :oops:
Lopalong [ Sun 31 May, 2009 15:27 ]
Post subject: Re: [Solved]Icy Phoenix RC 2 Error: Could Not Obtain Topic Information
Good job Limun! ;)
Considering all of these updates are in database_update.php, one wonders if going to RC2 without upgrading to RC1 first may have created this problem. :shock:
Dunno! :mricy:
Limun [ Sun 31 May, 2009 15:32 ]
Post subject: Re: Icy Phoenix RC 2 Error: Could Not Obtain Topic Information
EDIT 2: Yes, it was the last one. Now it seems to work fine. Thanks for everybody!!
good :mrorange:
Considering all of these updates are in database_update.php, one wonders if going to RC2 without upgrading to RC1 first may have created this problem. :shock:
Dunno! :mricy:
we shoud try it :mrorange:
i have some IP 1.2.0.27c on my local i will try update it directly to RC2
Danielc [ Sun 31 May, 2009 15:35 ]
Post subject: Re: [Solved]Icy Phoenix RC 2 Error: Could Not Obtain Topic Information
MMM, i could fix the error of this topic, but the database has a lot of errors. I can't see my news, and i can't create a new subforum. I don't know why it didn´t update correctly.. Will it work correctly if i update the original database to rc1 and after to rc2?
Limun [ Sun 31 May, 2009 15:38 ]
Post subject: Re: [Solved]Icy Phoenix RC 2 Error: Could Not Obtain Topic Information
MMM, i could fix the error of this topic, but the database has a lot of errors. I can't see my news, and i can't create a new subforum. I don't know why it didn´t update correctly.. Will it work correctly if i update the original database to rc1 and after to rc2?
yes this how it supose to be , i didnt tryed from IP 1.2.0.27c to RC2
anyway put here errors what you get while upgradeing (they are with red letters i think)
Danielc [ Sun 31 May, 2009 15:44 ]
Post subject: Re: [Solved]Icy Phoenix RC 2 Error: Could Not Obtain Topic Information
MMM, i could fix the error of this topic, but the database has a lot of errors. I can't see my news, and i can't create a new subforum. I don't know why it didn´t update correctly.. Will it work correctly if i update the original database to rc1 and after to rc2?
yes this how it supose to be , i didnt tryed from IP 1.2.0.27c to RC2
anyway put here errors what you get while upgradeing (they are with red letters i think)
Ok, first i'm trying to update to RC1 and after to RC2.. Later, i backup the database, and restore the original one, i do the update to rc2, and post here the errors.
Limun [ Sun 31 May, 2009 15:46 ]
Post subject: Re: [Solved]Icy Phoenix RC 2 Error: Could Not Obtain Topic Information
MMM, i could fix the error of this topic, but the database has a lot of errors. I can't see my news, and i can't create a new subforum. I don't know why it didn´t update correctly.. Will it work correctly if i update the original database to rc1 and after to rc2?
yes this how it supose to be , i didnt tryed from IP 1.2.0.27c to RC2
anyway put here errors what you get while upgradeing (they are with red letters i think)
Ok, first i'm trying to update to RC1 and after to RC2.. Later, i backup the database, and restore the original one, i do the update to rc2, and post here the errors.
what do you mean "original" ?? :shock:
Lopalong [ Sun 31 May, 2009 15:53 ]
Post subject: Re: [Solved]Icy Phoenix RC 2 Error: Could Not Obtain Topic Information
@ Daniel
It's normal to update the database first - before you upload the new version files. Can save a lot
of problems. ;)
Quote:
Upload install folder to the root of your Icy Phoenix and launch database_update.php (i.e.
http://www.mysite.com/ip/install/database_update.php).
Then:
Upload all Icy Phoenix files (all but config.php) in the same folder where Icy Phoenix was installed and running. Pay attention that all older files eventually still there must be replaced by new ones.
And hopefully you wont have any problems. :mricy:
PS: Bedtime - - G'night! :P
Danielc [ Sun 31 May, 2009 16:04 ]
Post subject: Re: [Solved]Icy Phoenix RC 2 Error: Could Not Obtain Topic Information
@Limun: the 1.2.27 database.
@Lopalong: MMM, ok, i will do that now!
Limun [ Sun 31 May, 2009 16:07 ]
Post subject: Re: [Solved]Icy Phoenix RC 2 Error: Could Not Obtain Topic Information
@Limun: the 1.2.27 database.
@Lopalong: MMM, ok, i will do that now!
no man , you cant restore 1.2.27 database on RC2 database
you have to upgrade 1.2.27 database to RC2 database
spydie [ Sun 31 May, 2009 16:13 ]
Post subject: Re: [Solved]Icy Phoenix RC 2 Error: Could Not Obtain Topic Information
Someone should tell this to MG.
Because if everyone will have this problem, then we´re in the sh**ter
Danielc [ Sun 31 May, 2009 16:46 ]
Post subject: Re: [Solved]Icy Phoenix RC 2 Error: Could Not Obtain Topic Information
@Limun: the 1.2.27 database.
@Lopalong: MMM, ok, i will do that now!
no man , you cant restore 1.2.27 database on RC2 database
you have to upgrade 1.2.27 database to RC2 database
Yeah, i know, i said that i will do some tests beginning again with the original DB
Lopalong [ Sun 31 May, 2009 23:30 ]
Post subject: Re: [Solved]Icy Phoenix RC 2 Error: Could Not Obtain Topic Information
Someone should tell this to MG.
Because if everyone will have this problem, then we´re in the sh**ter
It's usually what happens when people do things the wrong way round. :mrgreen:
In theory one can upload all the RC files first - not log in or anything else, and then use phpMyAdmin SQL to update the database.
BUT! in this case the upgrade dump is not configured for direct injection. So one
HAS to do it the way the
instructions tells one
how to do it. :P
spydie [ Mon 01 Jun, 2009 12:57 ]
Post subject: Re: [Solved]Icy Phoenix RC 2 Error: Could Not Obtain Topic Information
Thats why my wife prefers SMF for her forum.
The updates do everything without needing to interfier there.
Just upload update and run install. everything else goes by itself
Limun [ Mon 01 Jun, 2009 13:02 ]
Post subject: Re: [Solved]Icy Phoenix RC 2 Error: Could Not Obtain Topic Information
Just upload update and run install. everything else goes by itself
thats not true
if you have lot of packages and some diferrent style then you need to edit lot of things
spydie [ Mon 01 Jun, 2009 13:05 ]
Post subject: Re: [Solved]Icy Phoenix RC 2 Error: Could Not Obtain Topic Information
Ok but the main update runs swiftly. and it updates a lot of Mod´s itself.
well that happend with 2.04 to RC1 and to RC1.1
Lopalong [ Mon 01 Jun, 2009 22:30 ]
Post subject: Re: [Solved]Icy Phoenix RC 2 Error: Could Not Obtain Topic Information
Hooray for SMF and all the other forum software that auto-upgrades, But this is Icy Phoenix and it doesn't. :P
The same could be said for plugins - - - - - :mricy:
spydie [ Mon 01 Jun, 2009 22:32 ]
Post subject: Re: [Solved]Icy Phoenix RC 2 Error: Could Not Obtain Topic Information
Any special proggie to do this ??
anyway my wife´s forum is Smf .
mine keep´s beeing IP.
just thought that it would be nice if Icy could update that easy. that´s all
Danielc [ Tue 02 Jun, 2009 00:34 ]
Post subject: Re: [Solved]Icy Phoenix RC 2 Error: Could Not Obtain Topic Information
Hello everybody!!..
Well, i tried again to update my IP, and it updated successful. I follow the official instructions, but i get the same problem of the beginning, my forum didn't update the config.php correctly, so it searched for install folder. I follow some instructions in this forum, and now it works very well.. Thanks for all!!
Lopalong [ Tue 02 Jun, 2009 00:49 ]
Post subject: Re: [Solved]Icy Phoenix RC 2 Error: Could Not Obtain Topic Information
Good news Daniel. ;)
@Spydie.
I got it in an email - You would no doubt need a gif animator that creates onions to make something the same. ;)
spydie [ Tue 02 Jun, 2009 09:06 ]
Post subject: Re: [Solved]Icy Phoenix RC 2 Error: Could Not Obtain Topic Information
you´ve got to use the original config.php Daniel.
you haven´t read the instructions well.
Quote:
# Remove all files but config.php in your Icy Phoenix root (make sure you don't have some files you may need for some mods you have installed, but in any case you should have a backup Backup Rules!).
# Upload all Icy Phoenix files (all but config.php) in the same folder where Icy Phoenix was installed and running. Pay attention that all older files still there (if any) must be replaced by the new ones.
Danielc [ Tue 02 Jun, 2009 23:30 ]
Post subject: Re: [Solved]Icy Phoenix RC 2 Error: Could Not Obtain Topic Information
you´ve got to use the original config.php Daniel.
you haven´t read the instructions well.
Quote:
# Remove all files but config.php in your Icy Phoenix root (make sure you don't have some files you may need for some mods you have installed, but in any case you should have a backup Backup Rules!).
# Upload all Icy Phoenix files (all but config.php) in the same folder where Icy Phoenix was installed and running. Pay attention that all older files still there (if any) must be replaced by the new ones.
MMM, i understand that i should remove all files, but keep the config.php file.
Anyway, i have solved it xD..
Lopalong [ Wed 10 Jun, 2009 05:08 ]
Post subject: Re: [Solved]Icy Phoenix RC 2 Error: Could Not Obtain Topic Information
I owe you an apology Daniel for suggesting that you did it the wrong way, because I also tried to upgrade RC1 to RC2 and it all went bad with the same errors you had, plus a few extra. :oops:
But unlike you, I can't be bothered fixing them and may wait until I see what the next final release pans out to be, and how much Official Support it gets. ;)
Danielc [ Thu 11 Jun, 2009 00:12 ]
Post subject: Re: [Solved]Icy Phoenix RC 2 Error: Could Not Obtain Topic Information
There is no problem!! You helped me and it is the most important!.. But, i tried to update from 1.2.27 and not from RC1, so, there must be some errors in the installation. However, i just follow the instructions again and it worked fine xD..
