Recent Topics

Merging two sites into a third.

started by on Jun 06, 2017 – Last touched: Jun 15, 2017

Jun 06, 2017 12:38    

I am running with b2evolution 4.1.4. It has about eleven years of statistics in it's hit log. I have not been able to delete them. I have tried to run a scheduled task to autoprune old hits and sessions. It errors out saying: "Messages: [Error code: 2 ] Auto pruning is not set to run as a scheduled task"

I was able to successfully back up the site by skipping Logs & stats tables. If I try to back up the log stats, it simply times out.

I am also running with b2evolution 6.7.4-stable. It contain some of the postings from

In attempting to restore to, encountered the error:
`An unexpected error has occurred!
If this error persists, please report it to the administrator.
Go back to home page
Additional information about this error:

MySQL error!
Table 'jultho_b2evo.evo_hitlog' doesn't exist(Errno=1146)
Your query:
ALTER TABLE evo_hitlog

            ADD COLUMN hit_disp        VARCHAR(30) DEFAULT NULL AFTER hit_uri,
            ADD COLUMN hit_ctrl        VARCHAR(30) DEFAULT NULL AFTER hit_disp,
            ADD COLUMN hit_response_code     INT DEFAULT NULL AFTER hit_agent_type`

What is the easiest way to fix this?

Thank you.


PS All three sites are on the same VPS and I have root access.

Jun 07, 2017 00:39

You can truncate (meaning "brutal way to empty the table") the log and session table through mysql management tools such as PhpMySQL that may be provided by your host. Is it a CPanel VPS?

Once those big tables are truncated, backups should be easy.

Then you should probably upgrade all sites to the latest version.

Then I'm not sure what you are trying to do with merging or with " attempting to restore to "

This post has 2 feedbacks awaiting moderation...

Form is loading...

powered by b2evolution – This forum is powered by b2evolution CMS, a complete engine for your website.