Post here for help with installing or upgrading mojoPortal pre-compiled release packages. When posting in this forum, please provide all relevant details. You may also want to review the installation or upgrading documentation.
If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.
When posting in this forum, please try to provide as many relevant details as possible. Particularly the following:
You may also want to review the installation or upgrading documentation.
Operating System: Windows 7 professional Edition.
Database Server: MS SQL Server 2008 Express Edition
Web Server: IIS 7
I tried to install mojoportal as Application but during the installation process the problem below is listed and installation failed.
Running script mojoportal-core - 2.2.7.8 - 00:00:00.0440025 System.Data.SqlClient.SqlException: Invalid column name 'DefaultPageKeywords'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at mojoPortal.Data.SqlHelper.ExecuteNonQuery(SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters) at mojoPortal.Data.DBPortal.DatabaseHelperRunScript(String script, String overrideConnectionInfo) at mojoPortal.Data.DBPortal.DatabaseHelperRunScript(FileInfo scriptFile, String overrideConnectionInfo) at mojoPortal.Business.DatabaseHelper.RunScript(Guid applicationId, FileInfo scriptFile, String overrideConnectionInfo) - 00:00:01.0290589
That is a very strange error. That script runs without error on many many installations and I have never seen or heard of this error before.
What charset/collation are you using on your db?
What language is your OS using?
My OS is english
SQL Server 2008 express edition char set is Turkish_CS_AI
I would try create a new db with a different charset to see if that is the trouble.
As you know char set Turkish_CS_AI CS stands for case sensitive when I change it to CI case insensitive it worked. Thanks for your great help
Glad you got it working! I will remember about the case sensitivity issue if it comes up again.
Best,
Joe