Problem : Can't view query

WilliamVenner / SQLWorkbench

🖥️ An in-game Garry's Mod SQLite & MySQL database interface

https://steamcommunity.com/sharedfiles/filedetails/?id=1712956238

MIT License

34 stars 4 forks source link

Problem : Can't view query #6

Open Yoshi-OOF opened 4 years ago

Yoshi-OOF commented 4 years ago

Hey! I have a problem I can't view any query and I don't know why : Here is a screenshot : http://prntscr.com/uocmqp

But utime save in the sv.db : http://prntscr.com/uocmup

But when i go in db browser that's work fine : http://prntscr.com/uocp1u

Can you help me? I say you thank you in advance.

WilliamVenner commented 4 years ago

Does it work if you use "Basic Mode"?

Yoshi-OOF commented 4 years ago

Wait i will try

Yoshi-OOF commented 4 years ago

Nope :

MenschlichTv commented 4 years ago

Every time I use the SQLWorkbench, I get the same errors... therefore I just write the select statements by myself...

WilliamVenner commented 4 years ago

No clue, everything works fine for me.

RobertEikeland commented 3 years ago

Yeah, I am also experiencing this issue. Clicking any of the tables throws up this error. (This is in SQLite)

WilliamVenner commented 3 years ago

I tested with both SQLite and MySQL D:

MenschlichTv commented 3 years ago

I've only used the workbench with SQLite tho... But I have tried this in local multiplayer and also on multiple servers, and it didn't work on any of them... Not only for me but also for all other admins.

WilliamVenner commented 3 years ago

I think it might have something to do with the compression of the queries, as net.WriteData/ReadData were changed recently and it's become clear that the number of "bytes" I'm inputting to the functions is grossly incorrect.

@MenschlichTv Do you think you could fiddle around with the code to confirm?

WilliamVenner commented 3 years ago

Saying that, I have no idea why it works for me in that case.

MenschlichTv commented 3 years ago

I also just saw in the screenshots that there should be an auto complete? Because I also never saw that ingame... The only difference between IDE and basic mode was the coloring of keywords.. at least everytime I used it it was like that

WilliamVenner commented 3 years ago

You on x86_64? That also works for me.

MenschlichTv commented 3 years ago

Im playing with the default gmod version

MenschlichTv commented 3 years ago

just noticed that I also get this error: [HTML] :1: Uncaught TypeError: Property 'SetSQLQuery' of object # is not a function

WilliamVenner commented 3 years ago

You need to be on x86_64 branch, the default gmod web view stuff is too old to work properly with this.

MenschlichTv commented 3 years ago

Yup, works now.

Craftgeeking commented 2 years ago

Hello there ! , sorry to revive this issue but the same thing that happened to Yoshi happened to me : SQlite viewing doesn't work

So i was wondering if i needed another module like tmysql or mysqloo to view the sqlite database ?