| Re: FUDforum Migration Assistant |
Wed, 12 April 2023 14:29 |
|
|
Hi!
Just found this wonderful piece of forum software and now I'm planning on migrating our current forum from Simple Machines to FUD, but I found that the Migration Assistant is not really working with PHP 7.4 anymore.
Any plans to update the converter or am I doomed to stay on SMF?
|
|
| Post by Parrot is ignored |
| Re: FUDforum Migration Assistant |
Thu, 04 August 2011 01:57 |
|
|
ShineOn wrote: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.
No, it won't break anything. Go ahead and increase it to 255.
PS: I'll also change FUDforum's default to 255 for the next release (next RC or final 3.0.3).
|
|
| Post by ShineOn is ignored |
| Re: FUDforum Migration Assistant |
Mon, 01 August 2011 12:46 |
|
|
#1 will be fixed in the next release.
For #2, can you create the DB as UTF-8? Alternatively, run the the MySQL Charset Converter (in ACP) to convert all tables to UTF-8.
|
|
| Post by ShineOn is ignored |
|
|
|
|
|
|
| Re: FUDforum Migration Assistant |
Fri, 18 March 2011 04:27 |
|
|
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)
|
|
|
|
|
|
| Re: FUDforum Migration Assistant |
Fri, 18 March 2011 00:26 |
|
|
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])
|
|
| Re: FUDforum Migration Assistant |
Thu, 17 March 2011 23:11 |
|
|
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 |
Thu, 17 March 2011 19:49 |
|
|
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@emailaddress.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 |
Thu, 17 March 2011 18:23 |
|
|
i'll post a patch shortly for the changes i did (you probably won't want to keep them all, i can guarantee it 
|
|
| Re: FUDforum Migration Assistant |
Thu, 17 March 2011 18:22 |
|
|
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 |
Thu, 17 March 2011 13:37 |
|
|
Please see
http://fudforum.svn.sourceforge.net/fudforum/?rev=5194&view=rev
for PostgreSQL support and some other fixes.
The problem with salt in the users table was solved (I hope).
The '~' in the smiley codes are valid. FUDforum uses a '~' as separator between codes.
Can you please post more details about the 'alias' problem? I would be able to solve it if I can somehow reproduce the problem.
Thanks for helping us to resolve these issues!
|
|
| Re: FUDforum Migration Assistant |
Thu, 17 March 2011 11:23 |
|
|
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 .
|
|
| Re: FUDforum Migration Assistant |
Thu, 17 March 2011 09:54 |
|
|
|
Heh, I just check out trunk, and see the work so far. I'll give that a run. I was working reeeally tired when I tried... not conducive to fixing bugs in a mod you did .
|
|
|
|
| Re: FUDforum Migration Assistant |
Thu, 17 March 2011 06:01 |
|
|
I'll add PostgreSQL support and commit it later today or tomorrow.
From what forum are you converting?
|
|
| Re: FUDforum Migration Assistant |
Thu, 17 March 2011 03:42 |
|
|
Was wondering if there was any progress on having some postgres support with the assistant?
I would really rather not dump my forum db then the PITA task of converting to mysql, then adding it to a mysql install, just so it would work.
I tried hacking on it very cursorily earlier, and failed . I may try again soon-ish, then submit patches if i get a working one.
|
|
| FUDforum Migration Assistant |
Wed, 02 March 2011 05:34 |
|
|
We've reworked the FUDforum converter script. Please let us know if you can help us to test conversion from any of the below forums to FUDforum:
* Advanced Electron
* bbPress
* Drupal7 forum
* FluxBB
* IceBB
* MyBB
* Phorum
* phpBB3
* phpBB2
* PunBB
* Quicksilver Forums (QSF)
* Simple Machines (SMF)
* TairoBB
* UBB.threads
* Unclassified NewsBoard (UNB)
* Vanilla2
* XMB
The new converter can be downloaded from
https://sourceforge.net/projects/fudforum/files/ (MigrationAssistant.zip).
Note that we are not interested in converting old forums (not as part of this initiative anyway). These converters will only migrate the latest versions of these forum systems to FUDforum.
Any others we should add?
Best regards.
Frank
|
|
Calendar
Search
Help
Members
Control Panel
Logout [ CommonCrawl [Bot] ]
Home