|
I'll have to wait until tomorrow when I get back to my computer, but thankyou for your help.
|
|
|
|
|
I'm afraid that I get failures on both when I try to create these tables as an NDBCluster.
Error:
Can't create table (errno: 904) - 1005
|
|
|
|
|
Oh no... Sorry I have no clue. Will investigate as soon as I get some time and get back to you.
"I'm about as expert as a palsy victim performing brain surgery with a pipe wrench."
Check out my site at JacquesSnyman.co.za
** Remember: An article is only as good as the votes it gets **
|
|
|
|
|
Can anyone please help me? I setup the suite as specified. I opened Visual Studio Express. The wizard attempted to convert the project but could not parse the Simple.Providers.MySQL.csproj file. I am new to .net in general. Until recently, I programmed in ASP VBScript. Here is the conversion log contents:
ERROR: Unable to parse project file Simple.Providers.MySQL.csproj.
=========================COMMENTS=================
Project Simple.Providers.MySQL.csproj has been converted successfully at August 06 2007, 05:45:58.
Any tips or help greatly appreciated.
|
|
|
|
|
Hi Rob...
I've never worked with Visual Studio Express but have read quite a lot about it.
The project is a Visual Studio 2005 project and you shouldn't have to convert it. Maybe you should try opening it with Visual C# Express as it is a library and not a WinForm or Web project. You can then make changes and compile it. You then need to reference the compiled library from your Visual Studio Express environment. I hope this solves your problem. As I said, I've never used VS Express, so this is probably a shot in the dark.
Please let me know it this worked.
"I'm about as expert as a palsy victim performing brain surgery with a pipe wrench."
Check out my site at JacquesSnyman.co.za
** Remember: An article is only as good as the votes it gets **
|
|
|
|
|
Is it possible to use more than one child node in an treeview control?
I have managed to show the root and parent nodes but I cannot get the child nodes to show. Is I doing it wrong or is it simply not possible?
Thanx for a fabulous suite!
|
|
|
|
|
Please specify where you are having the problem. Is it with the sitemap provider?
"I'm about as expert as a palsy victim performing brain surgery with a pipe wrench."
Check out my site at JacquesSnyman.co.za
** Remember: An article is only as good as the votes it gets **
|
|
|
|
|
I have added to the database in the SiteMap table a few rows that I am using to fill a treeview with and that works. I get the root node and the 1st depth of nodes to show. I have used the id of the root node as the value for the parent column for the parent nodes. I would then like to have child nodes under the parent nodes and tried to set the parent column values the same as the ID for the parent but it doesnt work. Should that work?
I want to have a menu like this
root node
- Parent node 1
--Child 1
--Child 2
-Parent node 2
--Child 1
and so on but all i have managed to produce is the root and parent nodes. Does the provider support this usage? I hope this clearifies my question
|
|
|
|
|
Set the maxdatabinddepth of the treeview to -1
"I'm about as expert as a palsy victim performing brain surgery with a pipe wrench."
Check out my site at JacquesSnyman.co.za
** Remember: An article is only as good as the votes it gets **
|
|
|
|
|
|
Hello!
Thats the error that ocurrs when i deploy the solution to the product server.
Whats it about? where should i register it and how?
on Local machine everythin works good, but not on the hosting server.
any advices?
|
|
|
|
|
It might be that your host only supports signed assemblies. Or it might be any of a number of other factors. I think your hosting provider will be your best bet to try and find the problem.
"I'm about as expert as a palsy victim performing brain surgery with a pipe wrench."
Check out my site at JacquesSnyman.co.za
** Remember: An article is only as good as the votes it gets **
|
|
|
|
|
I chose your code for a project, where the Profile is important. But Profile function always give an exception.
1. I use a CreateUserWizard which has a step ask for user's profile, in the CreatedUser function, set this profile.
protected void CreateUserWizard1_CreatedUser(object sender, EventArgs e)
{
Profile.NickName = txtNickName.Text;
}
But it give an exception: Provider Exception! Cannot set it for an annonymous.
2. When I logined in, I set the Profile like this:
protected void btnSaveProfile_Click(object sender, EventArgs e)
{
Profile.NickName = txtNickName.Text;
Profile.Sex = RdSex.Text;
Profile.UserCompany = txtCompany.Text;
}
But an Exception ocurred: Unsupported property.
I use MySQL 5.0.
Can you help me.
I'm a chinese with poor english.
|
|
|
|
|
Hi...
You need to make changes to the code, database and web.config if you need custom properties for a profile. The "Unsupported property" exception you're getting is probably because of this.
The "Cannot set for anonymous" exception is because of the fact that you cannot set a profile property unless the user is logged in.
I'm working on making the profile properties dynamic so that the code and database can handle it.
Thanks
Jacques
"I'm about as expert as a palsy victim performing brain surgery with a pipe wrench."
Check out my site at JacquesSnyman.co.za
** Remember: An article is only as good as the votes it gets **
|
|
|
|
|
First, Thanks for your replay!
ERROR Comes from a file autogenerated in APP_CODE folder, The first Error reported "Unsupported property." in the NickName's this.SetPropertyValue function.
*****************************************************************
public class ProfileCommon : System.Web.Profile.ProfileBase {
public virtual string NickName {
get {
return ((string)(this.GetPropertyValue("NickName")));
}
set {
this.SetPropertyValue("NickName", value);
}
}
*******************************************************************
This is my profile:
*******************************************************************
<profile defaultProvider="profileProvider" automaticSaveEnabled="true">
<providers>
<clear/>
<add
name="profileProvider"
type="Simple.Providers.MySQL.MysqlProfileProvider"
connectionStringName="SimpleProviderConnectionString"
applicationName="CFH"
description="MySQL Profile Provider"/>
</providers>
<properties>
<clear/>
<add name="NickName" />
<add name="Sex" />
<add name="UserCompany" />
</properties>
</profile>
***************************************************************
And the database was created by sql file in your codes.
So, What should I do? Help me!
-- modified at 22:05 Monday 9th July, 2007
|
|
|
|
|
You should add the following line to the profiles create table sql script:
`NickName` varchar(255) NOT NULL default '',
Hope this helps!
"I'm about as expert as a palsy victim performing brain surgery with a pipe wrench."
Check out my site at JacquesSnyman.co.za
** Remember: An article is only as good as the votes it gets **
|
|
|
|
|
I don't know how Profiles works, but in your code, It seems difficulty. I must add a new column in the the table, then I must add corresponding code in the MysqlProfileProvider.cs file.
But the guide book of ASP.NET says, you can add any Profile Items anytime, just like Seesions does.
So why don't you save all the Profiles items in same table structure?
MySQL Provider suit is very important to devlopers who use ASP.NET 2.0 + MySQL Suit, it's the first thing! But I can't find a very good solution content myself.
Would you like change your code or find out a solution to us?
|
|
|
|
|
I already have this in mind and the solution should be quite easy, but I just don't get time to do dev work. Maybe someone can make the change and send me the changed code.
I will try and get to this asap if I don't get any change suggestions, so please, just hang in there.
"I'm about as expert as a palsy victim performing brain surgery with a pipe wrench."
Check out my site at JacquesSnyman.co.za
** Remember: An article is only as good as the votes it gets **
|
|
|
|
|
Hey
Do you have a solution in the near future? Because I'm in the need for the custom attributes, and would like to know, if I can wait for you to do the job...
If not, it could be nice to hear your ideas for an implemention
regars...
|
|
|
|
|
I try to do this:
DateTime dt = new DateTime(2001, 1, 1);
u.LastActivityDate = dt;
Membership.UpdateUser(u);
But apparently dt is formatted like 01-01-2001 00:00:00 where MySQL expects 2001-01-01 00:00:00
Any ideas?
|
|
|
|
|
Thanks for your question. I just realized that I didn't include everything in the SQL command.
"UPDATE `users` SET Email = ?, Comment = ?,IsApproved = ? WHERE Username = ? AND ApplicationName = ?"
That's the command that's executed on UpdateUser. I will get working on it right away.
Thanks again!
"I'm about as expert as a palsy victim performing brain surgery with a pipe wrench."
Check out my site at JacquesSnyman.co.za
** Remember: An article is only as good as the votes it gets **
|
|
|
|
|
Hi again,
any new on the above? I tried downloading the sourcecode, but it still has
"UPDATE `" + tableName + "`" +
" SET Email = ?, Comment = ?," +
" IsApproved = ?" +
" WHERE Username = ? AND ApplicationName = ?"
I guess I could try and correct it myself, but do you have an updated sourcefile that you didn´t upload yet?
|
|
|
|
|
I've submitted an update for the change.
"I'm about as expert as a palsy victim performing brain surgery with a pipe wrench."
Check out my site at JacquesSnyman.co.za
** Remember: An article is only as good as the votes it gets **
|
|
|
|
|
Hmmm.... where? When I download the sourcecode (top pf the page: "Download source - 182.1 KB" ), I still get this code (MysqlMembershipProvider.cs, line# 1199);
public override void UpdateUser(MembershipUser user)
{
OdbcConnection conn = new OdbcConnection(connectionString);
OdbcCommand cmd = new OdbcCommand("UPDATE `" + tableName + "`" +
" SET Email = ?, Comment = ?," +
" IsApproved = ?" +
" WHERE Username = ? AND ApplicationName = ?", conn);
cmd.Parameters.Add("@Email", OdbcType.VarChar, 128).Value = user.Email;
cmd.Parameters.Add("@Comment", OdbcType.VarChar, 255).Value = user.Comment;
cmd.Parameters.Add("@IsApproved", OdbcType.TinyInt).Value = user.IsApproved;
cmd.Parameters.Add("@Username", OdbcType.VarChar, 255).Value = user.UserName;
cmd.Parameters.Add("@ApplicationName", OdbcType.VarChar, 255).Value = pApplica
|
|
|
|
|
When i create a new user in simple code below :
Membership.CreateUser("test", "test");
Got the error :
Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
Source Error:
Line 1068: finally<br />
Line 1069: {<br />
Line 1070: conn.Close();<br />
Line 1071: }<br />
Line 1072:
Source File: MysqlMembershipProvider.cs Line: 1070
Stack Trace:
[AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt.]<br />
System.Data.Common.UnsafeNativeMethods.SQLFreeHandle(SQL_HANDLE HandleType, IntPtr StatementHandle) +0<br />
System.Data.Odbc.OdbcHandle.ReleaseHandle() +71<br />
System.Runtime.InteropServices.SafeHandle.InternalDispose() +0<br />
System.Runtime.InteropServices.SafeHandle.Dispose(Boolean disposing) +11<br />
System.Runtime.InteropServices.SafeHandle.Dispose() +9<br />
System.Data.Odbc.CMDWrapper.DisposeStatementHandle() +59<br />
System.Data.Odbc.CMDWrapper.Dispose() +30<br />
System.Data.Odbc.OdbcCommand.CloseCommandWrapper() +33<br />
System.Data.Odbc.OdbcCommand.CloseFromConnection() +37<br />
System.Data.Odbc.OdbcReferenceCollection.NotifyItem(Int32 message, Int32 tag, Object value) +73<br />
System.Data.ProviderBase.DbReferenceCollection.Notify(Int32 message) +91<br />
System.Data.Odbc.OdbcConnectionOpen.Deactivate() +18<br />
System.Data.ProviderBase.DbConnectionInternal.CloseConnection(DbConnection owningObject, DbConnectionFactory connectionFactory) +106<br />
System.Data.Odbc.OdbcConnection.Close() +38<br />
Simple.Providers.MySQL.MysqlMembershipProvider.GetUserNameByEmail(String email) in MysqlMembershipProvider.cs:1070<br />
Simple.Providers.MySQL.MysqlMembershipProvider.CreateUser(String username, String password, String email, String passwordQuestion, String passwordAnswer, Boolean isApproved, Object providerUserKey, MembershipCreateStatus& status) in Simple.Provider\MysqlMembershipProvider.cs:426<br />
System.Web.Security.Membership.CreateUser(String username, String password, String email, String passwordQuestion, String passwordAnswer, Boolean isApproved, Object providerUserKey, MembershipCreateStatus& status) +224<br />
System.Web.Security.Membership.CreateUser(String username, String password, String email) +30<br />
System.Web.Security.Membership.CreateUser(String username, String password) +6<br />
TestUser.btCreateUser_Click(Object sender, EventArgs e) +16<br />
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +105<br />
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +107<br />
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7<br />
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11<br />
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33<br />
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102
What do you think?
|
|
|
|