With MySql: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(10), NODEID) + '">' + TEXT + '</a>' AS NAME, LOGINNAME, EMAIL FROM CMSMEMBER I' at line 1
With vistaDB:
Error 567 (Provider v. 3.4.1.69): Column doesn't exist: <a href="editMember.aspx?id=
Yes, it looks like it's fixed in 4.1, but the availble version of 4.1 is not recommended for production. I guess I will have to write a small usercontrol for searching members and put it in the dashboard while I wait for 4.1 to get ready for production.
Mostly, I would recommend you switch to (the equally free) MS SQL express server if you can. This issue has been open for so long that I doubt that there is much active support for using mysql..
I cannot use the MSSql Express, it's on a shared hosting where its not supported. So it's vistaDB or mySql. Or the full MsSql, but that comes with a pricetag... But you think the support for mySql is going to be dropped?
No, it's not being dropped. Just not very actively developed. One tip: don't use VistaDB! I have bad experiences with it, mainly because of bad performance.
I don't understand why they won't host SQL Express databases but I'm not a hosting provider so maybe I'm missing something. If it's at all possible, maybe you should consider switching to new hosting, there are pretty affordable good hosts out there nowadays.
members search excpetion
Searching for members generates an exception
With MySql:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(10), NODEID) + '">' + TEXT + '</a>' AS NAME, LOGINNAME, EMAIL FROM CMSMEMBER I' at line 1
With vistaDB:
Error 567 (Provider v. 3.4.1.69): Column doesn't exist: <a href="editMember.aspx?id=
Line #: 1; Column #: 273
It looks like this issue is being fixed in v41., as two work items that describe this problem have been closed on march 4th:
umbraco.codeplex.com/WorkItem/View.aspx?WorkItemId=22158
umbraco.codeplex.com/WorkItem/View.aspx?WorkItemId=22948
Yes, it looks like it's fixed in 4.1, but the availble version of 4.1 is not recommended for production.
I guess I will have to write a small usercontrol for searching members and put it in the dashboard while I wait for 4.1 to get ready for production.
Mostly, I would recommend you switch to (the equally free) MS SQL express server if you can. This issue has been open for so long that I doubt that there is much active support for using mysql..
I cannot use the MSSql Express, it's on a shared hosting where its not supported. So it's vistaDB or mySql. Or the full MsSql, but that comes with a pricetag...
But you think the support for mySql is going to be dropped?
No, it's not being dropped. Just not very actively developed. One tip: don't use VistaDB! I have bad experiences with it, mainly because of bad performance.
I don't understand why they won't host SQL Express databases but I'm not a hosting provider so maybe I'm missing something. If it's at all possible, maybe you should consider switching to new hosting, there are pretty affordable good hosts out there nowadays.
is working on a reply...