Thread:Project:Support desk/Offering a read only wiki hosted on a MySQL read only database won't work because of SQL delete queries

Hello, we want to host a read only version in Europe of a wiki running on a remote site. For that, the WikiDb gets synced to Europe every morning and we would like to use this read only db (the user does only have read rights for the wiki tables). We are using Fedora12 64 bit, MediaWiki 1.15.4, PHP 5.3.3. and MySql 5.1.47. The Wiki is set to ReadOnly mode using the wgReadOnly option in the LocalSettings.php file. The SQL error is the following: A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:

DELETE FROM `objectcache` WHERE keyname='wiki-Wiki:messages:en'

from within function "MediaWikiBagOStuff::_doquery". Database returned error "1142: DELETE command denied to user 'user'@'192.168.0.25' for table 'objectcache' (192.168.0.25:3307)".

DO I have to grant write access to the cache tables of the wiki and disable the sync for them or is there another possibility?