Database Doesn't Give Any Results

[Mrcrix 10]

Hi, I'm trying to connect to a DB on my host, the connection is successful but when I run "query with result" it doesn't give any result, the same query on myadmin is working normally and give the result.

 

I tried to run a wrong query and I get the correct error message so it seems to be correct, I cannot understand why I don't get any result, here the very simple code I used:

 

define prendiLocalita {
    plugin command("DatabaseCommands.dll", "connect to database", "mysql:server=\'mysql.us.cloudlogin.co\';uid=\'MY_ID\'; pwd=\'MY_PASS\'; database=\'MY_DB_NAME\'; port=\'\'; pooling=false") {
        plugin command("DatabaseCommands.dll", "query with results", "SELECT * FROM members", &myList)
    }

 

I tried to use the simpler query and making an INSERT and it works correctly.

 

Any idea?

 

Thank you in advance!!

 

///////////////  U P D A T E  ////////////////

I fixed the issue, I just needed to restart ubot studio and this same script gave the expected results