Topic on Project:Support desk

Warnings after Migrating from MySql to sqlite3

2
Cbo0485 (talkcontribs)

Due to reasons out of my control I had to move my instance of mediawiki from mysql to sqlite3.

New Version Info:

MW 1.25.1

php 5.6.9 (apache2handler)

SQLite 3.8.8.3 with full-text search support

In doing so it went pretty smooth, I followed the basic directions found at:

http://www.linuxintro.org/wiki/Migrating_mediawiki_from_mysql_to_sqlite

As far as I can tell all the functionality is working. I can browse from page to page, viewing images works, creating new pages works, modifying existing pages works. But on every page I have the following at the top of the page:

Notice: unserialize(): Error at offset 65 of 6279 bytes in /opt/apps/asa/apache/asaSite/htdocs/wiki/includes/cache/LocalisationCache.php on line 1161

Warning: Invalid argument supplied for foreach() in /opt/apps/asa/apache/asaSite/htdocs/wiki/includes/cache/LocalisationCache.php on line 411

This also shows up when trying to add an image to a page when using the WYSIWYG editor. Images do still work though, b/c if I switch over to the Source portion in WYSIWYG, and type in the mediawiki syntax to add an image, the image shows up on the page.

83.135.228.180 (talkcontribs)

Since the localization cache only is a cache, I would try emptying it. I guess you can delete the cache files in folder htdocs/wiki/cache/ and also, as far as there are contents in the database table Manual:L10n cache table, you should be able to clean this table as well.

The maintenance script Manual:RebuildLocalisationCache.php can be used to rebuild the cache.

Manual:LocalisationCache might provide a somewhat deeper insight.

Reply to "Warnings after Migrating from MySql to sqlite3"