mm_forum plugin Portal information SQL syntax-error 
| Autor | Nachricht |
|
Verfasst am: 27.05.2008 [14:58]
|
|
| tobiasschaefer [Themenersteller] dabei seit: 15.05.2008 Beiträge: 17 |
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 |
 |
|
|
Verfasst am: 28.05.2008 [17:01]
|
|
| tobiasschaefer [Themenersteller] dabei seit: 15.05.2008 Beiträge: 17 |
Ich habe einen Bug Report eingestellt: http://bugs.typo3.net/view.php?id=370 |
|
|
|
Verfasst am: 28.05.2008 [17:42]
|
|
| tobiasschaefer [Themenersteller] dabei seit: 15.05.2008 Beiträge: 17 |
Mit der neuesten Entwickler-Version 199 trat der Fehler nicht mehr auf. |
|
|
