Could not prepare statement 'UPDATE wcf1_gdpr_export_log SET ipAddress = ? WHERE time <= ?'

FreeFun · January 22, 2022 at 2:02 PM

Hallo,

meine WSC Installation wirft seit neusten diesen Fehler aus.

Da neben dem WSC Update auch Plugins Neuinstalliert werden mussten kann ich nicht genau sagen wobei dieser Fehler entstanden ist.
Bevor ist jetzt stumpf versuche diesen DB hinzuzufügen frage ich hier lieber nochmal nach.

Requested URL

Referrer

Error Message: Could not prepare statement 'UPDATE wcf1_gdpr_export_log SET ipAddress = ? WHERE time <= ?'

Type: wcf\system\database\exception\DatabaseQueryException

File (Line): /usr/www/users/user/domain/hdk/wsc/lib/system/database/Database.class.php (333)

Stacktrace

/usr/www/users/user/domain/wsc/lib/system/cronjob/PruneIpAddressesCronjob.class.php (48): wcf\system\database\Database->prepareStatement(…)
/usr/www/users/user/domain/wsc/lib/system/cronjob/CronjobScheduler.class.php (274): wcf\system\cronjob\PruneIpAddressesCronjob->execute(…)
/usr/www/users/user/domain/wsc/lib/system/cronjob/CronjobScheduler.class.php (75): wcf\system\cronjob\CronjobScheduler->executeCronjob(…)
/usr/www/users/user/domain/wsc/lib/data/cronjob/CronjobAction.class.php (240): wcf\system\cronjob\CronjobScheduler->executeCronjobs(…)
/usr/www/users/user/domain/wsc/lib/data/AbstractDatabaseObjectAction.class.php (216): wcf\data\cronjob\CronjobAction->executeCronjobs(…)
/usr/www/users/user/domain/wsc/cron.php (18): wcf\data\AbstractDatabaseObjectAction->executeAction(…)

Error Message: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'wcf_hdk.wcf1_gdpr_export_log' doesn't exist

Type: PDOException

File (Line): /usr/www/users/user/domain/wsc/lib/system/database/Database.class.php (328)

Stacktrace

/usr/www/users/user/domain/wsc/lib/system/database/Database.class.php (328): PDO->prepare(…)
/usr/www/users/user/domain/wsc/lib/system/cronjob/PruneIpAddressesCronjob.class.php (48): wcf\system\database\Database->prepareStatement(…)
/usr/www/users/user/domain/wsc/lib/system/cronjob/CronjobScheduler.class.php (274): wcf\system\cronjob\PruneIpAddressesCronjob->execute(…)
/usr/www/users/user/domain/wsc/lib/system/cronjob/CronjobScheduler.class.php (75): wcf\system\cronjob\CronjobScheduler->executeCronjob(…)
/usr/www/users/user/domain/wsc/lib/data/cronjob/CronjobAction.class.php (240): wcf\system\cronjob\CronjobScheduler->executeCronjobs(…)
/usr/www/users/user/domain/wsc/lib/data/AbstractDatabaseObjectAction.class.php (216): wcf\data\cronjob\CronjobAction->executeCronjobs(…)
/usr/www/users/user/domain/wsc/cron.php (18): wcf\data\AbstractDatabaseObjectAction->executeAction(…)

