Hallo zusammen,
seit heute morgen bekomme ich beim Zugriff auf mein Piwik folgende Fehlermeldung:
SQLSTATE[42000]: Syntax error or access violation: 1064 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 'DEFAULT CHARSET=utf8' at line 13
Laut Hosteurope ist nichts am Webspace (mit PHP 5.3.28 und MySQL 5.5.35) geändert worden, ich selbst habe auch nichts verändert. Meine config.ini.php sieht so aus:
; <?php exit; ?> DO NOT REMOVE THIS LINE
; file automatically generated or modified by Piwik; you can manually override the default values in global.ini.php by redefining them in this file.
[database]
host = "localhost"
username = "xxx"
password = "xxx"
dbname = "xx"
tables_prefix = "piwik_"
schema = "Myisam"
[General]
trusted_hosts[] = "xxx.xxx.x"
salt = "a1fdea5b7f13970f040f67324bf0a073"
[log]
log_writers[] = file
[Deletelogs]
delete_logs_enable = 1
delete_max_rows_per_run = 100
[mail]
transport = "smtp"
port = 25
host = "xxx"
type = "Login"
username = "xxx"
password = "xxxx"
encryption = "tls"
; character used to automatically create categories in the Actions > Pages, Outlinks and Downloads reports
; for example a URL like "example.com/blog/development/first-post" will create
; the page first-post in the subcategory development which belongs to the blog category
action_url_category_delimiter = /
; similar to above, but this delimiter is only used for page titles in the Actions > Page titles report
action_title_category_delimiter = >
[Plugins]
Plugins[] = "CorePluginsAdmin"
Plugins[] = "CoreAdminHome"
Plugins[] = "CoreHome"
Plugins[] = "API"
Plugins[] = "LanguagesManager"
Plugins[] = "UsersManager"
Plugins[] = "SitesManager"
Plugins[] = "CoreUpdater"
Plugins[] = "Installation"
Plugins[] = "Proxy"
Plugins[] = "Login"
Plugins[] = "VisitTime"
Plugins[] = "VisitsSummary"
Plugins[] = "VisitorInterest"
Plugins[] = "VisitFrequency"
Plugins[] = "UserSettings"
Plugins[] = "UserCountryMap"
Plugins[] = "UserCountry"
Plugins[] = "Transitions"
Plugins[] = "SEO"
Plugins[] = "Provider"
Plugins[] = "PrivacyManager"
Plugins[] = "Overlay"
Plugins[] = "MultiSites"
Plugins[] = "Live"
Plugins[] = "ImageGraph"
Plugins[] = "Goals"
Plugins[] = "Dashboard"
Plugins[] = "Annotations"
Plugins[] = "Actions"
Plugins[] = "Widgetize"
Plugins[] = "CustomVariables"
Plugins[] = "SegmentEditor"
Plugins[] = "Referrers"
Plugins[] = "ScheduledReports"
Plugins[] = "Events"
Plugins[] = "CoreConsole"
Plugins[] = "CoreVisualizations"
Plugins[] = "Zeitgeist"
Plugins[] = "DBStats"
Plugins[] = "DevicesDetection"
Plugins[] = "LiveTab"
Plugins[] = "Morpheus"
[PluginsInstalled]
PluginsInstalled[] = "Login"
PluginsInstalled[] = "CoreAdminHome"
PluginsInstalled[] = "UsersManager"
PluginsInstalled[] = "SitesManager"
PluginsInstalled[] = "Installation"
PluginsInstalled[] = "CorePluginsAdmin"
PluginsInstalled[] = "CoreHome"
PluginsInstalled[] = "API"
PluginsInstalled[] = "Widgetize"
PluginsInstalled[] = "LanguagesManager"
PluginsInstalled[] = "Actions"
PluginsInstalled[] = "Dashboard"
PluginsInstalled[] = "UserSettings"
PluginsInstalled[] = "UserCountry"
PluginsInstalled[] = "VisitsSummary"
PluginsInstalled[] = "VisitFrequency"
PluginsInstalled[] = "VisitTime"
PluginsInstalled[] = "VisitorInterest"
PluginsInstalled[] = "ExampleAPI"
PluginsInstalled[] = "ExamplePlugin"
PluginsInstalled[] = "ExampleRssWidget"
PluginsInstalled[] = "Provider"
PluginsInstalled[] = "Feedback"
PluginsInstalled[] = "CoreUpdater"
PluginsInstalled[] = "Live"
PluginsInstalled[] = "Goals"
PluginsInstalled[] = "DBStats"
PluginsInstalled[] = "MultiSites"
PluginsInstalled[] = "Forecast"
PluginsInstalled[] = "Weekday"
PluginsInstalled[] = "TranslationsAdmin"
PluginsInstalled[] = "SEO"
PluginsInstalled[] = "UserCountryMap"
PluginsInstalled[] = "Proxy"
PluginsInstalled[] = "CustomVariables"
PluginsInstalled[] = "PrivacyManager"
PluginsInstalled[] = "ImageGraph"
PluginsInstalled[] = "DoNotTrack"
PluginsInstalled[] = "Transitions"
PluginsInstalled[] = "Annotations"
PluginsInstalled[] = "MobileMessaging"
PluginsInstalled[] = "Overlay"
PluginsInstalled[] = "SegmentEditor"
PluginsInstalled[] = "CoreConsole"
PluginsInstalled[] = "CoreVisualizations"
PluginsInstalled[] = "Zeitgeist"
PluginsInstalled[] = "Referrers"
PluginsInstalled[] = "ScheduledReports"
PluginsInstalled[] = "Events"
PluginsInstalled[] = "Morpheus"
PluginsInstalled[] = "DevicesDetection"
PluginsInstalled[] = "LiveTab"
PluginsInstalled[] = "LeftMenu"
PluginsInstalled[] = "ExampleTheme"
[Plugins_Tracker]
Plugins_Tracker[] = "Provider"
Plugins_Tracker[] = "Goals"
Plugins_Tracker[] = "UserCountry"
Plugins_Tracker[] = "UsersManager"
Plugins_Tracker[] = "SitesManager"
Plugins_Tracker[] = "DevicesDetection"
Plugins_Tracker[] = "PrivacyManager"
Plugins_Tracker[] = "Login"
Ich hab auch schon versucht, die Schemaoption zu setzen, wie in diesem Thread vorgeschlagen, aber das hat lediglich die Fehlermeldung bei “adapter = MYSQLI” geändert.
Hat jemand eine Idee, wo hier das Problem ist?