https://www.icyphoenix.com/viewtopic.php?f=35&t=5927
-----------------------------------
Danielc
Sun 31 May, 2009 06:20

[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 linenumbers=false]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[/code]

Thanks and sorry for my english xD, i'm from Colombia.


-----------------------------------
Limun
Sun 31 May, 2009 10:40

Re: Icy Phoenix RC 2 Error: Could Not Obtain Topic Information
-----------------------------------
can you check if you have this in your database

a column [b]forum_similar_topics[/b] in ip_forums table

 [img]http://www.icyphoenix.com/files/images/3336/ip_fst.png[/img]

you can try this
[spoiler]ALTER TABLE ip_forums ADD `forum_similar_topics` TINYINT(1) NOT NULL DEFAULT '0' AFTER `forum_notify`;[/spoiler]


-----------------------------------
Danielc
Sun 31 May, 2009 14:08

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 linenumbers=false]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[/code]

Thanks!
Line : 259
File : viewtopic.php


-----------------------------------
Limun
Sun 31 May, 2009 14:39

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 )
[spoiler]ALTER TABLE phpbb_forums ADD `forum_topic_views` TINYINT(1) NOT NULL DEFAULT '1' AFTER `forum_similar_topics`;[/spoiler]


-----------------------------------
Danielc
Sun 31 May, 2009 14:48

Re: Icy Phoenix RC 2 Error: Could Not Obtain Topic Information
-----------------------------------
There are a lot of errors . Now it says this:
[code linenumbers=false]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[/code]
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

Re: Icy Phoenix RC 2 Error: Could Not Obtain Topic Information
-----------------------------------
this one now (i wonder when it stop)
[spoiler]ALTER TABLE ip_forums ADD `forum_kb_mode` TINYINT(1) NOT NULL DEFAULT '0' AFTER `forum_sort_box`;[/spoiler]

[quote user="Danielc" post="40050"]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? .
[/quote]
i have no idea  :?


-----------------------------------
Danielc
Sun 31 May, 2009 15:05

Re: Icy Phoenix RC 2 Error: Could Not Obtain Topic Information
-----------------------------------
MMM, it seems that another column is missing.
[code linenumbers=false] MySQL said: Documentation
#1054 - Unknown column 'forum_sort_box' in 'ip_forums' [/code]


-----------------------------------
Lopalong
Sun 31 May, 2009 15:06

Re: Icy Phoenix RC 2 Error: Could Not Obtain Topic Information
-----------------------------------
[quote user="Danielc" post="40050"]I don't know why it didn't update correctly.[/quote]

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

Re: Icy Phoenix RC 2 Error: Could Not Obtain Topic Information
-----------------------------------
[quote user="Danielc" post="40052"]MMM, it seems that another column is missing.
[code linenumbers=false] MySQL said: Documentation
#1054 - Unknown column 'forum_sort_box' in 'ip_forums' [/code][/quote]


than first this
[spoiler]ALTER TABLE ip_forums ADD `forum_sort_box` TINYINT(1) NOT NULL DEFAULT '0' AFTER `forum_tags`;[/spoiler]

and then 
[spoiler]ALTER TABLE ip_forums ADD `forum_kb_mode` TINYINT(1) NOT NULL DEFAULT '0' AFTER `forum_sort_box`;[/spoiler]

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

Re: Icy Phoenix RC 2 Error: Could Not Obtain Topic Information
-----------------------------------
[quote user="Lopalong" post="40053"][quote user="Danielc" post="40050"]I don't know why it didn't update correctly.[/quote]

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 ?[/quote]
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 linenumbers=false]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[/code]
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

Re: Icy Phoenix RC 2 Error: Could Not Obtain Topic Information
-----------------------------------
[spoiler]ALTER TABLE ip_forums ADD `forum_thanks` TINYINT(1) NOT NULL DEFAULT '0' AFTER `forum_postcount`;[/spoiler]

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


-----------------------------------
Lopalong
Sun 31 May, 2009 15:27

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

Re: Icy Phoenix RC 2 Error: Could Not Obtain Topic Information
-----------------------------------
[quote user="Danielc" post="40055"]
EDIT 2: Yes, it was the last one. Now it seems to work fine. Thanks for everybody!![/quote]
good  :mrorange: 

[quote user="Lopalong" post="40057"]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:[/quote]
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

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

Re: [Solved]Icy Phoenix RC 2 Error: Could Not Obtain Topic Information
-----------------------------------
[quote user="Danielc" post="40059"]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?[/quote]
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

Re: [Solved]Icy Phoenix RC 2 Error: Could Not Obtain Topic Information
-----------------------------------
[quote user="Limun" post="40060"][quote user="Danielc" post="40059"]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?[/quote]
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)[/quote]
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

Re: [Solved]Icy Phoenix RC 2 Error: Could Not Obtain Topic Information
-----------------------------------
[quote user="Danielc" post="40061"][quote user="Limun" post="40060"][quote user="Danielc" post="40059"]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?[/quote]
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)[/quote]
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.[/quote]
what do you mean "original" ??  :shock:


-----------------------------------
Lopalong
Sun 31 May, 2009 15:53

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.[/quote]

And hopefully you wont have any problems.  :mricy:

PS: Bedtime - - G'night! :P


-----------------------------------
Danielc
Sun 31 May, 2009 16:04

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

Re: [Solved]Icy Phoenix RC 2 Error: Could Not Obtain Topic Information
-----------------------------------
[quote user="Danielc" post="40064"]@Limun: the 1.2.27 database.
@Lopalong: MMM, ok, i will do that now![/quote]

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

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

Re: [Solved]Icy Phoenix RC 2 Error: Could Not Obtain Topic Information
-----------------------------------
[quote user="Limun" post="40066"][quote user="Danielc" post="40064"]@Limun: the 1.2.27 database.
@Lopalong: MMM, ok, i will do that now![/quote]

no man , you cant restore  1.2.27 database on RC2 database 
you have to upgrade  1.2.27 database to RC2 database[/quote]
Yeah, i know, i said that i will do some tests beginning again with the original DB


-----------------------------------
Lopalong
Sun 31 May, 2009 23:30

Re: [Solved]Icy Phoenix RC 2 Error: Could Not Obtain Topic Information
-----------------------------------
[quote user="spydie" post="40067"]Someone should tell this to MG.

Because if everyone will have this problem, then we´re in the sh**ter[/quote]

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 [b]HAS [/b]to do it the way the [u][b]instructions [/b][/u]tells one [b]how[/b] to do it. :P


-----------------------------------
spydie
Mon 01 Jun, 2009 12:57

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

Re: [Solved]Icy Phoenix RC 2 Error: Could Not Obtain Topic Information
-----------------------------------
[quote user="spydie" post="40150"]
Just upload update and run install. everything else goes by itself[/quote]
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

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

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:

[img]http://www.icyphoenix.com/files/images/3531/great_day.gif[/img]


-----------------------------------
spydie
Mon 01 Jun, 2009 22:32

Re: [Solved]Icy Phoenix RC 2 Error: Could Not Obtain Topic Information
-----------------------------------
[quote user="Lopalong" post="40172"]

[img]http://www.icyphoenix.com/files/images/3531/great_day.gif[/img][/quote]

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

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

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

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.[/quote]


-----------------------------------
Danielc
Tue 02 Jun, 2009 23:30

Re: [Solved]Icy Phoenix RC 2 Error: Could Not Obtain Topic Information
-----------------------------------
[quote user="spydie" post="40191"]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.[/quote][/quote]
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

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

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


