F
Filament•5mo ago
Matthew

Error after switching to pgsql

SQLSTATE[42883]: Undefined function: 7 ERROR: operator does not exist: text ->> unknown LINE 1: ...ifications"."notifiable_id" is not null and "data"->>'format... ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts. https://flareapp.io/share/LPlp21DP I never had this issue with mariadb, but as soon as I switched to pgsql and migrating, I get this error. Summerizing: 1) Im on production with ubuntu and postgres 2) Im running octane 3) Issue appeared after switching to pgsql. It was fine with mariadb
Flare
SQLSTATE[42883]: Undefined function: 7 ERROR: operator does not exist: text ->> unknown LINE 1: ...ifications"."notifiable_id" is not null and "data"->>'format... ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts. (Connection: pg...
4 Replies
Matthew
Matthew•5mo ago
Bump
Patrick1989
Patrick1989•4mo ago
Im guessing that is a json column? the ""data" field in your DB what type of field is that? If it was a text field in mariadb it should now be a JSONB field if I'm correct
Matthew
Matthew•4mo ago
Yeah indeed. That's what I did yesterday and it worked. I altered the column to json and the error disappeared. I did find it weird that postgres didn't do it automatically
Patrick1989
Patrick1989•4mo ago
glad you fixed it
Want results from more Discord servers?
Add your server
More Posts
Cant edit variable inside custom page class in bladei have a custom page which has public variable inside it. I wanted to make it accessible in the viewUdate record with livewevireHello, I have a problem with updating data and creating a new order. The error message is 'get_classEquivalence of getEloquentQuery( ) in Relation ManagerWhat is the equivalence of the getEloquentQuery( ) method in Relation Manager, I need to get the datBulkAction too many records, can we chunk these?I'm running into an issue with a bulk table action. The table has approximately 2500 records but SQLWidget Table BulkActionI have a problem when i use a bulkaction on a WidgetAction, no matter what selected, everything get Hide tenantID in URLHello, I am testing multi-tenancy and I was looking if it is possible to hide the tenantID. Since filament/forms/src/Components/Tabs/Tab.php$this->id(Str::slug($label)); Returns empty for non-English, causing all tabs to be selected.Can I use import options to allow the user to define the CSV delimiter?I would like to use the import action and I can see that one can introduce custom options for the usManage data in foreign databasesHi experts, I am very new to both Laravel and Filament, so maybe my question might be silly, but I dSearchable translatable columnHi guys, I'm using a translation package (astrotomic) and I'm trying to make a column searchable, bu