Table sessions missing

Installation Issues
1

Hi

I installed kanboard, but when I try to acces the application, I get this message:

“Internal Error: SQL Error: SQLSTATE[HY000]: General error: 1 no such table: sessions”

It the standard installation, with SQLite database and there is a “db.sqlite” file in the “data” subdirectory.

Thank you for your help!

2

check your data/ directory permissions (it should be writable by the webserver)
Remove the db.sqlite file and kanboard should recreate it with the correct schema. You have nothing to lose because you were never able to use the application, correct?

3

Thank you for your answer.
I did what you suggested, but I still have the same error :
“Internal Error: SQL Error: SQLSTATE[HY000]: General error: 1 no such table: sessions”

4

Can you list the tables inside the db.sqlite file and send here?
You can use a tool to explore the database, like sqlitebrowser.org, or on command line:

[u@host ~]$ cd /var/www/html/kanboard/data
[u@host data]$ sqlite3 db.sqlite 
SQLite version 3.26.0 2018-12-01 12:34:55
Enter ".help" for usage hints.
sqlite> .table
action_has_params               project_has_roles             
actions                         project_has_users             
column_has_move_restrictions    project_role_has_restrictions 
column_has_restrictions         projects                      
columns                         remember_me                   
comments                        sessions                      
...

You can also enable debug on config.php:

define('DEBUG', true);
define('LOG_DRIVER', 'file');
define('LOG_FILE', DATA_DIR.DIRECTORY_SEPARATOR.'debug.log');

And check the debug.log file on kanboards data/ dir for errors.

  1. Enable debug
  2. Remove db.sqlite file again
  3. Try to log in to the application
  4. Send the debug log messages here, or on a pastebin