MySQL - file missing in the latest download

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/1/2009 8:25:34 PM
zChris
Gravatar
Total Posts 72
View Posts

MySQL - file missing in the latest download

Hi

Am upgrading mojo from 2-2-9-6 to the latest version 2-3-1-0.  Am getting an error and I think it may be due to the download of the mysql files missing the MySql.Data.dll file.  The error is:

My website is down now - help.

Cheers

---------------------------------------

2009-07-01 21:11:33,628 ERROR mojoPortal.Web.Global - 110.175.32.225-en-GB - /setup/Default.aspx
System.IO.FileLoadException: Could not load file or assembly 'MySql.Data, Version=6.0.3.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)
File name: 'MySql.Data, Version=6.0.3.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d'
at mojoPortal.Data.DBBannedIP.IsBanned(String ipAddress)
at mojoPortal.Business.BannedIPAddress.IsBanned(String ipAddress)
at mojoPortal.Web.BannedIPBlockingHttpModule.BeginRequest(Object sender, EventArgs e)
at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].

---------------------------------------

7/2/2009 5:49:41 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: MySQL - file missing in the latest download

Hi Chris,

You were right that  I forgot to include the MySql.Data.dll in the latest package of the mysql data layer. I have corrected and uploaded a new version of the file which includes this dll.

However, I will note something strange about the error is that it mentions the version as 6.0.3.0, but I have never shipped that version, the one included in the package is version 5.2.5.0

I recommend re-download the mojoportal-2-3-1-0-mysqldatalyer-GPL.zip file and copy the MySql.Data.dll into your /bin folder.

Hope it helps,

Joe

7/2/2009 6:07:48 AM
zChris
Gravatar
Total Posts 72
View Posts

Re: MySQL - file missing in the latest download

I've downloaded the mysql aqain and uploaded to website, cleared the error log then tried to run setup again - same sort of errors.

I have upgraded to the latest version - made sure that everything copied across via FTP - everything except for my custom SKIN.

----------------------------

2009-07-02 06:59:57,457 ERROR mojoPortal.Web.Global - 110.175.32.225-en-GB - /setup/Default.aspx
System.IO.FileLoadException: Could not load file or assembly 'MySql.Data, Version=6.0.3.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)
File name: 'MySql.Data, Version=6.0.3.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d'
at mojoPortal.Data.DBBannedIP.IsBanned(String ipAddress)
at mojoPortal.Business.BannedIPAddress.IsBanned(String ipAddress)
at mojoPortal.Web.BannedIPBlockingHttpModule.BeginRequest(Object sender, EventArgs e)
at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].

2009-07-02 07:03:32,318 INFO mojoPortal.Web.Global - Global.asax.cs Application_End
2009-07-02 07:05:09,741 INFO mojoPortal.Web.Global - Application Started.
2009-07-02 07:05:11,162 ERROR mojoPortal.Web.Global - 110.175.32.225-en-AU - /setup/Default.aspx
System.IO.FileLoadException: Could not load file or assembly 'MySql.Data, Version=6.0.3.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)
File name: 'MySql.Data, Version=6.0.3.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d'
at mojoPortal.Data.DBTaskQueue.DeleteCompleted()
at mojoPortal.Business.TaskQueue.DeleteCompleted()
at mojoPortal.Web.WebTaskManager.StartOrResumeTasks(Boolean appWasRestarted)
at mojoPortal.Web.Global.StartOrResumeTasks()
at mojoPortal.Web.Global.Application_Start(Object sender, EventArgs e)

WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].
 

7/2/2009 6:17:44 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: MySQL - file missing in the latest download

Appologies Chris,

I just looked at the source code to check the version we are referencing and it is 6.0.3.0, so I put the wrong version of MySql.Data.dll in the package. I've corrected it and uploaded it again, just get the new MySql.Data.dll.

What happened was that in the source code I have an _libs folder which contained the old version of MySql.Data.dll but I had forgotten that I had the new version at _libs\mysql603, and this is the one we are using but I had got the old one and added it to the package.

The new dll should solve it. Again appologies.

Best,

Joe 

7/2/2009 6:27:23 AM
zChris
Gravatar
Total Posts 72
View Posts

Re: MySQL - file missing in the latest download

That almost did the trick - started setup and now get this on the setup page. 

 

---------------------

Unexpected XML declaration. The XML declaration must be the first node in the document, and no white space characters are allowed to appear before it. Line 39, position 3.
Source:System.Xml
Stack Trace at System.Xml.XmlTextReaderImpl.Throw(Exception e) at System.Xml.XmlTextReaderImpl.Throw(String res, String arg) at System.Xml.XmlTextReaderImpl.ParsePI(BufferBuilder piInDtdStringBuilder) at System.Xml.XmlTextReaderImpl.ParseDocumentContent() at System.Xml.XmlTextReaderImpl.Read() at System.Xml.XmlLoader.LoadNode(Boolean skipOverWhitespace) at System.Xml.XmlLoader.LoadDocSequence(XmlDocument parentDoc) at System.Xml.XmlLoader.Load(XmlDocument doc, XmlReader reader, Boolean preserveWhitespace) at System.Xml.XmlDocument.Load(XmlReader reader) at System.Xml.XmlDocument.Load(String filename) at mojoPortal.Web.ContentFeatureConfiguration.GetConfig(String applicationFolderName) at mojoPortal.Web.UI.Pages.SetupHome.SetupFeatures(String applicationName) at mojoPortal.Web.UI.Pages.SetupHome.RunSetup() at mojoPortal.Web.UI.Pages.SetupHome.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

7/2/2009 6:30:59 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: MySQL - file missing in the latest download

This means you have more corrupt files. 

Each feature has an xml config file located at

/Setup/applications/[featurename]/FeatureDefinitions/

at least one of those files must be mangled like that other xml file was.

Hope it helps,

Joe

7/2/2009 7:03:05 AM
zChris
Gravatar
Total Posts 72
View Posts

Re: MySQL - file missing in the latest download

That was it - all working now - thanks for your quick replies. 

Still have my issue of mail not being sent.  Its the correct SMTP - is there another way of testing this - the usual contact us page is not sending them - same as the form wizard pro forms not sending an email

Cheers

7/2/2009 7:12:04 AM
zChris
Gravatar
Total Posts 72
View Posts

Re: MySQL - file missing in the latest download

Sorry for the hassle on this - but I just found some test code which I created an aspx page on the root of the website and put in the smtp settings as per what I have in the user.config and web.config files and the email was sent no problem and received.  Wondering if there is something else that I have missed or is wrong. 

Cheers Chris

7/2/2009 7:12:44 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: MySQL - file missing in the latest download

If you are not seeing smtp related errors in the log then it means as far as the code knows it is sending the email so it possibly blocked somehow upstream from there after its sent. Like if its relaying through your hosts email system it could be droping messages based on permissions or configuration of some kind on their end.

If its logging errors then the smtp settings are not working or not correct.

Hope it helps,

Joe

7/2/2009 7:18:29 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: MySQL - file missing in the latest download

In the latest version I changed this setting to true where it used to be false by default:

<add key="DisableDotNetOpenMail" value="true" />

So previously by default we were using the DotNetOpenMail library to send mail and now by default we are just using the built in ASP.NET System.Net.Mail library.

You might experiment with that setting and see if it helps. Generally it should work the same with either setting though. The reason we changed back to use the normal .NET version is because of issues sending mail in other languages, the .NET version seems to do better at getting the encoding right.

Make sure the default from address in site settings is the same address as the smtp settings.

Hope it helps,

Joe 

7/2/2009 7:20:03 AM
zChris
Gravatar
Total Posts 72
View Posts

Re: MySQL - file missing in the latest download

No idea why - but its working now - I did try and send a contact form email and used the same email address on the form as per the settings in the config file and never got an email but when I tried a different email address on the form it worked.  Oh well.

Thanks again for your help 

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