vbjournal to vb blog import issue

**Steve Machol** · Sun 16 Sep '07, 11:11am

Fill out a support ticket at:

http://members.vbulletin.com/membersupport_contactform.php

vBulletin Community Software

Please include a complete description of the problem and be sure to include the login info to your Admin CP, phpMyAdmin and FTP in the 'Sensitive Data' field.

**davide101** · Mon 17 Sep '07, 6:27am

I'd like to report that my import was a 100% success. Even the blog posts that it said failed happened to import correctly.

Jerry, thanks for sticking it out to fix all of the nagging bugs. My users are absolutely thrilled with the new setup.

**Reeve of Shinra** · Mon 17 Sep '07, 8:13am

Steve - my ticket id is 707667 from September 13th.

edit:

Jerry has been working with me on this... I don't want to leave anyone with the wrong impression.

**Jerry** · Mon 17 Sep '07, 6:35pm

Still working on it, fixed the categories today so all the blogs are associated correctly.

The userid issue was done last week, I've had reports (as above) of customers being ok.

Though looking at a clean (and safe) way of merging admins atm.

**Diver** · Fri 5 Oct '07, 9:12pm

Originally posted by davide101

2. I get this error in Module 1:
Fatal error: Call to undefined method ImpExData::import_blog_category() in /home/davide10/public_html/forum/impex/systems/vBJournal/001.php on line 112

i get the same error as well.
can someone help us out please?

thank you so much!

**Jerry** · Mon 8 Oct '07, 9:44am

Originally posted by Diver

i get the same error as well.
can someone help us out please?

thank you so much!

Have to make sure you have the latest ImpEx uploaded and selected the correct target system.

**ArchangelX** · Sun 26 Apr '09, 3:36pm

Hi,

I've just upgraded to 3.8 which has killed my vBjournal.

I'm have the following issue:

Code:

ImpEx Database errormysql error: Invalid SQL: 
     INSERT INTO blog_user
     (
      bloguserid, importbloguserid, title, description, options,
      viewoption, comments, lastblog, lastblogid,
      lastblogtitle, lastcomment, lastcommenter, lastblogtextid,
      entries, allowsmilie, subscribeown, subscribeothers,
      moderation, deleted, draft, options_everyone,
      options_buddy, options_ignore, ratingnum, ratingtotal,
      rating, pending, uncatentries
     )
     VALUES
     (
      '5',
      '5',
      'ArchangelX\'s Journal',
      'The life &amp; times of AAX...a tragedy of geek proportions.',
      '0',
      'all',
      '0',
      '0',
      '0',
      '',
      '0',
      '',
      '0',
      '0',
      '1',
      'none',
      'none',
      '0',
      '0',
      '0',
      '3',
      '3',
      '0',
      '0',
      '0',
      '0',
      '0',
      '0'
     )
 
mysql error: Unknown column 'options_everyone' in 'field list'
mysql error number: 1054
Date: Sunday 26th 2009f April 2009 01:34:30 PM
Database: hawaiita_hawaiitalks
MySQL error:

I can't seem to associate any users...I can however import all of their entries and comments.

Is there a fix for this? Mahalo!

**Steve Machol** · Sun 26 Apr '09, 6:38pm

There is no 'options_everyone' field in the vB 2.0.2 Blog. Which version of Blog are you running?

**ArchangelX** · Sun 26 Apr '09, 7:06pm

I'm running the following:

vBJournal 1.0.2 Beta 1 vBJournal for vBulletin 3.5

And

vBulletin Blog 2.0.2 Personal web log, integrated with vBulletin.

Is it possibly a vB Journal column or something? I see that this was a problem before, too...so I'm not the only one encountering this issue:

vB Journal to vBulletin Blog 2.0.1 - vBulletin Community Forum

http://www.vbulletin.com/forum/showthread.php?t=299521&highlight=journal

Thanks.

**Steve Machol** · Sun 26 Apr '09, 9:42pm

As that thread states Blog 2 is not officially supported with Impex yet. You will need uninstall it, download Blog 1.0.5, install that, then do the import. After that you can upgrade the Blog.

**ArchangelX** · Sun 26 Apr '09, 11:30pm

Ahh...okayz. Thanks for the heads up!

**Floris** · Mon 27 Apr '09, 1:57am

Isn't the blog 2.0 in "stable" now?

**ArchangelX** · Mon 27 Apr '09, 2:02am

Regardless, following Steve's suggestion did the trick...although it doesn't report any new blogs being listed, all the blog entries and comments are listed to their respective owners. I did hose my database once though...freakin' Impex is a very scary yet powerful tool! Thanks!

**Loco.M** · Thu 19 Aug '10, 8:19am

Originally posted by ArchangelX

Hi,

I've just upgraded to 3.8 which has killed my vBjournal.

I'm have the following issue:

Code:

ImpEx Database errormysql error: Invalid SQL: 
     INSERT INTO blog_user
     (
      bloguserid, importbloguserid, title, description, options,
      viewoption, comments, lastblog, lastblogid,
      lastblogtitle, lastcomment, lastcommenter, lastblogtextid,
      entries, allowsmilie, subscribeown, subscribeothers,
      moderation, deleted, draft, options_everyone,
      options_buddy, options_ignore, ratingnum, ratingtotal,
      rating, pending, uncatentries
     )
     VALUES
     (
      '5',
      '5',
      'ArchangelX\'s Journal',
      'The life &amp; times of AAX...a tragedy of geek proportions.',
      '0',
      'all',
      '0',
      '0',
      '0',
      '',
      '0',
      '',
      '0',
      '0',
      '1',
      'none',
      'none',
      '0',
      '0',
      '0',
      '3',
      '3',
      '0',
      '0',
      '0',
      '0',
      '0',
      '0'
     )
 
mysql error: Unknown column 'options_everyone' in 'field list'
mysql error number: 1054
Date: Sunday 26th 2009f April 2009 01:34:30 PM
Database: hawaiita_hawaiitalks
MySQL error:

I can't seem to associate any users...I can however import all of their entries and comments.

Is there a fix for this? Mahalo!

I have this exact same issue on a fresh install, importing vb 3.5 to 4.x which went fine
but I get the above error trying to import vbjournal to vb blog 1.0..

What do I need to do to fix it?

thx

Originally posted by Steve Machol

As that thread states Blog 2 is not officially supported with Impex yet. You will need uninstall it, download Blog 1.0.5, install that, then do the import. After that you can upgrade the Blog.

wait, how to I uninstall the 2.0 blog and where do I get the 1.0 version?
this is with the 4.x suite..

thx

*edit*
so apparently vb journal ISN'T supported even those it's clearly marked as supported in the vbulletin docs.

well isn't this great, not only is vbulletin lying to me, but they are lying to their clients.

**Kevin Sours** · Thu 19 Aug '10, 10:43am

The manual here http://www.vbulletin.com/docs/html/impex_module_dump clearly indicates that vBJournal is Tier3.

Originally posted by vbmanual

Tier 3

This is the graveyard of importers, these importers are not supported. There are three reasons imports make it here. Firstly is because their source system has reached it's end of life and the source data model isn't changing any more so there are going to be no future updates. Secondly, that demand for them is so low that it is not viable to offer support for them as it makes no business sense (though the importer is here for people who want to delve into it).

place in the documentation where it is marked as supported, please let us know so we can correct that.

vbjournal to vb blog import issue

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment