You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Hi i found a syntax error in "app/controllers/database_connections_controller.rb".
I got this error:
"Mysql2::Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ASC LIMIT 50 OFFSET 0' at line 1: SELECT database_connections.* FROM database_connections ORDER BY database ASC LIMIT 50 OFFSET 0"
It's fixed if i modify this line:
@database_connections = DatabaseConnection.order("database ASC").page(params[:page])
To this:
@database_connections = DatabaseConnection.order("database ASC").page(params[:page])
The text was updated successfully, but these errors were encountered:
Hi i found a syntax error in "app/controllers/database_connections_controller.rb".
I got this error:
"Mysql2::Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ASC LIMIT 50 OFFSET 0' at line 1: SELECT
database_connections
.* FROMdatabase_connections
ORDER BY database ASC LIMIT 50 OFFSET 0"It's fixed if i modify this line:
@database_connections = DatabaseConnection.order("database ASC").page(params[:page])
To this:
@database_connections = DatabaseConnection.order("
database
ASC").page(params[:page])The text was updated successfully, but these errors were encountered: