Hello.

I am currently installing Gallery Server Pro v2.1.3222 with the following:

-Microsoft SQL Server Management Studio Express (9.00.3042.00)
-Microsoft Data Access Components (MDAC) - 2000.086.3959.00 (srv03_sp2_rtm.070216-1710)
-Microsoft MSXML (2.6 3.0 6.0 )
-Microsoft Internet Explorer (7.0.5730.11)
-Microsoft .NET Framework (2.0.50727.1433)
-Operating System: Windows Server 2003 64-bit

During the installation, I receive the following:

_____________________________________________________________

An error occurred during configuration.
Error executing SQL in InstallGalleryServerProSql2005.sql. Incorrect syntax near '0x0a0d'. Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon. Unclosed quotation mark after the character string ')) ਍䄀䰀吀䔀刀 吀䄀䈀䰀䔀 嬀搀戀漀崀⸀嬀最猀开䄀氀戀甀洀崀 䐀刀伀倀 䌀伀一匀吀刀䄀䤀一吀 嬀䘀䬀开最猀开䄀氀戀甀洀开最猀开䄀氀戀甀洀崀ഀഀ '.

Error executing SQL: /**********************************************************************/ ਍⼀⨀ 䤀渀猀琀愀氀氀䜀愀氀氀攀爀礀匀攀爀瘀攀爀倀爀漀匀焀氀㈀　　㔀⸀猀焀氀                                                  ഀഀ ਍ 䤀渀猀琀愀氀氀猀 琀栀攀 琀愀戀氀攀猀Ⰰ 猀琀漀爀攀搀 瀀爀漀挀攀搀甀爀攀猀Ⰰ 甀猀攀爀ⴀ搀攀昀椀渀攀搀 昀甀渀挀琀椀漀渀猀Ⰰ 愀渀搀 爀漀氀攀猀 渀攀挀攀猀猀愀爀礀 昀漀爀  ഀഀ core Gallery Server Pro operation. This script runs on SQL Server 2005 and later. ਍ 吀栀椀猀 猀挀爀椀瀀琀 猀栀漀甀氀搀 戀攀 爀甀渀 愀昀琀攀爀 琀栀攀 䴀攀洀戀攀爀猀栀椀瀀 匀儀䰀 猀挀爀椀瀀琀猀⸀ഀഀ ਍⨀⨀ 䌀漀瀀礀爀椀最栀琀 吀攀挀栀 䤀渀昀漀 匀礀猀琀攀洀猀Ⰰ 䰀䰀䌀 ㈀　　㠀⸀ 䄀氀氀 刀椀最栀琀猀 刀攀猀攀爀瘀攀搀⸀ഀഀ */ ਍⼀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⼀ഀഀ ਍⼀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⼀ഀഀ /* BEGIN SECTION 1 (AUTO-GENERATED OUTPUT) */ ਍⼀⨀ഀഀ SECTION 1: Create tables, stored procedures, and user-defined functions. The following script ਍眀愀猀 愀甀琀漀洀愀琀椀挀愀氀氀礀 最攀渀攀爀愀琀攀搀 戀礀 琀栀攀 䐀愀琀愀戀愀猀攀 倀甀戀氀椀猀栀椀渀最 圀椀稀愀爀搀 猀攀琀 琀漀 琀栀攀 昀漀氀氀漀眀椀渀最 漀瀀琀椀漀渀猀㨀ഀഀ All tables, stored procedures, and user-defined functions beginning with "gs_" were selected; ਍猀挀栀攀洀愀 漀甀琀瀀甀琀 漀渀氀礀㬀 琀愀爀最攀琀 搀愀琀愀戀愀猀攀 㴀 匀儀䰀 匀攀爀瘀攀爀 ㈀　　㔀㬀 搀爀漀瀀 漀戀樀攀挀琀猀 㴀 琀爀甀攀ഀഀ ਍一伀吀䔀㨀 吀栀攀 愀甀琀漀ⴀ最攀渀攀爀愀琀攀搀 猀挀爀椀瀀琀 椀渀挀氀甀搀攀搀 漀戀樀攀挀琀猀 眀栀漀猀攀 渀愀洀攀猀 猀琀愀爀琀攀搀 眀椀琀栀 愀猀瀀渀攀琀开Ⰰ 攀瘀攀渀 琀栀漀甀最栀ഀഀ they weren't selected in the wizard. These objects were manually removed from the script. ਍䄀氀猀漀Ⰰ 琀栀攀 䜀刀䄀一吀 匀䔀䰀䔀䌀吀 愀渀搀 䜀刀䄀一吀 䔀堀䔀䌀唀吀䔀 猀琀愀琀攀洀攀渀琀猀 眀攀爀攀 洀漀瘀攀搀 琀漀 猀琀攀瀀 ㈀Ⰰ 樀甀猀琀 愀昀琀攀爀 琀栀攀ഀഀ statement that creates the role gs_GalleryServerProRole.*/ ਍⼀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⼀ഀഀ ਍⼀⨀⨀⨀⨀⨀⨀ 伀戀樀攀挀琀㨀  䘀漀爀攀椀最渀䬀攀礀 嬀䘀䬀开最猀开䄀氀戀甀洀开最猀开䄀氀戀甀洀崀    匀挀爀椀瀀琀 䐀愀琀攀㨀 　㤀⼀　㘀⼀㈀　　㜀 ㄀㠀㨀㐀㐀㨀㌀㤀 ⨀⨀⨀⨀⨀⨀⼀ഀഀ IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_gs_Album_gs_Album]') AND parent_object_id = OBJECT_ID(N'[dbo].[gs_Album]')) ਍䄀䰀吀䔀刀 吀䄀䈀䰀䔀 嬀搀戀漀崀⸀嬀最猀开䄀氀戀甀洀崀 䐀刀伀倀 䌀伀一匀吀刀䄀䤀一吀 嬀䘀䬀开最猀开䄀氀戀甀洀开最猀开䄀氀戀甀洀崀ഀഀ

