update the counters error

rotti3 · Oct 9th 2015

After successful importing all data from vBulletin Version 4.2.3 to WBB when I try to run "worker wbb\\system\\worker\\PostRebuildDataWorker" or worker wbb\\system\\worker\\ThreadRebuildDataWorker I get the following error:

Code

Username> XXXXXXX
Password> XXXXXXXXX
>worker wcf\\system\\worker\\LikeRebuildDataWorker
100% [##########################################################################################################################################################################################################################################################]            
>worker wcf\\system\\worker\\LikeUserRebuildDataWorker
100% [##########################################################################################################################################################################################################################################################] ETA 00:00:00
>worker wbb\\system\\worker\\PostRebuildDataWorker
  0% [----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------]             [ERROR]
exception 'wcf\system\exception\SystemException' with message 'PHP notice in file /home/om77/public_html/forums/lib/system/worker/PostRebuildDataWorker.class.php (145): Trying to get property of non-object' in /home/om77/public_html/forums/wcf/lib/system/WCF.class.php:309
Stack trace:
#0 /home/om77/public_html/forums/lib/system/worker/PostRebuildDataWorker.class.php(145): wcf\system\WCF::handleError(8, 'Trying to get p...', '/home/om77/publ...', 145, Array)
#1 /home/om77/public_html/forums/wcf/lib/system/cli/command/WorkerCLICommand.class.php(123): wbb\system\worker\PostRebuildDataWorker->execute()
#2 /home/om77/public_html/forums/wcf/lib/system/CLIWCF.class.php(281): wcf\system\cli\command\WorkerCLICommand->execute(Array)
#3 /home/om77/public_html/forums/wcf/lib/system/CLIWCF.class.php(92): wcf\system\CLIWCF->initCommands()
#4 /home/om77/public_html/forums/wcf/cli.php(18): wcf\system\CLIWCF->__construct()
#5 {main}
[WARN] Previous command had an open transaction.
>worker wbb\\system\\worker\\PostRebuildDataWorker
  0% [----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------]             [ERROR]
exception 'wcf\system\exception\SystemException' with message 'PHP notice in file /home/om77/public_html/forums/lib/system/worker/PostRebuildDataWorker.class.php (145): Trying to get property of non-object' in /home/om77/public_html/forums/wcf/lib/system/WCF.class.php:309
Stack trace:
#0 /home/om77/public_html/forums/lib/system/worker/PostRebuildDataWorker.class.php(145): wcf\system\WCF::handleError(8, 'Trying to get p...', '/home/om77/publ...', 145, Array)
#1 /home/om77/public_html/forums/wcf/lib/system/cli/command/WorkerCLICommand.class.php(123): wbb\system\worker\PostRebuildDataWorker->execute()
#2 /home/om77/public_html/forums/wcf/lib/system/CLIWCF.class.php(281): wcf\system\cli\command\WorkerCLICommand->execute(Array)
#3 /home/om77/public_html/forums/wcf/lib/system/CLIWCF.class.php(92): wcf\system\CLIWCF->initCommands()
#4 /home/om77/public_html/forums/wcf/cli.php(18): wcf\system\CLIWCF->__construct()
#5 {main}
[WARN] Previous command had an open transaction.
>

Display More

Please help on this as my site is offline I can't go online before this is solved.

Morik · Oct 9th 2015

Any problems with the import iteself ?

rotti3 · Oct 9th 2015

nope it worked smoothly to the end all data is on the DB.

Morik · Oct 9th 2015

And if you use the ACP for this worker you get the same error ?

rotti3 · Oct 9th 2015

Yes same

Morik · Oct 9th 2015

Please run the following command via your database:

SQL

SELECT * FROM wbb1_post WHERE threadID NOT IN (SELECT threadID FROM wbb1_thread)

It should show no results, but if there are any we know why you have those problems

rotti3 · Oct 9th 2015

MySQL returned an empty result set (i.e. zero rows). (Query took 43.6887 sec) no rows

Morik · Oct 9th 2015

Try the same for threads:

SQL

SELECT * FROM wbb1_thread WHERE boardID NOT IN (SELECT boardID FROM wbb1_board)

rotti3 · Oct 9th 2015

MySQL returned an empty result set (i.e. zero rows). (Query took 1.0458 sec) same no issue

Morik · Oct 9th 2015

well, in this case i have no idea whats going wrong with your installation...
Maybe its best for you to write a ticket.

rotti3 · Oct 9th 2015

Thank you for trying to help.

I see few others had the same issue:

https://translate.google.com/translate?hl=en&sl=de&u=https://community.woltlab.com/thread/231052-cli-import-threadrebuilddataworker-error/&prev=search

https://translate.googleusercontent.com/translate_c?depth=1&hl=en&prev=search&rurl=translate.google.com&sl=de&u=https://community.woltlab.com/thread/217090-nach-import-anzeige-beitr%25C3%25A4ge-und-themen-aktualisieren/%3FpostID%3D42299%26highlight%3Danzeige%26s%3Dba1853e86540987b88f5b0b2abd7cfb5edbd9462&usg=ALkJrhhc-nk9TF86T3Tp4KEXaJjnDaY2Cg#post42299

Morik · Oct 9th 2015

Seams to be a random bug which is not propperly to identify.

SQL

SELECT * FROM wbb1_thread WHERE boardID = NULL

SQL

SELECT * FROM wbb1_post WHERE threadID = NULL

Give this 2 requests a last try, if they don't find any unassigned thread or post i can't help you (It's basically what @Marcel Werk suggestet in the first thread you linked )

rotti3 · Oct 10th 2015

Both above commands returned 0
MySQL returned an empty result set (i.e. zero rows). (Query took 0.0003 sec)

I was able to solve and run them now only after running worker wcf\\system\\worker\\StatDailyRebuildDataWorke which took almost 9 hours.

Thank you

update the counters error

Participate now!

Share

Tags