News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord

Main Menu

[SMF Converter] vBulletin 3.7

Started by SleePy, September 17, 2008, 03:03:37 PM

Previous topic - Next topic

benz1

Quote from: TE on March 15, 2009, 04:15:43 PM
Ok, we go the easy way ;) try the attached version. you should be asked for a database and table prefix.

OK, we're making progress. Managed to import the vBulletin database into the new database I created but can't get past the first page of convert.php.

If the details in Settings.php are as follows:
$db_name = 'account_smf1';
$db_user = 'account_smf1';
$db_passwd = 'xxxxxxxx';
$db_prefix = 'smf_';

and the VB database details are:
db_name: account_vbdump
db_user: account_vb
db_passwd: yyyyyy
prefix: account

What should the correct details be for MySQL database & Table Prefix & passowrd?

Thanks,
Benz1

ThorstenE

ups, different databases with different MySQL users / passwords is a problem. SMF must be allowed to read the vBulletin database. you shoul use the same database for both SMF and vBulletin.
Then use this for the database and "account" for the prefix (your vBulletin table prefix).

benz1

Quote from: TE on March 16, 2009, 02:52:20 AM
ups, different databases with different MySQL users / passwords is a problem. SMF must be allowed to read the vBulletin database. you shoul use the same database for both SMF and vBulletin.
Then use this for the database and "account" for the prefix (your vBulletin table prefix).

Oh ok, so I should have imported the VB database into the existing SMF database? I could point Settings.php to the new one but I guess I'd lose my admin account on SMF then. I actually had to get my host to import the dbase as I couldn't do it. If this is the answer then I'll have to ask them to re-import it into the SMF database.

Thanks,
Benz1

benz1

Hi TE,

Made more progress but am stuck again.

Managed to import the vBulletin database into my SMF database.
Ran convert.php using your updated .sql file. Worked out that the prefix actually relates to the prefix of the imported database so
MySQL database: massive_smf1
Table Prefix is mos_ (from imported VB database)

When I ran it I got
Converting members... Unsuccessful!
The error was that massive_smf1.mos_user was not found

I noticed that there was no table mos_user but there was mos_users so I edited your sql file and changed 4 occurrences of user to users.

Ran convert again but this time got:

Converting members... Unsuccessful!
This query:

    SELECT
    u.userid AS ID_MEMBER, SUBSTRING(u.username, 1, 80) AS memberName,
    SUBSTRING(u.username, 1, 255) AS realName,
    SUBSTRING(u.password, 1, 64) AS passwd,
    SUBSTRING(u.email, 1, 255) AS emailAddress,
    SUBSTRING(u.homepage, 1, 255) AS websiteTitle,
    SUBSTRING(u.homepage, 1, 255) AS websiteUrl,
    SUBSTRING(u.icq, 1, 255) AS ICQ, SUBSTRING(u.aim, 1, 16) AS AIM,
    SUBSTRING(u.yahoo, 1, 32) AS YIM, SUBSTRING(u.msn, 1, 255) AS MSN,
    SUBSTRING(IF(u.customtitle, u.usertitle, ''), 1, 255) AS usertitle,
    u.lastvisit AS lastLogin, u.joindate AS dateRegistered, u.posts,
    u.reputation AS karmaGood, u.birthday_search AS birthdate,
    SUBSTRING(u.ipaddress, 1, 255) AS memberIP,
    SUBSTRING(u.ipaddress, 1, 255) AS memberIP2,
    CASE
    WHEN u.usergroupid = 6 THEN 1
    WHEN u.usergroupid = 5 THEN 2
    WHEN u.usergroupid = 7 THEN 2
    ELSE 0
    END AS ID_GROUP,
    CASE WHEN u.usergroupid IN (3, 4) THEN 0 ELSE 1 END AS is_activated,
    SUBSTRING(u.salt, 1, 5) AS passwordSalt,
    SUBSTRING(ut.signature, 1, 65534) AS signature, '' AS lngfile,
    '' AS buddy_list, '' AS pm_ignore_list, '' AS messageLabels,
    '' AS personalText, '' AS timeFormat, '' AS avatar, '' AS secretQuestion,
    '' AS secretAnswer, '' AS validation_code, '' AS additionalGroups,
    '' AS smileySet
    FROM `massive_smf1`.mos_users AS u
    LEFT JOIN `massive_smf1`.mos_usertextfield AS ut ON (ut.userid = u.userid)
    WHERE u.userid != 0
    LIMIT 0, 500;

