mem_postmaster - Postmaster Revamp

tye · 2012-03-21 11:27:08

Thanks colak :) what version of MYSQL are you running on the fresh install? (of course only check when you have time :))

Manaus, they are the same errors I am getting… it must be something to do with the MYSQL version we are running as I had installed this perfectly not so long back on the same server

colak · 2012-03-21 15:58:57

Hi Manaus,

did you install zcr and the languages pack?

Manaus · 2012-03-21 18:38:06

Hi Colak,
yes, both active…
Seems like it cannot create the table of subscribers

tye · 2012-03-22 00:48:28

OK – this is probably the wrong thing to do… but I just altered line 493 – 497 in mem_postmaster_library to this:

$custom_fields = addslashes(''); for ($i=1; $i <= BAB_CUSTOM_FIELD_COUNT; $i++) { $custom_fields .= "`subscriberCustom{$i}` longtext NOT NULL default ''," . n; }

Previously it was this

$custom_fields = ''; for ($i=1; $i <= BAB_CUSTOM_FIELD_COUNT; $i++) { $custom_fields .= "`subscriberCustom{$i}` longtext NOT NULL default \'\'," . n; }

Hopefully that still keeps it secure and correct code (I have no idea)

What happens is the first time you go to the extension tab you still get “Warning: Duplicate” errors, but if you press it again, they disappear (hopefully that is a good thing)

tye · 2012-03-22 00:59:54

