can't install on sql2000 - aruba - with strange message

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.
7/21/2009 9:37:03 AM
Gravatar
Total Posts 122

can't install on sql2000 - aruba - with strange message

hallo... I'm in trouble since 2 weeks and I can't figure out !!!

I want to host on a provider witch assigned me those elements

Server: webs1142
Host DataBase: 62.149.153.21
Nome DataBase: MSSqlmiki
Login DataBase: MSSqlmiki
PassWord DataBase: a6ce9ad6

database is SQL2005-2007

The provider created a user called MSSqlmiki with dbo permissions as
- db-datareader
- db-datawriter


The provider (www.aruba.it, ...one of the greatest in italy) DOES NOT accept to change user permission
and says that instead of using "[dbo]." in scripts or db calls I have to put "[MSSqlmiki]."

 

Now, the scenario is the following:

0) I used mojoportal-2-3-1-0-mssql-deploymentfiles.zip

1) I'have done a replace on ALL exixsting [dbo] entries with [MSSqlmiki]

2) I'have set user_config parameter as

<add key="MSSQLConnectionString" value="server=webs1142;UID=MSSqlmiki;PWD=a6ce9ad6;database=MSSqlmiki" />

3) I'have set web_config parameter as

<add key="MSSQLConnectionString" value="server=webs1142;UID=MSSqlmiki;PWD=a6ce9ad6;database=MSSqlmiki" />

4) I run http:\\webname\setup\default.aspx and get always this message:

<<We're sorry but a server error has occurred while trying to process your request.

The error has been logged and will be reviewed by our staff as soon as possible. It is possible that the error was just a momentary hiccup and you may wish to use the back button and try again or go back to the home page. >>


What can I do ?????? HELPPP !!
thanck you all from Michele Ciotti - Italy

7/21/2009 12:49:56 PM
Gravatar
Total Posts 18439

Re: can't install on sql2000 - aruba - with strange message

Hi,

First need to find out what the error is, see http://www.mojoportal.com/basic-troubleshooting.aspx for information to help find out the error.

There was no need to do find and replace on the scripts so its probablly best to restore them as they were.

You can edit this setting in Web.config or ideally put it in user.config

<add key="MSSQLOwnerPrefix" value="[dbo]." />

you should change it to 

<add key="MSSQLOwnerPrefix" value="[MSSqlmiki]." />

and we have a built in thing that will replace the [dbo]. in the scripts before executing them. As long as I've been consistent in the use of [dbo]. then it should hopefully work.

Hope it helps,

Joe

7/21/2009 3:34:34 PM
Gravatar
Total Posts 122

Re: can't install on sql2000 - aruba - with strange message

hi mister... sob.. nothing changes.. and I can't find the famous /Data/currentlog.config sigh !!!

I:

1) reloaded all files

2) changed user.config

<add key="MSSQLConnectionString" value="server=62.149.153.21;UID=MSSql31184;PWD=a6ce9ad6;database=MSSql31184" />

added key:

<add key="MSSQLOwnerPrefix" value="[MSSql31184]." />

3) leaved web.config in standard mode

resault:

<<We're sorry but a server error has occurred while trying to process your request.

The error has been logged and will be reviewed by our staff as soon as possible. It is possible that the error was just a momentary hiccup and you may wish to use the back button and try again or go back to the home page.
>>

now it's not a matter of one beer, its a full dinner when you will come to rome.. hehehehe

help me !!!

 

 

 

 

 

7/22/2009 6:37:27 AM
Gravatar
Total Posts 18439

Re: can't install on sql2000 - aruba - with strange message

Hi,

Dinner in Rome would be a dream come true, maybe one day ;-)

I think you missed part of the troubleshooting tips, it was poorly written/organised, I've updated the article to make it clearer. Please see the part about disabling the friendly error page so you can see the real error and the part about what it means if the log file does not exist.

http://www.mojoportal.com/basic-troubleshooting.aspx

Hope it helps,

Joe

7/22/2009 8:44:22 AM
Gravatar
Total Posts 122

