Praney Behl 314 Posted April 21, 2013 Report Share Posted April 21, 2013 For some reason I am not able to use the plugin. When I try to create a database it errors out "Access to the path "C:\data.sqlite" is denied."What's going on? Praney Quote Link to post Share on other sites
Praney Behl 314 Posted April 21, 2013 Report Share Posted April 21, 2013 Oh I am on Win8 Pro 64 bit.Just thought to mention it as if might be related to Win8 somehow. Quote Link to post Share on other sites
beatngu 65 Posted April 21, 2013 Report Share Posted April 21, 2013 Sounds like a windows restriction problem.Im also using Win8 Pro 64 without any problem,have you tried to use save to special folder? Quote Link to post Share on other sites
Aymen 385 Posted April 21, 2013 Author Report Share Posted April 21, 2013 For some reason I am not able to use the plugin. When I try to create a database it errors out "Access to the path "C:\data.sqlite" is denied." What's going on? Praneythat error is usually related to hard drive permission not set properly !Try to save the database file to another hard drive or another place ! Quote Link to post Share on other sites
Josh 37 Posted April 22, 2013 Report Share Posted April 22, 2013 I think I found a bug in the latest release. The get data command no longer works with variables as the database path. I tested this without a variable as the database path and it works. This worked in previous versions of the plugin. This is my ubot code.... plugin command("SQLlite.dll", "SQLite Get Data", #domain name, "select * from pages where profile_name=\"{#pages profile}\";", &pages data table) Quote Link to post Share on other sites
Aymen 385 Posted April 22, 2013 Author Report Share Posted April 22, 2013 I think I found a bug in the latest release. The get data command no longer works with variables as the database path. I tested this without a variable as the database path and it works. This worked in previous versions of the plugin. This is my ubot code.... plugin command("SQLlite.dll", "SQLite Get Data", #domain name, "select * from pages where profile_name=\"{#pages profile}\";", &pages data table) Your code have few mistakes , SQL syntax should not end with ( ; )Video : http://screencast.com/t/OSDu9P5fdz Quote Link to post Share on other sites
Josh 37 Posted April 22, 2013 Report Share Posted April 22, 2013 Ok well that syntax actually worked without the variables. Thanks though. Much appreciated. Sorry for the trouble. Quote Link to post Share on other sites
Aymen 385 Posted April 22, 2013 Author Report Share Posted April 22, 2013 Ok well that syntax actually worked without the variables. Thanks though. Much appreciated. Sorry for the trouble. No problem ! Quote Link to post Share on other sites
kev123 132 Posted May 8, 2013 Report Share Posted May 8, 2013 I've got and idea for a addition, like the grid popup but graphic so you can chart data from the database Quote Link to post Share on other sites
Praney Behl 314 Posted May 9, 2013 Report Share Posted May 9, 2013 Yeah that will be good Quote Link to post Share on other sites
Aymen 385 Posted May 9, 2013 Author Report Share Posted May 9, 2013 I've got and idea for a addition, like the grid popup but graphic so you can chart data from the database thats planned !i'll add it soon ! Quote Link to post Share on other sites
Praney Behl 314 Posted May 19, 2013 Report Share Posted May 19, 2013 Hey Ayen, How are the updates for your plugins delivered? Praney Quote Link to post Share on other sites
Aymen 385 Posted May 19, 2013 Author Report Share Posted May 19, 2013 Hey Ayen, How are the updates for your plugins delivered? Praney Via Email , if you did not get updates send me a PM and i'll send you the latest version ! Quote Link to post Share on other sites
Aymen 385 Posted May 24, 2013 Author Report Share Posted May 24, 2013 Limited time promotion 50% offcoupon code : MAYUBOT2013expires in 2013-05-31 Quote Link to post Share on other sites
beer BOTtle 0 Posted May 30, 2013 Report Share Posted May 30, 2013 The compiled bots don't work on pc (WIN 7 32bit) with Microsoft .NET Framework 4 Extended (4.0.30319), .NET Client Profil (4.0.30319) the filesSystem.Data.SQLite.dllSystem.Data.SQLite.Linq.dllare in the same directory like the bot.exe. No error messages, but the database functions don't work. What should I do? Quote Link to post Share on other sites
Aymen 385 Posted May 30, 2013 Author Report Share Posted May 30, 2013 The compiled bots don't work on pc (WIN 7 32bit) with Microsoft .NET Framework 4 Extended (4.0.30319), .NET Client Profil (4.0.30319) the filesSystem.Data.SQLite.dllSystem.Data.SQLite.Linq.dllare in the same directory like the bot.exe. No error messages, but the database functions don't work. What should I do? make sure you used the 32bits dllsif that still doesn't work , install the sqlite application the same you did in your developpement PC and that will solve the issue ! Let me know your result Quote Link to post Share on other sites
beer BOTtle 0 Posted May 30, 2013 Report Share Posted May 30, 2013 The client installshttp://system.data.sqlite.org/downloads/1.0.84.0/sqlite-netFx40-setup-bundle-x86-2010-1.0.84.0.exe but the bot (your database functions) don't work.I used WIN 7 64bit for the development of the bot. Quote Link to post Share on other sites
Aymen 385 Posted May 30, 2013 Author Report Share Posted May 30, 2013 The client installshttp://system.data.sqlite.org/downloads/1.0.84.0/sqlite-netFx40-setup-bundle-x86-2010-1.0.84.0.exe but the bot (your database functions) don't work.I used WIN 7 64bit for the development of the bot. did you install the dlls in the GAC cache ?if you don't check a checkbox on the installation that won't work ! make sure to follow the video i recorded for this !pm me on skype please ! Quote Link to post Share on other sites
beer BOTtle 0 Posted May 30, 2013 Report Share Posted May 30, 2013 did you install the dlls in the GAC cache ?if you don't check a checkbox on the installation that won't work ! make sure to follow the video i recorded for this !pm me on skype please !No, he forgot the checkbox. Now it works In the future, I need a 64bit and 32bit version for my customers? 64 bit - System.Data.SQLite.dllSystem.Data.SQLite.Linq.dllor32 bit - System.Data.SQLite.dllSystem.Data.SQLite.Linq.dll This sucks! In the videos you don't show that the customers (.exe + dlls) have to install anything. Quote Link to post Share on other sites
Aymen 385 Posted May 30, 2013 Author Report Share Posted May 30, 2013 No, he forgot the checkbox. Now it works In the future, I need a 64bit and 32bit version for my customers? 64 bit - System.Data.SQLite.dllSystem.Data.SQLite.Linq.dllor32 bit - System.Data.SQLite.dllSystem.Data.SQLite.Linq.dll This sucks! In the videos you don't show that the customers (.exe + dlls) have to install anything. cool !yea you need 2 versions , one version for 64 bits and one version for 32 bitsi have a small code that downloads the files for you so you don't have to package the dlls with the bot , you just place the dlls in your server and the bot takes care of the rest !let me know if you want it ! Quote Link to post Share on other sites
kev123 132 Posted May 30, 2013 Report Share Posted May 30, 2013 did you install the dlls in the GAC cache ?if you don't check a checkbox on the installation that won't work ! make sure to follow the video i recorded for this !pm me on skype please !i'm a bit confused on a bot i'm about to sell i thought we just had to supply the dll files either 64bits or 32bits in the same folder as the exe and that was it. Quote Link to post Share on other sites
Aymen 385 Posted May 30, 2013 Author Report Share Posted May 30, 2013 i'm a bit confused on a bot i'm about to sell i thought we just had to supply the dll files either 64bits or 32bits in the same folder as the exe and that was it. yea that should work !its really rare that it doesn't work on some computers! Quote Link to post Share on other sites
Praney Behl 314 Posted June 18, 2013 Report Share Posted June 18, 2013 Any updated or new features on this plugin? Quote Link to post Share on other sites
Aymen 385 Posted June 18, 2013 Author Report Share Posted June 18, 2013 Any updated or new features on this plugin? not updates for now , but possibly will add a chart window command soon ! if you guys have suggestions , let me know Quote Link to post Share on other sites
Aymen 385 Posted June 19, 2013 Author Report Share Posted June 19, 2013 Affiliate Program is open : http://ubot-plugins.com/affiliate-program/ 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.