SQL error on tbale lock check

croshad's profile image croshad posted 5 years ago in General Permalink

So i'm running a local environment with Laragon and after creating and saving the initial session and connecting to the db, every subsequent connection attempt using that saved session results in a SQL syntax error pointing to the line "SHOW OPEN TABLES FROM DATABASE WHERE in_use!=0;". I then have to delete the session and create a new one and it works again until next time it checks for table locks. I figured out it's because the database isn't in backticks. I am using the latest MySQL 8.0.15, it works fine in version 5 and i tried different db names just in case. I thought backticks weren't needed when it's a normal non reserved db name but i don't know anymore. Is there a way to make Heidi always add backticks to db names ?

Thanks

croshad's profile image croshad posted 5 years ago Permalink

Sorry for the title typo.

Please login to leave a reply, or register at first.