jforum 2.1.7 b3 error with sql server 2000 script

[Migrated From Jforum.net]

'ROW_NUMBER' is not a recognized function name.

how to fix, still using sql server2000, can not update to 2005, because the server on the web is only 2000

please help me jforum team
[originally posted on jforum.net by kiemhao]

[Migrated From Jforum.net]

One of the big headache's with MS SQL is that it has never supported the non-standard / but widely supported by other vendor's LIMIT and OFFSET type of syntax. These are generally used to get a subset (e.g. page) of results from a large query. The current SQL support "emulates" these using the SQL 2005 functions.

That said, there are two way to go here. The first is to try to figure out a way to emulate the OFFSET/LIMIT functions in older MS SQL versions. This might require some server specific stored procedures or views to be set up and the associated queries to be changed.

Or, if you don't mind running the 2.1.6 version, you could use my Torque DAO implimentation. See:

https://coderanch.com/t/577340

and the thread linked into it.

We use it in our production environment with MS SQL 2000 and run it against V7.0 in development.
[originally posted on jforum.net by monroe]

[Migrated From Jforum.net]

i am successfully install with version 2.1.6 with dao on local,
but that version can not host on the web, because first, i do not have the war file, second if i have the war file, can not edit the jforum-custom.conf on the server

So, i have tried the latest version 2.1.7 b3, It doesn't work, problem with
systemglobal.properties (connect to databse error, something like that), when i start the site, after fix the error in log4.xml ( no appender could be found )

So, can you help me fix the problem or i have to wait for the next version
[originally posted on jforum.net by kiemhao]

[Migrated From Jforum.net]

A war is nothing more that a zip file/jar file of everything under the webapp's root directory (e.g. the one that the WEB-INF file is in).

If you have a working local version, just make sure the jforum-custom.conf has the values you need for the production server and zip it up. I.e., if you expand a war file with winzip or 7zip, the directory that you expand it to will contains stuff like:

images
templates
...
WEB-INF
...
index.htm

As opposed to jforum/images, etc.

One thing I'm not sure of is if JForum will run correctly from an unexpanded war file. In particular, attachments may not have a place to be stored.
[originally posted on jforum.net by monroe]

[Migrated From Jforum.net]

Thanks for reply

i tried to use winrar for archive to .war file, but it didn't work when i copy that war file to webapps directory, the tomcat didn't create a directory with the name as the war file

So, i know , the build.xml is needed to build a war file from source,
but i don't have that file in version 2.1.6

Can you help me, I have tested many forum software. but the jforum is the best i think (both graphic and process)


[originally posted on jforum.net by kiemhao]

[Migrated From Jforum.net]

and one thing i want to ask

when i host jforum 2.1.7 b3 version, i got the error message :

---------------------------------------
exception

javax.servlet.ServletException: Servlet.init() for servlet jforum threw exception
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:300)
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:383)
org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:743)
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:675)
org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:866)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
java.lang.Thread.run(Unknown Source)


root cause

net.jforum.exceptions.ForumStartupException: Error while starting JForum
java.util.Hashtable.put(Unknown Source)
net.jforum.util.preferences.SystemGlobals.buildSystem(SystemGlobals.java:116)
net.jforum.util.preferences.SystemGlobals.initGlobals(SystemGlobals.java:104)
net.jforum.ConfigLoader.startSystemglobals(ConfigLoader.java:90)
net.jforum.JForumBaseServlet.init(JForumBaseServlet.java:108)
net.jforum.JForum.init(JForum.java:94)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:300)
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:383)
org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:743)
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:675)
org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:866)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
java.lang.Thread.run(Unknown Source)


note The full stack trace of the root cause is available in the Apache Tomcat/5.5.4 logs.


--------------------------------------------------------------------------------

it work on local, but error on web, do you know why ?


Thanks a lot,


[originally posted on jforum.net by kiemhao]