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:

Code: [Hide] [Select]
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

ip_fst

you can try this
Spoiler: [ Show ]


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:
Code: [Hide] [Select]
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 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 )
Spoiler: [ Show ]


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:
Code: [Hide] [Select]
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)
Spoiler: [ Show ]


Danielc wrote: [View Post]
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.
Code: [Hide] [Select]
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
Danielc wrote: [View Post]
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
Danielc wrote: [View Post]
MMM, it seems that another column is missing.
Code: [Hide] [Select]
MySQL said: Documentation
#1054 - Unknown column 'forum_sort_box' in 'ip_forums'



than first this
Spoiler: [ Show ]


and then
Spoiler: [ Show ]


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
Lopalong wrote: [View Post]
Danielc wrote: [View Post]
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:
Code: [Hide] [Select]
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
Spoiler: [ Show ]


well i have no other ideas then continue to add column by column


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.

Dunno!


Limun [ Sun 31 May, 2009 15:32 ]
Post subject: Re: Icy Phoenix RC 2 Error: Could Not Obtain Topic Information
Danielc wrote: [View Post]

EDIT 2: Yes, it was the last one. Now it seems to work fine. Thanks for everybody!!

good

Lopalong wrote: [View Post]
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.
Dunno!

we shoud try it
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
Danielc wrote: [View Post]
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
Limun wrote: [View Post]
Danielc wrote: [View Post]
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
Danielc wrote: [View Post]
Limun wrote: [View Post]
Danielc wrote: [View Post]
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" ??


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.

PS: Bedtime - - G'night!


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
Danielc wrote: [View Post]
@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 wrote: [View Post]
Danielc wrote: [View Post]
@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
spydie wrote: [View Post]
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.

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.


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
spydie wrote: [View Post]

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.

The same could be said for plugins - - - - -

great_day


spydie [ Mon 01 Jun, 2009 22:32 ]
Post subject: Re: [Solved]Icy Phoenix RC 2 Error: Could Not Obtain Topic Information
Lopalong wrote: [View Post]


great_day


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
spydie wrote: [View Post]
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.

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




Powered by Icy Phoenix