Re: can't install on sql2000 - aruba - with strange message

hi,

I've done it (change web.config) but this comes back:

Server Error in '/'.
--------------------------------------------------------------------------------

Reference to an object not set to an instance of object.
Description:An unhandled exception occurred during the execution of the current web request. For more information about the error and where it originated in the code, see the analysis of the stack.

Exception Details:System.NullReferenceException: Reference to an object not set to an instance of object.

Error in source code:

During the execution of the current web request has been generated an unhandled exception. For information about the location and the exception, see the analysis of the stack from the exception below.

Analysis of the stack:


[NullReferenceException: Reference to an object not set to an instance of object.]
Brettle.Web.NeatUpload.MultiRequestUploadModule.get_UploadPath () +38
Brettle.Web.NeatUpload.UploadHttpModule.Application_BeginRequest (Object sender, EventArgs e) +309
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute () +68
System.Web.HttpApplication.ExecuteStep (IExecutionStep step, Boolean & completedSynchronously) +75

 


--------------------------------------------------------------------------------
Version information:Version of Microsoft. NET Framework: 2.0.50727.3082; ASP.NET Version: 2.0.50727.3082

Here is how I changed web.config:

<!-- CUSTOM ERROR MESSAGES
Set customErrors mode="On" or "RemoteOnly" to enable custom error messages, "Off" to disable.
Add <error> tags for each of the errors you want to handle.

"On" Always display custom (friendly) messages.
"Off" Always display detailed ASP.NET error information.
"RemoteOnly" Display custom (friendly) messages only to users not running
on the local Web server. This setting is recommended for security purposes, so
that you do not display application detail information to remote clients.


-->
<customErrors mode="Off" defaultRedirect="Error.htm">
<error statusCode="413" redirect="~/NeatUpload/Error413.aspx" />
</customErrors>
<!-- set enabled to true if you want to trace -->
<trace enabled="false" writeToDiagnosticsTrace="true" requestLimit="50" pageOutput="true" traceMode="SortByTime" localOnly="false" />

 

7/22/2009 8:52:16 AM
Gravatar
Total Posts 18439

Re: can't install on sql2000 - aruba - with strange message

Possible causes

1. Based on the version at the bottom of the error I have a feeling this machine does not have .NET 3.5 SP1 installed

2. It is also likely that you are hosted in Medium Trust, see  http://www.mojoportal.com/mediumtrust.aspx

Hope it helps,

Joe

7/22/2009 9:18:56 AM
Gravatar
Total Posts 122

Re: can't install on sql2000 - aruba - with strange message

hi Joe... a little task more performed...

now I get this exception... and i dont know what it means..

Checking the system ...
Encountered problems of file system privileges.

