ntimyeboah/laravel-database-trigger incompatible

I have tried it but get the same error as before :/

@marco_1992 you are clearly doing something wrong here, I just tried that now and everything was installed perfectly.

Can you try doing that on a fresh Laravel install?

I have tried it on a fresh Laravel install, but i get the same error. Does it matter at which position your code is added in the composer.json file?

Or do you add additional code in the file?

Here is my file:

{
    "name": "laravel/laravel",
    "type": "project",
    "description": "The Laravel Framework.",
    "keywords": ["framework", "laravel"],
    "license": "MIT",
  "repositories": [
        {
            "type": "vcs",
            "url": "https://github.com/DariusIII/laravel-database-trigger"
        }
    ],
    "require": {
        "php": "^7.3|^8.0",
        "fideloper/proxy": "^4.4",
        "fruitcake/laravel-cors": "^2.0",
        "guzzlehttp/guzzle": "^7.0.1",
        "laravel/framework": "^8.12",
        "laravel/tinker": "^2.5"
    },
    "require-dev": {
        "facade/ignition": "^2.5",
        "fakerphp/faker": "^1.9.1",
        "laravel/sail": "^1.0.1",
        "mockery/mockery": "^1.4.2",
        "nunomaduro/collision": "^5.0",
        "phpunit/phpunit": "^9.3.3"
    },
    "autoload": {
        "psr-4": {
            "App\": "app/",
            "Database\Factories\": "database/factories/",
            "Database\Seeders\": "database/seeders/"
        }
    },
    "autoload-dev": {
        "psr-4": {
            "Tests\": "tests/"
        }
    },
    "scripts": {
        "post-autoload-dump": [
            "Illuminate\Foundation\ComposerScripts::postAutoloadDump",
            "@php artisan package:discover --ansi"
        ],
        "post-root-package-install": [
            "@php -r \"file_exists('.env') || copy('.env.example', '.env');\""
        ],
        "post-create-project-cmd": [
            "@php artisan key:generate --ansi"
        ]
    },
    "extra": {
        "laravel": {
            "dont-discover": []
        }
    },
    "config": {
        "optimize-autoloader": true,
        "preferred-install": "dist",
        "sort-packages": true
    },
    "minimum-stability": "dev",
    "prefer-stable": true
}

Can you give me an example how to use triggers with db facade? i thought the way and syntax with the package is easier?!

your migration

up()
  DB::statement("CREATE TRIGGER your_tg_name ...
  ...


down()
  DB::statement("DROP TRIGGER your_tg_name
....

https://mariadb.com/kb/en/create-trigger/

@sr57 good point! I wasn't paying attention to the usage of the package but only to how to install it.

Hi @neilstee

I've noticed that this time you're getting a little off track, but you're doing a good job overall. Have a day and thanks for your helps to the community.

@sr57 what is that supposed to mean?!

The question here was he can't install a certain package and not "is this the best package for this task?".

Although it's good you have pointed that this package was not needed for a certain task, but I think my solution wasn't "off track".

And lastly, this is not a job. I'm helping the community using my time and effort so I think you should be kind with your words because every effort does count. It doesn't need to be measure or what.

But thanks, I'll be more "aware" to the question next time. 🙂

@neilstee

Whaoh !!!! comminication is always a difficult art ...

I'll wrote to be kind with you, to thank yo and it seems I hurt you ... APPOLOGIES ... english is not my mother language.

But thanks, I'll be more "aware" to the question next time

You answer to the question this time too, I never wrote or want to write other thing.

Do you want me to erase my post?

@sr57 all good mate! no need for apologies! we are all learning here and I'm glad people like you are willing to help the community! I've been seeing you answering questions here always.

@marco_1992 I have installed a fresh Laravel 8 and did what I suggest to you above and it all working fine.

I'm not sure if this helps but I'm using composer v2. What composer version you are running?

@marco_1992 how about your PHP version?

@marco_1992 so it is a PHP version issue.

@marco_1992 I would not suggest this but you can bypass this using --ignore-platform-reqs:

composer require DariusIII/laravel-database-trigger --ignore-platform-reqs

Now it works. Thank you!!

@marco_1992 but please be aware that you are ignoring the required version of PHP to use this package.

So I suggest upgrading your PHP if you have any trouble.

Okay. But I think, than I have to downgrade php because I think php 8 is the problem.