Could not prepare statement #313

Fri, 27 Mar 2026 18:07:29 +0000

Message: Could not prepare statement 'SELECT github_repository.repositoryID AS objectID FROM wcf1_github_repository github_repository LEFT JOIN wcf1_github_commit commit ON (commit.repositoryID = github_repository.repositoryID AND commit.committerTime = github_repository.lastCommitTime) WHERE github_repository.repositoryID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND github_repository.isDisabled = ? AND lastCommitTime > ? ORDER BY repositoryID DESC, github_repository.repositoryID DESC LIMIT 20 OFFSET 20'

PHP version: 8.3.29-nmm1

WoltLab Suite version: 6.2.2

Request URI: GET /index.php?github-repository-list/&pageNo=2&sortField=repositoryID&sortOrder=DESC

Referrer:

User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36

Peak Memory Usage: 13432760/402653184

======

Error Class: wcf\system\database\exception\DatabaseQueryException

Error Message: Could not prepare statement 'SELECT github_repository.repositoryID AS objectID FROM wcf1_github_repository github_repository LEFT JOIN wcf1_github_commit commit ON (commit.repositoryID = github_repository.repositoryID AND commit.committerTime = github_repository.lastCommitTime) WHERE github_repository.repositoryID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND github_repository.isDisabled = ? AND lastCommitTime > ? ORDER BY repositoryID DESC, github_repository.repositoryID DESC LIMIT 20 OFFSET 20'

Error Code: 23000

File: /www/htdocs/w00ddbc3/yourecom/lib/system/database/Database.class.php (347)

Extra Information: -

Stack Trace: [{"file":"\/www\/htdocs\/w00ddbc3\/yourecom\/lib\/system\/database\/Database.class.php","line":380,"function":"prepareUnmanaged","class":"wcf\\system\\database\\Database","type":"->","args":["SELECT github_repository.repositoryID AS objectID\n FROM wcf1_github_repository github_repository\n LEFT JOIN wcf1_github_commit commit\n ON (commit.repositoryID = github_repository.repositoryID AND commit.committerTime = github_repository.lastCommitTime)\n WHERE github_repository.repositoryID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND github_repository.isDisabled = ? AND lastCommitTime > ?\n ORDER BY repositoryID DESC, github_repository.repositoryID DESC LIMIT 20 OFFSET 20",20,20]},{"file":"\/www\/htdocs\/w00ddbc3\/yourecom\/lib\/data\/DatabaseObjectList.class.php","line":173,"function":"prepare","class":"wcf\\system\\database\\Database","type":"->","args":["SELECT github_repository.repositoryID AS objectID\n FROM wcf1_github_repository github_repository\n LEFT JOIN wcf1_github_commit commit\n ON (commit.repositoryID = github_repository.repositoryID AND commit.committerTime = github_repository.lastCommitTime)\n WHERE github_repository.repositoryID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND github_repository.isDisabled = ? AND lastCommitTime > ?\n ORDER BY repositoryID DESC, github_repository.repositoryID DESC",20,20]},{"file":"\/www\/htdocs\/w00ddbc3\/yourecom\/lib\/data\/github\/repository\/AccessibleGithubRepositoryList.class.php","line":54,"function":"readObjectIDs","class":"wcf\\data\\DatabaseObjectList","type":"->","args":[]},{"file":"\/www\/htdocs\/w00ddbc3\/yourecom\/lib\/page\/MultipleLinkPage.class.php","line":179,"function":"readObjects","class":"wcf\\data\\github\\repository\\AccessibleGithubRepositoryList","type":"->","args":[]},{"file":"\/www\/htdocs\/w00ddbc3\/yourecom\/lib\/page\/MultipleLinkPage.class.php","line":140,"function":"readObjects","class":"wcf\\page\\MultipleLinkPage","type":"->","args":[]},{"file":"\/www\/htdocs\/w00ddbc3\/yourecom\/lib\/page\/SortablePage.class.php","line":64,"function":"readData","class":"wcf\\page\\MultipleLinkPage","type":"->","args":[]},{"file":"\/www\/htdocs\/w00ddbc3\/yourecom\/lib\/page\/AbstractPage.class.php","line":335,"function":"readData","class":"wcf\\page\\SortablePage","type":"->","args":[]},{"file":"\/www\/htdocs\/w00ddbc3\/yourecom\/lib\/page\/AbstractPage.class.php","line":124,"function":"show","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/www\/htdocs\/w00ddbc3\/yourecom\/lib\/system\/request\/Request.class.php","line":54,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/www\/htdocs\/w00ddbc3\/yourecom\/lib\/http\/middleware\/HandleValinorMappingErrors.class.php","line":35,"function":"handle","class":"wcf\\system\\request\\Request","type":"->","args":["Laminas\\Diactoros\\ServerRequest"]},{"file":"\/www\/htdocs\/w00ddbc3\/yourecom\/lib\/system\/request\/RequestHandler.class.php","line":168,"function":"process","class":"wcf\\http\\Pipeline","type":"->","args":["Laminas\\Diactoros\\ServerRequest","wcf\\http\\RequestHandlerMiddleware"]},{"file":"\/www\/htdocs\/w00ddbc3\/yourecom\/index.php","line":10,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf"]}]

