Icy Phoenix

     
 


Post new topic  Reply to topic 
Page 1 of 1
 
 
Reply with quote Download Post 
Post 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
 
BIG BOSSSend private message  
Back to topPage bottom
Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.

Support us
 
Reply with quote Download Post 
Post 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
 
Mighty GorgonSend private messageSend e-mail to userVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post 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
 
BIG BOSSSend private message  
Back to topPage bottom
Reply with quote Download Post 
Post 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
 
Mighty GorgonSend private messageSend e-mail to userVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post 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
 
spydieSend private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post Re: SQL Error : 1054 Unknown Column 'p.post_text' In 'field List' 
 
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....
 




____________
Regards,

BIG BOSS
 
BIG BOSSSend private message  
Back to topPage bottom
Reply with quote Download Post 
Post 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
 



 
BIG BOSSSend private message  
Back to topPage bottom
Reply with quote Download Post 
Post 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
 
spydieSend private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post 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
 
BIG BOSSSend private message  
Back to topPage bottom
Reply with quote Download Post 
Post 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
 
Mighty GorgonSend private messageSend e-mail to userVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post 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
 
BIG BOSSSend private message  
Back to topPage bottom
Post new topic  Reply to topic  Page 1 of 1
 


Display posts from previous:    

HideWas this topic useful?

Link this topic
URL
BBCode
HTML




 
Permissions List
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