Call stack: 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 GalleryServerPro.Web.installer._default.ExecuteSqlInStream(Stream stream)

_____________________________________________________________

Please help. Thank you.

Thank you for your response. The characters show up as asian in the forum, but they show up as boxes in the installer results window.

I downloaded and updated the file, removed the database, and tried again. It gave me the same error.

Please advise.

Hello.

I tried the experiment and when I opened up the file and executed, it gave me the message:

A fatal scripting error occurred.
Incorrect syntax was encountered while parsing GO.

The SQL text looks like the following (where the asian characters are squares):

/**********************************************************************/
਍⼀⨀ 䤀渀猀琀愀氀氀䜀愀氀氀攀爀礀匀攀爀瘀攀爀倀爀漀匀焀氀㈀　　㔀⸀猀焀氀                                                  ഀഀ

਍ 䤀渀猀琀愀氀氀猀 琀栀攀 琀愀戀氀攀猀Ⰰ 猀琀漀爀攀搀 瀀爀漀挀攀搀甀爀攀猀Ⰰ 甀猀攀爀ⴀ搀攀昀椀渀攀搀 昀甀渀挀琀椀漀渀猀Ⰰ 愀渀搀 爀漀氀攀猀 渀攀挀攀猀猀愀爀礀 昀漀爀  ഀഀ
core Gallery Server Pro operation. This script runs on SQL Server 2005 and later.
਍ 吀栀椀猀 猀挀爀椀瀀琀 猀栀漀甀氀搀 戀攀 爀甀渀 愀昀琀攀爀 琀栀攀 䴀攀洀戀攀爀猀栀椀瀀 匀儀䰀 猀挀爀椀瀀琀猀⸀ഀഀ
਍⨀⨀ 䌀漀瀀礀爀椀最栀琀 吀攀挀栀 䤀渀昀漀 匀礀猀琀攀洀猀Ⰰ 䰀䰀䌀 ㈀　　㠀⸀ 䄀氀氀 刀椀最栀琀猀 刀攀猀攀爀瘀攀搀⸀ഀഀ
*/
਍⼀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⼀ഀഀ
਍⼀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⼀ഀഀ
/* BEGIN SECTION 1 (AUTO-GENERATED OUTPUT) */
਍⼀⨀ഀഀ
SECTION 1: Create tables, stored procedures, and user-defined functions. The following script
਍眀愀猀 愀甀琀漀洀愀琀椀挀愀氀氀礀 最攀渀攀爀愀琀攀搀 戀礀 琀栀攀 䐀愀琀愀戀愀猀攀 倀甀戀氀椀猀栀椀渀最 圀椀稀愀爀搀 猀攀琀 琀漀 琀栀攀 昀漀氀氀漀眀椀渀最 漀瀀琀椀漀渀猀㨀ഀഀ
All tables, stored procedures, and user-defined functions beginning with "gs_" were selected;
਍猀挀栀攀洀愀 漀甀琀瀀甀琀 漀渀氀礀㬀 琀愀爀最攀琀 搀愀琀愀戀愀猀攀 㴀 匀儀䰀 匀攀爀瘀攀爀 ㈀　　㔀㬀 搀爀漀瀀 漀戀樀攀挀琀猀 㴀 琀爀甀攀ഀഀ
਍一伀吀䔀㨀 吀栀攀 愀甀琀漀ⴀ最攀渀攀爀愀琀攀搀 猀挀爀椀瀀琀 椀渀挀氀甀搀攀搀 漀戀樀攀挀琀猀 眀栀漀猀攀 渀愀洀攀猀 猀琀愀爀琀攀搀 眀椀琀栀 愀猀瀀渀攀琀开Ⰰ 攀瘀攀渀 琀栀漀甀最栀ഀഀ
they weren't selected in the wizard. These objects were manually removed from the script.
਍䄀氀猀漀Ⰰ 琀栀攀 䜀刀䄀一吀 匀䔀䰀䔀䌀吀 愀渀搀 䜀刀䄀一吀 䔀堀䔀䌀唀吀䔀 猀琀愀琀攀洀攀渀琀猀 眀攀爀攀 洀漀瘀攀搀 琀漀 猀琀攀瀀 ㈀Ⰰ 樀甀猀琀 愀昀琀攀爀 琀栀攀ഀഀ
statement that creates the role gs_GalleryServerProRole.*/
਍⼀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⼀ഀഀ