======

Error Class: PDOException

Error Message: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'repositoryID' in ORDER BY is ambiguous

Error Code: 23000

File: /www/htdocs/w00ddbc3/yourecom/lib/system/database/Database.class.php (341)

Extra Information: -

Stack Trace: [{"file":"\/www\/htdocs\/w00ddbc3\/yourecom\/lib\/system\/database\/Database.class.php","line":341,"function":"prepare","class":"PDO","type":"->","args":["SELECT github_repository.repositoryID AS objectID\n FROM wcf1_github_repository github_repository\n LEFT JOIN wcf1_github_commit commit\n ON (commit.repositoryID = github_repository.repositoryID AND commit.committerTime = github_repository.lastCommitTime)\n WHERE github_repository.repositoryID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND github_repository.isDisabled = ? AND lastCommitTime > ?\n ORDER BY repositoryID DESC, github_repository.repositoryID DESC LIMIT 20 OFFSET 20"]},{"file":"\/www\/htdocs\/w00ddbc3\/yourecom\/lib\/system\/database\/Database.class.php","line":380,"function":"prepareUnmanaged","class":"wcf\\system\\database\\Database","type":"->","args":["SELECT github_repository.repositoryID AS objectID\n FROM wcf1_github_repository github_repository\n LEFT JOIN wcf1_github_commit commit\n ON (commit.repositoryID = github_repository.repositoryID AND commit.committerTime = github_repository.lastCommitTime)\n WHERE github_repository.repositoryID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND github_repository.isDisabled = ? AND lastCommitTime > ?\n ORDER BY repositoryID DESC, github_repository.repositoryID DESC LIMIT 20 OFFSET 20",20,20]},{"file":"\/www\/htdocs\/w00ddbc3\/yourecom\/lib\/data\/DatabaseObjectList.class.php","line":173,"function":"prepare","class":"wcf\\system\\database\\Database","type":"->","args":["SELECT github_repository.repositoryID AS objectID\n FROM wcf1_github_repository github_repository\n LEFT JOIN wcf1_github_commit commit\n ON (commit.repositoryID = github_repository.repositoryID AND commit.committerTime = github_repository.lastCommitTime)\n WHERE github_repository.repositoryID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND github_repository.isDisabled = ? AND lastCommitTime > ?\n ORDER BY repositoryID DESC, github_repository.repositoryID DESC",20,20]},{"file":"\/www\/htdocs\/w00ddbc3\/yourecom\/lib\/data\/github\/repository\/AccessibleGithubRepositoryList.class.php","line":54,"function":"readObjectIDs","class":"wcf\\data\\DatabaseObjectList","type":"->","args":[]},{"file":"\/www\/htdocs\/w00ddbc3\/yourecom\/lib\/page\/MultipleLinkPage.class.php","line":179,"function":"readObjects","class":"wcf\\data\\github\\repository\\AccessibleGithubRepositoryList","type":"->","args":[]},{"file":"\/www\/htdocs\/w00ddbc3\/yourecom\/lib\/page\/MultipleLinkPage.class.php","line":140,"function":"readObjects","class":"wcf\\page\\MultipleLinkPage","type":"->","args":[]},{"file":"\/www\/htdocs\/w00ddbc3\/yourecom\/lib\/page\/SortablePage.class.php","line":64,"function":"readData","class":"wcf\\page\\MultipleLinkPage","type":"->","args":[]},{"file":"\/www\/htdocs\/w00ddbc3\/yourecom\/lib\/page\/AbstractPage.class.php","line":335,"function":"readData","class":"wcf\\page\\SortablePage","type":"->","args":[]},{"file":"\/www\/htdocs\/w00ddbc3\/yourecom\/lib\/page\/AbstractPage.class.php","line":124,"function":"show","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/www\/htdocs\/w00ddbc3\/yourecom\/lib\/system\/request\/Request.class.php","line":54,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/www\/htdocs\/w00ddbc3\/yourecom\/lib\/http\/middleware\/HandleValinorMappingErrors.class.php","line":35,"function":"handle","class":"wcf\\system\\request\\Request","type":"->","args":["Laminas\\Diactoros\\ServerRequest"]},{"file":"\/www\/htdocs\/w00ddbc3\/yourecom\/lib\/system\/request\/RequestHandler.class.php","line":168,"function":"process","class":"wcf\\http\\Pipeline","type":"->","args":["Laminas\\Diactoros\\ServerRequest","wcf\\http\\RequestHandlerMiddleware"]},{"file":"\/www\/htdocs\/w00ddbc3\/yourecom\/index.php","line":10,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf"]}]