Forum Centre Block problem Need help creating a block or add-on, or you have created or modified a block/add-on that works in Dragonfly CMS and it meets the CPG Security Requirements? Do you have feedback about a specific add-on? Here is the place to post. Read the announcements here first!.
Offline Joined: May 24, 2007 Posts: 34 Location: Malaysia
Posted: Wed Jun 04, 2008 9:58 am Post subject: Re: Forum Centre Block problem
my site has problem like this:
* 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
Posted: Wed Jun 04, 2008 11:14 am Post subject: Re: Forum Centre Block problem
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.
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