Go Back   vb.org Archive > Community Discussions > Modification Requests/Questions (Unpaid)
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 06-25-2002, 01:02 PM
beheader beheader is offline
 
Join Date: Jun 2002
Posts: 22
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Whine....

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!
Reply With Quote
  #2  
Old 06-25-2002, 01:09 PM
Admin's Avatar
Admin Admin is offline
Coder
 
Join Date: Oct 2023
Location: Server
Posts: 1
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Have you used the official phpBB2 importer?
Reply With Quote
  #3  
Old 06-25-2002, 01:20 PM
beheader beheader is offline
 
Join Date: Jun 2002
Posts: 22
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
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/newrepl...ly&postid=8243


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

Well, at leats I tried....
Reply With Quote
  #4  
Old 06-25-2002, 01:24 PM
Admin's Avatar
Admin Admin is offline
Coder
 
Join Date: Oct 2023
Location: Server
Posts: 1
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #5  
Old 06-25-2002, 01:28 PM
beheader beheader is offline
 
Join Date: Jun 2002
Posts: 22
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
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.
Reply With Quote
  #6  
Old 06-25-2002, 01:34 PM
beheader beheader is offline
 
Join Date: Jun 2002
Posts: 22
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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...
Reply With Quote
  #7  
Old 06-25-2002, 01:35 PM
Admin's Avatar
Admin Admin is offline
Coder
 
Join Date: Oct 2023
Location: Server
Posts: 1
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

View the HTML source of the page and paste it here.
Reply With Quote
  #8  
Old 06-25-2002, 01:48 PM
beheader beheader is offline
 
Join Date: Jun 2002
Posts: 22
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
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/a...rum=vbdatabase
Referer:
Reply With Quote
  #9  
Old 06-25-2002, 02:00 PM
Admin's Avatar
Admin Admin is offline
Coder
 
Join Date: Oct 2023
Location: Server
Posts: 1
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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:
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
Quote:
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/a...rum=vbdatabase
> Referer:
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
> This thread is located at:
> https://vborg.vbsupport.ru/showthrea...7&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.p...threadid=40267
>
> To unsubscribe from ALL threads, please visit this page:
> https://vborg.vbsupport.ru/member2.p...type=allthread
>
>
Reply With Quote
  #10  
Old 06-25-2002, 02:15 PM
beheader beheader is offline
 
Join Date: Jun 2002
Posts: 22
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 01:06 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.08775 seconds
  • Memory Usage 2,259KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (4)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (10)postbit_onlinestatus
  • (10)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete