i upgraded to the latest version but keep getting 500 errors running php 7.4 iis 7
the update process worked normally when i clicked on take me to the new installation i get the 500 errors.
i went back to the previous version with the newly upgraded database. is that ok?
it's a little confused , on the footer it shows version 3.11 but when adding a faq etc it shows 3.0.12
not sure what I am missing, done this upgrade many times before and no issues. the folders have the correct user permissions for iis
any help much appreciated.
Thorsten
upgrade to 311
Moderator: Thorsten
Re: upgrade to 311
Hi,
did you try to enable the DEBUG mode when running the 3.1.1 release to see the 500s?
bye
Thorsten
did you try to enable the DEBUG mode when running the 3.1.1 release to see the 500s?
bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
amazon.de Wishlist
Re: upgrade to 311
i did not enable debug. will do that tomorrow and retest
a co-worker of mine and i installed phpmyfaq on windows 2019 and 2016 server we got everything to work except the moment we go to php 8.1 ldap breaks
it works fine up to and incl. version 8.0 will check with debug mode when going to the latest
Danke schoen
Thorsten
a co-worker of mine and i installed phpmyfaq on windows 2019 and 2016 server we got everything to work except the moment we go to php 8.1 ldap breaks
it works fine up to and incl. version 8.0 will check with debug mode when going to the latest
Danke schoen
Thorsten
Re: upgrade to 311
this is what my co-worker found being on php 8.1 and latest phpmyfaq with ldap enabled and trying to login with domain account
phpMyFAQ Fatal error (Running PHP 8.1, PHPMyFAQ 3.1.1, will not even go past this screen in debug mode)
Uncaught exception: 'ErrorException'
Message: 'strtoupper(): Passing null to parameter #1 ($string) of type string is deprecated'
Stack trace:
#0 [internal function]: phpMyFAQ\Core\Error::errorHandler(8192, 'strtoupper(): P...', 'D:\\wwwroot\\Npir...', 270)
#1 D:\wwwroot\NpirsPortal\knowledgedev\src\phpMyFAQ\Language.php(270): strtoupper(NULL)
#2 D:\wwwroot\NpirsPortal\knowledgedev\index.php(276): phpMyFAQ\Language::isASupportedLanguage(NULL)
#3 {main}
Thrown in 'D:\wwwroot\NpirsPortal\knowledgedev\src\phpMyFAQ\Language.php' on line 270
phpMyFAQ debug info (Running PHP 8.1, PHPMyFAQ 3.0.12, gives Wrong login name or password. But at least loads the login screen)
phpMyFAQ deprecated warning [8192]: Constant FILTER_SANITIZE_STRING is deprecated in D:\wwwroot\NpirsPortal\knowledgedev\src\phpMyFAQ\Language.php on line 142
phpMyFAQ deprecated warning [8192]: Constant FILTER_SANITIZE_STRING is deprecated in D:\wwwroot\NpirsPortal\knowledgedev\src\phpMyFAQ\Language.php on line 147
phpMyFAQ deprecated warning [8192]: Constant FILTER_SANITIZE_STRING is deprecated in D:\wwwroot\NpirsPortal\knowledgedev\src\phpMyFAQ\Language.php on line 152
phpMyFAQ deprecated warning [8192]: Constant FILTER_SANITIZE_STRING is deprecated in D:\wwwroot\NpirsPortal\knowledgedev\admin\index.php on line 112
phpMyFAQ deprecated warning [8192]: Constant FILTER_SANITIZE_STRING is deprecated in D:\wwwroot\NpirsPortal\knowledgedev\admin\index.php on line 114
phpMyFAQ deprecated warning [8192]: Constant FILTER_SANITIZE_STRING is deprecated in D:\wwwroot\NpirsPortal\knowledgedev\admin\index.php on line 120
phpMyFAQ deprecated warning [8192]: Constant FILTER_SANITIZE_STRING is deprecated in D:\wwwroot\NpirsPortal\knowledgedev\admin\index.php on line 130
phpMyFAQ deprecated warning [8192]: Constant FILTER_SANITIZE_STRING is deprecated in D:\wwwroot\NpirsPortal\knowledgedev\admin\index.php on line 138
phpMyFAQ deprecated warning [8192]: Constant FILTER_SANITIZE_STRING is deprecated in D:\wwwroot\NpirsPortal\knowledgedev\admin\index.php on line 139
phpMyFAQ deprecated warning [8192]: Constant FILTER_SANITIZE_STRING is deprecated in D:\wwwroot\NpirsPortal\knowledgedev\admin\index.php on line 140
phpMyFAQ deprecated warning [8192]: Constant FILTER_SANITIZE_STRING is deprecated in D:\wwwroot\NpirsPortal\knowledgedev\admin\index.php on line 220
phpMyFAQ deprecated warning [8192]: Constant FILTER_SANITIZE_STRING is deprecated in D:\wwwroot\NpirsPortal\knowledgedev\admin\index.php on line 222
DEBUG INFORMATION:
D:\wwwroot\NpirsPortal\knowledgedev\src\Bootstrap.php:
phpMyFAQ\Configuration->getAll() in line 140: SELECT config_name, config_value FROM faqconfig
D:\wwwroot\NpirsPortal\knowledgedev\src\phpMyFAQ\User\CurrentUser.php:
phpMyFAQ\User->getUserByLogin() in line 151: SELECT user_id, login, account_status FROM faquser WHERE login = 'd1\\xxxxx'
D:\wwwroot\NpirsPortal\knowledgedev\src\phpMyFAQ\User\CurrentUser.php:
phpMyFAQ\User\CurrentUser->isFailedLastLoginAttempt() in line 152: SELECT session_timestamp, ip, success, login_attempts FROM faquser WHERE user_id = -1 AND ('1645059080' - session_timestamp) <= 600 AND ip = '10.155.107.33' AND success = 0 AND login_attempts > 5
D:\wwwroot\NpirsPortal\knowledgedev\src\phpMyFAQ\User\CurrentUser.php:
phpMyFAQ\Auth\AuthDatabase->checkLogin() in line 199: SELECT login FROM faquserlogin WHERE login = 'xxxxxx'
D:\wwwroot\NpirsPortal\knowledgedev\src\phpMyFAQ\User\CurrentUser.php:
phpMyFAQ\User\CurrentUser->setSuccess() in line 255: UPDATE faquser SET success = 0, login_attempts = 0 WHERE user_id = -1
D:\wwwroot\NpirsPortal\knowledgedev\src\phpMyFAQ\Logging.php:
phpMyFAQ\Database\Mysqli->nextId() in line 114: SELECT MAX(id) AS current_id FROM faqadminlog
D:\wwwroot\NpirsPortal\knowledgedev\src\phpMyFAQ\Logging.php:
phpMyFAQ\User\UserData->get() in line 116: SELECT user_id FROM faquserdata WHERE user_id = 0
D:\wwwroot\NpirsPortal\knowledgedev\admin\index.php:
phpMyFAQ\Logging->logAdmin() in line 176: INSERT INTO faqadminlog (id, time, usr, text, ip) VALUES (1, 1645059080, 0, 'Loginerror\\nLogin: d1\\xxxxxx\\nErrors: Specified login could not be found. , Specified login could not be found. ', '10.155.107.33')
D:\wwwroot\NpirsPortal\knowledgedev\src\phpMyFAQ\Helper\AdministrationHelper.php:
phpMyFAQ\Permission\BasicPermission->getAllRightsData() in line 131: SELECT right_id, name, description, for_users, for_groups, for_sections FROM faqright ORDER BY right_id ASC
D:\wwwroot\NpirsPortal\knowledgedev\src\phpMyFAQ\Permission\BasicPermission.php:
phpMyFAQ\Permission\BasicPermission->getUserRights() in line 248: SELECT fr.right_id AS right_id FROM faqright fr, faquser_right fur, faquser fu WHERE fr.right_id = fur.right_id AND fu.user_id = -1 AND fu.user_id = fur.user_id
D:\wwwroot\NpirsPortal\knowledgedev\src\phpMyFAQ\Permission\BasicPermission.php:
phpMyFAQ\Permission\BasicPermission->getUserRights() in line 248: SELECT fr.right_id AS right_id FROM faqright fr, faquser_right fur, faquser fu WHERE fr.right_id = fur.right_id AND fu.user_id = -1 AND fu.user_id = fur.user_id
Danke
Thorsten
phpMyFAQ Fatal error (Running PHP 8.1, PHPMyFAQ 3.1.1, will not even go past this screen in debug mode)
Uncaught exception: 'ErrorException'
Message: 'strtoupper(): Passing null to parameter #1 ($string) of type string is deprecated'
Stack trace:
#0 [internal function]: phpMyFAQ\Core\Error::errorHandler(8192, 'strtoupper(): P...', 'D:\\wwwroot\\Npir...', 270)
#1 D:\wwwroot\NpirsPortal\knowledgedev\src\phpMyFAQ\Language.php(270): strtoupper(NULL)
#2 D:\wwwroot\NpirsPortal\knowledgedev\index.php(276): phpMyFAQ\Language::isASupportedLanguage(NULL)
#3 {main}
Thrown in 'D:\wwwroot\NpirsPortal\knowledgedev\src\phpMyFAQ\Language.php' on line 270
phpMyFAQ debug info (Running PHP 8.1, PHPMyFAQ 3.0.12, gives Wrong login name or password. But at least loads the login screen)
phpMyFAQ deprecated warning [8192]: Constant FILTER_SANITIZE_STRING is deprecated in D:\wwwroot\NpirsPortal\knowledgedev\src\phpMyFAQ\Language.php on line 142
phpMyFAQ deprecated warning [8192]: Constant FILTER_SANITIZE_STRING is deprecated in D:\wwwroot\NpirsPortal\knowledgedev\src\phpMyFAQ\Language.php on line 147
phpMyFAQ deprecated warning [8192]: Constant FILTER_SANITIZE_STRING is deprecated in D:\wwwroot\NpirsPortal\knowledgedev\src\phpMyFAQ\Language.php on line 152
phpMyFAQ deprecated warning [8192]: Constant FILTER_SANITIZE_STRING is deprecated in D:\wwwroot\NpirsPortal\knowledgedev\admin\index.php on line 112
phpMyFAQ deprecated warning [8192]: Constant FILTER_SANITIZE_STRING is deprecated in D:\wwwroot\NpirsPortal\knowledgedev\admin\index.php on line 114
phpMyFAQ deprecated warning [8192]: Constant FILTER_SANITIZE_STRING is deprecated in D:\wwwroot\NpirsPortal\knowledgedev\admin\index.php on line 120
phpMyFAQ deprecated warning [8192]: Constant FILTER_SANITIZE_STRING is deprecated in D:\wwwroot\NpirsPortal\knowledgedev\admin\index.php on line 130
phpMyFAQ deprecated warning [8192]: Constant FILTER_SANITIZE_STRING is deprecated in D:\wwwroot\NpirsPortal\knowledgedev\admin\index.php on line 138
phpMyFAQ deprecated warning [8192]: Constant FILTER_SANITIZE_STRING is deprecated in D:\wwwroot\NpirsPortal\knowledgedev\admin\index.php on line 139
phpMyFAQ deprecated warning [8192]: Constant FILTER_SANITIZE_STRING is deprecated in D:\wwwroot\NpirsPortal\knowledgedev\admin\index.php on line 140
phpMyFAQ deprecated warning [8192]: Constant FILTER_SANITIZE_STRING is deprecated in D:\wwwroot\NpirsPortal\knowledgedev\admin\index.php on line 220
phpMyFAQ deprecated warning [8192]: Constant FILTER_SANITIZE_STRING is deprecated in D:\wwwroot\NpirsPortal\knowledgedev\admin\index.php on line 222
DEBUG INFORMATION:
D:\wwwroot\NpirsPortal\knowledgedev\src\Bootstrap.php:
phpMyFAQ\Configuration->getAll() in line 140: SELECT config_name, config_value FROM faqconfig
D:\wwwroot\NpirsPortal\knowledgedev\src\phpMyFAQ\User\CurrentUser.php:
phpMyFAQ\User->getUserByLogin() in line 151: SELECT user_id, login, account_status FROM faquser WHERE login = 'd1\\xxxxx'
D:\wwwroot\NpirsPortal\knowledgedev\src\phpMyFAQ\User\CurrentUser.php:
phpMyFAQ\User\CurrentUser->isFailedLastLoginAttempt() in line 152: SELECT session_timestamp, ip, success, login_attempts FROM faquser WHERE user_id = -1 AND ('1645059080' - session_timestamp) <= 600 AND ip = '10.155.107.33' AND success = 0 AND login_attempts > 5
D:\wwwroot\NpirsPortal\knowledgedev\src\phpMyFAQ\User\CurrentUser.php:
phpMyFAQ\Auth\AuthDatabase->checkLogin() in line 199: SELECT login FROM faquserlogin WHERE login = 'xxxxxx'
D:\wwwroot\NpirsPortal\knowledgedev\src\phpMyFAQ\User\CurrentUser.php:
phpMyFAQ\User\CurrentUser->setSuccess() in line 255: UPDATE faquser SET success = 0, login_attempts = 0 WHERE user_id = -1
D:\wwwroot\NpirsPortal\knowledgedev\src\phpMyFAQ\Logging.php:
phpMyFAQ\Database\Mysqli->nextId() in line 114: SELECT MAX(id) AS current_id FROM faqadminlog
D:\wwwroot\NpirsPortal\knowledgedev\src\phpMyFAQ\Logging.php:
phpMyFAQ\User\UserData->get() in line 116: SELECT user_id FROM faquserdata WHERE user_id = 0
D:\wwwroot\NpirsPortal\knowledgedev\admin\index.php:
phpMyFAQ\Logging->logAdmin() in line 176: INSERT INTO faqadminlog (id, time, usr, text, ip) VALUES (1, 1645059080, 0, 'Loginerror\\nLogin: d1\\xxxxxx\\nErrors: Specified login could not be found. , Specified login could not be found. ', '10.155.107.33')
D:\wwwroot\NpirsPortal\knowledgedev\src\phpMyFAQ\Helper\AdministrationHelper.php:
phpMyFAQ\Permission\BasicPermission->getAllRightsData() in line 131: SELECT right_id, name, description, for_users, for_groups, for_sections FROM faqright ORDER BY right_id ASC
D:\wwwroot\NpirsPortal\knowledgedev\src\phpMyFAQ\Permission\BasicPermission.php:
phpMyFAQ\Permission\BasicPermission->getUserRights() in line 248: SELECT fr.right_id AS right_id FROM faqright fr, faquser_right fur, faquser fu WHERE fr.right_id = fur.right_id AND fu.user_id = -1 AND fu.user_id = fur.user_id
D:\wwwroot\NpirsPortal\knowledgedev\src\phpMyFAQ\Permission\BasicPermission.php:
phpMyFAQ\Permission\BasicPermission->getUserRights() in line 248: SELECT fr.right_id AS right_id FROM faqright fr, faquser_right fur, faquser fu WHERE fr.right_id = fur.right_id AND fu.user_id = -1 AND fu.user_id = fur.user_id
Danke
Thorsten
Re: upgrade to 311
Hi,
this fix should handle the fatal error: https://github.com/thorsten/phpMyFAQ/co ... 8a032f54e2
The deprecation errors when running PHP 8.1 will be fixed with the next releases, they will break in PHP 9, so we have some time.
bye
Thorsten
this fix should handle the fatal error: https://github.com/thorsten/phpMyFAQ/co ... 8a032f54e2
The deprecation errors when running PHP 8.1 will be fixed with the next releases, they will break in PHP 9, so we have some time.
bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
amazon.de Wishlist