Whine....

[beheader]

Well ok- I'm not whining really....

BUT- and I'm sure this topic has been mentioned before...

I'm trying to migrate my YaBB system to vbulletin, and had only partial success. I used the YaBB-->phpbb converter into a clean phpbb install, then did the import from phpbb-->YaBB.

Well, the results were almost usable...

Rather then get into the specifics, my crap hackjob got the data moved over, but reinitializing the search index, and replying to some posts did not work...

I cannot find another YaBB--><whatever> converter that will convert from <whatever> to vbulletin

Which completely sucks.....

So I'd like to add my voice to the chior of those whining (err ok requesting) a YaBB SE-->vbulletin converter.

My vbulletin purchase is pretty much useless unless I can get the data moved over. I have 30,000 posts that cannot be lost...

Thanks for the ears... 25 hours later, after manually editing, hacking, crying and screaming- I admit defeat!

[Admin]

Have you used the official phpBB2 importer?

[beheader]

Originally posted by FireFly
Have you used the official phpBB2 importer?

Yup!

It moves the data, drops a few users, munges the forums a bit, and then locks the phpbb-->vbulletin converter.

Then I have to manually delete threads in the phpbb system, and finally it will import...

However, it will not re-index the search DB, nor allow a reply to certain posts and retorts with a database error...

when trying to search:

"Database error in vBulletin 2.2.6:

Invalid SQL: SELECT wordid,title FROM word WHERE title LIKE 'house'
mysql error: Can't open file: 'word.MYD'. (errno: 145)

mysql error number: 1016

Date: Tuesday 25th of June 2002 09:12:08 AM
Script: http://forums.aswp.net/vbull/vbull/search.php
Referer: http://forums.aswp.net/vbull/search.php?"

When trying to reply:

Database error in vBulletin 2.2.6:

Invalid SQL: SELECT wordid,title FROM word WHERE title IN ('re','re','doom','iii','quote','i','originally',' posted','by','groinklothaswp','/i','','b','i','thought','you','were','leaving','fo r','a','while','p','/b','/quote')
mysql error: Can't open file: 'word.MYD'. (errno: 145)

mysql error number: 1016

Date: Tuesday 25th of June 2002 09:13:02 AM
Script: http://forums.aswp.net/vbull/vbull/newreply.php
Referer: http://forums.aswp.net/vbull/newreply.php?action=newreply&postid=8243


In other words- it's a total loss....

Well, at leats I tried....

[Admin]

Don't give up, not yet. :)

Upload repair.php from the vbulletin226.zip file, and run it. Your word table is damaged, which is why you can't reindex your forum nor reply.

[beheader]

Originally posted by FireFly
Don't give up, not yet. :)

Upload repair.php from the vbulletin226.zip file, and run it. Your word table is damaged, which is why you can't reindex your forum nor reply.

Response is:

There seems to have been a slight problem with the database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.

[beheader]

Ok- I'm going to do a complete re-install, and migration of my "Golden" data master...

Then rebuild with the repair script.... I'll report...

[Admin]

View the HTML source of the page and paste it here.

[beheader]

Originally posted by FireFly
View the HTML source of the page and paste it here.

Here's the error:

Database error in vBulletin Control Panel 2.2.6:

Invalid SQL: USE vbdatabase
mysql error: Unknown database 'vbdatabase'

mysql error number: 1049

Date: Tuesday 25th of June 2002 09:37:53 AM
Script: http://forums.aswp.net/vbull/vbull/admin/repair.php?check=1&iterations=4&forum=vbdatabase
Referer:

[Admin]

You need to change the database name in the URL. The default is vbdatabase,
but yours is probably different. Check config.php if you don't remember the
database name.

----- Original Message -----
From: "vBulletin.org Forum Mailer" <post@vbhacks.com>
To: <chen.avinadav@vbulletin.com>
Sent: Tuesday, June 25, 2002 4:48 PM
Subject: Whine....


> Hello FireFly,
>
> beheader has just replied to a thread you have subscribed to entitled -
Whine.... - in the Requests forum of vBulletin.org Forum.
>
> ~~~~~ NEW ~~~~~
> New at vBulletin.org!
> You can now reply to the thread by replying to this message. All you need
to do is to make sure this code appears in the e-mail subject:
>
> You should also remove this text to ensure your reply is readable by other
forum users.
> ~~~~~ NEW ~~~~~
>
> Here are the contents of the post:
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Originally posted by FireFly
> View the HTML source of the page and paste it here.
>
> Here's the error:
>
> Database error in vBulletin Control Panel 2.2.6:
>
> Invalid SQL: USE vbdatabase
> mysql error: Unknown database 'vbdatabase'
>
> mysql error number: 1049
>
> Date: Tuesday 25th of June 2002 09:37:53 AM
> Script:
http://forums.aswp.net/vbull/vbull/admin/repair.php?check=1&iterations=
4&forum=vbdatabase
> Referer:
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
> This thread is located at:
> https://vborg.vbsupport.ru/showthread.php?threadid=40267&goto=newpost
>
> There may be other replies also, but you will not receive any more
notifications until you visit the board again.
>
> Yours,
> vBulletin.org Forum team
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Unsubscription information:
>
> To unsubscribe from this thread, please visit this page:
> https://vborg.vbsupport.ru/member2.php?action=usub&threadid=40267
>
> To unsubscribe from ALL threads, please visit this page:
> https://vborg.vbsupport.ru/member2.php?action=usub&type=allthread
>
>

[beheader]

Ran it- lock sql hard.... dropping databased for one more try....

[beheader]

Ok- here's the final analysis....

The converter from YaBB to phpbb is not working correctly. It is dumping some users from the transition with errors, I can only imagine what it might be doing to posts...

So I'm fairly sure that a stock transition from phpbb to vbulletin would go without a hitch, the problem lies with the yabb conversion to phpbb.

A couple of further notes:

My YaBB sp1 install converted flawlessly into YaBB SE. Although I see no converters around for YaBB SE to anything at this point.

Seriously, I would write my own conversion, but really my programming skils (as modest as they are) are not up to the task.

I would think that a conversion from YaBB SE to vbulletin would be fairly painless since you are working with data coming out of the same database engine. But again it's my horrible programming skills stopping me (and I have to make sure I don't ignore my clients).

Thanks for the help... however, this is a dead end conversion path. Looks like I'm landlocked on my current system since I can lose the content...

Guess I'll have to sit on my vbulletin license and hope a solution comes up.

Sadly, I would get hung by my board of directors (we are a NPC) if I lost the content....

<weep>