Newsletter function

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/2/2009 1:28:36 PM
Gravatar
Total Posts 20

Re: Newsletter function

I uploaded web.config again. And that seemed to get the task queue on track again. I now have:

WebTaskManager 11/2/2009 8:26:55 PM 11/2/2009 8:26:56 PM 11/2/2009 8:26:59 PM 50% Running
App Keep Alive Task 11/2/2009 8:26:52 PM 11/2/2009 8:26:59 PM 11/2/2009 8:26:59 PM 0% Started
2010 Mailer 11/2/2009 8:25:37 PM 11/2/2009 8:25:40 PM 11/2/2009 8:25:40 PM 0% Started
App Keep Alive Task 11/2/2009 8:23:35 PM 11/2/2009 8:23:39 PM 11/2/2009 8:23:49 PM 0% Running

11/2/2009 1:53:38 PM
Gravatar
Total Posts 18439

Re: Newsletter function

Hi,

I would take the web site offline by creating an app_offline.htm file and put it in the root. This way no more tasks will be created while you delete the existing ones. Then delete all rows from mp_TaskQueue, then download and upload your Web.config then remove the app_offline.htm file.

I do not have a preview available for MySql but maybe I can prepare one for you tomorrow.

Hope it helps,

Joe

11/2/2009 3:35:04 PM
Gravatar
Total Posts 18439

Re: Newsletter function

Hi,

I just uploaded a new build on our Novell Forge download page, mojoportal-mssql-build-2009-11-02.zip and I also uploaded a corresponding MySql Data layer mysqldatalayer-GPL-build-2009-11-02.zip

Please try upgrading to this build and see if it solves the problem, you may need to purge the mp_TaskQueue table again after upgrading.

This build is very close to a final release and you will be able to upgrade to the final release from this build.

Hope it helps,

Joe

11/3/2009 6:59:05 AM
Gravatar
Total Posts 20

Re: Newsletter function

Tried the suggestion about app_offline.htm aso. That changed the picture. Now a mailer task is generated and also run (ei. it dissapears from the queue). But the mails are still not send.

I'm gonna try with the preview build.

I'll  be back ;-)

11/3/2009 7:45:25 AM
Gravatar
Total Posts 20

Re: Newsletter function

Argh! After upgrading to the preview I get this when I try to load the hp:

Welcome to mojoPortal Setup

 

Probing system...

File system permissions ok.

MySQL database connection ok.

database permissions are sufficient to alter schema.

database initial schema already exists.

database core schema needs upgrade.

1 site(s) found.

This site appears to be running in a secured environment using Medium Trust policy or at least lower than Full Trust.

In order to use MySQL under Medium Trust, The MySQL Connector for .NET must be installed in the Global Assembly Cache on the server. If you see a SecurityException in the error message then the Connector is not installed. You can download the MySql Connector for .NET from here: http://dev.mysql.com/downloads/connector/net/5.0.html

 

 

Running script mojoportal-core - 2.3.2.0 - 00:00:00.2031250

MySql.Data.MySqlClient.MySqlException: Duplicate column name 'SubscribeGuid' at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId) at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet() at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery() at MySql.Data.MySqlClient.MySqlScript.Execute() 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) - 00:00:00.2187500

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.



11/3/2009 7:53:52 AM
Gravatar
Total Posts 18439

Re: Newsletter function

Hi,

That is very strange. Maybe you can solve it by chopping this part out of the /Setup/applications/mojoportal-core/SchemaUpgradeScripts/mysql/2.3.2.0.config file

 

ALTER TABLE mp_LetterSendLog ADD COLUMN `SubscribeGuid` char(36);
UPDATE mp_LetterSendLog
SET SubscribeGuid = '00000000-0000-0000-0000-000000000000';
CREATE INDEX idxSendLogsGuid ON mp_LetterSendLog(`SubscribeGuid`);

ALTER TABLE mp_LetterSendLog ADD COLUMN `SubscribeGuid` char(36);
UPDATE mp_LetterSendLogSET SubscribeGuid = '00000000-0000-0000-0000-000000000000';
CREATE INDEX idxSendLogsGuid ON mp_LetterSendLog(`SubscribeGuid`);

but I do not understand how that column could already exist in your installation as it does not exist in any previous script.

Since it is trying to run the script I think you can ignore th warning about medium trust as the MySql Connector must be in the GAC. It may be best to delete the MySql.Data.dll from the bin folder if it is using the one from the GAC.

Hope it helps,

Joe

 

11/3/2009 9:54:54 AM
Gravatar
Total Posts 20

Re: Newsletter function

Well then it just continues with an error on the next table in the same file:

Running script mojoportal-core - 2.3.2.0 - 00:00:00.0781250

MySql.Data.MySqlClient.MySqlException: Table 'mp_LetterSubscribe' already exists at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId) at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet() at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery() at MySql.Data.MySqlClient.MySqlScript.Execute() 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) - 00:00:00.0937500

 

The frontpage looks like a mess: http://herreski.culmsee.dk

 

Is there any way of going back? I prefer to do without the newsletter function and have the rest working ;-)

11/3/2009 10:03:54 AM
Gravatar
Total Posts 18439

Re: Newsletter function

Only way to go back is if you made a backup of your site and db before upgrading. Or if you at least have a db backup you can delete the setup folder to get rid of newer version scripts, re-deploy version 2.3.1.9 and then restore your db.

However I do not understand how it can report an existing table when this is a new table not in any existing script.

You are actually the only one I know of running mojoPortal in Medium Trust with MySql. I don't see how that can make it see a table that has not been created as existing. 

I am sorry you are having these difficulties but I have no clue about these strange errors. I would look in the db and see if the table does exist and see if the mp_SendLog table has a column SubscribeGuid as reported in the previous error.

mojoPortal.com is running on MySql and went through this upgrade with no issues at all.

Best,

Joe

11/3/2009 10:15:35 AM
Gravatar
Total Posts 20

Re: Newsletter function

There is a SubscribeGuid in the mp_LetterSendLog. Also the table mp_LetterSubscribe and mp_LetterSubscribeHx (mentioned in 2.3.2.0.config) are both in the db.

But maybee it is suposed to give this error when I rerun the Setup?

Still the site is not functioning :-(

 

Jacob :o)

11/3/2009 10:19:28 AM
Gravatar
Total Posts 18439

Re: Newsletter function

After it runs a script it updates the schema version in the mp_SchemaVersion table according to the script version this way it should never run the same script more than once. You could look for the row for mojoportal-core in the mp_SchemaVersion folder and change it to 2.3.2.0 then it should move on to run the 2.3.2.1 and higher scripts.

Hope it helps,

Joe

11/3/2009 10:21:33 AM
Gravatar
Total Posts 20

Re: Newsletter function

Maybee I should try to install the previous version again and spend some time restoring what is lost because I didn't make the db backup.

Where is the pages I generated saved? Maybee theese tables can bee copied back into a new installation of the previous version? I just made some html and google maps.

 

Jacob :o)

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