• 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
  • Tim Cooke
  • paul wheaton
  • Paul Clapham
  • Ron McLeod
Sheriffs:
  • Jeanne Boyarsky
  • Liutauras Vilda
Saloon Keepers:
  • Tim Holloway
  • Carey Brown
  • Roland Mueller
  • Piet Souris
Bartenders:

[Solved?] CVS not working, status of 2.1.5?

 
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi, reading the forum I figured that I'd need the CVS version to get sqlserver support for the forum.

So I checked that out and got it running. But there seem to be some issues with the database/datamodel - at least for the sqlserver?

I could get the forum up running by fixing the UserModel.selectById query (adding a missing column)

Now I can run the forum, admin, create categories, forums.

I registered a new user. I tried to post as this new user. Here I get the next error:



I can't find this last_user_id column nowhere in the sqlserver SQL files and have no idea, how to fix that.

Question:
is this a work in progress?
how usable is the CVS version, especially the SQLSERVER support?
any timeline on a 2.1.5 release?

I could try and help a bit in testing the sqlserver stuff - if that helps
[originally posted on jforum.net by Ansorg]
 
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
SQL Server is not usable as far as I know - it should work for other databases.

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
I don't know about the current cvs status, but sometime ago I had submitted an sql file for sql server. You can find it here:

https://coderanch.com/t/575550

I'm using sql server without any problem...
[originally posted on jforum.net by cagin]
 
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

cagin wrote:I don't know about the current cvs status, but sometime ago I had submitted an sql file for sql server. You can find it here:

https://coderanch.com/t/575550

I'm using sql server without any problem...



Hm, using your script I'm back at where I was directly after checking out jforum from CVS:


The column "user_biography" exists in the user table. SO I can fix that error by adding the column to UserModel.selectById like

[originally posted on jforum.net by Ansorg]
 
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

cagin wrote:I don't know about the current cvs status, but sometime ago I had submitted an sql file for sql server. You can find it here:

https://coderanch.com/t/575550

I'm using sql server without any problem...



Continued from above ...

After the last change to sqlserver.sql I can start the forum, login as admin, configure, creeate categories and forums, create new users, login, logout.

But I cannot post messages. When trying it fails with



UPDATE

after some debugging (thank god jforum is open source ) I think I could fix that issue:

I replaced all occurances of

last_post_by_id

in the sqlserver.sql with

last_user_id



UPDATE

another issue: SqlServerUserDAO.java#selectAll(int, int) did not work with your changed sqlserver.sql. I changed the code a little




Now I can post, reply, quote, PM whatever. Will test this further.

Could anybody check those changes and perhaps update the file in CVS?



Next step: implement SSO from the surrounding web app ...



[originally posted on jforum.net by Ansorg]
 
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
Ok, changes commited to the cvs

Thanks

Rafael
[originally posted on jforum.net by Rafael Steil]
 
reply
    Bookmark Topic Watch Topic
  • New Topic