search

inhinias / Arcanum

A small tool for saving encrypted passwords in a database.
GNU General Public License v3.0
5 stars 0 forks source link

Invalid SQL for creating the tables #11

Closed inhinias closed 5 years ago

inhinias commented 5 years ago

The SQL for creating the tables if the don't exist initially is wrong. Error for all tables: Creating table passTable: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'KEYname VARCHAR(300)email VARCHAR(300)username VARCHAR(300)category VARCHAR(300)' at line 1 Qt version: 5.11.2 PyQt version: 5.11.3 SIP version: 4.19.13 Linux Mint 19 Tara x86_64 Kernel: 4.15.0-42-generic

inhinias commented 5 years ago

My stupid ass didn't realize that there need to be commas separating each column. This was fixed with commit: Fixed Table Creation