https://bugzilla.wikimedia.org/show_bug.cgi?id=16521
Summary: SiteStatsUpdate warning with MySQL 5.1.30
Product: MediaWiki
Version: 1.13.2
Platform: All
OS/Version: All
Status: NEW
Severity: normal
Priority: Normal
Component: Database
AssignedTo: [email protected]
ReportedBy: [EMAIL PROTECTED]
I just upgraded my database to MySQL 5.1.30 and now I get warnings for every
MediaWiki page access in /var/log/mysqld.log file. Here's the warning message:
081201 9:56:37 [Warning] Statement is not safe to log in statement format.
Statement: UPDATE /* SiteStatsUpdate::doUpdate Dmulter */ `site_stats` SET
ss_total_views=ss_total_views+1 LIMIT 1
It appears to be an update performed as part of computing the "This page has
been accessed XXX times" message in the footer.
As an aside, I also had to rebuild my searchindex table as I was getting errors
after the update for that as well.
I'm guessing the 5.1.x series introduced some issues with MediaWiki. I was
running MySQL 5.0.67 before the upgrade. I'm running the latest MediaWiki
1.13.2 release.
--
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
You are watching all bug changes.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
