`quiqqer:tests` Datenbank-Tests schlagen fehl
Einige Datenbank-Tests mittels quiqqer:tests schlagen fehl:
Aus den Logs:
==> var/log/debug-2019-04-12.log <==
[2019-04-12 12:32:27] - DEBUG - 401 ::
Array
(
)
Your session has expired, please login.
#0 /var/www/quiqqer-test/packages/quiqqer/quiqqer/lib/QUI/Permissions/Permission.php(410): QUI\Users\Manager->checkUserSession()
#1 /var/www/quiqqer-test/packages/quiqqer/quiqqer/lib/QUI/Permissions/Permission.php(139): QUI\Permissions\Permission::checkUser()
#2 /var/www/quiqqer-test/packages/quiqqer/quiqqer/lib/QUI/Ajax.php(179): QUI\Permissions\Permission::checkAdminUser()
#3 /var/www/quiqqer-test/packages/quiqqer/quiqqer/lib/QUI/Ajax.php(292): QUI\Ajax::checkPermissions('ajax_system_mod...')
#4 /var/www/quiqqer-test/packages/quiqqer/quiqqer/lib/QUI/Ajax.php(207): QUI\Ajax->callRequestFunction('ajax_system_mod...')
#5 /var/www/quiqqer-test/packages/quiqqer/quiqqer/lib/ajax.php(101): QUI\Ajax->call()
#6 /var/www/quiqqer-test/packages/quiqqer/quiqqer/admin/ajax.php(21): require('/var/www/quiqqe...')
#7 {main}
{
"request": "http:\/\/quiqqer-test.jan.pcsg.eu\/\/admin\/\/ajax.php?_rf=[\"ajax_system_modRewrite\"]",
"errorFilename": false,
"userId": false,
"username": "nobody",
"IP": "127.0.0.1"
}
==> var/log/warning-2019-04-12.log <==
[2019-04-12 12:32:27] - WARNING -
-> Database Check Errors in: /var/www/quiqqer-test/packages/quiqqer/translator/database.xml <-
Error #1:
-------------------------
Definition for table: "translate"
Database table: "translate"
Error: No PRIMARY KEY -> Table "translate" has no PRIMARY KEY.
Error #2:
-------------------------
Definition for table: "translate"
Database table: "translate"
Error: Primary Key mismatch -> XML primary keys: (none) | Database table primary keys: id
{
"errorFilename": false,
"userId": 926994626,
"username": "admin",
"IP": ""
}
[2019-04-12 12:32:27] - WARNING -
-> Database Check Errors in: /var/www/quiqqer-test/packages/quiqqer/quiqqer/database.xml <-
Error #1:
-------------------------
Definition for table: "users"
Database table: "users"
Error: Field structure mismatch -> The XML file says that field "secHash" should be "text(32)" but the database says it is "tinytext".
Error #2:
-------------------------
Definition for table: "users"
Database table: "users"
Error: Field structure mismatch -> The XML file says that field "failedLogins" should be "smallint unsigned default '0'" but the database says it is "smallint(5) unsigned".
Error #3:
-------------------------
Definition for table: "permissions2sites"
Database table: "permissions2sites"
Error: Field structure mismatch -> The XML file says that field "id" should be NULL but the database says it is NOT NULL.
Error #4:
-------------------------
Definition for table: "permissions2sites"
Database table: "permissions2sites"
Error: Field structure mismatch -> The XML file says that field "permission" should be NULL but the database says it is NOT NULL.
Error #5:
-------------------------
Definition for table: "permissions2projects"
Database table: "permissions2projects"
Error: Field structure mismatch -> The XML file says that field "permission" should be NULL but the database says it is NOT NULL.
Error #6:
-------------------------
Definition for table: "permissions2media"
Database table: "permissions2media"
Error: Field structure mismatch -> The XML file says that field "id" should be NULL but the database says it is NOT NULL.
Error #7:
-------------------------
Definition for table: "permissions2media"
Database table: "permissions2media"
Error: Field structure mismatch -> The XML file says that field "permission" should be NULL but the database says it is NOT NULL.
{
"errorFilename": false,
"userId": 926994626,
"username": "admin",
"IP": ""
}
[2019-04-12 12:32:27] - WARNING -
-> Database Check Errors in: /var/www/quiqqer-test/packages/quiqqer/cron/database.xml <-
Error #1:
-------------------------
Definition for table: "cron_history"
Database table: "cron_history"
Error: No PRIMARY KEY -> Table "cron_history" has no PRIMARY KEY.
Error #2:
-------------------------
Definition for table: "cron_cronservice"
Database table: "cron_cronservice"
Error: No PRIMARY KEY -> Table "cron_cronservice" has no PRIMARY KEY.
{
"errorFilename": false,
"userId": 926994626,
"username": "admin",
"IP": ""
}
[2019-04-12 12:32:27] - WARNING -
-> Database Check Errors in: /var/www/quiqqer-test/packages/quiqqer/bricks/database.xml <-
Error #1:
-------------------------
Definition for table: "bricksCache"
Database table: "Test_de_bricksCache"
Error: No PRIMARY KEY -> Table "Test_de_bricksCache" has no PRIMARY KEY.
Error #2:
-------------------------
Definition for table: "bricksCache"
Database table: "Test_de_bricksCache"
Error: No PRIMARY KEY -> Table "Test_de_bricksCache" has no PRIMARY KEY.
Error #3:
-------------------------
Definition for table: "bricksCache"
Database table: "TestTestTestTest_en_bricksCache"
Error: No PRIMARY KEY -> Table "TestTestTestTest_en_bricksCache" has no PRIMARY KEY.
{
"errorFilename": false,
"userId": 926994626,
"username": "admin",
"IP": ""
}