Page 1 of 4 1234 LastLast
Results 1 to 20 of 65

Thread: vBulletin Forums Importer

  1. #1
    Join Date
    Jan 2004
    Location
    Georgia, USA
    Posts
    34,466

    Default vBulletin Forums Importer

    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.
    Last edited by Brian; 05-27-2009 at 11:16 AM.

  2. #2
    Join Date
    Aug 2004
    Posts
    353

    Default Re: vBulletin Forums Importer

    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?

  3. #3
    Join Date
    Jan 2004
    Location
    Georgia, USA
    Posts
    34,466

    Default Re: vBulletin Forums Importer

    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.
    PHP Code:
    define('ADV_DYNA_PREFIX''adv_dyna'); 

  4. #4
    Join Date
    Aug 2004
    Posts
    353

    Default Re: vBulletin Forums Importer

    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
    Last edited by tfw2005; 09-08-2007 at 06:22 PM.

  5. #5
    Join Date
    Aug 2004
    Posts
    353

    Default Re: vBulletin Forums Importer

    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.

  6. #6
    Join Date
    Jan 2004
    Location
    Georgia, USA
    Posts
    34,466

    Default Re: vBulletin Forums Importer

    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!

  7. #7
    Join Date
    Jan 2004
    Location
    Miami
    Posts
    1,040

    Default Re: vBulletin Forums Importer

    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.

  8. #8
    Join Date
    Sep 2007
    Location
    NYC
    Posts
    17

    Default Re: vBulletin Forums Importer

    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?

  9. #9
    Join Date
    Sep 2007
    Location
    NYC
    Posts
    17

    Default Re: vBulletin Forums Importer

    I then got this




    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....php?do=import
    Referrer : http://dev.bapetalk2.com/admincp/vba...o=submitforums
    IP Address : 66.108.233.115
    Username : rollinjunk
    Classname : vB_Database

  10. #10
    Join Date
    Jan 2004
    Location
    Georgia, USA
    Posts
    34,466

    Default Re: vBulletin Forums Importer

    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;

  11. #11
    Join Date
    Sep 2007
    Location
    NYC
    Posts
    17

    Default Re: vBulletin Forums Importer

    brian is that an apple compatible product?

  12. #12
    Join Date
    Jan 2004
    Location
    Georgia, USA
    Posts
    34,466

    Default Re: vBulletin Forums Importer

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

  13. #13
    Join Date
    Nov 2007
    Location
    Nashville, Tennessee
    Posts
    249

    Question Re: vBulletin Forums Importer - Updating Counters for Secondary Instances

    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
    Last edited by NashChristian; 01-06-2008 at 03:25 AM.

  14. #14
    Join Date
    Nov 2007
    Location
    Nashville, Tennessee
    Posts
    249

    Default Re: vBulletin Forums Importer

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

    Thanks!
    Jeff

  15. #15
    Join Date
    Jan 2008
    Posts
    3

    Default Re: vBulletin Forums Importer

    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....php?do=import
    Referrer : http://www.cyemen.com/VB/admincp/vba...o=submitforums
    IP Address : 90.148.113.237
    Username : الوحيشي
    Classname : vb_database

  16. #16
    Join Date
    Jan 2004
    Location
    Georgia, USA
    Posts
    34,466

    Default Re: vBulletin Forums Importer

    Can you post the entire error?

  17. #17
    Join Date
    Jan 2008
    Posts
    3

    Default Re: vBulletin Forums Importer

    oK brian it works now done .

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

  18. #18
    Join Date
    Jan 2008
    Posts
    7

    Default Re: vBulletin Forums Importer

    I have the error:
    Code:
    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[URL=\"http://news.google.com/news/url?sa=T&ct=us/1-0i-More...[/url]',
    
    .....
    
    
    							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_imp...1&type=threads
    Referrer     : http://.../foro/admincp/vba_dyna_imp...1&type=threads
    IP Address   : 
    Username     : lms
    Classname    : vB_Database
    You help me?

    Thanks
    Last edited by lms; 02-08-2008 at 07:02 PM.

  19. #19

    Default Re: vBulletin Forums Importer

    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?

  20. #20

    Default Re: vBulletin Forums Importer

    Will this also work with 3.7.x?
    -

Page 1 of 4 1234 LastLast

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. forum importer
    By Lionel in forum Feedback & Suggestions
    Replies: 5
    Last Post: 08-27-2007, 07:05 AM
  2. vBulletin Development Update: vBulletin 3.5
    By ManagerJosh in forum Chit Chat
    Replies: 58
    Last Post: 10-05-2005, 12:46 AM
  3. width of forums changed after module was enabled in forums
    By bringindaruckus in forum Troubleshooting / "How do I..." Questions
    Replies: 7
    Last Post: 06-03-2005, 04:45 PM
  4. vbulletin functions outside of forums directory
    By dionysis in forum Troubleshooting / "How do I..." Questions
    Replies: 1
    Last Post: 01-04-2005, 06:59 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •