Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
#205 2012-03-19 06:19:57
Re: mem_postmaster - Postmaster Revamp
Does anyone else get like this when using Postmaster 1.0.10 installed on txp 4.41, php 5.2.13, mysql 5.1.44
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 '\'\', `subscriberCustom2` longtext NOT NULL default \'\', `subscriberCustom3` lo' at line 6 CREATE TABLE IF NOT EXISTS bab_pm_subscribers ( `subscriberID` int(4) NOT NULL auto_increment, `subscriberFirstName` varchar(30) NOT NULL default '', `subscriberLastName` varchar(30) NOT NULL default '', `subscriberEmail` varchar(100) NOT NULL default '', `subscriberCustom1` longtext NOT NULL default \'\', `subscriberCustom2` longtext NOT NULL default \'\', `subscriberCustom3` longtext NOT NULL default \'\', `subscriberCustom4` longtext NOT NULL default \'\', `subscriberCustom5` longtext NOT NULL default \'\', `subscriberCustom6` longtext NOT NULL default \'\', `subscriberCustom7` longtext NOT NULL default \'\', `subscriberCustom8` longtext NOT NULL default \'\', `subscriberCustom9` longtext NOT NULL default \'\', `subscriberCustom10` longtext NOT NULL default \'\', `subscribe in /Applications/MAMP/htdocs/ztest/register_tests/textpattern/lib/txplib_db.php on line 89Offline
#206 2012-03-21 05:09:09
Re: mem_postmaster - Postmaster Revamp
Has anyone installed this plugin on txp 4.4.1?
Offline
#207 2012-03-21 06:25:05
Re: mem_postmaster - Postmaster Revamp
tye wrote:
Has anyone installed this plugin on txp 4.4.1?
Hi tye, I have it working on 4.4.1, in two sites
Last edited by colak (2012-03-21 06:34:29)
Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.
Offline
#208 2012-03-21 07:40:38
Re: mem_postmaster - Postmaster Revamp
Thanks colak… did you do a fresh install or was it an upgrade?
Offline
#209 2012-03-21 08:23:39
Re: mem_postmaster - Postmaster Revamp
Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.
Offline
#210 2012-03-21 09:43:49
Re: mem_postmaster - Postmaster Revamp
Hello, I’m having these installation troubles, gonna tryout the 1.0.7 version
Offline
#211 2012-03-21 11:27:08
Re: mem_postmaster - Postmaster Revamp
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
Offline
#212 2012-03-21 15:58:57
Re: mem_postmaster - Postmaster Revamp
Hi Manaus,
did you install zcr and the languages pack?Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.
Offline
#213 2012-03-21 18:38:06
Re: mem_postmaster - Postmaster Revamp
Hi Colak,
yes, both active…
Seems like it cannot create the table of subscribers
Offline
#214 2012-03-22 00:48:28
Re: mem_postmaster - Postmaster Revamp
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)
Offline
#215 2012-03-22 00:59:54
Re: mem_postmaster - Postmaster Revamp
Cancel that, it does seem to be working, but it is still throwing errors everywhere :(
Offline
#216 2012-05-04 11:36:22
Re: mem_postmaster - Postmaster Revamp
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)
Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.
Offline