So I finally had some time to implement 4.1 Beta II in a test
site. For various reasons I decided to use MySQL. I'm
still running it through the paces, but here are some quick notes
on my implementation experience.
Install
After copying the files to my test site location (shared
hosting) and setting the permissions I tried to browse to the site
to initialize the install scripts. Unfortunately I
immediately received a number of errors which some of the postings
on our.umbraco.org indicated were related to the medium trust
install even though no trust settings were set and the Umbraco
Setting [umbracoUseMediumTrust] was set to false. As my host allows
full trust I added a <trust level="Full" /> tag and was
fine.
The rest of the configuration went as it usually does and I was
able to successfully install the Umbraco Instance.
Site Setup
After install I immediately started adding Document Types and
Templates and installing my favorite Packages. Everything
went smoothly until I tried to add my home page to the
content. The UI generated an error bubble regarding a missing
table.
It turns out that the install scripts for the 4.1 Beta II for
MySQL are missing the Create Table calls for the CMSPREVIEWXML
table. So I took the MSSQL scripts and ported the related
calls to MySQL so I could run them there. Below is my
script. Be aware that it is probably not the official Umbraco
version that they will have in the final install, but it seems to
have worked for me.
CREATE TABLE CMSPREVIEWXML(
nodeId int NOT NULL,
versionId CHAR(36) NOT NULL,
timestamp DATETIME NOT NULL,
xml LONGTEXT NOT NULL
);
ALTER TABLE CMSPREVIEWXML ADD CONSTRAINT PK_cmsContentPreviewXml PRIMARY KEY CLUSTERED (nodeId, versionId);
Installing Packages
One final note is that not every package will work with version
4.1 Beta II. Make sure you test any package you add while you
are playing with Beta II.