Icy Phoenix

Strange thing happening after upgrading from 1.2.0.27 to 1.3.0.53, it seems to be working fine in IE8, but when opening the site with FF 3.5.6 it gives this error:

Error general
Could not obtain topics information

DEBUG MODE

SQL Error : 1054 Unknown column 'p.post_text' in 'field list'

SELECT t.*, p.poster_id, p.post_username, p.post_text, p.enable_bbcode, p.enable_html, p.enable_smilies, u.username, u.user_active, u.user_color, lp.poster_id AS lp_poster_id, lu.username AS lp_username, lp.post_username AS lp_post_username, lp.post_time AS lp_post_time FROM ip_topics AS t, ip_posts AS p, ip_users AS u, ip_posts AS lp, ip_users lu WHERE t.forum_id IN (1, 3, 4, 5, 6, 7, 12) AND p.post_id = t.topic_first_post_id AND u.user_id = p.poster_id AND lp.post_id = t.topic_last_post_id AND lu.user_id = lp.poster_id AND t.topic_calendar_time < 1262671200 AND (t.topic_calendar_time + t.topic_calendar_duration) >= 1262066400 AND t.topic_status <> 2 ORDER BY t.topic_calendar_time, t.topic_calendar_duration DESC, t.topic_last_post_id DESC

Line : 408
File : functions_calendar.php

Any help will be greatly appreciated.

Make sure you have removed all old PHP files from your site and refreshed with new ones.

I performed the upgrade according to instructions provided with the pack.

Do I need to delete any other folder not mentioned in the instructions?

Also I have Activity Mod installed in .27c, could that be affecting the new version?

I have a backup of all files on server and database, rolled back to it and everything works fine again.

Something I forgot to add in previous post:

When trying to read a post it returns "Hacking attempt"

Did you do what I suggested?

Did you remove all PHP files and refreshed with new ones?

It looks to me like you did´nt go fully through the install file.

theres some otpions like fix config etc that if not performed might through this error.

on the other site . when you upload the new files make shure to do it on BINARY mod of the client.

Mighty Gorgon wrote: [View Post]

Did you do what I suggested?

Did you remove all PHP files and refreshed with new ones?

Yes, indeed. I deleted all php files. Closed FTP client, checked site through cPanel to see if any old files were there. Not one file found. Opened FTP client and uploaded fresh php files from new download.

Same result.

spydie wrote: [View Post]

It looks to me like you did´nt go fully through the install file.

theres some otpions like fix config etc that if not performed might through this error.

on the other site . when you upload the new files make shure to do it on BINARY mod of the client.

Hmm, I'm going to try this one and see what happens. I tried a fresh installation and everything went smooth... same site, same server, no need to CHMOD, using phpsuexec....

Ok, this is the error I'm getting now:

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.*, 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 = '1714' AND t.topic_id = p.topic_id AND p2.topic_id = p.topic_id AND p2.post_id <= '1714' 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

Have you done the quick settings ?


Ups:

I got the similar topics disabled aswell, due to about the same error.

Try disabling it and see if the error disapears.

Well, somewhere in the middle of backing up / restoring/ deleting / uploading my database backup file got corrupted in the last try to install the new version.

Practically all information stored during the last 4 years is useless now. I was able to recover the users' emails from the users table.

Right now I'm in the process of making a fresh installation. Then I will email the users asking them to re-register.

Our board will start from scratch. :(

You didn't update properly... if you didn't start from scratch I would suggest to have another try by carefully following the upgrade procedure step by step.

Unfortunately most of the information is corrupted. I had to delete all files on server and start all over again. New database and files.