Error when running setup from /Setup/Default.aspx

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.

Post here for help with installation of mojoPortal pre-compiled release packages

When posting in this forum, please try to provide as many relevant details as possible. Particularly the following:

  • What operating system were you running when the bug appeared?
  • What database platform is your site using?
  • What version of mojoPortal are you running?
  • What version of .NET do you use?
  • What steps are necessary to reproduce the issue? Compare expected results vs actual results.

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.

This thread is closed to new posts. You must sign in to post in the forums.
11/26/2007 3:51:32 PM
mojo2
Gravatar
Total Posts 15
View Posts

Error when running setup from /Setup/Default.aspx

I've installed the database and mojoPortal. When I attempt to run the initial setup page at: /setup/default.aspx it does the following (see the SQL error below). The site does seem to work but it worries me to get this error, what should I do?

 

Probing system...
File system permissions ok.
MSSQL database connection ok.
database permissions are sufficient to alter schema.
database initial schema already exists.
database core schema is up to date.
1 site(s) found.
Configuring mojoportal-core...
Configuring feature Html Content - 00:00:00.1562500
Configuring feature Blog - 00:00:00.2187500
Configuring feature Contact Form - 00:00:00.3906250
Configuring feature Event Calendar - 00:00:00.4218750
Configuring feature Forums - 00:00:00.4531250
Configuring feature Image Gallery - 00:00:00.4843750
Configuring feature Links - 00:00:00.5625000
Configuring feature RSSFeed(s) - 00:00:00.5937500
Configuring feature Shared Files - 00:00:00.7031250
Configuring feature Site Statistics - 00:00:00.7031250
Configuring feature Html Fragment Include - 00:00:00.7343750
Configuring feature Xml/Xsl - 00:00:00.7500000
Configuring feature Web Part - 00:00:00.8437500
Running script pollfeature-byChristianFredh - 0.0.0.1 - 00:00:00.8593750
System.Data.SqlClient.SqlException: Line 16: Incorrect syntax near '('. 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) in C:\Documents and Settings\Username\Desktop\mojoportal-2-2-3-9-sourcecode-3\sourcecode\mojoportal\mojoPortal.Data.MSSQL\SQLHelper.cs:line 448 at mojoPortal.Data.dbPortal.DatabaseHelper_RunScript(String script, String overrideConnectionString) in C:\Documents and Settings\Username\Desktop\mojoportal-2-2-3-9-sourcecode-3\sourcecode\mojoportal\mojoPortal.Data.MSSQL\dbPortal.cs:line 509 at mojoPortal.Data.dbPortal.DatabaseHelper_RunScript(FileInfo scriptFile, String overrideConnectionString) in C:\Documents and Settings\Username\Desktop\mojoportal-2-2-3-9-sourcecode-3\sourcecode\mojoportal\mojoPortal.Data.MSSQL\dbPortal.cs:line 445 at mojoPortal.Business.DatabaseHelper.RunScript(Guid applicationID, FileInfo scriptFile, String overrideConnectionString) in C:\Documents and Settings\Username\Desktop\mojoportal-2-2-3-9-sourcecode-3\sourcecode\mojoportal\mojoPortal.Business\DatabaseHelper.cs:line 308 - 00:00:00.8906250
Configuring pollfeature-byChristianFredh...
Configuring feature Poll - 00:00:00.9062500
Running script webstore - 0.0.0.1 - 00:00:00.9375000
System.Data.SqlClient.SqlException: The text, ntext, and image data types are invalid in this subquery or aggregate expression. 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) in C:\Documents and Settings\Username\Desktop\mojoportal-2-2-3-9-sourcecode-3\sourcecode\mojoportal\mojoPortal.Data.MSSQL\SQLHelper.cs:line 448 at mojoPortal.Data.dbPortal.DatabaseHelper_RunScript(String script, String overrideConnectionString) in C:\Documents and Settings\Username\Desktop\mojoportal-2-2-3-9-sourcecode-3\sourcecode\mojoportal\mojoPortal.Data.MSSQL\dbPortal.cs:line 509 at mojoPortal.Data.dbPortal.DatabaseHelper_RunScript(FileInfo scriptFile, String overrideConnectionString) in C:\Documents and Settings\Username\Desktop\mojoportal-2-2-3-9-sourcecode-3\sourcecode\mojoportal\mojoPortal.Data.MSSQL\dbPortal.cs:line 445 at mojoPortal.Business.DatabaseHelper.RunScript(Guid applicationID, FileInfo scriptFile, String overrideConnectionString) in C:\Documents and Settings\Username\Desktop\mojoportal-2-2-3-9-sourcecode-3\sourcecode\mojoportal\mojoPortal.Business\DatabaseHelper.cs:line 308 - 00:00:02.8125000
Running script webstore - 0.0.0.2 - 00:00:02.8281250
System.Data.SqlClient.SqlException: Invalid object name 'dbo.ws_Category_Delete'. 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) in C:\Documents and Settings\Username\Desktop\mojoportal-2-2-3-9-sourcecode-3\sourcecode\mojoportal\mojoPortal.Data.MSSQL\SQLHelper.cs:line 448 at mojoPortal.Data.dbPortal.DatabaseHelper_RunScript(String script, String overrideConnectionString) in C:\Documents and Settings\Username\Desktop\mojoportal-2-2-3-9-sourcecode-3\sourcecode\mojoportal\mojoPortal.Data.MSSQL\dbPortal.cs:line 509 at mojoPortal.Data.dbPortal.DatabaseHelper_RunScript(FileInfo scriptFile, String overrideConnectionString) in C:\Documents and Settings\Username\Desktop\mojoportal-2-2-3-9-sourcecode-3\sourcecode\mojoportal\mojoPortal.Data.MSSQL\dbPortal.cs:line 445 at mojoPortal.Business.DatabaseHelper.RunScript(Guid applicationID, FileInfo scriptFile, String overrideConnectionString) in C:\Documents and Settings\Username\Desktop\mojoportal-2-2-3-9-sourcecode-3\sourcecode\mojoportal\mojoPortal.Business\DatabaseHelper.cs:line 308 - 00:00:02.8750000
Configuring webstore...
Configuring feature WebStoreName - 00:00:02.8750000
Ensuring all features are installed in server admin sites... - 00:00:02.8906250

