I've used Campaign Letter beta version on MsSqlServer2008 and it works perfectly. However, I need to use Campaign Letter with a mysql 5+ database(for a live site). After I installed campaignletter on to MySql database I noticed I couldn't add any data to uwz_subscribeItem table using the umbraco 'campaign letters' tab/ or a user control, which worked with MsSqlServer2008, at the front-end.
It seems to be only uwz_subscribeItem table that has the issue as I can add new Master Templates and Campaign letters via umbraco and they appear in the relevant tables on my MySql database.
The live site I believe is MySql 5.5.15, I've also tried a it on a dummy site aswell on my local machine which has MySql 5.6 they are both failing. I'm looking at the source code now.
Thank you Owen the package 0.43 solved the issue. However, I realise the source code for this new version hasn't been posted. Is this possible?
I've found another bug, "Unsubscribe API methods not working" (Ive posted it in the forum with more detail), I believe I know how to fix the issue but don't have the 0.43 source code to keep your MySql fix as it isn't available.
MySql Adding users to subcribe group via umbraco?
Hi Owen/anyone whos had this issue and solved,
I've used Campaign Letter beta version on MsSqlServer2008 and it works perfectly. However, I need to use Campaign Letter with a mysql 5+ database(for a live site). After I installed campaignletter on to MySql database I noticed I couldn't add any data to uwz_subscribeItem table using the umbraco 'campaign letters' tab/ or a user control, which worked with MsSqlServer2008, at the front-end.
It seems to be only uwz_subscribeItem table that has the issue as I can add new Master Templates and Campaign letters via umbraco and they appear in the relevant tables on my MySql database.
What sql do you use?
Regards
Paul
Hi Paul, sorry for replied late. I am busy with another package recently, and this package will be rewrited in the future.
I wondering the exactly version number of MySql, i need to test it.
Otherwise, you can download the source code and try to debug your code to find the issue.
The live site I believe is MySql 5.5.15, I've also tried a it on a dummy site aswell on my local machine which has MySql 5.6 they are both failing. I'm looking at the source code now.
Thanks for your quick response
Paul
Hi Paul, i have fixed the issue. You can download the 0.4.3. It should be works now.
BTW, if you have data don't want to be deleted, you can just replace the dll files.
--
Owen
Thank you Owen the package 0.43 solved the issue. However, I realise the source code for this new version hasn't been posted. Is this possible?
I've found another bug, "Unsubscribe API methods not working" (Ive posted it in the forum with more detail), I believe I know how to fix the issue but don't have the 0.43 source code to keep your MySql fix as it isn't available.
-
Paul
is working on a reply...