Created on 2014-01-14.09:38:19 by vezjakv, last changed 96 months ago by ced.
New changeset b544598a1eaa by C?dric Krier in branch '3.0': Use raw SQL string to test database http://hg.tryton.org/trytond/rev/b544598a1eaa
Proposed patch solved the problem for me.
Indeed it was fixed in trunk with changeset 610cf1f6c946 but we can not backport this patch because of API changes. So here is a patch that re-use the old raw SQL string for 3.0
I executed more code and it fails in the test query, concrectly in . I get the following traceback: Traceback (most recent call last): File "C:\Program Files\neso-3.0.0\neso.py", line 150, in <module> cursor2.execute(sql, params) File "trytond\trytond\backend\sqlite\database.pyc", line 342, in execute OperationalError: near "%": syntax error Which is quite strange for me. I also printed the generated query and params, which lead to: ('SELECT "a"."name" FROM "sqlite_master" AS "a" WHERE (("a"."type" = %s) AND ("a"."name" IN (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s)))', ('table', 'ir_model', 'ir_model_field', 'ir_ui_view', 'ir_ui_menu', 'res_user', 'res_group', 'ir_module_module', 'ir_module_module_dependency', 'ir_translation', 'ir_lang')) Let me know if more inputs are needed.  http://hg.tryton.org/trytond/file/cb04e75618bf/trytond/backend/sqlite/database.py#l382
Just to confirm this issue only affects windows, as I can reproduce it on a Windows VM machine, but not on my linux box. Just installed a python shell on the Windows VM machine and I tried list dirs of the folder and they are correctly listed, so the problem may be opening the cursor to the database. I also installed sqlite-cli on the windows machine and I can access the database without problems. Any tips about how to run neso from sources on windows, or how to create neso.exe (as Oscar already pointed) will be great to solve the issue.
Same issue here, reproduced on Win 7 Pro 32 as well as on Windows XP Pro 32.
I am testing on Windows 8 Enterprise 64-Bit.
To exist any way for to create neso.exe, from neso.py for test/hack in my pc, using print another changes maybe I help, but I don't know how create neso.exe correctly.
I tested on Windows 7 ultimate, 32 bits, Virtualbox
I've tested on Windows 7 Enterprise SP1, build 7601, x64.
It will be strange to be allowed to create a file but not read it back. Any way, everyone having this issue, could you provide the version of each OS where this happens?
I have de same problem in windows7, maybe it is a problem of permissions on file c:\users\<username>\.neso\3.0\demo.sqlite.
I can also produce the scenario as dominik described. But after closing neso client, the symptoms are back again.
Having the same problem here. But if I create a new databasem,connect to the new database and then select in the menu to connect to another databse, then the neso client then finds the old database.
yes, it is there: c:\users\<username>\.neso\3.0\demo.sqlite. Similarly, I've installed Windows tryton client and trytond server on Linux w/ sqlite as backend. Funny thing is that when adding connection profile, it cannot list sqlite databases on the server, just Create Database. But I can connect to the sqlite database if I enter server:port and database name directly.
I can not reproduce it. Could you verify if the sqlite database are correctly created in $HOME/.neso/3.0/<name>.sqlite ?
After initial start and new database created, it works normal in current session. But after closing neso, and starting again there is no database list, always 'Create database' button. There is no option to connect to existing database.
|2014-03-04 23:10:41||ced||set||status: testing -> resolved|
messages: + msg15858
|2014-03-02 22:33:16||pokoli||set||messages: + msg15824|
|2014-03-02 22:15:42||ced||set||component: + trytond, - neso|
|2014-03-02 22:15:17||ced||set||status: chatting -> testing|
messages: + msg15823
keyword: + review
|2014-03-02 21:21:32||pokoli||set||messages: + msg15822|
|2014-03-02 20:05:22||pokoli||set||status: need-eg -> chatting|
messages: + msg15821
|2014-03-02 19:09:44||pokoli||set||nosy: + pokoli|
messages: + msg15592
|2014-01-29 11:15:14||dominik||set||messages: + msg15377|
Showing 10 items. Show all history (warning: this could be VERY long)