• 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
    • Mediawiki Import Stops on Step 2

    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: Mediawiki Import Stops on Step 2

    • Issue Tools
      • View Changes
    1. issueid=2293 May 13, 2011 11:43 PM
      HarleyTZ HarleyTZ is offline
      New Member
      Mediawiki Import Stops on Step 2

      Hi there,
      I'm running into the following error when importing our Mediawiki database.

      Code:
      Database error in vBulletin 4.1.3:
      
      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,
      				usr.user_name AS username, rev.rev_minor_edit AS minor, rev.rev_comment AS reason
      			FROM page AS page
      			LEFT JOIN revision AS rev ON (rev.rev_page = page.page_id AND rev.rev_id = page.page_latest)
      			LEFT JOIN text AS txt ON (txt.old_id = rev.rev_text_id)
      			LEFT JOIN 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 Error   : 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 9
      Error Number  : 1064
      Request Date  : Friday, May 13th 2011 @ 11:21:03 PM
      Error Date    : Friday, May 13th 2011 @ 11:21:03 PM
      IP Address    : 72.229.162.172
      Username      : Harley
      Classname     : vB_Database
      MySQL Version : 5.0.77
    Issue Details
    Issue Number 2293
    Issue Type Bug
    Project VaultWiki 3.x Series
    Category Importing
    Status Fixed
    Priority 5 - Minor Bugs / Small Tweaks
    Affected Version 3.0.11
    Fixed Version 3.0.12
    Milestone (none)
    Software DependencyAny
    Users able to reproduce bug 0
    Users unable to reproduce bug 0
    Attachments 0
    Assigned Users (none)
    Tags (none)




    1. May 14, 2011 3:51 AM
      pegasus pegasus is offline
      VaultWiki Team
      This would only happen if you selected 'DO NOT IMPORT' for everything on the import preferences page. Make sure you actually select locations to import your MediaWiki articles to.

      If the only choice for anything is 'DO NOT IMPORT', and you can't choose something else, this means you either:
      A) Didn't create any wiki areas/forums ahead of time, or
      B) Didn't give yourself permission to post in the wiki
      Reply Reply  
    2. May 14, 2011 4:11 PM
      HarleyTZ HarleyTZ is offline
      New Member
      Thanks. Knew it had to something I missed. I'm running into another problem on Step 4. It looks like it's working, but then it just stops. There's no error message. The "Processing Complete - Proceed" text disappears. I looked in the source of the rendered page and it cuts off after a < /tr> tag. I'll C&P a portion of it until it cuts off. I'm sure it's something I missed again. Anything you can do to point me in the right direction would be greatly appreciated.

      HTML Code:
      <table cellpadding="4" cellspacing="0" border="0" align="center" width="90%" style="border-collapse:separate" class="tborder" id="cpform_table"> 
      <tr> 
      	<td class="tcat" align="center"> 
      		<div style="float:right"><a class="helplink" href="#" onclick="js_open_help('vaultwiki_setup', 'import', ''); return false;">Help <img src="../cpstyles/vBulletin_3_Default/cp_help.gif" alt="" border="0" title="Click for help on these options" style="vertical-align:middle" /></a></div> 
      		<b>Importing MediaWiki Data</b> 
      	</td> 
      </tr> 
      <tr valign="top"> 
      	<td class="alt1" colspan="2"></td> 
      </tr>
      Reply Reply  
    3. May 14, 2011 4:55 PM
      pegasus pegasus is offline
      VaultWiki Team
      The phrase for step 4 is missing but it should be working. That step usually talks a very long time to complete. It mirrors MediaWiki's revision table. If you have a very large wiki, it can take 10 minutes or more. That said, the page should periodically refresh on its own. If it's not, it's possible an error occurred. Since no message is appearing you may have to check your server logs or turn on 'display_errors' in php.ini.

      I have fixed the phrase for the next release along with the broken table HTML when the page finally refreshes.
      Reply Reply  
    4. May 14, 2011 8:50 PM
      HarleyTZ HarleyTZ is offline
      New Member
      I went and studied the pages and code a little bit more. It looks like it's actually getting to step 4, but not completing the page so that you can execute it. I found this in the server error logs from around the next time I ran the import script.

      [Sat May 14 17:03:21 2011] [error] [client XXX.XXX.XXX.XXX] script '/home/toonzone/public_html/test-installation/admincp/ajax.php' not found or unable to stat, referer: http://www.toonzone.net/test-install...&st artat=3600

      No other errors. All HTML in the frame cuts off after that < /tr> and it can't complete the forum.
      Reply Reply  
    5. May 14, 2011 10:10 PM
      pegasus pegasus is offline
      VaultWiki Team
      The importer doesn't call ajax.php. This sounds like another mod that is interfering with the process. Please PM your mod list.
      Reply Reply  
    6. May 14, 2011 11:30 PM
      HarleyTZ HarleyTZ is offline
      New Member
      Ok. Will do.
      Reply Reply  
    7. May 15, 2011 12:53 PM
      pegasus pegasus is offline
      VaultWiki Team
      In your server's php.ini file, make sure display_errors = 1. If you make a change, see if step 4 says anything new.
      Reply Reply  
    8. May 15, 2011 3:16 PM
      HarleyTZ HarleyTZ is offline
      New Member
      Argh. Unfortunately, no. No error messages produced by the change to php.ini.
      Reply Reply  
    9. May 18, 2011 5:34 PM
      pegasus pegasus is offline
      VaultWiki Team
      Would it be possible for me to perform the import for you? Solving the issue and getting your wiki imported would go much faster that way, as I have been unable to reproduce this is any way. I have added a free Import Service to your Members Area. If that's doable, just fill it out.
      Reply Reply  
    10. May 25, 2011 12:14 PM
      HarleyTZ HarleyTZ is offline
      New Member
      Hey! You're back! Okay. Will do.
      Reply Reply  
    11. May 26, 2011 12:46 PM
      pegasus pegasus is offline
      VaultWiki Team
      Just completed the import on your testvb without any problems. What import settings have you been using? What browser?
      Reply Reply  
    12. May 26, 2011 3:05 PM
      HarleyTZ HarleyTZ is offline
      New Member
      Huh. That's annoying, but I'm glad, of course. Chrome on Win 7. How long did it end up taking?
      Reply Reply  
    13. May 26, 2011 3:35 PM
      pegasus pegasus is offline
      VaultWiki Team
      About 2 minutes. It's possible I wasn't using the same settings as you. At the first screen it asks you to fill out a form. What values did you select for each one?
      Reply Reply  
    14. June 12, 2011 2:22 PM
      pegasus pegasus is offline
      VaultWiki Team
      Closing as the error in the OP has been fixed.
      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 11:40 PM.
    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.