Open mrenbe opened 3 years ago
Connect to your docker instance and get us the contents of storage/logs/laravel.log
I think it lives in /var/www/html
if memory serves (and it likely does not)
Connect to your docker instance and get us the contents of
storage/logs/laravel.log
[2021-01-07 16:34:12] production.ERROR: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ad_append_domain' in 'field list' in /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:64 Stack trace:
Next Doctrine\DBAL\Driver\PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ad_append_domain' in 'field list' in /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:66 Stack trace:
Stack trace:
[stacktrace]
[previous exception] [object] (Doctrine\DBAL\Driver\PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ad_append_domain' in 'field list' at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:66) [stacktrace]
[previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ad_append_domain' in 'field list' at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:64) [stacktrace]
"}
Fresh install on Debian and without Docker and it is the same issue
The error sounds like db migration error:[previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ad_append_domain' in 'field list' at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:64) [stacktrace]
It fits with issue 8657, maybe the solution there will help you
I am getting the same error when trying to save any new settings on the LDAP screen and am also on PHP 7.4. When I try to update settings and click save it just shows a "500 | Server Error" with no additional text. So now my LDAP is broken until I can update the settings. Is there any way to update the LDAP password via cmdline instead of the web browser? I've look at the database and it is base64 encoded and then encoded again using some arbitrary data fields so I couldn't update the password directly in the database. Snipe-IT Version 5.1.5 OS: Ubuntu 20.04.2 Web Server: Apache2 2.4.41 PHP Version 7.4.3
Apparently a PHP 7.4 issue as commented here. https://github.com/snipe/snipe-it/issues/9554#issuecomment-844846728
checked the logs and it showed Unknown column 'ldap_phone_field' in 'field list' Fixed it by running "php artisan migrate" to create the missing columns in the mysql database.
"Unknown Colun ad_append_domain" means that you haven't run migrations. Run migrations and this problem should go away, which is exactly what @djlongy said - they're right.
Can you folks give that a try, and let me know if you're still having problems?
Please confirm you have done the following before posting your bug report:
Describe the bug A clear and concise description of what the bug is. LDAP is not working. If I try to change in the LDAP settings page when I save I got an 500 Internal Error
I got the same behaviour when edition general settings when I click save I got 500 Internal Error
To Reproduce
Steps to reproduce the behavior:
Please advise
Expected behavior A clear and concise description of what you expected to happen.
Screenshots If applicable, add screenshots to help explain your problem.
Server (please complete the following information):
Error Messages
Additional context