xoops forums

Zap_English

Not too shy to talk
Posted on: 2016/6/28 10:40
Zap_English
Zap_English (Show more)
Not too shy to talk
Posts: 137
Since: 2016/5/24
#1

Is there a working newsletter module?

I tried xnewsletter and it won't install

Quote:
BLOB/TEXT column 'template_description' can't have a default value


And it's the latest version from github

zyspec

Module Developer
Posted on: 2016/6/28 11:44
zyspec
zyspec (Show more)
Module Developer
Posts: 980
Since: 2004/9/21
#2

Re: Is there a working newsletter module?

You might try this one... I made some quick changes to remove setting a default value on MySQL text columns...

https://github.com/zyspec/xnewsletter/archive/master.zip

Let me know if this worked. If so, I'll submit a GitHub pull request for the change(s).

Zap_English

Not too shy to talk
Posted on: 2016/6/28 15:33
Zap_English
Zap_English (Show more)
Not too shy to talk
Posts: 137
Since: 2016/5/24
#3

Re: Is there a working newsletter module?

It installed

I'll let you know if it works

Right now I'm having big problems with publisher that I have to deal with

luciorota

Module Developer
Posted on: 2016/6/29 3:59
luciorota
luciorota (Show more)
Module Developer
Posts: 174
Since: 2007/4/20
#4

Re: Is there a working newsletter module?

this is my latest...
https://github.com/luciorota/xnewsletter

Zap_English

Not too shy to talk
Posted on: 2016/6/29 6:41
Zap_English
Zap_English (Show more)
Not too shy to talk
Posts: 137
Since: 2016/5/24
#5

Re: Is there a working newsletter module?

CSV import doesn't work.

zyspec

Module Developer
Posted on: 2016/6/29 10:35
zyspec
zyspec (Show more)
Module Developer
Posts: 980
Since: 2004/9/21
#6

Re: Is there a working newsletter module?

@Zap_English

We need a little more information to be able to help. Can you tell us what the settings are/were on the Import page when it "didn't work"?

Any information you can give us helps reduce the time it takes to find the problem and hopefully resolve it quickly.

Zap_English

Not too shy to talk
Posted on: 2016/6/29 12:43
Zap_English
Zap_English (Show more)
Not too shy to talk
Posts: 137
Since: 2016/5/24
#7

Re: Is there a working newsletter module?

It doesn't give an error. It just says no data imported

I tried both formats given in the example files and nothing happens

zyspec

Module Developer
Posted on: 2016/6/29 16:08
zyspec
zyspec (Show more)
Module Developer
Posts: 980
Since: 2004/9/21
#8

Re: Is there a working newsletter module?

There were problems due to xNewsletter's use of direct mysql statements instead of using the XOOPS API for database access. I've fixed those and a few other bugs in the import plugins (XoopsUser and CSV). Please download again from my GitHub repository and let me know what you find.

https://github.com/zyspec/xnewsletter/archive/master.zip

Zap_English

Not too shy to talk
Posted on: 2016/6/30 0:48
Zap_English
Zap_English (Show more)
Not too shy to talk
Posts: 137
Since: 2016/5/24
#9

Re: Is there a working newsletter module?

That fixed it.

Now I have to edit over 600 subscribers from simplenewsletter to get them to import to xnewsletter :(

zyspec

Module Developer
Posted on: 2016/6/30 1:44
zyspec
zyspec (Show more)
Module Developer
Posts: 980
Since: 2004/9/21
#10

Re: Is there a working newsletter module?

I'll look at this tomorrow to see if I can create a plugin for simplenewsletter so you can import subscribers. Stay tuned...