|
|
| Author |
Message |
Jay-Jay
Not So New User
Joined: 03 Jun 2007
Posts: 84
|
 Posted: March 31st 2010, 3:08 pm Post subject: SQL Error : 1054 Unknown column 'pt.post_id' in 'on clause' |
 |
|
I am getting this strange error on my phpbb2 forum. It's been many months since I have added any hacks or modified the pages. So I am confused as to what could have caused this error below. Please help.
General Error Report
| Quote:
|
General Error
Could not obtain post/user information.
DEBUG MODE
SQL Error : 1054 Unknown column 'pt.post_id' in 'on clause'
SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_logo, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_skype, u.user_regdate, u.user_lastvisit, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, u.user_allowdefaultavatar, u.user_allow_viewonline, u.user_session_time, u.user_birthday, u.user_next_birthday_greeting, u.user_country, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid, t.topic_poster, er.text, er.user FROM posts p, users u, posts_text pt, topics t LEFT JOIN edit_reason er ON pt.post_id = er.post_id WHERE p.topic_id = 5359 AND t.topic_id = p.topic_id AND pt.post_id = p.post_id AND u.user_id = p.poster_id AND p.post_flagged <> 1 ORDER BY p.post_time ASC LIMIT 0, 20
Line : 507
File : viewtopic.php
|
_________________
phpBBhacks.com is the best! Great support! Great hacks!
Last edited by Jay-Jay on March 31st 2010, 3:44 pm; edited 1 time in total |
|
| Back to top |
|
 |
~HG~
Dedicated User
Joined: 08 Nov 2003
Posts: 3913
Location: Australia
|
| Posted: March 31st 2010, 3:30 pm Post subject: |
|
|
Can you please edit your post and enclose viewtopic.php in the BBCode code brackets so we can view it and save it to find line 507 and then we might be able to assist you with resolving your problem.
_________________
~HG~
|| rodneyangell.com || || phpbb-tutorials.com ||My Hacks |
|
| Back to top |
|
|
Jay-Jay
Not So New User
Joined: 03 Jun 2007
Posts: 84
|
| Posted: March 31st 2010, 3:49 pm Post subject: |
|
|
| ~HG~ wrote:
|
|
Can you please edit your post and enclose viewtopic.php in the BBCode code brackets so we can view it and save it to find line 507 and then we might be able to assist you with resolving your problem.
|
Sorry, I did try but I think it gets cropped. Here is a text file you can download for viewtopic.
download link: http://rapidshare.com/files/370497159/viewtopic.txt.html
Thanks for the help!!
_________________
phpBBhacks.com is the best! Great support! Great hacks! |
|
| Back to top |
|
|
~HG~
Dedicated User
Joined: 08 Nov 2003
Posts: 3913
Location: Australia
|
| Posted: April 1st 2010, 2:58 pm Post subject: |
|
|
The rapidshare file seems to be inconsistent with way too many line breaks so I can't assist with the problem using that file.
What you can do is to upload a copy to your server simply by changing the name of the file from viewtopic.php to viewtopic.txt and posting a direct link to it here.
That way we will see the file exactly as it is on your server.
_________________
~HG~
|| rodneyangell.com || || phpbb-tutorials.com ||My Hacks |
|
| Back to top |
|
|
Jay-Jay
Not So New User
Joined: 03 Jun 2007
Posts: 84
|
| Posted: April 1st 2010, 5:30 pm Post subject: |
|
|
HG, I tried uploading a text file copy of that page on my server, and when I tried to check if the link was working good, it would result in a strange error. This is why I then attempted to try rapidshare to be able to give you a copy of this file.
I wonder if this error is related to my initial problem? Here is the link: http://www.mixingonbeat.com/media/support/viewtopic.txt
I just sent a support ticket to my host provider to inquire if the problem is on their end. I will let you know in the next 24 hrs to see if any improvement has been achieved.
Update
Well it seems that my server was having more than this problem yesterday. I have addon domains on this server and I could not view those pages. Would get an error when trying to view them. I sent a support ticket with my host and they fixed that problem.
But this problem still lingers. I did a bit of investigating, and discovered if that I use the IP address to view the posts on my site, that I can view them without getting the general error above. But if I view them with the www domain name of my site, I get the SQL Error that I explained when starting this topic.
I just sent an example to my host support team with two links, so they can see that if I use the www domain name I get the error, but when I use the IP address of my site, no more errors.
Here is an example for you. Recall the txt file you can't view on my site? Here is the links again, note one has my domain name and that one doesn't work, while the other has the IP address and that one works great.
Not working: http://www.mixingonbeat.com/media/support/viewtopic.txt
working: http://66.49.205.144/media/support/viewtopic.txt
I must admit this issue has me a bit confused on what could have caused this issue. Any takers??
_________________
phpBBhacks.com is the best! Great support! Great hacks! |
|
| Back to top |
|
|
joetraff
New User
Joined: 20 May 2010
Posts: 2
|
| Posted: May 21st 2010, 7:56 am Post subject: |
|
|
Thanks for the replies.
It helped me a lot. 
_________________
how to make money online |
|
| Back to top |
|
|
Jay-Jay
Not So New User
Joined: 03 Jun 2007
Posts: 84
|
| Posted: May 21st 2010, 12:48 pm Post subject: |
|
|
Sorry, never came back to report how it got fixed.
My host decided on their own to move my site to a new server. But this new server was using now PHP 5. This had caused my site to malfunction as explained above. After I consulted with my host, they moved me back to another server that was still supporting PHP 4. The problems went away after that. I hope this helps.
_________________
phpBBhacks.com is the best! Great support! Great hacks! |
|
| Back to top |
|
|
Patrick
Admin/Webmaster
Joined: 11 May 2001
Posts: 17279
Location: Harbinger, NC, U.S.A.
|
|
| Back to top |
|
|
|
Forums
Home
Register
Profile
Log in to check your private messages
Log in
FAQ
Search
Contact
Us 
