🇵🇱Poland @adpo

Thank you, Divyansh for your support. I have tried several solutions also and I am surprised that it doesn’t work

I agree with @akolahi, in my case asking customers for their mailing address is very misleading during the pickup.

For the quick sulution for exisitng website, can I just run ALTER TABLE menu_tree MODIFY route_param_key VARCHAR(1024);
Do you see any drawbacks in such a solution?

Thank you for the info.

adpo → created an issue.

same here, it happens to guest checkout.

Drupal\Core\Entity\EntityStorageException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '21561e61-86a1-4286-a9d2-04c01e14167a' for key 'profile_field__uuid__value': INSERT INTO "profile" ("revision_id", "type", "uuid", "status", "uid", "is_default", "data", "created", "changed") VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8); Array ( [:db_insert_placeholder_0] => [:db_insert_placeholder_1] => customer [:db_insert_placeholder_2] => 21561e61-86a1-4286-a9d2-04c01e14167a [:db_insert_placeholder_3] => 1 [:db_insert_placeholder_4] => 0 [:db_insert_placeholder_5] => 0 [:db_insert_placeholder_6] => a:0:{} [:db_insert_placeholder_7] => 1727018890 [:db_insert_placeholder_8] => 1727018890 ) in Drupal\Core\Entity\Sql\SqlContentEntityStorage->save() (line 815 of 

adpo → created an issue.

Hello, I am experiencing the same issue as described in #47 (link to views with facets), however, the link is short: "products/school-type/2," while the that path has a long route_param_key:

[:db_update_placeholder_28] => f0=&f1=&f2=&f3=&f4=&f5=&f6=&f7=&f8=&f9=&f10=&f11=&f12=&f13=&f14=&f15=&f16=&f17=&f18=&f19=&f20=&f21=&f22=&f23=&f24=&f25=&f26=&f27=&f28=&f29=&f30=&f31=&f32=&f33=&f34=&f35=&f36=&f37=&f38=&f39=&view_id=product_catalog&display_id=product_catalog&facets_query=school-type/primary-2 [:db_condition_placeholder_0] => 500 ) in Drupal\Core\Menu\MenuTreeStorage->doSave() (line 303 of core/lib/Drupal/Core/Menu/MenuTreeStorage.php)

I have decided to use external link http://mywebsite.com/products/school-type/2 for my internal path to resolve that issue, however, this is not an ideal solution.

problem solved with
https://www.drupal.org/project/commerce/issues/2916252#comment-15332776 🐛 [PP-1] Order's Adjustment can't be normalized and serialized Postponed

Far enough, order load:

[adjustments] => Array
                                (
 [x-default] => Array
  (
  [0] => Array(1)
  )
  )

I believe I'm not making any order adjustments, other than discounts. Maybe there are some other modules that do it, should I do a research for a particular hook?

@jsacksick thank you for your reply , I have already tried PATH https://www.drupal.org/project/commerce/issues/2916252#comment-15287240 🐛 [PP-1] Order's Adjustment can't be normalized and serialized Postponed and https://www.drupal.org/project/commerce/issues/2916252#comment-15332776 🐛 [PP-1] Order's Adjustment can't be normalized and serialized Postponed without any success.

I'm not convinced about any order's adjustment, is there a way to check this out?

Here is the working example output before upgrade to Drupal 10:

{
    "order_id": [
        {
            "value": 55819
        }
    ],
    "uuid": [
        {
            "value": "dad804c6-dbfb-47b9-ae0e-e1815eb8b7b9"
        }
    ],
    "type": [
        {
            "target_id": "default",
            "target_type": "commerce_order_type",
            "target_uuid": "affc6e26-74fc-4f11-b04e-6d7292a55d26"
        }
    ],
    "order_number": [
        {
            "value": "7997"
        }
    ],
    "version": [
        {
            "value": 12
        }
    ],
    "store_id": [
        {
            "target_id": 1,
            "target_type": "commerce_store",
            "target_uuid": "80851e61-b63a-4b32-b673-9aebe7c281a3",
            "url": "/store/1"
        }
    ],
    "uid": [
        {
            "target_id": 30866,
            "target_type": "user",
            "target_uuid": "4ab3bc14-be20-4c42-82ce-75c2e2f838cb",
            "url": "/user/30866"
        }
    ],
    "mail": [
        {
            "value": "test@test.com"
        }
    ],
    "ip_address": [
        {
            "value": "95.45.154.229"
        }
    ],
    "billing_profile": [
        {
            "target_id": 33525,
            "target_revision_id": 33519,
            "target_type": "profile",
            "target_uuid": "4c120c7c-d26b-49c2-9541-f85089cfbf9f",
            "url": "/profile/33525"
        }
    ],
    "order_items": [
        {
            "target_id": 38855,
            "target_type": "commerce_order_item",
            "target_uuid": "375944f4-2adc-4893-b0fe-7efb5ce414f3"
        }
    ],
    "adjustments": [
        {
            "value": {}
        }
    ],
    "total_price": [
        {
            "number": "187.000000",
            "currency_code": "EUR",
            "formatted": "€187.00"
        }
    ],
    "total_paid": [
        {
            "number": "187.000000",
            "currency_code": "EUR",
            "formatted": "€187.00"
        }
    ],
    "balance": [
        {
            "number": "0",
            "currency_code": "EUR",
            "formatted": "€0.00"
        }
    ],
    "state": [
        {
            "value": "processing"
        }
    ],
    "data": [
        {
            "paid_event_dispatched": true
        }
    ],
    "locked": [
        {
            "value": false
        }
    ],
    "created": [
        {
            "value": "2024-01-14T21:23:50+00:00",
            "format": "Y-m-d\\TH:i:sP"
        }
    ],
    "changed": [
        {
            "value": "2024-01-17T11:43:15+00:00",
            "format": "Y-m-d\\TH:i:sP"
        }
    ],
    "placed": [
        {
            "value": "2024-01-17T11:43:05+00:00",
            "format": "Y-m-d\\TH:i:sP"
        }
    ],
    "completed": [],
    "cart": [
        {
            "value": false
        }
    ],
    "checkout_flow": [
        {
            "target_id": "shipping",
            "target_type": "commerce_checkout_flow",
            "target_uuid": "8180c3d9-b151-4bd3-87df-d13fc3433dff"
        }
    ],
    "checkout_step": [
        {
            "value": "complete"
        }
    ],
    "payment_gateway": [
        {
            "target_id": "stripe",
            "target_type": "commerce_payment_gateway",
            "target_uuid": "e118e08c-6d0d-45cc-a103-9ff77d9ddbb8"
        }
    ],
    "payment_method": [
        {
            "target_id": 6459,
            "target_type": "commerce_payment_method",
            "target_uuid": "d8d89d66-fe30-47b0-b614-c07a06cf4e99"
        }
    ],
    "coupons": [],
    "field_order_activation_codes": [
        {
            "value": false
        }
    ],
    "field_order_invoice": [],
    "shipments": [
        {
            "target_id": 8183,
            "target_type": "commerce_shipment",
            "target_uuid": "946d8cca-3aeb-4ca3-9ec2-d4ca05de4765",
            "url": "/admin/commerce/orders/55819/shipments/8183"
        }
    ]
}

