Version 20050409 enhanced menu

This is just a minor release. I had a request in the forums about not all the properties for skmMenu working. I just had not exposed them all as properties on SiteMenu which wraps around skmMenu and populates it from the db.

The only files that have changed since version 20040403 are the dll files in the bin folder. Backup your originals and replace the files. you may need to re-start apache.

The full set of properties with defaults for the menu are as follows:

SiteMenu id="SiteMenu1" runat="server" Direction="Vertical"
MenuGridLines="Both"
BorderColor="DarkRed"
BorderWidth="1"
MenuBorderStyle="Solid"
Opacity="100"
MenuFadeDelay="1"
ItemSpacing="0"
ItemPadding="2"
DefaultCssClass=""
CssClass="MainMenu"
SelectedItemCssClass="SelectedMenuItems"
OtherItemCssClass="OtherMenuItems"
DefaultMouseDownCssClass=""
DefaultMouseOverCssClass="MainMenuMouseOver"
DefaultMouseUpCssClass=""
SubMenuCssClass=""
HighlightTopMenu="True"
ClickToOpen="False"
ZIndex="100"


These can be set in the skin file.

Version 20050407 Bug Fix Release

I just released a new set of deployment binary packages. The only files that have changed are the dlls in the bin folder.  Its available now on the download page.

The following bugs were fixed.

RSS Feed module didn't work unless the date time format was in GMT

The Register Link was using https even when SSLIsAvailable was set to false.

In the MySQL version, there was a bug in the Gallery that would only effect Galleries not configured in  Compact Mode. This bug was introduced in the upgrade from ByteFX to the newer MySQL Connector.

I recommend you back up your current dlls then replace them with the new ones. You may need to restart apache.

Release 20050403 alpha is now available

A new release is now available on the Download page.

This release includes a new data layer for PostgreSQL thanks to Joseph Hill of GotMono.com.  Now mojoPortal supports MS SQL, MySQL, and PostgreSQL!  The demo sites are now using the PostgreSQL data layer.

Also with big thanks to Joseph, a new RSS Feed Aggregator Module is included.  It is based on the sample code that Joseph sent me from his GotMono blogs.  It is very configurable including settings for Cache Time, age of posts to include, number of  posts per feed, etc.  You can put one on as many pages as you like and show 1 or many feeds in each one.  You can configure whether to show or hide the Feed list and the RSS links. You can configure the Feed list links to go either to the web site associated with the feed or as a filter on the current display

The MySQL data layer has been upgraded from the ByteFX data provider to the newer  MySQL Connector for .NET

As always if you have any trouble please post in the forums.


I also updated Mono on my server to the latest build from svn

Upgrading from ByteFX to the .NET Connector for MySQL

Last night I made the switch from the older ByteFX Data provider for MySQL to the newer  .NET Connector for MySQL.  It required some code changes in the MySQL data layer. 

For Example, anywhere I was using parameters like @SiteID, they had to be changed to ?SiteID except in places where the parameter is not being passed in but used in SQL with a SET statement .

In this line:
SET @PageLowerBound = (?PageSize * ?PageNumber) - ?PageSize

?PageSize and ?PageNumber are passed in but @PageLowerBound is not and it wouldn't work if I used ? instead of @

Another difference is in ByteFx you have only one data type for int MySqlDbType.Int whereas in the newer .NET Connector you have MySqlDbType.Int16, MySqlDbType.Int24, MySqlDbType.Int32, and MySqlDbType.Int64 and it won't work with just MySqlDbType.Int so you have to change the code.

I wasn't having any problems with the ByteFX provider myself but a few people have posted in the forums and been unable to connect using ByteFX with their specific version of MySQL. One person tried switching to the .NET Connector and then was able to connect but of course without the code changes described above it did not work for him either.  Hopefully this change will eliminate any problems some users were having with the MySQL version of mojoPortal.  It will be included in tomorrow's release.

Another user reported problems with losing special characters when data was saved to the database.  He was working with Portuguese content and it worked correctly in Text fields populated using the FCKeditor but did not work correctly with VarChar fields populated using normal text boxes.  I don't know if this change will fix that problem but I hope so.

Other gotchas I have observed with ByteFX and .NET Connector when building on Windows and deploying on mono you get the dreaded "File Not Found error" which would more accurately be described as "Couldn't load assembly".  This is caused because these data providers are shipped with a pre-comiled version of sharpziplib that was built using incremental build.  This problem is easily overcome by obtaining the source code for sharpziplib and compiling it myself with full Re-Build.  By doing this I have no problems compiling on Windows with VS.NET and deploying on mono.
 

A New Release this Sunday

I'm planning a new release this sunday. 

New things to look forward to include support for PostgreSQL thanks to Joseph Hill of GotMono.com.  Also with much thanks to Joseph Hill, a new RSS Feed Aggregation module to allow you to show one or many feeds on a page.  Joseph sent me the code he is currently using on GotMono.com for the bloggers page and I turned it into a module that can be plugged into any page in a mojoPortal site.  You can configure the cache time, the maximum age of posts to show and a maximum number of posts to show per feed and a few other settings.

Also a few bug fixes and improvements.