https://www.icyphoenix.com/viewtopic.php?f=35&t=6824
-----------------------------------
BIG BOSS
Wed 30 Dec, 2009 18:37

SQL Error : 1054 Unknown Column 'p.post_text' In 'field List'
-----------------------------------
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.


-----------------------------------
Mighty Gorgon
Thu 31 Dec, 2009 10:37

Re: SQL Error : 1054 Unknown Column 'p.post_text' In 'field List'
-----------------------------------
Make sure you have removed all old PHP files from your site and refreshed with new ones.


-----------------------------------
BIG BOSS
Thu 31 Dec, 2009 14:17

Re: SQL Error : 1054 Unknown Column 'p.post_text' In 'field List'
-----------------------------------
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"


-----------------------------------
Mighty Gorgon
Thu 31 Dec, 2009 19:12

Re: SQL Error : 1054 Unknown Column 'p.post_text' In 'field List'
-----------------------------------
Did you do what I suggested?

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


-----------------------------------
spydie
Thu 31 Dec, 2009 19:36

Re: SQL Error : 1054 Unknown Column 'p.post_text' In 'field List'
-----------------------------------
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.


-----------------------------------
BIG BOSS
Fri 01 Jan, 2010 15:37

Re: SQL Error : 1054 Unknown Column 'p.post_text' In 'field List'
-----------------------------------
[quote user="Mighty Gorgon" post="46924"]Did you do what I suggested?

Did you remove all PHP files and refreshed with new ones?[/quote]

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.

[quote user="spydie" post="46926"]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.[/quote]

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


-----------------------------------
BIG BOSS
Sat 02 Jan, 2010 16:40

Re: SQL Error : 1054 Unknown Column 'p.post_text' In 'field List'
-----------------------------------
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


-----------------------------------
spydie
Sat 02 Jan, 2010 16:57

Re: SQL Error : 1054 Unknown Column 'p.post_text' In 'field List'
-----------------------------------
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.


-----------------------------------
BIG BOSS
Mon 11 Jan, 2010 15:57

Re: SQL Error : 1054 Unknown Column 'p.post_text' In 'field List'
-----------------------------------
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.  :(


-----------------------------------
Mighty Gorgon
Sun 17 Jan, 2010 13:21

Re: SQL Error : 1054 Unknown Column 'p.post_text' In 'field List'
-----------------------------------
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.


-----------------------------------
BIG BOSS
Sun 17 Jan, 2010 15:17

Re: SQL Error : 1054 Unknown Column 'p.post_text' In 'field List'
-----------------------------------
Unfortunately most of the information is corrupted. I had to delete all files on server and start all over again. New database and files.


