DateOfBirth in MySQL setup

This forum is only for questions or discussions about working with the mojoPortal source code in Visual Studio, obtaining the source code from the repository, developing custom features, etc. If your question is not along these lines this is not the right forum. Please try to post your question in the appropriate forum.

Please do not post questions about design, CSS, or skinning here. Use the Help With Skins Forum for those questions.

This forum is for discussing mojoPortal development

This forum is only for questions or discussions about working with the mojoPortal source code in Visual Studio, obtaining the source code from the repository, developing custom features, etc. If your question is not along these lines this is not the right forum. Please try to post your question in the appropriate forum.

You can monitor commits to the repository from this page. We also recommend developers to subscribe to email notifications in the developer forum as occasionally important things are announced.

Before posting questions here you might want to review the developer documentation.

Do not post questions about design, CSS, or skinning here. Use the Help With Skins Forum for those questions.
This thread is closed to new posts. You must sign in to post in the forums.
12/28/2013 3:47:16 PM
CyberSkunk
Gravatar
Total Posts 2
View Posts

DateOfBirth in MySQL setup

Hi,

I created a Virtualbox image with server 2008 r2 x64 and VS2012 and tried to get the source code to try out the MojoPortal. Because I would like to run MojoPortal with MySQL I installed the latest MySQL version also.

After compiling and running the MojoPortal from within VS2012 I got a error from the setup that the field ‘DateOfBirth’ could not be found in mp_users. After some debugging and checking the schema creation scripts I found that the update script ‘2.4.0.1.config’ of the SQL version had a alter statement adding the ‘DateOfBirth’ field to the mp_users. After I did add the missing alter statement to the 2.4.0.1.config file of the MySQL SchemaUpgradeScripts the install went flawless and I can login and test now.

The statement I added was: ALTER TABLE mp_users ADD COLUMN `DateOfBirth` datetime;

It looks like the adding of the DateOfBirth field was forgotten, or I did something wrong :)
If it was forgotten please add it to the source code.

Keep up the good work!

Regards,

Carlo (CyberSkunk)

12/29/2013 6:30:01 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: DateOfBirth in MySQL setup

Hi Carlo,

Thanks! This script is now fixed in the source code repository.

I'm not sure what you mean by "installed the latest MySql version".

Note that if you are building from source code using VS, to use another data layer like MySql, all you have to do is choose the correct build profile from the dropdown in VS before building the solution, ie "Release - MySql" or "Debug - MySql". There is no need for any manual installation.

Best Regards,

Joe

12/29/2013 8:02:42 AM
CyberSkunk
Gravatar
Total Posts 2
View Posts

Re: DateOfBirth in MySQL setup

Hi Joe,

 

I know about choosing the correct datalayer in VS and my develop website is up and running now :)
 

The reason I wrote about the "last MySQL version" was because I already had stopped the virtualbox and I was to lazy to start it for the version number.

I just looked up the version and I am using the 5.6.15 x64 MySQL Community server version.

Regards,

Carlo

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