Hi
Thanks for answer
the Blog version is 2.6.0.0.
I crosscheck all files under setup\applications\blog\*.* all are identical to the setup package.
I run setup/default.aspx again, and detected an error (sorry for not seeing this in the first run)
============
Configuring feature Bing Map - 00:00:01.5643530
Running script blog - 2.6.0.1 - 00:00:01.6356375
System.Data.SqlClient.SqlException (0x80131904): Zeichenfolgen- oder Binärdaten würden abgeschnitten. Die Anweisung wurde beendet. bei System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) bei System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() bei System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) bei System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) bei System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) bei System.Data.SqlClient.SqlCommand.ExecuteNonQuery() bei mojoPortal.Data.SqlHelper.ExecuteNonQuery(SqlTransaction transaction, CommandType commandType, String commandText, Int32 commandTimeout, SqlParameter[] commandParameters) bei mojoPortal.Data.DBPortal.DatabaseHelperRunScript(String script, String overrideConnectionInfo) bei mojoPortal.Business.DatabaseHelper.RunScript(Guid applicationId, FileInfo scriptFile, String overrideConnectionInfo) - 00:00:01.9979190
Configuring feature Blog - 00:00:02.0262375
==================
Sorry Error is German, because SQL is German version, but means that that (n(v))char- or binary data would be truncated so the script terminates. So I think this error exist a little bit longer, (2.6.0.1) i don't update every version of your great mojo.
The Error is in the SQL Statement
INSERT INTO mp_Comments(ParentGuid,SiteGuid,FeatureGuid,ModuleGuid,ContentGuid,UserGuid,Title,UserComment,UserName,UserEmail,UserUrl,UserIp,CreatedUtc,LastModUtc,ModerationStatus)
SELECT'00000000-0000-0000-0000-000000000000',m.SiteGuid,m.FeatureGuid,m.[Guid],b.BlogGuid,'00000000-0000-0000-0000-000000000000',bc.Title,bc.[Comment],bc.[Name],'',bc.URL,'',bc.DateCreated,bc.DateCreated,1 FROM mp_BlogComments bc JOIN mp_Blogs b ON b.ItemID = bc.ItemID JOIN mp_Modules m ON m.ModuleID = bc.ModuleID
Just doing the select part only I found one entry with the length of 56 Char´s in the bc.name field (Target table only allows 50 char)
The origin table mp_BlogComments allows 100 char in the name field, and the script didn´t cut this to 50.
After cutting the name field manually in mp_BlogComments all went fine.
Configuring feature Bing Map - 00:00:00.1298878
Running script blog - 2.6.0.1 - 00:00:00.1435602
Running script blog - 2.6.0.2 - 00:00:00.4189614
Running script blog - 2.6.0.3 - 00:00:00.6513922
Running script blog - 2.6.0.4 - 00:00:00.7529586
Running script blog - 2.6.0.5 - 00:00:00.8066716
Running script blog - 2.6.0.6 - 00:00:00.8515952
Running script blog - 2.6.0.7 - 00:00:01.0771898
Running script blog - 2.6.0.8 - 00:00:01.1543412
Running script blog - 2.6.0.9 - 00:00:01.4893150
Running script blog - 2.6.1.0 - 00:00:02.1084794
Running script blog - 2.6.1.1 - 00:00:02.1582860
Configuring feature Blog - 00:00:02.1875840
Configuring feature Comments - 00:00:02.2237182
Can I delete some content of the Blog Comments (spam) in database direct? in the old table mp_BlogComments or in the new mp_comments? I cant find this comments in the Webgui of the blogs.
So thanks again for help, I have 2 other smaller issues (both in Image Gallery) but I will make 2 new threads.
Peter
Best Regards from Austria