[mierlp]

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

[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

[mierlp]

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

Can you please help me or give another tip?

Thanx.

[mierlp]

Juan,

We now what QR codes are…

But when we sell a ticket, the code in the QR is the URL of the site and the code of the event.

But i want that the QR is the ticket number, and not an URL with simple crackable code

See attachment..

[mierlp]

We are in the Netherlands, and i want all the festials and the music venues in our database from:
the Netherlands
Belgium
Germany
France
England
Sweden
Norway
Denmark

[mierlp]

Hi Address,

I’m back…but i think we have to give it up..with a SQL statement and not knowing
the relation between different tables it’s not to do.

I would like to use a tool like Navicat to create a query for the data
to retrieve all database. Only I do not see the connection between the tables.

When I create an event and I search for the event name, this occurs in 2 tables:
– wp_options
– wp_post * (here is the correct ID I think, eg 2167?)

When I search on this ID (2167), I find it in the tables:
– wp_options
– wp_postmeta *
– wp_post
– wp_term_relationships

When I filter in wp_postmeta on the post_id (2167) I get data
about the event and fields like:
– _EventVenueID?
– _EventOrganizerID?

I miss the connection and where to start in which order to retrieve the correct data
for a closed event.

I don’t see relationship on field level between :
Event -> Tickets -> Orders / Customer / TicketNumbers (_tribe_wooticket_security_code?)

• How do you export the CSV from the plugin?
• Is this based on JSON or something else … because in some
  there is all info in one line like first+lastname, address, zip, city

Regards Peter

[mierlp]

Hi

Oke thanks…i will try to use a query builder to retrieve some data
and see where data is stored.

Regars Peter

[mierlp]

Hi Andras,

Thanks for the respons. A scanning app would be great if you can sell it
together with the theme. This prototype i showed is also working but the
only thing we needs is the data.

Which tooling do you use to retrieve the data from the memo fields ?
Can i use an query builder because i don’t recognize the syntax how
data is stored. Maybe because we developed desktop/web applications
where data is stored in records/fields

Regards Peter

[mierlp]

Hi Andras,

Thanks for the reply. Attachted 2 screenshots from the the app.
Green when valid and red when not valid or already scanned.

What we need is the following information :
– Event Name
– Event Number
– Event Date
– Event Time
– TicketNumber
– LastName
– FirstName
– MiddleName
– Order Date
– Order Time
– Order status or Payment status

Each order/payed ticket will be a record in the table

Would be great if you can help us out.

Greetz Peter

• This reply was modified 6 years, 2 months ago by mierlp.

[Author]

Posts