verbb / events Goto Github PK

Description

Line 52 of TicketController has the Events::$plugin->getPurchasedTickets()->checkInPurchasedTicket($purchasedTicket); call commented out so the function returns a success message but checkin is not recorded.

Steps to reproduce

1. Post to events/ticket/checkin with a PurchasedTicket sku.
2. Inspect the events_puchasedTickets table to verify that checkedIn is null and checkedInDate is null

Additional info

• Plugin version: 1.1.6
• Craft version: 3.3.11

I'm using Events for conferences and sessions (as separate event types). I'd love to be able to do two-way linking between conferences and sessions, instead of having to set the relationship from both entries.

For other element types, I use the Many to Many plugin (where I've requested Events support). Not sure if there's something you could do on your end though!

Description

I would like to report the following issue with Events (https://plugins.craftcms.com/events).

Good afternoon,

I am writing to report a crash with this plugin. I was following our normal development process, in which I create a development branch, do my development, and then merge with a local, up-to-date master branch. When I went to merge into my master branch, I ran the following commands:

./craft migrate/all 
./craft project-config/sync

upon syncing the project config, I received the following error:

Applying changes from project.yaml ... error: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'event' for key 'tb_events_eventtypes_handle_unq_idx'
The SQL being executed was: INSERT INTO `tb_events_eventtypes` (`uid`, `name`, `handle`, `hasTitleField`, `titleLabel`, `titleFormat`, `hasTickets`, `icsTimezone`, `icsDescriptionFieldHandle`, `icsLocationFieldHandle`, `fieldLayoutId`, `dateCreated`, `dateUpdated`) VALUES ('e138e5af-ad5e-42a7-bab0-285bed545b39', 'Event', 'event', 1, 'Title', '', 1, '', '', '', 75, '2020-05-06 16:56:09', '2020-05-06 16:56:09')

I made sure before running the commands that the database did not have that entry, let alone even the table. It seems like it is trying to add it twice.

Steps to reproduce

1. Created new branch for development on multi-lanuage site.
2. Merged code to master
3. From directory root ran

./craft migrate/all 
./craft project-config/sync

Additional info

• Plugin version: 1.4.7
• Craft version: 3.4.16

Just a heads up. Looks like Events for Craft 3 is throwing the following deprecation warning.

Message:
craft.commerce.primaryPaymentCurrency has been deprecated. Use craft.commerce.paymentCurrencies.primaryPaymentCurrency instead

Origin:
/Users/jacobgraf/Sites/getconnected/vendor/verbb/events/src/templates/_includes/ticket-row.html:46

This might be a feature request, but is there any way currently to relate an entry to an event? We have a news/press release section on a website that can often relate to an event in our event directory. Right now we're using Solspace Calendar to hold our events and they have a field type where we can relate a Solspace Calendar Event to an entry.

Description

With the purchased tickets now stored as elements, it be incredible to be able to edit the custom fields mapped to them.

In our case, a person can purchase multiple tickets on behalf of others. We save the attendee info in the Order options. We are planning on adding our own db table to then store the attendee info outside of orders for easy querying. Even better would be able to add that attendee info to custom fields on a purchased ticket.

Unable to install the plugin.

In control panel, clicking install shows the flash message "Unable to install plugin".

The database tables are created but the following SQL error is shown in the logs

Exception: SQLSTATE[HY000]: General error: 1215 Cannot add foreign key constraint

The SQL that fails is:

ALTER TABLE events_purchasedticketsADD CONSTRAINTevents_purchasedtickets_lineItemId_fk FOREIGN KEY (lineItemId) REFERENCES commerce_lineitems (id) ON DELETE SET NULL

There is also an error

Tried to roll back a savepoint, but it does not exist: SQLSTATE[42000]: Syntax error or access violation: 1305 SAVEPOINT LEVEL1 does not exist
The SQL being executed was: ROLLBACK TO SAVEPOINT LEVEL1

• Plugin version: 1.1.6
• Craft version: 3.3.7

I'm using the Field Labels plugin (similar to Relabel) to override the label and instructions of some fields in my event types.

Everything looks fine while editing, but after I save the event type, the changes get wiped and I'm back to my original field labels and instructions.

Setup:

• Craft Pro 3.1.26
• PostgreSQL 10.7
• Events 1.0.2.1
• Field labels 1.1.0

Hi, great plugin so far. Not sure if this is intentional or not but I noticed when I checked-in tickets it didn't actually update the DB. Found this commented out line which was the culprit.

I've just installed the trial and I can't seem to save any events with tickets added. They save fine without.

yii\base\InvalidConfigException: Ticket is missing its ticket type ID in /Users/Name/Sites/site/craft/vendor/verbb/events/src/elements/Ticket.php:268
Stack trace:
#0 /Users/Name/Sites/site/craft/vendor/verbb/events/src/elements/Ticket.php(172): verbb\events\elements\Ticket->getType()
#1 /Users/Name/Sites/site/craft/vendor/yiisoft/yii2/base/BaseObject.php(109): verbb\events\elements\Ticket->init()
#2 /Users/Name/Sites/site/craft/vendor/verbb/events/src/helpers/EventHelper.php(28): yii\base\BaseObject->__construct()
#3 /Users/Name/Sites/site/craft/vendor/verbb/events/src/elements/Event.php(385): verbb\events\helpers\EventHelper::populateEventTicketModel(Object(verbb\events\elements\Event), Array, 'new1')
#4 /Users/Name/Sites/site/craft/vendor/verbb/events/src/helpers/EventHelper.php(104): verbb\events\elements\Event->setTickets(Array)
#5 /Users/Name/Sites/site/craft/vendor/verbb/events/src/controllers/EventsController.php(161): verbb\events\helpers\EventHelper::populateEventFromPost()
#6 [internal function]: verbb\events\controllers\EventsController->actionSave()
#7 /Users/Name/Sites/site/craft/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array(Array, Array)
#8 /Users/Name/Sites/site/craft/vendor/yiisoft/yii2/base/Controller.php(157): yii\base\InlineAction->runWithParams(Array)
#9 /Users/Name/Sites/site/craft/vendor/craftcms/cms/src/web/Controller.php(109): yii\base\Controller->runAction('save', Array)
#10 /Users/Name/Sites/site/craft/vendor/yiisoft/yii2/base/Module.php(528): craft\web\Controller->runAction('save', Array)
#11 /Users/Name/Sites/site/craft/vendor/craftcms/cms/src/web/Application.php(297): yii\base\Module->runAction('events/events/s...', Array)
#12 /Users/Name/Sites/site/craft/vendor/craftcms/cms/src/web/Application.php(565): craft\web\Application->runAction('events/events/s...', Array)
#13 /Users/Name/Sites/site/craft/vendor/craftcms/cms/src/web/Application.php(281): craft\web\Application->_processActionRequest(Object(craft\web\Request))
#14 /Users/Name/Sites/site/craft/vendor/yiisoft/yii2/base/Application.php(386): craft\web\Application->handleRequest(Object(craft\web\Request))
#15 /Users/Name/Sites/site/craft/web/index.php(21): yii\base\Application->run()
#16 {main}

Hi Josh,

The 1.4 version is updated to work with craft 3.4 and commerce 3.
My query is... is commerce 3 a requirement? - i've tested locally running it with commerce 2 and it seems to work fine. I was just wondering if there was something that made it commerce 3 only or would it be possible to set the requirement back to commerce 2?

Cheers

Description

Server Error when trying to access Events > Purchased Tickets

When looking at web.log, I see this error...

2020-02-01 13:03:37 [-][1][-][error][RuntimeException] TypeError: Argument 1 passed to verbb\events\services\Events::getEventById() must be of the type int, null given, called in /home/forge/mysite.com/vendor/verbb/events/src/elements/PurchasedTicket.php on line 215 and defined in /home/forge/mysite.com/vendor/verbb/events/src/services/Events.php:20

Additional info

• Plugin version: 1.3.1
• Craft version: Pro 3.4.2
• Commerce version: Lite 3.0.5

Only on my staging site (Fortrabbit + Forge), not my local site (valet). events.js also shows up twice in Network on the staging site, with the same URL. If I try to open it in a new tab, it says fopen(/home/forge/dev.facadetectonics.org/web/cpresources/2d10db37/js/events.js): failed to open stream: No such file or directory

I have setup event ticket check In form on my site as describe in plugin doc.
1. Everything working good. But I want to show error and success message on my site with my
extended layout.
Like I want to show success and error message above my form.

2. Second thing is when entered wrong SKU then php error occurs instead of show "You have 
      entered wrong sku."

For what can we do for this requirement? Please give me suggestion.

Description

When editing many events and tickets quickly, the first gear icon click on a ticket shifts the tickets pane slightly so opening all of the tickets quickly leads to accidentally deleting some without checking if deleting was intended, resulting in having to reload the screen to get the ticket back.

Steps to reproduce

1. Create/edit event and go to tickets pane.
2. When clicking gear icons quickly on tickets to open them all up, tickets pane shifts slightly and clicking next icon usually results in clicking delete button.

Additional info

• Plugin version: 1.1.1
• Craft version: Solo 3.2.7

Description

Custom Ticket Fields are not editable until the event has been saved with the ticket on it. However, a required field needs a value in order to save, hence a required field prevents tickets being added to events.

Steps to reproduce

1. Create Ticket Type with custom field set to required
2. Create Event and add ticket of newly created type
3. Click Save

Additional info

• Plugin version:1.1.3
• Craft version:3.2.7

Description

I'm programatically creating Events (and setting tickets). It fails trying to save the element, which I narrowed down to the ticket failing validation, with the error "Ticket type must be set.".

However, the ticket type id was set, and the error message in the Event ticket validation doesn't report the actual validation issue (which in my case was a duplicate SKU) -

Additional info

• Plugin version: 1.4.2
• Craft version: 3.4.9

Description

A general question, as I am researching options for a website I am building for a tuition company.
Events looks like a good fit, as they offer one-off courses and mock-exams they want to make purchasable online.
However, I suspect they would only need the lite commerce package.
So does events work with both?

Description

Just updated to 1.4.10 to get the multi-site patch, thanks for releasing. I think there is still an issue though.

I have three sites on my craft install: English, Spanish and Korean. When I go to make an event, I enter the English translation into the English page and save. It then is visible on all three sites. Now, if I head to the Korean page and enter my other translation and save, I lost the Korean translation and it is replaced with the English translation, and on the English page I have the Korean translation. I can then overwrite the english translation to its desired text, but I still do not have the korean translation on the korean site.

Steps to reproduce

1. Create a craft install with three sites.
2. Create an event with a text field that is translatable per site.
3. Enter text for site 1 and save, then change sites, enter text for site 2 (or 3) and save.
4. Look at the 2nd (or 3rd) site that you just updated. Notice it is different than what was just entered.
5. Also note the difference on the first site.

Additional info

• Plugin version: 1.4.10
• Craft version: 3.4.16

Thank you!

Description

When running update via composer from v1.1.7.1 to v1.2.1, I'm getting this error about failing to backup the db even though I chose to skip the db backup.

error: The command "'/Users/stephencallender/Projects/_sites/local-fti/craft' 'migrate/all' '--no-content'" failed.

Exit Code: 1(General error)

Working directory: /Users/stephencallender/Projects/_sites/local-fti

Output:
================
Yii Migration Tool (based on Yii v2.0.30)

Error Output:
================
Error backing up the database: The shell command "PGPASSWORD="" pg_dump --dbname=local_fti --host=localhost --port=5432 --username=stephencallender --if-exists --clean --no-owner --no-privileges --no-acl --file="/Users/stephencallender/Projects/_sites/local-fti/storage/backups/facade-tectonics-institute_200130_163107_ad6qvwugyo_v3.3.18.2.sql" --schema=public --exclude-table-data 'public.assetindexdata' --exclude-table-data 'public.assettransformindex' --exclude-table-data 'public.sessions' --exclude-table-data 'public.templatecaches' --exclude-table-data 'public.templatecachequeries' --exclude-table-data 'public.templatecacheelements' --exclude-table-data 'public.cache' --exclude-table-data 'public.templatecachecriteria'" failed with exit code 127: sh: pg_dump: command not found

Additional info

• Plugin version: 1.1.7.1
• Craft version: 3.3.18.2

I'd love to use this to completely replace Solspace Calendar, instead of using both. However, we'll definitely have events where we don't have tickets or don't know ticket details (for example, a calendar of industry events). It would be cool to have the option on an event type or individual event basis to not include tickets.

I'm pretty sure this and #8 are the main features Events is lacking compared to Calendar, at least where we're concerned.

What's the likelihood you'd be able to incorporate this in the next month or so? Trying to figure out whether we have to continue using both plugins or we can drop Calendar.

Description

TicketTypesController requires the events-manageTicketTypes permission, but this permission is not registered by the plugin. Non-admins trying to add or edit ticket types get a 403 forbidden response.

https://github.com/verbb/events/blob/craft-3/src/controllers/TicketTypesController.php#L22
https://github.com/verbb/events/blob/craft-3/src/Events.php#L195

Steps to reproduce

1. Log in as any non-admin user with all available Events plugin permissions granted.
2. Try to add or edit a ticket type.

Additional info

• Plugin version: 1.1.6
• Craft version: 3.2.10

I've installed Events with composer. It appears on my plugins page in the control panel, but when I click on "install" there, I get a red bar on top of the screen saying "Couldn’t install plugin."

PHP version 7.2.10
Craft CMS 3.1.23
Craft Commerce 2.1.3.1
Events 1.0.0

The Solspace Calendar plugin allows calendars (event types) to be shared/subscribed with ICS. That would be pretty rad to have here. Is that on the roadmap? 😄

What's the timeline for supporting Commerce 3? What compatibility issues do you anticipate?

A few queries I wish existed:

• craft.events.purchasedTickets({ purchasedBy: cart.customer })
  All PurchasedTickets customer has bought
• craft.events.tickets({ purchasedBy: cart.customer })
  All Tickets customer has purchased
• craft.events.events({ purchasedBy: cart.customer })
  All Events customer has booked a ticket from
• craft.events.hasTicket(order)
  Similar to .isTicket but can be run against orders. May be nice to integrate to craft.orders({ hasTicket.. }) if possible

If you be really nice that if you are currently logged into the cp (or are a user that has cp access) and you scan a ticket QRcode, that the page redirect actually takes you to the purchased tickets index page for that event in the cp.

if not logged into the cp (or have access) then do the current functionality.

Not sure if this is a technical limitation, but we use Order Status' to send emails, etc related to our events. I love the new "Purchased Tickets" view, but would love to be able to select all (per event) and bulk change the Commerce Order status for those orders.

Also, I'd love to be able to filter by event status (enabled, disabled, expired, etc).

Thanks for listening!

Description

I had a component on my site that displayed past events using the below code:

{% set pastEvents = craft.events.events()
.startDate("< #{start}")
.all() %}
{% for pastEvent in pastEvents %}
{{ pastEvent.title }}
{% endfor %}

This was working fine, however it has now stopped working. I've only noticed today, but wonder if it was a result of the plugin updates on 8th and 9th Aug.

Can anyone else get this query to output past events?

Additional info

• Plugin version: 1.1.5
• Craft version: Craft Pro 3.2.9

Description

I have integrated the plugin, create a number of events of different types, however when querying them I'm getting an empty array.

Steps to reproduce

1. Created a number of events, say 20.
2. Queried using the following expression: {% set events = craft.events.events().all() %}
3. The result I get from {{ dump(events) }} is an empty array. Am I missing something?

Additional info

• Plugin version: 1.3.0
• Craft version: 3.4.0.2

Can we have the ability to manually checkin a ticket via the CP? - so we don't need to go to the checkin url.

Doing it via the purchased ticket detail page and via the listing view (so multiple tickets can be checked in) would be great.

Also, can we have the ability to undo a checkin?

Tried to update to 1.1.4 and get the following error. Tried a manual composer update from the command line and get the same result.

Error: Unknown downloader type: . Available types: git, svn, fossil, hg, perforce, zip, rar, tar, gzip, xz, phar, file, path.

Composer output: Package "craftcms/vue-asset" listed for update is not installed. Ignoring.
Loading composer repositories with package information
Updating dependencies
Package operations: 0 installs, 1 update, 0 removals

Saw this when installing:
Package endroid/qrcode is abandoned, you should avoid using it. Use endroid/qr-code instead.

It looks like Packagist, and in turn the Craft Plugin Store, are now properly refreshing to 1.1.1. Can you fix this so we can pull down 1.1.2? Thanks!

Description

Ticket Purchasables are marked as having free shipping as well as non-shippable:

See code here:
https://github.com/verbb/events/blob/craft-3/src/elements/Ticket.php#L617-L630

This means that shipping cost rules can not be applied to them, even though there is support for shipping categories for ticket types. You may want to document that shipping costs can not be added to tickets.

Can we have the feature to be able to assign a "seat" quantity to a ticket type please?

This would allow the ability to have family or group tickets that would count against the total capacity.

eg: total capacity is 100, a single family ticket (4 persons) is purchased and the total capacity left if now 96, even though 1 ticket have been bought.

Description

As you can set a Title Format like {fieldHandleA} - {fieldHandleB} on entry types, please allow a similar function for Ticket Types.

Use Case

Say we set up a generic ticket type which allows for a name to be given to it, along with other config settings on how to render it. This can be used to show in the front end reasonably well, but it would be nice, for things such as the default craft commerce checkout to be able to configure what name it will show per ticket (not per ticket type)

Description

I have an "Administrators" user group. I would like them to be able to manage tickets for an event but not create new event types. The preference for the group are.

Manage event types - unchecked
Manage Events - checked
Manage my event - checked
Manage ticket types - unchecked

Steps to reproduce

1. Log in as user in Administrators group.
2. Go to Events
3. Event Types is visible in the sidebar
4. "New event" type button is visible
5. Clicking "New event type" button gets HTTP403 forbidden

The Event types option should not be available in the sidebar menu.

Additional info

• Plugin version: 1.17.1
• Craft version: 3.3.18.2

Description

Im using this method in a Sprout Reports report that is twig template based. I recently ran Craft updates + plugin updates which included

Craft 3.1.31 > 3.3.3
Commerce 2.1.7 > 2.1.13
Events 1.1.1 > 1.1.6
Sprout Reports did not have an update

The report was working fine before this update. Since the update, this code:

{% set items = '' %}
	{% for item in order.lineItems %}
		{% if item and craft.events.isTicket(item) %}
			{% set ticket = item.purchasable %}
			{% set event = ticket.event %}
			{% set items = items~item.qty~' - '~event.title~' - '~ticket.name~lb %}
		{% else %}
			{% set purchasable = item.purchasable %}
			{% set product = purchasable.product %}
			{% set items = items~item.qty~' - '~product.title~lb %}
		{% endif %}
	{% endfor %}

generates this error:

yii\base\ErrorException: get_class() expects parameter 1 to be object, null given in /Users/Chad/Sites/stemple-creek/vendor/verbb/events/src/variables/EventsVariable.php:94
Stack trace:
#0 /Users/Chad/Sites/stemple-creek/vendor/verbb/events/src/variables/EventsVariable.php(94): ::get_class()
#1 /Users/Chad/Sites/stemple-creek/vendor/twig/twig/src/Extension/CoreExtension.php(1485): verbb\events\variables\EventsVariable->isTicket()
#2 /Users/Chad/Sites/stemple-creek/vendor/craftcms/cms/src/helpers/Template.php(105): ::twig_get_attribute()
#3 /Users/Chad/Sites/stemple-creek/storage/runtime/compiled_templates/88/88ab57a3732fdfcaa9d4132b0a9b637293e94bb007972294b7a8d9774f3df5f3.php(121): craft\helpers\Template::attribute()
#4 /Users/Chad/Sites/stemple-creek/vendor/twig/twig/src/Template.php(407): __TwigTemplate_feebf5c4c6a9c5e0670697c60092e9e64ecc6e0aa837e63f7fa867e93f8131de->doDisplay()
#5 /Users/Chad/Sites/stemple-creek/vendor/twig/twig/src/Template.php(380): __TwigTemplate_feebf5c4c6a9c5e0670697c60092e9e64ecc6e0aa837e63f7fa867e93f8131de->displayWithErrorHandling()
#6 /Users/Chad/Sites/stemple-creek/vendor/twig/twig/src/Template.php(392): __TwigTemplate_feebf5c4c6a9c5e0670697c60092e9e64ecc6e0aa837e63f7fa867e93f8131de->display()
#7 /Users/Chad/Sites/stemple-creek/vendor/twig/twig/src/TemplateWrapper.php(45): __TwigTemplate_feebf5c4c6a9c5e0670697c60092e9e64ecc6e0aa837e63f7fa867e93f8131de->render()
#8 /Users/Chad/Sites/stemple-creek/vendor/twig/twig/src/Environment.php(318): Twig\TemplateWrapper->render()
#9 /Users/Chad/Sites/stemple-creek/vendor/craftcms/cms/src/web/View.php(344): craft\web\twig\Environment->render()
#10 /Users/Chad/Sites/stemple-creek/vendor/barrelstrength/sprout-reports/src/datasources/CustomTwigTemplate.php(205): craft\web\View->renderTemplate()
#11 /Users/Chad/Sites/stemple-creek/vendor/barrelstrength/sprout-reports/src/datasources/CustomTwigTemplate.php(52): barrelstrength\sproutreports\datasources\CustomTwigTemplate->processFrontEndResultsTemplate()
#12 /Users/Chad/Sites/stemple-creek/vendor/barrelstrength/sprout-base-reports/src/controllers/ReportsController.php(138): barrelstrength\sproutreports\datasources\CustomTwigTemplate->getDefaultLabels()
#13 /Users/Chad/Sites/stemple-creek/vendor/yiisoft/yii2/base/InlineAction.php(57): barrelstrength\sproutbasereports\controllers\ReportsController->actionResultsIndexTemplate()
#14 /Users/Chad/Sites/stemple-creek/vendor/yiisoft/yii2/base/InlineAction.php(57): ::call_user_func_array:{/Users/Chad/Sites/stemple-creek/vendor/yiisoft/yii2/base/InlineAction.php:57}()
#15 /Users/Chad/Sites/stemple-creek/vendor/yiisoft/yii2/base/Controller.php(157): yii\base\InlineAction->runWithParams()
#16 /Users/Chad/Sites/stemple-creek/vendor/craftcms/cms/src/web/Controller.php(187): barrelstrength\sproutbasereports\controllers\ReportsController->runAction()
#17 /Users/Chad/Sites/stemple-creek/vendor/yiisoft/yii2/base/Module.php(528): barrelstrength\sproutbasereports\controllers\ReportsController->runAction()
#18 /Users/Chad/Sites/stemple-creek/vendor/craftcms/cms/src/web/Application.php(299): craft\web\Application->runAction()
#19 /Users/Chad/Sites/stemple-creek/vendor/yiisoft/yii2/web/Application.php(103): craft\web\Application->runAction()
#20 /Users/Chad/Sites/stemple-creek/vendor/craftcms/cms/src/web/Application.php(284): craft\web\Application->handleRequest()
#21 /Users/Chad/Sites/stemple-creek/vendor/yiisoft/yii2/base/Application.php(386): craft\web\Application->handleRequest()
#22 /Users/Chad/Sites/stemple-creek/public_html/index.php(21): craft\web\Application->run()
#23 {main}

https://d.pr/i/RwpeJD

So, the report won't work at this time.

Description

I'm importing events from Solspace Calendar, which never had any ticketing options before. The error I'm getting is as follows:

Argument 1 passed to verbb\events\services\Tickets::getAllTicketsByEventId() must be of the type integer, string given, called in /storage/av04383/www/stage_html/vendor/verbb/events/src/elements/Event.php on line 370 - Tickets.php: 26

Steps to reproduce

1. Export Solspace Calendar Events using the Craft built-in element exporter on the Events index page.
2. Map the fields, leaving the ticketing fields with just their defaults, and run the import.

Additional info

• Plugin version: 1.4.7
• Craft version: 3.4.13

Description

I can create events and purchase tickets using the default templates from the craft commerce 3 alpha templates folder and the Events plugin suggested templates. However, if I save supertable data in an event, then adding a ticket for that event to my cart causes an infinite loop and a 504 gateway time-out error.

Here's an example of the code that's repeated over and over in 5 web.log files after I do this (my supertable field is called "continuingEducation":

2019-08-09 08:02:43 [-][1][la82j0df3dc7limrn3uuo4orir][profile begin][yii\db\Command::query] SELECT "elements"."id", "elements"."fieldLayoutId", "elements"."uid", "elements"."enabled", "elements"."archived", "elements"."dateCreated", "elements"."dateUpdated", "elements_sites"."slug", "elements_sites"."siteId", "elements_sites"."uri", "elements_sites"."enabled" AS "enabledForSite", "supertableblocks"."fieldId", "supertableblocks"."ownerId", "supertableblocks"."typeId", "supertableblocks"."sortOrder", "content"."id" AS "contentId", "content"."field_headline", "content"."field_details"
FROM (SELECT "elements"."id" AS "elementsId", "elements_sites"."id" AS "elementsSitesId", "content"."id" AS "contentId"
FROM "elements" "elements"
INNER JOIN "supertableblocks" "supertableblocks" ON "supertableblocks"."id" = "elements"."id"
INNER JOIN "elements_sites" "elements_sites" ON "elements_sites"."elementId" = "elements"."id"
INNER JOIN "stc_continuingeducation" "content" ON ("content"."elementId" = "elements"."id") AND ("content"."siteId" = "elements_sites"."siteId")
WHERE ("supertableblocks"."fieldId"=158) AND ("supertableblocks"."ownerId"=835) AND ("elements_sites"."siteId"=1) AND ("elements"."archived"=FALSE) AND ("elements"."enabled"=TRUE) AND ("elements"."dateDeleted" IS NULL) AND ("elements_sites"."enabled"=TRUE) AND ("elements"."draftId" IS NULL) AND ("elements"."revisionId" IS NULL)
ORDER BY "supertableblocks"."sortOrder"
LIMIT 1) "subquery"
INNER JOIN "supertableblocks" "supertableblocks" ON "supertableblocks"."id" = "subquery"."elementsId"
INNER JOIN "elements" "elements" ON "elements"."id" = "subquery"."elementsId"
INNER JOIN "elements_sites" "elements_sites" ON "elements_sites"."id" = "subquery"."elementsSitesId"
INNER JOIN "stc_continuingeducation" "content" ON "content"."id" = "subquery"."contentId"
ORDER BY "supertableblocks"."sortOrder"

I've tested a few times and can reliable reproduce the issue with different supertable fields. All other fields seem to work fine.

Steps to reproduce

1. Create an event type with date in the future and tickets enabled.
2. Add a supertable field to the event type.
3. Add data to the supertable field and save.
4. Using the default templates provided in commerce 3 alpha and the events plugin documentation, click "add to cart" on front end for the event.

Additional info

• Craft version: Craft Pro 3.2.9
• DB version: PostgreSQL 10.9
• Commerce version: 3.0.0-alpha.1
• Events version: 1.1.5
• SuperTable version: 2.2.1

I've got the total capacity set but not the quantity on the ticket, and when i try to add to my basket I get the "You reached the maximum ticket quantity for the event" message.

The same happens if no total capacity and no ticket capacity is set. It only works if a ticket capacity is set.

Any chance of adding yet even more complexity to events and adding support for recurring events?

Description

Admin panel edit event pages break when an associated ticket type is deleting before removing it from the event.

Steps to reproduce

1. Create event and ticket types.
2. Assign ticket to event.
3. Delete ticket type and try to edit event again.

Returns error:
Invalid Configuration – yii\base\InvalidConfigException
Invalid ticket type ID: 2976

Additional info

• Plugin version: 1.1.1
• Craft version: Solo 3.2.2

My client has set up an event with the total capacity set to 64. The event has then sold 44 tickets. They have then reduced the total capacity to 16. At this point, if a user attempts to add a ticket to their basket, it results in a 500 error.

I understand that this is due to the plugin having sold more historical tickets than it's new total capacity, which contradict its logic and results in an error. This is definitely a user error on the part of my client and I have told them not to reduce the total capacity after the initial setup of the event.

As a way to prevent this from happening again in the future, I was hoping that an error can be added in the event CP to prevent the content editor from reducing the total capacity below the number of tickets that have been sold at that time.

Would be really nice to be able to import Events using FeedMe - currently Events aren't available as an Element Type that FeedMe works with.

Is that on the cards and if so, could it be added tomorrow? ;-)

Description

We're setting up conferences that have many sessions. One conference can have many sessions, and each session belongs to exactly one conference. Sessions and conferences are separate event types.

I was originally trying to link sessions and conferences with reciprocal fields, which is why I posted #13.

However, a parent-child relationship would also work and might be easier! Would it be feasible to allow nesting of events, even across event types, like you would for a structure that has different entry types? Are there negative consequences I'm not seeing?