Hello,
I was creating a staging version of my website paradigmshift.com.pk but it failed twice. I asked Cloudways, my host, to check it out from the backend andd they told me it is related to wpforo plugin.
They said:
The staging app creation was failed as the MYSQL dump for the main site could not be created and was aborted due to sudden change in DB.
In detail it was this particular table:
Table definition has changed, please retry transaction when dumping table `kqd_wpforo_visits`
The second time I tried, the same thing happened. I asked for the logs and they sent me this for you:
You can share these exact logs with them:
able definition has changed, please retry transaction when dumping table `kqd_wpforo_visits` at row: 0\n"}}, "status": -81, "task_info": {"playbook_name": ***, "playbook_path": "N/A", "task_name": ***, "task_result": "FAILED", "ignore_errors": false, "run_state": "FAILED_HOSTS", "pre_run_state": "OK", "post_run_state": "OK", "uid": "a786ae12-1272-4940-8627-2fd9336e9db0"}} )
Hi @hbk747 ,
The problem you're facing with is a migration issue, it doesn't have any relation to the wpForo forum plugin support. I'm sorry, but we don't know what steps you are during, and we cannot provide any solution for your website cloning.
The issue you are facing with staging creation failing due to the MySQL dump error on the table `kqd_wpforo_visits` is related to the wpForo plugin's visits table being modified during the dump process. This causes the "Table definition has changed, please retry transaction" error.
This can happen if there are ongoings writes or changes to that table while the database dump is running, which is common for visit or statistics tables that update frequently.
So when the WordPress is running it allow runs all wpForo functions, and they use the database. If f you're creating the database during running of WordPress website, then you'll get that error.
As a "try and see if it works" solution I suggest you can either ignore this error, and after the whole migration go to Dashboard > wpForo > Tools > Database Table and click Resolve Database Problems button, or you should disable all options in Dashboard > wpForo > Settings > Action Logging & Views admin page before cloning.
Hello,
I was creating a staging version of my website paradigmshift.com.pk but it failed twice. I asked Cloudways, my host, to check it out from the backend andd they told me it is related to wpforo plugin.
They said:
The staging app creation was failed as the MYSQL dump for the main site could not be created and was aborted due to sudden change in DB.
In detail it was this particular table:
Table definition has changed, please retry transaction when dumping table `kqd_wpforo_visits`
The second time I tried, the same thing happened. I asked for the logs and they sent me this for you:
You can share these exact logs with them:
able definition has changed, please retry transaction when dumping table `kqd_wpforo_visits` at row: 0\n"}}, "status": -81, "task_info": {"playbook_name": , "playbook_path": "N/A", "task_name": , "task_result": "FAILED", "ignore_errors": false, "run_state": "FAILED_HOSTS", "pre_run_state": "OK", "post_run_state": "OK", "uid": "a786ae12-1272-4940-8627-2fd9336e9db0"}} )
I have the same question and I’m running into almost the exact same issue on my texas roadhouse menu website. When trying to create a staging version of my site, the process keeps failing because the MySQL dump aborts due to a change in the wpforo_visits table. My host also pointed out that this specific table is causing the “Table definition has changed, please retry transaction” error, and the staging creation stops midway.
I’m getting similar logs showing the dump failing at kqd_wpforo_visits, and Cloudways also confirmed that the issue appears to be related to wpForo. If anyone from wpForo or anyone who has dealt with this before knows how to handle this table so the staging copy can be created properly, I’d really appreciate any advice.
Hi @benchenk,
Please see my advice above: https://wpforo.com/community/how-to-and-troubleshooting-2/staging-application-website-issue/#post-128684
Hello,
I was creating a staging version of my website paradigmshift.com.pk but it failed twice. I asked Cloudways, my host, to check it out from the backend andd they told me it is related to wpforo plugin.
They said:
The staging app creation was failed as the MYSQL dump for the main site could not be created and was aborted due to sudden change in DB.
In detail it was this particular table:
Table definition has changed, please retry transaction when dumping table `kqd_wpforo_visits`
The second time I tried, the same thing happened. I asked for the logs and they sent me this for you:
You can share these exact logs with them:
able definition has changed, please retry transaction when dumping table `kqd_wpforo_visits` at row: 0\n"}}, "status": -81, "task_info": {"playbook_name": , "playbook_path": "N/A", "task_name": , "task_result": "FAILED", "ignore_errors": false, "run_state": "FAILED_HOSTS", "pre_run_state": "OK", "post_run_state": "OK", "uid": "a786ae12-1272-4940-8627-2fd9336e9db0"}} )
I have the same question and I’m running into almost the exact same issue on my texas roadhouse menu website. When trying to create a staging version of my site, the process keeps failing because the MySQL dump aborts due to a change in the wpforo_visits table. My host also pointed out that this specific table is causing the “Table definition has changed, please retry transaction” error, and the staging creation stops midway.
I’m getting similar logs showing the dump failing at kqd_wpforo_visits, and Cloudways also confirmed that the issue appears to be related to wpForo. If anyone from wpForo or anyone who has dealt with this before knows how to handle this table so the staging copy can be created properly, I’d really appreciate any advice.
Very Very Thanks it got fixed!
