• 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
    • Blank article pages when using forum with existing threads

    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: Blank article pages when using forum with existing threads

    • Issue Tools
      • View Changes
    1. issueid=2101 November 23, 2010 10:16 AM
      Mikele Mikele is offline
      New Member
      Blank article pages when using forum with existing threads
      Blank article pages when using forum with existing threads

      Earlier, I used the Lite-version and everything was fine until I switched to Premium (3.0.6).
      Now, when I try to access the default namespace associated with existing forum (http://wiki.rotarycars.ru/showwiki.php - link on the left) I see a list of threads-articles that are empty on opening (contrary to the contents of the database, which has all the info).

      At first I thought it was a problem because of the language, but English-language articles that I create does not work either
    Issue Details
    Issue Number 2101
    Issue Type Bug
    Project VaultWiki 3.x Series
    Category Install / Upgrade
    Status Fixed
    Priority 3 - Loss of Functionality
    Affected Version 3.0.6
    Fixed Version (none)
    Milestone (none)
    Software DependencyAny
    Users able to reproduce bug 0
    Users unable to reproduce bug 0
    Attachments 0
    Assigned Users (none)
    Tags (none)




    1. November 23, 2010 11:29 AM
      pegasus pegasus is offline
      VaultWiki Team
      If you uninstalled Lite first, rather than upgrading, this may be the reason. Go to AdminCP > VaultWiki > Wiki URL Manager > Rebuild Page URLs.
      Reply Reply  
    2. November 23, 2010 12:00 PM
      Mikele Mikele is offline
      New Member
      Firstly I tried to run the upgrade script, but the "Proceed" button takes me back to the upgrade_lite.php (just like the simple page refresh), and I decided to try reinstalling the product.

      After fixing this bug, the newly created articles work well (even with cyrillic names), but the old still does not work, even after Page URL rebuild...

      Also, I tried to change thread title from Cyrillic to English manually via database (to make sure that this is not a problem with the charset), but it did not help
      Reply Reply  
    3. November 23, 2010 12:37 PM
      Mikele Mikele is offline
      New Member
      It's very strange. I compared the two threads and posts belonging to them in the database.
      They are identical (only the first post from the new thread has an empty value in the "htmlstate" field; in the old topic - htmlstate is "on_nl2br" everywhere; but the database does not allow me to select a blank value to test it).

      One thread works fine, the other - no
      Reply Reply  
    4. November 23, 2010 12:39 PM
      pegasus pegasus is offline
      VaultWiki Team
      Lite did not have support for Cyrillic names. Because titles are mapped to URLs in a separate database table, simply editing the thread table in the database will not help. You will have to manually rename the pages in the following manner:
      1. Go to the forum containing the old articles.
      2. Double click the title of the problematic articles.
      3. In the pop-up editor, change the title so that it uses the correct Cyrillic characters. Check the box not to redirect the old URL (it was broken anyway).
      4. Save, and the article should now be available.
      Reply Reply  
    5. November 23, 2010 12:58 PM
      Mikele Mikele is offline
      New Member
      I tried to change the titles through the forum (as you wrote) and through the database (manually via phpmyadmin). Even change the Cyrillic titles to English. Then clean Article Post Cache and rebuilding URLs. But it does not help

      If I try to create a new article with the name of the existing-old (blank), I just moved into edit screen. But the text field is still empty...

      ...
      Seem to understand the problem.
      The tables vault_article and vault_revision has no information about old topics, they are empty. How I can fill them?
      Reply Reply  
    6. November 23, 2010 1:24 PM
      Mikele Mikele is offline
      New Member
      OK, I've found. It just does not fill the articles and revisions tables when I assign Forum to the Namespace.
      This action drops the error:

      Code:
      Database error in vBulletin 4.0.8:
      
      Invalid SQL:
      v
      			SELECT rev.*, post.pagetext AS newtext, post.attach AS newattach, thread.forumid
      				
      				, post.htmlstate AS newstate
      			FROM vb3_vault_revision AS rev
      			LEFT JOIN vb3_post AS post ON (post.threadid = rev.threadid AND post.parentid = 0)
      			
      			WHERE rev.threadid = 13198
      			ORDER BY rev.dateline DESC;
      
      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 'v
      			SELECT rev.*, post.pagetext AS newtext, post.attach AS newattach, thread.fo' at line 1
      Error Number  : 1064
      Request Date  : Tuesday, November 23rd 2010 @ 09:20:47 PM
      Error Date    : Tuesday, November 23rd 2010 @ 09:20:47 PM
      Script        : http://forum.rotarycars.ru/admincp/vaultwiki_namespace.php?do=rebuild&namespaceid=2&meta=79,55&types[0]=0&types[1]=1&parents[0]=79&parents[1]=55&postcache=,2
      Referrer      : http://forum.rotarycars.ru/admincp/vaultwiki_namespace.php?do=save
      IP Address    : 93.80.208.231
      Username      : Mikele
      Classname     : vB_Database_MySQLi
      MySQL Version : 5.1.53
      Reply Reply  
    7. November 23, 2010 1:30 PM
      Mikele Mikele is offline
      New Member
      It's just a mistype in inlinemod.php on the line 226
      Reply Reply  
    8. November 23, 2010 1:32 PM
      Mikele Mikele is offline
      New Member
      Well, the new error has come... the same action:

      Code:
      Database error in vBulletin 4.0.8:
      
      Invalid SQL:
      
      			SELECT rev.*, post.pagetext AS newtext, post.attach AS newattach, thread.forumid
      				
      				, post.htmlstate AS newstate
      			FROM vb3_vault_revision AS rev
      			LEFT JOIN vb3_post AS post ON (post.threadid = rev.threadid AND post.parentid = 0)
      			
      			WHERE rev.threadid = 13198
      			ORDER BY rev.dateline DESC;
      
      MySQL Error   : Unknown column 'thread.forumid' in 'field list'
      Error Number  : 1054
      Request Date  : Tuesday, November 23rd 2010 @ 09:31:37 PM
      Error Date    : Tuesday, November 23rd 2010 @ 09:31:37 PM
      Script        : http://forum.rotarycars.ru/admincp/vaultwiki_namespace.php?do=rebuild&namespaceid=2&meta=55,79&types[0]=0&types[1]=1&parents[0]=55&parents[1]=79&postcache=,2
      Referrer      : http://forum.rotarycars.ru/admincp/vaultwiki_namespace.php?do=save
      IP Address    : 93.80.208.231
      Username      : Mikele
      Classname     : vB_Database_MySQLi
      MySQL Version : 5.1.53
      Reply Reply  
    9. November 23, 2010 1:48 PM
      Mikele Mikele is offline
      New Member
      Temporary fixed it by removing the "!VAULT_40X_COMPAT" condition for the "LEFT JOIN " . TABLE_PREFIX . "thread" , changed the namespace forum to temporary forum and back to working one, rebuilded the URLs and it started to working!!
      Reply Reply  
    10. November 23, 2010 7:27 PM
      pegasus pegasus is offline
      VaultWiki Team
      Okay I've fixed the errors you reported which were preventing the forum updates, so closing this. As for the articles being empty, this is expected when changing encoding methods (no Cyrllic support to Cyrillic support). It is also expected that the change is difficult to propagate across the database, but it looks like you have figured it out. We hope to simplify changes like this by separating the wiki from threads in version 4.
      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 1:33 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.