Topic on Project:Support desk

Hi...

I'm running four interwikis sharing one pool wiki for the media files. After upgrading from 1.16 to 1.17 I'm getting an error, when I set $wgUseSharedUploads = true; in the LocalSettings.php of each interwiki.

Here is the error:

Warning: mysql_real_escape_string() expects parameter 2 to be resource, null
given in /html/wiki/en/w/includes/db/DatabaseMysql.php on line 318

Warning: mysql_real_escape_string() expects parameter 2 to be resource, null
given in /html/wiki/en/w/includes/db/DatabaseMysql.php on line 318

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in
/html/wiki/en/w/includes/db/DatabaseMysql.php on line 23

A database query syntax error has occurred. This may indicate a bug in the
software. The last attempted database query was: 
BEGIN
from within function "DatabaseBase::begin". Database returned error "0: ". 

Debug data:
Start request 

GET /wiki/Main_Page 
HTTP HEADERS: 
Accept: text/html, application/xml;q=0.9, application/xhtml+xml, image/png,
image/webp, image/jpeg, image/gif, image/x-xbitmap, */*;q=0.1 
Accept-Encoding: gzip, deflate 
Accept-Language: en,de;q=0.9,de-DE;q=0.8 
Cache-Control: no-cache 
Connection: Keep-Alive 
Cookie: database_3UserID=1; database_3UserName=Till+Kraemer;
database_3Token=1d8916427743c36ef3936c5f20a8c9e3; awc_startTime=20110814185359;
database_3_session=2bauhg71ti53lp57pfhqage6q2;
__utma=162725736.456536178.1297683604.1313346115.1313410956.169;
__utmb=162725736.37.10.1313410956; __utmc=162725736;
__utmz=162725736.1313410956.169.53.utmcsr=pool.domain.com|utmccn=(referral)|utmcmd=referral|utmcct=/wiki/Main_Page 
Host: en.domain.com 
Referer: http://en.domain.com/wiki/Till_Kraemer 
User-Agent: Opera/9.80 (Windows NT 6.1; U; en) Presto/2.9.168 Version/11.50 

CACHES: APCBagOStuff[main] APCBagOStuff[message] FakeMemCachedClient[parser] 
Unstubbing $wgParser on call of $wgParser::setFunctionHook from
SimpleSecurity::__construct 
Unstubbing $wgOut on call of $wgOut::_unstub from wfDebug 
Unstubbing $wgContLang on call of $wgContLang::getMagic from MagicWord::load 
LocalisationCache: using store LCStore_DB 
Unstubbing $wgMessageCache on call of $wgMessageCache::get from wfMsgGetKey 
Unstubbing $wgLang on call of $wgLang::getCode from MessageCache::get 
User: got user 1 from cache 
Connecting to 111.222.333.444 database_3... 
Connected to 111.222.333.444 database_3. 
User: loading options for user 1 from override cache. 
User: logged in from session 
User: loading options for user 1 from override cache. 
MessageCache::load: Loading en... got from global cache 
Use of MessageCache::addMessages is deprecated. [Called from
call_user_func_array in (internal function)] 
Use of MessageCache::addMessage is deprecated. [Called from setupSEOParserHooks
in /html/wiki/en/w/extensions/Add_HTML_Meta_and_Title.php at line 57] 
Fully initialised 
Title::getRestrictionTypes: applicable restriction types for Main Page are
edit,move,readOutputPage::checkLastModified: CACHE DISABLED 
User::isBlockedFrom: enter 
User::isBlockedFrom: asking isBlocked() 
User::isBlocked: enter 
User::getBlockedStatus: checking... 
IP: 555.666.777.888 
Block::load: '', '1', 1 
Article::view using parser cache: no 
Class SkinMonobook not found; skipped loading 
Article::view: doing uncached parse 
User::isBlockedFrom: enter 
User::isBlockedFrom: asking isBlocked() 
User::isBlocked: enter 
User::getBlockedStatus: already loaded. 
SiteStats::loadAndLazyInit: reading site_stats from slave 
SQL ERROR: 
User::isBlockedFrom: enter 
User::isBlockedFrom: asking isBlocked() 
User::isBlocked: enter 
User::getBlockedStatus: already loaded. 
Title::getRestrictionTypes: applicable restriction types for Main Page are
edit,move,read

It's very brutal, because no images show up, except for the pool wiki. I'm about to try MW 1.18 alpha, because I have no idea how to fix this and I really need the images.

Any help is more than appreciated!

Thanks + cheers,

P.S.: Is it possible to downgrade from 1.17 to 1.16? And if so, do I have to change the databases in some way?

If needed I could walk you through on how to use it, but it's probably easiest to use $wgForeignFileRepos since the SharedUploads method has been deprecated (although it should still work).

You may also come by on IRC to ask for help.

Thanks for your help!

I added the following to LocalSettings.php:

$wgForeignFileRepos[] = array(
    'class' => 'ForeignDBRepo',
    'name' => 'pool',
    'url' => "http://pool.domain.com/w/images",
    'directory' => '/html/wiki/pool/w/images/',
    'hashLevels' => 2, // This must be the same for the other family member
    'dbType' => $wgDBtype,
    'dbServer' => $wgDBserver,
    'dbUser' => $wgDBuser,
    'dbPassword' => $wgDBpassword,
    'dbFlags' => DBO_DEFAULT,
    'dbName' => 'pool_db_username',
    'tablePrefix' => '',
    'hasSharedCache' => false,
    'descBaseUrl' => 'http://pool.domain.com/w/index.php/Image:',
    'fetchDescription' => false
);

...and ended up getting the same error :(

I also tried to use LocalRepo:

$wgForeignFileRepos[] = array(
   'class'                    => 'LocalRepo',
   'name'                     => 'pool',
   'url'                      => 'http://pool.domain.com/w/images',
   'hashLevels'               => 2, // This must be the same for the other family member
   'pathDisclosureProtection' => 'paranoid',
   'descBaseUrl'              => 'http://pool.domain.com/wiki/Image:',
   'scriptDirUrl'             => 'http://pool.domain.com/w',
   'fetchDescription'         => true, // Optional
);

...but no images showed up :|

I'm gonna try to find you on #MediaWiki.

Thanks + cheers,

This is my config. and it works perfectly. Hope this helps.

$wgForeignFileRepos[] = array(
   'class'                   => 'ForeignAPIRepo',
   'name'                    => 'shared',
   'apibase'                 => 'http://You're site.whereever/w/api.php',
   'fetchDescription'        => true, // Optional
   'descriptionCacheExpiry'  => 43200, // 12 hours, optional (values are seconds)
   'apiThumbCacheExpiry'     => 43200, // 12 hours, optional, but required for local thumb caching
);

I was scared to use ForeignAPIRepo, because it says "Access through ForeignDBRepo is faster than through ForeignAPIRepo", but you're right, it works perfectly. Thanks a lot! Cheers,

Glad to help.

I wrote a bug report here: https://bugzilla.wikimedia.org/show_bug.cgi?id=31943