Caused the error:

    Table 'massive_smf1.mos_usertextfield' doesn't exist

Tried changing this to users to but still didn't work. There is no field called textfield in the mos_users table.

Have now reached the limits of my technical knowledge so would be grateful if you could assist.

Thanks,
Benz1

ThorstenE

can you check your database with phpMyAdmin please? is there a table named "mos_usertextfield' ? Are you sure this is a vBulletin 3.7.4 backup?

benz1

Definitely no mos_usertextfield. Full list of tables below.

The footer of the forum it was exported from says, Powered by vBulletin® Version 3.7.4

massive_smf1 (123)

    beta_users
    mos_banner
    mos_bannerclient
    mos_bannerfinish
    mos_bookmarks
    mos_bookmarks_categories
    mos_bookmarks_columns
    mos_bookmarks_itemcat
    mos_bookmarks_prefs
    mos_bookmarks_vote
    mos_categories
    mos_combomax
    mos_components
    mos_contact_details
    mos_content
    mos_content_frontpage
    mos_content_rating
    mos_core_acl_aro
    mos_core_acl_aro_groups
    mos_core_acl_aro_sections
    mos_core_acl_groups_aro_map
    mos_core_log_items
    mos_core_log_searches
    mos_docman
    mos_docman_groups
    mos_docman_history
    mos_docman_licenses
    mos_docman_log
    mos_enewsfrontpage
    mos_groups
    mos_mambots
    mos_menu
    mos_messages
    mos_messages_cfg
    mos_modules
    mos_modules_menu
    mos_newsfeeds
    mos_polls
    mos_poll_data
    mos_poll_date
    mos_poll_menu
    mos_ptregions
    mos_sections
    mos_session
    mos_stats_agents
    mos_templates_menu
    mos_template_positions
    mos_tfs_bots
    mos_tfs_browsers
    mos_tfs_configuration
    mos_tfs_ipaddresses
    mos_tfs_iptocountry
    mos_tfs_keywords
    mos_tfs_pages
    mos_tfs_page_request
    mos_tfs_page_request_c
    mos_tfs_referrer
    mos_tfs_search_engines
    mos_tfs_systems
    mos_tfs_topleveldomains
    mos_tfs_visits
    mos_users
    mos_usertypes
    mos_weblinks
    phpads_acls
    phpads_adclicks
    phpads_adstats
    phpads_adviews
    phpads_affiliates
    phpads_banners
    phpads_cache
    phpads_clients
    phpads_config
    phpads_images
    phpads_session
    phpads_targetstats
    phpads_userlog
    smf_attachments
    smf_ban_groups
    smf_ban_items
    smf_boards
    smf_board_permissions
    smf_calendar
    smf_calendar_holidays
    smf_categories
    smf_collapsed_categories
    smf_log_actions
    smf_log_activity
    smf_log_banned
    smf_log_boards
    smf_log_errors
    smf_log_floodcontrol
    smf_log_karma
    smf_log_mark_read
    smf_log_notify
    smf_log_online
    smf_log_polls
    smf_log_search_messages
    smf_log_search_results
    smf_log_search_subjects
    smf_log_search_topics
    smf_log_topics
    smf_membergroups
    smf_members
    smf_messages
    smf_message_icons
    smf_moderators
    smf_package_servers
    smf_pages
    smf_permissions
    smf_personal_messages
    smf_pm_recipients
    smf_polls
    smf_poll_choices
    smf_sessions
    smf_settings
    smf_smileys
    smf_sp_articles
    smf_sp_blocks
    smf_sp_categories
    smf_sp_functions
    smf_themes
    smf_topics

