No codes

[mierlp]

Hello,

We are very close to go live, but as today we get no QR codes in our mailbox.

When i order i get the new client mail and the client gets the order overview mail, but no tickets are mailed…
Also when i resend the tickets in WooCommerce, it does not work.

Did you ever seen this issue?

[Victor]

Hi Peter!

I’m sorry to hear you are having that problem. I’d be happy to help you sort it out.

From what you describe it seems other emails are being sent out so that’s good. But if the ticket emails are not being sent, then there could be an error.

Could you please enable WP_DEBUG and WP_DEBUG_LOG ? This will create a debug.log file inside the /wp-content directory.

After that, try reproducing the issue a few times by re-sending the email from the order, so that in case there is an error, it will be saved into the debug.log file. Please share that log file with us so we can see if any problem from there.

If there are no errors showing up, then it could be a theme or plugin conflict somehow. To make sure we are not dealing with a conflict, please go through the steps outlined in our Testing for Conflicts guide and see if you can reproduce the same issue under default conditions.

Let me know how it goes.

Thanks,
Victor

[mierlp]

Hi,
I dit enable debugging, but no file is created in de content.

Can you please help me or give another tip?

Thanx.

[Victor]

Hi Peter,

Thanks for trying that out.

I did some tests on my end and the ticket emails are being sent, so I suspect this could be a conflict with your theme or another plugin.

Did you happen to notice a difference when deactivating all other plugins or switching to a default WordPress theme, like Twenty Seventeen? What happens if you try deactivating all plugins and switching to the Twenty Seventeen theme together? Do you notice a difference then?

If you see no difference in those conditions, then we’ll need to do some deeper troubleshooting.

Let me know how it goes.

Best,
Victor

[mierlp]

This is de debug file…can you please look at it. Thanx !

I can not uplod .log or .txt files.
This is in the log:

