Cannot create user with SQLite

[marienfressinaud]

I try to create a second user for my tests but I can't with SQLite on a fresh install.

I think the problem comes from we try to create new tables on the SQLite file of current user. Since we don't use prefix, tables already exist!

[marienfressinaud]

Moreover, I don't really like the code we use in FreshRSS_UserDAO::createUser(): it is the same as in install.php but the condition if (defined('SQL_CREATE_TABLES')) { ... } else { ... } is quite non-understable at the first glance…

[Alkarex]

Every user is supposed to have its own .sqlite file.
This is probably a file creation problem or something similar

[Alkarex]

Patch d477373
Pas encore trop testé. Il faudra vérifier MySQL aussi, et install.php #575

[Alkarex]

Should be good now, but we have to double-check MySQL and install.php as part of #575

[marienfressinaud]

It still not works :( I have an error and logs show:

[Sat Aug 09 20:00:47 2014] [error] [client 172.17.42.1] PHP Notice:  Undefined variable: ok in /var/www/html/app/Models/UserDAO.php on line 24, referer: http://localhost/p/i/?c=configure&a=users
[Sat Aug 09 20:00:47 2014] [error] [client 172.17.42.1] PHP Notice:  Undefined variable: stm in /var/www/html/app/Models/UserDAO.php on line 27, referer: http://localhost/p/i/?c=configure&a=users

Edit: and in FRSS logs: SQL error : syntax error

[marienfressinaud]

Oops, sorry, I have updated FRSS on my server and tried on my computer >< It works now!

[Alkarex]

You probably have an old version of UserDAO.php

[Alkarex]

Ok :-)