An Error Occurred:Can not find a part of the path 'D: \ Inetpub \ webs \ itawanit \ Data \ Sites \ 1 \ GalleryImages \ test.config'.
Source:mscorlib
Stack Trace in System.IO.__Error.WinIOError (Int32 errorCode, String maybeFullPath) in System.IO.FileStream.Init (String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, Fileshare share, Int32 Buffersize, FileOptions options, SECURITY_ATTRIBUTES secAttrs , msgPath String, Boolean bFromProxy) at System.IO.FileStream .. ctor (String path, FileMode mode, FileAccess access, Fileshare share, Int32 Buffersize, FileOptions options) in System.IO.StreamWriter.CreateFile (String path, Boolean append) in System.IO.StreamWriter .. ctor (String path, Boolean append, Encoding encoding, Int32 Buffersize) in System.IO.StreamWriter .. ctor (String path, Boolean append) at System.IO.File.CreateText (String path) in mojoPortal.Web.mojoSetup.TouchTestFile (String pathToFile) in mojoPortal.Web.UI.Pages.SetupHome.GetFolderDetailsHtml () in mojoPortal.Web.UI.Pages.SetupHome.ProbeSystem () in mojoPortal.Web.UI.Pages.SetupHome . Page_Load (Object sender, EventArgs e) at System.Web.UI.Control.OnLoad (EventArgs e) System.Web.UI.Control.LoadRecursive () at System.Web.UI.Page.ProcessRequestMain (Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

7/22/2009 9:25:11 AM
Gravatar
Total Posts 18439

Re: can't install on sql2000 - aruba - with strange message

That means its trying to create test files to make sure it has correct file system permissions but it can't create the files because permissions are wrong. 

You need to make the /Data folder writable by the web process so it can create files and sub folders there as needed.

Hope it helps,

Joe

7/22/2009 9:49:47 AM
Gravatar
Total Posts 122

Re: can't install on sql2000 - aruba - with strange message

hi joe,

i'm checking with ARUBA (hosting provider) if it is possible to give full permissions  to "\DATA" ...

for now it seems not possible because they told me that their ONLY folder that has full permissions is called "\public"

do you have even made customizable the name of this directory ??? How ??

best regards

Michele Ciotti

7/22/2009 10:04:07 AM
Gravatar
Total Posts 18439

Re: can't install on sql2000 - aruba - with strange message

Sorry but no, the Data folder must be writable there is no way to configure to use a different folder unless maybe you can create a virtual directory "Data" that maps to public and then put the files in public, maybe that can work.

Hopeit helps,

Joe 

7/22/2009 10:06:17 AM
Gravatar
Total Posts 122

Re: can't install on sql2000 - aruba - with strange message

hi joe...

checked (sob !!)...

they confirm me that only the directory "\public" has the right permissions !!!

then they proposed me to change to a linux platform.. but with Mysql , obviuously not 2.0 or 3.5 aspnet, etc...

Does mojoportal work on linux ??

... I'm living a drama !!! (but the rome - dinner is still confirmed.. hehehe)

Michele

 

7/22/2009 10:24:52 AM
Gravatar
Total Posts 18439

Re: can't install on sql2000 - aruba - with strange message

Thats a pretty restrictive hosting environment sound like most apps will have trouble running on a platform where they tell you what folders can be writable. Most hosting companies offer a control panel where you can configure file system permissions according to your needs.

mojoPortal can run on Linux using Mono, but Mono is still too buggy in my opinion for me to recommend it for important sites and very few hosting companies offer Mono support.

I would look for another host if they don't give you control over file system permissions.

Hope it helps,

Joe

7/24/2009 8:43:30 AM
Gravatar
Total Posts 122

Re: can't install on sql2000 - aruba - with strange message

HI Joe... hope you have a little more time for me..

I've resolved access wright to \data folder .... (renamed their "public" to "data"... and seems it works)

now I have the next problem...

Verifica del sistema...
Privilegi del File system ok.
MSSQL connessione al database ok.
i privilegi per il database sono sufficienti per modificare lo schema.
lo schema database iniziale gia' esistente.
lo schema centrale del database necessita aggiornamento.
0 sito(i) trovati.
Questo sito sembra operare in un ambiente protetto che usa policy Medium Trust o, almeno, inferiori a Full Trust.

 

Esecuzione script mojoportal-core - 2.2.1.5 - 00:00:00.2187514
Esecuzione script mojoportal-core - 2.2.1.6 - 00:00:00.2343765
Esecuzione script mojoportal-core - 2.2.1.7 - 00:00:00.2343765
Esecuzione script mojoportal-core - 2.2.1.8 - 00:00:00.2343765
Esecuzione script mojoportal-core - 2.2.1.9 - 00:00:00.2343765
System.Data.SqlClient.SqlException: Either the parameter @objname is ambiguous or the claimed @objtype (COLUMN) is wrong. in System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) in System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) in System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) in System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) in System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) in System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) in System.Data.SqlClient.SqlCommand.ExecuteNonQuery() in mojoPortal.Data.SqlHelper.ExecuteNonQuery(SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters) in mojoPortal.Data.DBPortal.DatabaseHelperRunScript(String script, String overrideConnectionInfo) in mojoPortal.Data.DBPortal.DatabaseHelperRunScript(FileInfo scriptFile, String overrideConnectionInfo) in mojoPortal.Business.DatabaseHelper.RunScript(Guid applicationId, FileInfo scriptFile, String overrideConnectionInfo) - 00:00:00.4218777

 

