Win a copy of Testing JavaScript Applications this week in the HTML Pages with CSS and JavaScript forum!
  • 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 all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Bear Bibeault
  • Ron McLeod
  • Jeanne Boyarsky
  • Paul Clapham
Sheriffs:
  • Tim Cooke
  • Liutauras Vilda
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • fred rosenberger
  • salvin francis
Bartenders:
  • Piet Souris
  • Frits Walraven
  • Carey Brown

Adapting SQL Files for MS SQL Server 2005

 
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm currently working through the process of installing jForum on MS SQL Server 2005 and I ran into some issues when executing the original sqlserver_db_struct.sql file. Here are the things I had to change to get past the errors. The location of this file is within the jforum-2.1.8\WEB-INF\config\database\sqlserver directory.

In short, the only errors I was getting were within the CREATE TABLE function for jforum_moderation_log. See the changes below.

Removed, Added

CREATE TABLE CREATE TABLE [dbo].[jforum_moderation_log] (
[log_id] [bigint] IDENTITY(1,1) NOT NULL,
[user_id] [bigint]) NOT NULL,
[log_description] BLOB[varbinary](max) NOT NULL,
[log_original_message] BLOB[varbinary](max),
[log_date] DATE[datetime] NOT NULL,
[log_type] [tinyint] DEFAULT ((0)),
[post_id] [bigint],
[topic_id] [bigint],
[post_user_Id] [bigint]
PRIMARY KEY CLUSTERED
(
[log_id] ASC
) WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END

Once I corrected these items, both the sqlserver_db_struct.sql file and the sqlserver_db_dump.sql file executed without errors and the data appears to have populated correctly.

Now for the real adventure. Working to get the jForum instance running on Ubuntu 8.10. It looks like we're going to have to do a manual install for SQL or intall for mySQL with the UI and then convert afterwards. Any guidance here would be greatly appreciated.

Where does the sqlserver.sql file come into play? How about the sqlserver.properties file?
[originally posted on jforum.net by cgabriel]
 
A magnificient life is loaded with tough challenges. En garde tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
    Bookmark Topic Watch Topic
  • New Topic