Hey there, Awesome Customers!

Just a heads up: We'll be taking a breather to celebrate International Workers' Day (May 1st and 2nd - Wednesday and Thursday) and Orthodox Easter from Good Friday (May 3rd) through Easter Monday (May 6th). So, from May 1st to May 6th, our team will be off enjoying some well-deserved downtime.

During this time, our customer support will be running on a smaller crew, but don't worry! We'll still be around to help with any urgent matters, though it might take us a bit longer than usual to get back to you.

We'll be back in action at full throttle on May 7th (Tuesday), ready to tackle your questions and requests with gusto!

In the meantime, you can explore our documentation for Amelia and wpDataTables. You'll find loads of helpful resources, including articles and handy video tutorials on YouTube (Amelia's YouTube Channel and wpDataTables' YouTube Channel). These gems might just have the answers you're looking for while we're kicking back.

Thanks a bunch for your understanding and support!

Catch you on the flip side!

Warm regards,

TMS

Okay
  Public Ticket #1105360
http error 500 - variable in table rows
Closed

Comments

  •  3
    Axelmet started the conversation

    Good morning,

    UPDATE problem HELP! after upgrading to version 1.0.3 - March 14, 2017, some reports are no longer working. Page (and the preview report) return HTTP ERROR 500. I already made the re-upload, deactivated and reactivated the plugin but nothing changes. I also tried to create a new report. Obviously, before the update, these simple reports were working fine..

    n.b. page in error: admin-ajax.php

    Put variables in rows When I use a variable (in excel file), the report writes it once, I would need to repeat it for each row in the table, something like ${myvariable.all}

  • [deleted] replied

    Hi Axelmet,
    Thank you for the purchase.

    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 so nobody can see it except us.

  •   Axelmet replied privately
  •   Axelmet replied privately
  • [deleted] replied

    Hi Axelmet,

    These errors are probably because of some bad variable name in the template. I have tried to generate reports with ID 1 and 2 and they are working. Reports 3, 4, 5 are not working. Also I tried to see template of the report with ID 3 from this link:

    http://www.zconsulting.it/mediazione/wp-content/uploads/2017/02/Lettera-convocazione-istante.docx

    But when I click on it I got the message that page doesn't exists: "Spiacente, ma la pagina richiesta non esiste. Forse fare una ricerca potrebbe aiutare.". Are you sure you have the template on this address?

    These reports worked for you in version 1.0.2 or you created them now?


  •  3
    Axelmet replied

    hello Milos, you're absolutely right, the association with the template it was wrong, even though I have no idea why ... these are reports that already existed from the previous version. Thus, Reports 3 and 4 now work perfectly :)).

    The problem now remains only on report number 5 (sounds like the Mambo ...),, the .xlsx file exists but the report does not work, with the same error.

    Have you also an idea on how to solve the problem with variables in rows?

  • [deleted] replied

    Hi Axelmet,

    The issue with Report with ID 5 is probably because of some wrong name of the column or variable. Can you check if the names are same as column original headers - Link. Please note that they are case sensitive. If that is not the case I will login and take a look a little more closer what is happening.

    Unfortunately it is not possible to use variables in this way like ${myvariable.all}. Only way to use it is as a single value like ${myvariable}.

    Thanks

  •  3
    Axelmet replied

    yes, maybe it's time that you take a look, the names are right, the problem is that the Report Builder does not accept XLSX file, or have problems with Generation logic: single file.

    I tried to flank the report 6 that generates a docx on the same wpdatatable and it works.

    Generally it does not work with any report template .xlsx

    I'm demoralizing :(

    thank you

  • [deleted] replied

    Hi Axelmet,

    From WordPress 4.7.2 there is a one bug by WordPress (they said they will fix in the next update) when you try to upload Excel or CSV file. So when I try to add a new template I got this message "Questo tipo di file non è consentito per questioni di sicurezza.". Please go in wp-config.php file of your WordPress and add this line at the and of page:

    define('ALLOW_UNFILTERED_UPLOADS', true);
    

    Until then I am not able to upload the template. When you do that please notify me so I could test Report with ID 5.

  •  3
    Axelmet replied

    I added the line to the config, though I always loaded .xlsx template with no problems

  • [deleted] replied

    Hi Axelmet,
    Sorry for delayed reply.

    Can you check do you have installed PHP ZIP Archive on your server. Probably that is the reason why it's not working. You can contact your Host provider to install it for you or you can install it by your own. All reports that are working are ZIP with multiple files for each row except this with ID 5 that is Single file report?

  •  3
    Axelmet replied

    Hi Milos, I have not quite clear what you say.
    "All reports that are working are ZIP with multiple files for each row." This to me means that php zip is available ...

    ID5 is a single file .xlsx report, How could it be php zip not enabled, if the single report does not use php zip?

    SUMMARY
    • ID 1 - ID 2 - 3 ID - ID 4, which are DOCX "ZIP files with multiple files for each row", all work
    • ID 5 That is Single report file (XLSX NO ZIP), does not work.
    • ID 6 That is Single report files (DOCX NO ZIP) works fine.

    XLS does not work with either "ZIP with multiple files for each row" and "Single File"

    I'm not able to give solutions but, for me, it is clear that the .xls / .xlsx files do not work.

    I hope to have written properly

    Thanks


  •   Axelmet replied privately
  • [deleted] replied

    Hi Axelmet,

    Yes I enabled debugging mode, but now I turned it off. The error that I am getting when I am trying to download report from ID 5:

    Fatal error: Class 'PHPExcel_Worksheet_HeaderFooter' not found in /web/htdocs/www.zconsulting.it/home/mediazione/wp-content/plugins/wpdatatables/lib/phpExcel/PHPExcel/Worksheet.php on line 348

    Report with ID 6 is using the same table as Report with ID 5? So probably the issue is in the template. This is the error when there is something wrong with the template. Can you try to create a new one from scratch? 

  •  3
    Axelmet replied

    Hi Milos,

    Yes, Report with ID 6 is using the same table as Report with ID 5.

    I created a new .xlsx file with only one field but the problem remains.
    With the same installation of excel I also saved as .doc but the result is the same.
    I use Excel 2010 and Excel 2016
    Could you put an excel file made by you?
    Report Builder ID 5
    wpdatatable id 12
    field: ${stato.all}

    you can modify it freely

    tanks

  • [deleted] replied

    Hi Axelmet,

    It is fixed now. Some files from PHPExcel lib are not uploaded probably when you were uploading wpDataTables plugin. I have added these two files and now downloading report is working. Sorry we needed so much time to investigate this issue.

  •  3
    Axelmet replied

    Milos, you are the best!
    I had imagined that the fault was mine.
    many apologize for the time that I did miss you, sometimes cuteftp has some problems with the files and warns me that one or more files already exist (but this is untrue).
    I must investigate the other debugging alerts.

    Thanks again

  • [deleted] replied

    Hi Axelmet,

    No problem, you are welcome We'd greatly appreciate it if you could take a minute and leave a review on CodeCanyon on this link. Thanks! 

  •  3
    Axelmet replied

    I can not! due to a fault on CodeCanyon (attach)

  • [deleted] replied

    Hi Axelmet,

    Thank you for your great review. Gravity form integration is something that we are working on