http://api-dev.beerair.ml/api/v1/records/recently-visited-country?authenticated=true

{"success":false,"contents":null,"error":{"message":"could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet","code":500}}

DDL-AUTO: UPDATE 추가

jpa:
    database: mysql
    database-platform: org.hibernate.dialect.MySQL5InnoDBDialect
    hibernate:
      ddl-auto: update

→ 시크릿에도 DEV_YML, PROD_YML 수정하여 update

여전히 같은 에러

디비를 확인해보자

$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \\g.
Your MySQL connection id is 4267

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sulsuldb           |
| sys                |
+--------------------+
5 rows in set (0.00 sec)

mysql> use sulsuldb;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed

# 전체 테이블
mysql> show tables;
+--------------------+
| Tables_in_sulsuldb |
+--------------------+
| beer               |
| beer_flavor        |
| continent          |
| country            |
| flavor             |
| member             |
| member_beer        |
| member_beer_flavor |
| member_level       |
| record             |
| record_flavor      |
| request_beer       |
| token              |
+--------------------+
13 rows in set (0.00 sec)

# description record 테이블 
mysql> desc record;
+-------------------+--------------+------+-----+---------+----------------+
| Field             | Type         | Null | Key | Default | Extra          |
+-------------------+--------------+------+-----+---------+----------------+
| record_id         | bigint       | NO   | PRI | NULL    | auto_increment |
| created_at        | datetime     | YES  |     | NULL    |                |
| deleted_at        | datetime     | YES  |     | NULL    |                |
| updated_at        | datetime     | YES  |     | NULL    |                |
| content           | varchar(255) | YES  |     | NULL    |                |
| end_country_eng   | varchar(255) | YES  |     | NULL    |                |
| end_country_kor   | varchar(255) | YES  |     | NULL    |                |
| feel              | int          | YES  |     | NULL    |                |
| image_url         | varchar(255) | YES  |     | NULL    |                |
| is_public         | bit(1)       | YES  |     | NULL    |                |
| start_country_eng | varchar(255) | YES  |     | NULL    |                |
| start_country_kor | varchar(255) | YES  |     | NULL    |                |
| beer_id           | bigint       | YES  | MUL | NULL    |                |
| member_id         | bigint       | YES  | MUL | NULL    |                |
+-------------------+--------------+------+-----+---------+----------------+
14 rows in set (0.00 sec)

end_country_eng , end_country_kor 이 있는데 왜 없다구 하는지…?