[Solved?] CVS not working, status of 2.1.5?

[Migrated From Jforum.net]

Hi, reading the forum I figured that I'd need the CVS version to get sqlserver support for the forum.

So I checked that out and got it running. But there seem to be some issues with the database/datamodel - at least for the sqlserver?

I could get the forum up running by fixing the UserModel.selectById query (adding a missing column)

Now I can run the forum, admin, create categories, forums.

I registered a new user. I tried to post as this new user. Here I get the next error:

Caused by: java.sql.SQLException: Invalid column name last_user_id.
	at net.sourceforge.jtds.jdbc.JtdsResultSet.findColumn(JtdsResultSet.java:964)
	at net.sourceforge.jtds.jdbc.JtdsResultSet.getInt(JtdsResultSet.java:968)
	at net.jforum.dao.generic.GenericTopicDAO.fillTopicsData(GenericTopicDAO.java:607)
	at net.jforum.dao.sqlserver.SqlServerTopicDAO.selectRecentTopics(SqlServerTopicDAO.java:83)
	at net.jforum.repository.TopicRepository.loadMostRecentTopics(TopicRepository.java:161)
	at net.jforum.repository.TopicRepository.pushTopic(TopicRepository.java:104)
	at net.jforum.view.forum.common.TopicsCommon.updateBoardStatus(TopicsCommon.java:273)
	at net.jforum.view.forum.PostAction.insertSave(PostAction.java:1057)
	... 16 more

I can't find this last_user_id column nowhere in the sqlserver SQL files and have no idea, how to fix that.

Question:
is this a work in progress?
how usable is the CVS version, especially the SQLSERVER support?
any timeline on a 2.1.5 release?

I could try and help a bit in testing the sqlserver stuff - if that helps
[originally posted on jforum.net by Ansorg]

[Migrated From Jforum.net]

SQL Server is not usable as far as I know - it should work for other databases.

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

I don't know about the current cvs status, but sometime ago I had submitted an sql file for sql server. You can find it here:

https://coderanch.com/t/575550

I'm using sql server without any problem...
[originally posted on jforum.net by cagin]

[Migrated From Jforum.net]

cagin wrote:I don't know about the current cvs status, but sometime ago I had submitted an sql file for sql server. You can find it here:

https://coderanch.com/t/575550

I'm using sql server without any problem...

Hm, using your script I'm back at where I was directly after checking out jforum from CVS:

09:56:53,282 ERROR [ExceptionWriter     ] java.sql.SQLException: Invalid column name user_biography.
	at net.sourceforge.jtds.jdbc.JtdsResultSet.findColumn(JtdsResultSet.java:964)
	at net.sourceforge.jtds.jdbc.JtdsResultSet.getString(JtdsResultSet.java:1205)
	at net.jforum.dao.generic.GenericUserDAO.fillUserFromResultSet(GenericUserDAO.java:164)
	at net.jforum.dao.generic.GenericUserDAO.selectById(GenericUserDAO.java:97)
	at net.jforum.repository.SecurityRepository.load(SecurityRepository.java:94)
	at net.jforum.repository.SecurityRepository.load(SecurityRepository.java:112)
	at net.jforum.JForum.service(JForum.java:158)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:103)
	at com.caucho.server.http.FilterChainServlet.doFilter(FilterChainServlet.java:96)
	at net.jforum.util.legacy.clickstream.ClickstreamFilter.doFilter(ClickstreamFilter.java:59)
	at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88)
	at com.caucho.server.http.Invocation.service(Invocation.java:315)
	at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135)
	at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:246)
	at com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java:164)
	at com.caucho.server.TcpConnection.run(TcpConnection.java:139)
	at java.lang.Thread.run(Thread.java:534)

The column "user_biography" exists in the user table. SO I can fix that error by adding the column to UserModel.selectById like

