1. Michael Manfre
  2. txp-plugins
Issue #19 new

mem_postmaster

Dimitri Kouvdis
created an issue

Hi After installation, I have checked in the Extension tab. I have a long list of errors. It looks like it failed to created new tables in the database.

Heres an example. I didnt paste all

==================================

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 /Users/Dimitri/Sites/ogestates.dev/textpattern/lib/txplib_db.php on line 89

Warning: Table 'ogestates.bab_pm_subscribers' doesn't exist INSERT INTO bab_pm_subscribers (subscriberFirstName, subscriberLastName, subscriberEmail, subscriberCustom1, subscriberCustom10, unsubscribeID) values ('Test','User','test@test','custom1','custom10','170d02247684bf3d81c74aa94ace2bc7') in /Users/Dimitri/Sites/ogestates.dev/textpattern/lib/txplib_db.php on line 89

Warning: Unknown column 'list_id' in 'field list' insert into bab_pm_list_prefs set list_id=1, subscriber_id=1 in /Users/Dimitri/Sites/ogestates.dev/textpattern/lib/txplib_db.php on line 89

Warning: Table 'ogestates.bab_pm_subscribers' doesn't exist ALTER TABLE bab_pm_subscribers ADD COLUMN subscriberCustom1 longtext NOT NULL default '' in /Users/Dimitri/Sites/ogestates.dev/textpattern/lib/txplib_db.php on line 89

Warning: Table 'ogestates.bab_pm_subscribers' doesn't exist ALTER TABLE bab_pm_subscribers ADD COLUMN subscriberLastName varchar(30) NOT NULL default '' AFTER subscriberID, ADD COLUMN subscriberFirstName varchar(30) NOT NULL default '' AFTER subscriberID in /Users/Dimitri/Sites/ogestates.dev/textpattern/lib/txplib_db.php on line 89

Comments (2)

  1. Anonymous

    Seconding dkouvdis. After installation in TXP 4.4.1 i get same errors, running MySQL 4.1.22. Thanx for anything you do, there#s hardly an alternative to this plug in TXP. - jayrope

  2. aguawebs

    I think its something to do with this line:

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

    but I'm not 100%

  3. Log in to comment