Email stopped working after running upgrade to 2.7.7 [message #40246] |
Mon, 28 January 2008 19:14  |
BAD35th
 Messages: 61 Registered: February 2007 Location: Hammertown
Karma: 0
|
Member |
|
|
Ok ran update script from 2.6.10RC3 to 2.7.7, everything seemed to run fine and completed.
Now however after a few days I have noticed email that used to feed into the forum when it was 2.6.10RC3 has stopped working. I have 2 forums where I use the email mailing list feature to send out copies of posts as email to an email distribution list. However since the upgrade: Mail is going out from the forums ok, but not coming back into the forums or being sorted into the threads...it just doesn't show up at all ??
Even though replies don't get inserted back into the forum, they do get redistributed back to the email distribution list as email and I receive those just fine.
The Mailing List rules are still intact and seem to be correct, everything else in globals.php also seems to be exactly the same.
The email acct. that is listed for forum to use is still exactly the same.
I checked the domain and MX records and they are fine.
Forgot to mention after the upgrade I get mail show up from just one user who posts in the forum as originating from G(at)prohost(dot)org?? This is not his email (see headers attached)
Any ideas what to check??
[Updated on: Mon, 28 January 2008 19:29] Report message to a moderator
|
|
|
|
|
|
|
Re: Email stopped working after running upgrade to 2.7.7 [message #40257 is a reply to message #40256] |
Wed, 30 January 2008 03:39   |
BAD35th
 Messages: 61 Registered: February 2007 Location: Hammertown
Karma: 0
|
Member |
|
|
I don't have access to the hosted areas where php is ie usr/lib/php.ini etc. I can only browse the forum files using the builtin in File Manager.
Under the errors directory I only see 2 files and no ini file.
The 2 files are the SQLErrorLOg and PHPErrorLog.
If I try to view the files using the forums Error Log Viewer I only see this under SQL:
Time Error Description
Thu Jan 1 0:00:00 GMT 1970
(System date looks wrong)
If I download the SQLError Log I see the error listed below which may be relevant. Note: I don't believe I have any command line access to the SQL Tables in use as it is hosted with you at your site ProForum.
What is next step ??
/home/c_pippy/forum_data/include/theme/default/db.inc:176<br />
/home/c_pippy/forum_data/include/mlist.inc:76<br />
/home/c_pippy/www/docs/adm/admmlist.php:40<br />
) 1064: 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 '
'',
73,
'',
'',
'',
'',
'',
''
)' at<br />
Query: INSERT INTO fud26_mlist(
forum_id,
name,
mlist_opt,
subject_regex_haystack,
subject_regex_needle,
body_regex_haystack,
body_regex_needle,
additional_headers,
custom_sig
)
VALUES(
,
'',
73,
'',
'',
'',
'',
'',
''
)<br />
_POST: array (
'SQ' => '4abb8badbbbef82ba1f97e223748e6f8',
'ml_name' => '',
'ml_forum_id' => '',
'ml_mlist_post_apr' => '1',
'ml_allow_frm_post' => '0',
'ml_frm_post_apr' => '0',
'ml_allow_mlist_attch' => '8',
'ml_allow_mlist_html' => '0',
'ml_complex_reply_match' => '0',
'ml_create_users' => '64',
'ml_skip_non_forum_users' => '0',
'ml_subject_regex_haystack' => '',
'ml_subject_regex_haystack_opt' => '',
'ml_subject_regex_needle' => '',
'ml_body_regex_haystack' => '',
'ml_body_regex_haystack_opt' => '',
'ml_body_regex_needle' => '',
'ml_additional_headers' => '',
'ml_custom_sig' => '',
'ml_submit' => 'Add Mailing List Rule',
'edit' =>
|
|
|
|
|
|
Re: Email stopped working after running upgrade to 2.7.7 [message #40701 is a reply to message #40269] |
Sun, 06 April 2008 15:46   |
srchild
 Messages: 88 Registered: December 2003 Location: UK
Karma: 1
|
Member |
|
|
I have the same problem. Any solution?
I just upgraded from 2.6.9 to 2.7.7
2.6.9 forum was running well for over two years, synchronising three mailing lists and three forums in both directions.
Now, as described above, a post to the forum is sent out to the lists, but a post to the lists does not appear in the forums.
I haven't changed my procmail or list setup, the script path is unchanged and exactly as appears in the control panel for the list, and I have confirmed from my procmail logs that the messages are getting passed to maillist.php
I have checked the shebang in maillist.php, and in fact have tried both php4 and php5 (both binaries are available to me), doesn't work with either.
php.ini shows:
log_errors Off ; Log errors into a log file
I have read-only access to php.ini, I can't edit it to enable logging.
The FUDforum and SQL error logs are empty (did the upgrade clear them?).
Suggestions please - this forum is quiet on Sunday but the mailing lists get busier on Monday morning!
Thanks.
Simon Child
[Updated on: Sun, 06 April 2008 16:28] Report message to a moderator
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|