Advertisement:

Author Topic: vb 4.2.2 to smf 2.0.9  (Read 7933 times)

Offline The Factor

  • Semi-Newbie
  • *
  • Posts: 40
  • Gender: Male
  • Welcome to reality.. Wish you could stay longer..
vb 4.2.2 to smf 2.0.9
« on: March 02, 2015, 09:11:23 PM »
All:

First post..  So let me say I like it all so far.
I ran the converter from http://www.simplemachines.org/community/index.php?topic=527924.msg3745016#msg3745016
Every thing went pretty well.  I had a few duplicate board notices in source forum but i sorted that out.  My main issue is with the VB attachments.  I have seen other here with similar issues so I wanted to post. So here it goes.

Looks like I have all of my attachment up to sometime in 2012 and it just stops cold. 
1.) Does the attachment folder limit in SMF count on conversion?  if so I need to set it to above my current VB attachment size of 6 gigs?
2.)I noticed whats in the SMF attachment folder not image files and the structure is not the same. So it not just coping them to some new structure.
3.)I did notice it failed at first on permissions.  So I set the source attachment to 777 that helped a lot.
4.) the errors look like [ATTACH=CONFIG]48353[/ATTACH][ATTACH=CONFIG]48354[/ATTACH][ATTACH=CONFIG]48355[/ATTACH]
5.)Here is some of the error log. 
[01-Mar-2015 23:05:34 America/New_York] PHP Warning:  copy(/home/33333/public_html/forum/attachments/1/0/7/3461.attach) [<a href='function.copy'>function.copy</a>]: failed to open stream: No such file or directory in /home/333333/public_html/testsmf/convert.php(1264) : eval()'d code on line 44
[01-Mar-2015 23:05:34 America/New_York] PHP Warning:  copy(/home/33333/public_html/forum/attachments/1/0/7/3462.attach) [<a href='function.copy'>function.copy</a>]: failed to open stream: No such file or directory in /home/333333/public_html/testsmf/convert.php(1264) : eval()'d code on line 44
[01-Mar-2015 23:05:34 America/New_York] PHP Warning:  copy(/home/33333/public_html/forum/attachments/2/8/0/3451.attach) [<a href='function.copy'>function.copy</a>]: failed to open stream: No such file or directory in /home/333333/public_html/testsmf/convert.php(1264) : eval()'d code on line 44

Any help or ideas would be great.

Brent Dacus
Thanks,

Brent Dacus

Reading and learning still at 46..

Offline The Factor

  • Semi-Newbie
  • *
  • Posts: 40
  • Gender: Male
  • Welcome to reality.. Wish you could stay longer..
Re: vb 4.2.2 to smf 2.0.9
« Reply #1 on: March 03, 2015, 12:26:02 PM »
Ok I found this.  It states that you need to move your Attachments back in to the VB db.  I will try this and report back.

http://www.simplemachines.org/community/index.php?topic=461867.msg3228513#msg3228513
Thanks,

Brent Dacus

Reading and learning still at 46..

Offline The Factor

  • Semi-Newbie
  • *
  • Posts: 40
  • Gender: Male
  • Welcome to reality.. Wish you could stay longer..
Re: vb 4.2.2 to smf 2.0.9
« Reply #2 on: March 03, 2015, 12:38:30 PM »
Also make sure your max_allowed_packet size is larger that the largest attachment.  example max_allowed_packet size =10MB
and in the php.ini upload_max_filesize = 10M.  after this bounce Mysql and HTTP server.
Thanks,

Brent Dacus

Reading and learning still at 46..

Offline margarett

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,761
  • Gender: Male
Re: vb 4.2.2 to smf 2.0.9
« Reply #3 on: March 03, 2015, 02:31:56 PM »
I converted a pretty big forum without any issues with that converter (although for sure they didn't have that many attachments)

Those warnings do not represent any problem. The converter checks the database entry in vB and tries to copy the file pointed by it. If the copy is successful, the attachment is added to SMF's database. If not, it is skipped (but the failed copy operation triggers that error)

About your point 4), I have no idea, never saw that before :(

How does it stop? White page, some fatal error, ...?
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

Quote
Over 90% of all computer problems can be traced back to the interface between the keyboard and the chair

Offline The Factor

  • Semi-Newbie
  • *
  • Posts: 40
  • Gender: Male
  • Welcome to reality.. Wish you could stay longer..
Re: vb 4.2.2 to smf 2.0.9
« Reply #4 on: March 05, 2015, 04:44:29 PM »
I get to talk to the great a powerful margarett...  just like that  8)..

