Fatal Error

  • Resolved renegade16400

    (@renegade16400)


    8 years, 2 months ago

    Hello,

    First off, this is the error message I am recieving after I submit my Contact form:

    Fatal error: Call to a member function getWorksheets() on null in /home4/talbotdems/public_html/wp-content/plugins/cf7-google-sheets-connector/lib/google-sheets.php on line 75

    Below is my code for my content:

    <h3><center> Honorary Chair, Patron, or Sponsor</center></h3>
    <div style=”border:1px solid #259AE8;”>
    <label for=”fname”> First Name</label>
    <input type=”text” id=”lname” name=”firstname” placeholder=”John”>
    <label for=”lname”> Last Name</label>
    <input type=”text” id=”lname” name=”lastname” placeholder=”Doe”>
    <label for=”email”> Email</label>
    <input type=”text” id=”email” name=”email” placeholder=”[email protected]”>
    <label for=”adr”> Address</label>
    <input type=”text” id=”adr” name=”address” placeholder=”Address”>
    <label for=”city”> City</label>
    <input type=”text” id=”city” name=”city” placeholder=”City”>
    <label for=”state”>State</label>
    <select>
    <option value=”AL”>Alabama</option>
    <option value=”AK”>Alaska</option>
    <option value=”AZ”>Arizona</option>
    <option value=”AR”>Arkansas</option>
    <option value=”CA”>California</option>
    <option value=”CO”>Colorado</option>
    <option value=”CT”>Connecticut</option>
    <option value=”DE”>Delaware</option>
    <option value=”DC”>District Of Columbia</option>
    <option value=”FL”>Florida</option>
    <option value=”GA”>Georgia</option>
    <option value=”HI”>Hawaii</option>
    <option value=”ID”>Idaho</option>
    <option value=”IL”>Illinois</option>
    <option value=”IN”>Indiana</option>
    <option value=”IA”>Iowa</option>
    <option value=”KS”>Kansas</option>
    <option value=”KY”>Kentucky</option>
    <option value=”LA”>Louisiana</option>
    <option value=”ME”>Maine</option>
    <option value=”MD”>Maryland</option>
    <option value=”MA”>Massachusetts</option>
    <option value=”MI”>Michigan</option>
    <option value=”MN”>Minnesota</option>
    <option value=”MS”>Mississippi</option>
    <option value=”MO”>Missouri</option>
    <option value=”MT”>Montana</option>
    <option value=”NE”>Nebraska</option>
    <option value=”NV”>Nevada</option>
    <option value=”NH”>New Hampshire</option>
    <option value=”NJ”>New Jersey</option>
    <option value=”NM”>New Mexico</option>
    <option value=”NY”>New York</option>
    <option value=”NC”>North Carolina</option>
    <option value=”ND”>North Dakota</option>
    <option value=”OH”>Ohio</option>
    <option value=”OK”>Oklahoma</option>
    <option value=”OR”>Oregon</option>
    <option value=”PA”>Pennsylvania</option>
    <option value=”RI”>Rhode Island</option>
    <option value=”SC”>South Carolina</option>
    <option value=”SD”>South Dakota</option>
    <option value=”TN”>Tennessee</option>
    <option value=”TX”>Texas</option>
    <option value=”UT”>Utah</option>
    <option value=”VT”>Vermont</option>
    <option value=”VA”>Virginia</option>
    <option value=”WA”>Washington</option>
    <option value=”WV”>West Virginia</option>
    <option value=”WI”>Wisconsin</option>
    <option value=”WY”>Wyoming</option>
    </select>
    <label for=”zip”>Zip</label>
    <input type=”text” id=”zip” name=”zip” placeholder=”12345″>
    <label for=”occupation”>Occupation/Employer</label>
    <input type=”text” id=”occupation” name=”occupation”>
    <label for=”citizen”>U.S. Citizenship Status</label>
    [select* menu-595 “Yes” “No”]
    <label for=”purchase”>Please select the ticket(s) you would like to purchase</label>
    [checkbox* checkbox-312 “Honorary Chair – $5000 |5000.00” “Patron – $2500 |2500.00” “Sponsor – $1500 |1500.00”]
    <label> Please select your preferred payment method (required) </label>
    [select menu-222 “Pay with Credit Card|paypal”]
    <h4><center><i>Upon submission, please wait for transfer to the payment page. Thank you.</i></center></h4>
    <center>[submit “Purchase Now”]</center>
    </div>

    Lastly, here are the Google Sheet columns I made:

    date
    text-fname
    text-lname
    text-email
    text-adr
    text-city
    select-state
    text-zip
    text-occupation
    select-citizen
    checkbox-312

    Any help you could give me would be greatly appreciated!!

    The page I need help with: [log in to see the link]

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author WesternDeal

    (@westerndeal)

    8 years, 2 months ago

    Hi @renegade16400,

    Thanks for using the plugin,
    The above error indicates that there is something wrong with integration with your google account where specified google sheets are not available or either the sheet name and tab names added under contact forms would be wrong.

    I would like to suggest you that
    – can you re-authenticate with google account again ?
    – verify with the sheet-name and tab-name you had used.

    Then, let me know what errors you have in debug log,
    which helps us to solve your issue.

    Thanks
    Jina Shah

    Thread Starter renegade16400

    (@renegade16400)

    8 years, 2 months ago

    Thanks so much. The error problem is resolved but now I think I’m having issues with exporting the data. The only data that is currently being exported to the Google Doc is the date, menu-595, and checkbox-312. Looking at the code below, can you tell me the values that I need to plug into the column for each of the following items: first name, last name, email, address, city, state, zip code, and occupation? I’m not sure what debug log is, I apologize.

    Here is my line of code:

    <h3><center> Honorary Chair, Patron, or Sponsor</center></h3>
    <div style=”border:1px solid #259AE8;”>
    <label for=”fname”> First Name</label>
    <input type=”text” id=”lname” name=”firstname” placeholder=”John”>
    <label for=”lname”> Last Name</label>
    <input type=”text” id=”lname” name=”lastname” placeholder=”Doe”>
    <label for=”email”> Email</label>
    <input type=”text” id=”email” name=”email” placeholder=”[email protected]”>
    <label for=”adr”> Address</label>
    <input type=”text” id=”adr” name=”address” placeholder=”Address”>
    <label for=”city”> City</label>
    <input type=”text” id=”city” name=”city” placeholder=”City”>
    <label for=”state”>State</label>
    <select>
    <option value=”AL”>Alabama</option>
    <option value=”AK”>Alaska</option>
    <option value=”AZ”>Arizona</option>
    <option value=”AR”>Arkansas</option>
    <option value=”CA”>California</option>
    <option value=”CO”>Colorado</option>
    <option value=”CT”>Connecticut</option>
    <option value=”DE”>Delaware</option>
    <option value=”DC”>District Of Columbia</option>
    <option value=”FL”>Florida</option>
    <option value=”GA”>Georgia</option>
    <option value=”HI”>Hawaii</option>
    <option value=”ID”>Idaho</option>
    <option value=”IL”>Illinois</option>
    <option value=”IN”>Indiana</option>
    <option value=”IA”>Iowa</option>
    <option value=”KS”>Kansas</option>
    <option value=”KY”>Kentucky</option>
    <option value=”LA”>Louisiana</option>
    <option value=”ME”>Maine</option>
    <option value=”MD”>Maryland</option>
    <option value=”MA”>Massachusetts</option>
    <option value=”MI”>Michigan</option>
    <option value=”MN”>Minnesota</option>
    <option value=”MS”>Mississippi</option>
    <option value=”MO”>Missouri</option>
    <option value=”MT”>Montana</option>
    <option value=”NE”>Nebraska</option>
    <option value=”NV”>Nevada</option>
    <option value=”NH”>New Hampshire</option>
    <option value=”NJ”>New Jersey</option>
    <option value=”NM”>New Mexico</option>
    <option value=”NY”>New York</option>
    <option value=”NC”>North Carolina</option>
    <option value=”ND”>North Dakota</option>
    <option value=”OH”>Ohio</option>
    <option value=”OK”>Oklahoma</option>
    <option value=”OR”>Oregon</option>
    <option value=”PA”>Pennsylvania</option>
    <option value=”RI”>Rhode Island</option>
    <option value=”SC”>South Carolina</option>
    <option value=”SD”>South Dakota</option>
    <option value=”TN”>Tennessee</option>
    <option value=”TX”>Texas</option>
    <option value=”UT”>Utah</option>
    <option value=”VT”>Vermont</option>
    <option value=”VA”>Virginia</option>
    <option value=”WA”>Washington</option>
    <option value=”WV”>West Virginia</option>
    <option value=”WI”>Wisconsin</option>
    <option value=”WY”>Wyoming</option>
    </select>
    <label for=”zip”>Zip</label>
    <input type=”text” id=”zip” name=”zip” placeholder=”12345″>
    <label for=”occupation”>Occupation/Employer</label>
    <input type=”text” id=”occupation” name=”occupation”>
    <label for=”citizen”>U.S. Citizenship Status</label>
    [select* menu-595 “Yes” “No”]
    <label for=”purchase”>Please select the ticket(s) you would like to purchase</label>
    [checkbox* checkbox-312 “Honorary Chair – $5000 |5000.00” “Patron – $2500 |2500.00” “Sponsor – $1500 |1500.00”]
    <label> Please select your preferred payment method (required) </label>
    [select menu-222 “Pay with Credit Card|paypal”]
    <h4><center><i>Upon submission, please wait for transfer to the payment page. Thank you.</i></center></h4>
    <center>[submit “Purchase Now”]</center>
    </div>

    Plugin Author WesternDeal

    (@westerndeal)

    8 years, 2 months ago

    Hello,
    Can you send me the URL of site
    Also it looks you are not using CF7 tags instead you have used direct html code to display, that’s why you input data is not saving in google sheet..

    Let us know with link of the site..

    Thanks
    Abdullah

    Thread Starter renegade16400

    (@renegade16400)

    8 years, 2 months ago

    http://talbotdems.org/the-douglass-tubman-dinner/

    So how to I export using html code?

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

The topic ‘Fatal Error’ is closed to new replies.