update

This is the place to report bugs and get support. When posting in this forum, please always provide as much detail as possible.

Please do not report problems with a custom build or custom code in this forum. If you are producing your own build from the source code and have problems or questions, ask in the developer forum, do not report it as a bug.

This is the place to report bugs and get support

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.
Please do not report problems with a custom build or custom code in this forum. If you are producing your own build from the source code and have problems or questions, ask in the developer forum.
This thread is closed to new posts. You must sign in to post in the forums.
3/21/2013 5:38:07 AM
hamidzebel63
Gravatar
Total Posts 20
View Posts

update

i want to update to Version: 2.3.9.6

i use , sql sever

i upload all file

but i have problem :   downloadpaper.ir


database permissions are sufficient to alter schema.
database initial schema already exists.
database core schema needs upgrade.
3سایت پیدا شد
درحال اجرای اسکریپت mojoportal-core - 2.2.1.9 - 00:00:02.4959680
System.Data.SqlClient.SqlException (0x80131904): Either the parameter @objname is ambiguous or the claimed @objtype (COLUMN) is wrong. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at mojoPortal.Data.SqlHelper.ExecuteNonQuery(SqlTransaction transaction, CommandType commandType, String commandText, Int32 commandTimeout, 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) ClientConnectionId:c79a32c4-30da-4451-a7df-143bd63e9359 - 00:00:03.2291586
Note: This page shows some information that is helpful during setup and upgrades but for security it would be best not to show any information when the system is up to date. You can disable setup and suppress all information on this page by setting DisableSetup=true in Web.config. When you need to upgrade, you can set this back to false. If you are logged in as Administrator setup will run and you will be able to see this page even if it is disabled in Web.config so you can easily leave it disabled and just login before upgrading. But if you are not logged in you will need to enable setup in Web.config

3/21/2013 6:39:24 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: update

To solve this problem we need to know the contents of mp_SchemaVersion and mp_SchemaScriptHistory tables

Whatever version is the highest version for mojoportal-core in mp_SchemaScriptHistory, the same version needs to be in mp_SchemaVersion so that it only tries to run newer scripts. it should never run the script 2.2.1.9 unless upgrading from a very very old version of mojoPortal. Something is not correct in the mp_SchemaVersion table so it is trying to run old scripts that it should not try to run.

3/21/2013 7:21:45 AM
hamidzebel63
Gravatar
Total Posts 20
View Posts

Re: update

previous version mojoportal was :
mojoPortal 2.3.5.8 MSSQL

 

mp_SchemaVersion :

8bdb352a-b566-4401-a2db-04f541f01a39 feed-manager 0 0 1 0
1097035e-a126-4c1f-bf13-1d0c36c4cad9 blog 0 0 2 0
4868b5e4-10a5-4884-9c16-2d37ffc81ae2 imagegallery 0 0 0 8
e91249c4-767d-4187-9cae-2e6c54c6116c eventcalendar 0 0 0 6
077e4857-f583-488e-836e-34a4b04be855 mojoportal-core 2 2 1 8
a8132d7d-b3ea-4823-aa10-40fef98b8e69 webstore 0 0 7 0
31a72abb-859a-4ecb-823c-7e6d9d202803 contactform 0 0 0 6
cc6663de-e6c6-408a-ac5f-a13e2c9e316b sharedfiles 0 0 1 0
04bfdb45-f2fb-4493-bc65-b0c96a5e2d4c surveyfeature 0 0 1 7
f3b0ed7e-3b7c-4331-9ef3-c27863b61180 pollfeature-byChristianFredh 0 0 0 5
1c63a8bd-4f85-4034-8557-d2d2d15a12fd forums 0 0 2 0
8c3ee75e-3d90-4ce4-a25a-f797305cf40e linksmodule 0 0 0 9
NULL NULL NULL NULL NULL NULL

mp_SchemaScriptHistory :

 

