|
Page 1 of 1
|
BIG BOSS
Joined: March 2008
Posts: 42
Location:
|
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.
____________ Regards,
BIG BOSS
|
#1 Wed 30 Dec, 2009 18:37 |
|
Sponsors
|
Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.
|
|
Mighty Gorgon
Luca Libralato
Joined: August 2006
Posts: 7191
Location: Borgo San Michele
|
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.
____________ Luca
SEARCH is the quickest way to get support.
Icy Phoenix ColorizeIt - CustomIcy - HON
|
#2 Thu 31 Dec, 2009 10:37 |
|
BIG BOSS
Joined: March 2008
Posts: 42
Location:
|
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"
____________ Regards,
BIG BOSS
|
#3 Thu 31 Dec, 2009 14:17 |
|
Mighty Gorgon
Luca Libralato
Joined: August 2006
Posts: 7191
Location: Borgo San Michele
|
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?
____________ Luca
SEARCH is the quickest way to get support.
Icy Phoenix ColorizeIt - CustomIcy - HON
|
#4 Thu 31 Dec, 2009 19:12 |
|
spydie
Joined: December 2008
Posts: 1796
Location: In the Boxes
|
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.
____________ Out of Order
|
#5 Thu 31 Dec, 2009 19:36 |
|
BIG BOSS
Joined: March 2008
Posts: 42
Location:
|
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?
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.
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....
____________ Regards,
BIG BOSS
|
#6 Fri 01 Jan, 2010 15:37 |
|
BIG BOSS
Joined: March 2008
Posts: 42
Location:
|
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
|
#7 Sat 02 Jan, 2010 16:40 |
|
spydie
Joined: December 2008
Posts: 1796
Location: In the Boxes
|
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.
____________ Out of Order
|
#8 Sat 02 Jan, 2010 16:57 |
|
BIG BOSS
Joined: March 2008
Posts: 42
Location:
|
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.
____________ Regards,
BIG BOSS
|
#9 Mon 11 Jan, 2010 15:57 |
|
Mighty Gorgon
Luca Libralato
Joined: August 2006
Posts: 7191
Location: Borgo San Michele
|
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.
____________ Luca
SEARCH is the quickest way to get support.
Icy Phoenix ColorizeIt - CustomIcy - HON
|
#10 Sun 17 Jan, 2010 13:21 |
|
BIG BOSS
Joined: March 2008
Posts: 42
Location:
|
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.
____________ Regards,
BIG BOSS
|
#11 Sun 17 Jan, 2010 15:17 |
|
|
Page 1 of 1
|
Was this topic useful?
Was this topic useful?
Link this topic |
URL |
|
BBCode |
|
HTML |
|
You cannot post new topics You cannot reply to topics You cannot edit your posts You cannot delete your posts You cannot vote in polls You cannot attach files You can download files You cannot post calendar events
|
|
|
|