vBulletin Forums Importer

[Brian]

This script will allow you to import data from your vBulletin forums into vBadvanced Dynamics. It will import all threads, posts, ratings, and attachments. To use the script, simply upload the attached file into your forum/admincp directory, go to it in your browser, and follow the on-screen instructions there.

[tfw2005]

Hey Brian,

I want to import threads to a second instance of Dynamics. I uploaded the file, chose forum, and it only gave me the option to install it to the first instance.

Any way to get that fixed?

[Our Sponsors]

[Brian]

Sure thing. I've just updated the attachment above. If you'll download it again and then open it up in a text editor, you'll see this line now where you can change the instance prefix.
define('ADV_DYNA_PREFIX', 'adv_dyna');

[tfw2005]

Thanks Brian,

Getting an error with the new file...


Database error in vBulletin 3.6.7:

Invalid SQL:
INSERT INTO vba_fict_entries_pages (entryid, pagetext, pagenumber, allowsmilie) VALUES (

(Lotsa Values)

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '), (
112031,
'thread text..........' at line 766
Error Number : 1064
Date : Saturday, September 8th 2007 @ 05:07:19 PM
Script : ......./admincp/vba_dyna_import_vbposts.php?do=import
Referrer : ....../admincp/vba_dyna_import_vbposts.php?do=submitforums
IP Address :
Username : Me
Classname : vB_Database

[Our Sponsors]

[tfw2005]

Did some research, seems it crapped out when it hit a thread that was moved, and still had a redirect in the forum I was importing from. When I deleted the redirect, worked fine.

[Brian]

Doesn't seem like redirects should cause a problem like that. :/
I have updated the attachment above though so that redirects will not be included. Thanks for pointing out the problem!

[Lionel]

The importer works beautifully. Unfortunately since I needed to move threads and not entire forums I had to do the additional step of creating a transit forum, then move threads to transit forums and import that transit forum.

[rollinjunk]

i get this error {Your vBa Dynamics attachments folder is not writable. Please make sure that your '/var/www/vhosts/bapetalk2/subdomains/dev/httpdocs/dyna/attachments' folder on your server is chmod to 777. Once you have updated this you may refresh the page to resume the import.}

but i dont have an attachments files i have an attachment file how ever should i change something in the code?

[rollinjunk]

I then got this

http://www.bapetalk2.com/uploads/import.png


and this is the error i got


Database error in vBulletin 3.6.2:

Invalid SQL:
INSERT INTO adv_dyna_entries (entryid, title, catid, userid, username, dateline, views, posts, iconid, valid, open, sticky, showsignature, votenum, votetotal, ipaddress) VALUES (
1,
'lookin\' good...',
3,
'4',
'johnnyblaze036',
'1170949274',
'36',
'0',
'0',
'1',
'1',
'0',
'0',
'0',
'0',
'208.196.60.42'
);

MySQL Error : Duplicate entry '1' for key 1
Error Number : 1062
Date : Tuesday, September 25th 2007 @ 08:10:34 AM
Script : http://dev.bapetalk2.com/admincp/vba_dyna_import_vbposts.php?do=import
Referrer : http://dev.bapetalk2.com/admincp/vba_dyna_import_vbposts.php?do=submitforums
IP Address : 66.108.233.115
Username : rollinjunk
Classname : vB_Database

[Brian]

Sounds like you had already submitted some entries to vBa Dynamics, and you have some threads/posts with conflicting id's. If you'll run these queries through phpMyAdmin or your vBulletin Admin CP then it should clear out all of that data.

TRUNCATE adv_dyna_entries;
TRUNCATE adv_dyna_entries_pages;
TRUNCATE adv_dyna_attachments;
TRUNCATE adv_dyna_entryparsed;
TRUNCATE adv_dyna_posts;
TRUNCATE adv_dyna_rate;

[rollinjunk]

brian is that an apple compatible product?

[Brian]

The import script? As far as I'm aware there should not be any issues with a Mac.

[NashChristian]

Brian,

I noticed that after using this importer (on secondary instances), when it advises me to update my counters and I use the provided link to the vba_dyna_admin_maintenance.php, that it will only update the counters of my primary instance. How can I get this to also update the counters of my secondary instances?

Is it possible to add the [define('ADV_DYNA_PREFIX', 'articles');] line, as you advised for the vba_dyna_import_vBposts.php? Is it done exactly the same way?

Thanks for the help!
Jeff

[NashChristian]

Nevermind. I figured out how to do this through the AdminCP, in the Maintenance section for each individual instance.

Thanks!
Jeff

[yemen]

Invalid SQL:
INSERT INTO adv_dyna_entries_pages (entryid, pagetext, pagenumber, allowsmilie) VALUES (





Error Number : 1064
Date : Wednesday, February 6th 2008 @ 04:33:38 AM
Script : http://www.cyemen.com/VB/admincp/vba_dyna_import_vbposts.php?do=import
Referrer : http://www.cyemen.com/VB/admincp/vba_dyna_import_vbposts.php?do=submitforums
IP Address : 90.148.113.237
Username : الوحيشي
Classname : vb_database

[Brian]

Can you post the entire error?

[yemen]

oK brian it works now done .

but I want to remove thise thread what I should do ?

[lms]

I have the error:
Database error in vBulletin 3.6.8:

Invalid SQL:
INSERT INTO vB_adv_dyna_entries_pages (entryid, pagetext, pagenumber, allowsmilie) VALUES (
4211,
'[FONT=arial,sans-serif]\n<img alt=\"\" height=\"1\" width=\"1\">\n',

.....


1,
0
),
(
4238,
'',
1,

);

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 141
Error Number : 1064
Date : Friday, February 8th 2008 @ 12:37:52 PM
Script : http://.../foro/admincp/vba_dyna_import_vbposts.php?do=import&page=3&forumids=74,55,63,75,76,85,86,90,109,110,87,95,98,99,101,94,97,114,83,81,102,103 ,104,105,106,107,113,108,80,82,93,84,89,91,88,100,92,111,77,78,96,62,69,112&catids=3,4,5,7,8,9,10,11,13,14,16,17,20,21,22,23,24,25,27,30,57,58,59,31,32,33,3 4,46,40,41,42,43,44,45,47,48,49,50,54,55,51,52,53,56&forumkey=1&type=threads (\"http://news.google.com/news/url?sa=T&ct=us/1-0i-More...[/url)
Referrer : [url]http://.../foro/admincp/vba_dyna_import_vbposts.php?do=import&page=2&forumids=74,55,63,75,76,85,86,90,109,110,87,95,98,99,101,94,97,114,83,81,102,103 ,104,105,106,107,113,108,80,82,93,84,89,91,88,100,92,111,77,78,96,62,69,112&catids=3,4,5,7,8,9,10,11,13,14,16,17,20,21,22,23,24,25,27,30,57,58,59,31,32,33,3 4,46,40,41,42,43,44,45,47,48,49,50,54,55,51,52,53,56&forumkey=1&type=threads
IP Address :
Username : lms
Classname : vB_Database

You help me?

Thanks

[tggbrokenwings]

no one can reply to posts after this install

No Entry specified. If you followed a valid link, please notify the administrator is whats being said

I can post NEW threads but not this..

what gives?

[RaZor Edge]

Will this also work with 3.7.x?

[Brian]

As far as I'm aware it will.

[Magz]

I then got this

http://www.bapetalk2.com/uploads/import.png


and this is the error i got


Database error in vBulletin 3.6.2:

Invalid SQL:
INSERT INTO adv_dyna_entries (entryid, title, catid, userid, username, dateline, views, posts, iconid, valid, open, sticky, showsignature, votenum, votetotal, ipaddress) VALUES (
1,
'lookin\' good...',
3,
'4',
'johnnyblaze036',
'1170949274',
'36',
'0',
'0',
'1',
'1',
'0',
'0',
'0',
'0',
'208.196.60.42'
);

MySQL Error : Duplicate entry '1' for key 1
Error Number : 1062
Date : Tuesday, September 25th 2007 @ 08:10:34 AM
Script : http://dev.bapetalk2.com/admincp/vba_dyna_import_vbposts.php?do=import
Referrer : http://dev.bapetalk2.com/admincp/vba_dyna_import_vbposts.php?do=submitforums
IP Address : 66.108.233.115
Username : rollinjunk
Classname : vB_Database

Sounds like you had already submitted some entries to vBa Dynamics, and you have some threads/posts with conflicting id's. If you'll run these queries through phpMyAdmin or your vBulletin Admin CP then it should clear out all of that data.

TRUNCATE adv_dyna_entries;
TRUNCATE adv_dyna_entries_pages;
TRUNCATE adv_dyna_attachments;
TRUNCATE adv_dyna_entryparsed;
TRUNCATE adv_dyna_posts;
TRUNCATE adv_dyna_rate;

Will this also work with 3.7.x?



Brian, I imported a forum to a new category i created, and then ran the maintenence to update counters but got similar to this error. Ive tried running the queries you gave, but get

An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table 'DATABASENAME_ibp.adv_dyna_entries' doesn't exist

Ive also noticed you cannot make a reply either, You can click the reply button, enter comment etc, but but when you submit it, No comments are being recorded. Ive ran maintenence options too.

Everything else with dynamics appears to work fine

[Brian]

Looks like you need to add your table prefix before the table names in those queries.

TRUNCATE prefix_hereadv_dyna_entries;

[Magz]

Thank you brian, that seemed to work.

However, i still cant post any comments. You enter a comment, press submit, no errors are shown, but it goes back to the post and the comment isnt being displayed.

Also, after running the query, content i had in some of the "non Imported" categories dissapeared.

[Magz]

Any idea about the above message anyone ?

regards

[Magz]

Not a great fan of bumping threads, but its been just over three weeks now, and i still cant get comments to display as mentioned 2 posts back.

Show Replies on Separate Page is set to no, and all permissions are set to allow posting replies.

Any ideas ?


Update:

Grrrr, what a numpty i am,

Category permisions were set to moderation, how i missed that i will never know.
Resolved :)

[DrMirth]

I'm afraid I can't get this import script to work. I'm running vBulletin v3.7.3 Patch Level 1 and vBadvanced Dynamics v1.0.3. The script will allow be to select the forum to import from, but it the displays the following error:

PHP Fatal error: Call to undefined function print_cat_select() in vba_dyna_import_vbposts.php on line 55

Any ideas?

[DrMirth]

Okay, I fixed my problem. A few functions needed to be prefixed with 'dyna_' before they would work. I've attached the updated script.

[albumhunt]

each time i try to run the importer i get this msg
Your vBa Dynamics attachments folder is not writable. Please make sure that your '/home/users/public_html/downloads/attach' folder on your server is chmod to 777. Once you have updated this you may refresh the page to resume the import.

i noticed that its looking for the folder with the structure '/home/users/public_html/downloads/attach' but i dont have it that way..its setup as "/albumhunt.com/html/downloads/"

and i have triple checked those folder to make sure they writable.

btw vb ver 3.7.4 and the latest vb dyna

help?

EDIT: FIXED!!! simple settings needed to be changed in the dyna acp

[Renada]

Hi,

When I run the importer all I get is a blue screen (see attachment) - no way back to the admincp and no forums are imported.

Am I doing something wrong?

1) Created categories that match the forums that I want imported (not sure if this matters or not)

