Error using Gravity forms entries in Excel – Plugin

  • Resolved werkplaats27

    (@werkplaats27)


    4 years, 12 months ago

    Hello, I get un error message trying to use your plugin.
    I shrink the title, but unfortunately no luck.
    Can you help me out with this.
    Thanks in advance…

    Include the following details in your message:

    Plugin Version: 1.6.1
    Gravity Forms Version: 2.4.8
    PHP Version: 7.2.17
    Wordpress Version: 5.1.1
    Error message: Uncaught Error: Undefined class constant ‘SHEET_TITLE_MAXIMUM_LENGTH’ in /var/www/vhosts/radijsconceptstore.nl/httpdocs/wp-content/plugins/gf-entries-in-excel/src/Renderer/AbstractPHPExcelRenderer.php:160
    Stack trace:
    #0 /var/www/vhosts/radijsconceptstore.nl/httpdocs/wp-content/plugins/gf-entries-in-excel/src/Renderer/PHPExcelRenderer.php(77): GFExcel\Renderer\AbstractPHPExcelRenderer->setWorksheetTitle(Object(PhpOffice\PhpSpreadsheet\Worksheet\Worksheet), Array)
    #1 /var/www/vhosts/radijsconceptstore.nl/httpdocs/wp-content/plugins/gf-entries-in-excel/src/Renderer/PHPExcelRenderer.php(113): GFExcel\Renderer\PHPExcelRenderer->setTitle(‘kransen’)
    #2 /var/www/vhosts/radijsconceptstore.nl/httpdocs/wp-content/plugins/gf-entries-in-excel/src/Renderer/PHPExcelRenderer.php(39): GFExcel\Renderer\PHPExcelRenderer->setProperties()
    #3 /var/www/vhosts/radijsconceptstore.nl/httpdocs/wp-content/plugins/gf-entries-in-excel/src/GFExcelOutput.php(64): GFExcel\Renderer\PHPExcelRenderer->handle(Array, Array, Array, false)
    #4 /var
    Error stack trace:

    #0 [internal function]: GFExcel\Renderer\AbstractPHPExcelRenderer->fatalHandler()
    #1 {main}

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

Viewing 15 replies - 1 through 15 (of 16 total)
1 2
  • Plugin Author Doeke Norg

    (@doekenorg)

    4 years, 12 months ago

    @werkplaats27 Excuses. Wordt aan gewerkt. 1.6.2 komt over een paar minuten uit en fixed dit.

    Plugin Author Doeke Norg

    (@doekenorg)

    4 years, 12 months ago

    @werkplaats27 de URL die hebt geplaatst is publiek. Voor security redenen kun je beter nu die url hergenereren voordat iemand bij de data kan.

    davouid

    (@davouid)

    4 years, 12 months ago

    Hi

    I still have an error with the update

    Fatal error: Uncaught TypeError: Argument 2 passed to GFExcel\Shorttag\DownloadUrl::handleNotification() must be of the type array, bool given, called in /home/clients/5511b56d3b46b613ce4ed971b0040b9d/pierreblanche/wp-includes/class-wp-hook.php on line 288 and defined in /home/clients/5511b56d3b46b613ce4ed971b0040b9d/pierreblanche/wp-content/plugins/gf-entries-in-excel/src/Shorttag/DownloadUrl.php:54 Stack trace: #0 /home/clients/5511b56d3b46b613ce4ed971b0040b9d/pierreblanche/wp-includes/class-wp-hook.php(288): GFExcel\Shorttag\DownloadUrl->handleNotification(”, false) #1 /home/clients/5511b56d3b46b613ce4ed971b0040b9d/pierreblanche/wp-includes/plugin.php(208): WP_Hook->apply_filters(”, Array) #2 /home/clients/5511b56d3b46b613ce4ed971b0040b9d/pierreblanche/wp-content/plugins/gravityforms/common.php(1218): apply_filters(‘gform_replace_m…’, ”, false, false, false, false, false, ‘html’) #3 /home/clients/5511b56d3b46b613ce4ed971b0040b9d/pierreblanche/wp-content/plugins/gravityforms/includes/fields/class-gf-field-radio.php in /home/clients/5511b56d3b46b613ce4ed971b0040b9d/pierreblanche/wp-content/plugins/gf-entries-in-excel/src/Shorttag/DownloadUrl.php on line 54

    Plugin Author Doeke Norg

    (@doekenorg)

    4 years, 12 months ago

    Hi @davouid thanks for ketting me know. Will resolve ASAP and let you know.

    Can you provide me with some version info? PHP, Gf and WP. Thanks.

    Thread Starter werkplaats27

    (@werkplaats27)

    4 years, 12 months ago

    Hello Doeke, I just installed version 1.62 and this seems to work. Unfortunate the plugin breaks the whole website (white screen in browser) Could you please check this. (this also occurred in with the 1.61 plugin version. Kind regards, Lars

    Plugin Author Doeke Norg

    (@doekenorg)

    4 years, 12 months ago

    Hi @werkplaats27,

    Can you perhaps help me out, and try if this works:

    Replace line 54-56 of gf-entries-in-excel/src/Shorttag/DownloadUrl.php with

    public function handleNotification($text, $form)
    {
        if (!is_array($form)) {
            return $text;
        }

        $custom_merge_tag = '{' . self::SHORTTAG . '}';

    If that restores the site then I know what to fix. I can’t seem to reproduce the error :S

    Plugin Author Doeke Norg

    (@doekenorg)

    4 years, 12 months ago

    @werkplaats27 @davouid was able to reproduce. Just released 1.6.3. Should be good now. Please let me know.

    Thread Starter werkplaats27

    (@werkplaats27)

    4 years, 12 months ago

    Hi Doeke, this works fine.. Thanks.

    Plugin Author Doeke Norg

    (@doekenorg)

    4 years, 12 months ago

    @werkplaats27 great to hear. Blood pressure stabilizing now 🙂

    Thread Starter werkplaats27

    (@werkplaats27)

    4 years, 12 months ago

    Fine… Thanks for your really quick reply. One question. You are a WordPress developer… Do you do other projects? Kind regards. LB

    Plugin Author Doeke Norg

    (@doekenorg)

    4 years, 12 months ago

    @werkplaats27 Hi Lars,

    No I don’t. I’m a full time developer for a company. This plugin is just a hobby project gotten out of hand 😉

    davouid

    (@davouid)

    4 years, 12 months ago

    Hi

    Everything is up to date… here is the gf rapport

    ### Gravity Forms ###

    Registration: Site registered ( 822a451f-72a2-485b-bc88-dbf8cf6f7540 ) ✔
    Version: 2.4.8 ✔
    Upload folder: /home/clients/5511b56d3b46b613ce4ed971b0040b9d/pierreblanche/wp-content/uploads/gravity_forms/
    Upload folder permissions: Writable ✔
    Output CSS: Yes
    Output HTML5: Yes
    No-Conflict Mode: Yes
    Currency: CHF
    Background updates: Yes
    Locale: fr_FR

    ### Add-Ons ###

    Bulk Actions Pro for Gravity Forms: by JetSloth – 1.2.19 ✔
    Gutenberg: by rocketgenius – 1.0-rc-1.2 ✔
    Image Choices: by JetSloth – 1.2.4 ✔
    MailChimp: by rocketgenius – 4.6 ✔
    Quiz: by Rocketgenius – 3.1 ✔

    ### Database ###

    Database Version: 2.4.8 ✔ Your database is up-to-date.
    wp_gf_form_view: ✔
    wp_gf_form_meta: ✔
    wp_gf_form: ✔
    wp_gf_form_revisions: ✔
    wp_gf_entry: ✔
    wp_gf_entry_meta: ✔
    wp_gf_entry_notes: ✔
    wp_gf_draft_submissions: ✔
    wp_gf_addon_feed: ✔

    ### WordPress ###

    Home URL: https://lapierreblanche.ch
    Site URL: https://lapierreblanche.ch
    WordPress Version: 5.1.1 ✔
    WordPress Multisite: No
    WordPress Memory Limit: 640M
    WordPress Debug Mode: No
    WordPress Debug Log: No
    WordPress Script Debug Mode: No
    WordPress Cron: Yes
    WordPress Alternate Cron: No
    Background tasks: Yes ✔

    ### Active Theme ###

    Pierreblanche: by trivialmass (http://www.trivialmass.ch/) – 1.0 (Development) ✘

    ### Active Plugins ###

    Admin Columns Pro: by AdminColumns.com – 4.3.8 ✔
    Admin Columns Pro – Advanced Custom Fields (ACF): by Admin Columns – 2.3.2 ✔
    Advanced Custom Fields: Font Awesome: by mattkeys – 3.0.2 ✔
    Advanced Custom Fields PRO: by Elliot Condon – 5.8.0-beta4.1 ✔
    Classic Editor: by WordPress Contributors – 1.4 ✔
    Disable Comments: by Samir Shah – 1.9.0 ✔
    Duplicate Post: by Enrico Battocchi – 3.2.2 ✔
    GP Limit Dates: by David Smith – 1.0.19 ✔
    GP Multi-page Navigation: by Gravity Wiz – 1.0.5 ✔
    GP Preview Submission: by David Smith – 1.2.13 ✔
    GP Read Only: by David Smith – 1.3.8 ✔
    Gravity Perks: by Gravity Wiz – 2.1.4 ✔
    Intuitive Custom Post Order: by hijiri – 3.1.2 ✔
    Really Simple SSL: by Rogier Lankhorst, Mark Wolters – 3.1.5 ✔
    Redirection: by John Godley – 4.2.3 ✔
    Relevanssi: by Mikko Saari – 4.1.4 ✔
    Restricted Site Access: by Jake Goldman, 10up, Oomph – 7.1.0 ✔
    Search & Filter Pro: by Code Amp – 2.4.6 ✔
    Snazzy Maps: by Atmist – 1.1.5 ✔
    SVG Support: by Benbodhi – 2.3.15 ✔
    WP GraphQL: by WPGraphQL – 0.2.2 ✔
    WP Migrate DB Pro: by Delicious Brains – 1.9.6 ✔
    WP Migrate DB Pro Media Files: by Delicious Brains – 1.4.14 ✔
    Yoast SEO: by Team Yoast – 11.0 ✔

    ### Web Server ###

    Software: Apache
    Port: 80
    Document Root: /home/clients/5511b56d3b46b613ce4ed971b0040b9d/pierreblanche

    ### PHP ###

    Version: 7.3.4 ✔
    Memory Limit: 640M
    Maximum Execution Time: 60
    Maximum File Upload Size: 300M
    Maximum File Uploads: 100
    Maximum Post Size: 300M
    Maximum Input Variables: 1000
    cURL Enabled: Yes (version 7.38.0)
    OpenSSL: OpenSSL 1.0.1t 3 May 2016 (268439887)
    Mcrypt Enabled: Yes
    Mbstring Enabled: Yes
    Loaded Extensions: Core, date, libxml, openssl, pcre, sqlite3, zlib, bcmath, bz2, calendar, ctype, curl, dom, hash, fileinfo, filter, ftp, gd, gettext, gmp, SPL, iconv, session, intl, json, ldap, mbstring, standard, pcntl, PDO, mysqlnd, pdo_sqlite, pgsql, Phar, posix, Reflection, imap, SimpleXML, soap, sodium, pdo_mysql, exif, tidy, tokenizer, wddx, xml, xmlreader, xmlwriter, xsl, mysqli, cgi-fcgi, geos, imagick, mailparse, mcrypt, mongodb, OAuth, PDFlib, propro, raphf, ssh2, timezonedb, xmlrpc, yaz, http, zip, ionCube Loader

    ### MySQL ###

    Version: 5.6.35 ✔
    Database Character Set: utf8
    Database Collation: utf8_general_ci

    davouid

    (@davouid)

    4 years, 12 months ago

    Thanks!

    davouid

    (@davouid)

    4 years, 12 months ago

    It is working!

    Thanks

    davouid

    (@davouid)

    4 years, 12 months ago

    Have a beer for me!

    Thanks again for this plug, and the support.

    It is even better than some paying plug!

Viewing 15 replies - 1 through 15 (of 16 total)
1 2
  • The topic ‘Error using Gravity forms entries in Excel – Plugin’ is closed to new replies.