Error With RC2 After Upgrade From RC1 »  Show posts from    to     

Icy Phoenix


Old Support Topics - Error With RC2 After Upgrade From RC1



haweki [ Fri 22 May, 2009 01:59 ]
Post subject: Error With RC2 After Upgrade From RC1
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.


Limun [ Fri 22 May, 2009 10:49 ]
Post subject: Re: Error With RC2 After Upgrade From RC1
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


haweki [ Fri 22 May, 2009 15:45 ]
Post subject: Re: Error With RC2 After Upgrade From 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.


Limun [ Fri 22 May, 2009 19:11 ]
Post subject: Re: Error With RC2 After Upgrade From RC1
can you check if you have column 'topic_reg' in ip_topics table please


haweki [ Fri 22 May, 2009 21:25 ]
Post subject: Re: Error With RC2 After Upgrade From RC1
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


Limun [ Fri 22 May, 2009 21:34 ]
Post subject: Re: Error With RC2 After Upgrade From RC1
seems that your update didnt went good maybe

try add this column
Spoiler: [ Show ]

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

PS. backup your databse before !!!


spydie [ Fri 22 May, 2009 22:09 ]
Post subject: Re: Error With RC2 After Upgrade From RC1
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


haweki [ Fri 22 May, 2009 23:24 ]
Post subject: Re: Error With RC2 After Upgrade From RC1
Limun wrote: [View Post]
seems that your update didnt went good maybe

try add this column
Spoiler: [ Show ]

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.




Powered by Icy Phoenix