Messages posted by: jdev1

Hi!
I have a problem at forums list and topics list.
If new message added forum and topic marks as "New Messages" only if user is online. If user is offline, after log in no forum or topic is marked as "New Messages" even if new posts have been added to them.
How can i solve that problem? Maybe some setting at config list?
Thank you!

Yes i talk to my admin first and he told me everything good with mail server, no errors at server logs. Also another apps doesn't have same problems with that mail server. That's why i asked you.

I think this is it (tomcat-stdout):

DEBUG: Jakarta Mail version 2.0.0
DEBUG: successfully loaded resource: /META-INF/javamail.default.providers
DEBUG: Tables of loaded providers
DEBUG: Providers Listed By Class Name: {com.sun.mail.smtp.SMTPTransport=jakarta.mail.Provider[TRANSPORT,smtp,com.sun.mail.smtp.SMTPTransport,Oracle], com.sun.mail.imap.IMAPSSLStore=jakarta.mail.Provider[STORE,imaps,com.sun.mail.imap.IMAPSSLStore,Oracle], com.sun.mail.pop3.POP3Store=jakarta.mail.Provider[STORE,pop3,com.sun.mail.pop3.POP3Store,Oracle], com.sun.mail.smtp.SMTPSSLTransport=jakarta.mail.Provider[TRANSPORT,smtps,com.sun.mail.smtp.SMTPSSLTransport,Oracle], com.sun.mail.imap.IMAPStore=jakarta.mail.Provider[STORE,imap,com.sun.mail.imap.IMAPStore,Oracle], com.sun.mail.pop3.POP3SSLStore=jakarta.mail.Provider[STORE,pop3s,com.sun.mail.pop3.POP3SSLStore,Oracle]}
DEBUG: Providers Listed By Protocol: {imap=jakarta.mail.Provider[STORE,imap,com.sun.mail.imap.IMAPStore,Oracle], smtp=jakarta.mail.Provider[TRANSPORT,smtp,com.sun.mail.smtp.SMTPTransport,Oracle], pop3=jakarta.mail.Provider[STORE,pop3,com.sun.mail.pop3.POP3Store,Oracle], imaps=jakarta.mail.Provider[STORE,imaps,com.sun.mail.imap.IMAPSSLStore,Oracle], smtps=jakarta.mail.Provider[TRANSPORT,smtps,com.sun.mail.smtp.SMTPSSLTransport,Oracle], pop3s=jakarta.mail.Provider[STORE,pop3s,com.sun.mail.pop3.POP3SSLStore,Oracle]}
DEBUG: successfully loaded resource: /META-INF/javamail.default.address.map
DEBUG: getProvider() returning jakarta.mail.Provider[TRANSPORT,smtp,com.sun.mail.smtp.SMTPTransport,Oracle]
DEBUG SMTP: useEhlo true, useAuth true
DEBUG SMTP: trying to connect to host "172.28.200.26", port 25, isSSL false
DEBUG SMTP: exception reading response, THROW:
java.net.SocketException: Connection reset
at java.net.SocketInputStream.read(Unknown Source)
at java.net.SocketInputStream.read(Unknown Source)
at com.sun.mail.util.TraceInputStream.read(TraceInputStream.java:102)
at java.io.BufferedInputStream.fill(Unknown Source)
at java.io.BufferedInputStream.read(Unknown Source)
at com.sun.mail.util.LineInputStream.readLine(LineInputStream.java:100)
at com.sun.mail.smtp.SMTPTransport.readServerResponse(SMTPTransport.java:2456)
at com.sun.mail.smtp.SMTPTransport.openServer(SMTPTransport.java:2172)
at com.sun.mail.smtp.SMTPTransport.protocolConnect(SMTPTransport.java:722)
at jakarta.mail.Service.connect(Service.java:342)
at jakarta.mail.Service.connect(Service.java:222)
at net.jforum.util.mail.Spammer.dispatchMessages(Spammer.java:208)
at net.jforum.view.forum.AjaxAction.sendTestMail(AjaxAction.java:148)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at net.jforum.Command.process(Command.java:122)
at net.jforum.JForum.processCommand(JForum.java:269)
at net.jforum.JForum.service(JForum.java:251)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at net.jforum.csrf.CsrfFilter.doFilter(CsrfFilter.java:104)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at net.jforum.util.legacy.clickstream.ClickstreamFilter.doFilter(ClickstreamFilter.java:59)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:563)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:291)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:610)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:503)
at java.lang.Thread.run(Unknown Source)