11/26/2007 4:10:07 PM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Error when running setup from /Setup/Default.aspx

Well those errors happened trying to setup Poll Feature and WebStore feature so as long as you don't use those it should be ok.

I think these scripts are working in svn trunk. Are you using SQL 2005 or SQL 2000?

Best,

Joe

11/27/2007 7:48:17 AM
mojo2
Gravatar
Total Posts 15
View Posts

Re: Error when running setup from /Setup/Default.aspx

Hi, well on the bottom of the setup page it says I have the up to date files:

"Status  Your installation is up to date."

as for the database, it is 2005. It looks like one of the errors at least is due to something missing:

Invalid object name 'dbo.ws_Category_Delete'

I figured the errors were related to those two features. If it's any difference, I was testing using the source code version which I had compiled for this in vs2005

11/27/2007 3:54:54 PM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Error when running setup from /Setup/Default.aspx

The installation is up to date message only refers to the core of mojoPortal.

If you are working with the source code I highly recomend you get the code from svn trunk instead of the download zip.

http://www.mojoportal.com/tortoisesvn.aspx

The script errors are fixed in svn trunk.

Best,

Joe

 

11/30/2007 8:29:55 AM
mojo2
Gravatar
Total Posts 15
View Posts

Re: Error when running setup from /Setup/Default.aspx

 

Hi, unfortunately, I still do get those errors after updating from svn:

 

Running script pollfeature-byChristianFredh - 0.0.0.1 - 00:00:02.3281250
System.Data.SqlClient.SqlException: Line 16: Incorrect syntax near '('. at

 

11/30/2007 1:47:19 PM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Error when running setup from /Setup/Default.aspx

Hi,

When I try with a clean db it works fine for me. I can't think of a reason it would work on one sql 2005 machine but not on another unless you don't have the service paks installed.

I'm not sure if Christian used sql 2000 compatibility option when he created this script. If I send you a new script created with this option can you try it on your machine? I always use this option when generating scripts for the core features and it uses the older compatible syntax.

I'll send it along in a few minutes.

Thanks,

Joe

11/30/2007 2:23:21 PM
mojo2
Gravatar
Total Posts 15
View Posts

Re: Error when running setup from /Setup/Default.aspx

Hi that script fixed the problem, however, there was also another problem in that /setup/default.aspx:

Running script webstore - 0.0.0.4 - 00:00:03
System.Data.SqlClient.SqlException: Line 10: Incorrect syntax near '('. at

11/30/2007 3:40:19 PM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Error when running setup from /Setup/Default.aspx

These scripts are both fixed now in svn trunk. The previous versions I think were not generated with SQL 2000 compatibility. My guess is your installation of SQL 2005 does not have the service pak(s) applied so apparently some new syntax support has come in the service paks. In any case we should to try to keep compatibility with sql 2000 so it was good to fix these scripts. I appreciate you letting me know and helping work through correcting it.

Many Thanks,

Joe

You must sign in to post in the forums. This thread is closed to new posts.