WoltLab Cloud Staff Tracker 1.0.5

Batarjal
Sep 22nd 2018
41 Downloads
35 Comments
14 Purchases

This plugin allows users to easily find posts made by the staff.

Features

The staff page now shows the most recent posts of staff members
A new sortable page containing all staff posts
An icon in the forum list to quickly jump to the latest staff post in that forum
An icon in the thread lost to quickly jump latest staff post in that
All thread boxes can now be limited to staff posts
It is also possible to use usergroups that are not shown on the team page
Ideal for support forums or as DevTracker

Live Demo

noexcept.de

Screenshots

Further Information

Available languages: English and German
Support

Version 1.0.5
- Batarjal
- Jun 1st 2020
- 81.92 kB
- 8 Downloads
fix for php74
Version 1.0.4
- Batarjal
- Jan 4th 2020
- 81.92 kB
- 8 Downloads
WCF 5.2 Support
Version 1.0.3
- Batarjal
- Oct 18th 2018
- 81.92 kB
- 13 Downloads
- fixed some design issues
- guests can now access team page
- custom usergroups that are not team members can be added
- fixed an issue where the link would not always jump to the last team reply
- performance improvements
Version 1.0.2
- Batarjal
- Oct 4th 2018
- 71.68 kB
- 4 Downloads
- fixed SQL issue
- fixed invalid HTML
Version 1.0.0
- Batarjal
- Sep 22nd 2018
- 71.68 kB
- 8 Downloads

Darklord May 30th 2020

Leider besteht der Fehler vom 2 April, noch immer, weshalb ich das Plugin jetzt rausnehmen muss, da ich endlich auf die 7.4 umstellen möchte.
Schade, das es nach fast 2 Monaten keine Fehlerbehebung gibt!
- Batarjal Jun 1st 2020 Author
  
  Hallo, sorry für die späte Antwort.
  Der Fehler ist mit Version 1.0.5 behoben.
Darklord Apr 2nd 2020
Scheint als hätte die neuste Version noch ein Problem mit PHP 7.4.4.

Requested URL

/

Referrer

https://my-domain.de

Error Message

Trying to access array offset on value of type int

Type

wcf\system\exception\ErrorException

File (Line)

/var/www/vhosts/my-domain.de/httpdocs/lib/system/WCF.class.php (341)

Stacktrace

/var/www/vhosts/my-domain.de/httpdocs/forum/lib/system/cache/builder/TeamTrackBoardCacheBuilder.class.php (110): wcf\system\WCF::handleError(…)

/var/www/vhosts/my-domain.de/httpdocs/forum/lib/system/cache/builder/TeamTrackBoardCacheBuilder.class.php (33): wbb\system\cache\builder\TeamTrackBoardCacheBuilder->update(…)

/var/www/vhosts/my-domain.de/httpdocs/forum/lib/system/event/listener/TeamTrackerThreadListener.class.php (39): wbb\system\cache\builder\TeamTrackBoardCacheBuilder->getData(…)

/var/www/vhosts/my-domain.de/httpdocs/lib/system/event/EventHandler.class.php (228): wbb\system\event\listener\TeamTrackerThreadListener->execute(…)

/var/www/vhosts/my-domain.de/httpdocs/lib/system/box/AbstractDatabaseObjectListBoxController.class.php (350): wcf\system\event\EventHandler->fireAction(…)

/var/www/vhosts/my-domain.de/httpdocs/forum/lib/system/box/ThreadListBoxController.class.php (139): wcf\system\box\AbstractDatabaseObjectListBoxController->readObjects(…)

/var/www/vhosts/my-domain.de/httpdocs/lib/system/box/AbstractDatabaseObjectListBoxController.class.php (326): wbb\system\box\ThreadListBoxController->readObjects(…)

/var/www/vhosts/my-domain.de/httpdocs/lib/system/box/AbstractDatabaseObjectListBoxController.class.php (293): wcf\system\box\AbstractDatabaseObjectListBoxController->loadContent(…)

/var/www/vhosts/my-domain.de/httpdocs/lib/data/box/Box.class.php (291): wcf\system\box\AbstractDatabaseObjectListBoxController->hasContent(…)

/var/www/vhosts/my-domain.de/httpdocs/lib/data/box/Box.class.php (276): wcf\data\box\Box->hasContent(…)

