|
Alana
|
May 5, 2017 at 5:09 am
Hi,
We have setup Event Espresso in our website. We have some questions related to download invoice.
We have used “Invoice” Payment gateway for event registration.
After confirm registration, it will redirect to thank you page. When we click on view order button, It is showing all details but cant download PDF.
This is the link for test:
https://australianinstituteofmanagement.com.au/?ee=msg_url_trigger&snd_msgr=html&gen_msgr=html&message_type=invoice&context=purchaser&token=1-e6321e9f35e095a86ff90a51d9be42f4&GRP_ID=7&id=575
Thank you,
Vince Nicita
|
|
Josh
|
May 5, 2017 at 8:01 am
Hi Vince,
Your server is likely not configured to allow converting an html page to PDF. There’s a fatal error being thrown and if you check the server’s PHP error log you should be able to find the error which will point to what’s missing on your server. It’s likely there’s a necessary PHP function that’s been disabled by your host, and once you know the error message we’ll know the next step. Can you check your PHP error log?
|
|
Alana
|
May 7, 2017 at 11:49 pm
Hi josh,
As per your guidance, i have checked the error_log.
Below is the error log generated when i click on the Download PDF button.
Will you please have a look and provide the suggestion.
[08-May-2017 05:43:35 UTC] WordPress database error Unknown column ‘wp_esp_datetime.DTT_EVT_start’ in ‘where clause’ for query SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (786,72,923,766,419) AND wp_posts.post_type = ‘page’ AND ((wp_posts.post_status = ‘publish’)) AND wp_esp_datetime.DTT_EVT_start >= “2017-05-08 00:00” ORDER BY wp_esp_datetime.DTT_EVT_start ASC made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/wp_aim/template-events-listing.php’), get_footer, locate_template, load_template, require_once(‘/themes/wp_aim/footer.php’), wp_nav_menu, wp_get_nav_menu_items, get_posts, WP_Query->query, WP_Query->get_posts
[08-May-2017 05:43:35 UTC] WordPress database error Unknown column ‘wp_esp_datetime.DTT_EVT_start’ in ‘where clause’ for query SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (295,289,645,4165) AND wp_posts.post_type = ‘page’ AND ((wp_posts.post_status = ‘publish’)) AND wp_esp_datetime.DTT_EVT_start >= “2017-05-08 00:00” ORDER BY wp_esp_datetime.DTT_EVT_start ASC made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/wp_aim/template-events-listing.php’), get_footer, locate_template, load_template, require_once(‘/themes/wp_aim/footer.php’), wp_nav_menu, wp_get_nav_menu_items, get_posts, WP_Query->query, WP_Query->get_posts
[08-May-2017 05:43:35 UTC] WordPress database error Unknown column ‘wp_esp_datetime.DTT_EVT_start’ in ‘where clause’ for query SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (906,5379,911) AND wp_posts.post_type = ‘page’ AND ((wp_posts.post_status = ‘publish’)) AND wp_esp_datetime.DTT_EVT_start >= “2017-05-08 00:00” ORDER BY wp_esp_datetime.DTT_EVT_start ASC made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/wp_aim/template-events-listing.php’), get_footer, locate_template, load_template, require_once(‘/themes/wp_aim/footer.php’), wp_nav_menu, wp_get_nav_menu_items, get_posts, WP_Query->query, WP_Query->get_posts
Will you please help me out on this?
Thanks
|
|
Josh
|
May 8, 2017 at 9:29 am
Hi Vince,
The errors all originate from your active WordPress theme. If you temporary switch to one of the default WordPress themes does the site then allow you to download a PDF from the Invoice page? If not, do any new errors get logged?
|
|
Alana
|
May 8, 2017 at 9:41 pm
Hi josh,
Thank you for your feedback
But i don’t think so that its a theme related issue.
I have setup whole site on another dev server and below is the link
See below link:
http://198.57.136.49/~aim/?ee=msg_url_trigger&snd_msgr=html&gen_msgr=html&message_type=invoice&context=purchaser&token=1-e6321e9f35e095a86ff90a51d9be42f4&GRP_ID=7&id=575
Above link is working.
There is nothing difference in above link and the link we have posted on first post other then domain name.
See below link that is not working:
https://australianinstituteofmanagement.com.au/?ee=msg_url_trigger&snd_msgr=html&gen_msgr=html&message_type=invoice&context=purchaser&token=1-e6321e9f35e095a86ff90a51d9be42f4&GRP_ID=7&id=575
Please have a look.
I personally think https://australianinstituteofmanagement.com.au/ domain does not allow to include php script/file that should be executed once we click on Download Pdf.
Please help to sort out this issue.
Thanks
|
|
Tony
|
May 9, 2017 at 3:30 am
On the live site, can you enabled WP_DEBUG and then post here to let me know you have it enabled.
Make sure you’re not just logging the errors but displaying them as we need to see the error that is being thrown when the button is clicked and the errors you posted above don’t appear to be the problem.
|
