Icy Phoenix

Hi!

First, sorry for my bad english, but i speak spanish ;).

I recently upgraded my site to the latest RC2 version from RC1 , but, when i open some thread, Icy phoenix displays the following error:

Could not obtain topic information

DEBUG MODE

SQL Error : 1054 Unknown column 't.topic_reg' 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 = '106' AND t.topic_id = p.topic_id AND p2.topic_id = p.topic_id AND p2.post_id <= '106' 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

I update the database with file database_update.php , and was upgraded sucesfully.

What is the problem?

Thanks.

did you uploated and replaced all files for RC2 ?

to me seems that you didnt !

PS.if you didnt pay attention to not upload config.php and files you moded in RC1

Limun wrote: [View Post]

did you uploated and replaced all files for RC2 ?

to me seems that you didnt !

PS.if you didnt pay attention to not upload config.php and files you moded in RC1

Yes, i upload and replaced all files for RC2.

After upgrade and upload the files of RC2, this error display.

can you check if you have column 'topic_reg' in ip_topics table please

Limun wrote: [View Post]

can you check if you have column 'topic_reg' in ip_topics table please

Yes.

I dont have column "Topic_Reg" in ip_topics :S

seems that your update didnt went good maybe

try add this column

Tipp: if your database prefix is diferent than ip_ change this query to your prefix

PS. backup your databse before !!!

question.

When did you download RC2 ??

there was a topic with problems that seem to be the same .

something like PhpBB prefix in a file.

[SOLVED] Error After Upgrade To RC2 Version have a look

Limun wrote: [View Post]

seems that your update didnt went good maybe

try add this column

Spoiler: [ Show ]

Spoiler: [ Hide ]

ALTER TABLE ip_topics ADD topic_reg TINYINT(1) DEFAULT '0' NOT NULL AFTER topic_calendar_duration;

Tipp: if your database prefix is diferent than ip_ change this query to your prefix

PS. backup your databse before !!!

Problem fixed!!!

Thank you very much :D :D :D

spydie wrote: [View Post]

question.

When did you download RC2 ??

there was a topic with problems that seem to be the same .

something like PhpBB prefix in a file.

[SOLVED] Error After Upgrade To RC2 Version have a look

I downloaded RC2 yesterday, from Icy phoenix.com server.