Hello, I am very glad with your Simplenews module, but I wonder whether it is possible to use Simplenews on a Multisite in such a way that each site has its own subscribe-block, but only one domain keeps the database. All subscriptions will be for the same newsletter.

Thanks

Comments

theorichel’s picture

Well I should correct myself, all subscriptions will not be for one newsletter, I just want one table to contain the subscriptions that come in from two sites. The newsletters will be seperate. So the subscriptions table needs to be shared. Is there any experience with this?

scedwar’s picture

I tried this in October on a test site and couldn't get consistent behaviour for subscriptions. It sounds like it should be quite simple, but alas I couldn't get it to work with some sensible table prefixes and didn't want to dig into the module.

theorichel’s picture

Well as a matter of fact I have it working: 1 database that is filled from two domains. I send the newsletters from each domain, but the group of people that receives it remains the same. I have shared the following tables: simplenews-newsletters, simplenews-subscriptions and simplenews snid-tid. I was told that I should also share the taxonomy table but I havent.
This works very well.

Thanks

TR

scedwar’s picture

watch out for your node sequences numbers between the two sites if you aren't sharing your nodes and you are sharing the newsletters.

Devis’s picture

subscribe

theorichel’s picture

Title: Multisite configuration? » Multisite configuration?

Sorry I must correct myself, I gave the wrong list of shared tables which may be confusing. Below is my real list of shared tables:

'users'
'sessions'
'role'
'authmap'
'sequences'
'profile_fields'
'profile_values'
'users_roles'
'simplenews_subscriptions'
'simplenews_snid_tid'
'bio'

It works allright apart from the fact that the users pictures are visible only in one domain due to the fact that each domain has its own file directory and the picture dir is below that. That is annoying but I do not know what to do about that. I am told Symlinks is a solution but I do not know how to make them.

Also I have the impression that domain 1 (which contains the shared tables) gives a rather high number of current visitors whereas domain 2 (which uses the shared tables) a rather low. If I look at the real number of reads this should be the other way around. I have the impression that now domain 1 gives the tot number of current visitors for both domains and domain 2 only the visitors for that domain (or not even that). I suppose this counter is session based, but I do not know really (and would like to!)

sutharsan’s picture

Status: Active » Fixed

Can't help you further with that.

Anonymous’s picture

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.