Upgrade 2.* to 3.0:
If you would like to upgrade your system to 3.0, follow the instructions below. Please make a backup of your system and database structure before
you begin. Note that any custom changes will be lost if you perform this action. We offer NO support if anything goes wrong, so proceed with caution.
1. Backup recipe file structure and database.
2. Download latest version from the Maian Recipe website.
3. Rename 'control/_cfg-example.php' to '_cfg.php' and complete all options in this file.
4. Upload all files to your server to overwrite existing files.
5. Open your database program (PHPMyAdmin, Adminer etc) and run the following commands in the order they are shown below. Make sure the table prefix is correct if you changed it.
alter table `mr_categories` drop column `enComments`;
alter table `mr_categories` drop column `enRecipes`;
alter table `mr_categories` drop column `enRating`;
drop table `mr_cloudtags`;
drop table `mr_ratings`;
alter table `mr_recipes` drop column `comCount`;
alter table `mr_recipes` drop column `ratingCount`;
update `mr_recipes` set `ingredients` = REPLACE(`ingredients`,'\n','<br>'),`instructions` = REPLACE(`instructions`,'\n','<br>');
create table if not exists `mr_recipe_cats` (
`id` int(10) unsigned not null auto_increment,
`recipe` int(8) not null default 0,
`category` int(8) not null default 0,
primary key (`id`),
key `recipe` (`recipe`),
key `category` (`category`)
) engine=myisam default charset=utf8mb4;
alter table `mr_settings` add column `smtp_fname` varchar(100) not null default '';
alter table `mr_settings` add column `smtp_femail` varchar(100) not null default '';
alter table `mr_settings` add column `addRecipe` enum('no','yes') not null default 'yes';
alter table `mr_settings` add column `a_user` varchar(250) not null default '';
alter table `mr_settings` add column `a_pass` varchar(250) not null default '';
alter table `mr_settings` add column `menu` enum('open','closed') not null default 'open';
insert into `mr_recipe_cats` (`recipe`,`category`) select `id`,`cat` from `mr_recipes`;
alter table `mr_recipes` drop column `cat`;
Upgrade completed!