A couple of people have emailed me to ask if I could provide them with some info on converting the club starter kit to MySQL. I'm currently recoding stuff a bit for a new website (www.muddevils.be), but soon (within
the next week) I'll put up the original Starter Kit converted for MySQL. It's for version 4.x without the stored procs cause my provider hasn't switched to version 5 yet. For people wanting the version 5, you'll have alter the code yourself a bit (shoulnd't
be that hard to do).
For those wanting to try it yourself, you'll need the mysql provider from nux technologies (google on it) They made a provider out of the 1.0.7 .net connector for .net 2.0. Take the ms access version of starter kit, and convert the aspnet database and the
club-sql database to MySQL (files are in ASP_data directory). Then you'll need to change the different providers in the ASP_Code directory to use your mysql database iso the ms access one. Iso using sqldatasources I changed them to Objectdatasources and made
wrappers for the database tables. It can probably done differently, but that's how I got it working.
I haven't found a way yet to connect the mysql provider into visual studio express though, the provider from nux claims to implement the providerfactory, so there should be a way to do it... If you know let me know :)
I provide this template as is and without any garranty, I got it running on my localhost running MySQL 4.1. I simply converted the existing Club Starter Kit from asp.net, so all the possibly bugs that are in the standard template can still be in here.
Run the sql scripts in App_Data to build the MySQL database, remember to find and replace the name of the database first, (now it is called muddevils-be) and modify the connection string in web.config
Use and alter it as you like, have fun with it.
PS: Drop me a line if you plan on using it, would be nice to know where my code goes to :-)
I am trying to use the mysql version of club site your converted. The first problem is that the downloaded zip file could not be extracted. It appeared the files were corrupted. Could you please create a new zip file? I am eager to try again.
Try it again I just downloaded it and it opens up but there is a problem the person is not using the free MySQL engine, here is a snap short of the tables. Hope this helps.
CREATE TABLE `muddevils-be`.`Albums` (
`albumid` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
`title` VARCHAR(50) NOT NULL DEFAULT '',
`parentid` INTEGER UNSIGNED NOT NULL DEFAULT 0,
`private` BOOLEAN,
`description` LONGTEXT,
`ownerid` INTEGER UNSIGNED NOT NULL DEFAULT 0,
PRIMARY KEY(`albumid`)
)
ENGINE = InnoDB;
I have installedm mysql (version 4.1.21) and running it on my computer. But Istill have the same problem. It mostly complains about the directories: image, bin, app_code, app_data. I can not understand why the zip file won't work.
I will start to use it and see if this will running to any issue. I really appreciate your work converting it. This will save us some money for hosting.
Yes but you are running the free MySQL the code was not for the free one, that is the reason I got into the thread to let you know the free MySQL will not run that code. I hope this explains it.
DROP TABLE IF EXISTS `muddevils-be`.`aspnet_Users`;
CREATE TABLE `muddevils-be`.`aspnet_Users` (
`ApplicationId` INT(10) NULL,
`UserId` INT(10) NOT NULL AUTO_INCREMENT,
`UserName` VARCHAR(255) NULL,
`MobileAlias` VARCHAR(16) NULL,
`IsAnonymous` TINYINT(1) NOT NULL,
`LastActivityDate` DATETIME NULL,
PRIMARY KEY (`UserId`),
UNIQUE INDEX `UserId` (`UserId`),
INDEX `ApplicationId` (`ApplicationId`),
INDEX `aspnet_Applicationsaspnet_Users` (`ApplicationId`),
INDEX `UserName` (`UserName`)
)
ENGINE = INNODB;
DROP TABLE IF EXISTS `muddevils-be`.`aspnet_UsersInRoles`;
CREATE TABLE `muddevils-be`.`aspnet_UsersInRoles` (
`UserId` INT(10) NULL,
`RoleId` INT(10) NULL,
INDEX `aspnet_Rolesaspnet_UsersInRoles` (`RoleId`),
INDEX `aspnet_Usersaspnet_UsersInRoles` (`UserId`),
INDEX `RoleId` (`RoleId`),
INDEX `UserId` (`UserId`)
)
ENGINE = INNODB;
-- -------------------------------------
-- Views
-- DROP VIEW IF EXISTS `muddevils-be`.`vw_aspnet_Applications`;
-- CREATE OR REPLACE VIEW `muddevils-be`.`vw_aspnet_Applications` AS
-- SELECT `aspnet_Applications`.`Description`, `aspnet_Applications`.`ApplicationId`, `aspnet_Applications`.`ApplicationName`
-- FROM aspnet_Applications;
-- DROP VIEW IF EXISTS `muddevils-be`.`vw_aspnet_MembershipUsers`;
-- CREATE OR REPLACE VIEW `muddevils-be`.`vw_aspnet_MembershipUsers` AS
-- SELECT aspnet_Membership.LastPasswordChangedDate, aspnet_Membership.UserId, aspnet_Membership.PasswordFormat, aspnet_Membership.MobilePIN, aspnet_Membership.Email, aspnet_Membership.PasswordQuestion, aspnet_Membership.PasswordAnswer, aspnet_Membership.IsApproved,
aspnet_Membership.LastLoginDate, aspnet_Membership.Comment, aspnet_Users.ApplicationId, aspnet_Users.UserName, aspnet_Users.MobileAlias, aspnet_Users.IsAnonymous, aspnet_Users.LastActivityDate, aspnet_Membership.CreateDate
-- FROM aspnet_Membership INNER JOIN aspnet_Users ON aspnet_Membership.UserId=aspnet_Users.UserId;
-- DROP VIEW IF EXISTS `muddevils-be`.`vw_aspnet_Profiles`;
-- CREATE OR REPLACE VIEW `muddevils-be`.`vw_aspnet_Profiles` AS
-- SELECT (Len(aspnet_Profile.PropertyValuesString)+Len(aspnet_Profile.PropertyNames)), aspnet_Profile.LastUpdatedDate, aspnet_Profile.UserId
-- FROM aspnet_Profile;
-- DROP VIEW IF EXISTS `muddevils-be`.`vw_aspnet_Roles`;
-- CREATE OR REPLACE VIEW `muddevils-be`.`vw_aspnet_Roles` AS
-- SELECT `aspnet_Roles`.`Description`, `aspnet_Roles`.`RoleName`, `aspnet_Roles`.`RoleId`, `aspnet_Roles`.`ApplicationId`
-- FROM aspnet_Roles;
-- DROP VIEW IF EXISTS `muddevils-be`.`vw_aspnet_Users`;
-- CREATE OR REPLACE VIEW `muddevils-be`.`vw_aspnet_Users` AS
-- SELECT `aspnet_Users`.`LastActivityDate`, `aspnet_Users`.`IsAnonymous`, `aspnet_Users`.`MobileAlias`, `aspnet_Users`.`UserName`, `aspnet_Users`.`UserId`, `aspnet_Users`.`ApplicationId`
-- FROM aspnet_Users;
-- DROP VIEW IF EXISTS `muddevils-be`.`vw_aspnet_UsersInRoles`;
-- CREATE OR REPLACE VIEW `muddevils-be`.`vw_aspnet_UsersInRoles` AS
-- SELECT `aspnet_UsersInRoles`.`RoleId`, `aspnet_UsersInRoles`.`UserId`
-- FROM aspnet_UsersInRoles;
-- DROP VIEW IF EXISTS `muddevils-be`.`vw_aspnet_WebPartState_Paths`;
-- CREATE OR REPLACE VIEW `muddevils-be`.`vw_aspnet_WebPartState_Paths` AS
-- SELECT aspnet_Paths.Path, aspnet_Paths.PathId, aspnet_Paths.ApplicationId
-- FROM aspnet_Paths;
-- DROP VIEW IF EXISTS `muddevils-be`.`vw_aspnet_WebPartState_Shared`;
-- CREATE OR REPLACE VIEW `muddevils-be`.`vw_aspnet_WebPartState_Shared` AS
-- SELECT aspnet_PagePersonalizationAllUsers.LastUpdatedDate, Len(aspnet_PagePersonalizationAllUsers.PageSettings), aspnet_PagePersonalizationAllUsers.PathId
-- FROM aspnet_PagePersonalizationAllUsers;
-- DROP VIEW IF EXISTS `muddevils-be`.`vw_aspnet_WebPartState_User`;
-- CREATE OR REPLACE VIEW `muddevils-be`.`vw_aspnet_WebPartState_User` AS
-- SELECT aspnet_PagePersonalizationPerUser.LastUpdatedDate, Len(aspnet_PagePersonalizationPerUser.PageSettings), aspnet_PagePersonalizationPerUser.UserId, aspnet_PagePersonalizationPerUser.PathId
-- FROM aspnet_PagePersonalizationPerUser;
lucifer
Member
65 Points
13 Posts
MySQL version of Club Starter kit
Aug 28, 2006 08:51 AM|LINK
A couple of people have emailed me to ask if I could provide them with some info on converting the club starter kit to MySQL. I'm currently recoding stuff a bit for a new website (www.muddevils.be), but soon (within the next week) I'll put up the original Starter Kit converted for MySQL. It's for version 4.x without the stored procs cause my provider hasn't switched to version 5 yet. For people wanting the version 5, you'll have alter the code yourself a bit (shoulnd't be that hard to do).
For those wanting to try it yourself, you'll need the mysql provider from nux technologies (google on it) They made a provider out of the 1.0.7 .net connector for .net 2.0. Take the ms access version of starter kit, and convert the aspnet database and the club-sql database to MySQL (files are in ASP_data directory). Then you'll need to change the different providers in the ASP_Code directory to use your mysql database iso the ms access one. Iso using sqldatasources I changed them to Objectdatasources and made wrappers for the database tables. It can probably done differently, but that's how I got it working.
I haven't found a way yet to connect the mysql provider into visual studio express though, the provider from nux claims to implement the providerfactory, so there should be a way to do it... If you know let me know :)
lucifer
Member
65 Points
13 Posts
Re: MySQL version of Club Starter kit
Sep 06, 2006 08:22 PM|LINK
Template is temporarly available at http://www.pxlstudio.be/templates/ClubStarterKitforMySQL.zip
I'l leave it online for a couple of days/weeks until I need the space.
I provide this template as is and without any garranty, I got it running on my localhost running MySQL 4.1. I simply converted the existing Club Starter Kit from asp.net, so all the possibly bugs that are in the standard template can still be in here.
Run the sql scripts in App_Data to build the MySQL database, remember to find and replace the name of the database first, (now it is called muddevils-be) and modify the connection string in web.config
Use and alter it as you like, have fun with it.
PS: Drop me a line if you plan on using it, would be nice to know where my code goes to :-)
wendyzhang
Member
50 Points
10 Posts
Re: MySQL version of Club Starter kit
Sep 10, 2006 07:10 PM|LINK
Lucifier,
I am trying to use the mysql version of club site your converted. The first problem is that the downloaded zip file could not be extracted. It appeared the files were corrupted. Could you please create a new zip file? I am eager to try again.
Thanks a lot!
Wendy
Caddre
All-Star
26581 Points
5308 Posts
Re: MySQL version of Club Starter kit
Sep 10, 2006 07:24 PM|LINK
Try it again I just downloaded it and it opens up but there is a problem the person is not using the free MySQL engine, here is a snap short of the tables. Hope this helps.
CREATE TABLE `muddevils-be`.`Albums` (
`albumid` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
`title` VARCHAR(50) NOT NULL DEFAULT '',
`parentid` INTEGER UNSIGNED NOT NULL DEFAULT 0,
`private` BOOLEAN,
`description` LONGTEXT,
`ownerid` INTEGER UNSIGNED NOT NULL DEFAULT 0,
PRIMARY KEY(`albumid`)
)
ENGINE = InnoDB;
CREATE TABLE `muddevils-be`.`Announcements` (
`id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
`itemdate` DATETIME NOT NULL DEFAULT 0,
`title` LONGTEXT NOT NULL DEFAULT '',
`description` LONGTEXT,
`staticURL` LONGTEXT,
`photo` INTEGER UNSIGNED DEFAULT 0,
`albumid` INTEGER UNSIGNED,
PRIMARY KEY(`id`)
)
ENGINE = InnoDB;
CREATE TABLE `muddevils-be`.`Events` (
`id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
`starttime` DATETIME NOT NULL DEFAULT 0,
`endtime` DATETIME NOT NULL DEFAULT 0,
`title` LONGTEXT NOT NULL DEFAULT '',
`description` LONGTEXT NOT NULL DEFAULT '',
`staticURL` LONGTEXT,
`location` INTEGER UNSIGNED NOT NULL DEFAULT 0,
`photo` INTEGER UNSIGNED NOT NULL DEFAULT 0,
`album` INTEGER UNSIGNED NOT NULL DEFAULT 0,
PRIMARY KEY(`id`)
)
ENGINE = InnoDB;
CREATE TABLE `muddevils-be`.`Locations` (
`id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
`title` LONGTEXT NOT NULL DEFAULT '',
`description` LONGTEXT,
`linkURL` LONGTEXT,
`photo` INTEGER UNSIGNED NOT NULL DEFAULT 0,
`directions` LONGTEXT,
`address` LONGTEXT,
PRIMARY KEY(`id`)
)
ENGINE = InnoDB;
CREATE TABLE `muddevils-be`.`MemberInfo` (
`address` LONGTEXT,
`phone` VARCHAR(50),
`firstname` VARCHAR(50),
`lastname` VARCHAR(50),
`avatar` BLOB,
`memberid` INTEGER UNSIGNED NOT NULL DEFAULT 0,
`filesize` INTEGER UNSIGNED
PRIMARY KEY(`memberid`)
)
ENGINE = InnoDB;
CREATE TABLE `muddevils-be`.`images` (
`id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
`title` VARCHAR(50),
`data` MEDIUMBLOB NOT NULL DEFAULT '',
`notes` LONGTEXT,
`filesize` INTEGER UNSIGNED NOT NULL DEFAULT 0
PRIMARY KEY(`id`)
)
ENGINE = InnoDB;
Gift Peddie
wendyzhang
Member
50 Points
10 Posts
Re: MySQL version of Club Starter kit
Sep 10, 2006 10:33 PM|LINK
Thank you so much for reponsing quickly.
I have installedm mysql (version 4.1.21) and running it on my computer. But Istill have the same problem. It mostly complains about the directories: image, bin, app_code, app_data. I can not understand why the zip file won't work.
I will start to use it and see if this will running to any issue. I really appreciate your work converting it. This will save us some money for hosting.
Wendy
Caddre
All-Star
26581 Points
5308 Posts
Re: MySQL version of Club Starter kit
Sep 10, 2006 11:29 PM|LINK
Gift Peddie
wendyzhang
Member
50 Points
10 Posts
Re: MySQL version of Club Starter kit
Sep 11, 2006 02:56 AM|LINK
I have got your mysql version of club kit working at my computer. Many thanks!
But when I deployed it to the hosting site - godaddy.com, there was a problem:
"That assembly does not allow partially trusted callers."
I wonder if this is caused by the dlls. Can you compile the dlls with "AllowPartiallyTrustedCallers"?
https://support.isqsolutions.com/article.aspx?id=10334
Thanks again!
Wendy
wendyzhang
Member
50 Points
10 Posts
Re: MySQL version of Club Starter kit
Sep 11, 2006 09:00 PM|LINK
I have recompiled MySql.Data.dll with AllowPartiallyTrustedCallers and it worked on GoDaddy.com.
Thank you so much!
Wendy
Caddre
All-Star
26581 Points
5308 Posts
Re: MySQL version of Club Starter kit
Sep 11, 2006 10:59 PM|LINK
I did not do anything and I am happy you got it working. Here is the membership code if anybody else want to use it.
-- ----------------------------------------------------------------------
-- MySQL Migration Toolkit
-- SQL Create Script
-- ----------------------------------------------------------------------
SET FOREIGN_KEY_CHECKS = 0;
CREATE DATABASE IF NOT EXISTS `muddevils-be`
CHARACTER SET latin1 COLLATE latin1_swedish_ci;
-- -------------------------------------
-- Tables
DROP TABLE IF EXISTS `muddevils-be`.`aspnet_Applications`;
CREATE TABLE `muddevils-be`.`aspnet_Applications` (
`ApplicationName` VARCHAR(255) NULL,
`ApplicationId` INT(10) NOT NULL AUTO_INCREMENT,
`Description` VARCHAR(255) NULL,
PRIMARY KEY (`ApplicationName`),
UNIQUE INDEX `ApplicationId` (`ApplicationId`),
UNIQUE INDEX `ApplicationName` (`ApplicationName`)
)
ENGINE = INNODB;
DROP TABLE IF EXISTS `muddevils-be`.`aspnet_Membership`;
CREATE TABLE `muddevils-be`.`aspnet_Membership` (
`UserId` INT(10) NULL,
`Password` VARCHAR(128) NULL,
`PasswordFormat` INT(10) NULL,
`MobilePIN` VARCHAR(16) NULL,
`Email` VARCHAR(128) NULL,
`PasswordQuestion` VARCHAR(255) NULL,
`PasswordAnswer` VARCHAR(128) NULL,
`IsApproved` TINYINT(1) NOT NULL,
`CreateDate` DATETIME NULL,
`LastLoginDate` DATETIME NULL,
`LastPasswordChangedDate` DATETIME NULL,
`Comment` LONGTEXT NULL,
`PasswordSalt` VARCHAR(128) NULL,
PRIMARY KEY (`UserId`),
UNIQUE INDEX `aspnet_Usersaspnet_Membership` (`UserId`),
UNIQUE INDEX `UserId` (`UserId`)
)
ENGINE = INNODB;
DROP TABLE IF EXISTS `muddevils-be`.`aspnet_PagePersonalizationAllUsers`;
CREATE TABLE `muddevils-be`.`aspnet_PagePersonalizationAllUsers` (
`PathId` INT(10) NULL,
`PageSettings` LONGTEXT NULL,
`LastUpdatedDate` DATETIME NULL,
PRIMARY KEY (`PathId`),
UNIQUE INDEX `aspnet_Urlsaspnet_UrlPersonalizationAllUsersData` (`PathId`),
UNIQUE INDEX `UrlId` (`PathId`)
)
ENGINE = INNODB;
DROP TABLE IF EXISTS `muddevils-be`.`aspnet_PagePersonalizationPerUser`;
CREATE TABLE `muddevils-be`.`aspnet_PagePersonalizationPerUser` (
`Id` INT(10) NOT NULL AUTO_INCREMENT,
`PathId` INT(10) NULL,
`UserId` INT(10) NULL,
`PageSettings` LONGTEXT NULL,
`LastUpdatedDate` DATETIME NULL,
PRIMARY KEY (`Id`),
INDEX `aspnet_Urlsaspnet_UrlPersonalizationPerUserData` (`PathId`),
INDEX `aspnet_Usersaspnet_UrlPersonalizationPerUserData` (`UserId`),
INDEX `Id` (`Id`),
INDEX `UrlId` (`PathId`),
INDEX `UserId` (`UserId`)
)
ENGINE = INNODB;
DROP TABLE IF EXISTS `muddevils-be`.`aspnet_Paths`;
CREATE TABLE `muddevils-be`.`aspnet_Paths` (
`ApplicationId` INT(10) NULL,
`PathId` INT(10) NOT NULL AUTO_INCREMENT,
`Path` VARCHAR(255) NULL,
PRIMARY KEY (`PathId`),
INDEX `ApplicationId` (`ApplicationId`),
INDEX `aspnet_Applicationsaspnet_Urls` (`ApplicationId`),
INDEX `Url` (`Path`),
INDEX `UrlId` (`PathId`)
)
ENGINE = INNODB;
DROP TABLE IF EXISTS `muddevils-be`.`aspnet_Profile`;
CREATE TABLE `muddevils-be`.`aspnet_Profile` (
`UserId` INT(10) NULL,
`PropertyNames` LONGTEXT NULL,
`PropertyValuesString` LONGTEXT NULL,
`LastUpdatedDate` DATETIME NULL,
PRIMARY KEY (`UserId`),
UNIQUE INDEX `aspnet_Usersaspnet_Personalization` (`UserId`),
UNIQUE INDEX `UserId` (`UserId`)
)
ENGINE = INNODB;
DROP TABLE IF EXISTS `muddevils-be`.`aspnet_Roles`;
CREATE TABLE `muddevils-be`.`aspnet_Roles` (
`ApplicationId` INT(10) NULL,
`RoleId` INT(10) NOT NULL AUTO_INCREMENT,
`RoleName` VARCHAR(255) NULL,
`Description` VARCHAR(255) NULL,
PRIMARY KEY (`RoleId`),
INDEX `ApplicationId` (`ApplicationId`),
INDEX `aspnet_Applicationsaspnet_Roles` (`ApplicationId`),
INDEX `RoleId` (`RoleId`),
INDEX `RoleName` (`RoleName`)
)
ENGINE = INNODB;
DROP TABLE IF EXISTS `muddevils-be`.`aspnet_SiteCounters`;
CREATE TABLE `muddevils-be`.`aspnet_SiteCounters` (
`Id` INT(10) NOT NULL AUTO_INCREMENT,
`Application` LONGTEXT NULL,
`PageUrl` LONGTEXT NULL,
`CounterGroup` LONGTEXT NULL,
`CounterName` LONGTEXT NULL,
`CounterEvent` LONGTEXT NULL,
`NavigateUrl` LONGTEXT NULL,
`StartTime` DATETIME NULL,
`EndTime` DATETIME NULL,
`Total` INT(10) NULL,
UNIQUE INDEX `Id` (`Id`)
)
ENGINE = INNODB;
DROP TABLE IF EXISTS `muddevils-be`.`aspnet_Users`;
CREATE TABLE `muddevils-be`.`aspnet_Users` (
`ApplicationId` INT(10) NULL,
`UserId` INT(10) NOT NULL AUTO_INCREMENT,
`UserName` VARCHAR(255) NULL,
`MobileAlias` VARCHAR(16) NULL,
`IsAnonymous` TINYINT(1) NOT NULL,
`LastActivityDate` DATETIME NULL,
PRIMARY KEY (`UserId`),
UNIQUE INDEX `UserId` (`UserId`),
INDEX `ApplicationId` (`ApplicationId`),
INDEX `aspnet_Applicationsaspnet_Users` (`ApplicationId`),
INDEX `UserName` (`UserName`)
)
ENGINE = INNODB;
DROP TABLE IF EXISTS `muddevils-be`.`aspnet_UsersInRoles`;
CREATE TABLE `muddevils-be`.`aspnet_UsersInRoles` (
`UserId` INT(10) NULL,
`RoleId` INT(10) NULL,
INDEX `aspnet_Rolesaspnet_UsersInRoles` (`RoleId`),
INDEX `aspnet_Usersaspnet_UsersInRoles` (`UserId`),
INDEX `RoleId` (`RoleId`),
INDEX `UserId` (`UserId`)
)
ENGINE = INNODB;
-- -------------------------------------
-- Views
-- DROP VIEW IF EXISTS `muddevils-be`.`vw_aspnet_Applications`;
-- CREATE OR REPLACE VIEW `muddevils-be`.`vw_aspnet_Applications` AS
-- SELECT `aspnet_Applications`.`Description`, `aspnet_Applications`.`ApplicationId`, `aspnet_Applications`.`ApplicationName`
-- FROM aspnet_Applications;
-- DROP VIEW IF EXISTS `muddevils-be`.`vw_aspnet_MembershipUsers`;
-- CREATE OR REPLACE VIEW `muddevils-be`.`vw_aspnet_MembershipUsers` AS
-- SELECT aspnet_Membership.LastPasswordChangedDate, aspnet_Membership.UserId, aspnet_Membership.PasswordFormat, aspnet_Membership.MobilePIN, aspnet_Membership.Email, aspnet_Membership.PasswordQuestion, aspnet_Membership.PasswordAnswer, aspnet_Membership.IsApproved, aspnet_Membership.LastLoginDate, aspnet_Membership.Comment, aspnet_Users.ApplicationId, aspnet_Users.UserName, aspnet_Users.MobileAlias, aspnet_Users.IsAnonymous, aspnet_Users.LastActivityDate, aspnet_Membership.CreateDate
-- FROM aspnet_Membership INNER JOIN aspnet_Users ON aspnet_Membership.UserId=aspnet_Users.UserId;
-- DROP VIEW IF EXISTS `muddevils-be`.`vw_aspnet_Profiles`;
-- CREATE OR REPLACE VIEW `muddevils-be`.`vw_aspnet_Profiles` AS
-- SELECT (Len(aspnet_Profile.PropertyValuesString)+Len(aspnet_Profile.PropertyNames)), aspnet_Profile.LastUpdatedDate, aspnet_Profile.UserId
-- FROM aspnet_Profile;
-- DROP VIEW IF EXISTS `muddevils-be`.`vw_aspnet_Roles`;
-- CREATE OR REPLACE VIEW `muddevils-be`.`vw_aspnet_Roles` AS
-- SELECT `aspnet_Roles`.`Description`, `aspnet_Roles`.`RoleName`, `aspnet_Roles`.`RoleId`, `aspnet_Roles`.`ApplicationId`
-- FROM aspnet_Roles;
-- DROP VIEW IF EXISTS `muddevils-be`.`vw_aspnet_Users`;
-- CREATE OR REPLACE VIEW `muddevils-be`.`vw_aspnet_Users` AS
-- SELECT `aspnet_Users`.`LastActivityDate`, `aspnet_Users`.`IsAnonymous`, `aspnet_Users`.`MobileAlias`, `aspnet_Users`.`UserName`, `aspnet_Users`.`UserId`, `aspnet_Users`.`ApplicationId`
-- FROM aspnet_Users;
-- DROP VIEW IF EXISTS `muddevils-be`.`vw_aspnet_UsersInRoles`;
-- CREATE OR REPLACE VIEW `muddevils-be`.`vw_aspnet_UsersInRoles` AS
-- SELECT `aspnet_UsersInRoles`.`RoleId`, `aspnet_UsersInRoles`.`UserId`
-- FROM aspnet_UsersInRoles;
-- DROP VIEW IF EXISTS `muddevils-be`.`vw_aspnet_WebPartState_Paths`;
-- CREATE OR REPLACE VIEW `muddevils-be`.`vw_aspnet_WebPartState_Paths` AS
-- SELECT aspnet_Paths.Path, aspnet_Paths.PathId, aspnet_Paths.ApplicationId
-- FROM aspnet_Paths;
-- DROP VIEW IF EXISTS `muddevils-be`.`vw_aspnet_WebPartState_Shared`;
-- CREATE OR REPLACE VIEW `muddevils-be`.`vw_aspnet_WebPartState_Shared` AS
-- SELECT aspnet_PagePersonalizationAllUsers.LastUpdatedDate, Len(aspnet_PagePersonalizationAllUsers.PageSettings), aspnet_PagePersonalizationAllUsers.PathId
-- FROM aspnet_PagePersonalizationAllUsers;
-- DROP VIEW IF EXISTS `muddevils-be`.`vw_aspnet_WebPartState_User`;
-- CREATE OR REPLACE VIEW `muddevils-be`.`vw_aspnet_WebPartState_User` AS
-- SELECT aspnet_PagePersonalizationPerUser.LastUpdatedDate, Len(aspnet_PagePersonalizationPerUser.PageSettings), aspnet_PagePersonalizationPerUser.UserId, aspnet_PagePersonalizationPerUser.PathId
-- FROM aspnet_PagePersonalizationPerUser;
SET FOREIGN_KEY_CHECKS = 1;
-- ----------------------------------------------------------------------
-- EOF
Gift Peddie
wendyzhang
Member
50 Points
10 Posts
Re: MySQL version of Club Starter kit
Sep 13, 2006 07:58 PM|LINK
My album didn't work. Have you encountered this problem with MySQL version of Club Kit?
When I create a new album, it just come back empty without reporting any errors.
I tried to debug it, but the code seemed not reach the
"public static int insert(String title, Int32 parentid, Boolean Private, String description, Int32 ownerid)"
fuction in PXLStudio_ImageDB.cs.
Any clue?
Wendy