error when using the search engine in production
EmilioVar opened this issue · 2 comments
Have you searched through other issues to see if your problem is already reported or has been fixed?
Yes, I did not find it.
Did you read the documentation?
Yes, I did not find it.
Have you tried to publish the views?
Yes - I didn't work.
Is there an error in the console?
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'generation_expression' in 'field list' (Connection: mysql, SQL: select column_name as name
, data_type as type_name
, column_type as type
, collation_name as collation
, is_nullable as nullable
, column_default as default
, column_comment as comment
, generation_expression as expression
, extra as extra
from information_schema.columns where table_schema = 'xxx' and table_name = 'xxx' order by ordinal_position asc)
PHP Version
8.2
PowerGrid
5.8.0
Laravel
11.9
Livewire
3.5.0
Alpine JS
No response
Theme
Tailwind 3.x
Describe the bug.
When I try to search for a record in the table, I get an error in the query. It seems that it tries to search for the variables.
To Reproduce...
- I enter text to search
- I get the error text, always the same, regardless of the search
Extra information
I have the mysql 5.5 version in production
Hello! Unfortunately, I cannot reproduce this problem and believe it is unrelated to PowerGrid due to the MySQL version. I suggest updating to the latest version.
Thank you
Hello! Unfortunately, I cannot reproduce this problem and believe it is unrelated to PowerGrid due to the MySQL version. I suggest updating to the latest version.
Thank you
Right! I have updated the version of mysql and now it works correctly. Thank you so much!