會員註冊 / 登入  |  電腦版  |  Jump to bottom of page

User Forum » Re:Problem with html in response emails

發表人: udittmer
3 年 前
You'll need to apply the database changes in order. The DB upgrade scripts are in https://sourceforge.net/p/jforum2/code/HEAD/tree/trunk/upgrade/ from 2.2.0 to 2.7.0.

發表人: jdev1
3 年 前
Hi! I just update my forum to version 2.3.5 and when i trying to open any post (/posts/list/101645.page) a'm getting error java.sql.SQLException: Invalid column name. How can i see executing sql query to fix this problem.

發表人: udittmer
3 年 前
The full stack trace should say which attribute is missing. Check the catalina.out file, it contains the full stack trace. That attribute should -hopefully- be part of the 2.3.5 upgrade scripts.

發表人: jdev1
3 年 前
I check catalina.out file there is no error after server startup. And i'm pretty sure i installed all upgrade script from link you gave me.

oracle_2.1.8_to_2.2.0.sql
ALTER TABLE jforum_topics MODIFY (topic_views DEFAULT 0);

--
-- Table structure for table 'jforum_mail_integration'
--
CREATE TABLE jforum_mail_integration (
forum_id NUMBER(10) NOT NULL,
forum_email VARCHAR2(100) NOT NULL,
pop_username VARCHAR2(100) NOT NULL,
pop_password VARCHAR2(100) NOT NULL,
pop_host VARCHAR2(100) NOT NULL,
pop_port NUMBER(10) DEFAULT 110,
pop_ssl NUMBER(1) DEFAULT 0
);

CREATE INDEX idx_mi_forum ON jforum_mail_integration(forum_id);

--
-- Table structure for table 'jforum_api'
--
CREATE SEQUENCE jforum_api_seq
INCREMENT BY 1
START WITH 1 MAXVALUE 2.0E9 MINVALUE 1 NOCYCLE
CACHE 200 ORDER;

CREATE TABLE jforum_api (
api_id NUMBER(10) NOT NULL,
api_key VARCHAR2(32) NOT NULL,
api_validity DATE NOT NULL,
PRIMARY KEY(api_id)
);


oracle_2.3.1_to_2.3.2.sql
ALTER TABLE jforum_attach_desc MODIFY mimetype VARCHAR2(85);

oracle_2.3.2_to_2.3.5.sql
ALTER TABLE jforum_users ADD COLUMN user_twitter VARCHAR2(50) DEFAULT NULL;

ALTER TABLE jforum_moderation_log ALTER COLUMN post_id SET DEFAULT 0;
ALTER TABLE jforum_moderation_log ALTER COLUMN topic_id SET DEFAULT 0;
ALTER TABLE jforum_moderation_log ALTER COLUMN post_user_id SET DEFAULT 0;

ALTER TABLE jforum_mail_integration MODIFY pop_port NUMBER(5);

發表人: udittmer
3 年 前
The error message would appear in the log when that error occurs, not necessarily at startup.

When the error happens, is there just that little bit about SQLException, and nothing else? That would be very odd. Maybe in the HTML source code?

發表人: jdev1
3 年 前
This is sreenshot of error. What HTML source code file should i look into?
I'm sorry for my stupid questions, i'm not web developer)

[Thumb - error.png]
檔案名稱 error.png
描述 沒有檔案註解存在
檔案大小 7 Kbytes
下載次數 612 次
[Disk] 下載


發表人: udittmer
3 年 前
There should be a browser menu "view source code" or "view html source" or something like that. That should contain more information.

發表人: jdev1
3 年 前

<!-- BEGIN ERROR STACK TRACE
net.jforum.exceptions.ForumException: java.lang.reflect.InvocationTargetException
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:114)
at net.jforum.JForum.processCommand(JForum.java:251)
at net.jforum.JForum.service(JForum.java:233)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at net.jforum.util.legacy.clickstream.ClickstreamFilter.doFilter(ClickstreamFilter.java:59)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:492)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:165)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:451)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1201)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:654)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:319)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.reflect.InvocationTargetException
... 30 more
Caused by: net.jforum.exceptions.DatabaseException: java.sql.SQLException: Недопустимое имя столбца
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
at oracle.jdbc.driver.OracleStatement.getColumnIndex(OracleStatement.java:3296)
at oracle.jdbc.driver.OracleResultSetImpl.findColumn(OracleResultSetImpl.java:1914)
at oracle.jdbc.driver.OracleResultSet.getString(OracleResultSet.java:1515)
at com.mchange.v2.c3p0.impl.NewProxyResultSet.getString(NewProxyResultSet.java:3326)
at net.jforum.dao.generic.GenericTopicDAO.topicPosters(GenericTopicDAO.java:1174)
at net.jforum.view.forum.PostAction.list(PostAction.java:235)
... 30 more
Caused by: java.sql.SQLException: Недопустимое имя столбца
... 39 more

URL is: /forum/posts/list/154854.page
END ERROR STACK TRACE-->

發表人: udittmer
3 年 前
Stupid oracle - doesn't say which attribute is missing. Are you using the code from 2.3.5 with this? I advise to apply the DB changes until 2.7.0, and then run the 2.7.0 code with that. After all, you want to run 2.7.0, not 2.3.5.

I won't be able to look into things in detail for the next week or so, but I'll do then (assuming you don't get it running until then}.

發表人: jdev1
3 年 前
I checked requirements for 2.7, i need to update my Java to install 2.7, but i'm afraid if i update Java i can broke other apps on this server so i decided install 2.3.5 in hope that will fix my problem.

發表人: jdev1
3 年 前
Hello! Thanks a lot for all your help. I just fixed my problem with emails.
I downloaded version 2.4 and it resolved problem with java.sql.SQLException
Then i changed response email type to text in my old forum version and copied mail .txt template from 2.4 to my old forum version. I don't how but it's working fine without <br> tags as it was before

發表人: udittmer
3 年 前
It's great that you got it going. But you really should update to Java 8 and JForum 2.7 - you're missing out on a lot of bug and security fixes, not to mention a bunch of useful features.

發表人: jdev1
1 年 前
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/12smilie;
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:Fromsmilieate; 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<br><br><br><br><br><br>te=
sting message<br><br><br>---------<br><br>=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<br><br>=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<br><br>=
<br>




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/12smilie;
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:Fromsmilieate; 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

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



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


發表人: udittmer
1 年 前
I'm not sure, as I don't use HTML emails, but I'll take a look.

發表人: udittmer
1 年 前
I think this can happen if some of the users have "Allow HTML" turned on in their profile, and some users do not.




會員註冊 / 登入  |  電腦版  |  Jump to top of page