Chatbot stops responding after first interaction & cannot access SQL query

[marcofog]

app:

library(shiny)
library(bslib)
library(querychat)

querychat_config <- querychat_init(mtcars)

ui <- page_sidebar(
  sidebar = querychat_sidebar("chat"),
  DT::DTOutput("dt")
)

server <- function(input, output, session) {
  querychat <- querychat_server("chat", querychat_config)
  
  output$dt <- DT::renderDT({
    DT::datatable(querychat$df())
  })
}

shinyApp(ui, server)

Steps to reproduce

Launch the Shiny app with the code above
Ask a first question to the chatbot (e.g., "Show cars with mpg > 20")
The chatbot responds correctly
Ask a second question
The chatbot does not respond

Additional behavior

Attempt to access querychat$sql() to see the generated query doesn't work
No error messages visible in the user interface

packageVersion("querychat")
[1] ‘0.0.0.9000’
packageVersion("shiny")
[1] ‘1.10.0’
packageVersion("bslib")
[1] ‘0.9.0’
R.version.string
[1] "R version 4.4.3 (2025-02-28 ucrt)"
Sys.info()[c("sysname", "release", "version")]
sysname release version
"Windows" "10 x64" "build 22631"

[chendaniely]

Hello. I think I was running into this the other day as well and we had to immediately try and merge #27.
Can you try to remove and re-install both shinychat and querychat?

# install.packages("pak")
pak::pak("posit-dev/shinychat/pkg-r")
pak::pak("posit-dev/querychat/pkg-r")

[marcofog]

It worked!
Thanks a lot. There is a profound and woderful idea behind this package.

Just a note:
the command:
pak::pak("posit-dev/shinychat")
doesn't work:

<<

pak::pak("posit-dev/shinychat")
Error:
! error in pak subprocess
Caused by error:
! Could not solve package dependencies:

• posit-dev/shinychat: ! pkgdepends resolution error for posit-dev/shinychat.
  Caused by error:
  ! Can't find R package in GitHub repo posit-dev/shinychat
  Type .Last.error to see the more details.

[chendaniely]

@marcofog : ahh yes this repo is a bit special since it hosts both the R and python package version of querychat, the correct install command in R is pak::pak("posit-dev/querychat/pkg-r") (you need to tell it to look in the pkg-r folder)

We're putting together the official pkgdown sites and docs at the moment, but you can see more in the R readme file for now: https://github.com/posit-dev/querychat/tree/main/pkg-r

[chendaniely]

OH! sorry I totally misread your comment. yes it should also read pak::pak("posit-dev/shinychat/pkg-r") i updated my original comment above with the install instructions.

Thank you for reporting this issue. I'm going to close this issue now that it's all working for you (and i updated the install instructions)