RC1 - import from xenforo to Woltlab -- Watched threads

Aslan · February 17, 2015 at 12:58 AM

I believe this happened when importing attachment. I recall it importing the forums without issue and post and users and avatars all without issue. The last thing I recall was it was on attachments, I stepped out of the room and found this upon my return.

edit: I was wrong. It got stuck on "Watched Threads" (made it to 76%)

PHP

Could not execute prepared statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '219-10485-1063' for key 'objectTypeID'




Stacktrace:
#0 /usr/share/nginx/sociallyuncensored.net/public_html/wcf/lib/data/DatabaseObjectEditor.class.php(38): wcf\system\database\statement\PreparedStatement->execute(Array)
#1 /usr/share/nginx/sociallyuncensored.net/public_html/wcf/lib/system/importer/AbstractWatchedObjectImporter.class.php(34): wcf\data\DatabaseObjectEditor::create(Array)
#2 /usr/share/nginx/sociallyuncensored.net/public_html/lib/system/importer/WatchedThreadImporter.class.php(33): wcf\system\importer\AbstractWatchedObjectImporter->import(0, Array)
#3 /usr/share/nginx/sociallyuncensored.net/public_html/wcf/lib/system/exporter/XF12xExporter.class.php(934): wbb\system\importer\WatchedThreadImporter->import(0, Array)
#4 [internal function]: wcf\system\exporter\XF12xExporter->exportWatchedThreads(13000, 1000)
#5 /usr/share/nginx/sociallyuncensored.net/public_html/wcf/lib/system/exporter/AbstractExporter.class.php(154): call_user_func(Array, 13000, 1000)
#6 /usr/share/nginx/sociallyuncensored.net/public_html/wcf/lib/system/worker/ImportWorker.class.php(97): wcf\system\exporter\AbstractExporter->exportData('com.woltlab.wbb...', 13)
#7 /usr/share/nginx/sociallyuncensored.net/public_html/wcf/lib/acp/action/WorkerProxyAction.class.php(93): wcf\system\worker\ImportWorker->execute()
#8 /usr/share/nginx/sociallyuncensored.net/public_html/wcf/lib/action/AbstractAction.class.php(49): wcf\acp\action\WorkerProxyAction->execute()
#9 /usr/share/nginx/sociallyuncensored.net/public_html/wcf/lib/action/AJAXInvokeAction.class.php(63): wcf\action\AbstractAction->__run()
#10 /usr/share/nginx/sociallyuncensored.net/public_html/wcf/lib/system/request/Request.class.php(58): wcf\action\AJAXInvokeAction->__run()
#11 /usr/share/nginx/sociallyuncensored.net/public_html/wcf/lib/system/request/RequestHandler.class.php(139): wcf\system\request\Request->execute()
#12 /usr/share/nginx/sociallyuncensored.net/public_html/acp/index.php(10): wcf\system\request\RequestHandler->handle('wbb', true)
#13 {main}

Display More

Aslan · February 17, 2015 at 1:13 AM

^ I was WRONG.

This froze up on "Watched threads"

I have edited the title to reflect this. It got to 76% when it froze.

**Tim Düsterhus** · February 17, 2015 at 1:39 AM Official Post

Hi

could you please execute the following query in your database and attach / post the result:

SQL

SELECT   user_id, thread_id, COUNT(*) AS count
FROM     xf_thread_watch
GROUP BY user_id, thread_id
HAVING   count > 1

Aslan · February 17, 2015 at 1:42 AM

I honestly don't see anything would be wrong with watched threads, but attached is the database entry for it

xf_thread_watch

Aslan · February 17, 2015 at 1:45 AM

Quote from TimWolla
Hi

could you please execute the following query in your database and attach / post the result:
SQL
SELECT   user_id, thread_id, COUNT(*) AS count
FROM     xf_thread_watch
GROUP BY user_id, thread_id
HAVING   count > 1

MySQL returned an empty result set (i.e. zero rows). (Query took 0.0001 seconds.)

**Tim Düsterhus** · February 17, 2015 at 1:48 AM Official Post

Hi

do you import from a live board or from a database dump? Both the code and the database export you attached look fine. I suspect that a member added a subscription to a thread, thus shifting all the later subscriptions dpwn by one, leading to a duplicate import of one subscription.

Edit: Technical correction

Aslan · February 17, 2015 at 1:50 AM

Quote from TimWolla

Hi

do you import from a live board or from a database dump? Both the code and the database export you attached look fine. I suspect that a member removed their subscription to a thread, thus shifting all the later subscriptions up by one, leading to a duplicate import of one subscription.

It was indeed a live site... So perhaps the fault is my own. Don't mark this as "not a bug" just yet... Tonight when its not busy, I'll either do a dump and use that OR close the live site temporarily.

Aslan · February 17, 2015 at 5:55 AM

Well unfortunately, this does appear to be a bug. I could repeat more than once. Had both sites closed too this time. Always at 76% on Watched Threads.

Diff

Could not execute prepared statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '219-10485-1063' for key 'objectTypeID'




