Hallo,
ich habe vor kurzem die mm_forum-Extension 0.1.6 installiert (zum 1. Mal, kein Update) und erhalte beim Plugin Portal Information 3 SQL syntax errors:
---------------------------------------------------------------------------------------------------
caller t3lib_DB::exec_SELECTquery
ERROR You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'u.uid=s.ses_userid AND u.pid='75'
GROUP BY ses_userid
ORDER BY username AS' at line 4
lastBuiltQuery SELECT u.usergroup, u.username, u.uid
FROM fe_users u, fe_sessions s
WHERE
s.ses_tstamp >= "1211890836" AND u.deleted=0AND u.uid=s.ses_userid AND u.pid='75'
GROUP BY ses_userid
ORDER BY username ASC
debug_backtrace require // tslib_fe->INTincScript // tslib_cObj->USER // tslib_cObj->callUserFunction // call_user_method // tx_mmforum_pi6->main // tx_mmforum_pi6->display // tx_mmforum_pi6->getOnlineUsers // tx_mmforum_pi6->getUsersFromTime // t3lib_DB->exec_SELECTquery // t3lib_DB->debug
caller t3lib_DB::exec_SELECTquery
ERROR You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'u.uid=s.ses_userid AND u.pid='75'
GROUP BY ses_userid
ORDER BY username AS' at line 4
lastBuiltQuery SELECT u.usergroup, u.username, u.uid
FROM fe_users u, fe_sessions s
WHERE
s.ses_tstamp >= "1211839201" AND u.deleted=0AND u.uid=s.ses_userid AND u.pid='75'
GROUP BY ses_userid
ORDER BY username ASC
debug_backtrace require // tslib_fe->INTincScript // tslib_cObj->USER // tslib_cObj->callUserFunction // call_user_method // tx_mmforum_pi6->main // tx_mmforum_pi6->display // tx_mmforum_pi6->getTodayUsers // tx_mmforum_pi6->getUsersFromTime // t3lib_DB->exec_SELECTquery // t3lib_DB->debug
caller t3lib_DB::exec_SELECTquery
ERROR Unknown column 'tx_mmforum_posts.deleted' in 'where clause'
lastBuiltQuery SELECT COUNT(*)
FROM tx_mmforum_topics
WHERE
1=1 AND tx_mmforum_posts.deleted=0 AND tx_mmforum_posts.hidden=0 AND pid='564'
debug_backtrace require // tslib_fe->INTincScript // tslib_cObj->USER // tslib_cObj->callUserFunction // call_user_method // tx_mmforum_pi6->main // tx_mmforum_pi6->display // tx_mmforum_pi6->getTotalTopics // t3lib_DB->exec_SELECTquery // t3lib_DB->debug
caller t3lib_DB::exec_SELECTquery
ERROR Unknown column 'tx_mmforum_posts.deleted' in 'where clause'
lastBuiltQuery SELECT COUNT(*)
FROM tx_mmforum_topics
WHERE
1=1 AND tx_mmforum_posts.deleted=0 AND tx_mmforum_posts.hidden=0 AND pid='564'
debug_backtrace require // tslib_fe->INTincScript // tslib_cObj->USER // tslib_cObj->callUserFunction // call_user_method // tx_mmforum_pi6->main // tx_mmforum_pi6->display // tx_mmforum_pi6->getTotalReplies // tx_mmforum_pi6->getTotalTopics // t3lib_DB->exec_SELECTquery // t3lib_DB->debug
---------------------------------------------------------------------------------------------------
Serverdaten:
Suse Linux Enterprise Server 10.1
Apache 2.2.3
MySQL 5.0.26
PHP 5.1.2
Hat jemand vielleicht das gleiche Problem und weiss eine Lösung?
Viele Grüße
Tobias