wood burning stoves 2.0*
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: 42028
    
  64
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 - my free Android networking tools app
 
GeeCON Prague 2014
 
subject: Poll and attachment error in MS SQL 2000