Skip to content

sqlite3.OperationalError: duplicate column name: carid #57

@AlbertoZen

Description

@AlbertoZen

I installed the docker version of TeslaETA and I cannot get it to work, I'm using the teslamateapi back end.

The error that I keep getting is:

sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) duplicate column name: carid

Attached is the full log from docker logs.

teslaeta_log.txt

Querying the SQLite database I don't get almost anything from it:

sqlite> .tables
alembic_version  share          
sqlite> select * from share;
sqlite> select * from alembic_version;
sqlite> 

Checking with sqlite-utils

sqlite-utils schema data/service.db 
CREATE TABLE share (
        shortuuid TEXT(22) NOT NULL, 
        lat FLOAT, 
        lng FLOAT, 
        expiry INTEGER NOT NULL, 
        carid INTEGER, 
        PRIMARY KEY (shortuuid), 
        UNIQUE (shortuuid)
);
CREATE TABLE alembic_version (
        version_num VARCHAR(32) NOT NULL, 
        CONSTRAINT alembic_version_pkc PRIMARY KEY (version_num)
);

Any help would be appreciated, thanks.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions