cznews forums not showing

  Post new topicReply to topicPrintable Version
<< View previous topic View next topic >>
Share: Del.icio.us  Digg  Google  Spurl  Blink  Furl  Y! MyWeb  
#1   cznews forums not showing
floppydrivez
CZ Addict
 Codezwiz Site Donator
floppydrivez has been a member for over 18 year's 18 Year Member
usa.gif mississippi.gif
Occupation: graphic design
Age: 43
Gender: Male
Website:
Status: Offline
Joined: Feb 26, 2006
0.08 posts per day
Posts: 518
Points: 4,848
AIM Address Yahoo Messenger MSN Messenger 
I used echo mysql_error(); directly after $result_bb and I get the following.

Unknown column 't.topic_last_post_id' in 'on clause'


I checked the topics table and it topic_last_post_id is actually there.


Back to top Reply with quote
#2   re: cznews forums not showing
floppydrivez
CZ Addict
 Codezwiz Site Donator
floppydrivez has been a member for over 18 year's 18 Year Member
usa.gif mississippi.gif
Occupation: graphic design
Age: 43
Gender: Male
Website:
Status: Offline
Joined: Feb 26, 2006
0.08 posts per day
Posts: 518
Points: 4,848
AIM Address Yahoo Messenger MSN Messenger 
I think the error is mysql 5, telli this is a modded version of $result_bb.

Fix it to fit the default for others please
$result_bb = "SELECT t.topic_id, t.topic_last_post_id, t.topic_title, f.forum_name, f.forum_id, u.username, u.user_id, p.poster_id, p.post_time FROM ".$prefix."_bbtopics t, ".$prefix."_bbforums f,  ".$prefix."_bbposts p, ".$prefix."_users u WHERE  p.post_id = t.topic_last_post_id AND u.user_id = p.poster_id AND t.forum_id=f.forum_id AND f.auth_view=0 ORDER BY t.topic_last_post_id DESC LIMIT $offset_posts, $postnum";


I REPEAT IT WILL NOT WORK WITH STANDARD CZNEWS PROPERLY!!


Back to top Reply with quote
#3   re: cznews forums not showing
floppydrivez
CZ Addict
 Codezwiz Site Donator
floppydrivez has been a member for over 18 year's 18 Year Member
usa.gif mississippi.gif
Occupation: graphic design
Age: 43
Gender: Male
Website:
Status: Offline
Joined: Feb 26, 2006
0.08 posts per day
Posts: 518
Points: 4,848
AIM Address Yahoo Messenger MSN Messenger 
Still some issues to sort out with Auth for groups and what not.



Back to top Reply with quote
#4   re: cznews forums not showing
floppydrivez
CZ Addict
 Codezwiz Site Donator
floppydrivez has been a member for over 18 year's 18 Year Member
usa.gif mississippi.gif
Occupation: graphic design
Age: 43
Gender: Male
Website:
Status: Offline
Joined: Feb 26, 2006
0.08 posts per day
Posts: 518
Points: 4,848
AIM Address Yahoo Messenger MSN Messenger 
I fixed the auth just need to put the original back together and I will post the modifications.



Back to top Reply with quote
#5   re: cznews forums not showing
OzButcher
CZ Super Newbie
 Codezwiz Site Donator
OzButcher has been a member for over 17 year's 17 Year Member
australia.gif
Occupation: Painter
Gender: Male
Website:
Status: Offline
Joined: Jan 19, 2007
0.01 posts per day
Posts: 35
Points: 1,075
   
thanks floppy. itching to try this out. icon_smile.gif



Back to top Reply with quote
Display posts from previous:      
Add To: Del.icio.us  Digg  Google  Spurl  Blink  Furl  Y! MyWeb  
<< View previous topic View next topic >>
Post new topicReply to topic

Jump to 
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 cannot attach files in this forum
You cannot download files in this forum