Stacktrace:
#0 /usr/share/nginx/sociallyuncensored.net/public_html/wcf/lib/data/DatabaseObjectEditor.class.php(38): wcf\system\database\statement\PreparedStatement->execute(Array)
#1 /usr/share/nginx/sociallyuncensored.net/public_html/wcf/lib/system/importer/AbstractWatchedObjectImporter.class.php(34): wcf\data\DatabaseObjectEditor::create(Array)
#2 /usr/share/nginx/sociallyuncensored.net/public_html/lib/system/importer/WatchedThreadImporter.class.php(33): wcf\system\importer\AbstractWatchedObjectImporter->import(0, Array)
#3 /usr/share/nginx/sociallyuncensored.net/public_html/wcf/lib/system/exporter/XF12xExporter.class.php(934): wbb\system\importer\WatchedThreadImporter->import(0, Array)
#4 [internal function]: wcf\system\exporter\XF12xExporter->exportWatchedThreads(13000, 1000)
#5 /usr/share/nginx/sociallyuncensored.net/public_html/wcf/lib/system/exporter/AbstractExporter.class.php(154): call_user_func(Array, 13000, 1000)
#6 /usr/share/nginx/sociallyuncensored.net/public_html/wcf/lib/system/worker/ImportWorker.class.php(97): wcf\system\exporter\AbstractExporter->exportData('com.woltlab.wbb...', 13)
#7 /usr/share/nginx/sociallyuncensored.net/public_html/wcf/lib/acp/action/WorkerProxyAction.class.php(93): wcf\system\worker\ImportWorker->execute()
#8 /usr/share/nginx/sociallyuncensored.net/public_html/wcf/lib/action/AbstractAction.class.php(49): wcf\acp\action\WorkerProxyAction->execute()
#9 /usr/share/nginx/sociallyuncensored.net/public_html/wcf/lib/action/AJAXInvokeAction.class.php(63): wcf\action\AbstractAction->__run()
#10 /usr/share/nginx/sociallyuncensored.net/public_html/wcf/lib/system/request/Request.class.php(58): wcf\action\AJAXInvokeAction->__run()
#11 /usr/share/nginx/sociallyuncensored.net/public_html/wcf/lib/system/request/RequestHandler.class.php(139): wcf\system\request\Request->execute()
#12 /usr/share/nginx/sociallyuncensored.net/public_html/acp/index.php(10): wcf\system\request\RequestHandler->handle('wbb', true)
#13 {main}

Display More

Aslan · February 18, 2015 at 3:19 AM

Concerning threads, there are the following tables

xf_thread
xf_thread_prefix
xf_thread_prefix_group
xf_thread_read
xf_thread_redirect
xf_thread_reply_ban
xf_thread_user_post
xf_thread_view
xf_thread_watch

One of those is loaded into memory (xf_thread_view). But I don't think that would be an issue.

What I think is perhaps xf_thread_watch would have an association with xf_thread_read because it would seem logical (I believe) for you to keep an eye on what you're watching and haven't yet read would be xf_thread_read (obviously).

So just for good measure I'm attaching that as well.

Aslan · February 18, 2015 at 6:01 AM

@TimWolla I can congratulate you. If I uncheck "watched thread" from the importer... The import completes at 100%.

(which from my standing point is acceptable)

Black Rider · February 18, 2015 at 8:40 PM

For the future: Please use the edit feature to edit your posts instead of posting multiple posts if no one else did write anything.

Aslan · February 28, 2015 at 11:22 PM

I finally got around to testing RC2 import. Same result.

CSS

Could not execute prepared statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '219-10485-1063' for key 'objectTypeID'
Stacktrace:
#0 /usr/share/nginx/sociallyuncensored.net/public_html/wcf/lib/data/DatabaseObjectEditor.class.php(38): wcf\system\database\statement\PreparedStatement->execute(Array)
#1 /usr/share/nginx/sociallyuncensored.net/public_html/wcf/lib/system/importer/AbstractWatchedObjectImporter.class.php(34): wcf\data\DatabaseObjectEditor::create(Array)
#2 /usr/share/nginx/sociallyuncensored.net/public_html/lib/system/importer/WatchedThreadImporter.class.php(33): wcf\system\importer\AbstractWatchedObjectImporter->import(0, Array)
#3 /usr/share/nginx/sociallyuncensored.net/public_html/wcf/lib/system/exporter/XF12xExporter.class.php(934): wbb\system\importer\WatchedThreadImporter->import(0, Array)
#4 [internal function]: wcf\system\exporter\XF12xExporter->exportWatchedThreads(13000, 1000)
#5 /usr/share/nginx/sociallyuncensored.net/public_html/wcf/lib/system/exporter/AbstractExporter.class.php(154): call_user_func(Array, 13000, 1000)
#6 /usr/share/nginx/sociallyuncensored.net/public_html/wcf/lib/system/worker/ImportWorker.class.php(97): wcf\system\exporter\AbstractExporter->exportData('com.woltlab.wbb...', 13)
#7 /usr/share/nginx/sociallyuncensored.net/public_html/wcf/lib/acp/action/WorkerProxyAction.class.php(93): wcf\system\worker\ImportWorker->execute()
#8 /usr/share/nginx/sociallyuncensored.net/public_html/wcf/lib/action/AbstractAction.class.php(49): wcf\acp\action\WorkerProxyAction->execute()
#9 /usr/share/nginx/sociallyuncensored.net/public_html/wcf/lib/action/AJAXInvokeAction.class.php(63): wcf\action\AbstractAction->__run()
#10 /usr/share/nginx/sociallyuncensored.net/public_html/wcf/lib/system/request/Request.class.php(58): wcf\action\AJAXInvokeAction->__run()
#11 /usr/share/nginx/sociallyuncensored.net/public_html/wcf/lib/system/request/RequestHandler.class.php(139): wcf\system\request\Request->execute()
#12 /usr/share/nginx/sociallyuncensored.net/public_html/acp/index.php(10): wcf\system\request\RequestHandler->handle('wbb', true)
#13 {main}

Display More

Black Rider · March 1, 2015 at 11:16 AM

There is no label for “fixed” yet. Thus it hasn't been fixed yet.

Participate now!