staff mod
Geplaatst: 28 feb 2004, 13:58
Ik wil de staff mod gebruiken op een Access database, kan dit aangezien het voor (My)SQL is gemaakt?
Code: Selecteer alles
Warning: odbc_exec(): SQL error: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'DISTINCT p.post_time'., SQL state 37000 in SQLExecDirect in c:\program files\easyphp1-7\www\phpbb2\db\msaccess.php on line 120
Code: Selecteer alles
General Error
Error getting user last post.
DEBUG MODE
SQL Error : Error
SELECT DISTINCT p.post_time, p.post_id, count(DISTINCT t.topic_id) AS user_topics FROM phpbb_posts p, phpbb_topics t WHERE p.poster_id = '2' AND t.topic_poster = '2' GROUP BY p.post_time ORDER BY p.post_time DESC LIMIT 1
Line : 138
File : c:\program files\easyphp1-7\www\phpbb2\staff.php