Migration error [Laravel 8.8, pagebuilder 0.24]

[promanapeople]

`composer require hansschouten/laravel-pagebuilder //ok php artisan vendor:publish --provider="HansSchouten\LaravelPageBuilder\ServiceProvider" --tag=config //ok php artisan migrate

PDOException

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'pb.pagebuilder__settings' doesn't exist

at D:\www\pb\vendor\hansschouten\phpagebuilder\src\Core\DB.php:65 61▕ $stmt = $this->pdo->prepare("SELECT {$columns} FROM {$table}"); 62▕ } else { 63▕ $stmt = $this->pdo->prepare("SELECT * FROM {$table}"); 66▕ return $stmt->fetchAll(); 67▕ } 68▕ 69▕ /**

1 D:\www\pb\vendor\hansschouten\phpagebuilder\src\Core\DB.php:65 PDOStatement::execute()

2 D:\www\pb\vendor\hansschouten\phpagebuilder\src\Repositories\BaseRepository.php:156 PHPageBuilder\Core\DB::all("pagebuilder__settings", "*")`

[Dennise89]

Any update on this topic? I've got the same error in a fresh laravel app.

EDIT: Okay I fixed it by creating two tables in the database:

create table pagebuilder__settings (
    id int NOT NULL AUTO_INCREMENT,
    settings varchar(50) UNIQUE,
    value MEDIUMTEXT,
    is_array BOOLEAN,
    created_at DATETIME,
    updated_at DATETIME, PRIMARY KEY (id)
);

create table pagebuilder__page_translations (
    id int NOT NULL AUTO_INCREMENT,
    page_id INT UNSIGNED NOT NULL,
    locale VARCHAR(50),
    title VARCHAR(255),
    route VARCHAR(255),
    created_at DATETIME,
    updated_at DATETIME,
    PRIMARY KEY (id)
);

After that just run php artisan migrate:fresh(). Only use this if you have nothing of value in your database ofcourse!!

[irvine48]

once php artisan vendor:publish, remove the database prefix in cofig file to complete the config:cache. i found might be database migration run before config file read causing issue to this command broken.

[neetkiss]

public function all(string $table, $columns = '*') { $this->checkAndCreateTable($table); if (is_array($columns)) { foreach ($columns as &$column) { $column = preg_replace('/[^a-zA-Z_]*/', '', $column); } $columns = implode(',', $columns); $stmt = $this->pdo->prepare("SELECT {$columns} FROM {$table}"); } else { $stmt = $this->pdo->prepare("SELECT * FROM {$table}"); } $stmt->execute() return $stmt->fetchAll(); }

`public function checkAndCreateTable(string $tableName)
{
    $tableExists = $this->pdo->query("SHOW TABLES LIKE '{$tableName}'")->rowCount() > 0;
    if (!$tableExists) {
        // Tablo yok, oluştur
        $createQuery = "CREATE TABLE {$tableName} (
        id INT AUTO_INCREMENT PRIMARY KEY,
        created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
        updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
    )";

        $this->pdo->exec($createQuery);
        return true;
    }

    return true;
}`

line 54 in phpagebuilder/src/Core/DB.php
I will try to solve the errors on the project, this will do the trick until then.