---
title: "mm_forum plugin Portal information SQL syntax-error"
url: "https://www.typo3.net/d/77738-mm-forum-plugin-portal-information-sql-syntax-error"
source: "typo3.net"
tags: ["Extensions","Datenbank","Frage"]
created: "2008-05-27"
last_reply: "2008-05-28"
replies: 2
solved: false
page: 1
pages: 1
lang: "de"
---

# mm_forum plugin Portal information SQL syntax-error

Extensions · 2 Antworten · gestartet 2008-05-27

## Eröffnungsbeitrag

**tobiasschaefer** · 2008-05-27 · [Beitrag #1](https://www.typo3.net/d/77738-mm-forum-plugin-portal-information-sql-syntax-error/1)

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

## Antworten

### [#2](https://www.typo3.net/d/77738-mm-forum-plugin-portal-information-sql-syntax-error/2) · tobiasschaefer · 2008-05-28

Ich habe einen Bug Report eingestellt:
<http://bugs.typo3.net/view.php?id=370>

### [#3](https://www.typo3.net/d/77738-mm-forum-plugin-portal-information-sql-syntax-error/3) · tobiasschaefer · 2008-05-28

Mit der neuesten Entwickler-Version 199 trat der Fehler nicht mehr auf.

---

Quelle: „mm_forum plugin Portal information SQL syntax-error“, typo3.net, https://www.typo3.net/d/77738-mm-forum-plugin-portal-information-sql-syntax-error
Beiträge von Mitgliedern des Forums. Bitte mit Link auf die Diskussion zitieren.