... references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

[alxndr-w]

Wenn die Tabelle nicht (mehr) existiert, lässt sich das Profil nicht mehr bearbeiten. Stattdessen kommt ein Whoops.

rex_sql_exception: Error while executing statement "SHOW FULL COLUMNS FROM rex_xxx_event_url" using params []! SQLSTATE[HY000]: General error: 1356 View 'xxx.rex_xxx_event_url' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them File: src\core\lib\sql\sql.php Line: 406

Stacktrace

| Function | File | Line | | -------------------------------------------- | ------------------------------------------- | -------- | | rex_sql->execute | src\core\lib\sql\sql.php | 449 | | rex_sql->setQuery | src\core\lib\sql\sql.php | 1821 | | rex_sql::showColumns | src\addons\url\lib\Url\Database.php | 50 | | Url\Database::getSupportedTables | src\addons\url\pages\generator.profiles.php | 382 | | require | src\core\lib\packages\package.php | 233 | | rex_package->includeFile | src\core\lib\be\controller.php | 503 | | 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 | 453 | | rex_be_controller::includeCurrentPageSubPath | src\addons\url\pages\index.php | 17 | | require | src\core\lib\packages\package.php | 233 | | rex_package->includeFile | src\core\lib\be\controller.php | 503 | | 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.6, MariaDB 10.4.24)

| REDAXO | | | ------------: | :--------- | | Version | 5.15.1 | | PHP | | | ------------: | :----------------------------- | | Version | 8.1.6 | | OPcache | yes | | Xdebug | yes | | Warning | Das Setup wird unverschlüsselt durchgeführt. Frontend und Backend sollten grundsätzlich durch HTTPS verschlüsselt aufgerufen werden, um die Privatsphäre zu schützen und den Datenschutz zu gewährleisten. | | Database | | | ------------: | :-------------- | | Version | MariaDB 10.4.24 | | Character set | utf8mb4 | | Server | | | ------------: | :------------- | | OS | WINNT | | SAPI | apache2handler | | Webserver | Apache/2.4.53 | | Request | | | ------------: | :--------------- | | Browser | Chrome/112.0.0.0 | | Protocol | HTTP/1.1 | | HTTPS | no | | Packages | | | -----------------------: | :--------- | | accessdenied | 2.0.2 | | adminer | 1.9.3 | | auto_delete | 1.0-dev | | backup | 2.9.0 | | be_password | 2.0.1 | | be_style | 3.2.0 | | be_style/customizer | 3.2.0 | | be_style/redaxo | 3.2.0 | | be_style_fluent | 4.0.0 | | bloecks | 3.1.1 | | bloecks/cutncopy | 3.1.1 | | bpk | dev | | cache_warmup | 4.0.0 | | cronjob | 2.10.0 | | cronjob/article_status | 2.10.0 | | cronjob/optimize_tables | 2.10.0 | | developer | 3.9.2 | | epcqrcode | 1.0.3 | | focuspoint | 4.0.4 | | global_settings | 2.8.4 | | install | 2.11.1 | | mailer_profile | 1.0.1 | | maintenance | 2.9.1 | | media_manager | 2.14.0 | | media_manager_responsive | 1.1.4 | | mediapool | 2.13.0 | | metainfo | 2.10.0 | | mform | 7.2.8 | | notification | 1.0.0 | | pdfout | 7.1.2 | | phpmailer | 2.12.0 | | plus_bs5 | 0.0.5 | | project | dev | | project_manager | 1.5.0 | | project_manager/client | 1.1.0 | | qanda | 2.0.14 | | quick_navigation | 6.0.2 | | redactor | 2.3.0 | | rides | 4.0.0 | | search_it | 6.9.8 | | search_it/documentation | 6.9.8 | | speed_up | 1.3.1 | | sprog | 1.5.1 | | structure | 2.15.0 | | structure/content | 2.15.0 | | structure/history | 2.15.0 | | url | 2.1.0 | | users | 2.10.0 | | wenns_sein_muss | 4.0.1 | | ydeploy | 1.2.0 | | yform | 4.1.1 | | yform/email | 4.1.1 | | yform/manager | 4.1.1 | | yform_field | 2.3.0-dev | | yform_geo_osm | 1.2.8 | | yform_spam_protection | 2.0.0-beta | | yrewrite | 2.10.0 | | yrewrite_metainfo | 1.0.5 | | zip_install | 1.2 |