UserAction Update groups

xXSwainXx · Dec 24th 2022

Hallo ich programmiere gerade eine Verifizierung

Ich versuche derzeit bei dem UserAction 'update' event die gruppen zu setzen aber irgendwie bekomme ich die ganze zeit den Fehler SQLSTATE[HY093]: Invalid parameter number

PHP

if (!empty($response)) {
            $getData = json_decode($response, true);
            $this->minecraftName = $getData['name'];
            $this->uuid = $getData['uuid'];
            $rankID = $getData['forumRankId'];

            curl_close($curl); 

            $data = [
                'isVerified' => 1,
                'uuid' => $this->uuid,
                'mcName' => $this->minecraftName,
                'username' => $this->minecraftName
            ];

            $this->objectAction = new UserAction([WCF::getUser()], 'update', [
                'data' => array_merge($this->additionalFields, $data),
                'groups' => array($rankID)
            ]);
            $this->objectAction->executeAction();

            UserProfileHandler::getInstance()->reloadUserProfile();

            $this->saved();

            // show success message
            WCF::getTPL()->assign('success', true);

Display More

Fehlermeldung

Requested URL: POST /verify/minecraft/

Referrer: https://maybemc.net/verify/minecraft/

Error Message: Could not execute statement 'SELECT user_rank.rankID FROM wcf1_user_rank user_rank LEFT JOIN wcf1_user_group user_group ON (user_group.groupID = user_rank.groupID) WHERE user_rank.groupID IN (?) AND user_rank.requiredPoints <= ? AND user_rank.requiredGender IN (?,?) ORDER BY user_group.priority DESC, user_rank.requiredPoints DESC, user_rank.requiredGender DESC LIMIT 1'

Type: wcf\system\database\exception\DatabaseQueryExecutionException

File (Line): /home/maybemk/forum/lib/system/database/statement/PreparedStatement.class.php (105)

Query Parameter 1: 875

Query Parameter 2: 0

Query Parameter 3: '1'

Stacktrace

/home/maybemk/forum/lib/data/user/UserProfileAction.class.php (378): wcf\system\database\statement\PreparedStatement->execute(…)
/home/maybemk/forum/lib/data/AbstractDatabaseObjectAction.class.php (204): wcf\data\user\UserProfileAction->updateUserRank(…)
/home/maybemk/forum/lib/data/user/UserAction.class.php (475): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
/home/maybemk/forum/lib/data/AbstractDatabaseObjectAction.class.php (204): wcf\data\user\UserAction->addToGroups(…)
/home/maybemk/forum/lib/data/user/UserAction.class.php (345): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
/home/maybemk/forum/lib/data/AbstractDatabaseObjectAction.class.php (204): wcf\data\user\UserAction->update(…)
/home/maybemk/forum/verify/lib/form/MinecraftVerifyForm.class.php (109): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
/home/maybemk/forum/lib/form/AbstractForm.class.php (62): minecraft\form\MinecraftVerifyForm->save(…)
/home/maybemk/forum/lib/form/AbstractForm.class.php (123): wcf\form\AbstractForm->submit(…)
/home/maybemk/forum/lib/page/AbstractPage.class.php (291): wcf\form\AbstractForm->readData(…)
/home/maybemk/forum/verify/lib/form/MinecraftVerifyForm.class.php (140): wcf\page\AbstractPage->show(…)
/home/maybemk/forum/lib/page/AbstractPage.class.php (114): minecraft\form\MinecraftVerifyForm->show(…)
/home/maybemk/forum/lib/system/request/Request.class.php (83): wcf\page\AbstractPage->__run(…)
/home/maybemk/forum/lib/system/request/RequestHandler.class.php (109): wcf\system\request\Request->execute(…)
/home/maybemk/forum/verify/index.php (11): wcf\system\request\RequestHandler->handle(…)

Error Message: SQLSTATE[HY093]: Invalid parameter number

Type: PDOException

File (Line): /home/maybemk/forum/lib/system/database/statement/PreparedStatement.class.php (93)

Stacktrace

/home/maybemk/forum/lib/system/database/statement/PreparedStatement.class.php (93): PDOStatement->execute(…)
/home/maybemk/forum/lib/data/user/UserProfileAction.class.php (378): wcf\system\database\statement\PreparedStatement->execute(…)
/home/maybemk/forum/lib/data/AbstractDatabaseObjectAction.class.php (204): wcf\data\user\UserProfileAction->updateUserRank(…)
/home/maybemk/forum/lib/data/user/UserAction.class.php (475): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
/home/maybemk/forum/lib/data/AbstractDatabaseObjectAction.class.php (204): wcf\data\user\UserAction->addToGroups(…)
/home/maybemk/forum/lib/data/user/UserAction.class.php (345): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
/home/maybemk/forum/lib/data/AbstractDatabaseObjectAction.class.php (204): wcf\data\user\UserAction->update(…)
/home/maybemk/forum/verify/lib/form/MinecraftVerifyForm.class.php (109): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
/home/maybemk/forum/lib/form/AbstractForm.class.php (62): minecraft\form\MinecraftVerifyForm->save(…)
/home/maybemk/forum/lib/form/AbstractForm.class.php (123): wcf\form\AbstractForm->submit(…)
/home/maybemk/forum/lib/page/AbstractPage.class.php (291): wcf\form\AbstractForm->readData(…)
/home/maybemk/forum/verify/lib/form/MinecraftVerifyForm.class.php (140): wcf\page\AbstractPage->show(…)
/home/maybemk/forum/lib/page/AbstractPage.class.php (114): minecraft\form\MinecraftVerifyForm->show(…)
/home/maybemk/forum/lib/system/request/Request.class.php (83): wcf\page\AbstractPage->__run(…)
/home/maybemk/forum/lib/system/request/RequestHandler.class.php (109): wcf\system\request\Request->execute(…)
/home/maybemk/forum/verify/index.php (11): wcf\system\request\RequestHandler->handle(…)

Sat, 24 Dec 2022 10:41:39 +0000
Message: Could not execute statement 'SELECT        user_rank.rankID                 FROM        wcf1_user_rank user_rank                 LEFT JOIN    wcf1_user_group user_group                 ON        (user_group.groupID = user_rank.groupID)                 WHERE user_rank.groupID IN (?) AND user_rank.requiredPoints <= ? AND user_rank.requiredGender IN (?,?)                 ORDER BY    user_group.priority DESC, user_rank.requiredPoints DESC, user_rank.requiredGender DESC LIMIT 1'
PHP version: 7.4.29
WoltLab Suite version: 5.3.25
Request URI: POST /verify/minecraft/
Referrer: https://maybemc.net/verify/minecraft/
User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36
Peak Memory Usage: 7451896/536870912
======
Error Class: wcf\system\database\exception\DatabaseQueryExecutionException
Error Message: Could not execute statement 'SELECT        user_rank.rankID                 FROM        wcf1_user_rank user_rank                 LEFT JOIN    wcf1_user_group user_group                 ON        (user_group.groupID = user_rank.groupID)                 WHERE user_rank.groupID IN (?) AND user_rank.requiredPoints <= ? AND user_rank.requiredGender IN (?,?)                 ORDER BY    user_group.priority DESC, user_rank.requiredPoints DESC, user_rank.requiredGender DESC LIMIT 1'
Error Code: HY093
File: /home/maybemk/forum/lib/system/database/statement/PreparedStatement.class.php (105)
Extra Information: YTozOntpOjA7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDEiO2k6MTtpOjg3NTt9aToxO2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciAyIjtpOjE7aTowO31pOjI7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDMiO2k6MTtzOjM6IicxJyI7fX0=
Stack Trace: [{"file":"\/home\/maybemk\/forum\/lib\/data\/user\/UserProfileAction.class.php","line":378,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[["[redacted]","[redacted]","[redacted]"]]},{"file":"\/home\/maybemk\/forum\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"updateUserRank","class":"wcf\\data\\user\\UserProfileAction","type":"->","args":[]},{"file":"\/home\/maybemk\/forum\/lib\/data\/user\/UserAction.class.php","line":475,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/home\/maybemk\/forum\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"addToGroups","class":"wcf\\data\\user\\UserAction","type":"->","args":[]},{"file":"\/home\/maybemk\/forum\/lib\/data\/user\/UserAction.class.php","line":345,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/home\/maybemk\/forum\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"update","class":"wcf\\data\\user\\UserAction","type":"->","args":[]},{"file":"\/home\/maybemk\/forum\/verify\/lib\/form\/MinecraftVerifyForm.class.php","line":109,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/home\/maybemk\/forum\/lib\/form\/AbstractForm.class.php","line":62,"function":"save","class":"minecraft\\form\\MinecraftVerifyForm","type":"->","args":[]},{"file":"\/home\/maybemk\/forum\/lib\/form\/AbstractForm.class.php","line":123,"function":"submit","class":"wcf\\form\\AbstractForm","type":"->","args":[]},{"file":"\/home\/maybemk\/forum\/lib\/page\/AbstractPage.class.php","line":291,"function":"readData","class":"wcf\\form\\AbstractForm","type":"->","args":[]},{"file":"\/home\/maybemk\/forum\/verify\/lib\/form\/MinecraftVerifyForm.class.php","line":140,"function":"show","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/home\/maybemk\/forum\/lib\/page\/AbstractPage.class.php","line":114,"function":"show","class":"minecraft\\form\\MinecraftVerifyForm","type":"->","args":[]},{"file":"\/home\/maybemk\/forum\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/home\/maybemk\/forum\/lib\/system\/request\/RequestHandler.class.php","line":109,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/home\/maybemk\/forum\/verify\/index.php","line":11,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["minecraft"]}]
======
Error Class: PDOException
Error Message: SQLSTATE[HY093]: Invalid parameter number
Error Code: HY093
File: /home/maybemk/forum/lib/system/database/statement/PreparedStatement.class.php (93)
Extra Information: -
Stack Trace: [{"file":"\/home\/maybemk\/forum\/lib\/system\/database\/statement\/PreparedStatement.class.php","line":93,"function":"execute","class":"PDOStatement","type":"->","args":[["[redacted]","[redacted]","[redacted]"]]},{"file":"\/home\/maybemk\/forum\/lib\/data\/user\/UserProfileAction.class.php","line":378,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[["[redacted]","[redacted]","[redacted]"]]},{"file":"\/home\/maybemk\/forum\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"updateUserRank","class":"wcf\\data\\user\\UserProfileAction","type":"->","args":[]},{"file":"\/home\/maybemk\/forum\/lib\/data\/user\/UserAction.class.php","line":475,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/home\/maybemk\/forum\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"addToGroups","class":"wcf\\data\\user\\UserAction","type":"->","args":[]},{"file":"\/home\/maybemk\/forum\/lib\/data\/user\/UserAction.class.php","line":345,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/home\/maybemk\/forum\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"update","class":"wcf\\data\\user\\UserAction","type":"->","args":[]},{"file":"\/home\/maybemk\/forum\/verify\/lib\/form\/MinecraftVerifyForm.class.php","line":109,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/home\/maybemk\/forum\/lib\/form\/AbstractForm.class.php","line":62,"function":"save","class":"minecraft\\form\\MinecraftVerifyForm","type":"->","args":[]},{"file":"\/home\/maybemk\/forum\/lib\/form\/AbstractForm.class.php","line":123,"function":"submit","class":"wcf\\form\\AbstractForm","type":"->","args":[]},{"file":"\/home\/maybemk\/forum\/lib\/page\/AbstractPage.class.php","line":291,"function":"readData","class":"wcf\\form\\AbstractForm","type":"->","args":[]},{"file":"\/home\/maybemk\/forum\/verify\/lib\/form\/MinecraftVerifyForm.class.php","line":140,"function":"show","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/home\/maybemk\/forum\/lib\/page\/AbstractPage.class.php","line":114,"function":"show","class":"minecraft\\form\\MinecraftVerifyForm","type":"->","args":[]},{"file":"\/home\/maybemk\/forum\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/home\/maybemk\/forum\/lib\/system\/request\/RequestHandler.class.php","line":109,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/home\/maybemk\/forum\/verify\/index.php","line":11,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["minecraft"]}]

und die json die ich bekomme sieht so aus:

JSON

{
    "uuid": "06b8f220-a924-4b4e-81d6-7b5cbf510086",
    "name": "xXSwainXx",
    "rankName": "admin",
    "rankColor": "§4",
    "forumRankId": 69
}

Kann mir da jemand helfen?

itsmeJAY · Dec 24th 2022

Vielleicht sehe ich das auf den ersten Blick falsch, aber die uuid wird doch nicht mit der deines Benutzers übereinstimmen, oder?

Die uuid aus dem Response

Quote from xXSwainXx

"uuid": "06b8f220-a924-4b4e-81d6-7b5cbf51008

nutzt du derzeit für die Action:

Quote from xXSwainXx

$this->uuid = $getData['uuid'];

// ach, ich schätze du pflegst noch eine separate uuid?

xXSwainXx · Dec 24th 2022

Quote from itsmeJAY

// ach, ich schätze du pflegst noch eine separate uuid?

ja das ist die uuid von einem Spiel bei mir funktionier alles bis auf das mit dem rang setzen

Hanashi · Dec 25th 2022

Hallo,

was mir auffällt: warum ist in deinem Beispiel in Zeile 7 ein curl_close? Falls du irgendwo einen HTTP-Request machst, nutze am besten Guzzle. Außerdem nutze am besten wcf\util\JSON::decode anstatt json_decode.

xXSwainXx · Dec 29th 2022

Danke für die Info

Nur hilft mir das immer noch ned ganz bei meinem Problem

**Tim Düsterhus** · Jan 2nd 2023

Hallo,

die Fehlermeldung kommt daher, dass der Benutzer in keiner Gruppe mehr ist. Bei UserAction::update() müssen auch die Standardgruppen (inkl. Jeder) manuell gesetzt werden. Ich empfehle addToGroups stattdessen. Außerdem vermute ich, dass die ID 69 keine gültige Gruppen-ID ist, sonst hätte der Benutzer noch eine Gruppe.

xXSwainXx · Jan 2nd 2023

Quote from Tim Düsterhus

Ich empfehle addToGroups stattdessen.

Hey ich habe jetzt wie empfohlen addToGroups hinzugefügt nur leider ändert sich da auch nichts... ich bekomme keinen Rang dazu

Der Code:

PHP

            $this->objectAction = new UserAction([WCF::getUser()], 'update', [
                'data' => array_merge($this->additionalFields, $data)
            ]);
            $this->objectAction->executeAction();

            $this->groupAction = new UserAction([WCF::getUser()], 'addToGroups', [
                'groups' => array($rankID),
                'addDefaultGroups' => true
            ]);
            $this->groupAction->executeAction();
            wcfDebug(array($rankID));

Display More

der Debug sieht so aus:

was mache ich falsch?

**Tim Düsterhus** · Jan 2nd 2023

Hallo,

die Gruppe mit ID 3 ist die „Registrierte Benutzer“-Gruppe, das ist vermutlich die falsche.

xXSwainXx · Jan 2nd 2023

Quote from Tim Düsterhus

die Gruppe mit ID 3 ist die „Registrierte Benutzer“-Gruppe, das ist vermutlich die falsche.

Ouh xD habe fehler in meiner Config gehabt jetzt geht es vielen dank

UserAction Update groups

Participate now!

Share