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
|