I've got this message at jforum.log

2023-03-21 15:27:33,374 ERROR [AjaxAction] - net.jforum.exceptions.MailException: jakarta.mail.MessagingException: Exception reading response;
nested exception is:
java.net.SocketException: Connection reset
net.jforum.exceptions.MailException: jakarta.mail.MessagingException: Exception reading response;
nested exception is:
java.net.SocketException: Connection reset
at com.sun.mail.smtp.SMTPTransport.readServerResponse(SMTPTransport.java:2476)
at com.sun.mail.smtp.SMTPTransport.ehlo(SMTPTransport.java:1684)
at com.sun.mail.smtp.SMTPTransport.protocolConnect(SMTPTransport.java:726)
at jakarta.mail.Service.connect(Service.java:342)
at jakarta.mail.Service.connect(Service.java:222)
at net.jforum.util.mail.Spammer.dispatchMessages(Spammer.java:208)
at net.jforum.view.forum.AjaxAction.sendTestMail(AjaxAction.java:148)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at net.jforum.Command.process(Command.java:122)
at net.jforum.JForum.processCommand(JForum.java:269)
at net.jforum.JForum.service(JForum.java:251)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at net.jforum.csrf.CsrfFilter.doFilter(CsrfFilter.java:104)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at net.jforum.util.legacy.clickstream.ClickstreamFilter.doFilter(ClickstreamFilter.java:59)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:563)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:291)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:610)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:503)
at java.lang.Thread.run(Unknown Source)
Caused by: jakarta.mail.MessagingException: Exception reading response;
nested exception is:
java.net.SocketException: Connection reset
... 34 more
Caused by: java.net.SocketException: Connection reset
at java.net.SocketInputStream.read(Unknown Source)
at java.net.SocketInputStream.read(Unknown Source)
at com.sun.mail.util.TraceInputStream.read(TraceInputStream.java:102)
at java.io.BufferedInputStream.fill(Unknown Source)
at java.io.BufferedInputStream.read(Unknown Source)
at com.sun.mail.util.LineInputStream.readLine(LineInputStream.java:100)
at com.sun.mail.smtp.SMTPTransport.readServerResponse(SMTPTransport.java:2456)
... 33 more

Hi! I have one more question.
Users complain that they do not receive notifications about new responses. In the admin panel, I send a test email and get an error like in the screenshot. After that, I send the test email again and it is sent perfectly, and notifications begin to arrive to users. And after about 1-2 hours, everything repeats. What could be the matter?

Looks like that works fine. Thank you!

Ok, i'm waiting, thanks for helping

Can I ask you please to compile a jar file with one change in Spammer.class for me, if it's not difficult.

Instead of
if (this.messageFormat == 0) {
this.message.setContent(text.replaceAll("\n", " "), "text/html; charset=" + charset);
} else {
this.message.setText(text);
}

this:

if (this.messageFormat == 0) {
this.message.setContent(text, "text/html; charset=utf-8");
} else {
this.message.setText(text);
}

If it helps in my situation I will be very grateful. Thank you.

I've also seen redefinition messageFormat at Spammer.class

private void defineUserMessage(User user) {
try {
this.templateParams.put("user", user);
String text = this.processTemplate();
int oldMessageFormat = this.messageFormat;
if (user.notifyText()) {
this.messageFormat = 0;
}

this.defineMessageText(text);
this.messageFormat = oldMessageFormat;
} catch (Exception var4) {
throw new MailException(var4);
}
}

What is the function user.notifyText()? Is it related with "Allow HTML" you wrote about earlier or something else?

Nope, now i testing with two users and they two have "Allow HTML" turned on.
Also if i change mail.messageFormat to text and change message template by removing html tags from it message comes with replaced line breaks with the tag.
I seems strange. I saw replasment at Spammer.class line 245

