Help - Search - Members - Calendar
Full Version: Downgrading Mysql Database
Movable Type Community Forum > Installing and Upgrading > Databases
acidzero
I've installed MT4.0 and it took some days before I realize that it screwed my templates. sad.gif
So I was forced to go back to my 3.31 installation. Meanwile, new posts and comments arrived, and I could not just wipe my database and replace it with a backup.

There is a way to undo the changes MT 4.0 made in the template database?? (everything else is working fine)
I have access to phpMyadmin via CPanel, so I can edit the tables if I knew WHAT to edit...

Thanks.
Su-
Define "screwed my templates." MT should never touch any custom templates you already have set up during an upgrade.

There isn't really any way to simply downgrade your database. Depending on what's actually happened, though, things may be repairable.
acidzero
QUOTE (Su- @ Oct 16 2007, 06:32 PM) *
Define "screwed my templates." MT should never touch any custom templates you already have set up during an upgrade.

There isn't really any way to simply downgrade your database. Depending on what's actually happened, though, things may be repairable.


I mean "screwed" for 3.1, of course. The table for 4.0 is somewhat different than 3.31, so when I try to access the template page in my movabletype web manager it says:

An error occurred:
maketext doesn't know how to say: _SYSTEM_TEMPLATE_SEARCH_RESULTS as needed at lib/MT.pm line 919


Every other page works. I've managed to see inside the template table and my templates are there, but inacessible to me via web. I just need to know what changed from 3.31 to 4.0 (in this table) so I can revert back.

Thanks for your interest.
Su-
QUOTE (acidzero @ Oct 16 2007, 11:47 PM) *
I mean "screwed" for 3.1, of course.

Actually, no; not "of course" at all. You're making a significant change to your story.
The original post claimed that the upgrade did something(what?) to your templates which forced you to downgrade.
Now it sounds like the upgrade was presumably okay, and for whatever reason you chose to downgrade and did it improperly(not that there's really a proper way), and that is what's causing the problem.

So which is it?


In the meantime, you currently have a 4.0 database which is presumably fine. Why are you not using it? Again: your best option is probably to address whatever it is that made you backtrack rather than spend time hacking the database. There were a lot of changes involved in the 4.0 switch. You might be able to fix the template references(and I'm not the person to lead you through that), but there's no guarantee you're not going to run into a lot of other problems you just haven't triggered yet.
acidzero
QUOTE
In the meantime, you currently have a 4.0 database which is presumably fine. Why are you not using it?


I would love to be using MT4.0 with my blog, but it really ruined my layout structure. There was no warning about the removal of some features (I have a popup for comments, for example, and I do not want to use the comments in the same page of the post), just a "integration" of templates (whatsoever). I just could not adapt my blog to the news standards! My blog works very, very fine with my comment template being a pop-up and cannot be different.

The other problem with 4.0 was some errors that ocurred when I tried to post, that never happened in 3.31. So that was just one more reason to downgrade. And it happened because there were NO WARNINGS saying that SOME templates would not work after the upgrade, or I would never have upgraded.

I was wondering: If you can't help me, why are you so interested?
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2009 Invision Power Services, Inc.