diff options
author | jakobst1n <jakob@jakobstendahl.no> | 2023-09-08 19:06:07 +0200 |
---|---|---|
committer | jakobst1n <jakob.stendahl@outlook.com> | 2023-09-08 19:13:09 +0200 |
commit | 617bb0662f85f4c6c0f78fe39d5a33a2bd9a8b61 (patch) | |
tree | d9ef55a4fcb76e15bdd682c04145e9e6fe54b406 /src/database.rs | |
parent | 074ddd3893bd373048050ef912af51aeb3c66178 (diff) | |
download | RSS-watcher-617bb0662f85f4c6c0f78fe39d5a33a2bd9a8b61.tar.gz RSS-watcher-617bb0662f85f4c6c0f78fe39d5a33a2bd9a8b61.zip |
Add query which sets sql_mode for the version row to be inserted (#2)
Diffstat (limited to 'src/database.rs')
-rw-r--r-- | src/database.rs | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/src/database.rs b/src/database.rs index cd097eb..83d3fea 100644 --- a/src/database.rs +++ b/src/database.rs @@ -75,6 +75,10 @@ fn table_create(conn: &mut Conn) { error!("Could not create table! ({:#?}", x); process::exit(1); } + if let Err(x) = tx.query_drop("SET SESSION sql_mode='NO_AUTO_VALUE_ON_ZERO'") { + error!("Could not set NO_AUTO_VALUE_ON_ZERO sql_mode for session, you might have to change the id of this row manually from 1 to 0! ({:#?}", x); + process::exit(1); + } q = "INSERT INTO `rss-watcher-feeds` (id, url, last_fetch, |