# Troubleshooting

Hopefully you can solve your problems with the details below. If not please [contact us][/contact/] and we'll try our best to help.

# How to Debug Beekeeper Studio

# Enable Debug Mode and Collect Logs

You can find logs for Beekeeper in these directories:

Linux: ~/.config/beekeeper-studio/logs/{process type}.log MacOS: ~/Library/Logs/beekeeper-studio/{process type}.log Windows: %USERPROFILE%\AppData\Roaming\beekeeper-studio\logs{process type}.log

By default they will only contain uncaught errors.

You can enable extended logging by starting Beekeeper Studio with the debug flag DEBUG=*.

On linux, just run the app like this: DEBUG=* beekeeper-studio

# SQLite

# I get 'permission denied' when trying to access a database on an external drive

If you're on Linux and using the snap version of Beekeeper you need to give the app an extra permission.

sudo snap connect beekeeper-studio:removable-media :removable-media

If you're on another platform, please open a ticket and we'll try to help you debug the problem.

# PostgreSQL

# I get a column does not exist error, but the column does exist!

Postgres is weird with case sensitivity. This is usually the cause of the dreaded column does not exist error.

Postgres has two behaviors with column names:

  • If you define your column name without double quotes postgres downcases the name.
  • If you define your column name WITH double quotes, you need to use double quotes forever.

For example:

In this table:

CREATE table foo("myColumn" int);

  • This won't work: select myColumn from foo
  • This will works: select "myColumn" from foo

See this StackOverflow answer or this section in the PostgreSQL manual