rails-devise icon indicating copy to clipboard operation
rails-devise copied to clipboard

conversion from Sqlite3 to MySQL

Open ZAJDAN opened this issue 5 years ago • 0 comments

Hello, on Sqlite3 Devise worked without problem. Now I converted db from Sqlite3 to MySQL and Rails returns error: Mysql2::Error: Unknown column 'users.' in 'where clause': SELECT users.* FROM usersWHEREusers.`` = 1 LIMIT 1 in my Table is not column 'users'...I have just: id, email, encrypted_password, reset_password_token, reset_password_sent_at, remember_created_at, sign_in_count, current_sign_in_at, last_sign_in_at, current_sign_in_ip, last_sign_in_ip, created_at, updated_at

is necessary do something more after such conversion database?

Thank You

ZAJDAN avatar Jul 16 '19 09:07 ZAJDAN