• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.5 7 year migration since 2010

#1
I have waited 7 years in order to finally pluck up the courage and move from VB3 to XF

I did a test run and was able to migrate in under 20 hours !

1. First thing I have noticed not working is that the tanks have not been converted to likes, should they have?
2. I got this error after finalising the import and at the rebuilding indexes etc stage: Mysqli statement execute error : Duplicate entry '574522' for key 'PRIMARY'Yesterday at 4:41 AM - library/Zend/Db/Statement/Mysqli.php:21 (I have a ticket open for this, note both forums were in 'shutdown' state)
3. This may not be posted in the right area but I had a third party Haddon for which I have searched resources on here but none actually work. Has anyone been successful with VBSEO like import to XF?

Any help would be appreciated....
 
#3
Hi Jake,

1) I ran the sql command successfully (just had to make sure privileges were correct as we have two access going on) - the rebuild.php crashes out

Code:
Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator to inform of the time the error occurred and of anything you might have done that may have caused the error.

More information about this error may be available in the server error log.
2) i'll try again

3) it was the 'vbseo LIKES' i wanted converting also not anything else as that is old hat now.
 
#4
The server error log:

Code:
2017-09-02 08:57:03    Access    82.6.39.58    200    POST /index.php?login/csrf-token-refresh HTTP/1.1       562    Apache access
2017-09-02 08:57:23    Warning    82.6.39.58        mod_fcgid: read data timeout in 30 seconds                Apache error
2017-09-02 08:57:23    Error    82.6.39.58        Premature end of script headers: rebuildlikes.php
 
#5
I took these steps:

1. check php version and change from 5.3.17 to 5.6
2. changed the php setting max_execution_time to 120
3. edited /etc/httpd/conf.d/fcgid.conf to set FcgidIOTimeout from 45 to 600
4. restarted httpd

I now get: "Rebuilding like totals for users . . . An unexpected database error occurred. Please try again later."

or

Code:
Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator to inform of the time the error occurred and of anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

mysqld.log shows nothing :(

im now out of ideas - help
 
Last edited:
#7
LOL - that is indeed what the error message tells me. I have looked at all the logs and find nothing/taken steps to address - did you miss my server log posted above?
 
#10
found this:

Code:
Server Error Log
Error Info
Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Deadlock found when trying to get lock; try restarting transaction - library/Zend/Db/Statement/Mysqli.php:214
Generated By: Unknown Account, Today at 12:42 AM
Stack Trace
#0 /var/www/vhosts/xxx/forums.xxx/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /var/www/vhosts/xxx/forums.xxx/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /var/www/vhosts/xxx/forums.xxx/rebuildlikes.php(39): Zend_Db_Adapter_Abstract->query('\n\tUPDATE xf_use...')
#3 {main}
Request State
array(3) {
  ["url"] => string(43) "http://forums.xxx/rebuildlikes.php"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(0) {
  }
}
 

Jake Bunce

XenForo moderator
Staff member
#11
Deadlocks can happen as a matter of course. See these posts by Mike:

https://xenforo.com/community/threads/fatal-deadlock-when-upgrading.23471/#post-290271

https://xenforo.com/community/threads/vb-3-8-xf-via-cli-importer-discrepancies.27794/#post-327157

It may help to temporarily turn off your XF forum while running the rebuildlikes script. The idea is to limit database activity during the rebuild.

3) it was the 'vbseo LIKES' i wanted converting also not anything else as that is old hat now.
Here is a query for vBSEO likes:

https://xenforo.com/community/threads/vbseo-like-İmporter.56503/#post-692575
 
#12
Thanks Jake.... the query for vBSEO likes works and I had no issue with that. it's the rebuild script that is failing, and those are the deadlock messages. forums are closed. It seems everyone has become mixed up on my questions. I will if I have questions then I will post one thread per topic (after searching of course)

Rebuilding like totals for users . . . An unexpected database error occurred. Please try again later.