Ok... and now ???

Please help.. by michele

7/24/2009 8:49:05 AM
Gravatar
Total Posts 18439

Re: can't install on sql2000 - aruba - with strange message

Did you restore my scripts and set the config setting for [dbo]. that I mentioned before?

I would upload the /Setup folder again to be sure all the files are restored.

It should not start at script 2.2.1.5, thats a very old upgrade script, it should start at script 2.2.7.8

It determines if its a new install or an upgrade by the existence of the mp_Sites table.

You should delete all tables and procs from the db and then visit setup page again.

Hope it helps,

Joe 

7/24/2009 9:34:36 AM
Gravatar
Total Posts 122

Re: can't install on sql2000 - aruba - with strange message

YUPPAYEA !!!!! ... GREAT !!!

First of all... THANK YOU SO MUCH !!!

second.... BIG DINNER IN ROME

third....

some message at the end of the installation that I dont know if are correct or not !!

 

Esecuzione script mojoportal-core - 2.2.7.8 - 00:00:00.0937506
Esecuzione script mojoportal-core - 2.2.7.9 - 00:00:01.6562606
Esecuzione script mojoportal-core - 2.2.8.0 - 00:00:01.6718857
Esecuzione script mojoportal-core - 2.2.8.1 - 00:00:01.6718857
Esecuzione script mojoportal-core - 2.2.8.2 - 00:00:01.6718857
Esecuzione script mojoportal-core - 2.2.8.3 - 00:00:01.6875108
Esecuzione script mojoportal-core - 2.2.8.4 - 00:00:01.6875108
Esecuzione script mojoportal-core - 2.2.8.5 - 00:00:01.7187610
Esecuzione script mojoportal-core - 2.2.8.6 - 00:00:01.7187610
Esecuzione script mojoportal-core - 2.2.8.7 - 00:00:01.7343861
Esecuzione script mojoportal-core - 2.2.8.8 - 00:00:01.7343861
Esecuzione script mojoportal-core - 2.2.8.9 - 00:00:01.7500112
Esecuzione script mojoportal-core - 2.2.9.0 - 00:00:01.7812614
Esecuzione script mojoportal-core - 2.2.9.1 - 00:00:01.8125116
Esecuzione script mojoportal-core - 2.2.9.2 - 00:00:01.8125116
Esecuzione script mojoportal-core - 2.2.9.3 - 00:00:01.8593869
Esecuzione script mojoportal-core - 2.2.9.4 - 00:00:01.8593869
Esecuzione script mojoportal-core - 2.2.9.5 - 00:00:01.8750120
Esecuzione script mojoportal-core - 2.2.9.6 - 00:00:01.9062622
Esecuzione script mojoportal-core - 2.2.9.7 - 00:00:01.9062622
Esecuzione script mojoportal-core - 2.2.9.8 - 00:00:01.9218873
Esecuzione script mojoportal-core - 2.2.9.9 - 00:00:01.9218873
Esecuzione script mojoportal-core - 2.3.0.0 - 00:00:01.9531375
Esecuzione script mojoportal-core - 2.3.0.1 - 00:00:01.9687626
Esecuzione script mojoportal-core - 2.3.0.2 - 00:00:01.9687626
Esecuzione script mojoportal-core - 2.3.0.3 - 00:00:01.9687626
Esecuzione script mojoportal-core - 2.3.0.4 - 00:00:01.9687626
Esecuzione script mojoportal-core - 2.3.0.5 - 00:00:01.9843877
Esecuzione script mojoportal-core - 2.3.0.6 - 00:00:02.0000128
Esecuzione script mojoportal-core - 2.3.0.7 - 00:00:02.0000128
Esecuzione script mojoportal-core - 2.3.0.8 - 00:00:02.0468881
Esecuzione script mojoportal-core - 2.3.0.9 - 00:00:02.0625132
Esecuzione script mojoportal-core - 2.3.1.0 - 00:00:02.0781383
Creazione sito con impostazioni di default... - 00:00:02.1093885
Creazione ruoi e utente admin... - 00:00:07.3281719
Configurazione caratteristica Html Content - 00:00:07.4531727
Configurazione caratteristica Statistiche Sito - 00:00:07.4844229
Configurazione caratteristica Web Part - 00:00:07.5000480
Esecuzione script blog - 0.0.0.1 - 00:00:07.5156731
Esecuzione script blog - 0.0.0.2 - 00:00:07.5781735
Esecuzione script blog - 0.0.0.3 - 00:00:07.5937986
Esecuzione script blog - 0.0.0.4 - 00:00:07.5937986
Esecuzione script blog - 0.0.0.5 - 00:00:07.6094237
Esecuzione script blog - 0.0.0.6 - 00:00:07.6250488
Esecuzione script blog - 0.0.0.7 - 00:00:07.6250488
Esecuzione script blog - 0.0.0.8 - 00:00:07.6250488
Esecuzione script blog - 0.0.0.9 - 00:00:07.6406739
Esecuzione script blog - 0.0.1.0 - 00:00:07.6406739
Esecuzione script blog - 0.0.1.1 - 00:00:07.6406739
Configurazione caratteristica Blog - 00:00:07.6719241
Esecuzione script contactform - 0.0.0.1 - 00:00:07.7187994
Esecuzione script contactform - 0.0.0.2 - 00:00:07.7344245
Esecuzione script contactform - 0.0.0.3 - 00:00:07.7344245
Configurazione caratteristica Modulo Contatti - 00:00:07.7500496
Esecuzione script eventcalendar - 0.0.0.1 - 00:00:07.7500496
Esecuzione script eventcalendar - 0.0.0.2 - 00:00:07.7812998
Esecuzione script eventcalendar - 0.0.0.3 - 00:00:07.7812998
Configurazione caratteristica Calendario Eventi - 00:00:07.7969249
Esecuzione script feed-manager - 0.0.0.1 - 00:00:07.8125500
Esecuzione script feed-manager - 0.0.0.2 - 00:00:07.8438002
Esecuzione script feed-manager - 0.0.0.3 - 00:00:07.8594253
Esecuzione script feed-manager - 0.0.0.4 - 00:00:07.8594253
Esecuzione script feed-manager - 0.0.0.5 - 00:00:07.8594253
Configurazione caratteristica Gestione Feed - 00:00:07.8906755
Configurazione caratteristica Galleria immagini (versione a cartella semplice) - 00:00:07.9219257
Esecuzione script forums - 0.0.0.1 - 00:00:07.9219257
Esecuzione script forums - 0.0.0.2 - 00:00:08.0781767
Esecuzione script forums - 0.0.0.3 - 00:00:08.0938018
Esecuzione script forums - 0.0.0.4 - 00:00:08.0938018
Esecuzione script forums - 0.0.0.5 - 00:00:08.1094269
Esecuzione script forums - 0.0.0.6 - 00:00:08.1094269
Esecuzione script forums - 0.0.0.7 - 00:00:08.1094269
Configurazione caratteristica Forum - 00:00:08.1250520
Configurazione caratteristica Google Map - 00:00:08.1406771
Configurazione caratteristica Includi Frammento Html - 00:00:08.1563022
Esecuzione script imagegallery - 0.0.0.1 - 00:00:08.1563022
Esecuzione script imagegallery - 0.0.0.2 - 00:00:08.1875524
Esecuzione script imagegallery - 0.0.0.3 - 00:00:08.1875524
Configurazione caratteristica Galleria Immagini - 00:00:08.2031775
Esecuzione script linksmodule - 0.0.0.1 - 00:00:08.2031775
Esecuzione script linksmodule - 0.0.0.2 - 00:00:08.2344277
Esecuzione script linksmodule - 0.0.0.3 - 00:00:08.2344277
Esecuzione script linksmodule - 0.0.0.4 - 00:00:08.2344277
Configurazione caratteristica Collegamenti - 00:00:08.2500528
Configurazione caratteristica Live Messenger Chat - 00:00:08.2656779
Esecuzione script pollfeature-byChristianFredh - 0.0.0.1 - 00:00:08.2656779
Esecuzione script pollfeature-byChristianFredh - 0.0.0.2 - 00:00:08.3125532
Esecuzione script pollfeature-byChristianFredh - 0.0.0.3 - 00:00:08.3125532
Esecuzione script pollfeature-byChristianFredh - 0.0.0.4 - 00:00:08.3125532
Configurazione caratteristica Sondaggi - 00:00:08.3281783
Esecuzione script sharedfiles - 0.0.0.1 - 00:00:08.3281783
Esecuzione script sharedfiles - 0.0.0.2 - 00:00:08.3750536
Esecuzione script sharedfiles - 0.0.0.3 - 00:00:08.3750536
Configurazione caratteristica Files Condivisi - 00:00:08.4063038
Esecuzione script surveyfeature - 0.0.1.1 - 00:00:08.4063038
Esecuzione script surveyfeature - 0.0.1.2 - 00:00:08.5000544
Esecuzione script surveyfeature - 0.0.1.3 - 00:00:08.5000544
Esecuzione script surveyfeature - 0.0.1.4 - 00:00:08.5000544
Configurazione caratteristica Indagine - 00:00:08.5156795
Esecuzione script webstore - 0.0.0.1 - 00:00:08.5156795
Esecuzione script webstore - 0.0.0.2 - 00:00:09.0938082
Esecuzione script webstore - 0.0.0.3 - 00:00:09.0938082
Esecuzione script webstore - 0.0.0.4 - 00:00:09.0938082
Esecuzione script webstore - 0.0.0.5 - 00:00:09.1406835


System.Data.SqlClient.SqlException: Invalid object name 'MSSql31184.sysobjects'. in System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) in System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) in System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) in System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) in System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) in System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) in System.Data.SqlClient.SqlCommand.ExecuteNonQuery() in mojoPortal.Data.SqlHelper.ExecuteNonQuery(SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters) in mojoPortal.Data.DBPortal.DatabaseHelperRunScript(String script, String overrideConnectionInfo) in mojoPortal.Data.DBPortal.DatabaseHelperRunScript(FileInfo scriptFile, String overrideConnectionInfo) in mojoPortal.Business.DatabaseHelper.RunScript(Guid applicationId, FileInfo scriptFile, String overrideConnectionInfo) - 00:00:09.1563086


Configurazione caratteristica Negozio - 00:00:09.1563086
Configurazione caratteristica Xml/Xsl - 00:00:09.1719337
E' in corso la verifica che tutte le caratteristiche siano installate nei siti server admin... - 00:00:09.1719337
Nessuna pagina trovata, percio' sara' creato un contenuto di default...

7/24/2009 9:59:39 AM
Gravatar
Total Posts 18439

Re: can't install on sql2000 - aruba - with strange message

It looks like its having errors on the scripts for the webstore feature. If you are not going to use webstore you can probably ignore that.

It seems the problem is some checks for existing objects looking in sysobjects table, since it replaced the [dbo]. its getting invalid object because that table really is owned by dbo.

The scripts are located at /Setup/applications/webstore/SchemaUpgradeScripts/mssql

example from the 0.0.0.5.config script:

if exists (select * from [dbo].sysobjects where id = object_id(N'[dbo].[ws_GoogleCheckoutLog_Delete]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[ws_GoogleCheckoutLog_Delete]
GO

maybe could solve it by finding all references to [dbo].sysobjects and change it to dbo.sysobjects so it won't be effected by the replacement. Then try the setup page again it should try to run the script again.

Hope it helps,

Joe

7/24/2009 10:27:52 AM
Gravatar
Total Posts 122

Re: can't install on sql2000 - aruba - with strange message

hi Joe... works GREAT now....

seems all ok... now endly can I begin to work

if you want you can add the site to your list.... (if you will like it.. of course)

www.itawan.it

 

best BEST regards

Michele - Rome

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