Okay
  Public Ticket #2303212
Critical Error - bug
Closed

Comments

  • Simon started the conversation

    This is a major bug report.

    Error: Your website has encountered a critical error. 

    Ability to recover: Must delete wpDataTables table, and wpReportBuilder Report.

    Steps to replicate:

    1. Create wpDataTable from csv - either read from csv each time, or turn it into a db table. Doesn't matter.

    2. Create wpReportBuilder report, referencing that Data Table. Use single document download method.

    3. Scroll through the steps by hitting next, and then point the wpReportBuilder at the .docx file you wish to us as the template. Ensure the .docx has at least one misnamed field using the ${field.all} syntax. 

    4. Limit the number of rows being returned to "1"

    5. Download preview. 

    6. Your site has experienced a critical error. 

    7. Nothing you do now, including replacing the .docx will enable you to overcome this error - except deleting and recreating the wpDataTables data source, and recreating the wpReportBuilder report. 


    Screenshots here

    Imgur album

  •  2,572
    Aleksandar replied

    Hello Simon

    This shouldn't crash your website, but more likely there are either some permission issues, or there's something wrong with the template.

    Please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check Private Reply so nobody can see them except us.

    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables

  • Simon replied

    I cannot provide you an admin login, unfortunately.

    I downgraded wpDataTables to version 2.8 (instead of 2.8.1) and the problem resolved itself.

    If you wish to replicate I suggest you try on a fully updated Wordpress isntall with wpDataTables 2.8.1, wpDataTables to Gravity Forms conenctor, and the latest version of wpReportBuilder.

    Create a very simple template. Upload an excel sheet. Make sure you make a mistake in a tag. Eg ${Apples} vs ${apples} and you will see the crash message. I have been able to replicate this multiple times. With wpDatableTables Version 2.8 the error is handled gracefully, but with 2.8.1 it causes a crash. Something between wpReportBuilder and wpDataTables seems to not be working well in this manner - and it it a very frustrating experience that took much of my day to resolve. The only problem is - now I cannot in good faith update wpDataTables until the issue is resolved.  

  •  2,572
    Aleksandar replied

    Hello again Simon

    Thank you for your feedback.

    I did try to replicate the issue, but unfortunately no matter what I try, I can't get it to break. I have WordPress 5.2.3, wpDataTables 2.8.1 and Report Builder 1.1.7 - so everything is up to date. If I deliberately make a mistake, the report will still be downloaded, but instead of values - the placeholder would be used.

    There could be a conflict on your website, or something else that could cause this issue. If I had the log-in credentials, I could display all PHP errors, and see why it breaks, but without them I can only guess.

    Would you be able to duplicate your website with the Duplicator plugin? Then, you could send me the installation files, so we can clone your website and test the issue in our local environment.

    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables

  •  2
    Jason replied

    I am getting the same errors on my site - http://ccs.donor-database.com/contributions/ as soon as I click on the generate receipt button it errors out. I have yet to hear back from support on this...

  •  2,572
    Aleksandar replied

    Hi again Jason

    I really can't say much about this without taking a look from the inside.

    You can deactivate Report Builder; go to Plugin Editor, and access reportbuilder.php.

    3675439320.png

    In that file, around line 66, hit Enter to add a new row, and paste this:

    ini_set('display_errors', 1);
    ini_set('display_startup_errors', 1);
    error_reporting(E_ALL);

    So, the file looks like this:

    6066274278.png

    Save the file, activate report builder again, and try downloading the report from http://ccs.donor-database.com/contributions/ again.

    It will still break, but it should provide additional info about the error. Please share that error with me, so I at least have an idea of what's going on.

    When you're done with this, please undo your actions - deactivate the add-on; delete the extra lines of code added to reportbuilder.php file, and save it again; activate the add-on.

    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables

  •  2
    Jason replied

    Here is the error I get after adding the line to the plugin: 


    Fatal error: Uncaught Error: Call to a member function setGenerationLogic() on null in /home/cl4w1szc0rmr/public_html/websites/ccs.donor-database.com/wp-content/plugins/reportbuilder/source/class.reportbuilder.php:422 Stack trace: #0 /home/cl4w1szc0rmr/public_html/websites/ccs.donor-database.com/wp-content/plugins/reportbuilder/reportbuilder.php(258): WDTReportBuilder\ReportBuilder->build() #1 /home/cl4w1szc0rmr/public_html/websites/ccs.donor-database.com/wp-includes/class-wp-hook.php(288): WDTReportBuilder\Plugin::downloadReport('') #2 /home/cl4w1szc0rmr/public_html/websites/ccs.donor-database.com/wp-includes/class-wp-hook.php(312): WP_Hook->apply_filters('', Array) #3 /home/cl4w1szc0rmr/public_html/websites/ccs.donor-database.com/wp-includes/plugin.php(478): WP_Hook->do_action(Array) #4 /home/cl4w1szc0rmr/public_html/websites/ccs.donor-database.com/wp-admin/admin-ajax.php(175): do_action('wp_ajax_report_...') #5 {main} thrown in /home/cl4w1szc0rmr/public_html/websites/ccs.donor-database.com/wp-content/plugins/reportbuilder/source/class.reportbuilder.php on line 42

    I also get an error on the table on the page as well interesting enough...

  •  2
    echabok replied

    I have the same problem, when I click on download the report, the error shows up :"There has been a critical error on your website."

    I can provide my log-in credentials!

    Thank you.

  •  2,572
    Aleksandar replied

    Hi Jason

    Without remote access, I can't say anything about the issue, but maybe one of our developers can. I forwarded the error to him, and will let you know as soon as I hear back. The error will be present on all pages until you remove the code you've added, that's normal behavior.

    echabok, please open a new private ticket and provide us with the login credentials, so we can take a look.

    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables

  • Simon replied

    Looks like this is being found by a few people - I suspect this will come up more often.

    Have you followed the replication steps below Aleksandar to see if you can replicate? Not all of us can grant administrative access to production systems due to organisational requirements, etc. 

  •  2
    echabok replied

    Hi Aleksandar ,

    I have opened a private ticket with my login credentials 3 days ago, but didn't Receive any response. Appreciate if you could look into this matter for me.

    Thank you!

  •  2,572
    Aleksandar replied

    Hello guys.

    Sorry for the late response, we're not working on weekends.

    Simon, the issue on echabok's site was that the ZipArchive is not installed.

    However, the error message from your website is different than on echabok's, so installing the ZipArchive will probably not resolve the issue.

    I suppose duplicating your website with the Duplicator plugin is not an option either?

    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables