Issue: Import from vw3 fails with database error

Issue Tools
- View Changes

February 17, 2014 7:04 AM

gyro

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)

February 21, 2014 6:23 PM

gyro

New Member

still needing help, still no call

Reply
February 21, 2014 9:23 PM

pegasus

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
February 21, 2014 9:30 PM

gyro

New Member

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

February 24, 2014 3:35 PM

gyro

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}

February 24, 2014 5:10 PM

gyro

New Member

Any help would be much appreciated.... this is really affecting our business.

Reply
February 24, 2014 5:20 PM

gyro

New Member

We want to be rolled back asap... will you be available on skype this afternoon? What do you need from us?

Reply
This petition for a change to Awaiting Feedback was rejected
February 24, 2014 5:54 PM

gyro

New Member

Changing status
February 24, 2014 7:20 PM

pegasus

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
February 24, 2014 7:29 PM

gyro

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
This petition for a change to Awaiting Feedback was rejected
February 24, 2014 7:56 PM
gyro

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
February 24, 2014 8:17 PM

pegasus

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
February 24, 2014 10:15 PM

gyro

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
February 25, 2014 1:07 AM

pegasus

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
February 25, 2014 12:54 PM

gyro

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
May 15, 2014 5:08 PM

gyro

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

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

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

Issue: Import from vw3 fails with database error

Issue Tools