benz1

Have you given up on me?

Is it possible that the backup I imported was incomplete or didn't import correctly due to the size of the database?

Thanks,
Benz1

Spark753

woop ty ty ty. this works fine with vb 3.8.1
"Time is free, but it's priceless. You can't own it, but you can use it. You can't keep it, but you can spend it. Once you've lost it you can never get it back."

mobilewo

hi friends any one tel me how to install .sql file step by step


mobilewo

hello sir when i open covert.php  file ($row['realName'] = trim($row['realName'], " \t\n\r\x0B\0\xA0"); if (strpos($row['realName'], '<') !== false || strpos($row['realName'], '>') !== false || strpos($row['realName'], '& ') !== false) $row['realName'] = htmlspecialchars($row['realName'], ENT_QUOTES); else $row['realName'] = strtr($row['realName'], array('\'' => ''')); } if (empty($no_add)) $rows[] = "'" . implode("', '", addslashes_recursive($row)) . "'"; else $no_add = false; if (empty($keys)) $keys = array_keys($row); } if (isset($ignore) && $ignore == true) $ignore = 'IGNORE'; else $ignore = ''; if (!empty($rows)) convert_query(" INSERT $ignore INTO $special_table (" . implode(', ', $keys) . ") VALUES (" . implode('), (', $rows) . ")"); $_REQUEST['start'] += $special_limit; if (empty($special_max) && convert_num_rows($special_result) < $special_limit) break; elseif (!empty($special_max) && convert_num_rows($special_result) == 0 && $_REQUEST['start'] > $special_max) break; convert_free_result($special_result); } } $_REQUEST['start'] = 0; $s)

same as words coming

SleePy

Please try to redownload the vb Converter package from the official downloads page. It looks like Convert.php is corrupted in the one you downloaded.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

Hoof

This worked great, Thank You!

"54786 Posts in 11901 Topics by 2859 Members"  Pretty close to actual numbers from my vB site, I can live with it :) .

shawn666

The convert.php link doesn't let me download...just takes me to a list of topics which just leads me back here, wtf?

ThorstenE

Quote from: shawn666 on June 08, 2009, 07:09:46 PM
..just takes me to a list of topics which just leads me back here, wtf?
Convert.php is attached at the end of that topic, scroll down and you'll hopefully find it..

Les Paul

Quote from: SleePy on September 17, 2008, 03:03:37 PM
Software: vBulletin
Version: 3.7.x

The following is not converted:
- Permissions for boards are not converted.
- Membergorups are not converted.
- Avatar may not convert (under tested).

Changelog

convert.php
Use this convert.php with the .sql file attached in this topic.

I can't download the convert.php for vBulletin. Where is it?


Andreyguba

HI/ what doe it mean -


Notice: Undefined variable: config in /home/*/public_html/new/convert.php(407) : eval()'d code on line 1

Notice: Undefined variable: config in /home/*/public_html/new/convert.php(407) : eval()'d code on line 1

After -

Sorry, the database connection information used in the specified installation of SMF cannot access the installation of vBulletin 3.7. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it.

The error MySQL gave was: Incorrect database name ''


ThorstenE

the database name from your vBulletin wasn't identified by the converter.

please check this post:
http://www.simplemachines.org/community/index.php?topic=262571.msg1976367#msg1976367

Les Paul

I get an error when converting..


Converting personal messages (step 2)... Unsuccessful!
This query:

    SELECT
    pm.pmid AS ID_PM, pm.userid AS ID_MEMBER, pm.messageread != 0 AS is_read,
    '-1' AS labels
    FROM `ja000184_sarara`._vbpm
    LIMIT 0, 500;

Caused the error:

    Unknown column 'pm.pmid' in 'field list'


Hoy can I do?

Advertisement: