Database Error - no such table: sessions about chyrp-lite HOT 7 CLOSED

I know you stated you've tried with the develop branch, but can you open the file /includes/class/SQL.php and verify this line of code is specifying PDO::ATTR_PERSISTENT => false (the actual line number might be slightly different depending on whether you are in sync with recent commits).

I've been testing SQLite compatibility recently and I discovered that this persistent mode causes errors whenever the schema is modified by a query.

from chyrp-lite.

I deleted all testing instances afterwards, but now I'm now running 3b136e9, in which I can still reproduce the problem. PDO::ATTR_PERSISTENT => false is there.

I forgot to mention that all tests were done using SQLite.

from chyrp-lite.

That's an odd one. Clearly the error is being misreported because if the sessions table didn't exist the problem would occur consistently. My hunch is that this error is the result of some other intermittent connection problem PDO is having. Difficult to diagnose unless I can reproduce it. What version of PHP are you using?

from chyrp-lite.

PHP 5.6.17-3
pdo_sqlite 3.10.2
from the Debian stretch repos.

I will see how it goes using MySQL and let you know.

Edit: nothing, couldn't reproduce with MySQL.

from chyrp-lite.

Thanks for testing. I'll dedicate some more time to poking SQLite before the next release. Perhaps I can reproduce the problem.

from chyrp-lite.

I think it has to do with the DB path. I ignored the "full path" message and provided only the name because I saw that the DB was created in the root of my project anyway.

Now, if I do pass the full (writable) path, this error is gone.

It seems that 2 different locations are being referenced as the DB path. The right one, which exists and feeds most of the page, and the broken one causing the error. From what I read, SQLite creates a missing database file silently, which would explain the no such table: sessions message.

from chyrp-lite.

That's great news. I'm glad to have the mystery solved. ^_^

from chyrp-lite.