[Logo] JForum - Powering Communities
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Top Downloads] Top Downloads   [Groups] Back to home page 
[Register] Register /  [Login] Login 


The final version of JForum 2.7.0 has been released with lots of improvements. Read all about it here

Problem with html in response emails RSS feed
Forum Index » User Forum
Author Message
udittmer


Joined: 2013/2/21
Messages: 343
Offline
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.

Ping & Net - my free Android app for TCP/IP network diagnostics
[Email] [WWW]
jdev1


Joined: 2021/3/22
Messages: 14
Offline
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


Joined: 2013/2/21
Messages: 343
Offline
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.

Ping & Net - my free Android app for TCP/IP network diagnostics
[Email] [WWW]
jdev1


Joined: 2021/3/22
Messages: 14
Offline
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


Joined: 2013/2/21
Messages: 343
Offline
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?

Ping & Net - my free Android app for TCP/IP network diagnostics
[Email] [WWW]
jdev1


Joined: 2021/3/22
Messages: 14
Offline
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 [Disk] Download
 Description No description given
 Filesize 7 Kbytes
 Downloaded:  32 time(s)

udittmer


Joined: 2013/2/21
Messages: 343
Offline
There should be a browser menu "view source code" or "view html source" or something like that. That should contain more information.

Ping & Net - my free Android app for TCP/IP network diagnostics
[Email] [WWW]
jdev1


Joined: 2021/3/22
Messages: 14
Offline

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


Joined: 2013/2/21
Messages: 343
Offline
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}.

Ping & Net - my free Android app for TCP/IP network diagnostics
[Email] [WWW]
jdev1


Joined: 2021/3/22
Messages: 14
Offline
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


Joined: 2021/3/22
Messages: 14
Offline
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


Joined: 2013/2/21
Messages: 343
Offline
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.

Ping & Net - my free Android app for TCP/IP network diagnostics
[Email] [WWW]
 
Forum Index » User Forum
Go to:   
Mobile view
Powered by JForum 2.7.0 © 2020 JForum Team • Maintained by Andowson Chang and Ulf Dittmer