Can't launch / Station crashes: SQLITE_ERROR | Duplicate column name: subdomain, manifestURL, alwaysLoaded, installContext

The issue I’m facing is:

Hello community, since a few days ago I see this error when opening Station, to some of you it has happened … ??? with this error I can not access the Station app I hope you can help me Thanks
(I leave a reference image)


Here’s the detailed report

  • Trigger:
  • Issue:
  • Explanatory gifs/pictures (we really need that :pray: ):
  • OS version: w 8.1
  • Station version: 1.15.1

:writing_hand: Brief description of the issue

My problem is that …


:warning: Mandatory details

  • :gun: Trigger
    open station in mac os mojave 10.14 (18A391)

  • :boom: Issue
    Station App will not open at all
    SQLITE_ERROR: duplicate column name: subdomain

  • :movie_camera: Explanatory gifs/pictures — Station window won’t open, just this error on startup

  • :desktop_computer: OS version
    Mojave mac os mojave 10.14 (18A391)

  • :gear: Station version
    1.26.0

Is there any update here? I’m having this issue and haven’t been able to use Station since.

Hey everyone,

Resetting your Station will solve your issue:

Sorry for the inconvenience

1 Like

This worked for me! Thanks so much

:writing_hand: Brief description of the issue

My problem is that … I downloaded the program to my computer and once it installed I received this error SQLITE_ERROR: duplicate column name: alwaysLoaded

The program doesn’t start.

:warning: Mandatory details

  • :gun: Trigger

  • :boom: Issue — Won’t start at all

  • :movie_camera: Explanatory gifs/picturesimage

  • :desktop_computer: OS version — Windows

  • :gear: Station version — Latest version

:writing_hand: Brief description of the issue

After updating to 1.40.1, Station has a fatal error on startup with the message “SQLITE_ERROR: duplicate column name: manifestURL”


:warning: Mandatory details

  • :gun: Trigger — Open Station

  • :boom: Issue — Fatal error

  • :movie_camera: Explanatory gifs/picturesimage

  • :desktop_computer: OS version — Windows 10 Home, version 1809, OS build 17758.4

  • :gear: Station version — 1.40.1

Same for me. After updating to the last version I can’t open the app it promps Station Fatal Error, SQLITE_ERROR: duplicate column name: manifestURL.

Hey there :wave:,

Thanks for reaching out!
“Resetting” your Station profile should solve your issue:

Tell us how it goes :wink:

1 Like

Station 1.40.1
Windows 10(1809)

The following dialog is displayed

Station Fatal Error
SQLITE_ERROR: duplicate column name: manifestURL

dialog

1 Like

I did not want to reset Station, so I solved this the following way:

  1. Download DB Browser for SQLite: https://sqlitebrowser.org/
  2. Find your Station database. For me it was C:\Users\myUsername\AppData\Roaming\Station\db\station.db
  3. Open the database in DB Browser.
  4. Click on the servicesData table and click Modify Table, and rename the manifestURL column. For me there was no data in it. I renamed it to manifestURL_servicesData.
  5. Click Write Changes.
  6. Open Station. After it opens you will see there is a new manifestURL column in servicesData, so I think the problem was that Station was trying to create a new manifestURL column in servicesData when one already exists.

@Alexandre I think this should be an easy fix, and we can’t be the only two users with this problem.

4 Likes

For me the manifestURL column that needed to be renamed happened to be in the activity table. It was also empty so I just renamed it to manifestURL_activity and Station was able to load.

It’s works but I had to re-config everythig (reset is not the best solution but… ok, thanks!)

:writing_hand: Brief description of the issue

My problem is that …ever since the new update on April 8th, my Station app keeps crashing…


:warning: Mandatory details

  • :gun: Trigger

  • :boom: Issue

  • :movie_camera: Explanatory gifs/pictures

  • :desktop_computer: OS version

  • :gear: Station version

:writing_hand: Brief description of the issue

My problem is that …

Station does not launch on my Macbook Pro

Error message:

Station Fatal Error

SQLITE_ERROR: duplicate column name: manifest URL


Reinstalling does nothing


:warning: Mandatory details

  • :gun: Trigger — Launching the app

  • :boom: Issue — Fails to Launch

  • :movie_camera: Explanatory gifs/pictures

  • :desktop_computer: OS version — MacOS HighSierra 10.13.6

  • :gear: Station version — Newest downloaded (4/8/19)

I’m having the exact same problem. I have uninstalled and reinstalled Station and I continue to have this problem.

The error received is:
SQLITE_ERROR: duplicate column name: manifestURL

This occurs whenever the program is initiated. Station will not fully start and will shut down after the error is closed.

This worked. Thank you! I had to rename the one in my Activity table for it to work. Oh behalf of the others, thank you for sharing this info!

This started happening for me today on MacOS.

Hi @Sebastiaan

Where you able to resolve the problem?
If not you could try the next two options:
For the brave ones (Watch out to not change anything else except for the manifestURL column’s Name):

If you dont mind to reset your station you try this option:

Let me know if it helped :wink:

Thanks, resetting my profile did help. But that is not a fix for the actual bug.

AFAIK I changed nothing to my Station settings. I updated & rebooted my Mac last night, on opening Station, it maybe did an update or something else went wrong.