WordPress.org

1. noyz319
   Member
   Posted 5 years ago #

   Hi, has anybody got the WP Campaign Monitor plugin to work on wordpress 2.1.3 install?

   http://www.instinct.co.nz/wp-campaign-monitor/

   I've tried a couple of clean installs and it gives me a bunch of database errors all over it's admin screens. Here's an example one:
   "
   WordPress database error: [Table 'wordpress.wp_comms_groups' doesn't exist]
   SELECT * FROM wp_comms_groups WHERE name = 'Wordpress Users' LIMIT 1
   "
   It looks like a lot of the required tables are not being created in the first place. Any ideas on how to get this plugin to work?

2. jefjones
   Member
   Posted 5 years ago #

   Hi noyz319,

   I had the same problem. Fixed it by modifying a patch for the fGallery plugin that also wouldn't write SQL tables. Copy the code below and paste into a text file. Import the script into your database using phpmyadmin. Good luck.

   DROP TABLE IF EXISTS wp_comms;
   CREATE TABLE IF NOT EXISTS wp_comms (
   id bigint(20) unsigned NOT NULL auto_increment,
   email varchar(255) NOT NULL default '',
   mobile varchar(64) NOT NULL default '',
   name varchar(255) NOT NULL default '',
   title varchar(255) NOT NULL default '',
   organisation TEXT NOT NULL default '',
   subscribed char(1) NOT NULL default '',
   e-commerce char(1) NOT NULL default '',
   wp-user char(1) NOT NULL default '',
   time datetime NOT NULL default '0000-00-00 00:00:00',
   PRIMARY KEY (id),
   KEY subscribed (subscribed)
   ) TYPE=MyISAM AUTO_INCREMENT=1 ;";

   DROP TABLE IF EXISTS wp_comms_groups;
   CREATE TABLE IF NOT EXISTS wp_comms_groups (
   id bigint(20) unsigned NOT NULL auto_increment,
   email varchar(255) NOT NULL default '',
   mobile varchar(64) NOT NULL default '',
   name varchar(255) NOT NULL default '',
   title varchar(255) NOT NULL default '',
   organisation TEXT NOT NULL default '',
   subscribed char(1) NOT NULL default '',
   e-commerce char(1) NOT NULL default '',
   wp-user char(1) NOT NULL default '',
   time datetime NOT NULL default '0000-00-00 00:00:00',
   PRIMARY KEY (id),
   KEY subscribed (subscribed)
   ) TYPE=MyISAM AUTO_INCREMENT=1 ;

   DROP TABLE IF EXISTS wp_comms_email_log;
   CREATE TABLE IF NOT EXISTS wp_comms_email_log (
   id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
   email VARCHAR( 192 ) NOT NULL ,
   commsid BIGINT UNSIGNED NOT NULL ,
   messageid BIGINT UNSIGNED NOT NULL ,
   bounced VARCHAR( 1 ) NOT NULL ,
   errorcode VARCHAR( 64 ) NOT NULL ,
   datetime DATETIME NOT NULL ,
   INDEX ( commsid , messageid )
   ) TYPE = MYISAM ;

   DROP TABLE IF EXISTS wp_comms_message_log;
   CREATE TABLE IF NOT EXISTS wp_comms_message_log (
   id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
   subject TEXT NOT NULL ,
   message LONGTEXT NOT NULL ,
   type VARCHAR( 1 ) NOT NULL DEFAULT '0',
   datetime DATETIME NOT NULL
   ) TYPE = MYISAM ;

   DROP TABLE IF EXISTS wp_sms_log;
   CREATE TABLE IF NOT EXISTS wp_sms_log (
   id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT ,
   message TEXT NOT NULL ,
   mobnum TEXT NOT NULL ,
   time VARCHAR( 60 ) NOT NULL ,
   PRIMARY KEY ( id )
   ) TYPE = MYISAM ;

   DROP TABLE IF EXISTS wp_comms_project;
   CREATE TABLE IF NOT EXISTS wp_comms_project (
   id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
   name VARCHAR( 255 ) NOT NULL ,
   project_owner TEXT NOT NULL,
   project_developer TEXT NOT NULL,
   project_client TEXT NOT NULL,
   project_notes TEXT NOT NULL,
   userid BIGINT UNSIGNED NOT NULL ,
   completed VARCHAR( 1 ) NOT NULL DEFAULT '0',
   time DATETIME NOT NULL ,
   INDEX ( name , userid)
   ) TYPE = MYISAM ;

   DROP TABLE IF EXISTS wp_comms_project_status;
   CREATE TABLE IF NOT EXISTS wp_comms_project_status (
   id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
   status VARCHAR( 1 ) NOT NULL ,
   notes LONGTEXT NOT NULL,
   stage int(10) unsigned NOT NULL,
   projid BIGINT NOT NULL ,
   INDEX ( projid )
   ) TYPE = MYISAM ;

   DROP TABLE IF EXISTS wp_comms_groups;
   CREATE TABLE IF NOT EXISTS wp_comms_groups (
   id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
   name VARCHAR( 255 ) NOT NULL ,
   active VARCHAR( 1 ) NOT NULL
   ) TYPE = MYISAM ;

   DROP TABLE IF EXISTS wp_comms_user_groups;
   CREATE TABLE IF NOT EXISTS wp_comms_user_groups (
   id bigint(20) unsigned NOT NULL auto_increment,
   userid bigint(20) unsigned NOT NULL default '0',
   groupid bigint(20) unsigned NOT NULL default '0',
   PRIMARY KEY (id),
   INDEX ( userid ),
   INDEX ( groupid )
   ) TYPE = MYISAM ;

3. omikami
   Member
   Posted 5 years ago #

   The current version installed for me but there was a problem with the grouping feature. I have not tried to send test mails yet.

4. Arash
   Member
   Posted 5 years ago #

   I have the same problem, by the solution by jefjones did not work for me :(

5. prwind
   Member
   Posted 4 years ago #

   I have installed the campaign monitor/communications and it showed up as a plugin and I activated it. No problem. I go to the comms tab and the next screen says it could not find wp-admin/communications/addressbook.php

   How do I fix this? If I have to move files let me know. If I have to edit anything let me know and show me where to edit. Thank you.

6. dunamismedia
   Member
   Posted 4 years ago #

   I'm having the same problem that prwind is asking about. After the newsletter plugin is installed, i get the same error page after clicking on the "comm" tab in wordpress. Please provide any help you can offer. thanks.

7. ganzua64
   Member
   Posted 4 years ago #

   As well I have installed the campaign monitor/communications and it showed up as a plugin and I activated it, but when I go to the comms tab and the next screen says it could not find wp-admin/communications/addressbook.php

   How do I fix this? If I have to move files let me know. If I have to edit anything let me know and show me where to edit. Thank you.

   Is there anybody out there?

8. lillefod
   Member
   Posted 4 years ago #

   I had the same problem with 'could not find wp-admin/communications/addressbook.php' so I moved the plugin from /wp-content/plugins to /wp-admin and renamed the folder 'communication' et voilá - the plugin exists :-)

9. getwitit
   Member
   Posted 4 years ago #

   Using WP 2.5 created a folder named communications in the plugins dir then extracted WP Campaign Monitor in it. Tested emails and works fine. Looking for a way to integrate this with my listing service provided by my hosting company.

Topic Closed

This topic has been closed to new replies.