🇺🇦Ukraine @alex.mazaltov

Looking to the fork implementation for d11 compatibility.

I am wondering if we can generate a patch in an old-school way to test the implementation with alternative commerce Drupal core to make it compatible with d11

It is a very rare issue to happen with Drupal and it happened to me with aws migration process.

Fixing the watchdog table and queue table is not enough cause there may be other tables broken like in my case with the domain module and so on.

I did some research and I came up with a possible solution designed to fix the schema for all tables in the broken database.

Please help me to test his approach.

This approach to fix schema in broken DB using ddev with both databases → .

Here is the overview of the solution described in my gist

SELECT 
    CONCAT(
        'ALTER TABLE `', t.TABLE_NAME, '` ',
        GROUP_CONCAT(
            CASE
                WHEN c.COLUMN_NAME IS NULL THEN CONCAT('ADD COLUMN `', sc.COLUMN_NAME, '` ', sc.COLUMN_TYPE, ' ', 
                    IF(sc.IS_NULLABLE = 'NO', 'NOT NULL', 'NULL'), 
                    IF(sc.COLUMN_DEFAULT IS NOT NULL, CONCAT(' DEFAULT ', IF(sc.COLUMN_DEFAULT = 'CURRENT_TIMESTAMP', sc.COLUMN_DEFAULT, CONCAT('''', sc.COLUMN_DEFAULT, ''''))), ''),
                    IF(sc.EXTRA != '', CONCAT(' ', sc.EXTRA), '')
                )
                WHEN sc.COLUMN_TYPE != c.COLUMN_TYPE OR sc.IS_NULLABLE != c.IS_NULLABLE OR sc.COLUMN_DEFAULT != c.COLUMN_DEFAULT OR sc.EXTRA != c.EXTRA 
                THEN CONCAT('MODIFY COLUMN `', c.COLUMN_NAME, '` ', sc.COLUMN_TYPE, ' ', 
                    IF(sc.IS_NULLABLE = 'NO', 'NOT NULL', 'NULL'), 
                    IF(sc.COLUMN_DEFAULT IS NOT NULL, CONCAT(' DEFAULT ', IF(sc.COLUMN_DEFAULT = 'CURRENT_TIMESTAMP', sc.COLUMN_DEFAULT, CONCAT('''', sc.COLUMN_DEFAULT, ''''))), ''),
                    IF(sc.EXTRA != '', CONCAT(' ', sc.EXTRA), '')
                )
            END
            SEPARATOR ', '
        ),
        ';'
    ) AS alter_statement
FROM 
    information_schema.TABLES t
JOIN 
    information_schema.COLUMNS c ON t.TABLE_NAME = c.TABLE_NAME AND t.TABLE_SCHEMA = c.TABLE_SCHEMA
LEFT JOIN 
    information_schema.COLUMNS sc ON t.TABLE_NAME = sc.TABLE_NAME AND c.COLUMN_NAME = sc.COLUMN_NAME AND sc.TABLE_SCHEMA = 'source_database'
WHERE 
    t.TABLE_SCHEMA = 'target_database'
    AND (sc.COLUMN_TYPE != c.COLUMN_TYPE OR sc.IS_NULLABLE != c.IS_NULLABLE OR sc.COLUMN_DEFAULT != c.COLUMN_DEFAULT OR sc.EXTRA != c.EXTRA)
GROUP BY 
    t.TABLE_NAME
HAVING 
    alter_statement IS NOT NULL;

ddev mysql < schema_export.sql
ddev mysql < alter_statements.sql

I've been exploring the AI Interpolator module for my data-driven websites, particularly for a creation of facebook chatbots.

Could you please have a look Bot builder →

alex.mazaltov → created an issue.

Fixed in: Issue:3312774 →

Proposal is to update composer.json in module to handle the custom dependency from module's json.

Succesfully solved with version of library 3.5.2

      {
          "type": "package",
          "package": {
              "name": "waza-ari/msdropdown",
              "version": "v3.5.2",
              "type": "drupal-library",
              "dist": {
                  "url": "https://github.com/waza-ari/msdropdown/archive/refs/tags/v3.5.2.zip",
                  "type": "zip"
              },
              "source": {
                  "url": "https://github.com/waza-ari/msdropdown",
                  "type": "git",
                  "reference": "v3.5.2"
              },
              "extra": {
                  "installer-name": "ms-dropdown"
              }
          }
      }

And add with composer: composer require waza-ari/msdropdown

I have successfully installed the Marghoob Suleman Dropdownusing composer require and it stored in library folder as ms-Dropdown But module lang_dropdown can't find it.
How i did the composer adjustment:

1. I added external repository to composer.json file
2. And i specified installer name to be renamed after installation
3. Here is the chunk of code

{
          "type": "package",
          "package": {
              "name": "marghoobsuleman/ms-dropdown",
              "version": "v4.0.3",
              "type": "drupal-library",
              "dist": {
                  "url": "https://github.com/marghoobsuleman/ms-Dropdown/archive/refs/tags/v4.0.3.zip",
                  "type": "zip"
              },
              "source": {
                  "url": "https://github.com/marghoobsuleman/ms-Dropdown",
                  "type": "git",
                  "reference": "v4.0.3"
              },
              "extra": {
                  "installer-name": "ms-Dropdown"
              }
          }
      }

Please help with this issue.

Having the same issue
Drupal core: 9.5.9
Domain: 8.x-1.0-beta8