MySQL Database Is Coming Up Blank

[WarrenIndLLC 0]

Hey guys,

 

So, I'm trying to pull the first row of DB info to my bot. It connects to the DB just fine and I'm pretty sure I have the right code in, it just continually gives me blank results

 

plugin command("DatabaseCommands.dll", "connect to database", "mysql:server=***.**.***.**;uid=******_push; pwd=*********; database=******_push; port=3306; pooling=false") {

    plugin command("DatabaseCommands.dll", "query with results", "SELECT * FROM \'sendpush\' LIMIT 1", &results)

}

 

When I test run that through uBot I get a blank return of results. Anybody have an idea of what it could be?

 

Thanks

[vonnch 1]

I got nothing on top of my head for this. Have you tried checking the logs to see if it points you to something? 

[the_way 52]

use: SELECT COUNT(*) FROM tablename

 

This will give you a count of the number of rows in the DB. You should use that first to see if you can make the connection.

[blumi40 222]

SELECT TABLES  

should show u all the Tables of your Database. If this dont work  check your MySQL User and your Connection