FUDforum: Converters » IPB 1.3.1 Conversion not working

Home » FUDforum Development » Converters » IPB 1.3.1 Conversion not working

Show: Today's Messages :: Polls :: Message Navigator

IPB 1.3.1 Conversion not working [message #162407]

Wed, 05 May 2010 23:40

mmiller

Messages: 27
Registered: May 2010

Karma: 0

Junior Member

Hi Folks;

I've been running IPB 1.3.1 for about 5 years now and it's lack or support for NNTP really bugs me and so, I started evaluating FUD.

As part of that process I thought I would try importing my existing 1.3.1 users/posts etc. But, the script died as soon as it hit my swear table. No problem, I emptied that table and re-ran the script.

It reported no issues but didn't seem to go past members. Would it take a lot of effort to change the script around to support my 1.3.1 ? I'm just evaluating the software right now, no promises - yet! Razz

Razz

Report message to a moderator

Re: IPB 1.3.1 Conversion not working [message #162411 is a reply to message #162407]

Thu, 06 May 2010 05:28

naudefj

Messages: 3771
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

Yes, that script is somewhat dated. However, it should be quite easy to fix up. If you can provide me with a dump of your forum, I may even be able to help.

Report message to a moderator

Re: IPB 1.3.1 Conversion not working [message #162413 is a reply to message #162407]

Thu, 06 May 2010 05:38

mmiller

Messages: 27
Registered: May 2010

Karma: 0

Junior Member

Thanks Frank - I sent you an email with a link to the forum dB. I sure appreciate your help while I get accustomed to a new forum - it's pretty slick!

Btw, any time I try to do a quick reply I get bounced to the normal reply screen. I'm now copying my posts before continuing just in case Embarassed

Embarassed

Report message to a moderator

Re: IPB 1.3.1 Conversion not working [message #162424 is a reply to message #162407]

Sat, 08 May 2010 02:54

mmiller

Messages: 27
Registered: May 2010

Karma: 0

Junior Member

Hi Frank;

Were you able to do anything with the file?

Report message to a moderator

Re: IPB 1.3.1 Conversion not working [message #162425 is a reply to message #162424]

Sat, 08 May 2010 03:09

naudefj

Messages: 3771
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

mmiller wrote:

Were you able to do anything with the file?

No, I haven't received it. Can you please send it again?

Kwoteer:

Btw, any time I try to do a quick reply I get bounced to the normal reply screen. I'm now copying my posts before continuing just in case

Strange, are you pressing the right "Post Quick Reply" button?

Report message to a moderator

Re: IPB 1.3.1 Conversion not working [message #162427 is a reply to message #162425]

Sat, 08 May 2010 03:42

mmiller

Messages: 27
Registered: May 2010

Karma: 0

Junior Member

Hahaha...that might be it....I may well have been hitting the wrong button :-0

BTW, I sent you an email (to your gmail account) with a link to the forum dB.
Just in case it doesn't go through I'll send you a personal message with the link to.

Thanks!
Marvin

Report message to a moderator

Re: IPB 1.3.1 Conversion not working [message #162438 is a reply to message #162427]

Mon, 10 May 2010 18:07

naudefj

Messages: 3771
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

I've managed to import your forum. However, it's too large for simple testing purposes, just hope I don't have to do it again. Unless you have a smaller one we can use. Smile

Smile

Anyway, a slightly improved version is now available for download. Please test and let us know if you encounter any problems.

Report message to a moderator

Re: IPB 1.3.1 Conversion not working [message #162439 is a reply to message #162438]

Mon, 10 May 2010 19:48

mmiller

Messages: 27
Registered: May 2010

Karma: 0

Junior Member

Hi Frank;

Thanks very much - I'm sorry it amounted to a bit of work Sad

Sad

I'm eager to test it - is is the same one that's linked off of the documentation?

Report message to a moderator

Re: IPB 1.3.1 Conversion not working [message #162440 is a reply to message #162439]

Tue, 11 May 2010 05:45

naudefj

Messages: 3771
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

Yes.

Converter - http://sourceforge.net/apps/trac/fudforum/changeset/4954#file0
README - http://sourceforge.net/apps/trac/fudforum/changeset/4954#file3

Run the script from the command like to prevent any browser time-out issues.

Report message to a moderator

Re: IPB 1.3.1 Conversion not working [message #162441 is a reply to message #162407]

Tue, 11 May 2010 07:32

mmiller

Messages: 27
Registered: May 2010

Karma: 0

Junior Member

Odd.... if I run it from a browser I get this immediately;

Fatal error: Maximum execution time of -1 seconds exceeded in C:\Inetpub\fudforum\include\theme\default\db.inc on line 13

If I run it from the command line after a few seconds it just drops back to the cursor.

Am I doing something wrong?

Report message to a moderator

Re: IPB 1.3.1 Conversion not working [message #162444 is a reply to message #162441]

Tue, 11 May 2010 18:51

naudefj

Messages: 3771
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

The set_time_limit(-1) function is commonly used all over the code. However, it should be changed to set_time_limit(0) for infinite timeout.

Report message to a moderator

Re: IPB 1.3.1 Conversion not working [message #162458 is a reply to message #162444]

Fri, 14 May 2010 20:46

naudefj

Messages: 3771
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

Are you making progress? Let us know if there is anything we can help with.

Report message to a moderator

Re: IPB 1.3.1 Conversion not working [message #162462 is a reply to message #162458]

Sat, 15 May 2010 03:21

mmiller

Messages: 27
Registered: May 2010

Karma: 0

Junior Member

Hi Frank!

That last fix got it working but it stalls right away on the swear filter list;

Importing blocked words
(C:\Inetpub\fudforum\include\theme\default\db.inc:72
C:\Inetpub\fudforum\ipb.php:104
) 1366: Incorrect string value: '\xE4/' for column 'replace_str' at row 1
Query: INSERT INTO fud30_replace (replace_str, with_str) VALUES('/kyrpä/', 'beep')
Server Version: 5.1.42-community

Any ideas?

Report message to a moderator

Re: IPB 1.3.1 Conversion not working [message #162465 is a reply to message #162462]

Sat, 15 May 2010 19:32

mmiller

Messages: 27
Registered: May 2010

Karma: 0

Junior Member

OK, I needed to change one entry in the swear filter (a letter with a hat on it Smile

Smile

I also needed to change fud30_users so that the interests column was TEXT and not VARCHAR(255)

That got me WAY further along but there's a new issue with respect to IP addresses that I don't know how to address (perhaps a code change?)

Importing messages and topics
(C:\Inetpub\fudforum\include\theme\default\db.inc:72
C:\Inetpub\fudforum\include\theme\default\db.inc:176
C:\Inetpub\fudforum\include\theme\default\imsg_edt.inc:112
C:\Inetpub\fudforum\ipb.php:507
) 1406: Data too long for column 'ip_addr' at row 1
Query: INSERT INTO fud30_msg ( thread_id, poster_id, reply_to, ip_addr, host_name, post_stamp, subject, attach_cnt, poll_id, icon, msg_opt, file_id, foff, length, file_id_preview, offset_preview, length_preview, mlist_msg_id, poll_cache, flag_cc, flag_country ) VALUES( 0, 20690, 0, '24.83.208.28, 10', NULL, 1055722377, 'Isp Problem', 0, 0, NULL, 1, 160000, 202904, 535, 0, 0, 0, NULL, NULL, NULL, NULL )
Server Version: 5.1.42-community

It looks (to me) like the IP address code is not formatted properly. The ip_address table is OK (15 characters) but in the above I think it fails because of the formatting '24.83.208.28, 10' (that's 17 characters)

Any ideas? I'm getting a LOT closer Smile

Smile

Report message to a moderator

Re: IPB 1.3.1 Conversion not working [message #162466 is a reply to message #162465]

Sat, 15 May 2010 20:41

mmiller

Messages: 27
Registered: May 2010

Karma: 0

Junior Member

Nevermind, the reason seems to be that my forum dB really did have an IP address entry of 24.83.208.28, 10

Don't ask me how that happened but as soon as I changed it to 24.83.208.28 the script rolled on.... Embarassed

Embarassed

Report message to a moderator

Re: IPB 1.3.1 Conversion not working [message #162467 is a reply to message #162440]

Sat, 15 May 2010 23:20

mmiller

Messages: 27
Registered: May 2010

Karma: 0

Junior Member

Hi Frank!

After slightly massaging the data from my source forum I'm proud to say that I got the script to run and complete. There are only two things that concern me (maybe they are related?).

When I ran the script I got this error;

Importing messages and topics

Warning: strpos() [function.strpos]: Offset not contained in string in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 443

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111

Notice: Uninitialized string offset: 58970 in C:\Inetpub\fudforum\include\theme\default\post_proc.inc on line 111
Done: Importing 35148 messages and 7182 topics
Importing polls
Done: Importing 12 polls
Importing private messages
Done: Importing 25541 private messages
Importing miscellaneous settings
Done: Importing miscellaneous settings
Conversion Process Complete!

======================================================

I don't know if it means anything but here's the situation I'm seeing. When I go to my forum I can see the different forums but not any of the posts! The same thing occurs if I click on a member to view the posts they've made.

So, it seems we're very close! I did run the consistency check and optimization.

Other then that, the only error I got from the script (that was not tracked back to an issue with my source dB) was that the column interests in the fud_30 users table needed to be changed from VARCHAR to TEXT because some of the users interests were more then 255 characters Smile

Smile

At any rate, if you have an idea as to why the posts aren't showing up I'd love to hear it.

Best & Thanks!
Marvin

Report message to a moderator

Re: IPB 1.3.1 Conversion not working [message #162468 is a reply to message #162467]

Sun, 16 May 2010 08:13

naudefj

Messages: 3771
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

Strange, I've converter your forum and could see all the posts after the consistency check. If your forum is on net Net, I can login and have a look.

PS: You can ignore the warning and notice messages.

Report message to a moderator

Re: IPB 1.3.1 Conversion not working [message #162472 is a reply to message #162468]

Sun, 16 May 2010 17:44

mmiller

Messages: 27
Registered: May 2010

Karma: 0

Junior Member

Interesting....

I looked into it further and it seems my personal forum account had something wrong with it with respect to viewing the posts. I forgot what I changed but it had something to do with how many posts were displayed per page and then they appeared Smile

Smile

Weird thing though, the import process seems to have locked all posts that didn't have a reply Shocked

Shocked

Also, if I register as a new user I don't have posting permissions in any of the forums. That's not a big deal though.

I did find another issue though, imported posts with pictures no longer show up in the post. They seem to be treated as attachments?

Is there any way to get them to show up as they originally did - inside the posts?

My apologies for all the questions - I'm still trying to ascertain whether it's going to be wise to make the change or whether it will amount to an enormous amount of work. I know you've already done a lot of work just on the script Razz

Razz

Anyway, let me know what your thoughts are on the locked posts and the in-line images, and, as always, thanks very much for your efforts!

Oh, before I forget, the calendar was not imported (or the birthdays?) so the calendar is empty. Closer inspection shows that the birthdays were imported but they weren't applied to the calendar? Also, if I try to edit a post the contents are empty Razz

Razz

So, there's some issues yet Shocked

Shocked

[Updated on: Sun, 16 May 2010 17:49]

Report message to a moderator

Re: IPB 1.3.1 Conversion not working [message #162473 is a reply to message #162472]

Sun, 16 May 2010 18:24

naudefj

Messages: 3771
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

I'll gladly look at it, but I need a smaller test case. I'm definitely not going to reimport your existing form. Would you be able to prepare a smaller test forum with a couple of posts to illustrate the problem?

Report message to a moderator

Re: IPB 1.3.1 Conversion not working [message #162474 is a reply to message #162473]

Sun, 16 May 2010 19:26

mmiller

Messages: 27
Registered: May 2010

Karma: 0

Junior Member

Hi Frank;

Let's give it a rest for a bit - I'm finding that my unfamiliarity with the software is also causing some issues Embarassed

Embarassed

For instance, I now realize that the import did import the user's birthdays but that the reason they are not showing on the calendar is because the software doesn't support it (not a big deal - I just didn't know that).

With respect to the pictures not showing up in the posts - I think that too is caused by the fact that my version of IPB would automatically insert the picture if someone attached a gif, jpg or what have you.

When someone used a remote URL for the picture it does show up in the imported post. When they attached a picture it shows up as an attachment - that's correct but my current forum shows them as pictures.

So, there are some things that aren't right (from the import process) but there are also a lot of things that are different, or, that I had not taken into account. That's why I'm thinking that conversion might take considerable time to shape things up.

Anyway, let's let it rest for a bit and when I'm more familiar with the forum and can more accurately ascertain what aspects didn't work properly during import, then I can report them back Razz

Razz

Otherwise, I might send you on a wild goose chase Shocked

Shocked

Report message to a moderator

Re: IPB 1.3.1 Conversion not working [message #162480 is a reply to message #162474]

Tue, 18 May 2010 06:21

naudefj

Messages: 3771
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

Yes, conversions can be hairy. Anyway, just take note of the following:

Kwoteer:

I now realize that the import did import the user's birthdays but that the reason they are not showing on the calendar is because the software doesn't support it

Birthdays will be in the next release. I've already written the code and will probably commit it later this week.

Kwoteer:

With respect to the pictures not showing up in the posts - I think that too is caused by the fact that my version of IPB would automatically insert the picture if someone attached a gif, jpg or what have you.

With FUDforum you can have both. A simple converter fix will solve the problem. I just need a (small) test case to work on it.

Best regards.

Frank

Report message to a moderator

Re: IPB 1.3.1 Conversion not working [message #162505 is a reply to message #162480]

Tue, 25 May 2010 20:29

mmiller

Messages: 27
Registered: May 2010

Karma: 0

Junior Member

Hi Frank;

I haven't forgotten about your kind offer and I am still interested in completing the conversion but I've been side-tracked onto some important stuff that can't be put off any longer. Time is so short!

Report message to a moderator

Previous Topic:	Problems converting modified WWWboard to FUD
Next Topic:	Converting IPB 1.1.2 to FudForum Latest Version

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 21:17:58 GMT 2024

Total time taken to generate the page: 0.16422 seconds