Hi @rhellem,

@rhellem wrote:

Then exported the database from my "production" blog and tried to import it to the test installation, done that previously without any issues. But now on 5.2.2 it fails with the error

"Unknown column 'blog_disp_bloglist'

Checking and I see that the column is present on my "production" blog and not on my test installation, but both are 5.2.2.

Your test site should be completely broken without 'blog_disp_bloglist'. But there is something I don't understand, if the production site contains the field and you imported that database correctly to the test site, why blog_disp_bloglist is still missing? Are you sure that there are no errors on the import process?

Hi

Sorry for not being all clear about what I've done

* I exported a backup of my production blog database, simply using PHPMyAdmin -> Export
* I did install on my laptop an empty 5.2.2 installation which is up and running all fine (default without any example blog(-s))
* Tried to restore my backup on the test installation, which fails due to the missing column.

The test blog seems to be working just fine. Ok, yesterday before trying to do the import it had no blogs created, just empty. So now I did create a blog and then a post as well. All fine. Checked if the column had been created now, but it has not.

But, I see now in my test blog that the skin is reporting "The requested Blog doesn't exist any more!" underneath the listing of Categories. Not really sure if this is yet another symptom of the root cause.

Will look into enabling debug later today to see if there are any errors being logged that could explain this.

@rhellem: all right, now I know what happend. I got confused with blog_in_bloglist instead of blog_disp_bloglist, which is deprecated since a long time ago. So, if you have been updating your production site, the field just remained there. And, as your tests site is a new installation, the field is not in the database.

Now, where do you see the "Unknown column 'blog_disp_bloglist'? Can you please send a screenshot of that? I'm not able to reproduce it.

Thanks.

I just realized what I did wrong. It has been years since I have done the test installation from scratch on one of my laptops. I do an SQL export/import as described here http://hellem.org/blog/index.php/2010/06/03/b2evolution-on-my-laptop-and-rtfm?blog=6 and it has been working just fine. I do not remember if I did drop the database and creating it again before doing the import, but anyhow that was what I needed to do this time. That is

* Install the test installation
* Drop the database and create it again empty
* Do the SQL import (restore from production)

Then all fine...