• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Poll and attachment error in MS SQL 2000

 
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thank u monroe, now I can post a poll
[originally posted on jforum.net by novi]
 
Rancher
Posts: 43081
77
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
reply
    Bookmark Topic Watch Topic
  • New Topic