FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » How To » Testing maillist.php to import mailing list message into forum
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
Testing maillist.php to import mailing list message into forum [message #34648] Sat, 11 November 2006 20:46 Go to previous message
Injaki is currently offline  Injaki   Spain
Messages: 3
Registered: November 2006
Location: Madrid (Spain)
Karma:
Junior Member
Hello,

I'm setting up a FUDforum system with Mailman mailing list integration.
On my way to understand why the mailing list messages are not being imported as expected, I've reach the phase to test the maillist.php script, so I did:

cat message |/home/retroacc/FUDforum/scripts/maillist.php 1

(also as cat message |php -q /home/retroacc/FUDforum/scripts/maillist.php 1)

and everything I obtain is the following output:

Quote:

Warning: preg_replace() [function.preg-replace]: Compilation failed: range out of order in character class at offset 13 in /home/retroacc/FUDforum/scripts/maillist.php on line 292
(/home/retroacc/FUDforum/include/theme/default/db.inc:73
/home/retroacc/FUDforum/include/theme/default/db.inc:177
/home/retroacc/FUDforum/include/theme/default/imsg_edt.inc:113
/home/retroacc/FUDforum/scripts/maillist.php:496
) 1048: Column 'subject' cannot be null
Query: INSERT INTO fud26_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, 6, 0, '62.151.11.163', NULL, 1163273129, NULL, 0, 0, NULL, 3, 20000, 7048, 23, 0, 0, 0, '455623A9(dot)6060508(at)ya(dot)com', NULL, NULL, NULL )
_GET: array ( 1 => '', )
Server Version: 4.1.21-standard-log



The subject line of the message is never NULL, so I'm not sure why the script complains about that.

Any suggestion about what to look for next?

Thank you very much


Injaki

----------------------------------

PS: just in case it is important, this is the email message I'm using in the test (real email addresess stripped out)

Quote:

From sender(at)home(dot)com Sat Nov 11 12:25:33 2006
Return-path: <sender(at)home(dot)com>
Envelope-to: dest(at)lists(dot)domain(dot)org
Delivery-date: Sat, 11 Nov 2006 12:25:33 -0700
Received: from smtp06.ya.com ([62.151.11.163] helo=smtpauth.ya.com)
by box187.bluehost.com with esmtp (Exim 4.52)
id 1GiyTt-0006q9-4f
for dest(at)lists(dot)domain(dot)org; Sat, 11 Nov 2006 12:25:33 -0700
Received: from [84.76.84.120] (helo=[192.168.1.2])
by smtpauth.ya.com with asmtp id 1GiyTq-0002xO-00
for dest(at)lists(dot)domain(dot)org; Sat, 11 Nov 2006 20:25:30 +0100
Message-ID: <455623A9(dot)6060508(at)home(dot)com>
Date: Sat, 11 Nov 2006 20:25:29 +0100
From: sender(at)home(dot)com <sender(at)home(dot)com>
User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317)
X-Accept-Language: es-es, es
MIME-Version: 1.0
To: dest(at)lists(dot)domain(dot)org
Subject: just testing
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

test body





[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: How can I register Users Automatically from my other php applications?
Next Topic: Don't want maillist.php to create new users
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 22 10:41:32 GMT 2024

Total time taken to generate the page: 0.13677 seconds