nazgul26 / phprecipebook Goto Github PK
View Code? Open in Web Editor NEWCookbook and Meal planning software. Runs on PHP with MySQL/PostgreSQL.
Cookbook and Meal planning software. Runs on PHP with MySQL/PostgreSQL.
This is a great app, but I'm getting a number of errors. I've tried on MySQL and PostgreSQL. I've tried versions 4.09, 5.0.0, 5.0.1, and 5.0.2. I've tried both with and without git. I really love this app and want to get it working, but no matter what I try, I'm seeing errors like these:
Error: The action add is not defined in controller CoreIngredientsController
Error: Create CoreIngredientsController::add() in file: recipe/Controller/CoreIngredientsController.php.
class CoreIngredientsController extends AppController {
public function add() {
}
}
From the ingredients page, when I click add unit from the dropdown I get the error:
Error: The action add is not defined in controller UnitsController
Error: Create UnitsController::add() in file: recipe/Controller/UnitsController.php.
<?php
class UnitsController extends AppController {
public function add() {
}
}
But, when I click list units and then click add unit from the list page, it works. Something strange is happening...
Also, I had major trouble importing the core_ingredients.sql file to the database. In the file, groupNumber is used, but in the database it is group_id. In the file, weights are called recipe_core_weights, but the database column is just core_weights. I got the file to import by changing the file to match the column titles, but why did I have to do that?
I wasn't able to install 5.0.2 because some ___d() error. I forget what it was now, since I've been focusing on 5.0.1 since I managed to get that the furthest.
I'm not one to post online for help, I created an account just for this, but I've been at it for days and think I've exhausted google. Thank you for making this great app, and thank you for your help with my problems!
Cannot find any links to edit "location in store". Currently editing via phpmyadmin, I think this was in the 4.x version prior to changing to CakePHP, but can't remember...
I'm starting to translate script with readme instruction, but after update to server it does not do anything - all stuff is in english.
I've edited bootstrap conf:
Configure::write('Languages', array(
'eng' => 'English',
'zho' => 'Chinese',
'dan' => 'Danish',
'nld' => 'Dutch',
'est' => 'Estonian',
'fra' => 'French',
'deu' => 'German',
'hun' => 'Hungarian',
'ita' => 'Italian',
'jpn' => 'Japanese',
'kor' => 'Korean',
'nor' => 'Norwegian',
'por' => 'Portuguese',
'tur' => 'Turkish',
'srp' => 'Serbian',
'spa' => 'Spanish',
'swe' => 'Swedish',
'pol' => 'Polish',
'pl' => 'Polish2'
));
and created in locale pl folder, moved there default.po.
Line 106 in /View/Setup/index.cpt has an undefined function. The line reads:
echo d('setup','error Message:' ) . $errorMsg;
where it should be
echo __d('setup','error Message:' ) . $errorMsg;
I like to have different accounts for my normal user and admin user. This prevents me from using the same e-mail address in both.
Clean installation:
In the table core_ingredients group_id have to be groupNumber
The table recipe_core_weights have to be core_weights
Have followed all of the directions but don't seem to be able to get anything to work. Can't get past the setup page.
System info
Centos 5
php 5.3.3
MySQL 5.0.95
If I try to bypass the error page and create the new user account, I get an array error:
array(
'username' => array(
(int) 0 => 'required',
(int) 1 => 'required'
),
'access_level' => array(
(int) 0 => 'numeric',
(int) 1 => 'numeric'
)
)
And then it has a link to the page throwing the error:
/PHPRecipebook/Controller/SetupController.php (line 38)
Can you help?
Error text says:
Notice (8): Undefined index: name [APP/View/Recipes/view.ctp, line 161]
Code Context
$quantity = $this->Fraction->toFraction($quantity);
$unit = $recipe['IngredientMapping'][$i]['Unit']['name'];
$ingredientName = $recipe['IngredientMapping'][$i]['Ingredient']['name'];
$viewFile = '/var/www/recipe.mysite.net/phprecipebook-5.0.7/View/Recipes/view.ctp'
$dataForView = array(
'servings' => null,
'recipe' => array(
'Recipe' => array(
'id' => '33',
'name' => 'A-Test',
'ethnicity_id' => '1',
'base_type_id' => '1',
'course_id' => '1',
'preparation_time_id' => '2',
'difficulty_id' => '1',
'serving_size' => '1',
'directions' => 'Cook the damn thing.',
'comments' => 'Test',
'source_description' => 'Ugh',
'recipe_cost' => null,
'modified' => '2016-01-14',
'picture' => null,
'picture_type' => null,
'private' => false,
'system' => 'usa',
'source_id' => '4',
'user_id' => '2',
'preparation_method_id' => '5'
),
'Ethnicity' => array(
'name' => 'American'
),
'BaseType' => array(
'name' => 'Beef'
),
'Course' => array(
'name' => 'Breakfast'
),
'PreparationTime' => array(
'name' => '1-10 Minutes'
),
'Difficulty' => array(
'name' => 'Easy'
),
'Source' => array(
'name' => 'Unknown',
'id' => '4',
'description' => ''
),
'User' => array(
'name' => 'withanh',
'id' => '2'
),
'RelatedRecipe' => array(),
'IngredientMapping' => array(
(int) 0 => array(
[maximum depth reached]
)
),
'Image' => array(),
'Review' => array()
),
'allowAccountCreation' => false,
'isEditor' => true,
'isAdmin' => true,
'loggedInuserId' => '2',
'loggedIn' => true
)
$servings = '1'
$recipe = array(
'Recipe' => array(
'id' => '33',
'name' => 'A-Test',
'ethnicity_id' => '1',
'base_type_id' => '1',
'course_id' => '1',
'preparation_time_id' => '2',
'difficulty_id' => '1',
'serving_size' => '1',
'directions' => 'Cook the damn thing.',
'comments' => 'Test',
'source_description' => 'Ugh',
'recipe_cost' => null,
'modified' => '2016-01-14',
'picture' => null,
'picture_type' => null,
'private' => false,
'system' => 'usa',
'source_id' => '4',
'user_id' => '2',
'preparation_method_id' => '5'
),
'Ethnicity' => array(
'name' => 'American'
),
'BaseType' => array(
'name' => 'Beef'
),
'Course' => array(
'name' => 'Breakfast'
),
'PreparationTime' => array(
'name' => '1-10 Minutes'
),
'Difficulty' => array(
'name' => 'Easy'
),
'Source' => array(
'name' => 'Unknown',
'id' => '4',
'description' => ''
),
'User' => array(
'name' => 'withanh',
'id' => '2'
),
'RelatedRecipe' => array(),
'IngredientMapping' => array(
(int) 0 => array(
'recipe_id' => '33',
'ingredient_id' => '0',
'quantity' => '1',
'unit_id' => '1',
'qualifier' => '',
'optional' => false,
'sort_order' => '0',
'id' => '287',
'Ingredient' => array([maximum depth reached]),
'Unit' => array(
[maximum depth reached]
)
)
),
'Image' => array(),
'Review' => array()
)
$allowAccountCreation = false
$isEditor = true
$isAdmin = true
$loggedInuserId = '2'
$loggedIn = true
$recipeId = '33'
$scale = (int) 1
$numberOfReviews = (int) 0
$averageRating = (int) 0
$imageCount = (int) 0
$i = (int) 0
$quantity = (int) 1
$unit = 'Each'
include - APP/View/Recipes/view.ctp, line 161
View::_evaluate() - APP/Vendor/cakephp/cakephp/lib/Cake/View/View.php, line 971
View::_render() - APP/Vendor/cakephp/cakephp/lib/Cake/View/View.php, line 933
View::render() - APP/Vendor/cakephp/cakephp/lib/Cake/View/View.php, line 473
Controller::render() - APP/Vendor/cakephp/cakephp/lib/Cake/Controller/Controller.php, line 960
Dispatcher::_invoke() - APP/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php, line 200
Dispatcher::dispatch() - APP/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 113
i'm trying to add a recipe in chinese but save the name with "????" only...
i discovered that all tables are created with charset latin1_swedish_ci instead utf8
Please note that in database conf i have chosen utf8 and my db is set on utf8...
I created a recipe. Then went back later to make it Private. It now says private Yes but anyone can see it even when not logged in!
After creating or editing a recipe, when you hit Submit it should take you back to the View Recipe screen not keep you on the Edit Recipe screen.
It took me a couple of tries before I realized it was actually saving my updates, I thought it kept going back to the Edit screen because there was something wrong with one of the fields.
I tried creating an account in the demo but it appears /Users/login and /User/add are pointing to the /Users/login page, or at least the button seems to be trying to go to /User/add but is landing on /Users/login
Looking forward to diving deeper into the app.
I have installed PHPRecipebook with a new db in my Synology NAS.
After fixing core_ingredients.sql, I still have errors. I have added ingredients and a new recipe, but I can't view it.
Error: Table reviews for model Review was not found in datasource default.
And the "View" button when you have saved the recipe, into the edit mode, make a call to "PHPRecipebook/Recipes/view" without the recipe id. -> "PHPRecipebook/Recipes/view/1"
PD: I have tried to update from 4.0.9 with the same result, that's the reason to try from scratch.
Pulled up to master and got the following schema errors with running ./Console/cake schema update
Comparing Database to Schema...
Notice Error: Undefined index: tableParameters in [/var/www/recipebook.morgancomputers.net/Vendor/cakephp/cakephp/lib/Cake/Model/Datasource/Database/Postgres.php, line 543]
Notice Error: Undefined index: type in [/var/www/recipebook.morgancomputers.net/Vendor/cakephp/cakephp/lib/Cake/Model/Datasource/Database/Postgres.php, line 853]
Notice Error: Undefined index: in [/var/www/recipebook.morgancomputers.net/Vendor/cakephp/cakephp/lib/Cake/Model/Datasource/Database/Postgres.php, line 853]
Warning Error: Column name or type not defined in schema in [/var/www/recipebook.morgancomputers.net/Vendor/cakephp/cakephp/lib/Cake/Model/Datasource/DboSource.php, line 3327]
Notice Error: Undefined index: tableParameters in [/var/www/recipebook.morgancomputers.net/Vendor/cakephp/cakephp/lib/Cake/Model/Datasource/Database/Postgres.php, line 543]
Notice Error: Undefined index: type in [/var/www/recipebook.morgancomputers.net/Vendor/cakephp/cakephp/lib/Cake/Model/Datasource/Database/Postgres.php, line 853]
Notice Error: Undefined index: in [/var/www/recipebook.morgancomputers.net/Vendor/cakephp/cakephp/lib/Cake/Model/Datasource/Database/Postgres.php, line 853]
Warning Error: Column name or type not defined in schema in [/var/www/recipebook.morgancomputers.net/Vendor/cakephp/cakephp/lib/Cake/Model/Datasource/DboSource.php, line 3327]
Notice Error: Undefined index: tableParameters in [/var/www/recipebook.morgancomputers.net/Vendor/cakephp/cakephp/lib/Cake/Model/Datasource/Database/Postgres.php, line 543]
Notice Error: Undefined index: type in [/var/www/recipebook.morgancomputers.net/Vendor/cakephp/cakephp/lib/Cake/Model/Datasource/Database/Postgres.php, line 853]
Notice Error: Undefined index: in [/var/www/recipebook.morgancomputers.net/Vendor/cakephp/cakephp/lib/Cake/Model/Datasource/Database/Postgres.php, line 853]
Warning Error: Column name or type not defined in schema in [/var/www/recipebook.morgancomputers.net/Vendor/cakephp/cakephp/lib/Cake/Model/Datasource/DboSource.php, line 3327]
Notice Error: Undefined index: tableParameters in [/var/www/recipebook.morgancomputers.net/Vendor/cakephp/cakephp/lib/Cake/Model/Datasource/Database/Postgres.php, line 543]
Notice Error: Undefined index: type in [/var/www/recipebook.morgancomputers.net/Vendor/cakephp/cakephp/lib/Cake/Model/Datasource/Database/Postgres.php, line 853]
Notice Error: Undefined index: in [/var/www/recipebook.morgancomputers.net/Vendor/cakephp/cakephp/lib/Cake/Model/Datasource/Database/Postgres.php, line 853]
Warning Error: Column name or type not defined in schema in [/var/www/recipebook.morgancomputers.net/Vendor/cakephp/cakephp/lib/Cake/Model/Datasource/DboSource.php, line 3327]
Notice Error: Undefined index: tableParameters in [/var/www/recipebook.morgancomputers.net/Vendor/cakephp/cakephp/lib/Cake/Model/Datasource/Database/Postgres.php, line 543]
Notice Error: Undefined index: type in [/var/www/recipebook.morgancomputers.net/Vendor/cakephp/cakephp/lib/Cake/Model/Datasource/Database/Postgres.php, line 853]
Notice Error: Undefined index: in [/var/www/recipebook.morgancomputers.net/Vendor/cakephp/cakephp/lib/Cake/Model/Datasource/Database/Postgres.php, line 853]
Warning Error: Column name or type not defined in schema in [/var/www/recipebook.morgancomputers.net/Vendor/cakephp/cakephp/lib/Cake/Model/Datasource/DboSource.php, line 3327]
Notice Error: Undefined index: tableParameters in [/var/www/recipebook.morgancomputers.net/Vendor/cakephp/cakephp/lib/Cake/Model/Datasource/Database/Postgres.php, line 543]
Notice Error: Undefined index: type in [/var/www/recipebook.morgancomputers.net/Vendor/cakephp/cakephp/lib/Cake/Model/Datasource/Database/Postgres.php, line 853]
Notice Error: Undefined index: in [/var/www/recipebook.morgancomputers.net/Vendor/cakephp/cakephp/lib/Cake/Model/Datasource/Database/Postgres.php, line 853]
Warning Error: Column name or type not defined in schema in [/var/www/recipebook.morgancomputers.net/Vendor/cakephp/cakephp/lib/Cake/Model/Datasource/DboSource.php, line 3327]
Notice Error: Undefined index: tableParameters in [/var/www/recipebook.morgancomputers.net/Vendor/cakephp/cakephp/lib/Cake/Model/Datasource/Database/Postgres.php, line 543]
Notice Error: Undefined index: type in [/var/www/recipebook.morgancomputers.net/Vendor/cakephp/cakephp/lib/Cake/Model/Datasource/Database/Postgres.php, line 853]
Notice Error: Undefined index: in [/var/www/recipebook.morgancomputers.net/Vendor/cakephp/cakephp/lib/Cake/Model/Datasource/Database/Postgres.php, line 853]
Warning Error: Column name or type not defined in schema in [/var/www/recipebook.morgancomputers.net/Vendor/cakephp/cakephp/lib/Cake/Model/Datasource/DboSource.php, line 3327]
Notice Error: Undefined index: tableParameters in [/var/www/recipebook.morgancomputers.net/Vendor/cakephp/cakephp/lib/Cake/Model/Datasource/Database/Postgres.php, line 543]
Notice Error: Undefined index: type in [/var/www/recipebook.morgancomputers.net/Vendor/cakephp/cakephp/lib/Cake/Model/Datasource/Database/Postgres.php, line 853]
Notice Error: Undefined index: in [/var/www/recipebook.morgancomputers.net/Vendor/cakephp/cakephp/lib/Cake/Model/Datasource/Database/Postgres.php, line 853]
Warning Error: Column name or type not defined in schema in [/var/www/recipebook.morgancomputers.net/Vendor/cakephp/cakephp/lib/Cake/Model/Datasource/DboSource.php, line 3327]
There are more, but you get the idea.
The following statements will run.
ALTER TABLE "public"."attachments"
ALTER COLUMN "id" TYPE serial ,
ALTER COLUMN "id" SET NOT NULL,
ALTER COLUMN "id" DROP DEFAULT,
ALTER COLUMN "recipe_id" TYPE integer,
ALTER COLUMN "recipe_id" SET NOT NULL,
ALTER COLUMN "recipe_id" DROP DEFAULT,
ALTER COLUMN "name" TYPE varchar(32),
ALTER COLUMN "name" SET NOT NULL,
ALTER COLUMN "name" DROP DEFAULT,
ALTER COLUMN "attachment" TYPE varchar(255),
ALTER COLUMN "attachment" SET NOT NULL,
ALTER COLUMN "attachment" DROP DEFAULT,
ALTER COLUMN "dir" TYPE varchar(255),
ALTER COLUMN "dir" DROP NOT NULL,
ALTER COLUMN "dir" DROP DEFAULT,
ALTER COLUMN "type" TYPE varchar(255),
ALTER COLUMN "type" DROP NOT NULL,
ALTER COLUMN "type" DROP DEFAULT,
ALTER COLUMN "size" TYPE integer,
ALTER COLUMN "size" DROP NOT NULL,
ALTER COLUMN "size" SET DEFAULT 0,
ALTER COLUMN "sort_order" TYPE integer,
ALTER COLUMN "sort_order" DROP NOT NULL,
ALTER COLUMN "sort_order" DROP DEFAULT,
ALTER COLUMN "tableParameters" TYPE ,
ALTER COLUMN "tableParameters" DROP DEFAULT;
ALTER TABLE "public"."base_types"
ALTER COLUMN "id" TYPE serial ,
ALTER COLUMN "id" SET NOT NULL,
ALTER COLUMN "id" DROP DEFAULT,
ALTER COLUMN "name" TYPE varchar(64),
ALTER COLUMN "name" SET NOT NULL,
ALTER COLUMN "name" DROP DEFAULT,
ALTER COLUMN "tableParameters" TYPE ,
ALTER COLUMN "tableParameters" DROP DEFAULT;
ALTER TABLE "public"."core_ingredients"
ALTER COLUMN "id" TYPE serial ,
ALTER COLUMN "id" SET NOT NULL,
ALTER COLUMN "id" DROP DEFAULT,
ALTER COLUMN "groupNumber" TYPE integer,
ALTER COLUMN "groupNumber" SET NOT NULL,
ALTER COLUMN "groupNumber" DROP DEFAULT,
ALTER COLUMN "name" TYPE varchar(200),
ALTER COLUMN "name" SET NOT NULL,
ALTER COLUMN "name" DROP DEFAULT,
ALTER COLUMN "short_description" TYPE varchar(60),
ALTER COLUMN "short_description" SET NOT NULL,
ALTER COLUMN "short_description" DROP DEFAULT,
ALTER COLUMN "tableParameters" TYPE ,
ALTER COLUMN "tableParameters" DROP DEFAULT;
ALTER TABLE "public"."core_weights"
ALTER COLUMN "id" TYPE serial ,
ALTER COLUMN "id" SET NOT NULL,
ALTER COLUMN "id" DROP DEFAULT,
ALTER COLUMN "sequence" TYPE serial ,
ALTER COLUMN "sequence" SET NOT NULL,
ALTER COLUMN "sequence" DROP DEFAULT,
ALTER COLUMN "amount" TYPE integer,
ALTER COLUMN "amount" DROP NOT NULL,
ALTER COLUMN "amount" DROP DEFAULT,
ALTER COLUMN "measure" TYPE varchar(80),
ALTER COLUMN "measure" DROP NOT NULL,
ALTER COLUMN "measure" DROP DEFAULT,
ALTER COLUMN "weight" TYPE integer,
ALTER COLUMN "weight" DROP NOT NULL,
ALTER COLUMN "weight" DROP DEFAULT,
ALTER COLUMN "tableParameters" TYPE ,
ALTER COLUMN "tableParameters" DROP DEFAULT;
ALTER TABLE "public"."courses"
ALTER COLUMN "id" TYPE serial ,
ALTER COLUMN "id" SET NOT NULL,
ALTER COLUMN "id" DROP DEFAULT,
ALTER COLUMN "name" TYPE varchar(64),
ALTER COLUMN "name" SET NOT NULL,
ALTER COLUMN "name" DROP DEFAULT,
ALTER COLUMN "tableParameters" TYPE ,
ALTER COLUMN "tableParameters" DROP DEFAULT;
ALTER TABLE "public"."difficulties"
ALTER COLUMN "id" TYPE serial ,
ALTER COLUMN "id" SET NOT NULL,
ALTER COLUMN "id" DROP DEFAULT,
ALTER COLUMN "name" TYPE varchar(64),
ALTER COLUMN "name" DROP NOT NULL,
ALTER COLUMN "name" DROP DEFAULT,
ALTER COLUMN "tableParameters" TYPE ,
ALTER COLUMN "tableParameters" DROP DEFAULT;
ALTER TABLE "public"."ethnicities"
ALTER COLUMN "id" TYPE serial ,
ALTER COLUMN "id" SET NOT NULL,
ALTER COLUMN "id" DROP DEFAULT,
ALTER COLUMN "name" TYPE varchar(64),
ALTER COLUMN "name" SET NOT NULL,
ALTER COLUMN "name" DROP DEFAULT,
ALTER COLUMN "tableParameters" TYPE ,
ALTER COLUMN "tableParameters" DROP DEFAULT;
ALTER TABLE "public"."ingredient_mappings"
ALTER COLUMN "recipe_id" TYPE integer,
ALTER COLUMN "recipe_id" SET NOT NULL,
ALTER COLUMN "recipe_id" DROP DEFAULT,
ALTER COLUMN "ingredient_id" TYPE integer,
ALTER COLUMN "ingredient_id" SET NOT NULL,
ALTER COLUMN "ingredient_id" DROP DEFAULT,
ALTER COLUMN "quantity" TYPE float,
ALTER COLUMN "quantity" SET NOT NULL,
ALTER COLUMN "quantity" DROP DEFAULT,
ALTER COLUMN "unit_id" TYPE integer,
ALTER COLUMN "unit_id" DROP NOT NULL,
ALTER COLUMN "unit_id" DROP DEFAULT,
ALTER COLUMN "qualifier" TYPE varchar(32),
ALTER COLUMN "qualifier" DROP NOT NULL,
ALTER COLUMN "qualifier" DROP DEFAULT,
ALTER COLUMN "sort_order" TYPE integer,
ALTER COLUMN "sort_order" DROP NOT NULL,
ALTER COLUMN "sort_order" DROP DEFAULT,
ALTER COLUMN "id" TYPE serial ,
ALTER COLUMN "id" SET NOT NULL,
ALTER COLUMN "id" DROP DEFAULT,
ALTER COLUMN "tableParameters" TYPE ,
ALTER COLUMN "tableParameters" DROP DEFAULT;
ALTER TABLE "public"."ingredients"
ALTER COLUMN "id" TYPE serial ,
ALTER COLUMN "id" SET NOT NULL,
ALTER COLUMN "id" DROP DEFAULT,
ALTER COLUMN "name" TYPE varchar(120),
ALTER COLUMN "name" SET NOT NULL,
ALTER COLUMN "name" DROP DEFAULT,
ALTER COLUMN "description" TYPE text,
ALTER COLUMN "description" DROP NOT NULL,
ALTER COLUMN "description" DROP DEFAULT,
ALTER COLUMN "location_id" TYPE integer,
ALTER COLUMN "location_id" DROP NOT NULL,
ALTER COLUMN "location_id" DROP DEFAULT,
ALTER COLUMN "unit_id" TYPE integer,
ALTER COLUMN "unit_id" DROP NOT NULL,
ALTER COLUMN "unit_id" DROP DEFAULT,
ALTER COLUMN "system" TYPE varchar(8),
ALTER COLUMN "system" DROP NOT NULL,
ALTER COLUMN "system" SET DEFAULT 'usa',
ALTER COLUMN "user_id" TYPE integer,
ALTER COLUMN "user_id" DROP NOT NULL,
ALTER COLUMN "user_id" DROP DEFAULT,
ALTER COLUMN "core_ingredient_id" TYPE integer,
ALTER COLUMN "core_ingredient_id" DROP NOT NULL,
ALTER COLUMN "core_ingredient_id" DROP DEFAULT,
ALTER COLUMN "tableParameters" TYPE ,
ALTER COLUMN "tableParameters" DROP DEFAULT;
ALTER TABLE "public"."locations"
ALTER COLUMN "id" TYPE serial ,
ALTER COLUMN "id" SET NOT NULL,
ALTER COLUMN "id" DROP DEFAULT,
ALTER COLUMN "name" TYPE varchar(64),
ALTER COLUMN "name" SET NOT NULL,
ALTER COLUMN "name" DROP DEFAULT,
ALTER COLUMN "tableParameters" TYPE ,
ALTER COLUMN "tableParameters" DROP DEFAULT;
ALTER TABLE "public"."meal_names"
ALTER COLUMN "id" TYPE serial ,
ALTER COLUMN "id" SET NOT NULL,
ALTER COLUMN "id" DROP DEFAULT,
ALTER COLUMN "name" TYPE varchar(64),
ALTER COLUMN "name" SET NOT NULL,
ALTER COLUMN "name" DROP DEFAULT,
ALTER COLUMN "tableParameters" TYPE ,
ALTER COLUMN "tableParameters" DROP DEFAULT;
ALTER TABLE "public"."meal_plans"
ALTER COLUMN "mealday" TYPE date,
ALTER COLUMN "mealday" SET NOT NULL,
ALTER COLUMN "mealday" DROP DEFAULT,
ALTER COLUMN "meal_name_id" TYPE integer,
ALTER COLUMN "meal_name_id" SET NOT NULL,
ALTER COLUMN "meal_name_id" DROP DEFAULT,
ALTER COLUMN "recipe_id" TYPE integer,
ALTER COLUMN "recipe_id" SET NOT NULL,
ALTER COLUMN "recipe_id" DROP DEFAULT,
ALTER COLUMN "servings" TYPE integer,
ALTER COLUMN "servings" SET NOT NULL,
ALTER COLUMN "servings" SET DEFAULT 0,
ALTER COLUMN "user_id" TYPE integer,
ALTER COLUMN "user_id" DROP NOT NULL,
ALTER COLUMN "user_id" DROP DEFAULT,
ALTER COLUMN "id" TYPE serial ,
ALTER COLUMN "id" SET NOT NULL,
ALTER COLUMN "id" DROP DEFAULT,
ALTER COLUMN "tableParameters" TYPE ,
ALTER COLUMN "tableParameters" DROP DEFAULT;
ALTER TABLE "public"."preparation_methods"
ALTER COLUMN "id" TYPE serial ,
ALTER COLUMN "id" SET NOT NULL,
ALTER COLUMN "id" DROP DEFAULT,
ALTER COLUMN "name" TYPE varchar(64),
ALTER COLUMN "name" DROP NOT NULL,
ALTER COLUMN "name" DROP DEFAULT,
ALTER COLUMN "tableParameters" TYPE ,
ALTER COLUMN "tableParameters" DROP DEFAULT;
ALTER TABLE "public"."preparation_times"
ALTER COLUMN "id" TYPE serial ,
ALTER COLUMN "id" SET NOT NULL,
ALTER COLUMN "id" DROP DEFAULT,
ALTER COLUMN "name" TYPE varchar(64),
ALTER COLUMN "name" SET NOT NULL,
ALTER COLUMN "name" DROP DEFAULT,
ALTER COLUMN "tableParameters" TYPE ,
ALTER COLUMN "tableParameters" DROP DEFAULT;
ALTER TABLE "public"."price_ranges"
ALTER COLUMN "id" TYPE serial ,
ALTER COLUMN "id" SET NOT NULL,
ALTER COLUMN "id" DROP DEFAULT,
ALTER COLUMN "name" TYPE varchar(16),
ALTER COLUMN "name" DROP NOT NULL,
ALTER COLUMN "name" DROP DEFAULT,
ALTER COLUMN "tableParameters" TYPE ,
ALTER COLUMN "tableParameters" DROP DEFAULT;
ALTER TABLE "public"."recipes"
ALTER COLUMN "id" TYPE serial ,
ALTER COLUMN "id" SET NOT NULL,
ALTER COLUMN "id" DROP DEFAULT,
ALTER COLUMN "name" TYPE varchar(128),
ALTER COLUMN "name" SET NOT NULL,
ALTER COLUMN "name" DROP DEFAULT,
ALTER COLUMN "ethnicity_id" TYPE integer,
ALTER COLUMN "ethnicity_id" DROP NOT NULL,
ALTER COLUMN "ethnicity_id" DROP DEFAULT,
ALTER COLUMN "base_type_id" TYPE integer,
ALTER COLUMN "base_type_id" DROP NOT NULL,
ALTER COLUMN "base_type_id" DROP DEFAULT,
ALTER COLUMN "course_id" TYPE integer,
ALTER COLUMN "course_id" DROP NOT NULL,
ALTER COLUMN "course_id" DROP DEFAULT,
ALTER COLUMN "preparation_time_id" TYPE integer,
ALTER COLUMN "preparation_time_id" DROP NOT NULL,
ALTER COLUMN "preparation_time_id" DROP DEFAULT,
ALTER COLUMN "difficulty_id" TYPE integer,
ALTER COLUMN "difficulty_id" DROP NOT NULL,
ALTER COLUMN "difficulty_id" DROP DEFAULT,
ALTER COLUMN "serving_size" TYPE integer,
ALTER COLUMN "serving_size" DROP NOT NULL,
ALTER COLUMN "serving_size" DROP DEFAULT,
ALTER COLUMN "directions" TYPE text,
ALTER COLUMN "directions" TYPE text,
ALTER COLUMN "directions" DROP NOT NULL,
ALTER COLUMN "directions" DROP DEFAULT,
ALTER COLUMN "comments" TYPE text,
ALTER COLUMN "comments" DROP NOT NULL,
ALTER COLUMN "comments" DROP DEFAULT,
ALTER COLUMN "source_description" TYPE varchar(200),
ALTER COLUMN "source_description" DROP NOT NULL,
ALTER COLUMN "source_description" DROP DEFAULT,
ALTER COLUMN "recipe_cost" TYPE float,
ALTER COLUMN "recipe_cost" DROP NOT NULL,
ALTER COLUMN "recipe_cost" DROP DEFAULT,
ALTER COLUMN "picture_type" TYPE varchar(32),
ALTER COLUMN "picture_type" DROP NOT NULL,
ALTER COLUMN "picture_type" DROP DEFAULT,
ALTER COLUMN "system" TYPE varchar(16),
ALTER COLUMN "system" SET NOT NULL,
ALTER COLUMN "system" SET DEFAULT 'usa',
ALTER COLUMN "source_id" TYPE integer,
ALTER COLUMN "source_id" DROP NOT NULL,
ALTER COLUMN "source_id" DROP DEFAULT,
ALTER COLUMN "user_id" TYPE integer,
ALTER COLUMN "user_id" DROP NOT NULL,
ALTER COLUMN "user_id" DROP DEFAULT,
ALTER COLUMN "preparation_method_id" TYPE integer,
ALTER COLUMN "preparation_method_id" DROP NOT NULL,
ALTER COLUMN "preparation_method_id" DROP DEFAULT,
ALTER COLUMN "tableParameters" TYPE ,
ALTER COLUMN "tableParameters" DROP DEFAULT;
ALTER TABLE "public"."related_recipes"
ALTER COLUMN "parent_id" TYPE integer,
ALTER COLUMN "parent_id" SET NOT NULL,
ALTER COLUMN "parent_id" DROP DEFAULT,
ALTER COLUMN "recipe_id" TYPE integer,
ALTER COLUMN "recipe_id" SET NOT NULL,
ALTER COLUMN "recipe_id" DROP DEFAULT,
ALTER COLUMN "sort_order" TYPE integer,
ALTER COLUMN "sort_order" DROP NOT NULL,
ALTER COLUMN "sort_order" DROP DEFAULT,
ALTER COLUMN "id" TYPE serial ,
ALTER COLUMN "id" SET NOT NULL,
ALTER COLUMN "id" DROP DEFAULT,
ALTER COLUMN "tableParameters" TYPE ,
ALTER COLUMN "tableParameters" DROP DEFAULT;
ALTER TABLE "public"."reviews"
ALTER COLUMN "recipe_id" TYPE integer,
ALTER COLUMN "recipe_id" SET NOT NULL,
ALTER COLUMN "recipe_id" DROP DEFAULT,
ALTER COLUMN "comments" TYPE varchar(255),
ALTER COLUMN "comments" SET NOT NULL,
ALTER COLUMN "comments" DROP DEFAULT,
ALTER COLUMN "user_id" TYPE integer,
ALTER COLUMN "user_id" DROP NOT NULL,
ALTER COLUMN "user_id" DROP DEFAULT,
ALTER COLUMN "id" TYPE serial ,
ALTER COLUMN "id" SET NOT NULL,
ALTER COLUMN "id" DROP DEFAULT,
ALTER COLUMN "rating" TYPE integer,
ALTER COLUMN "rating" DROP NOT NULL,
ALTER COLUMN "rating" DROP DEFAULT,
ALTER COLUMN "tableParameters" TYPE ,
ALTER COLUMN "tableParameters" DROP DEFAULT;
ALTER TABLE "public"."restaurants"
ALTER COLUMN "id" TYPE serial ,
ALTER COLUMN "id" SET NOT NULL,
ALTER COLUMN "id" DROP DEFAULT,
ALTER COLUMN "name" TYPE varchar(64),
ALTER COLUMN "name" SET NOT NULL,
ALTER COLUMN "name" DROP DEFAULT,
ALTER COLUMN "street" TYPE varchar(128),
ALTER COLUMN "street" DROP NOT NULL,
ALTER COLUMN "street" DROP DEFAULT,
ALTER COLUMN "city" TYPE varchar(64),
ALTER COLUMN "city" DROP NOT NULL,
ALTER COLUMN "city" DROP DEFAULT,
ALTER COLUMN "state" TYPE varchar(2),
ALTER COLUMN "state" DROP NOT NULL,
ALTER COLUMN "state" DROP DEFAULT,
ALTER COLUMN "zip" TYPE varchar(16),
ALTER COLUMN "zip" DROP NOT NULL,
ALTER COLUMN "zip" DROP DEFAULT,
ALTER COLUMN "phone" TYPE varchar(128),
ALTER COLUMN "phone" DROP NOT NULL,
ALTER COLUMN "phone" DROP DEFAULT,
ALTER COLUMN "hours" TYPE text,
ALTER COLUMN "hours" DROP NOT NULL,
ALTER COLUMN "hours" DROP DEFAULT,
ALTER COLUMN "picture_type" TYPE varchar(64),
ALTER COLUMN "picture_type" DROP NOT NULL,
ALTER COLUMN "picture_type" DROP DEFAULT,
ALTER COLUMN "menu_text" TYPE text,
ALTER COLUMN "menu_text" DROP NOT NULL,
ALTER COLUMN "menu_text" DROP DEFAULT,
ALTER COLUMN "comments" TYPE text,
ALTER COLUMN "comments" DROP NOT NULL,
ALTER COLUMN "comments" DROP DEFAULT,
ALTER COLUMN "price_range_id" TYPE integer,
ALTER COLUMN "price_range_id" DROP NOT NULL,
ALTER COLUMN "price_range_id" DROP DEFAULT,
ALTER COLUMN "user_id" TYPE integer,
ALTER COLUMN "user_id" DROP NOT NULL,
ALTER COLUMN "user_id" DROP DEFAULT,
ALTER COLUMN "website" TYPE varchar(254),
ALTER COLUMN "website" DROP NOT NULL,
ALTER COLUMN "website" DROP DEFAULT,
ALTER COLUMN "country" TYPE varchar(64),
ALTER COLUMN "country" DROP NOT NULL,
ALTER COLUMN "country" DROP DEFAULT,
ALTER COLUMN "tableParameters" TYPE ,
ALTER COLUMN "tableParameters" DROP DEFAULT;
ALTER TABLE "public"."shopping_list_ingredients"
ALTER COLUMN "id" TYPE serial ,
ALTER COLUMN "id" SET NOT NULL,
ALTER COLUMN "id" DROP DEFAULT,
ALTER COLUMN "shopping_list_id" TYPE integer,
ALTER COLUMN "shopping_list_id" SET NOT NULL,
ALTER COLUMN "shopping_list_id" DROP DEFAULT,
ALTER COLUMN "ingredient_id" TYPE integer,
ALTER COLUMN "ingredient_id" SET NOT NULL,
ALTER COLUMN "ingredient_id" DROP DEFAULT,
ALTER COLUMN "unit_id" TYPE integer,
ALTER COLUMN "unit_id" SET NOT NULL,
ALTER COLUMN "unit_id" DROP DEFAULT,
ALTER COLUMN "qualifier" TYPE varchar(32),
ALTER COLUMN "qualifier" DROP NOT NULL,
ALTER COLUMN "qualifier" DROP DEFAULT,
ALTER COLUMN "quantity" TYPE float,
ALTER COLUMN "quantity" SET NOT NULL,
ALTER COLUMN "quantity" DROP DEFAULT,
ALTER COLUMN "user_id" TYPE integer,
ALTER COLUMN "user_id" DROP NOT NULL,
ALTER COLUMN "user_id" DROP DEFAULT,
ALTER COLUMN "tableParameters" TYPE ,
ALTER COLUMN "tableParameters" DROP DEFAULT;
ALTER TABLE "public"."shopping_list_recipes"
ALTER COLUMN "id" TYPE serial ,
ALTER COLUMN "id" SET NOT NULL,
ALTER COLUMN "id" DROP DEFAULT,
ALTER COLUMN "shopping_list_id" TYPE integer,
ALTER COLUMN "shopping_list_id" SET NOT NULL,
ALTER COLUMN "shopping_list_id" DROP DEFAULT,
ALTER COLUMN "recipe_id" TYPE integer,
ALTER COLUMN "recipe_id" SET NOT NULL,
ALTER COLUMN "recipe_id" DROP DEFAULT,
ALTER COLUMN "servings" TYPE integer,
ALTER COLUMN "servings" DROP NOT NULL,
ALTER COLUMN "servings" SET DEFAULT 1,
ALTER COLUMN "user_id" TYPE integer,
ALTER COLUMN "user_id" DROP NOT NULL,
ALTER COLUMN "user_id" DROP DEFAULT,
ALTER COLUMN "tableParameters" TYPE ,
ALTER COLUMN "tableParameters" DROP DEFAULT;
ALTER TABLE "public"."shopping_lists"
ALTER COLUMN "id" TYPE serial ,
ALTER COLUMN "id" SET NOT NULL,
ALTER COLUMN "id" DROP DEFAULT,
ALTER COLUMN "name" TYPE varchar(64),
ALTER COLUMN "name" SET NOT NULL,
ALTER COLUMN "name" DROP DEFAULT,
ALTER COLUMN "user_id" TYPE integer,
ALTER COLUMN "user_id" DROP NOT NULL,
ALTER COLUMN "user_id" DROP DEFAULT,
ALTER COLUMN "tableParameters" TYPE ,
ALTER COLUMN "tableParameters" DROP DEFAULT;
ALTER TABLE "public"."sources"
ALTER COLUMN "id" TYPE serial ,
ALTER COLUMN "id" SET NOT NULL,
ALTER COLUMN "id" DROP DEFAULT,
ALTER COLUMN "name" TYPE varchar(64),
ALTER COLUMN "name" DROP NOT NULL,
ALTER COLUMN "name" DROP DEFAULT,
ALTER COLUMN "description" TYPE text,
ALTER COLUMN "description" DROP NOT NULL,
ALTER COLUMN "description" DROP DEFAULT,
ALTER COLUMN "user_id" TYPE integer,
ALTER COLUMN "user_id" DROP NOT NULL,
ALTER COLUMN "user_id" DROP DEFAULT,
ALTER COLUMN "tableParameters" TYPE ,
ALTER COLUMN "tableParameters" DROP DEFAULT;
ALTER TABLE "public"."stores"
ALTER COLUMN "name" TYPE varchar(32),
ALTER COLUMN "name" SET NOT NULL,
ALTER COLUMN "name" DROP DEFAULT,
ALTER COLUMN "layout" TYPE text,
ALTER COLUMN "layout" DROP NOT NULL,
ALTER COLUMN "layout" DROP DEFAULT,
ALTER COLUMN "id" TYPE serial ,
ALTER COLUMN "id" SET NOT NULL,
ALTER COLUMN "id" DROP DEFAULT,
ALTER COLUMN "tableParameters" TYPE ,
ALTER COLUMN "tableParameters" DROP DEFAULT;
ALTER TABLE "public"."units"
ALTER COLUMN "id" TYPE serial ,
ALTER COLUMN "id" SET NOT NULL,
ALTER COLUMN "id" DROP DEFAULT,
ALTER COLUMN "name" TYPE varchar(64),
ALTER COLUMN "name" SET NOT NULL,
ALTER COLUMN "name" DROP DEFAULT,
ALTER COLUMN "abbreviation" TYPE varchar(8),
ALTER COLUMN "abbreviation" SET NOT NULL,
ALTER COLUMN "abbreviation" DROP DEFAULT,
ALTER COLUMN "system" TYPE integer,
ALTER COLUMN "system" SET NOT NULL,
ALTER COLUMN "system" DROP DEFAULT,
ALTER COLUMN "sort_order" TYPE integer,
ALTER COLUMN "sort_order" SET NOT NULL,
ALTER COLUMN "sort_order" DROP DEFAULT,
ALTER COLUMN "tableParameters" TYPE ,
ALTER COLUMN "tableParameters" DROP DEFAULT;
ALTER TABLE "public"."users"
ALTER COLUMN "username" TYPE varchar(32),
ALTER COLUMN "username" SET NOT NULL,
ALTER COLUMN "username" DROP DEFAULT,
ALTER COLUMN "password" TYPE varchar(255),
ALTER COLUMN "password" SET NOT NULL,
ALTER COLUMN "password" DROP DEFAULT,
ALTER COLUMN "name" TYPE varchar(64),
ALTER COLUMN "name" SET NOT NULL,
ALTER COLUMN "name" DROP DEFAULT,
ALTER COLUMN "access_level" TYPE integer,
ALTER COLUMN "access_level" SET NOT NULL,
ALTER COLUMN "access_level" SET DEFAULT 0,
ALTER COLUMN "language" TYPE varchar(8),
ALTER COLUMN "language" SET NOT NULL,
ALTER COLUMN "language" SET DEFAULT 'en',
ALTER COLUMN "country" TYPE varchar(8),
ALTER COLUMN "country" SET NOT NULL,
ALTER COLUMN "country" SET DEFAULT 'us',
ALTER COLUMN "email" TYPE varchar(64),
ALTER COLUMN "email" SET NOT NULL,
ALTER COLUMN "email" DROP DEFAULT,
ALTER COLUMN "id" TYPE serial ,
ALTER COLUMN "id" SET NOT NULL,
ALTER COLUMN "id" DROP DEFAULT,
ALTER COLUMN "reset_token" TYPE varchar(255),
ALTER COLUMN "reset_token" DROP NOT NULL,
ALTER COLUMN "reset_token" DROP DEFAULT,
ALTER COLUMN "locked" TYPE boolean,
ALTER COLUMN "locked" SET NOT NULL,
ALTER COLUMN "locked" SET DEFAULT 'FALSE',
ALTER COLUMN "meal_plan_start_day" TYPE integer,
ALTER COLUMN "meal_plan_start_day" SET NOT NULL,
ALTER COLUMN "meal_plan_start_day" SET DEFAULT 0,
ALTER COLUMN "tableParameters" TYPE ,
ALTER COLUMN "tableParameters" DROP DEFAULT;
ALTER TABLE "public"."vendor_products"
ADD COLUMN "name" varchar(255) DEFAULT NULL,
ALTER COLUMN "id" TYPE serial ,
ALTER COLUMN "id" SET NOT NULL,
ALTER COLUMN "id" DROP DEFAULT,
ALTER COLUMN "ingredient_id" TYPE integer,
ALTER COLUMN "ingredient_id" SET NOT NULL,
ALTER COLUMN "ingredient_id" DROP DEFAULT,
ALTER COLUMN "vendor_id" TYPE integer,
ALTER COLUMN "vendor_id" SET NOT NULL,
ALTER COLUMN "vendor_id" DROP DEFAULT,
ALTER COLUMN "code" TYPE varchar(32),
ALTER COLUMN "code" DROP NOT NULL,
ALTER COLUMN "code" DROP DEFAULT,
ALTER COLUMN "user_id" TYPE integer,
ALTER COLUMN "user_id" DROP NOT NULL,
ALTER COLUMN "user_id" DROP DEFAULT,
ALTER COLUMN "tableParameters" TYPE ,
ALTER COLUMN "tableParameters" DROP DEFAULT;
ALTER TABLE "public"."vendors"
ADD COLUMN "request_type" varchar(10) DEFAULT 'GET',
ADD COLUMN "format" varchar(255) DEFAULT NULL,
ALTER COLUMN "id" TYPE serial ,
ALTER COLUMN "id" SET NOT NULL,
ALTER COLUMN "id" DROP DEFAULT,
ALTER COLUMN "name" TYPE varchar(64),
ALTER COLUMN "name" SET NOT NULL,
ALTER COLUMN "name" DROP DEFAULT,
ALTER COLUMN "home_url" TYPE varchar(255),
ALTER COLUMN "home_url" DROP NOT NULL,
ALTER COLUMN "home_url" DROP DEFAULT,
ALTER COLUMN "add_url" TYPE varchar(255),
ALTER COLUMN "add_url" DROP NOT NULL,
ALTER COLUMN "add_url" DROP DEFAULT,
ALTER COLUMN "tableParameters" TYPE ,
ALTER COLUMN "tableParameters" DROP DEFAULT;
Hello,
This is not really an issue, more a wanted feature.
I used "Gourmet Recipe Manager" but wanted a better webinterface for my recipies so I installed this.
But i'm missing one of the best functions from "Gourmet..." and that is to import recipies from web pages.
That would be cool if you cold do this in this app to.
Best Regards,
Noiden
I built a fresh CentOS 7 install. I installed epel-release, httpd, mariadb, php, php-mysql, php-mcrypt, php-gd. I put the firewall rules in and it will serve an info.php. I then untar the files into /var/www/html/phprecipebook. I chown -R apache:apache /var/www/html/phprecipebook to make sure permissions were good. I created a database and changed the db config. When I browse http://ipaddress/phprecipebook or http://ipaddress/phprecipebook/index.php I get http error 500. I followed the instructions for mod_rewrite on apache2.4 but it didn't help. P
I re-installed due to the issue with updating the schema I posted earlier. Everything seems to be working fine now, but when I did the installation there was not a wizard to create the database entries or any wizard at all. I had to manually run cake schema create.
In Views/Recipes/edit.ctp lines 130 and 132 you have a leading forward slash that needs to be removed.
Should be:
if ($(this).is("[ingredient-delete]")) {
ajaxGet(baseUrl + "Recipes/RemoveIngredientMapping/" + recipeId + "/" + itemId, "ingredientDeleteResponse");
} else {
ajaxGet(baseUrl + "Recipes/RemoveRecipeMapping/" + recipeId + "/" + itemId, "recipeDeleteResponse");
}
The core ingredients do not seem to be available. I am being forced to recreate all the work someone else already did. It doesn't matter if "Create with default ingredients" is selected or not.
I see there's a closed issue related to this, but I'm wondering what all was done to fix this for Vittorio? Here's what I have happening.
# BEGIN WordPress
# END WordPress
Tried adding the following to my .htaccess in the root level RewriteBase /
Tried modifying Config/core.php while removing .htaccess files in webroot/ and app/ Uncomment //Configure::write('App.baseUrl', env('SCRIPT_NAME'));
Ensured the temp directory is writable by the web user
I've cleared Clear the ./tmp/cache/models, ./tmp/cache/persistent directories
At the moment, I get the following when I hit the url in a browser:
Warning: include(/home/content/07/3042307/html/cookbook2/Vendor/cakephp/cakephp/lib/Cake/bootstrap.php): failed to open stream: No such file or directory in /home/content/07/3042307/html/cookbook2/webroot/index.php on line 97
Warning: include(): Failed opening '/home/content/07/3042307/html/cookbook2/Vendor/cakephp/cakephp/lib/Cake/bootstrap.php' for inclusion (include_path='.:/usr/local/php5_4/lib/php') in /home/content/07/3042307/html/cookbook2/webroot/index.php on line 97
Fatal error: CakePHP core could not be found. Check the value of CAKE_CORE_INCLUDE_PATH in APP/webroot/index.php. It should point to the directory containing your /cake core directory and your /vendors root directory. in /home/content/07/3042307/html/cookbook2/webroot/index.php on line 104
Any ideas what I might be missing?
I think the redesign looks wonderful. Well done!!! Thank you in advance for you assistance with this.
Russ
I think it may be a phprecipebook.conf issue, can you give me a sample of what mine should look like?
When I browse to the site, I get this:
setDataSource($g_rb_database_type,$g_rb_database_host,$g_rb_database_user,$g_rb_database_password,$g_rb_database_name); $SMObj->setDebug($g_rb_debug); $SMObj->openDataSource(); // open the connection $DB_LINK = $SMObj->getDataSource(); // get the database connection object (adodb) // Global function, isValidID() function isValidID($id) { if (empty($id)) return false; elseif ($id < 1) return false; elseif (version_compare(phpversion(), "5.2.0", ">=") && !filter_var($id, FILTER_VALIDATE_INT)) return false; elseif (!is_numeric($id)) return false; else return true; } // Global Function, isValidLetter() function isValidLetter($letter, $exception) { if (empty($letter)) return false; elseif (strlen($letter) > 1) return false; elseif ($letter == $exception) return true; elseif (!preg_match("/[A-Z\s_]/i", $letter) > 0) return false; else return true; } $LangUI = new LangUI; // handles translations global $g_browser_lang; // give global access to this information $g_browser_lang = getBrowserLanguage(); // preg_match for letters, numbers, underscore, and hyphen. Reject anything else
"; $SMObj->setErrorMsg(''); //reset it, we have read it. } // Load the module that is requested if (file_exists("modules/$m/$a.php")) { include "modules/$m/$a.php"; } else { include "modules/$g_rb_default_module/$g_rb_default_page.php"; } if ($format == "yes") { if ($mobile) { // And the default mobile footer to close things require "themes/$g_rb_theme/footer_mob.php"; } else { // And the default footer to close things require "themes/$g_rb_theme/footer.php"; } } // Save the session infor and clean things up saveSecurityModel($SMObj); $LangUI->cleanUp(); ?>
My phprecipebook.conf looks like this:
<VirtualHost *:80>
ServerAdmin [email protected]
ServerName recipe.me.com
# Indexes + Directory Root.
DirectoryIndex index.php index.html
DocumentRoot /var/www/recipe.me.com/htdocs
# Main directory
<Directory /var/www/recipe.me.com/htdocs>
Options Indexes FollowSymLinks MultiViews
AllowOverride All
Order allow,deny
allow from all
</Directory>
# CGI Directory
ScriptAlias /cgi-bin/ /usr/lib/cgi-bin/
<Location /cgi-bin>
Options +ExecCGI
</Location>
# Logfiles
ErrorLog ${APACHE_LOG_DIR}/recipe.me.com.error.log
CustomLog ${APACHE_LOG_DIR}/recipe.me.com.access.log combined
Everything works fine when I upload the .tar.gz for 5.0.1 from the releases page.
But, when I clone the repository from git and follow the instructions, I can never make it to where index.php loads. Am I doing something wrong, or does this relate to issue #3?
I'm using Ubuntu 14.04, Apache 2.4.7, CakePHP 2.6.2
Some of the errors in the apache error log are:
PHP Warning: include(/var/www/html/recipe/Vendor/cakephp/cakephp/lib/Cake/bootstrap.php): failed to open stream: No such file or directory in /var/www/html/recipe/webroot/index.php on line 97
PHP Warning: include(): Failed opening '/var/www/html/recipe/Vendor/cakephp/cakephp/lib/Cake/bootstrap.php' for inclusion (include_path='.:/usr/share/php:/usr/share/pear') in /var/www/html/recipe/webroot/index.php on line 97
PHP Fatal error: CakePHP core could not be found. Check the value of CAKE_CORE_INCLUDE_PATH in APP/webroot/index.php. It should point to the directory containing your /cake core directory and your /vendors root directory. in /var/www/html/recipe/webroot/index.php on line 104
PHP Warning: include(/var/www/html/recipe/Vendor/cakephp/cakephp/lib/Cake/bootstrap.php): failed to open stream: No such file or directory in /var/www/html/recipe/webroot/index.php on line 97
Thanks!
Recipes that have qualifiers in the ingredients list don't show those qualifiers when the recipe is viewed.
An example is in the demo database as recipe "qualifier test".
I am able to create a recipe, but when I go to delete, this is the error on a white blank screen
Notice (8): Undefined index: image [APP/Plugin/Upload/Model/Behavior/UploadBehavior.php, line 1987]
Code Context
UploadBehavior::_prepareFilesForDeletion() - APP/Plugin/Upload/Model/Behavior/UploadBehavior.php, line 1987
UploadBehavior::beforeDelete() - APP/Plugin/Upload/Model/Behavior/UploadBehavior.php, line 432
ObjectCollection::trigger() - APP/Vendor/cakephp/cakephp/lib/Cake/Utility/ObjectCollection.php, line 128
call_user_func - [internal], line ??
CakeEventManager::dispatch() - APP/Vendor/cakephp/cakephp/lib/Cake/Event/CakeEventManager.php, line 243
Model::delete() - APP/Vendor/cakephp/cakephp/lib/Cake/Model/Model.php, line 2680
RecipesController::delete() - APP/Controller/RecipesController.php, line 232
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - APP/Vendor/cakephp/cakephp/lib/Cake/Controller/Controller.php, line 490
Dispatcher::_invoke() - APP/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - APP/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 113
your help is appreciated
I'm using the current release version 5.0.8 of PHPRecipebook and noticed an HTTPS to HTTP downgrade. I assume the automatic detection of the full base URL ignores the protocol scheme.
Steps to reproduce:
Expected result:
The browsing location is https://recipes.example.org/users/login
Actual result:
The browsing location is http://recipes.example.org/users/login
Workaround:
Force access to the webapplication to use HTTPS either via
Issue: Prior to this upgrade I had renamed my 'admin' user.
Symptoms: During the upgrade you receive the following error in a yellow window at the top of your browser.
../Controller/SetupController.php (line 45)
array(
'username' => array(
(int) 0 => 'required',
(int) 1 => 'required'
),
'access_level' => array(
(int) 0 => 'numeric',
(int) 1 => 'numeric'
)
)
Overview and resolution:
What I found during the upgrade to release 5.0.6 was that before I was able to successfully complete the upgrade wizard I needed to modify line 33 in ../Controllers/SetupController.php
From: $user = $this->User->findByUsername('admin');
To: $user = $this->User->findByUsername('myadminusernamehere');
Upon completion of the upgrade I modified this back to: $user = $this->User->findByUsername('admin');
Hi,
I tried to install the project clean, and got errors straight afterwards.
This is on a shared hosting plan so am unable to run linux commands.
Table meal_plans for model MealPlan was not found in datasource default.
Table attachments for model Image was not found in datasource default.
Table shopping_lists for model ShoppingList was not found in datasource default.
Table restaurants for model Restaurant was not found in datasource default.
I assure you those tables exist in the db.
Thanks
Hi,
I would like to add an Barcode (EAN) to the Database schema.
My vision is following...
a) Add to shopping list:
Use Barcode Scanner to get an EAN from a "empty" ingredient.
Put this ingredient (identified by a comparison to the previously updated database) to the shopping list
b) Add a recipe to the meal planner:
Use a prepared "Hand-out" with favourite recipes picture -> scan custom-EAN to generate the meal plan.
I bought a cheap Bardcode-scanner, which sends the detected EAN to a python script.
Now I need a good idea to update a) Shopping list and b) Meal planner via python...
Any suggesting s ?
Would really like to be able to import my old recipes from PhpRecipeBook 2.3x, but it only exports in either RecipeML or PhpRecipeBook XML formats. Any chance of being able to import these?
If I set the number of servings to something else than the default number, the amount that I have to buy is not updated.
Hi, when i run phprecipebook i see the wizard setup however I keep getting the message "URL Rewriting might not be properly configured on your server". I have mod_rewrite installed as it appears as an installed module when you run phpinfo.php
Any ideas? I am running a QNAP NAS setup. I've tried modifying the .htaccess files to no avail. Will have to disable rewrite if i can't cakephp to use it.
Cheers
Dom
I have tried to import a meal master file and i get the attached error
I have also attached the meal master import im trying to import
Thanks
Is it possible to import recipies from CSV or Excel?
If it is, how should the file be?
I have a server using Amahi and recently it had a pretty catastrophic error so I've had to largely start from scratch. I reinstalled Recipebook, and I have a backup of the old app so I was hoping to use my old recipe database so that i'm not starting from the beginning. My old system that crashed was Amahi 9 and I reinstalled a fresh install of Amahi 10, but I didn't think that impacted the PHPRecipeBook version #. I was hoping to be able to move the 'recipedb.sql' file from the backup in to the newly installed location but I'm rather lost on next steps or getting everything to work right. Any help is greatly appreciated, I'm a novice in PHP, Linux, coding, etc.
hello, my installation ask me for an "Phprecipebook5Controller.php" file. Since that file doesn't exists, how I can create it?
Thk & rgds
Hello,
I apologize in advance if this is not the appropriate forum to broadcast such a request or if my request violates some kind of rule or policy. I was unable to find contact information for any of the project developers so I am leaving my request here.
I installed PHPRecipebook a few months back (July '17 time frame) and have enjoyed using the software. I have found a few little bugs that make using the software a little cumbersome for folks a little less patient that myself (such as my wife). I would like to say for the record though that I find this particular piece of software very useful and, for the most part, very easy to use. I think that it has a whole lot of potential if a few of the bugs can be worked out.
I know that developing a community project like this takes time and resources (money). While I am not a programmer myself, I would be happy help out with the project in any way I can (financial contributions, web hosting, testing, etc.) in order to help this project into a more mature form.
If anyone of the developers here is interested in taking me up on my offer, I would be more than willing to discuss the project's needs here or via e-mail or telephone. Please respond as soon as is convenient.
Thank you,
Jason
If I have a shopping list with a recipe on it and then I go to the recipe page and delete the recipe, I get sent to a white page as soon as I click delete that says: Notice (8): Undefined index: image [APP/Plugin/Upload/Model/Behavior/UploadBehavior.php, line 1987]
Then on the shopping list page errors are shown:
Notice (8): Undefined index: name [APP/View/ShoppingLists/index.ctp, line 97]
Notice (8): Undefined index: id [APP/View/ShoppingLists/index.ctp, line 98]
Notice (8): Undefined index: serving_size [APP/View/ShoppingLists/index.ctp, line 113]
Other side effects of this (which may only apply when you delete all of your recipes, I only had one recipe and I deleted it, not sure what would happen if I still had recipes left):
I don't have the ability to import the database schema through a console script, so I attempted to import it with a desktop client instead, with only partial success due to some apparent errors in the structure code. Specifically, these declarations are causing all kinds of fits trying to run them, and I don't know how to resolve them without potentially breaking app code down the road:
CREATE table attachments (
id INT NOT NULL AUTO_INCREMENT,
recipe_id INT NOT NULL REFERENCES recipes(id) ON DELETE CASCADE,
name
varchar(32) NOT NULL,
attachment
varchar(255) NOT NULL,
dir
varchar(255) DEFAULT NULL,
type
varchar(255) DEFAULT NULL,
size
int(11) DEFAULT 0,
sort_order INT
PRIMARY KEY (id
) <==== WILL NOT IMPORT WHEN TICKS ARE USED AROUND 'id' HERE
);
CREATE TABLE ingredient_mappings (
id INT NOT NULL AUTO_INCREMENT,
recipe_id INT NOT NULL REFERENCES recipes(id) ON DELETE CASCADE,
ingredient_id INT NOT NULL REFERENCES ingredients(id) ON DELETE CASCADE,
quantity FLOAT NOT NULL,
unit_id INT REFERENCES units(id) ON DELETE SET NULL,
qualifier VARCHAR(32),
optional BOOL,
sort_order INT,
PRIMARY KEY (ingredient_id,recipe_id) <==== HOW CAN YOU HAVE TWO "PRIMARY" KEYS?? SERVER WILL NOT EVEN ALLOW ME TO MANUALLY ATTEMPT THIS.
);
CREATE TABLE related_recipes (
id INT NOT NULL AUTO_INCREMENT,
parent_id INT NOT NULL REFERENCES recipes(id) ON DELETE CASCADE,
recipe_id INT NOT NULL REFERENCES recipes(id) ON DELETE CASCADE,
required BOOL,
sort_order INT,
PRIMARY KEY (parent_id, recipe_id) <==== AGAIN, TWO PRIMARY KEYS??
);
The first table declaration imports just fine after removing the ticks around "id" at the PRIMARY KEY declaration.
The next two tables simply can't work (for me, at least) with the dual PRIMARY KEYs. Are these truly errors in the SQL, or am I running into yet more issues with shared web hosting again? I've never seen more than a single primary key in a table, but like I said, I'm no expert DBA so I can't say if that's legitimate or not.
Users should not be able to delete user ID 1. Some code is dependent on it and things are not going to work well without the admin user around.
Moved issue over from SourceForge bug list. Still relevant issue even after rewrite
Hi
I'm quite new to php and trying to learn the ropes! I've managed to get phprecipebook working and now trying out the new online shopping feature in version 5.0 which is great but it seems the product code is not pulled back from the vendor product table into the shopping list?
I added an ingredient, and selected the online vendor. If i click add nothing happens, however if i repaste the product code into the entry box next to add, then click add, then it works!
Any thoughts?
Dom
The Core Ingredients "More Actions" link does nothing. Seems like this should have similar functionality as the one in the regular Ingredients "More Actions" link.
Trying to install v5.1.0 under Windows 7 using a portable XAMPP v5.6.28 installation and the download install option. Everything is fine up to creating the database schema. The install page shows instructions for setting it up under UNIX (sudo ./Console/cake schema create) but no instructions for Windows. If I go into phpMyAdmin and try to import the database schema from \phprecipebook\Config\SQL\schema_MySQL.sql, I get multiple syntax errors and it refuses to import.
Schemas from older versions fail in the same way.
Hello,
I am running the PHPRecipebook installed on heroku, and I get following error when i'm trying to add any ingredient in a recipe:
It appears that the demo site (which seems like that's also deployed via heroku) has exact same problem. Is there a bug regarding recipe addition in the latest release?
Thanks.
Is there a way to only allow authenticated users. I would like to make sure only approved people can see any part of the recipes. I use it as a family heirloom cookbook so we want to be able to share the recipes in the family but not outside.
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.