|
|
|
|
|
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: 3771 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.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|