Getting "sqlite3.OperationalError: duplicate column name" error on running webui.bat

[Shivanadmb125]

Hi All,

Getting "sqlite3.OperationalError: duplicate column name" error on running webui.bat

Upgrading schema to version 3...
message_table_exist value is = True...
Traceback (most recent call last):
File "C:\Users\shivanand\Desktop\gpt4all_ui\GPT4All\app.py", line 728, in
bot = Gpt4AllWebUI(app, socketio, config, personality, config_file_path)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\INBACSLabuser\Desktop\gpt4all_ui\GPT4All\app.py", line 62, in init
super().init(config, personality, config_file_path)
File "C:\Users\shivanand\Desktop\gpt4all_ui\GPT4All\pyGpt4All\api.py", line 40, in init
self.db.populate()
File "C:\Users\shivanand\Desktop\gpt4all_ui\GPT4All\pyGpt4All\db.py", line 98, in populate
cursor.execute("ALTER TABLE message ADD COLUMN type INT DEFAULT 0") # Added in V1
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
sqlite3.OperationalError: duplicate column name: type

Can someone please help here? I'm running this on windows 10

Kindly let me know if anything else needed.

I have taken fresh pull today few hours back.

Best Regards,
Shivanand

[Shivanadmb125]

The installation was interrupted earlier so the database commands executed partially & now this error is gone. But getting below

(env) C:\Users\shivanand\Desktop\gpt4all_ui\GPT4All>python app.py --host 0.0.0.0 --port 9600 --db_path data/database.db
Traceback (most recent call last):
File "C:\Users\shivanand\Desktop\gpt4all_ui\GPT4All\app.py", line 728, in
bot = Gpt4AllWebUI(app, socketio, config, personality, config_file_path)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\shivanand\Desktop\gpt4all_ui\GPT4All\app.py", line 62, in init
super().init(config, personality, config_file_path)
File "C:\Users\INBACSLabuser\Desktop\gpt4all_ui\GPT4All\pyGpt4All\api.py", line 40, in init
self.db.populate()
File "C:\Users\INBACSLabuser\Desktop\gpt4all_ui\GPT4All\pyGpt4All\db.py", line 24, in populate
with sqlite3.connect(self.db_path) as conn:
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
sqlite3.OperationalError: unable to open database file

[ParisNeo]

it seems your database file is corrupted!
It is in databases/database.db
You can try to remove the database file or copy it somewhere else to verify. A new database file will be created.
It should be an error in upgrading the database that led to this situation.

[Shivanadmb125]

Hi, thank you for the feedback.
Yes, this was the problem, I re-tested in the new directory and this error is gone.

[ParisNeo]

You are welcome