2) Run the import script from the admincp

3) Select the forums I want to import

4) Press Continue

5) Result = blue screen

6) Update all counters etc.

Still nothing. Did I miss something?

Regards,
Renada

[Brian]

There's not any reason I'm aware of that would cause a blue screen like that... If you would like to submit a support ticket via the Members' Area here and be sure to mention which forum's you would like to import then I'll be glad to take a look at things for you.

[Renada]

There's not any reason I'm aware of that would cause a blue screen like that... If you would like to submit a support ticket via the Members' Area here and be sure to mention which forum's you would like to import then I'll be glad to take a look at things for you.

Thanks Brian will do :)

[Dunhamzzz]

Hi,

When I run the importer all I get is a blue screen (see attachment) - no way back to the admincp and no forums are imported.

Regards,
Renada

I have this issue too with 3.8.2. I will scour error logs and report back.

The error is: Fatal error: Call to undefined function print_cat_select() in /sites/mydellmini.com/http/forum/admincp/vba_dyna_import_vbposts.php on line 58

I downloaded the version in the first post of this thread.

[Brian]

Sorry about that. Looks like the attached file needed to be updated for use with the latest version. I've just made a couple of changes to the import file attached to the first post here, so if you'll download the file again and upload the updated version to your server, you should be able to go through with the import afterward.

