Support ⇒ Modules & Blocks ⇒ Forum Centre Block problem ⇒ Community Forums ⇒ CPG Dragonfly™ CMS

Forum Centre Block problem Reply to topic

Author Message
popeye
Newbie

Offline Offline
Joined: May 24, 2007
Posts: 34
Location: Malaysia

hye.. please check at my site at Forums Centre Block www.otaimerz.cjb.net ... why the width of the table is so high.. can i reduce to get suitable with my site


popeye's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
(Linux/ Apache version 2.2.6 (Unix)/ PHP version 5.2.5/ MySQL version 5.0.51a-community/ DragonflyCMS CVS 9.2.1)
View user's profileVisit poster's website
Jeruvy
Security Team

Offline Offline
Joined: Apr 23, 2004
Posts: 1432
Location: Canada

Read me signature.

_________________
J.
j e r u v y a t y a h o o d o t c o m

Need help? Look here: www.dragonflycms.org/W...d=112.html
Need to chat? Look for me on irc.freenode.net

Jeruvy's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Ubuntu7.10/Debian3.1 - 2.2.3/1.3.37 - 5.0.38/4.0.27 - 5.2.1/4.4.7 - CVS/9.1.2}
View user's profileICQ NumberYahoo MessengerPhoto Gallery
popeye
Newbie

Offline Offline
Joined: May 24, 2007
Posts: 34
Location: Malaysia

my site has problem like this:

includes/db/db.php

* CMS Warning line 75: On /portal/ While executing query "SELECT p.post_time, t.topic_id, t.forum_id, t.topic_title, t.topic_poster, t.topic_views, t.topic_replies, t.topic_type, t.topic_status, t.topic_last_post_id, t.topic_first_post_id, t.topic_moved_id, t.topic_attachment, t.icon_id, f.forum_id, f.forum_name, f.auth_read, n.notify_status, u.username, u.user_posts, v.username, v.user_posts, w.poster_ip, i.icon_url, p.poster_id, p.poster_ip, p.post_id, s.post_text, m.custom_title FROM cms_bbtopics t, cms_bbforums f LEFT JOIN cms_bbposts p ON (p.post_id=t.topic_last_post_id) LEFT JOIN cms_bbposts w ON (w.post_id=t.topic_first_post_id) LEFT JOIN cms_users u ON (u.user_id=p.poster_id) LEFT JOIN cms_users v ON (v.user_id=t.topic_poster) LEFT JOIN cms_bbtopics_watch n ON (n.user_id=2 AND n.topic_id=t.topic_id) LEFT JOIN cms_bbtopic_icons i ON (i.icon_id=t.icon_id) LEFT JOIN cms_bbposts_text s ON (s.post_id=t.topic_last_post_id) LEFT JOIN cms_modules m ON (m.title="Forums") WHERE t.forum_id=f.forum_id AND t.topic_moved_id=0 ORDER BY p.post_time DESC LIMIT 5" the following error occured: Unknown column 't.topic_last_post_id' in 'on clause' In: /home/wookieso/public_html/portal/blocks/block-Forums_Centre_Block_(Module).php on line: 95



u can see it at www.wookies.org/portal


popeye's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
(Linux/ Apache version 2.2.6 (Unix)/ PHP version 5.2.5/ MySQL version 5.0.51a-community/ DragonflyCMS CVS 9.2.1)
View user's profileVisit poster's website
Phoenix
• Many Posts •

Offline Offline
Joined: Apr 19, 2004
Posts: 8840
Location: Netizen

popeye please enter your server specs in your user profile!
Since you provide no info, why not try searching or at least go through the existing topic for Forum Centre Block.

_________________
DonationsPro for DragonflyCMS & SMF

Phoenix's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
View user's profilePhoto Gallery
popeye
Newbie

Offline Offline
Joined: May 24, 2007
Posts: 34
Location: Malaysia

Phoenix .. i'm already update my server specs.. please help me to run forum centre block nicely


popeye's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
(Linux/ Apache version 2.2.6 (Unix)/ PHP version 5.2.5/ MySQL version 5.0.51a-community/ DragonflyCMS CVS 9.2.1)
View user's profileVisit poster's website
Phoenix
• Many Posts •

Offline Offline
Joined: Apr 19, 2004
Posts: 8840
Location: Netizen

go through the existing topic for Forum Centre Block
Now that we know your specs, you have the problem because your host has upgraded to MySQL5 - you will find an updated block attached in the later posts, or you can make the change I suggested somewhere in those later posts.

Actually, I forgot I provided an updated block here:
nukebiz.com/Downloads/...ils/id=67/


Phoenix's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
View user's profilePhoto Gallery
Display posts from previous:
All times are UTC



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


User Info

Welcome Anonymous



(Register)
Community

Support for DragonflyCMS in a other languages:

Deutsch
Español