• Register
    • Help

    striker  0 Items
    Currently Supporting
    • Home
    • News
    • Forum
    • Wiki
    • Support
      • Manage Subscriptions
      • FAQ
      • Support For
        • VaultWiki 4.x Series
        • VaultWiki.org Site
    • What's New?
    • Buy Now
    • Manual
    • 
    • Support
    • VaultWiki 3.x Series
    • Bug
    • Import from Mediawiki - Stop at step 3/5

    1. Welcome to VaultWiki.org, home of the wiki add-on for vBulletin and XenForo!

      VaultWiki allows your existing forum users to collaborate on creating and managing a site's content pages. VaultWiki is a fully-featured and fully-supported wiki solution for vBulletin and XenForo.

      The VaultWiki Team encourages you to join our community of forum administrators and check out VaultWiki for yourself.

    Issue: Import from Mediawiki - Stop at step 3/5

    • Issue Tools
      • View Changes
    1. issueid=1239 March 9, 2010 2:20 PM
      hollosch hollosch is offline
      Senior Member
      Import from Mediawiki - Stop at step 3/5

      Importing MediaWiki Data
      Importing wiki pages
      Next step 3/5

      DB-Error:

      Code:
      Datenbankfehler in vBulletin 4.0.2:
      
      Invalid SQL:
      
      			SELECT page.page_id AS import_page_id, page.page_namespace AS namespaceid,
      				page.page_title AS title, rev.rev_user_text AS ipaddress,
      				rev.rev_timestamp AS dateline, txt.old_text AS pagetext, txt.old_flags AS flags,
      				thread.threadid, usr.user_name AS username, art.page_id AS parent_page_id
      			FROM mw_page AS page
      			LEFT JOIN mw_revision AS rev ON (rev.rev_page = page.page_id)
      			LEFT JOIN mw_text AS txt ON (txt.old_id = rev.rev_text_id)
      			
      			LEFT JOIN mw_page AS art ON (art.page_title = page.page_title AND page.page_namespace - 1 = art.page_namespace)
      			LEFT JOIN mw_user AS usr ON (usr.user_id = rev.rev_user)
      			WHERE page.page_namespace IN ()
      			GROUP BY page.page_id
      			ORDER BY rev.rev_timestamp
      			LIMIT 0,50;
      
      MySQL-Fehler  : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
      			GROUP BY page.page_id
      			ORDER BY rev.rev_timestamp
      			LIMIT 0,50' at line 11
      Fehler-Nr.    : 1064
      Fehler-Zeit   : Tuesday, 09.03.2010 @ 20:17:08
      Datum         : Tuesday, 09.03.2010 @ 20:17:08
      Skript        : http://www.wollmilchsau.org/forum/admincp/vaultwiki_setup.php?do=import
      Referrer      : http://www.wollmilchsau.org/forum/admincp/vaultwiki_setup.php?do=import&package=mediawiki&step=3&startat=300
      IP-Adresse    : 78.43.55.112
      Benutzername  : hollosch
      Klassenname   : vB_Database
      MySQL-Version : 5.0.67-1~ui40+2
    Issue Details
    Issue Number 1239
    Issue Type Bug
    Project VaultWiki 3.x Series
    Category Importing
    Status Fixed
    Priority 2 - Fatal / Database Errors
    Affected Version 3.0.0 Beta 6
    Fixed Version 3.0.0 Beta 6
    Milestone VaultWiki 3.0.0
    Software DependencyAny
    Users able to reproduce bug 0
    Users unable to reproduce bug 0
    Attachments 0
    Assigned Users (none)
    Tags (none)




    1. March 9, 2010 2:36 PM
      pegasus pegasus is offline
      VaultWiki Team
      In vault/special_import_mediawiki.php, find:
      Code:
      implode(',', array_keys($talking))
      Replace with:
      Code:
      implode(',', $import_spaces)
      Reply Reply  
    2. March 9, 2010 5:11 PM
      hollosch hollosch is offline
      Senior Member
      After fixing it, following DB-Error occurs:
      Code:
      Datenbankfehler in vBulletin 4.0.2:
      
      Invalid SQL:
      
      			SELECT page.page_id AS import_page_id, page.page_namespace AS namespaceid,
      				page.page_title AS title, rev.rev_user_text AS ipaddress,
      				rev.rev_timestamp AS dateline, txt.old_text AS pagetext, txt.old_flags AS flags,
      				thread.threadid, usr.user_name AS username, art.page_id AS parent_page_id
      			FROM mw_page AS page
      			LEFT JOIN mw_revision AS rev ON (rev.rev_page = page.page_id)
      			LEFT JOIN mw_text AS txt ON (txt.old_id = rev.rev_text_id)
      			
      			LEFT JOIN mw_page AS art ON (art.page_title = page.page_title AND page.page_namespace - 1 = art.page_namespace)
      			LEFT JOIN mw_user AS usr ON (usr.user_id = rev.rev_user)
      			WHERE page.page_namespace IN (1,7,11,13,15)
      			GROUP BY page.page_id
      			ORDER BY rev.rev_timestamp
      			LIMIT 0,50;
      
      MySQL-Fehler  : Unknown column 'thread.threadid' in 'field list'
      Fehler-Nr.    : 1054
      Fehler-Zeit   : Tuesday, 09.03.2010 @ 23:11:04
      Datum         : Tuesday, 09.03.2010 @ 23:11:04
      Skript        : http://www.wollmilchsau.org/forum/admincp/vaultwiki_setup.php?do=import
      Referrer      : http://www.wollmilchsau.org/forum/admincp/vaultwiki_setup.php?do=import&package=mediawiki&step=3&startat=300
      IP-Adresse    : 78.43.55.112
      Benutzername  : hollosch
      Klassenname   : vB_Database
      MySQL-Version : 5.0.67-1~ui40+2
      Reply Reply  
    3. March 9, 2010 5:22 PM
      pegasus pegasus is offline
      VaultWiki Team
      Find:
      Code:
      thread.threadid, usr.user_name AS username
      Replace with:
      Code:
      usr.user_name AS username
      Reply Reply  
    4. March 9, 2010 5:43 PM
      hollosch hollosch is offline
      Senior Member
      After step 3 following:
      Warnung: Invalid argument supplied for foreach() in [path]/vault/special_import_mediawiki.php (Zeile 1057)
      After step 4 following:
      No input file specified.
      Reply Reply  
    5. March 9, 2010 6:02 PM
      pegasus pegasus is offline
      VaultWiki Team
      Well if you got that far then the import was finished. I have fixed these two problems (trying to update something that doesn't need updating and redirecting back to the wrong file) for the next build.

      Please open a new report for any further issues.
      Reply Reply  
    + Reply

    Assigned Users
    Loading Please Wait
    Tags
    Loading Please Wait
    • Contact Us
    • License Agreement
    • Privacy
    • Terms
    • Top
    All times are GMT -4. The time now is 10:42 AM.
    This site uses cookies to help personalize content, to tailor your experience, and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Learn more… Accept Remind me later
  • striker
    Powered by vBulletin® Version 4.2.5 Beta 2
    Copyright © 2023 vBulletin Solutions Inc. All rights reserved.
    Search Engine Optimisation provided by DragonByte SEO (Pro) - vBulletin Mods & Addons Copyright © 2023 DragonByte Technologies Ltd.
    Copyright © 2008 - 2013 VaultWiki Team, Cracked Egg Studios, LLC.