1 頁 (共 1 頁)

[問題]有關ezportal

發表於 : 2004-05-07 14:42
JianWen
我最近安装了ezportal, 但是却不能正常显示?
Debug 的结果是如下:
Could not query announcements information

代碼: 選擇全部

DEBUG MODE 

SQL Error : -1 ERROR: LIMIT #,# syntax not supported. Use separate LIMIT and OFFSET clauses. 

SELECT t.topic_id, t.topic_time, t.topic_title, pt.post_text, u.username, u.user_id, t.topic_replies, pt.bbcode_uid, t.forum_id, t.topic_poster, t.topic_first_post_id, t.topic_status, pt.post_id, p.post_id, p.enable_smilies FROM phpbb_topics AS t, phpbb_users AS u, phpbb_posts_text AS pt, phpbb_posts AS p WHERE t.forum_id IN (1) AND t.topic_time <= 1083855531 AND t.topic_poster = u.user_id AND t.topic_first_post_id = pt.post_id AND t.topic_first_post_id = p.post_id AND t.topic_status <> 2 ORDER BY t.topic_time DESC LIMIT 0,5 

Line : 86 
File : /mydomain.com/phpBB2/fetchposts.php

Re: [問題]有關ezportal

發表於 : 2004-05-07 14:45
JianWen
JianWen 寫:我最近安装了ezportal, 但是却不能正常显示?
Debug 的结果是如下:
Could not query announcements information

代碼: 選擇全部

DEBUG MODE 

SQL Error : -1 ERROR: LIMIT #,# syntax not supported. Use separate LIMIT and OFFSET clauses. 

SELECT t.topic_id, t.topic_time, t.topic_title, pt.post_text, u.username, u.user_id, t.topic_replies, pt.bbcode_uid, t.forum_id, t.topic_poster, t.topic_first_post_id, t.topic_status, pt.post_id, p.post_id, p.enable_smilies FROM phpbb_topics AS t, phpbb_users AS u, phpbb_posts_text AS pt, phpbb_posts AS p WHERE t.forum_id IN (1) AND t.topic_time <= 1083855531 AND t.topic_poster = u.user_id AND t.topic_first_post_id = pt.post_id AND t.topic_first_post_id = p.post_id AND t.topic_status <> 2 ORDER BY t.topic_time DESC LIMIT 0,5 

Line : 86 
File : /mydomain.com/phpBB2/fetchposts.php
请各位大侠多多帮忙!!谢谢!!

發表於 : 2004-05-07 15:09
kkf
請依照發表格式~~~
http://phpbb-tw.net/phpbb/viewtopic.php?p=94203#94203


你用的是甚麼資料庫??
還有,你可以貼出line86那一段的程式碼嗎??