SQLSTATE[42000]: Syntax error or access violation


#1

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?


#2

Ach, vergessen: Die Piwikversion ist die 2.1.0


#3

Habe jetzt nochmal alle Dateien hochgeladen, da Piwik beim Ausführen des Installers eine fehlende Klasse angemeckert hat. Habe bisher die Updates über die automatische Aktualisierung durchgeführt. Jetzt funktioniert erstmal alles wieder.