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

____________
We are the phpBBorg. Lower your Crackers. Your phpological and forumological distinctivness will be added to our own. Resistance if futile!

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

____________
We are the phpBBorg. Lower your Crackers. Your phpological and forumological distinctivness will be added to our own. Resistance if futile!

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

____________
We are the phpBBorg. Lower your Crackers. Your phpological and forumological distinctivness will be added to our own. Resistance if futile!

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

____________
Out of Order

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

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.