• 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 4.x Series
    • Bug
    • Import from vw3 fails with database error

    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 vw3 fails with database error

    • Issue Tools
      • View Changes
    1. issueid=3589 February 17, 2014 7:04 AM
      gyro gyro is offline
      New Member
      Import from vw3 fails with database error
      Import from vw3 fails with database error

      When importing from VaultWiki 3, the import fails with the following error when importing the articles. This is now rendering our Wiki useless.
      Code:
      SELECT SQL_CALC_FOUND_ROWS `t`.`threadid` AS `threadid`,`t`.`prefixid` AS `prefixid`,`t`.`title` AS `title`,`t`.`dateline` AS `dateline`,`t`.`lastposter` AS `lastposter`,`t`.`replycount` AS `replycount`,`t`.`open` AS `open`,`t`.`visible` AS `visible`,`t`.`views` AS `views`,`t`.`lastpostid` AS `lastpostid`,`t`.`lastpost` AS `lastpost`,`t`.`forumid` AS `forumid`,`t`.`firstpostid` AS `firstpostid`,`t`.`lastposterid` AS `lastposterid`,`f`.`forumid` AS `forumid`,`f`.`title_clean` AS `title_clean`,`p`.`pagetext` AS `pagetext`,`p`.`postid` AS `postid`,`p`.`userid` AS `userid`,`p`.`parentid` AS `parentid`,`p`.`threadid` AS `threadid`,`u`.`userid` AS `userid`,`u`.`username` AS `username` FROM `thread` `t`  LEFT JOIN `forum` `f` ON (`t`.`forumid` = `f`.`forumid`) 
       LEFT JOIN `post` `p` ON (`t`.`threadid` = `p`.`threadid` AND `p`.`parentid` = 0) 
       LEFT JOIN `user` `u` ON (`p`.`userid` = `u`.`userid`)   WHERE  `f`.`forumid` IN (162)  AND `t`.`visible` = 1 AND  = 1 AND `t`.`open` <> 10 ORDER BY `t`.`title` ASC  LIMIT 0,200;
      It looks like the problem is with the "visible = 1 AND = 1" in the where clause. A field name seems to be missing.
    Issue Details
    Issue Number 3589
    Issue Type Bug
    Project VaultWiki 4.x Series
    Category Importing
    Status Fixed
    Priority 2 - Fatal / Database Errors
    Affected Version 4.0.0 Gamma 2
    Fixed Version 4.0.0 Gamma 3
    Milestone VaultWiki 4 Gamma X
    Software DependencyvBulletin 4.x
    License TypePaid
    Users able to reproduce bug 0
    Users unable to reproduce bug 0
    Attachments 0
    Assigned Users (none)
    Tags (none)


    Page 2 of 3 FirstFirst Previous 123 Next LastLast


    1. February 21, 2014 6:23 PM
      gyro gyro is offline
      New Member
      still needing help, still no call
      Reply Reply  
    2. February 21, 2014 9:23 PM
      pegasus pegasus is offline
      VaultWiki Team
      The earliest I can schedule a call for is tomorrow. We actually don't offer phone support so it has not been easy to setup. Today was a busy day and I will have to set up from home if we want a reliable voice connection. It is easier for us to do support over Skype, we can log into vaultwiki.support but even in that case it is chat functionality as we are not setup for voice in our office currently.
      Reply Reply  
    3. February 21, 2014 9:30 PM
      gyro gyro is offline
      New Member
      Quote Originally Posted by pegasus
      The earliest I can schedule a call for is tomorrow. We actually don't offer phone support so it has not been easy to setup. Today was a busy day and I will have to set up from home if we want a reliable voice connection. It is easier for us to do support over Skype, we can log into vaultwiki.support but even in that case it is chat functionality as we are not setup for voice in our office currently.
      We're going to do as you originally asked, and setup an account for you to log into the forum/ftp and repair the wiki. We'll PM you the credentials tomorrow.

      Thanks for being willing to take the extra steps to help.
      Reply Reply  
    4. February 24, 2014 3:35 PM
      gyro gyro is offline
      New Member
      ok we are getting error now when someone tries to post a comment.... Uggggg Can you take a look and let us know what's happening?
      Code:
      Trying to get package class from invalid contenttype '0' on line 498 in /var/www/vhosts/3drcforums.com/http_docs/vb/types.php
      #0 /var/www/vhosts/3drcforums.com/http_docs/vault/core/model/contenttype/vb4.php(56): vB_Types->getContentTypePackage(0)
      #1 /var/www/vhosts/3drcforums.com/http_docs/vault/core/model/editor/vb4.php(24): vw_ContentType_Model_vB4->key(Array, true)
      #2 /var/www/vhosts/3drcforums.com/http_docs/vault/core/controller/ui/discussion/vw.php(204): vw_Editor_Model_vB4->get_attachments(Array)
      #3 /var/www/vhosts/3drcforums.com/http_docs/vault/core/controller/ui/discussion/vw.php(518): vw_UI_Discussion_Controller->comment(Array)
      #4 /var/www/vhosts/3drcforums.com/http_docs/vault/core/controller/ui/discussion/vw.php(87): vw_UI_Discussion_Controller->postcomment()
      #5 /var/www/vhosts/3drcforums.com/http_docs/vault/core/view/ui/page/vw.php(158): vw_UI_Discussion_Controller->execute()
      #6 /var/www/vhosts/3drcforums.com/http_docs/vault/core/controller/ui/page/vw.php(579): vw_UI_Page_View->get_comments(Object(vw_UI_Page_Controller), true)
      #7 /var/www/vhosts/3drcforums.com/http_docs/vault/core/controller/ui/page/vw.php(107): vw_UI_Page_Controller->comments()
      #8 /var/www/vhosts/3drcforums.com/http_docs/vault/core/controller/ui/stack/vw.php(154): vw_UI_Page_Controller->execute()
      #9 /var/www/vhosts/3drcforums.com/http_docs/wiki_index.php(93): vw_UI_Stack_Controller->execute()
      #10 {main}
      Reply Reply  
    5. February 24, 2014 5:10 PM
      gyro gyro is offline
      New Member
      Any help would be much appreciated.... this is really affecting our business.
      Reply Reply  
    6. February 24, 2014 5:20 PM
      gyro gyro is offline
      New Member
      We want to be rolled back asap... will you be available on skype this afternoon? What do you need from us?
      Reply Reply  
    7. This petition for a change to Awaiting Feedback was rejected
      February 24, 2014 5:54 PM
      gyro gyro is offline
      New Member
      Changing status
       
    8. February 24, 2014 7:20 PM
      pegasus pegasus is offline
      VaultWiki Team
      Invalid contenttype '0' means that a vBulletin cache was not up-to-date. I'm not sure how this could be. That cache in question was fine when I signed off yesterday, and it seems fine now when I try to post comments (even if the comment has an attachment).

      If this error was unique, perhaps you installed/upgraded/enabled/disabled a mod at the same time that the comment posted. This would be considered a race condition (one user tries to access content - during a window sometimes that lasts for only a fraction of a second - that another user has modified) and there is nothing that can be done about it realistically.

      I am still logged into Skype since our last conversation.
      Reply Reply  
    9. February 24, 2014 7:29 PM
      gyro gyro is offline
      New Member
      We just seem to be chasing our tail.... i don't want to make a hasty decision but we are feeling very uneasy about this new version. I would like to roll back and use version 3 with vb 4.2.2. I understand vw 3 isn't compatible but really how incompatible is it? Can we make just a few fixes and get it to work on 3 versus all the issues we are having now and the possibility of it not being upgrade-able in the future due to all the modifications you've had to make.... We were really very happy with version 3 and now.... we are just frustrated.

      Thanks Ted

      Thoughts?
      Reply Reply  
    10. This petition for a change to Awaiting Feedback was rejected
      February 24, 2014 7:56 PM
      gyro gyro is offline
      New Member
      One of our major SEO hits and what makes us different from other sites was your wiki and now... we struggle big time.

      Just now I tried to delete a test message and this is what we get....
      Code:
      Fatal error: Call to undefined method vw_DB_MySQL_Model_vB3::subquery() in /var/www/vhosts/3drcforums.com/http_docs/vault/core/model/db/mysql/vw.php on line 148
      This is tiresome.... Please can we roll back to v3 and get it to work with 4.2.2
       
    11. February 24, 2014 8:17 PM
      pegasus pegasus is offline
      VaultWiki Team
      You will have just as many errors if not more by rolling back to an incompatible version. VaultWiki 3 is no longer under active development and will not even receive security patches after another 2 months. Simply put most bugs you encounter in version 3 will probably never be fixed.

      All of the modifications I've made have been merged into the next update, so you won't have an issue of not being upgrade-able. Most of the serious issues you've encountered have mainly just been that some of the data was not transferred over.

      Transferring data from VW3 was a one-time thing, not something you will be doing all the time. I only wish that we had encountered all of these issues in a staging area rather than on the live site. It would have been really simple to just copy the VW4 tables from a staging area once all the data was confirmed.

      Many sites that started on version 4 have been using 4 for the better part of a year and without encountering an issue. I am confident that once things settle down, you will be pleased with the freedom and ease of use in many aspects that it provides over version 3.
      Reply Reply  
    12. February 24, 2014 10:15 PM
      gyro gyro is offline
      New Member
      Still can't make a comment... It's still erroring out. Give it a shot. I can't make comments or delete them. Thanks for the detailed reply.
      Reply Reply  
    13. February 25, 2014 1:07 AM
      pegasus pegasus is offline
      VaultWiki Team
      No problems using the full editor to post comments. Saw that Quick Reply was forwarding to the advanced editor always rather than just submitting. This is now fixed.

      As for deleting comments, I'm still not having a problem. Perhaps if you link me to a particular comment you can't delete. Maybe it is something about that particular comment. Also are you trying Soft-Delete or Physically Remove?
      Reply Reply  
    14. February 25, 2014 12:54 PM
      gyro gyro is offline
      New Member
      I am now able to delete (physically) comments.

      I am also able to now make comments. I hope the fix will stay.
      Reply Reply  
    15. May 15, 2014 5:08 PM
      gyro gyro is offline
      New Member
      pegasus we have come to the conclusion we need to do a complete uninstall. What are your recommendations to do that at this point. We have VW 4.0 g2 installed and version 3.0.20 (disabled). We have tried to uninstall but ran into more problems when we tried a few months back. My thought would be to try to install the latest update and then uninstall from there. Your help/thougts would be much appreciated. We will be attempting this in our sandbox version.
      Reply Reply  
    Page 2 of 3 FirstFirst Previous 123 Next LastLast
    + 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 5:22 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.