Well, obviously... but importing them as threads is still better than nothing and in many cases good enough.
If you want to keep the blogs as "Blogs", the Better Blogs add-on provides a vBulletin 3.8/4 importerAny particular reason why all these modules aren't in the official vB3 importer already then? I would assume that everyone wants more and not less complete imports...
Unfortunately, I simply cannot replicate the issue. I have tested it on every version of centos 5.6 to 6.4. The issue lies with your server and its configuration interfering with the export file. Which is strange as the REPLACE function is a basic one thats been in mysql forever.
The only thing I can suggest is to alter both database users to grant all privileges on all databases for the import process, then flush the perms.
Does Importer supports the xenforo 1.2.1 new version now?
i have turkish charset problem. from only, user and polls tables.
To confirm, please post the error from the Import script's output, assuming there is one.
same problem for meWhen the import process. Turkish character's problems. poll and user tables.
in my opinion, these two tables are not transferred as LATIN5
When the import process. Turkish character's problems. poll and user tables.
in my opinion, these two tables are not transferred as LATIN5
// USE THIS SETTING TO SPECIFY AN EXTRA PIPE FOR ALL OUTPUT RECORDS
// EXAMPLE IS TO PIPE OUTPUT THROUGH iconv IF CHARACTER ENCODING CHANGES ARE NEEDED
// '| iconv -f LATIN1 -t UTF8'
public static $extraOutCommand = '| iconv -f LATIN1 -t UTF8';
same problem for me
portuguese language.
import process.. portuguese characters
errors screen:
threads:
http://imgur.com/Cqrg7N8
users:
http://i.imgur.com/xCCjyjT.png
all permissions set.."SELECT command denied"
That is a lack of MySQL permissions for your MySQL user.
Without a specific error, URL, or screenshot I can only speculate.
There is a configurable option in the Export script you can play with:
Code:// USE THIS SETTING TO SPECIFY AN EXTRA PIPE FOR ALL OUTPUT RECORDS // EXAMPLE IS TO PIPE OUTPUT THROUGH iconv IF CHARACTER ENCODING CHANGES ARE NEEDED // '| iconv -f LATIN1 -t UTF8' public static $extraOutCommand = '| iconv -f LATIN1 -t UTF8';
// '| iconv -f LATIN1 -t UTF8'
public static $extraOutCommand = '| iconv -f LATIN5 -t UTF8';
UPDATE xf_user
SET username = REPLACE(username, 'ɑ', 'new value')
// EXTRA PIPE IF NEEDED
if (self::$extraOutCommand)
{
exec('cat ' . self::$dataDir . 'xf_poll_response.txt ' . self::$extraOutCommand . ' > ' . self::$dataDir . 'xf_poll_response_utf8.txt');
exec('rm ' . self::$dataDir . 'xf_poll_response.txt');
exec('mv ' . self::$dataDir . 'xf_poll_response_utf8.txt ' . self::$dataDir . 'xf_poll_response.txt');
}
public static $extraOutCommand = '| iconv -f LATIN5 -t UTF8';
@router
Your usernames have html entities. You should be able to fix that by running a replacement query on each entity. For example:
Rich (BB code):UPDATE xf_user SET username = REPLACE(username, 'ɑ', 'new value')
The poll information appears to be getting double converted. If the problem is only affecting polls then it must be a problem with the poll data. Maybe try removing the extra pipe for poll response data in the Export script:
Code:// EXTRA PIPE IF NEEDED if (self::$extraOutCommand) { exec('cat ' . self::$dataDir . 'xf_poll_response.txt ' . self::$extraOutCommand . ' > ' . self::$dataDir . 'xf_poll_response_utf8.txt'); exec('rm ' . self::$dataDir . 'xf_poll_response.txt'); exec('mv ' . self::$dataDir . 'xf_poll_response_utf8.txt ' . self::$dataDir . 'xf_poll_response.txt'); }
// EXTRA PIPE IF NEEDED
if (self::$extraOutCommand)
{
exec('cat ' . self::$dataDir . 'xf_user.txt ' . self::$extraOutCommand . ' > ' . self::$dataDir . 'xf_user_utf8.txt');
exec('rm ' . self::$dataDir . 'xf_user.txt');
exec('mv ' . self::$dataDir . 'xf_user_utf8.txt ' . self::$dataDir . 'xf_user.txt');
}
$this->db->closeConnection();
We use essential cookies to make this site work, and optional cookies to enhance your experience.