Register / Login  |  Desktop view  |  Jump to bottom of page

User Forum » Re:Problem with html in response emails

Author: udittmer
2 months ago
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.

Author: jdev1
1 month ago
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.

Author: udittmer
1 month ago
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.

Author: jdev1
1 month ago
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);

Author: udittmer
1 month ago
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?

Author: jdev1
1 month ago
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]
Filename error.png
Description No description given
Filesize 7 Kbytes
Downloaded 33 time(s)
[Disk] Download


Author: udittmer
1 month ago
There should be a browser menu "view source code" or "view html source" or something like that. That should contain more information.

Author: jdev1
1 month ago

<!-- 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-->

Author: udittmer
1 month ago
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}.

Author: jdev1
1 month ago
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.

Author: jdev1
1 month ago
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

Author: udittmer
3 weeks ago
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.




Register / Login  |  Desktop view  |  Jump to top of page