Sold test ticket not available in OpenTickets reports

  • Resolved schmidtjd

    (@schmidtjd)


    9 years, 1 month ago

    I created a test ticket and purchased one through the event page. The product purchase could be found in WooCommerce reports (sales by product). However, upon scan, the ticket could not be found and was not available in OpenTickets reports (Attendees). Please advise.

    —

    ==Environment==
    – Home URL: https://www.thewelldesmoines.com
    – Site URL: https://www.thewelldesmoines.com
    – WC Version: 2.5.0
    – WP Version: 4.4.2
    – WP Multisite Enabled: No
    – Wev Server Info: Apache ++ HTTP/1.1
    – PHP Version: 5.4.43
    – MySQL Version: 5.5.42
    – WP Acitve Plugins: 9
    – WP Memory Limit: You have more than the required minimum memory of 64MB. Your current total is 256M.
    – WP Debug Mode: No
    – WP Language: en_US
    – WP Max Upload Size: No
    – WP Max Post Size: 50M
    – PHP Max Execution Time: 30
    – PHP Max Input Vars: 1000
    – WP Uploads Writable: Uploads directory IS writable (/home2/thewely7/public_html/wp-content/uploads)
    – Default Timezone: UTC

    ==Software==
    Active Plugins:
    – [ON]: Akismet by Automattic,
    – [ON]: Custom Login Page Customizer by Hardeep Asrani,
    – [ON]: Easy Forms for MailChimp by YIKES by YIKES,
    – [ON]: Jetpack by WordPress.com by Automattic,
    – MailChimp Forms by MailMunch by MailMunch,
    – MailChimp Forms by MailMunch by Mike Hansen,
    – [ON]: OpenTickets Community Edition by Quadshot Software LLC,
    – [ON]: Pirate Forms – Contact form and SMTP Plugin by Themeisle,
    – [ON]: Shortcode Widget by Gagan Deep Singh,
    – [ON]: WooCommerce by WooThemes,
    – [ON]: Yoast SEO by Team Yoast
    Acitve Theme: Zerif Lite by ThemeIsle

    ==Data==
    – Event Areas: “Grand Ballroom (Test)” [#129] (publish), “Grand Ballroom” [#68] (publish)
    – Ticket Products: #129 “Registration (Test)” (0.01) [1 EA], #68 “Registration” (60) [1 EA]UTC

    https://www.ads-software.com/plugins/opentickets-community-edition/

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author loushou

    (@loushou)

    Hey @schmidtjd,

    This does sound like a strange issue. There was a similar issue a couple minor versions ago, which a patch was made for recently. First, can you make sure you at the latest version of OTCE (though I am sure you are already). After that try to scan the ticket again.

    If it fails again, then this could be a different issue than before. Try going to OpenTickets -> System Status -> Tools, and click the button that says ‘Resynce order items to ticket table’ (the first button). This will take a moment to run. After it is done, try doing the scan/report again.

    If that does not work, we will probably need to step this up to the next level. We will cross that bridge when we come to it.

    Let me know if either suggestion solves the problem,
    Loushou

    Thread Starter schmidtjd

    (@schmidtjd)

    loushou:

    1. We are running OTCE 2.1.1.
    2. Smartphone re-scan of ticket produced the following message, “Check-In FAILED! We could not find those reservations. Could not check them in.”
    3. Ran resync as suggested. Received the following:

      select id from wp_tvqe_posts where post_type = ‘shop_order’ and post_status in (“wc-completed”,”wc-on-hold”,”wc-processing”) limit 500 offset 0
      ORDER IDS:
      144
      ———–
      ORDER_ITEM_IDS:
      1
      ———–
      select count(order_id) from wp_tvqe_qsot_event_zone_to_order test where 1=1 and event_id = ‘135’ and ticket_type_id = ‘129’ and quantity = ‘1’ and order_id = ‘144’
      does not exist
      **RESULT: created

      Smartphone re-scan of ticket produced the following message, “Check-In SUCCESSFUL.”
      Ticket was logged to Attendees report.

    Thanks very much!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Sold test ticket not available in OpenTickets reports’ is closed to new replies.