While setup portal getting "SQLSTATE[HY000] [2002] (SQL: select * from settings where setting_key = app-public limit 1)" #2329

New Issue

OVERLORD · 2026-02-05T03:41:29+03:00

OVERLORD commented

2026-02-05 03:41:29 +03:00

Originally created by @GrooveDevops on GitHub (Jul 26, 2021).

Hi Have Bookstack setup everything got installed properly but now getting below error while accessing portal

Originally created by @GrooveDevops on GitHub (Jul 26, 2021). Hi Have Bookstack setup everything got installed properly but now getting below error while accessing portal ![image](https://user-images.githubusercontent.com/77006816/126951355-f3177a50-9c1c-4e27-a17a-eeb66468f1ab.png)

OVERLORD closed this issue

2026-02-05 03:41:31 +03:00

OVERLORD commented

2026-02-05 03:41:35 +03:00

@ssddanbrown commented on GitHub (Jul 27, 2021):

Hi @BirenGroove,
From the error provided it seems like the BookStack instance can't connect to the database at all.
It might depend on how you've installed BookStack, but are you able to run the php artisan migrate command from the BookStack installation folder; If so, does it run without error?

@ssddanbrown commented on GitHub (Jul 27, 2021): Hi @BirenGroove, From the error provided it seems like the BookStack instance can't connect to the database at all. It might depend on how you've installed BookStack, but are you able to run the `php artisan migrate` command from the BookStack installation folder; If so, does it run without error?

OVERLORD commented

2026-02-05 03:41:38 +03:00

@GrooveDevops commented on GitHub (Jul 28, 2021):

Hi Dan,

Thanks for your reply, yes it was SQL connectivity issue, I am using Azure Paas SQL which required SSL connection to connect SQL, I fixed this it start working, then I ran php artisan migrate inside of bookstack folder and all tables got created after that it's working fine

@GrooveDevops commented on GitHub (Jul 28, 2021): Hi Dan, Thanks for your reply, yes it was SQL connectivity issue, I am using Azure Paas SQL which required SSL connection to connect SQL, I fixed this it start working, then I ran **php artisan migrate** inside of bookstack folder and all tables got created after that it's working fine

OVERLORD commented

2026-02-05 03:41:40 +03:00

@ssddanbrown commented on GitHub (Jul 28, 2021):

Thanks for confirming @BirenGroove, Will therefore close this off.

@ssddanbrown commented on GitHub (Jul 28, 2021): Thanks for confirming @BirenGroove, Will therefore close this off.

Sign in to join this conversation.

Branches Tags

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: starred/BookStack#2329

While setup portal getting "SQLSTATE[HY000] [2002] (SQL: select * from settings where setting_key = app-public limit 1)" #2329

While setup portal getting "SQLSTATE[HY000] [2002] (SQL: select * from `settings` where `setting_key` = app-public limit 1)" #2329