Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Cannot connect to front end. Returns a completely blank page. SQL error "Column not found" #308

Open
unalignedcoder opened this issue Feb 21, 2023 · 3 comments
Open

Cannot connect to front end. Returns a completely blank page. SQL error "Column not found" #308

unalignedcoder opened this issue Feb 21, 2023 · 3 comments
Labels
bug

Comments

@unalignedcoder
Copy link

unalignedcoder commented Feb 21, 2023 •
edited
Loading

Installation and table creation seem to have been completely correctly, but, when visiting the Agendav front-end address, it returns a blank page.

There are no errors in the log (though, I cannot find Agendav specific logs, if any), ModSecurity is disabled, the correct server root is set in VirtualHost directives, and the page gets a 200 OK response.

Where is the problem?
@unalignedcoder
Copy link
Author

I have found agendav logs, and here's the error:

[2023-02-21 11:39:13] agendav.ERROR: Uncaught Exception Doctrine\DBAL\Driver\PDO\Exception: "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sess_lifetime' in 'field list'" at /public_html/web/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php line 18 {"exception":"[object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sess_lifetime' in 'field list' at /public_html/web/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sess_lifetime' in 'field list' at /public_html/web/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117)"} []

It seems the tables were not created correctly?

@unalignedcoder unalignedcoder changed the title Cannot connect to front end. Returns a completely blank page. Cannot connect to front end. Returns a completely blank page. SQL error "Column not found" Feb 21, 2023
@unalignedcoder
Copy link
Author

It seems to be complaining about the sess_lifetime column, which is nowhere to be found in the structure:

image

@neilromig
Copy link

This happened to me (Arch linux, Agendav 2.6.0), as a quick fix I just added sess_lifetime as an INT column to the sessions table. Seems to work (so far).

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@pixelbrackets @neilromig @unalignedcoder