Cancel that, it does seem to be working, but it is still throwing errors everywhere :(

colak · 2012-05-04 11:36:22

This is just in case anyone wants to display on the front end the number of subscribers they have in their database.

<txp:php>echo getCount('bab_pm_subscribers',"1");</txp:php>

The code returns the number of total subscribers

Last edited by colak (2012-05-04 11:37:18)

frickinmuck · 2012-05-17 18:57:44

What happened to this plugin? I can’t seem to download it from the link provided.

kees-b · 2012-05-17 20:30:13

frickinmuck wrote:

What happened to this plugin? I can’t seem to download it from the link provided.

You can find it here

kees

colak · 2012-06-28 15:57:34

In the postmaster manual it says that we can enter <txp:bab_pm_zemTime custom_field="zemSubscriberCustom2" /> should we want the subscription date.

I have tried numerous variations of that including <txp:zem_contact_zemTime custom_field="zemSubscriberCustom2" /> but nothing works. Can anybody shed some light?

THE BLUE DRAGON · 2012-06-29 10:37:45

OK so after a lot of time I’m back using this plugin and here some things I notice:

1.
Installing v1.0.10, will not create the “bab_pm_subscribers” table in the database,
and that’s why you will get bunch of SQL errors.

So for now you will need to first install v1.0.7,
visit the “Postmaster” tab in the “Extensions”,
you will see some errors, ignore it,
then remove that version (1.0.7),
and install v1.0.10.

If you already installed v1.0.10 first, then you better not taking risks and totally remove the two other tables from your databse:
“bab_pm_list_prefs”
“bab_pm_subscribers_list”

A working installation will need all the 3 database tables that I just mentioned:
“bab_pm_list_prefs”
“bab_pm_subscribers”
“bab_pm_subscribers_list”

Then you will not get any errors.

2.
There is a small change you need to do to the plugin code,
Search for:

<tr id="nav-secondary"><td align="center" class="tabs" colspan="2">
		<td>

and remove the second <td> tag, this is just a syntax error that fixing it will make the menu to look better.

3.
If you wish to use some PHP inside your html-form, and want to link/include scripts and files from the root folder or so, then regular path to the files will not work.
You will need to use a global name $path_to_site; and set your path including it.
For example I use a script that takes the stylesheet and convert it to inline-style.
and also store a full .css file content in a variable, so this is how I set the path to the files:

<txp:variable name="the_contnet">
	all the html content goes here
</txp:variable>

<txp:php>
	global $variable;
	global $path_to_site;

	ob_start();
	include ($path_to_site.'/default.css');
	$the_css = ob_get_contents();
	ob_end_clean();

	// require
	require_once $path_to_site.'/css_to_inline_styles.php';

	// create instance
	$cssToInlineStyles = new CSSToInlineStyles($variable['the_contnet'], $the_css);

	// grab the processed HTML
	$processedHTML = $cssToInlineStyles->convert();
	echo $processedHTML;
</txp:php>

maybe there is better way instead of using $path_to_site;, but that’s what I found working good.
(I don’t know PHP)
BTW: if you want then here’s the “css_to_inline_styles” script that I use: http://classes.verkoyen.eu/css_to_inline_styles

.
.

What I also wish is to automatically send a mail to a subscriber on birthday, base on the date from each subscriber custom-field.
Do you have any idea how can we do that please?

THE BLUE DRAGON · 2012-06-29 12:49:42

I get this error when try to add a new subscriber:

Warning: Unknown column 'newSubscriberFirstName' in 'field list' insert into bab_pm_subscribers set `newSubscriberFirstName` = 'My first name', `newSubscriberLastName` = 'My last name', `newSubscriberEmail` = 'name@example.com', 
`newSubscriberCustom1` = '', `newSubscriberCustom2` = '', `newSubscriberCustom3` = '', `newSubscriberCustom4` = '', `newSubscriberCustom5` = '', `newSubscriberCustom6` = '', `newSubscriberCustom7` = '', `newSubscriberCustom8` = '', `newSubscriberCustom9` = '', 
`newSubscriberCustom10` = '', `newSubscriberCustom11` = '', `newSubscriberCustom12` = '', `newSubscriberCustom13` = '', `newSubscriberCustom14` = '', `newSubscriberCustom15` = '', `newSubscriberCustom16` = '', `newSubscriberCustom17` = '', `newSubscriberCustom18` = '', 
`newSubscriberCustom19` = '', `newSubscriberCustom20` = '', `unsubscribeID` = '6465115ac46034ff43d21a48b0f258aa' in /textpattern/lib/txplib_db.php on line 89

Warning: 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 '' at line 1 
insert into bab_pm_subscribers_list set list_id = 14, subscriber_id = in /textpattern/lib/txplib_db.php on line 89

colak · 2012-06-29 13:55:47

Hi Gil

I only have this problem for our ‘off line’ subscribers but the front end forms work just fine. Is this the case with you?

THE BLUE DRAGON · 2012-06-29 15:07:36

colak wrote:

Hi Gil

I only have this problem for our ‘off line’ subscribers but the front end forms work just fine. Is this the case with you?

Yep I’m trying to enter new subscribers manually, and then get the error,
I didn’t tried using a signup form, as I don’t use it for now.

I see that v.1.0.7 set 10 custom fields, and v.1.0.10 sets 20 custom fields.

I just went all the way back to the old original plugin which for now seems to work fine and do no problems at all, but I’m still playing with it so can’t say for sure for now.
I went to the database and removed all the 3 tables and all the preferences from the “txp_prefs” table.

If I will face with problems with the old plugin I will try once again the new one in version 1.0.10 and as you said I will use a signup form, if the form will work then I will just put it into an iframe or smd_tabber or so, if the signup will not work then I will go to use v.1.0.7.

I wish there was a change-log to see why we should use v.1.0.10 on top of v.1.0.7, if it’s only about these SQL errors show-up and do no harm then that’s fine, worst case I will hide the errors using JS or so.

THE BLUE DRAGON · 2012-06-30 13:15:42

OK day #3 !

The old plugin is not that good after all, because you can’t get the direct unsubscribe link to work,
if you use the tag <txp:bab_pm_unsubscribeLink /> then while sending you will get an error:

Warning: tag does not exist in /textpattern/publish.php on line 1202

.
.
So I’m back to the new one using v1.0.10,
can we please get the direct unsubscribe link to work in this version?
if so then how please?

colak · 2012-06-30 13:45:34

Hi Gil
I always hand coded the link to the unsubscribe page in the newsletter form

Textpattern CMS

Textpattern CMS support forum

#211 2012-03-21 11:27:08

Re: mem_postmaster - Postmaster Revamp

#212 2012-03-21 15:58:57

Re: mem_postmaster - Postmaster Revamp

#213 2012-03-21 18:38:06

Re: mem_postmaster - Postmaster Revamp

#214 2012-03-22 00:48:28

Re: mem_postmaster - Postmaster Revamp

#215 2012-03-22 00:59:54

Re: mem_postmaster - Postmaster Revamp

#216 2012-05-04 11:36:22

Re: mem_postmaster - Postmaster Revamp

#217 2012-05-17 18:57:44

Re: mem_postmaster - Postmaster Revamp

#218 2012-05-17 20:30:13

Re: mem_postmaster - Postmaster Revamp

#219 2012-06-28 15:57:34

Re: mem_postmaster - Postmaster Revamp

#220 2012-06-29 10:37:45

Re: mem_postmaster - Postmaster Revamp

#221 2012-06-29 12:49:42

Re: mem_postmaster - Postmaster Revamp

#222 2012-06-29 13:55:47

Re: mem_postmaster - Postmaster Revamp

#223 2012-06-29 15:07:36

Re: mem_postmaster - Postmaster Revamp

#224 2012-06-30 13:15:42

Re: mem_postmaster - Postmaster Revamp

#225 2012-06-30 13:45:34

Re: mem_postmaster - Postmaster Revamp

Board footer