Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Agile forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Poll and attachment error in MS SQL 2000

 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank u monroe, now I can post a poll
[originally posted on jforum.net by novi]
 
Ulf Dittmer
Rancher
Pie
Posts: 42967
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic