Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> BBtoNuke
Author Message
akky
Regular
Regular



Joined: Feb 18, 2006
Posts: 87

PostPosted: Wed Mar 29, 2006 6:36 am Reply with quote

Hi

Just got this error when clicking on recent posts link

SQL Error : 1054 Unknown column 't.topic_first_post_id' in 'on clause'

Code:



SELECT t.*, p.poster_id, p.post_username AS last_poster_name, p.post_id, p.post_time, f.forum_name, f.forum_id, u.username AS last_poster, u.user_id AS last_poster_id, u2.username AS first_poster, u2.user_id AS first_poster_id, p2.post_username AS first_poster_name FROM nuke_bbtopics t, nuke_bbposts p LEFT OUTER JOIN nuke_bbposts p2 ON p2.post_id = t.topic_first_post_id LEFT OUTER JOIN nuke_bbforums f ON p.forum_id = f.forum_id LEFT OUTER JOIN nuke_users u ON p.poster_id = u.user_id LEFT OUTER JOIN nuke_users u2 ON u2.user_id = t.topic_poster WHERE t.forum_id NOT IN ('start') AND p.post_id = t.topic_last_post_id AND FROM_UNIXTIME(p.post_time,'%Y%m%d') - FROM_UNIXTIME(unix_timestamp(NOW()),'%Y%m%d') = 0 ORDER BY t.topic_last_post_id DESC LIMIT 0, 10

Line : 166
File : recent.php



any ideas, anyone? It's trying to run.

modules.php?name=Forums&file=recent

I even created a 'recent' test post.

thanks akky
 
View user's profile Send private message
Raven
Site Admin/Owner



Joined: Aug 27, 2002
Posts: 17088

PostPosted: Wed Mar 29, 2006 11:31 am Reply with quote

That means your table nuke_bbtopics is missing the column named topic_first_post_id.
 
View user's profile Send private message
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> BBtoNuke

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©