[10-Aug-2018 04:47:44 UTC] WordPress database error Unknown column ‘EventStartDate’ in ‘order clause’ for query SELECT wp_posts.ID FROM wp_posts WHERE 1=1 AND wp_posts.post_type = ‘tribe_events’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘completed’ OR wp_posts.post_status = ‘not-completed’ OR wp_posts.post_status = ‘pending-payment’ OR wp_posts.post_status = ‘refunded’ OR wp_posts.post_status = ‘denied’ OR wp_posts.post_status = ‘tribe-ea-success’ OR wp_posts.post_status = ‘tribe-ea-failed’ OR wp_posts.post_status = ‘tribe-ea-schedule’ OR wp_posts.post_status = ‘tribe-ea-pending’ OR wp_posts.post_status = ‘tribe-ea-draft’) ORDER BY EventStartDate DESC, wp_posts.post_date DESC LIMIT 0, 1 made by require(‘C:\inetpub\wwwroot\EventSales\wp-blog-header.php’), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts
[11-Aug-2018 06:20:14 UTC] WordPress database error Unknown column ‘EventStartDate’ in ‘order clause’ for query SELECT wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND (
wp_term_relationships.term_taxonomy_id IN (61)
) AND wp_posts.post_type = ‘tribe_events’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘completed’ OR wp_posts.post_status = ‘not-completed’ OR wp_posts.post_status = ‘pending-payment’ OR wp_posts.post_status = ‘refunded’ OR wp_posts.post_status = ‘denied’ OR wp_posts.post_status = ‘tribe-ea-success’ OR wp_posts.post_status = ‘tribe-ea-failed’ OR wp_posts.post_status = ‘tribe-ea-schedule’ OR wp_posts.post_status = ‘tribe-ea-pending’ OR wp_posts.post_status = ‘tribe-ea-draft’) GROUP BY wp_posts.ID ORDER BY EventStartDate DESC, wp_posts.post_date DESC LIMIT 0, 1 made by require(‘C:\inetpub\wwwroot\EventSales\wp-blog-header.php’), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts
[11-Aug-2018 12:45:04 UTC] WordPress database error Unknown column ‘EventStartDate’ in ‘order clause’ for query SELECT wp_posts.ID FROM wp_posts WHERE 1=1 AND wp_posts.post_type = ‘tribe_events’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘completed’ OR wp_posts.post_status = ‘not-completed’ OR wp_posts.post_status = ‘pending-payment’ OR wp_posts.post_status = ‘refunded’ OR wp_posts.post_status = ‘denied’ OR wp_posts.post_status = ‘tribe-ea-success’ OR wp_posts.post_status = ‘tribe-ea-failed’ OR wp_posts.post_status = ‘tribe-ea-schedule’ OR wp_posts.post_status = ‘tribe-ea-pending’ OR wp_posts.post_status = ‘tribe-ea-draft’) ORDER BY EventStartDate DESC, wp_posts.post_date DESC LIMIT 0, 1 made by require(‘C:\inetpub\wwwroot\EventSales\wp-blog-header.php’), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts
[12-Aug-2018 13:08:18 UTC] PHP Notice: Undefined property: stdClass::$sections in C:\inetpub\wwwroot\EventSales\wp-content\themes\eventica-wp\inc\theme\update.php on line 224
[12-Aug-2018 13:59:23 UTC] WordPress database error Unknown column ‘EventStartDate’ in ‘order clause’ for query SELECT wp_posts.ID FROM wp_posts WHERE 1=1 AND wp_posts.post_type = ‘tribe_events’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘completed’ OR wp_posts.post_status = ‘not-completed’ OR wp_posts.post_status = ‘pending-payment’ OR wp_posts.post_status = ‘refunded’ OR wp_posts.post_status = ‘denied’ OR wp_posts.post_status = ‘tribe-ea-success’ OR wp_posts.post_status = ‘tribe-ea-failed’ OR wp_posts.post_status = ‘tribe-ea-schedule’ OR wp_posts.post_status = ‘tribe-ea-pending’ OR wp_posts.post_status = ‘tribe-ea-draft’) ORDER BY EventStartDate DESC, wp_posts.post_date DESC LIMIT 0, 1 made by require(‘C:\inetpub\wwwroot\EventSales\wp-blog-header.php’), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts
[12-Aug-2018 13:59:24 UTC] WordPress database error Unknown column ‘EventStartDate’ in ‘order clause’ for query SELECT wp_posts.ID FROM wp_posts WHERE 1=1 AND wp_posts.post_type = ‘tribe_events’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘completed’ OR wp_posts.post_status = ‘not-completed’ OR wp_posts.post_status = ‘pending-payment’ OR wp_posts.post_status = ‘refunded’ OR wp_posts.post_status = ‘denied’ OR wp_posts.post_status = ‘tribe-ea-success’ OR wp_posts.post_status = ‘tribe-ea-failed’ OR wp_posts.post_status = ‘tribe-ea-schedule’ OR wp_posts.post_status = ‘tribe-ea-pending’ OR wp_posts.post_status = ‘tribe-ea-draft’) ORDER BY EventStartDate DESC, wp_posts.post_date DESC LIMIT 0, 1 made by require(‘C:\inetpub\wwwroot\EventSales\wp-blog-header.php’), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts
[12-Aug-2018 13:59:25 UTC] WordPress database error Unknown column ‘EventStartDate’ in ‘order clause’ for query SELECT wp_posts.ID FROM wp_posts WHERE 1=1 AND wp_posts.post_type = ‘tribe_events’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘completed’ OR wp_posts.post_status = ‘not-completed’ OR wp_posts.post_status = ‘pending-payment’ OR wp_posts.post_status = ‘refunded’ OR wp_posts.post_status = ‘denied’ OR wp_posts.post_status = ‘tribe-ea-success’ OR wp_posts.post_status = ‘tribe-ea-failed’ OR wp_posts.post_status = ‘tribe-ea-schedule’ OR wp_posts.post_status = ‘tribe-ea-pending’ OR wp_posts.post_status = ‘tribe-ea-draft’) ORDER BY EventStartDate DESC, wp_posts.post_date DESC LIMIT 0, 1 made by require(‘C:\inetpub\wwwroot\EventSales\wp-blog-header.php’), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts
[13-Aug-2018 08:00:02 UTC] WordPress database error Unknown column ‘EventStartDate’ in ‘order clause’ for query SELECT wp_posts.ID FROM wp_posts WHERE 1=1 AND wp_posts.post_type = ‘tribe_events’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘completed’ OR wp_posts.post_status = ‘not-completed’ OR wp_posts.post_status = ‘pending-payment’ OR wp_posts.post_status = ‘refunded’ OR wp_posts.post_status = ‘denied’ OR wp_posts.post_status = ‘tribe-ea-success’ OR wp_posts.post_status = ‘tribe-ea-failed’ OR wp_posts.post_status = ‘tribe-ea-schedule’ OR wp_posts.post_status = ‘tribe-ea-pending’ OR wp_posts.post_status = ‘tribe-ea-draft’) ORDER BY EventStartDate DESC, wp_posts.post_date DESC LIMIT 0, 1 made by require(‘C:\inetpub\wwwroot\EventSales\wp-blog-header.php’), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts

[Victor]

Hi Peter,

Thanks for coming back with those logs.

It seems something may have not been working fine, However, I don’t see any indication from those errors that they are coming from any of our plugins.

It seems there could be a conflict somehow. Were you able to test for conflicts to see if any difference? If not, please follow the steps in the following article and see if the issue still occurs under default conditions > https://theeventscalendar.com/knowledgebase/testing-for-conflicts/

I would suggest you setup a dev/staging site so you can test things out without disrupting the live site.

Please let me know how it goes.

Thanks,
Victor

[mierlp]

I think we found it. The relation with the paying service is not working.

[Victor]

Glad to hear you’ve found the issue. Thanks for following up to let us know about it.

As you marked this Resolved I’ll go ahead and close it. Do feel free to open a new topic if anything comes up and we’ll be happy to help. 🙂

Cheers,
Victor

[Author]

Posts