[Dunhamzzz]

Ok this script does not work. It messed up the first time because the folder wasn't writable (although I'm pretty sure it was, how did it store my attachements earlier?)

Upon trying to start again it hit a dupliciate key errors as the first try did not clear after itself. Now my only option is to manually go through the database and delete what was added with the import, thankfully I only tried to import one article into a database that only had 1 article in it before hand, its going to take a while but is doable none the less, anyone attempting this with any amount of articles / or no database knowledge should not try this.

Personally I regret purchasing this script, its a premium paid for product that doesn't receive the level of support a premium product should. Hell, you didn't even run the original import script ONCE to test it as you'd have seen the blatant misnamed functions.

[Brian]

The script checks that your *Dynamics* attachment folder is writable, so that part has nothing to do with the your ability to upload attachments in vBulletin before.

I'm not sure what else you're expecting as far as support, but we've answered any questions you've asked.

The import certainly was tested and has been used by several people. Certain function names were changed in a recent release of vBa Dynamics though to avoid any possibility of conflicts with other software, which is why the import script had to be updated to include use the new function names.

[Dunhamzzz]

THe problem was is that the failed import took up all they primary keys that the script or some reason needs in the database, and with no clean up done by the script, made another import (which was inevitable due to the failed one earlier) impossible without manual database pruning

[NashChristian]

Hey Brian!

Is there a way to import vBa Dyna articles back into my base vB forums?

Thanks!
:D Jeff

[Brian]

Importing back to your forums is certainly posssible, but as far as I'm aware there have not been any import scripts posted.

[VonDoom]

Just dosent seem to work for me in the first or second instance. Any Ideas?


Database error in vBulletin 3.8.2:

Invalid SQL:
INSERT INTO adv_dyna_entries (entryid, title, catid, userid, username, dateline, views, posts, iconid, valid, open, sticky, showsignature, votenum, votetotal, ipaddress) VALUES (
228,
'Stillwater Supply Collars',
7,
'78',
'StillwaterSupply',
'1229203833',
'384',
'13',
'0',
'1',
'1',
'0',
'0',
'0',
'0',
'69.1.14.204'
);

MySQL Error : Duplicate entry '228' for key 1
Error Number : 1062
Request Date : Monday, August 24th 2009 @ 11:48:45 PM
Error Date : Monday, August 24th 2009 @ 11:48:45 PM
Script : http://www.doberman-chat.com/admincp/vba_dyna_import_vbposts.php?do=import
Referrer : http://www.doberman-chat.com/admincp/vba_dyna_import_vbposts.php?do=submitforums
IP Address : 24.180.141.176
Username : VonDoom
Classname : vB_Database_MySQLi
MySQL Version : 5.0.58-log

[Brian]

Looks like you already have some entries in that instance of vBa Dyanmics. I'd suggest uninstalling and re-installing to clear everything out before trying the import.

[ttnb]

I have not tried it. However, I would like to ask if this script can import "forums" in to "categories" of dynamisc?
Thanks

[Brian]

That's exactly what it does. :) You'll need to add any categories you would like to use in vBa Dynamics first. Then when you run the import script you will see options that will allow you to import any vB forum into any of your vBa Dynamics categories.

[ttnb]

Great! Thanks for your reply!
I have just realized that vbadynamics search engine working very well with Japanese (while vbulletin default search engine does not work). Then I intend to import some of my forums which is in Japanese in to Vba dynamisc.

[VonDoom]

Thanks again Brian for your quick responces. So considering your last answer to my question, am i correct in assuming this script will only work on a fresh install of dynamics? Meaning if i want to import an entire forum i must do this before i add any other content to the dynamics instance?

hmmm if thats the case im going to have a cpl angry moderators. ;)

