Sqlite Error

[Emanu2000 2]

Hi guys, I need help with Sqlite, I'm able to connect to the external file, however when running the query with the result, or just the query, it returns error that can not find my table within the file. is the file that I generated this in the wrong format? I tried to generate 3 extensions: db, sqlite and sqlite 3 and no work. I used the program "DB browser for sqlite," I do not know what to do, I need to use this feature. I hope someone can help me.

 

http://i.imgur.com/sfw6BON.png

http://i.imgur.com/SRBnBeJ.png

 

[Code Docta (Nick C.) 638]

you are connected the database so the extension must be ok

you need to create table first

show some code like your query.

 

some more details please, so we can help u better

if says plugin? r u using sqlite3 plugin from Aymen?

 

are you using ubot native and aymen's plugin?

 

Code Please,

CD
 

[Emanu2000 2]

you are connected the database so the extension must be ok

 

you need to create table first

 

show some code like your query.

 

some more details please, so we can help u better

 

if says plugin? r u using sqlite3 plugin from Aymen?

 

are you using ubot native and aymen's plugin?

 

Code Please,

CD

 

 

I created the database file and the table "userinfo". I am using only the native sqlite resource UBot v5.9.17.

 

the query I'm using is simple: SELECT rodou_compartilhamento FROM userinfo WHERE id = 1

[Code Docta (Nick C.) 638]

Can you see the table like with another program?

 

There is a plugin called Sqlite Manager for firefox. You can see if table was even created.

 

I have never gotten that to work. You prolly need to file a bug in the bug tracker.

 

UBot Studio Tracker

 

You can see this short tutorial

http://network.ubotstudio.com/forum/index.php/topic/19021-run-sqlite3-in-ubot-59x-temp-fixworkaround/

 

or buy Aymens sqlite plugin
I made a tut for this one too

[FREE Example Code] Learn Basic SQLite Queries - Build SQLite DB - Tutorials, Tips and Tricks - UBot Underground

CD

[Emanu2000 2]

Can you see the table like with another program?

 

There is a plugin called Sqlite Manager for firefox. You can see if table was even created.

 

I have never gotten that to work. You prolly need to file a bug in the bug tracker.

 

UBot Studio Tracker

 

You can see this short tutorial

http://network.ubotstudio.com/forum/index.php/topic/19021-run-sqlite3-in-ubot-59x-temp-fixworkaround/

 

or buy Aymens sqlite plugin

I made a tut for this one too

[FREE Example Code] Learn Basic SQLite Queries - Build SQLite DB - Tutorials, Tips and Tricks - UBot Underground

CD

 

yes, I can see and do queries on the table usually using another program.

 

Thanks for the tips, I'll see what I do

[iamddr 12]

If you chose Sqlite to test, the database connection would always be successful even File filed was blank, so I think it's bug. 

Python should be a good alternation, unfortunately there was an import sqlite3 error

Just tested, Nick's method worked. thanks Nick, you are always  quick steps

http://network.ubotstudio.com/forum/index.php/topic/19021-run-sqlite3-in-ubot-59x-temp-fixworkaround/

[Bundeskanzler 0]

Connect and create Sqlite Database     

 

http://s27.postimg.org/cbf7p35hd/SQLite.gif

[Emanu2000 2]

Connect and create Sqlite Database     

 

http://s27.postimg.org/cbf7p35hd/SQLite.gif

My God, I felt a stupid now ... it was only withdraw "Version = 3". worked now, thank Bundeskanzler .... I'm embarrassed here

[Bundeskanzler 0]

You are not stupid.

But I'm stuck with the socket cookies. I have no idea how the function works.   

 

How to save socket cookies and how does one cookies?