File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JForum and the fly likes Poll and attachment error in MS SQL 2000 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » JForum
Bookmark "Poll and attachment error in MS SQL 2000" Watch "Poll and attachment error in MS SQL 2000" New topic
Author

Poll and attachment error in MS SQL 2000

Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Using: jForum 2.1.7, MS SQL 2000, Tomcat 5.5.23
Code of the MS SQL2000: http://www.jforum.net/jira/browse/JF-656
When I tried to create a poll or attach a file, I get this error message.

Error in creating poll




Error in attachment - Fixed



Could someone help me with Poll error please?
Thank u in advance
[originally posted on jforum.net by novi]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Oficially, JForum does not support MS SQL, so let's hope someone who's using it too give us some help.

Rafael
[originally posted on jforum.net by Rafael Steil]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
A quick guess is that one or more of the SQL statements is trying to do an INSERT/UPDATE using the MySQL "NOW()" function. E.g. INSERT INTO table ( time ) values( NOW() ).

The MS SQL equivalent of this is GETDATE(). You'll need to find the bad statement in the .sql files and change it.
[originally posted on jforum.net by monroe]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Thank u monroe, now I can post a poll
[originally posted on jforum.net by novi]
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 39549
    
  27
The easiest would probably be to switch to this more up-to-date version of JForum, which has a bunch of fixes, some new features, and supports more DBs.


Ping & DNS - updated with new look and Ping home screen widget
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Poll and attachment error in MS SQL 2000
 
Similar Threads
java.lang.reflect.InvocationTargetException
error while inserting new message and new user
Multiple email notifications for new messages in a forum topic
error while inserting new message and new user
Can't create new topics in JForum 2.1.7