Jump to content

Mailchimp integration issue

Recommended Posts

Hi, I have been testing the mailchieenmp integration. and I found 2 issues.


1) If by mistake you dont create a list right after you setup the mailchimp API key, you wont be able to do it after... There  MUST be an option to create a list after the API key has been saved. I had this problem and I was forced to disconnect the mailchimp connection and make it again to be able to add a list.


2) When I try to add the list , I receive this error.. Any idea?


type - Schema describes string, NULL found instead vendor - Schema describes string, NULL found instead






Share this post

Link to post
Share on other sites


The error you are encountering indicates there are orphaned products in your WHMCS database (ie. products which are assigned to a non-existent product group).

To identify the problematic product,  the Utilities > Logs > Module debug Log tool can be used
Please enable it, reproduce the problem, disable it again and then review the data to identify the problematic product.

More detailed instructions are published at http://docs.whmcs.com/Troubleshooting_Module_Problems

This can be resolved in two ways:

  1. Delete the orphaned products from the tblhosting table. OR
  2. Insert a new record into tblproductgroups with the same id as the missing product group (tblproducts.gid) value. Call it something like "Orphaned Products" so you can deal with the product as you see fit via the Setup > Products/Services> Products/Services page.

Share this post

Link to post
Share on other sites

I got this fixed but my orphaned product was in tblproducts not tblhosting

Share this post

Link to post
Share on other sites

Is there any way to list the orphaned products? maybe an SQL query or something similar to identify that products...



Share this post

Link to post
Share on other sites

to get a list of IDs of products (and their product group) that have an invalid product group, the SQL query below should work...

SELECT id,gid FROM tblproducts WHERE gid NOT IN (SELECT id FROM tblproductgroups)


Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Similar Content

    • By MaikelVE
      Hi! I’ve purchased a third party addon, pre made WHMCS kb articles, but now my knowledgebase is realy slow. Looked into the database and saw that the ID’s are starting from 2001. 
      Could the ID be a problem?
    • By oklomsy
      hey everyone i really need help so i want to  make a login page but its not free to register and you need to buy the premium plan license key to login so you login with the license key you get and you get access to everything but i dont know how so please help me, i did make a login form and a database and a user and it has to be on PHP, so if you want just give me the codes and instructions and i will do it  your help is very appreciated 
    • By garybarr
      Maybe I'm wanting too much, maybe I'm doing something wrong, or maybe I found a glitch nobody thought of...
      But when a client has a change of email address,  it sends an update to MailChimp, which is bounced back.  (Added Module Debug Log below)
      If a customer checks "Don't Send client marketing emails", saves it... Changes their email and then unchecks it... It would work.  But what client would know to do that?  So if their email address ever changes, they will never be able to get emailed again...without a lot of manual interaction after someone either complains or just would happen to know they changed it.
      Ideas or thoughts?
      Array (     [id] => cust-11984     [email_address] => dcspamproof1@gmail.com     [opt_in_status] => 1     [company] =>      [first_name] => Test     [last_name] => User     [orders_count] => 0     [total_spent] => 0     [address] => Array         (             [address1] =>              [address2] =>              [city] =>              [province] =>              [postal_code] =>              [country] =>              [country_code] => US         ) ) ==============================================================================
      Array (     [type] => http://developer.mailchimp.com/documentation/mailchimp/guides/error-glossary/     [title] => Invalid Resource     [status] => 400     [detail] => An email address may not be changed once a customer is created.     [instance] => a1e12c27-ff1c-499f-96bf-cb1e8cdc8942 )  
    • By WebsiteIntegrations
      In the mailchimp integration settings it has an option called User opt in that says " When enabled, users will be asked to confirm they wish to opt-in to your mailing list during the signup/checkout process "
      I am not seeing a place on register/checkout that is showing this opt in option. Is there suppose to be?!
    • By ModulesGarden
      Next version of DNS Manager For WHMCS is ready! Version 1.9 contains several important improvements and fixes which you can't miss!
      ModulesGarden DNS Manager For WHMCS is a fully featured addon module that allows your customers to manage DNS zones and records within your WHMCS client area!
      As an administrator you will have full control over all DNS aspects and access to broad range of management options.
      Your customers will benefit from quick and easy management of zones and records without even leaving your website.
      New Features:

      Improved Import Tool: works with a large amount of domains
      Managing DNS and rDNS records per product in the client area
      Grouping and sorting zone records in the client area
      Switching template in the client area: 'Simple' or 'Advanced'
      Adding multiple records in the 'One Page' template
      Added support for PowerDNS Hosted submodule
      Added support for DNS Made Easy submodule
      Added support for Import Tool: SimpleDNS, DirectAdmin, DNS Made Easy
      Improved errors reporting in the Import Tool
      Improved client area design
      Added Dutch translation


      Fixed incorrect filtering in the client area
      Fixed a bug with the SRV records in cPanel submodule
      Multiservers Functionality: domain is no longer removed when exists in other product

      Are you interested?
      ✔ Order DNS Manager For WHMCS Now!
      Do you need more information?
      ✔ Read More About DNS Manager For WHMCS
      Are you looking for complete documentation?
      ✔ Visit DNS Manager WHMCS Wiki
      Check Out Also Our Other Products:
      ✔ Rackspace Cloud Servers For WHMCS
      ✔ cPanel Manage2 For WHMCS
      ✔ cPanel Extended For WHMCS
      ✔ Rackspace Email For WHMCS
      ✔ Rackspace Email Extended For WHMCS
      ✔ WWD GoDaddy Domains For WHMCS
      ✔ Advanced Billing For WHMCS
      ✔ DirectAdmin Extended For WHMCS
      ✔ Google Apps For WHMCS
      ✔ Zimbra Email For WHMCS
      ✔ Plesk Extended For WHMCS
      ✔ cPanel Pack For WHMCS
      ✔ Zendesk For WHMCS
      ✔ Resellers For WHMCS
      ✔ Liquid Web For WHMCS
      ✔ Liquid Web Load Balancer For WHMCS
      ✔ Storm On Demand For WHMCS
      ✔ Storm On Demand Load Balancer For WHMCS
      ✔ Storm Servers Billing For WHMCS
      ✔ SolusVM Extended VPS For WHMCS
      ✔ SolusVM Extended Cloud For WHMCS
      ✔ SolusVM Extended Reseller For WHMCS
      ✔ Zimbra Email For HostBill
      ✔ DirectAdmin Extended For HostBill
      Coming Soon:

      SolusVM Extended VPS, Cloud For WHMCS - version 1.2 with fixes and improvements
      Plesk Extended For WHMCS - update
      Gateway Charges For WHMCS - add additional fee to invoice depending on chosen Payment Gateway
      cPanel Extended For WHMCS - update
      DirectAdmin Extended For WHMCS - update
      IP Manager For WHMCS - advanced IP Management and auto-assignment of addresses to services
      Proxmox Module For WHMCS - owned licenses - with support for IP Manager For WHMCS, DNS Manager For WHMCS and Advanced Billing For WHMCS modules!
      Enom Email Module For WHMCS - offer email services to customers having Enom domain

      Do You Need Custom Software Development?
      ✔ Don't hesitate any longer! Contact us now!
      For more information about our promotions, products and company activity visit our Facebook, Forums, Twitter and Blog!
      ✔ Facebook
      ✔ Forums
      ✔ Twitter
      ✔ Blog
  • Recently Browsing   0 members

    No registered users viewing this page.


Important Information

By using this site, you agree to our Terms of Use & Guidelines