problemas con Ezportal
Publicado: 06 Jun 2005, 18:07
me sale este error y por supuesto el portal no va.. :cry:
Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 31: Incorrect syntax near 'LIMIT'., SQL state 37000 in SQLExecDirect in E:\toda_la_ruta\phpBB2\db\mssql-odbc.php on line 117
y luego sale esto....
General Error
Could not query announcements information
DEBUG MODE
SQL Error : 37000 [Microsoft][ODBC SQL Server Driver][SQL Server]Line 31: Incorrect syntax near 'LIMIT'.
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 <= 1118073879 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 : fetchposts.php
Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 31: Incorrect syntax near 'LIMIT'., SQL state 37000 in SQLExecDirect in E:\toda_la_ruta\phpBB2\db\mssql-odbc.php on line 117
y luego sale esto....
General Error
Could not query announcements information
DEBUG MODE
SQL Error : 37000 [Microsoft][ODBC SQL Server Driver][SQL Server]Line 31: Incorrect syntax near 'LIMIT'.
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 <= 1118073879 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 : fetchposts.php