Well I tried to put all the attachment back in the VB database and crashed the server  :-[.  The vps we are on ran out of space..  Looking for help on a new HSP. in another topic.. ::)

the # 4 is what shows on the post in smf  here a link http://www.authentic-campaigner.com/testsmf/index.php?topic=42718.0

BD
Thanks,

Brent Dacus

Reading and learning still at 46..

Offline Antes

  • Evil Black Cat
  • SMF Friend
  • SMF Hero
  • *
  • Posts: 8,648
  • Gender: Male
  • Black cat rulz!
    • Antes on GitHub
    • merta on LinkedIn
    • @antesistan on Twitter
    • Lunarfall
Re: vb 4.2.2 to smf 2.0.9
« Reply #5 on: March 05, 2015, 08:35:39 PM »
4. can be ILA alike mod for vBulletin?
Active Project(s): [ SimpleDesk ] # [ Lunarfall ] # [ CoreStore ]

Past Project(s): [ ezPortal ]

Offline The Factor

  • Semi-Newbie
  • *
  • Posts: 40
  • Gender: Male
  • Welcome to reality.. Wish you could stay longer..
Re: vb 4.2.2 to smf 2.0.9
« Reply #6 on: March 05, 2015, 08:46:52 PM »
Well I don't believe so.  Vb does it in the post for this forum always has. But I'll double check.   The funny part is if I look at older posts before 2012 they are there in vb and SMF....
http://www.authentic-campaigner.com/testsmf/index.php?topic=35675.0.msg220680#msg220680

Its like it just stopped loading.   Its kind of strange.
Thanks,

Brent Dacus

Reading and learning still at 46..

Offline The Factor

  • Semi-Newbie
  • *
  • Posts: 40
  • Gender: Male
  • Welcome to reality.. Wish you could stay longer..
Re: vb 4.2.2 to smf 2.0.9
« Reply #7 on: March 05, 2015, 10:58:00 PM »
Ok I found this.  It states that you need to move your Attachments back in to the VB db.  I will try this and report back.

http://www.simplemachines.org/community/index.php?topic=461867.msg3228513#msg3228513

Well I wouldn't say it failed but I filled up my VPS.  I have 6 gigs of attachments and apparently that is alot.  I want to move to another Host and try again.  Might be a while.  If anyone else has VB 4 and moves their attachments back into the db and that works.  I would love to hear your success.
Thanks,

Brent Dacus

Reading and learning still at 46..

Offline margarett

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,761
  • Gender: Male
Re: vb 4.2.2 to smf 2.0.9
« Reply #8 on: March 06, 2015, 04:52:01 AM »
I get to talk to the great a powerful margarett...  just like that  8)..
I'm not that great, I'm just 1,75m tall ;D ;D ;D

Well I don't believe so.  Vb does it in the post for this forum always has. But I'll double check. 
http://www.authentic-campaigner.com/testsmf/index.php?topic=35675.0.msg220680#msg220680
Most likely it *IS* a ILA-kind-of-thing, yes. This:
[ATTACH=CONFIG]48353[/ATTACH]
Is (probably) a BBC that tells vB to display a certain attachment. SMF has, out of the box, no such option...

Well I tried to put all the attachment back in the VB database and crashed the server  :-[.  The vps we are on ran out of space..  Looking for help on a new HSP. in another topic.. ::)
This actually got me confused... You don't put attachments in a database :o What do you mean by that?

If you have 6Gb of attachments you will need at least that amount of free space (preferably more). Here's more or less how it works:
* vB has an "attachments" table, that references all attachments that the forum knows. The files themselves are in a folder in your server's hard drive somewhere.
* The converter reads that table, from which it gathers information about each file.
** For each file that the table mentions, the converter tries to copy it to SMF's "attachments" FOLDER.
** If the copy is successful (eg, the file was duplicated), the converter adds a reference to it in SMF's "attachments" database. If not, that file is discarded.