/var/www/vhosts/my-domain.de/httpdocs/templates/compiled/5_wcf_1_cms.php (2863): wcf\data\box\Box->render(…)

/var/www/vhosts/my-domain.de/httpdocs/lib/system/template/TemplateEngine.class.php (334): include(…)

/var/www/vhosts/my-domain.de/httpdocs/lib/page/AbstractPage.class.php (323): wcf\system\template\TemplateEngine->display(…)

/var/www/vhosts/my-domain.de/httpdocs/lib/page/AbstractPage.class.php (114): wcf\page\AbstractPage->show(…)

/var/www/vhosts/my-domain.de/httpdocs/lib/system/request/Request.class.php (83): wcf\page\AbstractPage->__run(…)

/var/www/vhosts/my-domain.de/httpdocs/lib/system/request/RequestHandler.class.php (107): wcf\system\request\Request->execute(…)

/var/www/vhosts/my-domain.de/httpdocs/index.php (9): wcf\system\request\RequestHandler->handle(…)

Thu, 02 Apr 2020 05:58:21 +0000 Message: Trying to access array offset on value of type int PHP version: 7.4.4 WoltLab Suite version: 5.2.4 Request URI: / Referrer: https://my-domain.de User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:74.0) Gecko/20100101 Firefox/74.0 Peak Memory Usage: 9939792/1073741824 ====== Error Class: wcf\system\exception\ErrorException Error Message: Trying to access array offset on value of type int Error Code: 0 File: /var/www/vhosts/my-domain.de/httpdocs/lib/system/WCF.class.php (341) Extra Information: - Stack Trace: [{"file":"\/var\/www\/vhosts\/my-domain.de\/httpdocs\/forum\/lib\/system\/cache\/builder\/TeamTrackBoardCacheBuilder.class.php","line":110,"function":"handleError","class":"wcf\\system\\WCF","type":"::","args":[]},{"file":"\/var\/www\/vhosts\/my-domain.de\/httpdocs\/forum\/lib\/system\/cache\/builder\/TeamTrackBoardCacheBuilder.class.php","line":33,"function":"update","class":"wbb\\system\\cache\\builder\\TeamTrackBoardCacheBuilder","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/my-domain.de\/httpdocs\/forum\/lib\/system\/event\/listener\/TeamTrackerThreadListener.class.php","line":39,"function":"getData","class":"wbb\\system\\cache\\builder\\TeamTrackBoardCacheBuilder","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/my-domain.de\/httpdocs\/lib\/system\/event\/EventHandler.class.php","line":228,"function":"execute","class":"wbb\\system\\event\\listener\\TeamTrackerThreadListener","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/my-domain.de\/httpdocs\/lib\/system\/box\/AbstractDatabaseObjectListBoxController.class.php","line":350,"function":"fireAction","class":"wcf\\system\\event\\EventHandler","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/my-domain.de\/httpdocs\/forum\/lib\/system\/box\/ThreadListBoxController.class.php","line":139,"function":"readObjects","class":"wcf\\system\\box\\AbstractDatabaseObjectListBoxController","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/my-domain.de\/httpdocs\/lib\/system\/box\/AbstractDatabaseObjectListBoxController.class.php","line":326,"function":"readObjects","class":"wbb\\system\\box\\ThreadListBoxController","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/my-domain.de\/httpdocs\/lib\/system\/box\/AbstractDatabaseObjectListBoxController.class.php","line":293,"function":"loadContent","class":"wcf\\system\\box\\AbstractDatabaseObjectListBoxController","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/my-domain.de\/httpdocs\/lib\/data\/box\/Box.class.php","line":291,"function":"hasContent","class":"wcf\\system\\box\\AbstractDatabaseObjectListBoxController","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/my-domain.de\/httpdocs\/lib\/data\/box\/Box.class.php","line":276,"function":"hasContent","class":"wcf\\data\\box\\Box","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/my-domain.de\/httpdocs\/templates\/compiled\/5_wcf_1_cms.php","line":2863,"function":"render","class":"wcf\\data\\box\\Box","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/my-domain.de\/httpdocs\/lib\/system\/template\/TemplateEngine.class.php","line":334,"args":["\/var\/www\/vhosts\/my-domain.de\/httpdocs\/templates\/compiled\/5_wcf_1_cms.php"],"function":"include","class":"","type":""},{"file":"\/var\/www\/vhosts\/my-domain.de\/httpdocs\/lib\/page\/AbstractPage.class.php","line":323,"function":"display","class":"wcf\\system\\template\\TemplateEngine","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/my-domain.de\/httpdocs\/lib\/page\/AbstractPage.class.php","line":114,"function":"show","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/my-domain.de\/httpdocs\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/my-domain.de\/httpdocs\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/my-domain.de\/httpdocs\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":[]}]
- Batarjal Apr 2nd 2020 Author
  
  Danke für das Feedback, wird zeitnah behoben.
  1
- Darklord May 8th 2020
  
  Gibt es hier bereits etwas neues?
Rasselbande Oct 10th 2018

Wir haben noch ein geringfügiges Layout-Problem. Aus irgendeinem Grund sind Team Tracker Icon bei einem Forum mehr eingerückt, als bei den anderen? Mal nach links mal nach rechts.

https://i.imgur.com/2pDCBdE.png
- Batarjal Oct 18th 2018 Author
  
  Das ist in der nächsten Version behoben.
- Batarjal Oct 23rd 2018 Author
  
  Sollte nun funktionieren
Rasselbande Oct 10th 2018

Aus irgendeinem Grund haben Gäste keinen Zugriff auf ...index.php?team-tracker/

"Kann Team Tracker sehen" ist für Gäste freigeschaltet und sie sehen auch die Icons, können zu den Posts springen. Nur der Zugriff auf die entsprechende Seite oben ist verweigert?!
- Batarjal Oct 10th 2018 Author
  
  Hallo - Das wird in der nächsten Version behoben.
  1
Rasselbande Oct 7th 2018

Kann mir jemand den CSS code nennen, damit das FontAwesome Icon nicht so am Rand des Tabels klebt?

https://goo.gl/RLF7hr
- Batarjal Oct 7th 2018 Author
  
  Code
  
  .teamTrackerBadgeBoard { margin: 7px; }
- Rasselbande Oct 8th 2018
  
  Vielen Dank!!
Grischabock Oct 4th 2018

Welche Benutzergruppen werden beachtet? Kann ich mehrere da eintragen? Beim Test wurde mein Beitrag angezeigt welcher in der Mitte des ganzen Threads war. Der letzte Beitrag eines Team Mitglieds der am ende des Threads ist wurde nicht beachtet.

Die Benutzergruppe Team wird aber auf der Team Seite angezeigt.

Lässt sich das FA Icon durch eine Grafik ersetzen?
- Batarjal Oct 4th 2018 Author
  
  Alle Nutzer der Team-Seite werden beachtet. Eigentlich sollte der neuste Beitrag angezeigt werden, das prüfe ich für die nächste Version.
  Wie man ein eigenes Bild einbindet steht hier unter Übersicht ganz unten.
- Grischabock Oct 4th 2018
  
  Okay, danke dir. Schaue auch nochmals ob es bei mir irgendwo liegt.
  
  Sorry hab den Spoiler echt überlesen, vielen Dank
- Batarjal Oct 23rd 2018 Author
  
  Das Problem, dass nicht immer zum neusten Team-Beitrag gesprungen wird, sollte in der aktullen Version behoben sein.
  Außerdem kann man nun beliebige Benutzergruppen nutzen.
- Grischabock Oct 23rd 2018
  
  funktioniert beides perfekt. Danke
- WoltNet Oct 11th 2019
  
  Entschuldige wenn ich noch einmal hier nachfrage zur "eigenen Grafik". Das man ein anderes Icon (FA) nutzen kann habe ich auf den Screenshot gesehen, jedoch nicht wie/wo man ein eigenes Bild einsetzen kann.

enskyeu Oct 1st 2018

Hallo ich hab mir das Plugin gekauft allerdings erhalte ich nach installation folgenden Error

Code

Error Type:

wcf\system\database\exception\DatabaseQueryException

Error Message:

Could not prepare statement 'SELECT MAX(postID) AS postID, threadID FROM wbb1_post p LEFT JOIN wbb1_thread t USING (threadID) WHERE p.userID IN (?,?,?,?) AND t.boardID = ? GROUP BY t.threadID, postID ORDER BY postID DESC LIMIT 100'

Error Code:

42000

File:

*/lib/system/database/Database.class.php (248)

Stack Trace:

#0 */forum/lib/system/cache/builder/TeamTrackBoardCacheBuilder.class.php (75):
wcf\system\database\Database->prepareStatement('SELECT MAX(postID) AS postID, threadID FROM wbb1_post p LEFT JOIN wbb1_thread t USING (threadID) WHERE p.userID IN (?,?,?,?) AND t.boardID = ? GROUP BY t.threadID, postID ORDER BY postID DESC LIMIT 100')
#1 */forum/lib/system/cache/builder/TeamTrackBoardCacheBuilder.class.php (31):
wbb\system\cache\builder\TeamTrackBoardCacheBuilder->update([ ], [ 0 => ])
#2 */forum/lib/system/event/listener/TeamTrackerBoardListener.class.php (31):
wbb\system\cache\builder\TeamTrackBoardCacheBuilder->getData([ ], 13)
#3 */lib/system/event/EventHandler.class.php (228):
wbb\system\event\listener\TeamTrackerBoardListener->execute(wbb\page\BoardListPage, 'wbb\\page\\BoardListPage', 'assignVariables')
#4 */lib/page/AbstractPage.class.php (141):
wcf\system\event\EventHandler->fireAction(wbb\page\BoardListPage, 'assignVariables')
#5 */forum/lib/page/BoardListPage.class.php (76):
wcf\page\AbstractPage->assignVariables()
#6 */lib/page/AbstractPage.class.php (294):
wbb\page\BoardListPage->assignVariables()
#7 */lib/page/AbstractPage.class.php (114):
wcf\page\AbstractPage->show()
#8 */lib/system/request/Request.class.php (83):
wcf\page\AbstractPage->__run()
#9 */lib/system/request/RequestHandler.class.php (96):
wcf\system\request\Request->execute()
#10 */forum/index.php (9):
wcf\system\request\RequestHandler->handle('wbb')

Display More

Batarjal Oct 1st 2018 Author

Hallo - Ein Fix dafür sollte bald freigeschlatet werden. Ich habe dir die neue Version schnmal per PM geschickt.
enskyeu Oct 1st 2018

Dankeschön werde ihn gleich testen
MY-WSC.de Oct 2nd 2018

Häng mich dran , wegen Dem Fehler .Habs erstmal wieder Deinstalliert
Batarjal Oct 2nd 2018 Author

Hast eine PM
1
MY-WSC.de Oct 2nd 2018

Dank Dir.

Rasselbande Sep 29th 2018

Wär super, wenn man Benutzergruppen einzeln dafür aktivieren könnte. Aktuell bedient sich das Tool der Einstellung "Auf der Team-Seite anzeigen".

Und wie sieht es mit mehreren Team Antworten im Thread aus? Aktuell führt der Icon-Link nur zur ersten Antwort, oder wie kann man die nacheinander durchgehen, wenn mehrere im Thread sind?

Außerdem wäre eine optische Markierung von Team-Beiträgen super, zB. andere Hintergrund-Farbe der Team-Posts im Thread?

PS: Kann mir jemand erklären, wie ich die Farbe des FA-Icons anpasse?
- Batarjal Sep 29th 2018 Author
  
  Code
  
  .teamTrackerBadgeBoard { color: blue } .teamTrackerBadge { color: blue }
  
  Für Forum und Thread.
  
  Es wird immer die neuste Team-Antwort angezeigt.
  Frei wählbare Benutzergruppen und Icons für 'vorherige Antwort' kommen je nach Nachfrage in zukünftigen Versionen.
- StandbyGamer Oct 2nd 2018
  
  Bei den Frei wählbare Benutzergruppen und Icons hätte ich auch Interesse, das wäre sehr nützlich.
Rasselbande Sep 29th 2018

Tolle Idee! Habe es direkt gekauft. Nach der Installation beim Aufruf der Seite allerdings folgende Fehlermeldung.
Habe es vorerst wieder deinstalliert und hoffe auf gewohnt schnelle Hilfe

Display Spoiler

Sat, 29 Sep 2018 19:32:18 +0000

Message: Could not prepare statement 'SELECT MAX(postID) AS postID, threadID FROM wbb1_post p LEFT JOIN wbb1_thread t USING (threadID) WHERE p.userID IN (?,?,?,?,?,?,?,?,?,?) AND t.boardID = ? GROUP BY t.threadID, postID ORDER BY postID DESC LIMIT 100'

PHP version: 7.2.10

WoltLab Suite version: 3.1.5 pl 1

Request URI: /news/

Referrer:

User Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/12.0 Safari/605.1.15

Peak Memory Usage: 14999888/536870912

======

Error Class: wcf\system\database\exception\DatabaseQueryException

Error Message: Could not prepare statement 'SELECT MAX(postID) AS postID, threadID FROM wbb1_post p LEFT JOIN wbb1_thread t USING (threadID) WHERE p.userID IN (?,?,?,?,?,?,?,?,?,?) AND t.boardID = ? GROUP BY t.threadID, postID ORDER BY postID DESC LIMIT 100'

Error Code: 42000

File: /var/www/vhosts/circleofelements.de/rasselbande/lib/system/database/Database.class.php (248)

Extra Information: -

Stack Trace: [{"file":"\/var\/www\/vhosts\/circleofelements.de\/rasselbande\/forum\/lib\/system\/cache\/builder\/TeamTrackBoardCacheBuilder.class.php","line":75,"function":"prepareStatement","class":"wcf\\system\\database\\Database","type":"->","args":["SELECT MAX(postID) AS postID, threadID FROM wbb1_post p LEFT JOIN wbb1_thread t USING (threadID) WHERE p.userID IN (?,?,?,?,?,?,?,?,?,?) AND t.boardID = ? GROUP BY t.threadID, postID ORDER BY postID DESC LIMIT 100"]},{"file":"\/var\/www\/vhosts\/circleofelements.de\/rasselbande\/forum\/lib\/system\/cache\/builder\/TeamTrackBoardCacheBuilder.class.php","line":31,"function":"update","class":"wbb\\system\\cache\\builder\\TeamTrackBoardCacheBuilder","type":"->","args":[[],["[redacted]"]]},{"file":"\/var\/www\/vhosts\/circleofelements.de\/rasselbande\/forum\/lib\/system\/event\/listener\/TeamTrackerThreadListener.class.php","line":39,"function":"getData","class":"wbb\\system\\cache\\builder\\TeamTrackBoardCacheBuilder","type":"->","args":[[],32]},{"file":"\/var\/www\/vhosts\/circleofelements.de\/rasselbande\/lib\/system\/event\/EventHandler.class.php","line":228,"function":"execute","class":"wbb\\system\\event\\listener\\TeamTrackerThreadListener","type":"->","args":["wbb\\system\\box\\ThreadListBoxController","wbb\\system\\box\\ThreadListBoxController","readObjects"]},{"file":"\/var\/www\/vhosts\/circleofelements.de\/rasselbande\/lib\/system\/box\/AbstractDatabaseObjectListBoxController.class.php","line":253,"function":"fireAction","class":"wcf\\system\\event\\EventHandler","type":"->","args":["wbb\\system\\box\\ThreadListBoxController","readObjects"]},{"file":"\/var\/www\/vhosts\/circleofelements.de\/rasselbande\/forum\/lib\/system\/box\/ThreadListBoxController.class.php","line":134,"function":"readObjects","class":"wcf\\system\\box\\AbstractDatabaseObjectListBoxController","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/circleofelements.de\/rasselbande\/lib\/system\/box\/AbstractDatabaseObjectListBoxController.class.php","line":231,"function":"readObjects","class":"wbb\\system\\box\\ThreadListBoxController","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/circleofelements.de\/rasselbande\/lib\/system\/box\/AbstractDatabaseObjectListBoxController.class.php","line":202,"function":"loadContent","class":"wcf\\system\\box\\AbstractDatabaseObjectListBoxController","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/circleofelements.de\/rasselbande\/lib\/data\/box\/Box.class.php","line":278,"function":"hasContent","class":"wcf\\system\\box\\AbstractDatabaseObjectListBoxController","type":"->","args":[]},{"function":"hasContent","class":"wcf\\data\\box\\Box","type":"->","args":[],"file":"[internal function]","line":"?"},{"file":"\/var\/www\/vhosts\/circleofelements.de\/rasselbande\/lib\/data\/DatabaseObjectDecorator.class.php","line":86,"function":"call_user_func_array","args":[["[redacted]","[redacted]"],[]],"class":"","type":""},{"file":"\/var\/www\/vhosts\/circleofelements.de\/rasselbande\/lib\/data\/box\/PhpBox.class.php","line":20,"function":"__call","class":"wcf\\data\\DatabaseObjectDecorator","type":"->","args":["hasContent",[]]},{"file":"\/var\/www\/vhosts\/circleofelements.de\/rasselbande\/templates\/compiled\/2_news_1_categoryList.php","line":4199,"function":"render","class":"wcf\\data\\box\\PhpBox","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/circleofelements.de\/rasselbande\/lib\/system\/template\/TemplateEngine.class.php","line":321,"args":["\/var\/www\/vhosts\/circleofelements.de\/rasselbande\/templates\/compiled\/2_news_1_categoryList.php"],"function":"include","class":"","type":""},{"file":"\/var\/www\/vhosts\/circleofelements.de\/rasselbande\/lib\/page\/AbstractPage.class.php","line":323,"function":"display","class":"wcf\\system\\template\\TemplateEngine","type":"->","args":["categoryList","news"]},{"file":"\/var\/www\/vhosts\/circleofelements.de\/rasselbande\/lib\/page\/AbstractPage.class.php","line":114,"function":"show","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/circleofelements.de\/rasselbande\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/circleofelements.de\/rasselbande\/lib\/system\/request\/RequestHandler.class.php","line":96,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/circleofelements.de\/rasselbande\/news\/index.php","line":10,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["news"]}]

======

Error Class: PDOException

Error Message: SQLSTATE[42000]: Syntax error or access violation: 1055 'web28_rasselbande.p.threadID' isn't in GROUP BY

Error Code: 42000

File: /var/www/vhosts/circleofelements.de/rasselbande/lib/system/database/Database.class.php (243)

Extra Information: -

Stack Trace: [{"file":"\/var\/www\/vhosts\/circleofelements.de\/rasselbande\/lib\/system\/database\/Database.class.php","line":243,"function":"prepare","class":"PDO","type":"->","args":["SELECT MAX(postID) AS postID, threadID FROM wbb1_post p LEFT JOIN wbb1_thread t USING (threadID) WHERE p.userID IN (?,?,?,?,?,?,?,?,?,?) AND t.boardID = ? GROUP BY t.threadID, postID ORDER BY postID DESC LIMIT 100"]},{"file":"\/var\/www\/vhosts\/circleofelements.de\/rasselbande\/forum\/lib\/system\/cache\/builder\/TeamTrackBoardCacheBuilder.class.php","line":75,"function":"prepareStatement","class":"wcf\\system\\database\\Database","type":"->","args":["SELECT MAX(postID) AS postID, threadID FROM wbb1_post p LEFT JOIN wbb1_thread t USING (threadID) WHERE p.userID IN (?,?,?,?,?,?,?,?,?,?) AND t.boardID = ? GROUP BY t.threadID, postID ORDER BY postID DESC LIMIT 100"]},{"file":"\/var\/www\/vhosts\/circleofelements.de\/rasselbande\/forum\/lib\/system\/cache\/builder\/TeamTrackBoardCacheBuilder.class.php","line":31,"function":"update","class":"wbb\\system\\cache\\builder\\TeamTrackBoardCacheBuilder","type":"->","args":[[],["[redacted]"]]},{"file":"\/var\/www\/vhosts\/circleofelements.de\/rasselbande\/forum\/lib\/system\/event\/listener\/TeamTrackerThreadListener.class.php","line":39,"function":"getData","class":"wbb\\system\\cache\\builder\\TeamTrackBoardCacheBuilder","type":"->","args":[[],32]},{"file":"\/var\/www\/vhosts\/circleofelements.de\/rasselbande\/lib\/system\/event\/EventHandler.class.php","line":228,"function":"execute","class":"wbb\\system\\event\\listener\\TeamTrackerThreadListener","type":"->","args":["wbb\\system\\box\\ThreadListBoxController","wbb\\system\\box\\ThreadListBoxController","readObjects"]},{"file":"\/var\/www\/vhosts\/circleofelements.de\/rasselbande\/lib\/system\/box\/AbstractDatabaseObjectListBoxController.class.php","line":253,"function":"fireAction","class":"wcf\\system\\event\\EventHandler","type":"->","args":["wbb\\system\\box\\ThreadListBoxController","readObjects"]},{"file":"\/var\/www\/vhosts\/circleofelements.de\/rasselbande\/forum\/lib\/system\/box\/ThreadListBoxController.class.php","line":134,"function":"readObjects","class":"wcf\\system\\box\\AbstractDatabaseObjectListBoxController","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/circleofelements.de\/rasselbande\/lib\/system\/box\/AbstractDatabaseObjectListBoxController.class.php","line":231,"function":"readObjects","class":"wbb\\system\\box\\ThreadListBoxController","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/circleofelements.de\/rasselbande\/lib\/system\/box\/AbstractDatabaseObjectListBoxController.class.php","line":202,"function":"loadContent","class":"wcf\\system\\box\\AbstractDatabaseObjectListBoxController","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/circleofelements.de\/rasselbande\/lib\/data\/box\/Box.class.php","line":278,"function":"hasContent","class":"wcf\\system\\box\\AbstractDatabaseObjectListBoxController","type":"->","args":[]},{"function":"hasContent","class":"wcf\\data\\box\\Box","type":"->","args":[],"file":"[internal function]","line":"?"},{"file":"\/var\/www\/vhosts\/circleofelements.de\/rasselbande\/lib\/data\/DatabaseObjectDecorator.class.php","line":86,"function":"call_user_func_array","args":[["[redacted]","[redacted]"],[]],"class":"","type":""},{"file":"\/var\/www\/vhosts\/circleofelements.de\/rasselbande\/lib\/data\/box\/PhpBox.class.php","line":20,"function":"__call","class":"wcf\\data\\DatabaseObjectDecorator","type":"->","args":["hasContent",[]]},{"file":"\/var\/www\/vhosts\/circleofelements.de\/rasselbande\/templates\/compiled\/2_news_1_categoryList.php","line":4199,"function":"render","class":"wcf\\data\\box\\PhpBox","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/circleofelements.de\/rasselbande\/lib\/system\/template\/TemplateEngine.class.php","line":321,"args":["\/var\/www\/vhosts\/circleofelements.de\/rasselbande\/templates\/compiled\/2_news_1_categoryList.php"],"function":"include","class":"","type":""},{"file":"\/var\/www\/vhosts\/circleofelements.de\/rasselbande\/lib\/page\/AbstractPage.class.php","line":323,"function":"display","class":"wcf\\system\\template\\TemplateEngine","type":"->","args":["categoryList","news"]},{"file":"\/var\/www\/vhosts\/circleofelements.de\/rasselbande\/lib\/page\/AbstractPage.class.php","line":114,"function":"show","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/circleofelements.de\/rasselbande\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/circleofelements.de\/rasselbande\/lib\/system\/request\/RequestHandler.class.php","line":96,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/circleofelements.de\/rasselbande\/news\/index.php","line":10,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["news"]}]
- Batarjal Sep 29th 2018 Author
  
  Sorry für die Probleme - Habe leider eine andere MySQL-Version auf meinen Testsystemen. Ich habe dir einen Fix per PM geschickt.
  1
- Rasselbande Sep 29th 2018
  
  Danke! Du bist echt blitzschnell!
Viper850 Sep 28th 2018
Mir hats leider beim installieren gerade nen Fehler gebracht

Display Spoiler

Error Type:

PDOException

Error Message:

SQLSTATE[42000]: Syntax error or access violation: 1055 'wcf.p.threadID' isn't in GROUP BY

Error Code:

42000

File:

*/lib/system/database/Database.class.php (243)

Stack Trace:

#0 */lib/system/database/Database.class.php (243):

PDO->prepare('SELECT MAX(postID) AS postID, threadID FROM wbb1_post p LEFT JOIN wbb1_thread t USING (threadID) WHERE p.userID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND t.boardID = ? GROUP BY t.threadID, postID ORDER BY postID DESC LIMIT 100')

#1 */forum/lib/system/cache/builder/TeamTrackBoardCacheBuilder.class.php (75):

wcf\system\database\Database->prepareStatement('SELECT MAX(postID) AS postID, threadID FROM wbb1_post p LEFT JOIN wbb1_thread t USING (threadID) WHERE p.userID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND t.boardID = ? GROUP BY t.threadID, postID ORDER BY postID DESC LIMIT 100')

#2 */forum/lib/system/cache/builder/TeamTrackBoardCacheBuilder.class.php (31):

wbb\system\cache\builder\TeamTrackBoardCacheBuilder->update([ ], [ 0 => ])

#3 */forum/lib/system/event/listener/TeamTrackerBoardListener.class.php (31):

wbb\system\cache\builder\TeamTrackBoardCacheBuilder->getData([ ], 221)

#4 */lib/system/event/EventHandler.class.php (228):

wbb\system\event\listener\TeamTrackerBoardListener->execute(wbb\page\BoardListPage, 'wbb\\page\\BoardListPage', 'assignVariables')

#5 */lib/page/AbstractPage.class.php (141):

wcf\system\event\EventHandler->fireAction(wbb\page\BoardListPage, 'assignVariables')

#6 */forum/lib/page/BoardListPage.class.php (76):

wcf\page\AbstractPage->assignVariables()

#7 */lib/page/AbstractPage.class.php (294):

wbb\page\BoardListPage->assignVariables()

#8 */lib/page/AbstractPage.class.php (114):

wcf\page\AbstractPage->show()

#9 */lib/system/request/Request.class.php (83):

wcf\page\AbstractPage->__run()

#10 */lib/system/request/RequestHandler.class.php (96):

wcf\system\request\Request->execute()

#11 */forum/index.php (9):

wcf\system\request\RequestHandler->handle('wbb')
- Batarjal Sep 28th 2018 Author
  
  Hallo - Ich habe dir eine PM geschickt.

Customers Who Bought This File Also Bought

Community Bot
- UdoZ
- Monday, 3:02 pm
- (5)
New The 'Swiss Knife' for your community.

EUR 9.97
- 35
- 2.7k Downloads
- 898 Purchases
Teaser Slideshow Pro
- Darkwood.Design
- May 13th 2022
- (2)
New Allows you to create a modern slideshow with teaser as an eye catcher in your dashboard and/or forum.

WoltLab Cloud
EUR 12.99
- 85
- 3.2k Downloads
- 1k Purchases
Modern Shoutbox Pro
- Darkwood.Design
- May 9th 2022
- (10)
New This plugin provides a clean and modern shoutbox for your community.

WoltLab Cloud
EUR 5.95
- 292
- 19k Downloads
- 4.8k Purchases
Donation Plugin (Paypal, PSC, Bank Transfer)
- Darkwood.Design
- Feb 8th 2022
- (1)
The original Donation Plugin (Paypal, PSC, Bank Transfer)

WoltLab Cloud
EUR 19.99
- 111
- 6.1k Downloads
- 1.4k Purchases

File Details

License Agreement: noexcept.de Lizenz
Website: noexcept.de
Supported Versions: WoltLab Suite 3.0
WoltLab Suite 3.1
WoltLab Suite 5.2
WoltLab Suite 5.3
WoltLab Suite 5.4

More Files by Batarjal

Profile Integration for Steam 2020
Batarjal Jan 9th 2020
ThreadStarter: Movies
Batarjal Dec 11th 2017
ThreadStarter: Base
Batarjal Oct 18th 2018
ThreadStarter: Music
Batarjal Oct 18th 2018
ThreadStarter: Steam
Batarjal Jun 17th 2018

All Files

Features

Live Demo

Screenshots

Version 1.0.5

Version 1.0.4

Version 1.0.3

Version 1.0.2

Version 1.0.0

Darklord May 30th 2020

Batarjal Jun 1st 2020 Author

Darklord Apr 2nd 2020

Batarjal Apr 2nd 2020 Author

Darklord May 8th 2020

Rasselbande Oct 10th 2018

Batarjal Oct 18th 2018 Author

Batarjal Oct 23rd 2018 Author

Rasselbande Oct 10th 2018

Batarjal Oct 10th 2018 Author

Rasselbande Oct 7th 2018

Batarjal Oct 7th 2018 Author

Rasselbande Oct 8th 2018

Grischabock Oct 4th 2018

Batarjal Oct 4th 2018 Author

Grischabock Oct 4th 2018

Batarjal Oct 23rd 2018 Author

Grischabock Oct 23rd 2018

WoltNet Oct 11th 2019

enskyeu Oct 1st 2018

Batarjal Oct 1st 2018 Author

enskyeu Oct 1st 2018

MY-WSC.de Oct 2nd 2018

Batarjal Oct 2nd 2018 Author

MY-WSC.de Oct 2nd 2018

Rasselbande Sep 29th 2018

Batarjal Sep 29th 2018 Author

StandbyGamer Oct 2nd 2018

Rasselbande Sep 29th 2018

Batarjal Sep 29th 2018 Author

Rasselbande Sep 29th 2018

Viper850 Sep 28th 2018

Batarjal Sep 28th 2018 Author

Customers Who Bought This File Also Bought