Issue

Statistiken werden teilweise nicht aktualisiert
Issue #151
-
WCF Statistics
andi2288
Low
Open
0%
  • Hallo


    z.B. sind die Beiträge diesen Monat von einzelnen User höher wie die gesamten Beiträge diesen Monat.

    Andere Werte die sich auf einen Monat beziehen sehen auch komisch aus. Mir ist allerdings nicht klar ob ihr Monat immer als Kalendermonat sehr oder teilweise als 4 Wochen.

    Wenn ihr sie immer als Kalendermonat seht stimmen einige andere WErte nicht.

    Folgende Fehlermeldung habe ich in den Logs gefunden.

    Tue, 31 Mar 2020 12:16:20 +0000

    Message: Could not prepare statement 'SELECT COUNT(*) FROM wcf1_statistics_view statistics_view WHERE updated = ? AND pageName = ?'

    PHP version: 7.3.11-nmm1

    WoltLab Suite version: 5.2.4

    Request URI: /index.php?dashboard/

    Referrer: http://www.dein-lieblingsforum.de/index.php?statistics/

    User Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:74.0) Gecko/20100101 Firefox/74.0

    Peak Memory Usage: 5014016/134217728

    ======

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

    Error Message: Could not prepare statement 'SELECT COUNT(*) FROM wcf1_statistics_view statistics_view WHERE updated = ? AND pageName = ?'

    Error Code: 42

    File: /www/htdocs/w00f3f94/deinlieblingsforum/lib/system/database/Database.class.php (284)

    Extra Information: -

    Stack Trace: [{"file":"\/www\/htdocs\/w00f3f94\/deinlieblingsforum\/lib\/data\/DatabaseObjectList.class.php","line":148,"function":"prepareStatement","class":"wcf\\system\\database\\Database","type":"->","args":["SELECT\tCOUNT(*)\n\t\t\tFROM\twcf1_statistics_view statistics_view\n\t\t\t\n\t\t\tWHERE updated = ? AND pageName = ?"]},{"file":"\/www\/htdocs\/w00f3f94\/deinlieblingsforum\/lib\/data\/statistics\/ViewEditor.class.php","line":41,"function":"countObjects","class":"wcf\\data\\DatabaseObjectList","type":"->","args":[]},{"file":"\/www\/htdocs\/w00f3f94\/deinlieblingsforum\/lib\/system\/event\/listener\/StatisticsListener.class.php","line":28,"function":"createOrUpdate","class":"wcf\\data\\statistics\\ViewEditor","type":"::","args":["Cms"]},{"file":"\/www\/htdocs\/w00f3f94\/deinlieblingsforum\/lib\/system\/event\/EventHandler.class.php","line":144,"function":"execute","class":"wcf\\system\\event\\listener\\StatisticsListener","type":"->","args":["wcf\\page\\CmsPage","wcf\\page\\CmsPage","show"]},{"file":"\/www\/htdocs\/w00f3f94\/deinlieblingsforum\/lib\/system\/event\/EventHandler.class.php","line":177,"function":"executeInheritedActions","class":"wcf\\system\\event\\EventHandler","type":"->","args":["wcf\\page\\CmsPage","show","wcf\\page\\CmsPage","show@wcf\\page\\CmsPage",[]]},{"file":"\/www\/htdocs\/w00f3f94\/deinlieblingsforum\/lib\/page\/AbstractPage.class.php","line":297,"function":"fireAction","class":"wcf\\system\\event\\EventHandler","type":"->","args":["wcf\\page\\CmsPage","show"]},{"file":"\/www\/htdocs\/w00f3f94\/deinlieblingsforum\/lib\/page\/AbstractPage.class.php","line":114,"function":"show","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/www\/htdocs\/w00f3f94\/deinlieblingsforum\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/www\/htdocs\/w00f3f94\/deinlieblingsforum\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/www\/htdocs\/w00f3f94\/deinlieblingsforum\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf"]}]

    ======

    Error Class: PDOException

    Error Message: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'd031a07d.wcf1_statistics_view' doesn't exist

    Error Code: 42

    File: /www/htdocs/w00f3f94/deinlieblingsforum/lib/system/database/Database.class.php (279)

    Extra Information: -

    Stack Trace: [{"file":"\/www\/htdocs\/w00f3f94\/deinlieblingsforum\/lib\/system\/database\/Database.class.php","line":279,"function":"prepare","class":"PDO","type":"->","args":["SELECT\tCOUNT(*)\n\t\t\tFROM\twcf1_statistics_view statistics_view\n\t\t\t\n\t\t\tWHERE updated = ? AND pageName = ? -- '\/index.php?dashboard\/'"]},{"file":"\/www\/htdocs\/w00f3f94\/deinlieblingsforum\/lib\/data\/DatabaseObjectList.class.php","line":148,"function":"prepareStatement","class":"wcf\\system\\database\\Database","type":"->","args":["SELECT\tCOUNT(*)\n\t\t\tFROM\twcf1_statistics_view statistics_view\n\t\t\t\n\t\t\tWHERE updated = ? AND pageName = ?"]},{"file":"\/www\/htdocs\/w00f3f94\/deinlieblingsforum\/lib\/data\/statistics\/ViewEditor.class.php","line":41,"function":"countObjects","class":"wcf\\data\\DatabaseObjectList","type":"->","args":[]},{"file":"\/www\/htdocs\/w00f3f94\/deinlieblingsforum\/lib\/system\/event\/listener\/StatisticsListener.class.php","line":28,"function":"createOrUpdate","class":"wcf\\data\\statistics\\ViewEditor","type":"::","args":["Cms"]},{"file":"\/www\/htdocs\/w00f3f94\/deinlieblingsforum\/lib\/system\/event\/EventHandler.class.php","line":144,"function":"execute","class":"wcf\\system\\event\\listener\\StatisticsListener","type":"->","args":["wcf\\page\\CmsPage","wcf\\page\\CmsPage","show"]},{"file":"\/www\/htdocs\/w00f3f94\/deinlieblingsforum\/lib\/system\/event\/EventHandler.class.php","line":177,"function":"executeInheritedActions","class":"wcf\\system\\event\\EventHandler","type":"->","args":["wcf\\page\\CmsPage","show","wcf\\page\\CmsPage","show@wcf\\page\\CmsPage",[]]},{"file":"\/www\/htdocs\/w00f3f94\/deinlieblingsforum\/lib\/page\/AbstractPage.class.php","line":297,"function":"fireAction","class":"wcf\\system\\event\\EventHandler","type":"->","args":["wcf\\page\\CmsPage","show"]},{"file":"\/www\/htdocs\/w00f3f94\/deinlieblingsforum\/lib\/page\/AbstractPage.class.php","line":114,"function":"show","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/www\/htdocs\/w00f3f94\/deinlieblingsforum\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/www\/htdocs\/w00f3f94\/deinlieblingsforum\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/www\/htdocs\/w00f3f94\/deinlieblingsforum\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf"]}]




  • Hallo,


    bei Foren und Benutzern sind es immer die letzten 30 Tage. Wie oft die Daten aktualisiert werden kann man im ACP einstellen.

    Beim Verlauf sind es die Beiträge im Jeweiligen Monat.

    Ich werde die Namensgebung in der nächsten Version etwas eindeutiger gestalten.


    Tritt der fehler häufig auf? Da scheint eine Tabelle zu fehlen, ggf. ging etwas bei der installation schief?

  • Hi


    der Fehler ist nur ein mal im Log.

    Bei der Installation lief alles ohne Meldung durch.

    vg

    Andreas

  • :mad:
  • :)
  • :(
  • ;)
  • :P
  • ^^
  • :D
  • ;(
  • X(
  • :*
  • :|
  • 8o
  • =O
  • <X
  • ||
  • :/
  • :S
  • X/
  • 8)
  • ?(
  • :huh:
  • :rolleyes:
  • :love:
  • 8|
  • :cursing:
  • :thumbdown:
  • :thumbup:
  • :sleeping:
  • :whistling:
  • :evil:
  • :saint:
  • <3
  • :!:
  • :?:
The maximum number of attachments: 10
Maximum File Size: 1.05 MB
Allowed extensions: bmp, gif, jpeg, jpg, pdf, png, tar, txt, zip

Verification (“reCAPTCHA”)