Errors related with 'No file' option in the Filebase

Aethior · September 29, 2023 at 12:11 AM

In WoltLab Suite 5.5.17 you can add a file 'without file', but an error is generated when trying to add a review.
In WoltLab Suite 6.0.0 RC 2 the error is generated when you try to add a file 'without file', and directly breaks the Filebase

WoltLab Suite 5.5.17 Error Message

Requested URL: POST /lab/legacy/filebase/index.php?file-review-add/1/

Referrer: https://aethior.com/lab/legacy/filebase/index.php?file-review-add/1-testfile/

Error Message: Could not execute statement 'INSERT INTO filebase1_file_version_review (fileID,versionID,title,rating,time,userID,username,message,attachments,isDisabled) VALUES (?,?,?,?,?,?,?,?,?,?)'

Type: wcf\system\database\exception\DatabaseQueryExecutionException

File (Line): /homepages/46/d834751442/htdocs/www/lab/legacy/lib/system/database/statement/PreparedStatement.class.php (144)

Query Parameter 1: 1

Query Parameter 2: 0

Query Parameter 3: 'Test'

Query Parameter 4: 5

Query Parameter 5: 1695939021

Query Parameter 6: 2

Query Parameter 7: 'user'

Query Parameter 8: '<p>Test</p>'

Query Parameter 9: 0

Query Parameter 10: 0

Stacktrace

/homepages/46/d834751442/htdocs/www/lab/legacy/lib/data/TFastCreate.class.php (44): wcf\system\database\statement\PreparedStatement->execute(…)
/homepages/46/d834751442/htdocs/www/lab/legacy/lib/data/DatabaseObjectEditor.class.php (28): wcf\data\DatabaseObjectEditor::dboEditorCreateBase(…)
/homepages/46/d834751442/htdocs/www/lab/legacy/lib/data/AbstractDatabaseObjectAction.class.php (355): wcf\data\DatabaseObjectEditor::create(…)
/homepages/46/d834751442/htdocs/www/lab/legacy/filebase/lib/data/file/version/review/FileVersionReviewAction.class.php (104): wcf\data\AbstractDatabaseObjectAction->create(…)
/homepages/46/d834751442/htdocs/www/lab/legacy/lib/data/AbstractDatabaseObjectAction.class.php (216): filebase\data\file\version\review\FileVersionReviewAction->create(…)
/homepages/46/d834751442/htdocs/www/lab/legacy/lib/form/AbstractFormBuilderForm.class.php (188): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
/homepages/46/d834751442/htdocs/www/lab/legacy/filebase/lib/form/FileReviewAddForm.class.php (224): wcf\form\AbstractFormBuilderForm->save(…)
/homepages/46/d834751442/htdocs/www/lab/legacy/lib/form/AbstractForm.class.php (80): filebase\form\FileReviewAddForm->save(…)
/homepages/46/d834751442/htdocs/www/lab/legacy/lib/form/AbstractForm.class.php (152): wcf\form\AbstractForm->submit(…)
/homepages/46/d834751442/htdocs/www/lab/legacy/lib/form/AbstractFormBuilderForm.class.php (147): wcf\form\AbstractForm->readData(…)
/homepages/46/d834751442/htdocs/www/lab/legacy/filebase/lib/form/FileReviewAddForm.class.php (117): wcf\form\AbstractFormBuilderForm->readData(…)
/homepages/46/d834751442/htdocs/www/lab/legacy/lib/page/AbstractPage.class.php (353): filebase\form\FileReviewAddForm->readData(…)
/homepages/46/d834751442/htdocs/www/lab/legacy/lib/page/AbstractPage.class.php (135): wcf\page\AbstractPage->show(…)
/homepages/46/d834751442/htdocs/www/lab/legacy/lib/system/request/Request.class.php (90): wcf\page\AbstractPage->__run(…)
/homepages/46/d834751442/htdocs/www/lab/legacy/lib/system/request/RequestHandler.class.php (107): wcf\system\request\Request->execute(…)
/homepages/46/d834751442/htdocs/www/lab/legacy/filebase/index.php (11): wcf\system\request\RequestHandler->handle(…)

