|
|
|
|
|
|
|
|
|
|
| Re: FUDforum Migration Assistant [message #164833 is a reply to message #164832] |
Thu, 17 March 2011 15:23   |
 |
simonlnu
Messages: 19
Registered: March 2011
Location: Tiohtiake
Karma: 0
|
Junior Member |
|
|
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 15:33] Report message to a moderator |
|
|
|
|
|
| Re: FUDforum Migration Assistant [message #164835 is a reply to message #164834] |
Thu, 17 March 2011 22:22 |
|
simonlnu
Messages: 19
Registered: March 2011
Location: Tiohtiake
Karma: 0
|
Junior Member |
|
|
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 23:49 |
|
simonlnu
Messages: 19
Registered: March 2011
Location: Tiohtiake
Karma: 0
|
Junior Member |
|
|
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] |
Fri, 18 March 2011 03:11 |
 |
naudefj
Messages: 3771
Registered: December 2004
Karma: 28
|
Senior Member
Administrator
Core Developer |
|
|
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 #164844 is a reply to message #164843] |
Fri, 18 March 2011 04:26 |
|
simonlnu
Messages: 19
Registered: March 2011
Location: Tiohtiake
Karma: 0
|
Junior Member |
|
|
it's that non value there that make it choke, the "784, ," thing.
EDIT: in the patch, i do some weird stuff to get around the empty id. that's probably what made the topics and such all crazy (see my later post from a few minutes ago [07:54 local, 11:54 UTC])
[Updated on: Fri, 18 March 2011 08:29] Report message to a moderator |
|
|
|
|
|
|
|
| Re: FUDforum Migration Assistant [message #164852 is a reply to message #164851] |
Fri, 18 March 2011 08:27 |
|
simonlnu
Messages: 19
Registered: March 2011
Location: Tiohtiake
Karma: 0
|
Junior Member |
|
|
well, reset pass, all's good. one thing i note once i rebuilt everything... the categories, topics are screwed up.. topics/posts aren't with the categories they belong to. PM me if you want to see, i'll post a link to both the original and the new forum
Edit: more i think about it, the more i think it is that funky stuff i did in the patch (#2)
[Updated on: Fri, 18 March 2011 09:05] Report message to a moderator |
|
|
|
|
|
|
|
|
|
| Re: FUDforum Migration Assistant [message #165663 is a reply to message #164706] |
Mon, 01 August 2011 01:21 |
 |
ShineOn
Messages: 53
Registered: July 2011
Karma: 1
|
Member |
|
|
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?
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
) 2 Votes
.
]