UserModel.selectById = SELECT COUNT(pm.privmsgs_to_userid) AS private_messages, u.user_id, u.user_active, u.username, u.user_password, u.user_session_time, \
								u.user_session_page, u.user_lastvisit, u.user_regdate, u.user_level, u.user_posts, u.user_timezone, u.user_style, \
								u.user_lang, u.user_dateformat, u.user_new_privmsg, u.user_unread_privmsg, u.user_last_privmsg, u.user_emailtime, \
								u.user_viewemail, u.user_attachsig, u.user_allowhtml, u.user_allowbbcode, u.user_allowsmilies, u.user_allowavatar, \
								u.user_allow_pm, u.user_allow_viewonline, u.user_notify, u.user_notify_pm, u.user_popup_pm, u.rank_id, u.user_avatar, \
								u.user_avatar_type, u.user_email, u.user_icq, u.user_website, u.user_from, CAST(u.user_sig as varchar) as user_sig , u.user_sig_bbcode_uid, \
								u.user_aim, u.user_yim, u.user_msnm, u.user_occ, u.user_interests, u.user_actkey, u.gender, u.themes_id, u.deleted, \
								u.user_viewonline, u.security_hash, u.user_karma, CAST(u.user_biography as varchar) as user_biography \
								FROM jforum_users u \
								LEFT JOIN jforum_privmsgs pm ON pm.privmsgs_type = 1 AND pm.privmsgs_to_userid = u.user_id \
								WHERE u.user_id = ? \
								GROUP BY pm.privmsgs_to_userid, u.user_id, u.user_active, u.username, u.user_password, u.user_session_time, \
								u.user_session_page, u.user_lastvisit, u.user_regdate, u.user_level, u.user_posts, u.user_timezone, u.user_style, \
								u.user_lang, u.user_dateformat, u.user_new_privmsg, u.user_unread_privmsg, u.user_last_privmsg, u.user_emailtime, \
								u.user_viewemail, u.user_attachsig, u.user_allowhtml, u.user_allowbbcode, u.user_allowsmilies, u.user_allowavatar, \
								u.user_allow_pm, u.user_allow_viewonline, u.user_notify, u.user_notify_pm, u.user_popup_pm, u.rank_id, u.user_avatar, \
								u.user_avatar_type, u.user_email, u.user_icq, u.user_website, u.user_from, CAST(u.user_sig as varchar), u.user_sig_bbcode_uid, \
								u.user_aim, u.user_yim, u.user_msnm, u.user_occ, u.user_interests, u.user_actkey, u.gender, u.themes_id, u.deleted, \
								u.user_viewonline, u.security_hash, u.user_karma, CAST(u.user_biography as varchar)

[originally posted on jforum.net by Ansorg]

[Migrated From Jforum.net]

cagin wrote:I don't know about the current cvs status, but sometime ago I had submitted an sql file for sql server. You can find it here:

https://coderanch.com/t/575550

I'm using sql server without any problem...

Continued from above ...

After the last change to sqlserver.sql I can start the forum, login as admin, configure, creeate categories and forums, create new users, login, logout.

But I cannot post messages. When trying it fails with

Caused by: java.sql.SQLException: Invalid column name last_user_id.
	at net.sourceforge.jtds.jdbc.JtdsResultSet.findColumn(JtdsResultSet.java:964)
	at net.sourceforge.jtds.jdbc.JtdsResultSet.getInt(JtdsResultSet.java:968)
	at net.jforum.dao.generic.GenericTopicDAO.fillTopicsData(GenericTopicDAO.java:607)
	at net.jforum.dao.sqlserver.SqlServerTopicDAO.selectRecentTopics(SqlServerTopicDAO.java:83)
	at net.jforum.repository.TopicRepository.loadMostRecentTopics(TopicRepository.java:161)
	at net.jforum.repository.TopicRepository.pushTopic(TopicRepository.java:104)
	at net.jforum.view.forum.common.TopicsCommon.updateBoardStatus(TopicsCommon.java:273)
	at net.jforum.view.forum.PostAction.insertSave(PostAction.java:1057)
	... 16 more

UPDATE

after some debugging (thank god jforum is open source ) I think I could fix that issue:

I replaced all occurances of

last_post_by_id

in the sqlserver.sql with

last_user_id

UPDATE

another issue: SqlServerUserDAO.java#selectAll(int, int) did not work with your changed sqlserver.sql. I changed the code a little

		if (count > 0) {
				p = JForum.getConnection().prepareStatement(SystemGlobals.getSql(&UserModel.selectAllByLimit&));
				p.setInt(1, startFrom);
				p.setInt(2, count);
		}

Now I can post, reply, quote, PM whatever. Will test this further.

Could anybody check those changes and perhaps update the file in CVS?



Next step: implement SSO from the surrounding web app ...



[originally posted on jforum.net by Ansorg]

[Migrated From Jforum.net]

Ok, changes commited to the cvs

Thanks

Rafael
[originally posted on jforum.net by Rafael Steil]