Emanu2000 2 Posted March 14, 2016 Report Share Posted March 14, 2016 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.pnghttp://i.imgur.com/SRBnBeJ.png Quote Link to post Share on other sites
Code Docta (Nick C.) 638 Posted March 15, 2016 Report Share Posted March 15, 2016 you are connected the database so the extension must be okyou need to create table firstshow some code like your query. some more details please, so we can help u betterif says plugin? r u using sqlite3 plugin from Aymen? are you using ubot native and aymen's plugin? Code Please,CD Quote Link to post Share on other sites
Emanu2000 2 Posted March 15, 2016 Author Report Share Posted March 15, 2016 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 Quote Link to post Share on other sites
Code Docta (Nick C.) 638 Posted March 15, 2016 Report Share Posted March 15, 2016 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 tutorialhttp://network.ubotstudio.com/forum/index.php/topic/19021-run-sqlite3-in-ubot-59x-temp-fixworkaround/ or buy Aymens sqlite pluginI made a tut for this one too[FREE Example Code] Learn Basic SQLite Queries - Build SQLite DB - Tutorials, Tips and Tricks - UBot UndergroundCD Quote Link to post Share on other sites
Emanu2000 2 Posted March 15, 2016 Author Report Share Posted March 15, 2016 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 tutorialhttp://network.ubotstudio.com/forum/index.php/topic/19021-run-sqlite3-in-ubot-59x-temp-fixworkaround/ or buy Aymens sqlite pluginI made a tut for this one too[FREE Example Code] Learn Basic SQLite Queries - Build SQLite DB - Tutorials, Tips and Tricks - UBot UndergroundCD yes, I can see and do queries on the table usually using another program. Thanks for the tips, I'll see what I do Quote Link to post Share on other sites
iamddr 12 Posted March 16, 2016 Report Share Posted March 16, 2016 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/ 1 Quote Link to post Share on other sites
Bundeskanzler 0 Posted March 17, 2016 Report Share Posted March 17, 2016 Connect and create Sqlite Database http://s27.postimg.org/cbf7p35hd/SQLite.gif Quote Link to post Share on other sites
Emanu2000 2 Posted March 18, 2016 Author Report Share Posted March 18, 2016 Connect and create Sqlite Database http://s27.postimg.org/cbf7p35hd/SQLite.gifMy God, I felt a stupid now ... it was only withdraw "Version = 3". worked now, thank Bundeskanzler .... I'm embarrassed here Quote Link to post Share on other sites
Bundeskanzler 0 Posted March 19, 2016 Report Share Posted March 19, 2016 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? Quote Link to post Share on other sites
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.