Filament•11mo ago

Export Action Table Creation - Bug?

I am trying to use the pre built export table action, I have followed the instruction to create the required migrations and exporter found here. https://filamentphp.com/docs/3.x/actions/prebuilt-actions/export#creating-an-exporter I can add an action to a table and the process attempts to export but then fails and throws this error https://flareapp.io/share/VP6qJRem I have looked at the migrations that have been run and it appears it has installed the Import tables but not the Export tables? Not sure if I have done something incorrectly here or if it is a bug?
INFO Running migrations.
2024_01_24_040457_create_job_batches_table ........................................................... 20ms DONE 2024_01_24_040508_create_notifications_table ......................................................... 11ms DONE 2024_01_24_040518_create_imports_table ................................................................ 9ms DONE 2024_01_24_040519_create_failed_import_rows_table ..................................................... 8ms DONE Thanks in advance for any help.

Flare

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'test.exports' doesn't exist (Connection: mysql, SQL: insert into exports (user_id, exporter, total_rows, file_disk, updated_at, created_at) values (1, App\Filament\Exports\AdjustmentExporter, 10, public, 2024-01-24 23:47:44, 2024-01-24 23:47:44)) - The error occurred at htt...

Export action - Actions - Filament

6 Replies

Matthew•11mo ago

Can you show your composer.json?

MazeEzamOP•11mo ago

{
    "name": "laravel/laravel",
    "type": "project",
    "description": "The skeleton application for the Laravel framework.",
    "keywords": [
        "laravel",
        "framework"
    ],
    "license": "MIT",
    "require": {
        "php": "^8.1",
        "filament/filament": "^3.0-stable",
        "guzzlehttp/guzzle": "^7.2",
        "laravel/framework": "^10.10",
        "laravel/sanctum": "^3.3",
        "laravel/tinker": "^2.8"
    },
    "require-dev": {
        "fakerphp/faker": "^1.9.1",
        "laravel-shift/blueprint": "^2.9",
        "laravel/pint": "^1.0",
        "laravel/sail": "^1.18",
        "mockery/mockery": "^1.4.4",
        "nunomaduro/collision": "^7.0",
        "phpunit/phpunit": "^10.1",
        "spatie/laravel-ignition": "^2.0"
    },
    "autoload": {
        "psr-4": {
            "App\\": "app/",
            "Database\\Factories\\": "database/factories/",
            "Database\\Seeders\\": "database/seeders/"
        }
    },

{
    "name": "laravel/laravel",
    "type": "project",
    "description": "The skeleton application for the Laravel framework.",
    "keywords": [
        "laravel",
        "framework"
    ],
    "license": "MIT",
    "require": {
        "php": "^8.1",
        "filament/filament": "^3.0-stable",
        "guzzlehttp/guzzle": "^7.2",
        "laravel/framework": "^10.10",
        "laravel/sanctum": "^3.3",
        "laravel/tinker": "^2.8"
    },
    "require-dev": {
        "fakerphp/faker": "^1.9.1",
        "laravel-shift/blueprint": "^2.9",
        "laravel/pint": "^1.0",
        "laravel/sail": "^1.18",
        "mockery/mockery": "^1.4.4",
        "nunomaduro/collision": "^7.0",
        "phpunit/phpunit": "^10.1",
        "spatie/laravel-ignition": "^2.0"
    },
    "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",
            "@php artisan filament:upgrade"
        ],
        "post-update-cmd": [
            "@php artisan vendor:publish --tag=laravel-assets --ansi --force"
        ],
        "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,
        "allow-plugins": {
            "pestphp/pest-plugin": true,
            "php-http/discovery": true
        }
    },
    "minimum-stability": "stable",
    "prefer-stable": true
}

"autoload-dev": {
        "psr-4": {
            "Tests\\": "tests/"
        }
    },
    "scripts": {
        "post-autoload-dump": [
            "Illuminate\\Foundation\\ComposerScripts::postAutoloadDump",
            "@php artisan package:discover --ansi",
            "@php artisan filament:upgrade"
        ],
        "post-update-cmd": [
            "@php artisan vendor:publish --tag=laravel-assets --ansi --force"
        ],
        "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,
        "allow-plugins": {
            "pestphp/pest-plugin": true,
            "php-http/discovery": true
        }
    },
    "minimum-stability": "stable",
    "prefer-stable": true
}

Yep happy to share.

Matthew•11mo ago

this is weird which version of filament are you on?

MazeEzamOP•11mo ago

3.2 It's like the migrations are running the import table not the required export table when using the Documented methods?

Matthew•11mo ago

Weird Because it works for me Are you absolutely sure you ran these commands?

php artisan queue:batches-table
php artisan notifications:table
php artisan vendor:publish --tag=filament-actions-migrations
 
php artisan migrate

php artisan queue:batches-table
php artisan notifications:table
php artisan vendor:publish --tag=filament-actions-migrations
 
php artisan migrate

Because when I publish migration I have an export folder

MazeEzamOP•11mo ago

I have just updated to the latest release 3.2.12 and now when I run the same command its has worked for me also. I ran the above command 3 times yesterday using 3.2.11 and it would not install the exports table. Maybe the latest release has fixed the issue?? Thanks for your help

Gaming

Programming

Export Action Table Creation - Bug?