search

redaxo / redaxo

REDAXO, a PHP-based CMS since 2004. Both simple and flexible.
https://redaxo.org
Other
327 stars 116 forks source link

`rex_user_passkey` wird auch bei reinstall des packages/addons `rex_user` nicht angelegt. #5847

Closed alxndr-w closed 7 months ago

alxndr-w commented 11 months ago

Description / Beschreibung

Did it whoops? / Whoops erhalten?

rex_sql_exception: Error while executing statement "SELECT COUNT(*) AS rows FROM ( select null as id, password_changed as createdate from rex_user where id = 15 AND password IS NOT NULL union select id, createdate from rex_user_passkey where user_id = 15 ) t" using params []! SQLSTATE[42S02]: Base table or view not found: 1146 Table 'lichter-filmfest.de.rex_user_passkey' doesn't exist File: src\core\lib\sql\sql.php Line: 406

Stacktrace | Function | File | Line | | ------------------------------------- | --------------------------------------------- | -------- | | rex_sql->execute | src\addons\debug\lib\extensions\sql_debug.php | 47 | | rex_sql_debug->execute | src\core\lib\sql\sql.php | 449 | | rex_sql->setQuery | src\addons\debug\lib\extensions\sql_debug.php | 14 | | rex_sql_debug->setQuery | src\core\lib\list.php | 184 | | rex_list->__construct | src\core\lib\list.php | 219 | | rex_list::factory | src\core\pages\profile.auth_methods.php | 11 | | require | src\core\pages\profile.php | 391 | | include | src\core\lib\be\controller.php | 496 | | rex_be_controller::{closure} | src\core\lib\util\timer.php | 62 | | rex_timer::measure | src\core\lib\be\controller.php | 504 | | rex_be_controller::includePath | src\core\lib\be\controller.php | 436 | | rex_be_controller::includeCurrentPage | src\core\backend.php | 241 | | require | src\core\boot.php | 155 | | require | public\redaxo\index.php | 12 |
System report (REDAXO 5.15.1, PHP 8.1.10, MySQL 8.0.30) | REDAXO | | | ------------: | :--------- | | Version | 5.15.1 | | PHP | | | ------------: | :--------- | | Version | 8.1.10 | | OPcache | no | | Xdebug | no | | Database | | | ------------: | :----------- | | Version | MySQL 8.0.30 | | Character set | utf8 | | Server | | | ------------: | :------------- | | OS | WINNT | | SAPI | apache2handler | | Webserver | Apache/2.4.54 | | Request | | | ------------: | :--------------- | | Browser | Chrome/118.0.0.0 | | Protocol | HTTP/1.1 | | HTTPS | yes | | Packages | | | ----------------------: | :--------- | | adminer | 1.9.3 | | backup | 2.9.0 | | be_style | 3.2.0 | | be_style/customizer | 3.2.0 | | be_style/lichter | 3.0.1 | | bloecks | 3.1.1 | | bloecks/cutncopy | 3.1.1 | | consent_manager | 3.0.8 | | cronjob | 2.10.0 | | debug | 1.3.0 | | developer | 3.9.2 | | focuspoint | 4.0.4 | | install | 2.11.1 | | lff_akkreditieren | 1.0.0 | | lff_movie_suggest | 1.0.0 | | maintenance | 2.9.1 | | mblock | 3.4.12 | | media_manager | 2.14.0 | | mediapool | 2.13.0 | | metainfo | 2.10.0 | | phpmailer | 2.12.0 | | poll | 1.4.3 | | project | dev | | quick_navigation | 6.0.2 | | redactor | 2.3.0 | | search_it | 6.9.8 | | search_it/documentation | 6.9.8 | | search_it/stats | 6.9.8 | | sprog | 1.5.1 | | statistics | 2.6.1 | | structure | 2.15.0 | | structure/content | 2.15.0 | | structure/history | 2.15.0 | | uploader | 2.4.1 | | url | 2.1.0 | | users | 2.10.0 | | yakme | 0.0.1 | | ydeploy | 1.2.0 | | yform | 4.1.1 | | yform/email | 4.1.1 | | yform/manager | 4.1.1 | | yrewrite | 2.10.0 | | yrewrite_scheme | 3.6.2 |
gharlan commented 11 months ago

Die Tabelle ist nicht Teil des User-Addons, sondern Core-Bestandteil. Somit hilft die Addon-Reinstallation nicht, sondern es muss das Setup durchlaufen werden, um die Core-Tabellen zu reparieren.

(Das User-Addon liefert im wesentlichen die grafische Benutzerverwaltung. Ich bin am überlegen, das Addon aufzulösen und komplett wieder in den Core zu integrieren.)

alxndr-w commented 11 months ago

Das Setup zu durchlaufen hat nicht geklappt, da muss ich nochmal nachsehen, was in dem Projekt zu dem Problem führte...

gharlan commented 11 months ago

Im Setup würde ich dann "Update der Datenbank" auswählen.

alxndr-w commented 11 months ago

Im Setup erhalte ich dann bei der Aktualisierung der Datenbank

SQL error: Error while executing statement "CREATE TABLE `rex_user_passkey` ( `id` varchar(255) NOT NULL , `user_id` int(10) unsigned NOT NULL , `public_key` text NOT NULL , `createdate` datetime NOT NULL , PRIMARY KEY (`id`), CONSTRAINT `rex_user_passkey_user_id` FOREIGN KEY (`user_id`) REFERENCES `rex_user` (`id`) ON UPDATE CASCADE ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;" using params []! SQLSTATE[HY000]: General error: 1215 Cannot add foreign key constraint