adpo → created an issue.

Thank you both for quick response. Can you please also create a patch for: messageWarning: Undefined array key "override" in Drupal\symfony_mailer\Processor\EmailBuilderManager->Drupal\symfony_mailer\Processor\{closure}() (line 215

here:

     $definitions = array_filter($definitions, function ($definition) {
        return !$definition['override'] || $this->overrideManager->isEnabled($definition['id']);
      });

Plaese note that the same warning: Undefined array key "override" in Drupal\symfony_mailer happens on register_no_approval_required

 Undefined array key "override" in Drupal\symfony_mailer\Processor\EmailBuilderManager->buildCache() (line 249 of modules/contrib/symfony_mailer/src/Processor/EmailBuilderManager.php).
Drupal\symfony_mailer\Processor\EmailBuilderManager->buildCache() (Line: 157)
Drupal\symfony_mailer\Processor\EmailBuilderManager->createInstanceFromMessage(Array) (Line: 88)
Drupal\symfony_mailer\MailManagerReplacement->mail('user', 'register_no_approval_required', 'adrian_test2@test.com', 'en', Array, 'info@test.ie') (Line: 1070)
_user_mail_notify('register_no_approval_required', Object) (Line: 116)

adpo → created an issue.

Hi! Thank you so much for mentioning xnttviews—it will certainly help maintain the external entity.

Regarding the initial question, let me try to explain with an example. Each user entity has a school_id field, and in the external database (also connected), there is a column that contains school_id as well as a representative column (rep_name). To filter users by rep_name, I would need to create a third join. However, I assume, as you mentioned, there is no way to use an xnttdb SQL query to add joins.

Thanks for the prompt response and the detailed answer.

adpo → created an issue.

adpo → created an issue.

Also tested #62 but I don't see any permission setting I'm afraid. I have run update.php and cleared the cache.

Is there anything else I need to do?

Hi, I have found an alternative solution:

Simplify Menu | http://Drupal.org

[ https://www.drupal.org/project/simplify_menu] →

adpo → created an issue.

adpo → created an issue.

adpo → created an issue.

adpo → created an issue.

adpo → created an issue.

adpo → created an issue.

Actually it didn’t (old project). I will try again with different approach. Yes, was reffering to exposed filters.

Thank you @mstrelan I was able to determine the route name inside hook_options_list_alter
$current_route_name = \Drupal::service('current_route_match')->getRouteName();

Please close this topic. I had multpile custom EmailBuilder with the same ID.

adpo → created an issue.

PS. I have switched to Drupal Symfony Mailer, what is interesting is that the SMPT transport works for the mandrill but not the API.

adpo → created an issue.

I believe removing the address field like in this patch creates validation issue to continue to review (button is disabled, I need to refresh the page).

Other payment modules have option to disable Collect billing information, which works fine.

I'm wonder if is possible to do implement the same configuration.

No It wasn't unfortunately. I have additionally updated the URL from /contacts_financial to contacts eventually (just in case there is a duplicate URL),and it solved the problem but only for some time... Unfortunate this problem have occurred again for user using Edge. After switching to Firefox, this problem is solved but I'm not sure if this is not a matter of time. I can't say if this is a hosting or drupal issue. Views are quite basic (I have attached some pictures).

Great, that worked. THank you

function module_alter_file_uri(&$uri, $queryParams, &$headers, $scheme) {
  $headers["Content-Disposition"] = 'inline; filename="'.basename($uri).'"';
}

adpo → created an issue.

I have the same problem, where I need to delete configuration from my three custom modules.

I would like to know avoid this situation in future. Why does it happen, how to remove the dependency?

What is the reason for this error?