1    077e4857-f583-488e-836e-34a4b04be855    2.3.4.8.config    09/16/2010 01:56:23 ق.ظ    False
2    077e4857-f583-488e-836e-34a4b04be855    2.3.4.9.config    09/16/2010 01:56:23 ق.ظ    False
3    077e4857-f583-488e-836e-34a4b04be855    2.3.5.0.config    09/16/2010 01:56:23 ق.ظ    False
4    077e4857-f583-488e-836e-34a4b04be855    2.3.5.1.config    09/16/2010 01:56:23 ق.ظ    False
5    1097035e-a126-4c1f-bf13-1d0c36c4cad9    0.0.1.8.config    09/16/2010 01:57:05 ق.ظ    False
6    1097035e-a126-4c1f-bf13-1d0c36c4cad9    0.0.1.9.config    09/16/2010 01:57:05 ق.ظ    False
7    31a72abb-859a-4ecb-823c-7e6d9d202803    0.0.0.5.config    09/16/2010 01:57:05 ق.ظ    False
8    e91249c4-767d-4187-9cae-2e6c54c6116c    0.0.0.5.config    09/16/2010 01:57:06 ق.ظ    False
9    8bdb352a-b566-4401-a2db-04f541f01a39    0.0.0.9.config    09/16/2010 01:57:06 ق.ظ    False
10    1c63a8bd-4f85-4034-8557-d2d2d15a12fd    0.0.1.6.config    09/16/2010 01:57:07 ق.ظ    False
11    1c63a8bd-4f85-4034-8557-d2d2d15a12fd    0.0.1.7.config    09/16/2010 01:57:07 ق.ظ    False
12    4868b5e4-10a5-4884-9c16-2d37ffc81ae2    0.0.0.7.config    09/16/2010 01:57:07 ق.ظ    False
13    8c3ee75e-3d90-4ce4-a25a-f797305cf40e    0.0.0.7.config    09/16/2010 01:57:07 ق.ظ    False
14    f3b0ed7e-3b7c-4331-9ef3-c27863b61180    0.0.0.5.config    09/16/2010 01:57:08 ق.ظ    False
15    cc6663de-e6c6-408a-ac5f-a13e2c9e316b    0.0.0.9.config    09/16/2010 01:57:08 ق.ظ    False
16    04bfdb45-f2fb-4493-bc65-b0c96a5e2d4c    0.0.1.7.config    09/16/2010 01:57:09 ق.ظ    False
17    a8132d7d-b3ea-4823-aa10-40fef98b8e69    0.0.6.9.config    09/16/2010 01:57:11 ق.ظ    False
18    077e4857-f583-488e-836e-34a4b04be855    2.3.5.2.config    11/26/2010 10:03:35 ب.ظ    False
19    077e4857-f583-488e-836e-34a4b04be855    2.3.5.3.config    11/26/2010 10:03:35 ب.ظ    False
20    077e4857-f583-488e-836e-34a4b04be855    2.3.5.4.config    11/26/2010 10:03:35 ب.ظ    False
21    077e4857-f583-488e-836e-34a4b04be855    2.3.5.5.config    11/26/2010 10:03:36 ب.ظ    False
22    1c63a8bd-4f85-4034-8557-d2d2d15a12fd    0.0.1.8.config    11/26/2010 10:03:38 ب.ظ    False
23    a8132d7d-b3ea-4823-aa10-40fef98b8e69    0.0.7.0.config    11/26/2010 10:03:40 ب.ظ    False
24    077e4857-f583-488e-836e-34a4b04be855    2.3.5.6.config    12/16/2010 04:27:54 ب.ظ    False
25    077e4857-f583-488e-836e-34a4b04be855    2.3.5.7.config    12/16/2010 04:27:54 ب.ظ    False
26    077e4857-f583-488e-836e-34a4b04be855    2.3.5.8.config    12/16/2010 04:27:54 ب.ظ    False
27    1097035e-a126-4c1f-bf13-1d0c36c4cad9    0.0.2.0.config    12/16/2010 04:27:56 ب.ظ    False
28    31a72abb-859a-4ecb-823c-7e6d9d202803    0.0.0.6.config    12/16/2010 04:27:57 ب.ظ    False
29    e91249c4-767d-4187-9cae-2e6c54c6116c    0.0.0.6.config    12/16/2010 04:27:57 ب.ظ    False
30    8bdb352a-b566-4401-a2db-04f541f01a39    0.0.1.0.config    12/16/2010 04:27:57 ب.ظ    False
31    1c63a8bd-4f85-4034-8557-d2d2d15a12fd    0.0.1.9.config    12/16/2010 04:27:57 ب.ظ    False
32    1c63a8bd-4f85-4034-8557-d2d2d15a12fd    0.0.2.0.config    12/16/2010 04:27:57 ب.ظ    False
33    4868b5e4-10a5-4884-9c16-2d37ffc81ae2    0.0.0.8.config    12/16/2010 04:27:58 ب.ظ    False
34    8c3ee75e-3d90-4ce4-a25a-f797305cf40e    0.0.0.8.config    12/16/2010 04:27:58 ب.ظ    False
35    8c3ee75e-3d90-4ce4-a25a-f797305cf40e    0.0.0.9.config    12/16/2010 04:27:58 ب.ظ    False
36    cc6663de-e6c6-408a-ac5f-a13e2c9e316b    0.0.1.0.config    12/16/2010 04:27:59 ب.ظ    False
37    077e4857-f583-488e-836e-34a4b04be855    2.2.1.5.config    07/26/2011 07:57:21 ق.ظ    False
38    077e4857-f583-488e-836e-34a4b04be855    2.2.1.6.config    07/26/2011 07:57:22 ق.ظ    False
39    077e4857-f583-488e-836e-34a4b04be855    2.2.1.7.config    07/26/2011 07:57:23 ق.ظ    False
40    077e4857-f583-488e-836e-34a4b04be855    2.2.1.8.config    07/26/2011 07:57:24 ق.ظ    False
NULL    NULL    NULL    NULL    NULL

 


 

3/21/2013 7:35:13 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: update

I don't know how your row for mojoportal-core in mp_SchemaVersion changed to 2.2.1.8 but that is not correct and is causing it to try to run older scripts that it should not run, you need to update it to 2.3.5.8 then visit the setup page again and it should start at upgrade scripts 2.3.5.9

Hope that helps,

Joe

3/29/2013 9:55:00 AM
hamidzebel63
Gravatar
Total Posts 20
View Posts

Re: update

thanks

the problem solved

but i have problem with login

i login but when redirect to default.aspx , it doesn't login

3/29/2013 10:08:57 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: update

please only one question per thread. if you have a new question post a new thread and provide as much detail as possible.

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