So, your original vB setup is left untouched. So I'm having a hard time understanding why were you moving files around. You probably don't need another host, don't spend money... Make sure that your vB attachments aren't duplicated somewhere (because you were "moving" attachments, this is possible), delete SMF's test install folder and database, etc. That should allow to put your forum back online, that should be your main concern.

Then you need to investigate what you are using in terms of space and how much space you have available. You might need to clean the house a little bit ;)
Not so long ago I deal with an upgrade of SMF where the database had 100Mb of content and 700Mb of error logs :)

Let us know if you need further help.
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

Quote
Over 90% of all computer problems can be traced back to the interface between the keyboard and the chair

Offline The Factor

  • Semi-Newbie
  • *
  • Posts: 40
  • Gender: Male
  • Welcome to reality.. Wish you could stay longer..
Re: vb 4.2.2 to smf 2.0.9
« Reply #9 on: March 06, 2015, 08:45:53 AM »
Bruno thanks

The site is all good. I got that cured.

In vbulletin you have 2 options store attachments in the db or store them in the file system.
I currently have them in the file system for vbulletin.  I read post here in smf community that the conversion from vbulletin to smf attachments convert better if they are in vbulletins db and not in the filesystem.

I hear you saying for the conversion they should stay in the filesystem.   I am not in a rush.

So this ILA inline attachments? bb thing. So maybe I need a mod that might remedy the issue. Would you recommend any in particular?  OR is it not recommended? 

Like I said no rush here just taking my time and trying to get the best conversion possible.
Thanks,

Brent Dacus

Reading and learning still at 46..

Offline Antes

  • Evil Black Cat
  • SMF Friend
  • SMF Hero
  • *
  • Posts: 8,648
  • Gender: Male
  • Black cat rulz!
    • Antes on GitHub
    • merta on LinkedIn
    • @antesistan on Twitter
    • Lunarfall
Re: vb 4.2.2 to smf 2.0.9
« Reply #10 on: March 06, 2015, 08:59:52 AM »
AFAIK there is only one free ILA mod: https://github.com/Spuds/SMF-ILA
Active Project(s): [ SimpleDesk ] # [ Lunarfall ] # [ CoreStore ]

Past Project(s): [ ezPortal ]

Offline margarett

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,761
  • Gender: Male
Re: vb 4.2.2 to smf 2.0.9
« Reply #11 on: March 06, 2015, 09:15:54 AM »
Hi ;)

Quote
In vbulletin you have 2 options store attachments in the db or store them in the file system.
I currently have them in the file system for vbulletin.  I read post here in smf community that the conversion from vbulletin to smf attachments convert better if they are in vbulletins db and not in the filesystem.
I'm looking at the converter code and I think it handles both cases. Never saw the database "version" of it, though.

Quote
I hear you saying for the conversion they should stay in the filesystem.
Well, it's the version I'm more comfortable with, yes, because I never saw the other one :P

Quote
So maybe I need a mod that might remedy the issue. Would you recommend any in particular?  OR is it not recommended? 
Well... This is tricky. There are 2 MODs that we know of, that support inline attachments. The problem is that, apparently, vB uses the attachment ID to show the attachment. SMF MODs with the order number of the attachment in the post (eg: [attachment]1[/attachment] - not literal, I don't know the correct syntax of it) to show it inline.
This happens because, in SMF, the attachments are only uploaded when the post is submitted (as such, they only acquire an ID *after* submission).
Bottom line, I imagine it should be quite difficult to have the old inline attachments showing up :(

Quote
Like I said no rush here just taking my time and trying to get the best conversion possible.
That's very wise ;)

Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

Quote
Over 90% of all computer problems can be traced back to the interface between the keyboard and the chair

Offline The Factor

  • Semi-Newbie
  • *
  • Posts: 40
  • Gender: Male
  • Welcome to reality.. Wish you could stay longer..
Re: vb 4.2.2 to smf 2.0.9
« Reply #12 on: March 06, 2015, 09:29:57 AM »
Thanks,

Brent Dacus

Reading and learning still at 46..