Problem with 3.3.8

[jd1940]

Finally got it working. Reinstalling the server plus the batch file did the trick. Mvallevand's didn't work for me but Jaggy's did. Now all is good. Thanks everyone for your help. It's greatly appreciated.

[mvallevand]

Could you send all your server logs before they get too stale. I'd like to see the info from the reinstall while it is still there.

Martin.

[jd1940]

Here you go. These are everything in the log directory of the server.

[mvallevand]

Thanks, to me, it looks like the update was done before you ran the batch file.

Code:

2014-11-16 00:55:14.449    [DEBUG][1]    Executing SQL: alter table CHANNEL add column minor int
2014-11-16 00:55:14.449    [DEBUG][1]    Error excuting SQL (probably already applied in previous release): System.Data.SQLite.SQLiteException (0x80004005): SQL logic error or missing database
duplicate column name: minor
   at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
   at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
   at System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)
   at System.Data.SQLite.SQLiteDataReader.NextResult()
   at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
   at NShared.UpdateManager.DoDatabaseUpdates()
2014-11-16 00:55:14.449    [DEBUG][1]    Executing SQL: update CHANNEL set minor=0 where minor is null
2014-11-16 00:55:14.449    [DEBUG][1]    Executing SQL: alter table EPG_EVENT add column cast_member VARCHAR(255)
2014-11-16 00:55:14.449    [DEBUG][1]    Error excuting SQL (probably already applied in previous release): System.Data.SQLite.SQLiteException (0x80004005): SQL logic error or missing database
duplicate column name: cast_member
   at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
   at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
   at System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)
   at System.Data.SQLite.SQLiteDataReader.NextResult()
   at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
   at NShared.UpdateManager.DoDatabaseUpdates()
2014-11-16 00:55:14.449    [DEBUG][1]    Executing SQL: alter table EPG_EVENT add column crew VARCHAR(255)
2014-11-16 00:55:14.449    [DEBUG][1]    Error excuting SQL (probably already applied in previous release): System.Data.SQLite.SQLiteException (0x80004005): SQL logic error or missing database
duplicate column name: crew
   at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
   at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
   at System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)
   at System.Data.SQLite.SQLiteDataReader.NextResult()
   at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
   at NShared.UpdateManager.DoDatabaseUpdates()
2014-11-16 00:55:14.449    [DEBUG][1]    Executing SQL: alter table EPG_EVENT add column md5 VARCHAR(32)
2014-11-16 00:55:14.449    [DEBUG][1]    Error excuting SQL (probably already applied in previous release): System.Data.SQLite.SQLiteException (0x80004005): SQL logic error or missing database
duplicate column name: md5
   at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
   at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
   at System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)
   at System.Data.SQLite.SQLiteDataReader.NextResult()
   at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
   at NShared.UpdateManager.DoDatabaseUpdates()

Martin

[jd1940]

If I recall I ran the batch file first (the first one I saw) which did nothing. Then I reinstalled and ran your batch file. That caused me to get the SQLite message on the server and shut my client computer down completely. Then I reinstalled again and ran Jaggy's batch file and everything worked. I can also tell you the initial install on the server, before I ever contacted the forum, several items didn't want to open and I had to hit ignore a few times before the installation completed. On all subsequent installations, there was never a problem; the installation went smoothly and without incident.

I'm certainly glad someone on the forum understands those logs as they are completely Greek to me. Thanks again for your help.