Level 75
If this is a many to many, check conventions here: https://laravel.com/docs/10.x/eloquent-relationships#many-to-many-table-structure
Apr 12, 2023
10
Level 1
There is no column with name "product_owner" on table "products". error
I'm trying to get a column type of a specific table and column, the problem I'm having is that when I get to the line of code I get this error
There is no column with name "product_owner" on table "products".
The thing is, is that there is a product_owner in the products table.
Here is my code
foreach(Schema::getColumnListing('products') as $fields)
{
$columnType = Schema::getColumnType('products', $fields);
dd($columnType);
}
Level 1
@jlrdw there is no relationship. product_owner is a string field in the products table
Level 122
connected to the right database?
change your dd to dump, run the script then paste the result here
Level 1
@Snapey yes it is and this is what i get when I dump
Doctrine\DBAL\Schema\Exception\ColumnDoesNotExist
There is no column with name "product_owner" on table "products".
at vendor/doctrine/dbal/src/Schema/Exception/ColumnDoesNotExist.php:16
12▕ final class ColumnDoesNotExist extends SchemaException
13▕ {
14▕ public static function new(string $columnName, string $table): self
15▕ {
➜ 16▕ return new self(
17▕ sprintf('There is no column with name "%s" on table "%s".', $columnName, $table),
18▕ self::COLUMN_DOESNT_EXIST,
19▕ );
20▕ }
+5 vendor frames
6 Modules/Products/Models/Product.php:96
Illuminate\Support\Facades\Facade::__callStatic()
7 Modules/Products/Console/RefreshProductColumns.php:44
Modules\Products\Models\Product::refreshColumns()
Level 122
what does this return ?
dd(Schema::getColumnListing('products') );
Level 1
@Snapey I get
array:4 [ // Modules/Products/Models/Product.php:86
0 => "id"
1 => "product_owner"
2 => "name"
3 => "description"
]
Level 122
@stormy478 anything related to product_owner in your model?
Level 1
@Snapey product_owner is just a simple string that is only gonna have a name to it
Level 122
@stormy478 php artisan cache:clear ?
Level 122
What is refreshColumns function ?
Please or to participate in this conversation.