Sqlite In 5.9.33 Issue

[drewness 26]

Hi there,

 

I'm wrote my bot in the latest version of Ubot, but the GUI button issue (mentioned here http://network.ubotstudio.com/forum/index.php/topic/20149-odd-little-ui-problem-anyone-else-had-or-got-this/) drives me nuts, so I decided to use 5.9.33 to compile. This fixes the UI issue, but when the bot source loads in Ubot I get this error:

 

 

Keyword not supported. Parameter name: sqlite:data source

 

 

The SQLite setup works perfectly in the newest version of Ubot, but doesn't seem to work in .33 - I compiled it anyways and it doesn't work with the database.

 

I tried recreating the connection string in the connection wizard, but there's no option for SQLite, so I'm stumped.

 

Is there a fix for this, or am I left having to pick between a broken database connection or the annoying GUI quirk?

 

Thanks for your time!

[HelloInsomnia 1103]

I think most are using this for SQLite: http://network.ubotstudio.com/forum/index.php/topic/12960-sell-sqlite-database-plugin/

[drewness 26]

Thank you for the reply. I love and own about half of Aymen's plugins, but what are the benefits of it over the built-in SQLite features of the newer Ubot version that supports SQLite? Is the only reason to purchase the fact that the developers don't seem to want to fix the GUI issue, which is the only real issue I have?

[HelloInsomnia 1103]

but what are the benefits of it over the built-in SQLite features of the newer Ubot version that supports SQLite?

 

First time I've heard of this so I can't say, what commands are you talking about?

[drewness 26]

Pretty standard stuff. The following is fine in newest version but throws an error in .33 (see screenshot attached)

 

plugin command("DatabaseCommands.dll", "connect to database", "sqlite:Data Source=file://{#installedFolder}\\wpdatabase.db")

[HelloInsomnia 1103]

I don't think that command has ever worked with SQLite I think that is strictly for MySQL stuff. They may have updated it and perhaps you have another version but I have 1.1.0.0 and I think that versions been around for a couple of years now so its possible I have an outdated version..

[drewness 26]

Hmm yeah it definitely works natively with SQLite, the screenshot in the OP on this thread http://network.ubotstudio.com/forum/index.php/topic/19205-sqlite-error/is what I see on the newer version of ubot, but not on the .33 release. Looks like I'll need to buy Aymen's plugin to get the best of both worlds.

 

Thanks for pointing me in the right direction

[HelloInsomnia 1103]

Hmm yeah it definitely works natively with SQLite, the screenshot in the OP on this thread http://network.ubotstudio.com/forum/index.php/topic/19205-sqlite-error/is what I see on the newer version of ubot, but not on the .33 release. Looks like I'll need to buy Aymen's plugin to get the best of both worlds.

 

Thanks for pointing me in the right direction

 

I can see that's an updated version from what I have so I can see what you mean now I'll have to try and find that version. I saw there is another plugin which is free that does SQLite stuff as well: http://network.ubotstudio.com/forum/index.php/topic/20002-free-heopas-custom-plugin-thread-lock-sqlite-thread-variables-email-ini-clipboard/

[drewness 26]

Cool thanks I'll check it out! I really appreciate you taking time to help me out, much appreciated!