I tried opening up the InstallCommon.sql file and it shows fine.

I am running Microsoft Windows Server 2003 RC2, Standard x64 Edition, Service Pack 2, where the strange text occurs. I tried your above file and it still shows strange.

I opened up your the file on a different computer (Windows XP) with Management Studio and it read fine.

Please advise.

Hello.

It looks like that made it work. Thank you very much.

However, upon configuring the Site Admin email page, I didn't enter an SMTP and proceeded to Save Changes. I cannot get into the application now because of the following message:

---

The SMTP host was not specified.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: The SMTP host was not specified.

Source Error:

The source code that generated this unhandled exception can only be shown when compiled in debug mode. To enable this, please follow one of the below steps, then request the URL:

1. Add a "Debug=true" directive at the top of the file that generated the error. Example:

<%@ Page Language="C#" Debug="true" %>

or:

2) Add the following section to the configuration file of your application:

<configuration>
<system.web>
<compilation debug="true"/>
</system.web>
</configuration>

Note that this second technique will cause all files within a given application to be compiled in debug mode. The first technique will cause only that particular file to be compiled in debug mode.

Important: Running applications in debug mode does incur a memory/performance overhead. You should make sure that an application has debugging disabled before deploying into production scenario.

Stack Trace:


[InvalidOperationException: The SMTP host was not specified.]
System.Net.Mail.SmtpClient.CheckHostAndPort() +887569
System.Net.Mail.SmtpClient.Send(MailMessage message) +431
GalleryServerPro.ErrorHandler.AppErrorHandler.SendErrorReport(Exception ex, Exception eventLogException) +623
GalleryServerPro.ErrorHandler.AppErrorHandler.RecordErrorInfo(Exception ex) +43
GalleryServerPro.Business.AppSetting.DetermineIfDotNet3IsInstalled() +199
GalleryServerPro.Business.AppSetting.Initialize(ApplicationTrustLevel trustLevel, String physicalAppPath, String mediaObjectPath, String thumbnailPath, String optimizedPath, String appName) +370
GalleryServerPro.Web.WebsiteController.InitializeBusinessLayer() +237
GalleryServerPro.Web.WebsiteController.InitializeApplication() +5
GalleryServerPro.Web.GspPage..cctor() +56

[TypeInitializationException: The type initializer for 'GalleryServerPro.Web.GspPage' threw an exception.]
GalleryServerPro.Web.GspPage..ctor() +0
GalleryServerPro.Web._default..ctor() +5
ASP.default_aspx..ctor() +10
__ASP.FastObjectFactory_app_web_e0cgqtqn.Create_ASP_default_aspx() +20
System.Web.Compilation.BuildResultCompiledType.CreateInstance() +49
System.Web.Compilation.BuildManager.CreateInstanceFromVirtualPath(VirtualPath virtualPath, Type requiredBaseType, HttpContext context, Boolean allowCrossApp, Boolean noAssert) +115
System.Web.UI.PageHandlerFactory.GetHandlerHelper(HttpContext context, String requestType, VirtualPath virtualPath, String physicalPath) +31
System.Web.UI.PageHandlerFactory.System.Web.IHttpHandlerFactory2.GetHandler(HttpContext context, String requestType, VirtualPath virtualPath, String physicalPath) +40
System.Web.HttpApplication.MapHttpHandler(HttpContext context, String requestType, VirtualPath path, String pathTranslated, Boolean useAppConfig) +139
System.Web.MapHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +128
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +161

---

Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433

Perfect! I modified the file to show false for the time being until I get my SMTP service.

Thank you very much for this wonderful product and your extremely prompt and helpful support!