Sat, 22 Jan 2022 03:00:01 +0000
Message: Could not prepare statement 'UPDATE  wcf1_gdpr_export_log                         SET     ipAddress = ?                         WHERE   time <= ?'
PHP version: 8.0.15
WoltLab Suite version: 5.4.10
Request URI:  
Referrer: 
User Agent: 
Peak Memory Usage: 10048712/268435456
======
Error Class: wcf\system\database\exception\DatabaseQueryException
Error Message: Could not prepare statement 'UPDATE  wcf1_gdpr_export_log                         SET     ipAddress = ?                         WHERE   time <= ?'
Error Code: 42S02
File: /usr/www/users/user/domain/hdk/wsc/lib/system/database/Database.class.php (333)
Extra Information: -
Stack Trace: [{"file":"\/usr\/www\/users\/user\/domain\/wsc\/lib\/system\/cronjob\/PruneIpAddressesCronjob.class.php","line":48,"function":"prepareStatement","class":"wcf\\system\\database\\Database","type":"->","args":[]},{"file":"\/usr\/www\/users\/user\/domain\/wsc\/lib\/system\/cronjob\/CronjobScheduler.class.php","line":274,"function":"execute","class":"wcf\\system\\cronjob\\PruneIpAddressesCronjob","type":"->","args":[]},{"file":"\/usr\/www\/users\/user\/domain\/wsc\/lib\/system\/cronjob\/CronjobScheduler.class.php","line":75,"function":"executeCronjob","class":"wcf\\system\\cronjob\\CronjobScheduler","type":"->","args":[]},{"file":"\/usr\/www\/users\/user\/domain\/wsc\/lib\/data\/cronjob\/CronjobAction.class.php","line":240,"function":"executeCronjobs","class":"wcf\\system\\cronjob\\CronjobScheduler","type":"->","args":[]},{"file":"\/usr\/www\/users\/user\/domain\/wsc\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":216,"function":"executeCronjobs","class":"wcf\\data\\cronjob\\CronjobAction","type":"->","args":[]},{"file":"\/usr\/www\/users\/user\/domain\/wsc\/cron.php","line":18,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]}]
======
Error Class: PDOException
Error Message: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'wcf_hdk.wcf1_gdpr_export_log' doesn't exist
Error Code: 42S02
File: /usr/www/users/user/domain/wsc/lib/system/database/Database.class.php (328)
Extra Information: -
Stack Trace: [{"file":"\/usr\/www\/users\/user\/domain\/wsc\/lib\/system\/database\/Database.class.php","line":328,"function":"prepare","class":"PDO","type":"->","args":[]},{"file":"\/usr\/www\/users\/user\/domain\/wsc\/lib\/system\/cronjob\/PruneIpAddressesCronjob.class.php","line":48,"function":"prepareStatement","class":"wcf\\system\\database\\Database","type":"->","args":[]},{"file":"\/usr\/www\/users\/user\/domain\/wsc\/lib\/system\/cronjob\/CronjobScheduler.class.php","line":274,"function":"execute","class":"wcf\\system\\cronjob\\PruneIpAddressesCronjob","type":"->","args":[]},{"file":"\/usr\/www\/users\/user\/domain\/wsc\/lib\/system\/cronjob\/CronjobScheduler.class.php","line":75,"function":"executeCronjob","class":"wcf\\system\\cronjob\\CronjobScheduler","type":"->","args":[]},{"file":"\/usr\/www\/users\/user\/domain\/wsc\/lib\/data\/cronjob\/CronjobAction.class.php","line":240,"function":"executeCronjobs","class":"wcf\\system\\cronjob\\CronjobScheduler","type":"->","args":[]},{"file":"\/usr\/www\/users\/user\/domain\/wsc\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":216,"function":"executeCronjobs","class":"wcf\\data\\cronjob\\CronjobAction","type":"->","args":[]},{"file":"\/usr\/www\/users\/user\/domain\/wsc\/cron.php","line":18,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]}]

Beste Grüße
FreeFun

Krymonota · January 22, 2022 at 2:38 PM

Quote from FreeFun

wcf1_gdpr_export_log

Diese Datenbanktabelle ist nicht Bestandteil des WoltLab Suite Core. Hast du irgendein Plugin installiert, das ein Protokoll für Exports von Benutzerdaten führt?

SoftCreatR · January 22, 2022 at 2:41 PM

Ja, das Export-Frontend. Am besten einfach neu installieren, da offensichtlich eine Tabelle abhanden gekommen ist.

FreeFun · January 22, 2022 at 2:42 PM

Quote from Krymonota

Hast du irgendein Plugin installiert, das ein Protokoll für Exports von Benutzerdaten führt?

Nur das von Softi das DSGVO Daten-Export-Frontend Plugin. Das musste ja neu installiert werden.

Dann hau ich mal SoftCreatR an ob er mir da ein Tipp geben kann.

Nachtrag:

Quote from SoftCreatR

Ja, das Export-Frontend. Am besten einfach neu installieren, da offensichtlich eine Tabelle abhanden gekommen ist.

Okay dann mach ich das nochmal. Danke

Could not prepare statement 'UPDATE wcf1_gdpr_export_log SET ipAddress = ? WHERE time <= ?'

Participate now!

Similar Threads

Seit Update auf 5.4 jeden Tag Datenbankfehler

Verlinkte YT Videos verursachen Fehlermeldung

Paket-Aktualisierung 5.3.5 schlägt fehl

DatabaseQueryException seit Update auf 3.1.19 am 01.02.