That's what my posts looked like before I applied Kevin's hack. Double check your gateway.php file and make sure you followed the directions exactly. Also, run gateway.php manually, copy and paste what the screen log shows, and post it here.

Some of the information in mlist is very valuable; however, if you or a member does something wrong you can be removed/banned. I would like the option to prevent posting to mlist for this very reason. A forum member will always be able to post to the forum - it just won't be sent to the public mlist.

ARCHIVE - for information only; some of the content found in newsgroup/mlist can answer posted questions on forum (similar threads)

If you still can't get it working, post the 10 lines from gateway.php just before this mini-hack and I'll have a look.

From your screenshot, that is exactly the problem that this mini-hack fixes. It picks these up by their subject title and threads correctly where the reference in the email header is missing.

Like BustaCap say, check the installation in gateway.php, and if you still have problems post the output here.

I got it working ... thank you. :up:

Kevin,
I never get this error when I call the file directly. However, I do occasionally get this error when Schedule Task runs the file.
[sql]Invalid SQL: INSERT INTO post
(postid, threadid, title, username, userid, dateline,
pagetext, allowsmilie, showsignature, ipaddress,

iconid, visible, isusenetpost, msgid, ref, parentid)
VALUES (NULL, ,
'',
'', 0,
'',
'', 1, 0,
'', 0, 1, 1,
'',
'',
+ 0)
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '
'',
'', 0,
'',
'', 1, 0,
'', 0, 1, 1[/sql]
(I direct this to you (kevin) because it only happens when I use your mini hack.)

Kevin

Today it was working and I have not changed the gateway.php file.

Output from running from inside AdminCP

I set this up as a scheduled task in the AdminCP to run every 15 minutes but it seems to have no effect, I have to push it manually to run. If I tried to run it directly from the browser I got an error that it was already running so I have set the check in AdminCP to 1 now.

However it seems the ones before failed to match (title '2004 simulator ops') see attachment

It looks to be working correctly. The thread that you mention looks like a duplicate post (it has no "Re: " in the title), so the correct action is to start a new thread.

It will only search for a match by subject title under the following circumstances:

1. There are no references in the header that match an exisiting thread

AND

2. There is at least one "Re: " in the subject title, which gives an indication that there should be a parent thread for this post.

The output from gateway.php which you have shown also indicates that it is working correctly.

It's hard to tell from the sql query what is causing it to fail. If it ever happens when you are running gateway manually, make a copy & post the output which was running at the time.

Are you running the 'threading by subject' hack? There was an error in my first release which caused the $parentid not to generate, which would produce a error like the one you have. It was corrected with this version shortly afterwards:https://vborg.vbsupport.ru/showpost....&postcount=181

Kevin

Could it be that some users have just removed the subject prefix (or their mail clients have not added one?) . I have not used any other mail clients except Eudora or Outlook and these both addd it.

So in order for the threading function to be initiated it checks the first chars of the subject feild for matches on 'RE' ? Then parses an subject index for a match?

Guess its not case sensitive?

BTW, thanks for this really cool mod :)