[Brian]

Unfortunately (for your mods anyway), you are correct. Any entries, categories, posts, and ratings will be completely cleared from your vBa Dynamics install during the import to avoid any type of conflicts.

[ttnb]

Hello
I have tried this. It works. However, I have some problems:
- The attachment in some thread have not been moved. They are "jpg" attachment.

-It seem that if we have some attachments in the "replies" then those attachments are ignored during the importing process.

For example: I have post a thread. Anh I have attachment 1. And someone replied to my thread and in this thread he has attachment 2. Then the attachment1 is importet but the attachment2 is ignored.

I want to import forums which there alots of attachment in the replies. How can I they be imported?

[ttnb]

Inorder to get the attachment in the "replies" filed, I have to split my threads in to many news posts. Then, reinstall vba-dynamics(using different prefix) and run the scripts again. Howerver this time I got the following errors:confused:


Database error in vBulletin 3.8.4:

Invalid SQL:
INSERT INTO jp_entries_pages (entryid, pagetext, pagenumber, allowsmilie) VALUES (
4242,
'Dẫn nhập: Phần dưới đây là tập hợp những từ-ngữ mà một người ở trình độ sơ cấp tiếng Nhật (3 級)　cần phải biết. Mz viết lại theo trình tự liên tưởng.\r\n\r\n\r\nTừ-ngữ giao tiếp - あいさつなどの　ことば\r\nTrình độ 4 級：\r\n\r\n ごめん　ください\r\n いらっしゃいませ\r\n*\r\n おはよう　ございます\r\n こんにちは\r\n こんばんは\r\n*\r\n はじめまして\r\n どうぞ　よろしく\r\n おねがい　します\r\n こちらこそ\r\n*\r\n いただきます\r\n ごちそさま　でした\r\n*\r\n どうも　ありがとう　ございます / ございました\r\n どういたしまして\r\n*\r\n すみません\r\n しつれい　します / しました\r\n*\r\n さようなら\r\n では、おげんきで\r\n では、また\r\n*\r\n おやすみ　なさい\r\n\r\n\r\n\r\nTrình độ 3 級：\r\n\r\n いって　いらっしゃい\r\n いって　まいります\r\n*\r\n ただいま\r\n おかえり　なさい\r\n*\r\n おまたせしました\r\n*\r\n よく、いらっしゃいました\r\n*\r\n おかげさまで\r\n おだいじに\r\n*\r\n おめでとう　ございます\r\n*\r\n かしこまりました\r\n*\r\n それは　いけません　ね。\r\n\r\n\r\nTheo 日本語能力試験直前対策\r\n\r\n#',
1,
1
), (
4249,
'I - TRỢ TỪ　 が：\r\n1. Dùng để trình bày sự hiện hữu của đồ vật.\r\nCấu trúc:\r\n。。。 + が　ある\r\nVí dụ: \r\nあそこに　デパートが　あります。\r\nỞ đằng kia có thương xá.\r\n\r\n\r\n2. Dùng để trình bày sự hiện hữu của người và động vật.\r\nCấu trúc: \r\n。。。 + が　いる\r\nVí dụ: \r\n部屋に　学生が　います.\r\nTrong phòng có học sinh.\r\n\r\n門の　前に　犬が　います.\r\nTrước cổng có con chó.\r\n\r\n\r\n3. Dùng để trình bày một đối tượng nào đó.\r\nCấu trúc: Thường kết hợp với một trong các động từ hoặc tính từ sau đấy: \r\n。。。　+　 が　欲しい\r\n。。。　＋　が　痛い\r\n。。。　＋　が　好きだ\r\n。。。　＋　が　上手だ\r\n。。。　＋　が　要る\r\n。。。　＋　が　分かる\r \n。。。　＋　が　出来る\r\n。。。\r\n\r\nVí dụ: \r\n私は　いい　辞書が　ほしい　です。\r\nTôi muốn có một quyển từ điển tốt.\r\n\r\n私は　あたまが　いたい　です。\r\nTôi bị đau đầu.\r\n\r\n私は　果物が　好き　です。\r\nTôi thích trái cây.\r\n\r\nバクさんは　歌が　上手です。\r\nAnh Baku hát hay.\r\n\r\n仕事に　コンピューターが　要ります。\r\nTôi cần máy tính cho công việc.\r\n \r\n私は　漢字が　分かります。\r\nTôi biết chữ Hán. \r\n\r\n私は　日本語が　できます。\r\nTôi biết tiếng Nhật. \r\n\r\n\r\n4. Để trình bày hai mệnh đề nghịch lý nhau\r\nVí dụ:\r\nお酒は　おいしいですが、飲みすぎると、体に　よくない。\r\nRượu thì ngon nhưng nếu uống quá nhiều sẽ không tốt cho cơ thể. \r\n\r\n\r\n5. Để trình bày câu văn sau quan trọng hơn câu văn phía trước\r\nVí dụ:\r\nみどりがわと　申しますが、どうぞ　よろしく　おねがい　します。\r\nTôi là Midorigawa, xin các vị chiếu cố cho. \r\n\r\n\r\n6. Dùng trong câu văn bổ nghĩa cho danh từ:\r\nVí dụ:\r\nこれは　子供が　読む本 です。\r\nĐâｙ là sách trẻ con đọc.\r\n\r\n\r\n#',
1,
1
), (
4266,
'I)Cách sử dụng kính ngữ và khiêm nhường ngữ\r\n\r\n-Sử dụng với người trên như thầy giáo,giám đốc \r\n-Sử dụng với những người ko thân,lần đầu gặp hay với những người ko có mối quan hệ gần gũi \r\n-Sử dụng ở những nơi trịnh trọng như các hội nghị,các cuộc hội thảo… \r\n-Sử dụng kính ngữ vào những hành động hoặc việc làm của người trên \r\n-Sử dụng khiêm nhường vào những hành động hoặc việc làm của mình,những người trong công ty và gia đình. \r\n\r\nII) Khi nào dùng O,khi nào dùng GO\r\n\r\n1-( O) thường được gắn phía trước những từ chỉ một chữ Hán và đọc theo âm Kun \r\nvd: O hanami　(お花見）\r\nOniisan　(お兄さん）\r\nOoshiesuru　(お教えする）\r\nO shio　(お塩）\r\n…….. \r\n2-(GO) thường được gắn phía trước những từ được viết bằng hai chữ Hán và đọc theo âm On \r\nVd: Go annai　(ご案内） \r\n　　　　Go kazoku　(ご家族）\r\nGo ryokoo　(ご旅行）\r\n………. \r\n3-Tuy nhiên cũng có trường hợp đặc biệt.Dù một từ được viết bởi 2 chữ Hán nhưng cũng gắn (O) vào phía trước. \r\nvd: O jikan　(お時間） \r\n　　　O benkyoo　(お勉強）\r\n\r\n[B]III) Một
1
);

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '), (
8240,
'[B][U][SIZE=\"3\"]Bài 9[/SIZE' at line 86
Error Number : 1064
Request Date : Sunday, August 30th 2009 @ 09:25:24 AM
Error Date : Sunday, August 30th 2009 @ 09:25:24 AM
Script : http://www.mysite.net/fr/admincp/vba_dyna_import_vbposts.php?do=import&page=1&forumids=57,73,74,75,78,81,82,83,96,84,12,13,18,14,85,86,87,153,88,89,58,97,98,9 0,95,99,91,93,92,94,102,101&catids=33,32,2,3,4,5,7,34,8,9,12,15,16,11,14,13,17,10,18,21,22,23,24,20,25,26,19 ,27,29,30,28,31&forumkey=22&type=threads
Referrer :
IP Address : 58.94......
Username : username
Classname : vB_Database
MySQL Version : 5.0.81-community


The errors code is too long and I obmitted some of them. Please ignore the languages because it is some japanese and Vietnamese.

[ttnb]

Update:
I have realized that errors happens with the forum in which I have both japanese and Vietnamese. Some thread title is Japanese. I tried importing forum exluding the one caused errors and it ran ok. I will manually copy threads from the error forums to vba-dynamics.

[VonDoom]

Thanks Brian worked flawlessly after i installed another instance.