Error Message: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails ("dbs12124486"."filebase1_file_version_review", CONSTRAINT "ec819c70965b83bad9d6774adb3cc18d_fk" FOREIGN KEY ("versionID") REFERENCES "filebase1_file_version" ("versionID") ON DELETE CASCADE)

Type: PDOException

File (Line): /homepages/46/d834751442/htdocs/www/lab/legacy/lib/system/database/statement/PreparedStatement.class.php (126)

Stacktrace

/homepages/46/d834751442/htdocs/www/lab/legacy/lib/system/database/statement/PreparedStatement.class.php (126): PDOStatement->execute(…)
/homepages/46/d834751442/htdocs/www/lab/legacy/lib/data/TFastCreate.class.php (44): wcf\system\database\statement\PreparedStatement->execute(…)
/homepages/46/d834751442/htdocs/www/lab/legacy/lib/data/DatabaseObjectEditor.class.php (28): wcf\data\DatabaseObjectEditor::dboEditorCreateBase(…)
/homepages/46/d834751442/htdocs/www/lab/legacy/lib/data/AbstractDatabaseObjectAction.class.php (355): wcf\data\DatabaseObjectEditor::create(…)
/homepages/46/d834751442/htdocs/www/lab/legacy/filebase/lib/data/file/version/review/FileVersionReviewAction.class.php (104): wcf\data\AbstractDatabaseObjectAction->create(…)
/homepages/46/d834751442/htdocs/www/lab/legacy/lib/data/AbstractDatabaseObjectAction.class.php (216): filebase\data\file\version\review\FileVersionReviewAction->create(…)
/homepages/46/d834751442/htdocs/www/lab/legacy/lib/form/AbstractFormBuilderForm.class.php (188): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
/homepages/46/d834751442/htdocs/www/lab/legacy/filebase/lib/form/FileReviewAddForm.class.php (224): wcf\form\AbstractFormBuilderForm->save(…)
/homepages/46/d834751442/htdocs/www/lab/legacy/lib/form/AbstractForm.class.php (80): filebase\form\FileReviewAddForm->save(…)
/homepages/46/d834751442/htdocs/www/lab/legacy/lib/form/AbstractForm.class.php (152): wcf\form\AbstractForm->submit(…)
/homepages/46/d834751442/htdocs/www/lab/legacy/lib/form/AbstractFormBuilderForm.class.php (147): wcf\form\AbstractForm->readData(…)
/homepages/46/d834751442/htdocs/www/lab/legacy/filebase/lib/form/FileReviewAddForm.class.php (117): wcf\form\AbstractFormBuilderForm->readData(…)
/homepages/46/d834751442/htdocs/www/lab/legacy/lib/page/AbstractPage.class.php (353): filebase\form\FileReviewAddForm->readData(…)
/homepages/46/d834751442/htdocs/www/lab/legacy/lib/page/AbstractPage.class.php (135): wcf\page\AbstractPage->show(…)
/homepages/46/d834751442/htdocs/www/lab/legacy/lib/system/request/Request.class.php (90): wcf\page\AbstractPage->__run(…)
/homepages/46/d834751442/htdocs/www/lab/legacy/lib/system/request/RequestHandler.class.php (107): wcf\system\request\Request->execute(…)
/homepages/46/d834751442/htdocs/www/lab/legacy/filebase/index.php (11): wcf\system\request\RequestHandler->handle(…)

