upgrade to 311

Please report bugs here!

Moderator: Thorsten

Post Reply
treichelt
Posts: 18
Joined: Fri May 20, 2016 12:14 am

upgrade to 311

Post by treichelt »

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
Thorsten
Posts: 15373
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: upgrade to 311

Post by Thorsten »

Hi,

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
treichelt
Posts: 18
Joined: Fri May 20, 2016 12:14 am

Re: upgrade to 311

Post by treichelt »

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
treichelt
Posts: 18
Joined: Fri May 20, 2016 12:14 am

Re: upgrade to 311

Post by treichelt »

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
Thorsten
Posts: 15373
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: upgrade to 311

Post by Thorsten »

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
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
Post Reply