search

dbcodeio / public

The Power of Databases, The Convenience of VS Code: All in One Place
29 stars 1 forks source link

mysql introspection error #86

Closed wthee00 closed 5 days ago

wthee00 commented 3 weeks ago

Error: this[(_0x192273(...) _0x192273(...) "ON")] is not a function

VSCode Version: 1.95.0 Extension Version: 1.3.15 OS: win32 Arch: x64 Database Version: mariadb.org binary distribution - 10.4.27-MariaDB

mikeburgh commented 3 weeks ago

I think I have tracked this down.. Can you confirm did you set the database type as MySQL or Maria ?

wthee00 commented 3 weeks ago

I think I have tracked this down.. Can you confirm did you set the database type as MySQL or Maria ?

Yes. I have set the database type to MySQL. Image this is my .env database configuration. Image

mikeburgh commented 3 weeks ago

Thanks, I am working on a fix but if you changed the type to Maria in the connection form it will work as the underlying database is actually Maria

mikeburgh commented 3 weeks ago

Fixed in version 1.3.18

wthee00 commented 3 weeks ago

The issue persists in some databases but not all, potentially due to a large number of tables?

Error: _0x25aede[_0x27a9ac(...)]%3F.[_0x27a9ac(...)] is not a function

VSCode Version: 1.95.1 Extension Version: 1.3.18 OS: win32 Arch: x64 Database Version: mariadb.org binary distribution - 10.4.27-MariaDB

wthee00 commented 3 weeks ago

When I use SQL query to query the database, the table is shown. But the table is not show in the dropdown list and. The error is shown when click on the "gobs_crm" database. Image

mikeburgh commented 3 weeks ago

It looks like you still have the connection set as MySQL.. If you update to the latest version of the extension it should correct it, otherwise edit the connection and change the type to MariaDB, that's the actual database you are running, and while it's MySQL compatible, there are some differences, and that's what is causing this issue.

If that does not solve it, let me know and if you can share the exact error (Screen shot is great) I can dig further.

wthee00 commented 2 weeks ago

I changed the connection back to MySQL after updated to latest version which is 1.3.18. Before update, I change the connection to MariaDB also have error. Even now I change the connection to MariaDB also the same. Image Error: _0x25aede[_0x27a9ac(...)]%3F.[_0x27a9ac(...)] is not a function

mikeburgh commented 2 weeks ago

I just pushed a new version, can you give it a try ? I don't think it will be fixed, but it should provide me more information to hopefully track down where the issue is.

I tried replicating it with a MariaDB, same version and all the features (keys, indexes, trigers, functions etc) and was not able to replicate it.

mikeburgh commented 5 days ago

Closing this, you can re open it if it's still happening