Thu, 28 Sep 2023 22:10:21 +0000
Message: Could not execute statement 'INSERT INTO filebase1_file_version_review                             (fileID,versionID,title,rating,time,userID,username,message,attachments,isDisabled)                 VALUES      (?,?,?,?,?,?,?,?,?,?)'
PHP version: 8.1.23
WoltLab Suite version: 5.5.17
Request URI: POST /lab/legacy/filebase/index.php?file-review-add/1/
Referrer: https://aethior.com/lab/legacy/filebase/index.php?file-review-add/1-testfile/
User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36
Peak Memory Usage: 11426224/-1
======
Error Class: wcf\system\database\exception\DatabaseQueryExecutionException
Error Message: Could not execute statement 'INSERT INTO filebase1_file_version_review                             (fileID,versionID,title,rating,time,userID,username,message,attachments,isDisabled)                 VALUES      (?,?,?,?,?,?,?,?,?,?)'
Error Code: 23000
File: /homepages/46/d834751442/htdocs/www/lab/legacy/lib/system/database/statement/PreparedStatement.class.php (144)
Extra Information: YToxMDp7aTowO2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciAxIjtpOjE7aToxO31pOjE7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDIiO2k6MTtpOjA7fWk6MjthOjI6e2k6MDtzOjE3OiJRdWVyeSBQYXJhbWV0ZXIgMyI7aToxO3M6NjoiJ1Rlc3QnIjt9aTozO2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciA0IjtpOjE7aTo1O31pOjQ7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDUiO2k6MTtpOjE2OTU5MzkwMjE7fWk6NTthOjI6e2k6MDtzOjE3OiJRdWVyeSBQYXJhbWV0ZXIgNiI7aToxO2k6Mjt9aTo2O2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciA3IjtpOjE7czo2OiIndXNlciciO31pOjc7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDgiO2k6MTtzOjI1OiInJmx0O3AmZ3Q7VGVzdCZsdDsvcCZndDsnIjt9aTo4O2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciA5IjtpOjE7aTowO31pOjk7YToyOntpOjA7czoxODoiUXVlcnkgUGFyYW1ldGVyIDEwIjtpOjE7aTowO319
Stack Trace: [{"file":"\/homepages\/46\/d834751442\/htdocs\/www\/lab\/legacy\/lib\/data\/TFastCreate.class.php","line":44,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[]},{"file":"\/homepages\/46\/d834751442\/htdocs\/www\/lab\/legacy\/lib\/data\/DatabaseObjectEditor.class.php","line":28,"function":"dboEditorCreateBase","class":"wcf\\data\\DatabaseObjectEditor","type":"::","args":[]},{"file":"\/homepages\/46\/d834751442\/htdocs\/www\/lab\/legacy\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":355,"function":"create","class":"wcf\\data\\DatabaseObjectEditor","type":"::","args":[]},{"file":"\/homepages\/46\/d834751442\/htdocs\/www\/lab\/legacy\/filebase\/lib\/data\/file\/version\/review\/FileVersionReviewAction.class.php","line":104,"function":"create","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/homepages\/46\/d834751442\/htdocs\/www\/lab\/legacy\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":216,"function":"create","class":"filebase\\data\\file\\version\\review\\FileVersionReviewAction","type":"->","args":[]},{"file":"\/homepages\/46\/d834751442\/htdocs\/www\/lab\/legacy\/lib\/form\/AbstractFormBuilderForm.class.php","line":188,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/homepages\/46\/d834751442\/htdocs\/www\/lab\/legacy\/filebase\/lib\/form\/FileReviewAddForm.class.php","line":224,"function":"save","class":"wcf\\form\\AbstractFormBuilderForm","type":"->","args":[]},{"file":"\/homepages\/46\/d834751442\/htdocs\/www\/lab\/legacy\/lib\/form\/AbstractForm.class.php","line":80,"function":"save","class":"filebase\\form\\FileReviewAddForm","type":"->","args":[]},{"file":"\/homepages\/46\/d834751442\/htdocs\/www\/lab\/legacy\/lib\/form\/AbstractForm.class.php","line":152,"function":"submit","class":"wcf\\form\\AbstractForm","type":"->","args":[]},{"file":"\/homepages\/46\/d834751442\/htdocs\/www\/lab\/legacy\/lib\/form\/AbstractFormBuilderForm.class.php","line":147,"function":"readData","class":"wcf\\form\\AbstractForm","type":"->","args":[]},{"file":"\/homepages\/46\/d834751442\/htdocs\/www\/lab\/legacy\/filebase\/lib\/form\/FileReviewAddForm.class.php","line":117,"function":"readData","class":"wcf\\form\\AbstractFormBuilderForm","type":"->","args":[]},{"file":"\/homepages\/46\/d834751442\/htdocs\/www\/lab\/legacy\/lib\/page\/AbstractPage.class.php","line":353,"function":"readData","class":"filebase\\form\\FileReviewAddForm","type":"->","args":[]},{"file":"\/homepages\/46\/d834751442\/htdocs\/www\/lab\/legacy\/lib\/page\/AbstractPage.class.php","line":135,"function":"show","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/homepages\/46\/d834751442\/htdocs\/www\/lab\/legacy\/lib\/system\/request\/Request.class.php","line":90,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/homepages\/46\/d834751442\/htdocs\/www\/lab\/legacy\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/homepages\/46\/d834751442\/htdocs\/www\/lab\/legacy\/filebase\/index.php","line":11,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":[]}]
======
Error Class: PDOException
Error Message: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails ("dbs12124486"."filebase1_file_version_review", CONSTRAINT "ec819c70965b83bad9d6774adb3cc18d_fk" FOREIGN KEY ("versionID") REFERENCES "filebase1_file_version" ("versionID") ON DELETE CASCADE)
Error Code: 23000
File: /homepages/46/d834751442/htdocs/www/lab/legacy/lib/system/database/statement/PreparedStatement.class.php (126)
Extra Information: -
Stack Trace: [{"file":"\/homepages\/46\/d834751442\/htdocs\/www\/lab\/legacy\/lib\/system\/database\/statement\/PreparedStatement.class.php","line":126,"function":"execute","class":"PDOStatement","type":"->","args":[]},{"file":"\/homepages\/46\/d834751442\/htdocs\/www\/lab\/legacy\/lib\/data\/TFastCreate.class.php","line":44,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[]},{"file":"\/homepages\/46\/d834751442\/htdocs\/www\/lab\/legacy\/lib\/data\/DatabaseObjectEditor.class.php","line":28,"function":"dboEditorCreateBase","class":"wcf\\data\\DatabaseObjectEditor","type":"::","args":[]},{"file":"\/homepages\/46\/d834751442\/htdocs\/www\/lab\/legacy\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":355,"function":"create","class":"wcf\\data\\DatabaseObjectEditor","type":"::","args":[]},{"file":"\/homepages\/46\/d834751442\/htdocs\/www\/lab\/legacy\/filebase\/lib\/data\/file\/version\/review\/FileVersionReviewAction.class.php","line":104,"function":"create","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/homepages\/46\/d834751442\/htdocs\/www\/lab\/legacy\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":216,"function":"create","class":"filebase\\data\\file\\version\\review\\FileVersionReviewAction","type":"->","args":[]},{"file":"\/homepages\/46\/d834751442\/htdocs\/www\/lab\/legacy\/lib\/form\/AbstractFormBuilderForm.class.php","line":188,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/homepages\/46\/d834751442\/htdocs\/www\/lab\/legacy\/filebase\/lib\/form\/FileReviewAddForm.class.php","line":224,"function":"save","class":"wcf\\form\\AbstractFormBuilderForm","type":"->","args":[]},{"file":"\/homepages\/46\/d834751442\/htdocs\/www\/lab\/legacy\/lib\/form\/AbstractForm.class.php","line":80,"function":"save","class":"filebase\\form\\FileReviewAddForm","type":"->","args":[]},{"file":"\/homepages\/46\/d834751442\/htdocs\/www\/lab\/legacy\/lib\/form\/AbstractForm.class.php","line":152,"function":"submit","class":"wcf\\form\\AbstractForm","type":"->","args":[]},{"file":"\/homepages\/46\/d834751442\/htdocs\/www\/lab\/legacy\/lib\/form\/AbstractFormBuilderForm.class.php","line":147,"function":"readData","class":"wcf\\form\\AbstractForm","type":"->","args":[]},{"file":"\/homepages\/46\/d834751442\/htdocs\/www\/lab\/legacy\/filebase\/lib\/form\/FileReviewAddForm.class.php","line":117,"function":"readData","class":"wcf\\form\\AbstractFormBuilderForm","type":"->","args":[]},{"file":"\/homepages\/46\/d834751442\/htdocs\/www\/lab\/legacy\/lib\/page\/AbstractPage.class.php","line":353,"function":"readData","class":"filebase\\form\\FileReviewAddForm","type":"->","args":[]},{"file":"\/homepages\/46\/d834751442\/htdocs\/www\/lab\/legacy\/lib\/page\/AbstractPage.class.php","line":135,"function":"show","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/homepages\/46\/d834751442\/htdocs\/www\/lab\/legacy\/lib\/system\/request\/Request.class.php","line":90,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/homepages\/46\/d834751442\/htdocs\/www\/lab\/legacy\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/homepages\/46\/d834751442\/htdocs\/www\/lab\/legacy\/filebase\/index.php","line":11,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":[]}]

WoltLab Suite 6.0.0 RC 2 Error Message

Requested URL: GET /lab/beta/filebase/

Referrer: https://www.aethior.com/lab/beta/filebase/index.php?file-add/

Error Message: wcf\util\FileUtil::getIconNameByFilename(): Argument #1 ($filename) must be of type string, null given, called in /homepages/46/d834751442/htdocs/www/lab/beta/filebase/lib/data/file/ViewableFile.class.php on line 99

Type: TypeError

File (Line): /homepages/46/d834751442/htdocs/www/lab/beta/lib/util/FileUtil.class.php (565)

Stacktrace

/homepages/46/d834751442/htdocs/www/lab/beta/filebase/lib/data/file/ViewableFile.class.php (99): wcf\util\FileUtil::getIconNameByFilename(…)
/homepages/46/d834751442/htdocs/www/lab/beta/templates/compiled/0_filebase_2_fileList.php (1975): filebase\data\file\ViewableFile->getIconTag(…)
/homepages/46/d834751442/htdocs/www/lab/beta/lib/system/template/TemplateEngine.class.php (340): include(…)
/homepages/46/d834751442/htdocs/www/lab/beta/lib/page/AbstractPage.class.php (386): wcf\system\template\TemplateEngine->display(…)
/homepages/46/d834751442/htdocs/www/lab/beta/lib/page/AbstractPage.class.php (134): wcf\page\AbstractPage->show(…)
/homepages/46/d834751442/htdocs/www/lab/beta/lib/system/request/Request.class.php (57): wcf\page\AbstractPage->__run(…)
/homepages/46/d834751442/htdocs/www/lab/beta/lib/http/middleware/HandleValinorMappingErrors.class.php (35): wcf\system\request\Request->handle(…)
/homepages/46/d834751442/htdocs/www/lab/beta/lib/system/request/RequestHandler.class.php (143): wcf\http\Pipeline->process(…)
/homepages/46/d834751442/htdocs/www/lab/beta/filebase/index.php (10): wcf\system\request\RequestHandler->handle(…)

Thu, 28 Sep 2023 23:18:05 +0000
Message: wcf\util\FileUtil::getIconNameByFilename(): Argument #1 ($filename) must be of type string, null given, called in /homepages/46/d834751442/htdocs/www/lab/beta/filebase/lib/data/file/ViewableFile.class.php on line 99
PHP version: 8.1.23
WoltLab Suite version: 6.0.0 RC 2
Request URI: GET /lab/beta/filebase/
Referrer: https://www.aethior.com/lab/beta/filebase/index.php?file-add/
User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36
Peak Memory Usage: 11594896/-1
======
Error Class: TypeError
Error Message: wcf\util\FileUtil::getIconNameByFilename(): Argument #1 ($filename) must be of type string, null given, called in /homepages/46/d834751442/htdocs/www/lab/beta/filebase/lib/data/file/ViewableFile.class.php on line 99
Error Code: 0
File: /homepages/46/d834751442/htdocs/www/lab/beta/lib/util/FileUtil.class.php (565)
Extra Information: -
Stack Trace: [{"file":"\/homepages\/46\/d834751442\/htdocs\/www\/lab\/beta\/filebase\/lib\/data\/file\/ViewableFile.class.php","line":99,"function":"getIconNameByFilename","class":"wcf\\util\\FileUtil","type":"::","args":[]},{"file":"\/homepages\/46\/d834751442\/htdocs\/www\/lab\/beta\/templates\/compiled\/0_filebase_2_fileList.php","line":1975,"function":"getIconTag","class":"filebase\\data\\file\\ViewableFile","type":"->","args":[]},{"file":"\/homepages\/46\/d834751442\/htdocs\/www\/lab\/beta\/lib\/system\/template\/TemplateEngine.class.php","line":340,"args":["\/homepages\/46\/d834751442\/htdocs\/www\/lab\/beta\/templates\/compiled\/0_filebase_2_fileList.php"],"function":"include","class":"","type":""},{"file":"\/homepages\/46\/d834751442\/htdocs\/www\/lab\/beta\/lib\/page\/AbstractPage.class.php","line":386,"function":"display","class":"wcf\\system\\template\\TemplateEngine","type":"->","args":[]},{"file":"\/homepages\/46\/d834751442\/htdocs\/www\/lab\/beta\/lib\/page\/AbstractPage.class.php","line":134,"function":"show","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/homepages\/46\/d834751442\/htdocs\/www\/lab\/beta\/lib\/system\/request\/Request.class.php","line":57,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/homepages\/46\/d834751442\/htdocs\/www\/lab\/beta\/lib\/http\/middleware\/HandleValinorMappingErrors.class.php","line":35,"function":"handle","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/homepages\/46\/d834751442\/htdocs\/www\/lab\/beta\/lib\/system\/request\/RequestHandler.class.php","line":143,"function":"process","class":"wcf\\http\\Pipeline","type":"->","args":[]},{"file":"\/homepages\/46\/d834751442\/htdocs\/www\/lab\/beta\/filebase\/index.php","line":10,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":[]}]

Julian Pfeil · September 29, 2023 at 12:48 AM

Quote from Aethior

SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails ("dbs12124486"."filebase1_file_version_review", CONSTRAINT "ec819c70965b83bad9d6774adb3cc18d_fk" FOREIGN KEY ("versionID") REFERENCES "filebase1_file_version" ("versionID") ON DELETE CASCADE)

It's like: https://stackoverflow.com/questions/1406…ate-a-child-row

Maybe the version the review was written for got deleted while writing the review?

Aethior · September 29, 2023 at 1:08 AM

Hi @Julian Pfeil!

The error was found in another installation. This installation has been installed in an attempt to reproduce the error. The error is reproducible in different installations.

Edited. The error is related to the 'No file' option. Added all the information in the first post, with tests on different versions.

Errors related with 'No file' option in the Filebase

Aethior September 29, 2023 at 1:39 AM

Marcel Werk October 5, 2023 at 3:57 PM

Marcel Werk October 5, 2023 at 3:57 PM

Marcel Werk October 5, 2023 at 3:57 PM

Alexander Ebert October 11, 2023 at 7:15 PM

Participate now!

Similar Threads

Update: WoltLab Suite 5.5.16 / 5.4.32

Update: WoltLab Suite 5.5.13 / 5.4.28

Error message when you block an avatar, signature o cover photo and do not set an 'unblocking' date

WBB4 -> WSC5 Import Error on User Groups

Update: WoltLab Suite 5.5.11 / 5.4.27 / 5.3.28

Update: WoltLab Suite 5.5.10 / 5.4.26 / 5.3.27

Users Viewing This Thread

Aethior September 29, 2023 at 1:39 AM

Marcel Werk October 5, 2023 at 3:57 PM

Marcel Werk October 5, 2023 at 3:57 PM

Marcel Werk October 5, 2023 at 3:57 PM

Alexander Ebert October 11, 2023 at 7:15 PM

Participate now!

Similar Threads

Update: WoltLab Suite 5.5.16 / 5.4.32

Update: WoltLab Suite 5.5.13 / 5.4.28

Error message when you block an avatar, signature o cover photo and do not set an 'unblocking' date

WBB4 -> WSC5 Import Error on User Groups

Update: WoltLab Suite 5.5.11 / 5.4.27 / 5.3.28

Update: WoltLab Suite 5.5.10 / 5.4.26 / 5.3.27

Users Viewing This Thread

Aethior September 29, 2023 at 1:39 AM

Marcel Werk October 5, 2023 at 3:57 PM

Marcel Werk October 5, 2023 at 3:57 PM

Marcel Werk October 5, 2023 at 3:57 PM

Alexander Ebert October 11, 2023 at 7:15 PM