• Resolved Bilguun

    (@bilguun)


    Hello Andy,

    I am using the Pro version of LeadIn on a plumbing company website, http://www.atozstatewideplumbing.com. It was working fine but stopped collecting data starting about 4 days ago. When I enter a test data from the home page (First Name, Last Name, and Email) it says “the form has been submitted”, however, when I go to the LeadIn dashboard it is not showing anything. in fact my entries are gone, it is empty.

    Please help.

    Bilguun

    https://wordpress.org/plugins/leadin/

Viewing 8 replies - 1 through 8 (of 8 total)
  • Sorry for the issue. It sounds like there is a database error with your Leadin tables. This usually happens if one of the Leadin tables crashes or a funky character breaks on of the MySQL queries for the contact list.

    Do you mind creating an administrative login for andy@leadin.com? I’m happy to take a look to get to the bottom of this for you. Thanks in advance.

    To follow up with everyone else reading this thread, the issue here ended up being Backup Buddy not backing up the Leadin tables, so they got dropped. To fix this, all you need to do is manually recreate the tables:

    CREATE TABLE li_leads (
    lead_id int(11) unsigned NOT NULL AUTO_INCREMENT,
    lead_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    hashkey varchar(16) DEFAULT NULL,
    lead_ip varchar(40) DEFAULT NULL,
    lead_source text,
    lead_email varchar(255) DEFAULT NULL,
    lead_first_name varchar(255) NOT NULL,
    lead_last_name varchar(255) NOT NULL,
    lead_status set(‘contact’,’lead’,’comment’,’subscribe’,’contacted’,’customer’) NOT NULL DEFAULT ‘contact’,
    merged_hashkeys text,
    lead_deleted int(1) NOT NULL DEFAULT ‘0’,
    blog_id int(11) unsigned NOT NULL,
    company_data mediumtext NOT NULL,
    social_data mediumtext NOT NULL,
    PRIMARY KEY (lead_id),
    KEY hashkey (hashkey)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

    CREATE TABLE li_pageviews (
    pageview_id int(11) unsigned NOT NULL AUTO_INCREMENT,
    pageview_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    lead_hashkey varchar(16) NOT NULL,
    pageview_title varchar(255) NOT NULL,
    pageview_url text NOT NULL,
    pageview_source text NOT NULL,
    pageview_session_start int(1) NOT NULL,
    pageview_deleted int(1) NOT NULL DEFAULT ‘0’,
    blog_id int(11) unsigned NOT NULL,
    PRIMARY KEY (pageview_id),
    KEY lead_hashkey (lead_hashkey)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

    CREATE TABLE li_submissions (
    form_id int(11) unsigned NOT NULL AUTO_INCREMENT,
    form_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    lead_hashkey varchar(16) NOT NULL,
    form_page_title varchar(255) NOT NULL,
    form_page_url text NOT NULL,
    form_fields text NOT NULL,
    form_selector_id mediumtext NOT NULL,
    form_selector_classes mediumtext NOT NULL,
    form_hashkey varchar(16) NOT NULL,
    form_deleted int(1) NOT NULL DEFAULT ‘0’,
    blog_id int(11) unsigned NOT NULL,
    PRIMARY KEY (form_id),
    KEY lead_hashkey (lead_hashkey)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

    CREATE TABLE li_tags (
    tag_id int(11) unsigned NOT NULL AUTO_INCREMENT,
    tag_text varchar(255) NOT NULL,
    tag_slug varchar(255) NOT NULL,
    tag_form_selectors mediumtext NOT NULL,
    tag_synced_lists mediumtext NOT NULL,
    tag_order int(11) unsigned NOT NULL,
    blog_id int(11) unsigned NOT NULL,
    tag_deleted int(1) NOT NULL,
    PRIMARY KEY (tag_id)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

    CREATE TABLE li_tag_relationships (
    tag_relationship_id int(11) unsigned NOT NULL AUTO_INCREMENT,
    tag_id int(11) unsigned NOT NULL,
    contact_hashkey varchar(16) NOT NULL,
    form_hashkey varchar(16) NOT NULL,
    tag_relationship_deleted int(1) unsigned NOT NULL,
    blog_id int(11) unsigned NOT NULL,
    PRIMARY KEY (tag_relationship_id)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

    markfranklin99

    (@markfranklin99)

    Hi Andy

    It looks like I have the same problem on our site http://www.firstprinciplesconsulting.com/.

    I took a look in the Edit Plugins area and did find the area you mentioned, but it looks fine to my non-developer eyes.

    Any chance you could take a look please? Happy to give you admin access if you need it.

    Thanks, Mark

    Andy Cook

    (@andygcook)

    @markfranklin99 – I pinged you on the other thread but thought I’d post here just in case you missed that message. Do you mind creating support@leadin.com and administrative login for your site and I’ll take a closer look? Thanks!

    I ran that query and it says the table already exists. Also, since Backup buddy dumped. How can we get back the entries?

    I’m having the same problem. I get emails saying there was a submission but I recieve no data. There is no data about page hits or contact info. I’m not a coder so the info above just confuses me.

    Hi Jollyirishman, just responded to your question over on this initial thread

    Just as a follow up – there was a bug in 3.1.8 which made it seem like the tables were dropped when in fact they actually weren’t. We’ve since fixed the bug in 3.1.9, so if you update you might find that all the data is actually there. Sorry every one for any heart attacks we might have caused – we’ve since removed the functionality that checks to see if your tables were dropped so that error shouldn’t show up again.

Viewing 8 replies - 1 through 8 (of 8 total)

The topic ‘LeadIn is not registering entry’ is closed to new replies.