- Betroffene App
- WoltLab Suite Forum
Hello
I'm at the stage of conversion my board from phpBB to WBB. In WBB 4.1.3 (and 4.1.1) Importer is crashing, when it is trying to import watched threads.
Code
Could not execute prepared statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '219-8206-20' for key 'objectTypeID'
Stacktrace:
#0 C:\xampp\htdocs\wbb\wcf\lib\data\DatabaseObjectEditor.class.php(38): wcf\system\database\statement\PreparedStatement->execute(Array)
#1 C:\xampp\htdocs\wbb\wcf\lib\system\importer\AbstractWatchedObjectImporter.class.php(34): wcf\data\DatabaseObjectEditor::create(Array)
#2 C:\xampp\htdocs\wbb\lib\system\importer\WatchedThreadImporter.class.php(33): wcf\system\importer\AbstractWatchedObjectImporter->import(0, Array)
#3 C:\xampp\htdocs\wbb\wcf\lib\system\exporter\PhpBB3xExporter.class.php(986): wbb\system\importer\WatchedThreadImporter->import(0, Array)
#4 [internal function]: wcf\system\exporter\PhpBB3xExporter->exportWatchedThreads(0, 1000)
#5 C:\xampp\htdocs\wbb\wcf\lib\system\exporter\AbstractExporter.class.php(154): call_user_func(Array, 0, 1000)
#6 C:\xampp\htdocs\wbb\wcf\lib\system\worker\ImportWorker.class.php(97): wcf\system\exporter\AbstractExporter->exportData('com.woltlab.wbb...', 0)
#7 C:\xampp\htdocs\wbb\wcf\lib\acp\action\WorkerProxyAction.class.php(93): wcf\system\worker\ImportWorker->execute()
#8 C:\xampp\htdocs\wbb\wcf\lib\action\AbstractAction.class.php(49): wcf\acp\action\WorkerProxyAction->execute()
#9 C:\xampp\htdocs\wbb\wcf\lib\action\AJAXInvokeAction.class.php(63): wcf\action\AbstractAction->__run()
#10 C:\xampp\htdocs\wbb\wcf\lib\system\request\Request.class.php(58): wcf\action\AJAXInvokeAction->__run()
#11 C:\xampp\htdocs\wbb\wcf\lib\system\request\RequestHandler.class.php(139): wcf\system\request\Request->execute()
#12 C:\xampp\htdocs\wbb\acp\index.php(10): wcf\system\request\RequestHandler->handle('wbb', true)
#13 {main}
Alles anzeigen
Crash is happening right on start of watched threads import process (0%). After closing error window progress bar stays at 0%
Crash is repeatable for me - at every import attepmt crash is present, but it can be avoided simply by not converting watched threads.
This can be related to my database - my board is very old and it was already converted few years ago from phpBB2 to phpBB3. There were also some situations when some users wanted to delete their accounts and in database there can be some leftovers...