|
|
|
|
|
|
|
|
|
|
|
|
|
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
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
|
|
|
|
|
|
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
Weird thing though, the import process seems to have locked all posts that didn't have a reply
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
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
So, there's some issues yet
[Updated on: Sun, 16 May 2010 17:49] 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!
|
|
|