|
|
|
|
|
Re: FUDforum Migration Assistant [message #164833 is a reply to message #164832] |
Thu, 17 March 2011 11:23   |
 |
simonlnu
 Messages: 19 Registered: March 2011 Location: Tiohtiake
Karma: 0
|
Junior Member |
remove from buddy list ignore all messages by this user
|
|
well, so far, I've had to modify two columns: one in the _users table, salt and the other in _smiley, code ; however I don't know if the latter is valid, since it may have inserted semi-bogus data.
EDIT: it is, just that a few of the smilies in phpbb was longer once the tildes (~) were inserted.
EDIT: Also had to remove the 'Alias' data, otherwise I was getting dupes, and violating UNIQUE constraints.
EDIT: and on the other hand, it causes problems of its own, doing that .
[Updated on: Thu, 17 March 2011 11:33] Report message to a moderator
|
|
|
|
Re: FUDforum Migration Assistant [message #164835 is a reply to message #164834] |
Thu, 17 March 2011 18:22   |
 |
simonlnu
 Messages: 19 Registered: March 2011 Location: Tiohtiake
Karma: 0
|
Junior Member |
remove from buddy list ignore all messages by this user
|
|
The alias thing was something on my part, at least in part; has to do with the bot users not necessarily having the right data. I got it mostly working eventually, but it chokes on some posts.
anonymised:
convert.php:364
conversionmaps/phpBB3.map:144
convert.php:753
) 42601: ERROR: syntax error at or near "1" LINE 1: 1 ^
Query: 1
_POST: array ( 'from' => 'phpBB3', 'cfg' => '$PHPBB3_FORUM_DIR', 'verbose' => '1', 'submit' => 'Start conversion', )
Database version: 9.0.3
[Referring Page] http://site.tld/forumlocation/convert.php
the log is more informative, basically a value ends up being null, so there's a SQL syntax error
STATEMENT: INSERT INTO _thread (
id, forum_id, root_msg_id, views, replies, thread_opt, orderexpiry
) VALUES(
784,
,
1135,
6,
0,
0,
0)
|
|
|
|
|
Re: FUDforum Migration Assistant [message #164842 is a reply to message #164838] |
Thu, 17 March 2011 19:49   |
 |
simonlnu
 Messages: 19 Registered: March 2011 Location: Tiohtiake
Karma: 0
|
Junior Member |
remove from buddy list ignore all messages by this user
|
|
found the original problem with alias, but then choked later with the bot users
2011-03-18 03:09:35 UTC 192.168.1.1(30164) (user@dbname): ERROR: invalid input syntax for integer: "" at character 557
2011-03-18 03:09:35 UTC 192.168.1.1(30164) (user@dbname): STATEMENT: INSERT INTO fud_users
(id, login, alias, name, passwd, salt, last_visit, last_read, join_date,
email, home_page, location, time_zone, sig, avatar, avatar_loc,
icq, aim, yahoo, msnm, users_opt, theme)
VALUES (
2,
-- I Inserted the PHP code here for clarity and anonymity
'. _esc($user['login']) .',
'. _esc(htmlspecialchars($user['login'])) .',
'. _esc($user['name']) .',
'',
'',
'',
'hashed_password',
'hash',
1272115119,
1272115119,
1194157086,
'admin(at)emailaddress(dot)tld',
'',
'',
'-5.00',
'<font size="150"><b><font color="#FF0000">If you have a problem with the board, contact me.</font></b></font>',
0,
'',
'',
'',
'',
'',
5436407,
2
)
|
|
|
Re: FUDforum Migration Assistant [message #164843 is a reply to message #164838] |
Thu, 17 March 2011 23:11   |
 |
naudefj
 Messages: 3775 Registered: December 2004
Karma: 28
|
Senior Member Administrator Core Developer |
add to buddy list ignore all messages by this user
|
|
simonlnu wrote:now i gotta clean up the fud database, hehe
No need to clean up anything. Just re-run the converter.
simonlnu wrote:STATEMENT: INSERT INTO _thread ( id, forum_id, root_msg_id, views, replies, thread_opt, orderexpiry ) VALUES( 784, ,
A thread that's not in a forum? I guess we can simply ignore these.
|
|
|
|
|
|
|
|
|
|
Re: FUDforum Migration Assistant [message #165663 is a reply to message #164706] |
Sun, 31 July 2011 21:21   |
|
I have been trying to get the latest migration assistant to convert phpbb3 and keep getting stuck on a couple of things.
Running php5.2.17, Apache 2.2.19, MySQL 5.5.14 on WinXPProSP3 (just for test/dev - I use Linux for production)
1) The phpBB3 config.php uses $dbport variable. The connect script in the migration assistant apparently does not use $dbport but either assumes that the port will be read from the services file or php.ini, or assumes it will use the socket instead. Even though the port is defined in services (mysql-tcp) and the port is set in the mysqli section of php.ini, it doesn't seem to use it.
The only way I can get the convert.php to connect is by commenting out the $dbport setting in phpbb3's config.php and adding the port to the $dbhost variable ('localhost:3306'), and when I do that, the convert.php script will connect to the phpbb3 database, but that breaks phpbb3's access to the database.
2) The source phpBB3's data has some utf8 character-set data. It has occurred for me in the location field of the user table, but if it happens there I expect it would happen elsewhere as it encounters utf8 characters in other tables/fields as the conversion progresses past the user import. When it does, it fails to continue, giving this error (confidential info replaced with strings of x'es): E:\halftb\xxxx\FUDforum_3.0.2\fudforum\convert.php:751
) 1366: Incorrect string value: '\xEDa)' for column 'location' at row 1
Query: INSERT INTO fud30_users (id, login, alias, name, passwd, salt, last_visit, last_read, join_date, email, home_page, location, time_zone, sig, avatar, avatar_loc, icq, aim, yahoo, msnm, users_opt, theme) VALUES ( 1752, 'gxxxx7', 'gxxxx7', 'gxxxx7', 'xxxxxxxxxxxxxxxxxxxxxxxxxx..xxxxxx', '', 1205384388, 1205384388, 1158515359, 'gxxxx7(at)hotmail(dot)com', '', 'Caracas (while in vacations Lecher�a)', '0.00', '', 0, '<img src=\"h t t p : / / testpc.xxxxx/fud2//images/custom_avatars/3989bd335ab62e53c32b638e45a83adb_1752.jpg\" alt=\"\" width=\"100\" height=\"100\" />', 0, '', '', '', 4387830, 1 )
WRT #1, I can deal with working around the change needed to make the connect work, but it is something you should add to your buglist. The different method phpBB3 uses, even if it's non-standard, shouldn't make the conversion fail; the difference should be handled in the phpbb3 conversion map or something, if by no other means, at least by concatenating $dbhost .':'. $dbport if $dbport is set, when building your connect string.
WRT #2, is there a way to make it accept UTF8 data? Is this a function of how the database or tables were defined in MySQL by the FUDforum 3.0.2 installer, or is it in a globals file or something, or is there a function within the convert.php that should be modified to add logic to convert the UTF8 characters?
|
|
|
|
Re: FUDforum Migration Assistant [message #165675 is a reply to message #165664] |
Thu, 04 August 2011 00:42   |
|
I tried the SVN of the migration assistant, against 3.03RC1, and had reasonable success a) with the connect to the phpBB3 database, and 2) with the avatar, smilies and user imports.
It choked after importing the topics, when trying to import the messages. The subject field in phpbb3 is varchar 255 while in FUD the subject field is vc 100. Eight of the messages (out of thousands) have more than 100 characters.
Any chance of there being some provision for this? I noticed the same difference exists in the PM subject line field; again phpBB3's is 255 while FUDforum's is 100.
If I change the field size in the FUDforum database to fit any data coming from phpBB3 will that break functionality?
I could change the subject line to fit 100 characters, manually, for those phpBB3 fields using more than 100, but I really hate the idea of my users losing any of their content because of limitations in the (hopefully) new forum software.
|
|
|
|
|
|