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/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.