Trouble with v1.6.2.32

Topics: Business Logic Layer
Nov 2, 2010 at 10:40 PM

Folks,

I'm trying to stay up to date as much as I can, but recently, each new release - even seemingly minor changes - have caused great havoc and my web site has been more offline for maintenance than up and running.

The most recent problem: with the most recent version, I keep getting exceptions left and right - once BlogEngine.NET complains it can't initialize the settings subsytem - "no such table 'be_Settings' " which is a lie - there *is* such a table in my blogengine.s3db database!

Now suddenly, I get "type initializer for 'Right' has failed - no such table 'be_Rights'" - and this time, the error is accurate - there is no such table......

Are there any upgrade scripts for the SQLite database files to get them up and running again? Is the SQLite database provider even supported anymore??

Any help would be most welcome !

Marc

Coordinator
Nov 2, 2010 at 11:59 PM

We are preparing beta release in couple weeks - this is when stable version with all updated scripts will be available. Until then you'd have to grab updates for database from Sql Server update script. There are couple new tables to support roles/rights functionality that SQLite currently missing, and more changes to back-end coming, but it all definitely will be updated for beta.

CREATE TABLE [dbo].[be_Rights](
    [RightName] [nvarchar](100) NOT NULL,
 CONSTRAINT [PK_be_Rights] PRIMARY KEY CLUSTERED
(
    [RightName] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[be_RightRoles](
    [RightName] [nvarchar](100) NOT NULL,
    [Role] [nvarchar](100) NOT NULL,
 CONSTRAINT [PK_be_RightRoles] PRIMARY KEY CLUSTERED
(
    [RightName] ASC,
    [Role] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[be_Posts] ADD IsDeleted bit NULL
GO

ALTER TABLE [dbo].[be_Pages] ADD IsDeleted bit NULL
GO