Has anyone had success with updating an existing forum from 3.4.7 to 4.0 Beta 2? I get tons of errors. First when converting members. We have 344,000 members and it would die with "An error occurred Location: Step 1. Application Core" about every 25,000 or so. I would click retry and it would start going again. Once I get through members went smoothly for a bit and then died again. These errors: Unknown column 'sys_module_admin' in 'where clause' UPDATE `ibf_core_modules` SET `sys_module_area`=? WHERE sys_module_admin=1 Location: Step 1. Application Core Unknown column 'title' in 'field list' INSERT INTO `ibf_core_member_ranks` ( `id`, `posts`, `title`, `pips` ) VALUES ( ?, ?, ?, ? ) Location: Step 1. Application Core Unknown column 'title' in 'field list' INSERT INTO `ibf_core_member_ranks` ( `id`, `posts`, `title`, `pips` ) VALUES ( ?, ?, ?, ? ) Location: Step 1. Application Core And it keeps going from there. I have tried upgrading three times so far and same batch of errors at about the same time.
It is a dedicated server. I've been tailing that slow query log for about an hour now and nothing has been dumped in it. I also made two changes to my.cnf last night that significantly reduced the issue. I was averaging about 3 MB a day in the ACP SQL error log is now in the K's. The two values I changed were:
max_connections, raised it to 500.
table_cache to 1000.
I did also notice I'm now using some swap space. Using about 332 MB of swap space right now. I'll check that slow query log after work tomorrow and see if anything shows up in it.