Skip to content

`quiqqer:tests` Datenbank-Tests schlagen fehl

Einige Datenbank-Tests mittels quiqqer:tests schlagen fehl:
image

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": ""
}