-
-
Notifications
You must be signed in to change notification settings - Fork 32
Open
Labels
bugSomething isn't workingSomething isn't working
Description
Describe the bug
the issue is that I have a query in my API where I had to use some manual queries and when the enlighten wants to create a build example in DatabaseExampleBuilder@addQuery on 95 this is what happening:
enlighten error
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'set @totalDuration=0, ?, ?, ?, ?, ?, ?, ?)' at line 1 (SQL: insert into `enlighten_example_queries` (`sql`, `bindings`, `time`, `request_id`, `snippet_id`, `example_id`, `updated_at`, `created_at`) values (set @totalDuration=0, [], 0.26, 1050, ?, 896, 2021-11-10 14:41:15, 2021-11-10 14:41:15))my query
DB::statement(DB::raw('set @totalDuration=0'));I have tried to fix it on my local simply by putting the value of $queryExecuted->sql inside a double quote so the QUERY getting stored as plain text and it worked.
I would send a PR soon if you think this change doesn't break the system.
Metadata
Metadata
Assignees
Labels
bugSomething isn't workingSomething isn't working