if (this.messageFormat == 0) {
this.message.setContent(text.replaceAll("\n", " "), "text/html; charset=" + charset);
} else {
this.message.setText(text);
}

Maybe some problem with that?
Also i wanted to ask you how gets config values? From table JFORUM_CONFIG or from file?

Hi!
I found funny thing with response emails.

If only one user watches for topic everything is good, he's got good response email with content-type in headers:

Delivered-To: kvm8522@gmail.com
Received: by 2002:a50:3410:0:b0:1fc:2de0:6395 with SMTP id cq16csp3305035ecb;
Mon, 13 Feb 2023 04:13:58 -0800 (PST)
X-Google-Smtp-Source: AK7set85g1kpm5hL7Txm0VbG8HvALwq3aKGCPneIg+hrdGxps3L5sStqdtnSC5wAJQohSTMXLADz
X-Received: by 2002:a5d:4b85:0:b0:2c5:60e2:ed6d with SMTP id b5-20020a5d4b85000000b002c560e2ed6dmr120192wrt.3.1676290438053;
Mon, 13 Feb 2023 04:13:58 -0800 (PST)
ARC-Seal: i=1; a=rsa-sha256; t=1676290438; cv=none;
d=google.com; s=arc-20160816;
b=qFzFP1MAlget1/UCOszVHQIoqPbL4srknZSSYSEAXuFuPl4FRt+qzhZmgecRNZYCVr
VVPIU6LEFXjWQXpcRL60a+m3naqEUdT6NR+LB02CZLhnuTQqNRfHfrQlONp5PxnRSUv4
lMkqSqDGc6VYmhm6XMXnkiMFPSShaD79dixrjThQdKb5Z89i9Laqs8BSbzkYdy2sl5MK
PlTfMc8TAWXmV2sTlZ/jvLBusiW36JzDGrj6NdiKeoQevxIe5208q5pd4v1QO/lVH5W1
8fFPXA7kC0cEyOl0o0ksQ3NJDKLBc/leo6MRk9fRbbewjhLhTfJVvaO0KrpHWUqUqtdM
04lA==
ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20160816;
h=content-transfer-encoding:mime-version:subject:in-reply-to
:message-id:to:from:date:dkim-signature;
bh=hKibKfisjUei6Cjf/8RlNVikIjCSDsHWqiu/YE2VMgI=;
b=VTdHzVHaht94WUBZ+gEkuIU3HAewWknrYN30vVZBTYRU52+jHhPu/zTcJTxM5Hwfyp
7CkSL/8gGOddQrs19YCO7qzBjGfoy5iAhLq7hitCa0JdW4REGTyUXJQwxIC8BnQDLqI/
Dte63y1g2Fvdd+7pEr/YEk0VQcgHWQY9Am1GoMvVZxHSTuqq5tlcDajH6tqLS7snnFVa
bsMoXHf6WR7waMEs9vJ3lcw5eTfbh8qPQu7bgepyBtDJ3EAeaFQtEEH/EU/9CABbDrIm
sO8KO5xWXHlOWhW3hXSJEo0uzZBHZpLFAabW5SavEMkHLB99GNM3jEtgwrS+zBgUIelJ
GbOA==
ARC-Authentication-Results: i=1; mx.google.com;
dkim=pass header.i=@parus.ru header.s=mail header.b=BYfRxBh8;
spf=pass (google.com: domain of webadmin@parus.ru designates 2a02:6b8:0:1472:2741:0:8b7:109 as permitted sender) smtp.mailfrom=webadmin@parus.ru
Return-Path:
Received: from forward106p.mail.yandex.net (forward106p.mail.yandex.net. [2a02:6b8:0:1472:2741:0:8b7:109])
by mx.google.com with ESMTPS id t8-20020a5d5348000000b002c552b78437si4440576wrv.489.2023.02.13.04.13.57
for
(version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/12 smilie

;
Mon, 13 Feb 2023 04:13:57 -0800 (PST)
Received-SPF: pass (google.com: domain of webadmin@parus.ru designates 2a02:6b8:0:1472:2741:0:8b7:109 as permitted sender) client-ip=2a02:6b8:0:1472:2741:0:8b7:109;
Authentication-Results: mx.google.com;
dkim=pass header.i=@parus.ru header.s=mail header.b=BYfRxBh8;
spf=pass (google.com: domain of webadmin@parus.ru designates 2a02:6b8:0:1472:2741:0:8b7:109 as permitted sender) smtp.mailfrom=webadmin@parus.ru
Received: from forward103q.mail.yandex.net (forward103q.mail.yandex.net [IPv6:2a02:6b8:c0e:50:0:640:b21c:d009]) by forward106p.mail.yandex.net (Yandex) with ESMTP id 8647F2FC058F for ; Mon, 13 Feb 2023 15:13:57 +0300 (MSK)
Received: from vla1-ef285479e348.qloud-c.yandex.net (vla1-ef285479e348.qloud-c.yandex.net [IPv6:2a02:6b8:c0d:35a1:0:640:ef28:5479]) by forward103q.mail.yandex.net (Yandex) with ESMTP id 8159D56A0002 for ; Mon, 13 Feb 2023 15:13:57 +0300 (MSK)
Received: by vla1-ef285479e348.qloud-c.yandex.net (smtp/Yandex) with ESMTPSA id vDhYjB0Y0eA1-Qre5VVGO; Mon, 13 Feb 2023 15:13:57 +0300
X-Yandex-Fwd: 1
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=parus.ru; s=mail; t=1676290437; bh=hKibKfisjUei6Cjf/8RlNVikIjCSDsHWqiu/YE2VMgI=; h=Subject:In-Reply-To:Message-ID:To:From smilie

ate; b=BYfRxBh8V8r8JaVfLgZTv/fae/+m24f6uO4JxG7NPPYv0VCFyRqbfKTq+SrPJGGHh
T9NOUVwTBnyE5Rg+eGtcQRTGP5ZKz/ybz4GjO6H7X0tAfM5CQilXXYsR6T4+V7ycrA
LxQbZPdTcgyZLCNGsKih1fvB4ot7WeB01xd3HL5Y=
Authentication-Results: vla1-ef285479e348.qloud-c.yandex.net; dkim=pass header.i=@parus.ru
Received: from OPENCMS803 (unknown [172.28.200.144]) by smtprelay.localdomain (Postfix) with ESMTP id 1374D21F8728 for ; Mon, 13 Feb 2023 15:13:57 +0300 (MSK)
Date: Mon, 13 Feb 2023 15:13:58 +0300 (MSK)
From: webadmin@parus.ru
To: kvm8522@gmail.com
Message-ID: <1235602.154854.413.1676290438493218740383@jforum>
In-Reply-To: <561514.154854.413.1676290438494955718775@jforum>
Subject: Форум ПАРУС. Новый ответ: Уведомление по емайлу о новых ответах по темам
MIME-Version: 1.0
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

=EF=BB=BF te=
sting message --------- =D0=9F=D1=80=D0=BE=D1=87=D0=B8=D1=
=82=D0=B0=D1=82=D1=8C =D1=8D=D1=82=D1=83 =D1=82=D0=B5=D0=BC=D1=83 =D0=BE=D0=
=BD=D0=BB=D0=B0=D0=B9=D0=BD: https://support.parus.ru/forum/posts/list/210/=
154854.page#p1235602 =D0=9E=D1=82=D0=BF=D0=B8=D1=81=D0=B0=D1=82=D1=
=8C=D1=81=D1=8F =D0=BE=D1=82 =D1=83=D0=B2=D0=B5=D0=B4=D0=BE=D0=BC=D0=BB=D0=
=B5=D0=BD=D0=B8=D0=B9 =D0=BF=D0=BE =D1=8D=D1=82=D0=BE=D0=B9 =D1=82=D0=B5=D0=
=BC=D0=B5: https://support.parus.ru/forum/posts/unwatch/154854.page =
 

But if two or more users watches for topic one user then only one of them got right email with Content-Type: text/html;.
Other users got emails without Content-Type: text/html; so they see email with html tags:

Delivered-To: kolesnichenkovit@gmail.com
Received: by 2002:a05:6000:2c5:0:0:0:0 with SMTP id o5csp2297030wry;
Mon, 13 Feb 2023 04:14:00 -0800 (PST)
X-Google-Smtp-Source: AK7set9Gjtt8AoZXeZ9846rsB2w19Bor50xS19gTg6aRjOoVbVOwwA3O5BOSmWmWojeRzP3sszHs
X-Received: by 2002:a17:906:70b:b0:8af:3519:ea1 with SMTP id y11-20020a170906070b00b008af35190ea1mr14722288ejb.57.1676290440016;
Mon, 13 Feb 2023 04:14:00 -0800 (PST)
ARC-Seal: i=1; a=rsa-sha256; t=1676290440; cv=none;
d=google.com; s=arc-20160816;
b=NrBrm3yaWGeXvEo20FWiXxwIfZOu1rx3y6TTK9bXCwJuu9Xu+sZwQGXJqy8ps7+NMi
iMgZxsFKBc0D080DSh8G9zbzG9StFc0VSrveM14FBS711oiXGXXYyQrIdTKo2fYCNi9r
O7V6hFZwch2eZEniv4qtZlMRFmUG3CpYNA7NuxPeuSw+Uv25BTUoFiUNhIQD9LFIsp33
0UV6mNfgwMTmNIfsQ8DQgObk0xa7l34iTOCN1u7Hbec01IzI8lTSwm/HE58Zls2Y4rL/
bjp9s6EZXMzrme9QvxLpqXyudtu7f6wByMYTi3gO/aRmq+wd+UKv+Izjs93VzbN58iYX
u01Q==
ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20160816;
h=mime-version:subject:in-reply-to:message-id:to:from:date
:dkim-signature;
bh=Ji+Jz3frBYMbYeQFDIzilUoUvEyxYjQbhv5bvtzzxzo=;
b=sVnCnym/s3qSwxvaaIB4C/6UAomIcoU4JkNSD+DabcMYwsXYh8UbaF9OYL3DAXU2w4
VYYqFVcbdgFcM+xii38i+g4KDGVBglVcE3xwbXZTwJiUUoISXzo3r4M/wf4+65zDHrkh
DcNm72KtrLs6YhK55PjYACLbIPQ3gwaomCTxMkIW6iaj91YUzr6/iQoiaOOmOZUfEjpg
qN050diuECt2/GoWgb0p6C86O5rfCiXjXv28JKv/DZu67IE1hJ7CpRe2GnFvPRLTfU2W
/fpoDY5J3qrhnCjwXWUc9orMXpmXY5CBaxmFx3vz1TgQUbE98387pUzszbT+OVK5DGTR
2b8A==
ARC-Authentication-Results: i=1; mx.google.com;
dkim=pass header.i=@parus.ru header.s=mail header.b="FNDLsMb/";
spf=pass (google.com: domain of webadmin@parus.ru designates 2a02:6b8:0:1a2d::608 as permitted sender) smtp.mailfrom=webadmin@parus.ru
Return-Path:
Received: from forward105o.mail.yandex.net (forward105o.mail.yandex.net. [2a02:6b8:0:1a2d::608])
by mx.google.com with ESMTPS id 29-20020a170906225d00b00872236c2747si15208213ejr.305.2023.02.13.04.13.59
for
(version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/12 smilie

;
Mon, 13 Feb 2023 04:14:00 -0800 (PST)
Received-SPF: pass (google.com: domain of webadmin@parus.ru designates 2a02:6b8:0:1a2d::608 as permitted sender) client-ip=2a02:6b8:0:1a2d::608;
Authentication-Results: mx.google.com;
dkim=pass header.i=@parus.ru header.s=mail header.b="FNDLsMb/";
spf=pass (google.com: domain of webadmin@parus.ru designates 2a02:6b8:0:1a2d::608 as permitted sender) smtp.mailfrom=webadmin@parus.ru
Received: from forward103q.mail.yandex.net (forward103q.mail.yandex.net [IPv6:2a02:6b8:c0e:50:0:640:b21c:d009]) by forward105o.mail.yandex.net (Yandex) with ESMTP id 851674C451E for ; Mon, 13 Feb 2023 15:13:59 +0300 (MSK)
Received: from vla5-f17bbf3532fc.qloud-c.yandex.net (vla5-f17bbf3532fc.qloud-c.yandex.net [IPv6:2a02:6b8:c18:3588:0:640:f17b:bf35]) by forward103q.mail.yandex.net (Yandex) with ESMTP id 8138856A000F for ; Mon, 13 Feb 2023 15:13:59 +0300 (MSK)
Received: by vla5-f17bbf3532fc.qloud-c.yandex.net (smtp/Yandex) with ESMTPSA id xDh8nB0YFCg1-CIVmok6S; Mon, 13 Feb 2023 15:13:59 +0300
X-Yandex-Fwd: 1
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=parus.ru; s=mail; t=1676290439; bh=Ji+Jz3frBYMbYeQFDIzilUoUvEyxYjQbhv5bvtzzxzo=; h=Subject:In-Reply-To:Message-ID:To:From smilie

ate; b=FNDLsMb/SmMJrs9cYeNJAMiEzcYWqn8wECPrlvxq2BLB4AM65gwlBxUXD6tGDIBrC
ZkzSfAZkW33euCI5NrPt0a8A7izCoAXleUcOUb0aW3bG2PzBbh9fliQnxfX9MB3hbd
6ouxOEBBIp7kZhV0zqzUdlAxPGTjXl/Pn59It/SY=
Authentication-Results: vla5-f17bbf3532fc.qloud-c.yandex.net; dkim=pass header.i=@parus.ru
Received: from OPENCMS803 (unknown [172.28.200.144]) by smtprelay.localdomain (Postfix) with ESMTP id 15F9421F8728 for ; Mon, 13 Feb 2023 15:13:59 +0300 (MSK)
Date: Mon, 13 Feb 2023 15:13:58 +0300 (MSK)
From: webadmin@parus.ru
To: kolesnichenkovit@gmail.com
Message-ID: <1235602.154854.413.1676290438493218740383@jforum>
In-Reply-To: <561514.154854.413.1676290438494955718775@jforum>
Subject: Форум ПАРУС. Новый ответ: Уведомление по емайлу о новых ответах по темам
MIME-Version: 1.0

 testing message --------- Прочитать эту тему онлайн: https://support.parus.ru/forum/posts/list/210/154854.page#p1235602 Отписаться от уведомлений по этой теме: https://support.parus.ru/forum/posts/unwatch/154854.page ;

What could be the problem? My current version is 2.8.2, mail.charset=UTF-8 and mail.messageFormat=html

udittmer wrote:In the file templates/default/user_profile.htm, replace registrationDay with registrationDate - that will use the format you selected. Note that in the topic view, the format will still use the short version "Jul 6, 2011", because there space is at a premium.

Attached is a new JForum jar file that has the fix for Oracle. If you replace the one you have with this one, it should work regardless of the cache setting. Let me know how it works out for you.

No, it's the same error
java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000

Sorry to bother you but I have one last question. How can i change format of user registration date at user profile? Now it looks like this Jul 6, 2011
At SystemGlobals.properties date format looks like this dateTime.format=dd.MM.yyyy HH\:mm\:ss
Also topic list and forum list shows date in format dd.MM.yyyy HH\:mm\:ss
Thank you

udittmer wrote:

jdev1 wrote:I found reason of my problem it's "topic.cache.enabled" in SystemGlobal.properties. When it's "true" it uses selectAllByForum with MAX.integer as argument that's why it was 2147483647 as value.

That addresses the symptom, not the problem. If I provide you with a version that includes the fix I posted above, would you be willing to test that?

Yes i can test it.

It looks very strange. No AJAX POST request works. When I changed the type to GET, everything worked.

$.ajax({
type:"POST",
url:"${JForumContext.encodeURL("/ajax/sendTestMail")}",
data:params,
dataType:"script",
global:false
});