Table wikidb.mediawikiuser groups Doesn't Exist

    Table of contents
    No headers
    Migrating users...  
    <message>
      <status>500</status>
      <headers>
        <Content-Type>application/x-dream-exception+xml; charset=utf-8</Content-Type>
      </headers>
      <body format="xml">
      <exception>
        <type>MySql.Data.MySqlClient.MySqlException</type>
        <message>Table 'wikidb.mediawikiuser_groups' doesn't exist</message>
        <source>MySql.Data</source>
        <stacktrace>
        <frame>MySql.Data.MySqlClient.MySqlStream.OpenPacket()</frame>
        <frame>MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64&amp; affectedRows, Int64&amp; lastInsertId)</frame>
        <frame>MySql.Data.MySqlClient.MySqlDataReader.GetResultSet()</frame>
        <frame>MySql.Data.MySqlClient.MySqlDataReader.NextResult()</frame>
        <frame>MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderInternal(CommandBehavior behavior)</frame>
        <frame>MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)</frame>
        <frame>MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)</frame>
        <frame>System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()</frame>
        <frame>MindTouch.Data.DataCommand.Execute(Action`1 handler)</frame>
        <frame>
          <method>Mindtouch.Tools.MediaWikiDA.GetUsers()</method>
          <file>C:\Documents and Settings\{user}\src\dekiwiki\trunk\src\tools\mindtouch.deki.mwconverter\MediaWikiDA.cs</file>
          <line>78</line>
        </frame>
        <frame>
          <method>MindTouch.Tools.MediaWikiConverterService.ConvertUsers()</method>
          <file>C:\Documents and Settings\{user}\src\dekiwiki\trunk\src\tools\mindtouch.deki.mwconverter\MediaWikiConverterService.cs</file>
          <line>475</line>
        </frame>
        <frame>
          <method>MindTouch.Tools.MediaWikiConverterService.Convert()</method>
          <file>C:\Documents andSettings\{user}\src\dekiwiki\trunk\src\tools\mindtouch.deki.mwconverter\MediaWikiConverterService.cs</file>
          <line>986</line>
        </frame>
        <frame>
          <method>MindTouch.Tools.MediaWikiConverterService.&lt;PostConvert&gt;d__4.MoveNext()</method>
          <file>C:\Documents and Settings\{user}\src\dekiwiki\trunk\src\tools\mindtouch.deki.mwconverter\MediaWikiConverterService.cs</file>
          <line>1008</line>
        </frame>
        <frame>MindTouch.Dream.Coroutine.Iterate_Helper(IEnumerator`1 coroutine, TaskBehavior behavior)</frame>
        <frame>System.VoidClosure`2.Closure()</frame>
        <frame>MindTouch.Dream.Task.Execute(VoidHandler handler, TaskBehavior behavior)</frame>
      </stacktrace>
    </exception>
    </body>
    </message>
    

    This appears to be casued by a different MySQL table name for MediaWiki groups.  The converter is expecting a table name of mediawikiuser_groups, while older versions of MediaWiki use a table name of user_groups.  To fix it, open the MediaWikiDA.cs file, go to the GetUsers() method and change the SQL command to the following:

    MediaWikiConverterContext.Current.MWCatalog.NewQuery(String.Format("SELECT user_id, user_name, user_real_name, user_password, user_newpassword, user_email, user_options, user_touched, user_token, (select count(*) from user_groups where ug_user=user_id and ug_group='sysop') as user_sysop from {0}user order by user_touched DESC", MediaWikiConverterContext.Current.MWUserPrefix)).Execute(delegate(IDataReader dr) {
    Tag page
    You must login to post a comment.

    Copyright © 2011 MindTouch, Inc. Powered by