SELECT *
FROM vbulletin.user AS user
...
postssh: -c: line 0: syntax error near unexpected token `)'
sh: -c: line 0: `mysql -hlocalhost o_forum -uo_dbuser -p)yB0OSIDYxnt -N -q -e "SET NAMES binary;SET @position = -1, @previous = 0, @last_state = 0, @ip_id = 0;SELECT SQL_NO_CACHE post.postid AS post_id, post.threadid AS thread_id, post.userid AS user_id, post.username, post.dateline AS post_date, post.pagetext AS message, @ip_id:=@ip_id+1 AS ip_id, IF(post.visible = 0, 'moderated', IF(post.visible = 2, 'deleted', 'visible')) AS message_state, attach AS attach_count, IF(@previous = post.threadid, @position:=@position+@last_state, @position:=(0 * @previous:=post.threadid)) + ((@last_state:=IF(post.visible = 1, 1, 0)) * 0) AS position, 0 AS likes, 'a:0:{}' AS like_users, COALESCE((SELECT infractionid FROM infraction as infraction WHERE infraction.postid = post.postid AND action IN(0, 1) LIMIT 1), 0) AS warning_id, '' AS warning_message, 0 AS last_edit_date, 0 AS last_edit_user_id, 0 AS edit_count FROM post as post WHERE 1 ORDER BY post.threadid, post.postid" | sed -r 's/\[quote="?([^]";]*?);([^]";]*?)"?\]/[quote="\1, post: \2"]/ig;s/\[highlight\]//ig;s/\[\/highlight\]//ig;s/\[nofollow/\[url/ig;s/\[\/nofollow/\[\/url\]/ig;s/\[noparse\]/\[plain\]/ig;s/\[\/noparse\]/\[\/plain\]/ig;s/\[strike\]/\[s\]/ig;s/\[\/strike\]/\[\/s\]/ig;s/\[video\]http\:\/\/www.youtube.*v=([^&[]*?).*\[\/video\]/\[media=youtube\]\1\[\/media\]/ig' | iconv -f LATIN1 -t UTF8 > /home/e/public_html/import_data/xf_post.txt' echo $user['userid'] . ' ';
On a related note, in the db you're importing from, make sure to create a test thread with special characters (such as 'ɟpsɐ') in the title of the thread, in the post of the thread, in the user title (for a test user you create on the old board), and any other places you'd like to be sure convert properly with special chars.
Server Error Log
Error Info
Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Incorrect integer value: '' for column 'user_group_id' at row 2 - library/Zend/Db/Statement/Mysqli.php:214
Generated By: admin, Today at 11:24 AM
Stack Trace
#0 /home/e/public_html/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /home/e/public_html/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /home/e/public_html/library/XenForo/DataWriter/User.php(1111): Zend_Db_Adapter_Abstract->query('\n\t\t\tINSERT INTO...')
#3 /home/e/public_html/library/XenForo/Deferred/User.php(38): XenForo_DataWriter_User->rebuildUserGroupRelations()
#4 /home/e/public_html/library/XenForo/Model/Deferred.php(295): XenForo_Deferred_User->execute(Array, Array, 7.99999785423, '')
#5 /home/e/public_html/library/XenForo/Model/Deferred.php(429): XenForo_Model_Deferred->runDeferred(Array, 7.99999785423, '', false)
#6 /home/e/public_html/library/XenForo/Model/Deferred.php(374): XenForo_Model_Deferred->_runInternal(Array, NULL, '', false)
#7 /home/e/public_html/library/XenForo/ControllerAdmin/Tools.php(159): XenForo_Model_Deferred->run(true, NULL, '', false)
#8 /home/e/public_html/library/XenForo/FrontController.php(351): XenForo_ControllerAdmin_Tools->actionRunDeferred()
#9 /home/e/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#10 /home/e/public_html/admin.php(13): XenForo_FrontController->run()
#11 {main}
Request State
array(3) {
["url"] => string(55) "http://example.com/admin.php?tools/run-deferred"
["_GET"] => array(1) {
["tools/run-deferred"] => string(0) ""
}
["_POST"] => array(5) {
["execute"] => string(1) "1"
["_xfRequestUri"] => string(34) "/admin.php?tools/rebuild&success=1"
["_xfNoRedirect"] => string(1) "1"
["_xfToken"] => string(8) "********"
["_xfResponseType"] => string(4) "json"
}
}I found xf_user_field in Export.php. I installed the latest version, 1.5.1. Could you grab code from the standard importer to handle the automatic ordering?
fwrite($fp_user, str_replace('\\', '\\\\', "$user[userid] " . html_entity_decode($user['username']) . " $user[email] " . ($user['customtitle'] ? html_entity_decode($user['usertitle']) : '') . " 1 0 " . $importModel->resolveTimeZoneOffset($user['timezoneoffset'], $user['options'] & 64) . " 1 1 $user[usergroupid] $user[membergroupids] $userGroupDisplay $permissionComboId $user[posts] $user[pmunread] $user[joindate] $user[lastactivity] 0 0 $user[avatar_date] 192 192 " . ($user['usergroupid'] == 1 ? 'email_confirm' : 'valid') . " " . ($user['usergroupid'] == 4 ? '1' : '0') . " " . ($user['usergroupid'] == 3 ? '1' : '0') . " " . ($is_banned ? 1 : 0) . " $user[like_count] $user[ipoints] " . (($user['usergroupid'] == 4 OR $user['usergroupid'] == 3) ? '1' : '0')) . "\n");2) OK, strangely I can see the forums now. Maybe it was a caching issue.
// Created in the destination Xenforo
// 5-Supermods
// 6-Banned
// 7-Active
// 8-PMs
// 9-Summarizers
// MAP VB GROUP IDS TO XF GROUP IDS
public static $groupMap = array(
1 => 1,
2 => 2,
3 => 1,
4 => 1,
5 => 5,
6 => 3,
7 => 4,
8 => 6,
18 => 7,
21 => 8,
23 => 9,
);
