search

plankanban / planka

The realtime kanban board for workgroups built with React and Redux.
https://planka.app
GNU Affero General Public License v3.0
8.09k stars 760 forks source link

[Bug]: how to show sql queries #927

Closed gpt8763 closed 2 weeks ago

gpt8763 commented 3 weeks ago

Where is the problem occurring?

None

What browsers are you seeing the problem on?

No response

Current behaviour

i try to many way as follow ,but can't print sql

Desired behaviour

i want planka print sql where it is runing

Steps to reproduce

how to show sql queries. i try to many way as follow ,but can't print sql SAILS_LOG_SQL=1 node app.js process.env.SAILS_LOG_SQL = 1; set debug level in sails.config.log

Other information

No response

meltyshev commented 3 weeks ago

Hi! This can be done with DEBUG=query, though I've only tested it in development mode.

gpt8763 commented 3 weeks ago

I added DEBUG=query to the server's .env file, but I still don't see the sql log in the DEBUGGER CONSOLE

meltyshev commented 3 weeks ago

Hm, that's strange. I just checked by adding DEBUG=query to the .env file and also tried it in the production environment with docker-compose.yml, it works for me - every database query is logged to the console.