Coder Social home page Coder Social logo

phprecipebook's People

Contributors

admorgan avatar cybe avatar deathstapler avatar doppelgrau avatar ilveroluca avatar maxmikk avatar miclnl avatar nazgul26 avatar rettenbs avatar ronsaylor avatar smccloud avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

phprecipebook's Issues

The action add is not defined in controller CoreIngredientsController

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!

Edit "location in store"

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...

Polish translation

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.

Undefined function d()

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;

E-mail address is a unique key

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.

Error in core_ingredients.sql

Clean installation:
In the table core_ingredients group_id have to be groupNumber
The table recipe_core_weights have to be core_weights

URL rewriting might not properly configured on your server.

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?

Added new recipe, shows error when viewing

screen shot 2016-01-14 at 6 53 09 am

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

Cannot input Chinese characters

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...

Recipe edit

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.

Create account in demo

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.

clean installation erros

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.

Error in schema update

Pulled up to master and got the following schema errors with running ./Console/cake schema update

Path: /var/www/recipebook.morgancomputers.net/

Cake Schema Shell

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;

Import from webpage?

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

Error 500 on Install

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

Install wizard didn't run

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.

AJAX call to remove ingredient from recipe fails

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");
}

Styling suggestion

Hi guys,

thanks for the help for the clean install bit. I have a layout suggestion and that is to remove the font-size rule for the qtip.

Thanks

qtip1
qtip2

Core Ingredients not available

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.

CakePHP core could not be found and failed to open stream

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.

  1. GoDaddy is my web host
  2. My site uses ssl, so my site's root directory already does the following
    Options +FollowSymLinks
    RewriteEngine On
    RewriteCond %{SERVER_PORT} !=443
    RewriteRule ^ https://www.mydomainnamehere.org/%{REQUEST_URI} [R,L]
  # 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

Can't get to load, not sure what the issue is.

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 $g_browser_lang = (preg_match('/^(\w|-)+$/', $g_browser_lang)) ? $g_browser_lang : null; // Load the language file based on config or logged in user if ($SMObj->getUserLoginID() != NULL) { $userID = $SMObj->getUserLoginID(); $details = $SMObj->getUserDetails($userID); include "lang/".$details['language'].".php"; } else if ($g_browser_lang != NULL) { //we found a browser match load it if it exists if (file_exists('lang/'.$g_browser_lang.'.php')) include "lang/".$g_browser_lang.".php"; else include "lang/".$g_rb_language.".php"; } else { //nothing matched, load the default include "lang/".$g_rb_language.".php"; } // Convience debugging option, shows what version the database thinks it is. if ($g_rb_debug) { require_once("classes/DBUtils.class.php"); $msg = DBUtils::checkDBSchemaVersion(); } // langArray is set in en.php, it.php...etc.. $LangUI->setLangArray( $langArray ); $LangUI->setEncoding($langEncoding); $SMObj->setTranslationObject($LangUI); // pass that info on to the security manager if ($SMObj->isSecureLogin()) { $SMObj->getLoginFormSubmit(); } else { // auto login if ($SMObj->getUserLoginID() == "") $SMObj->login(); } // End of Login/Session stuff, now on to displaying the page // // m = the module, cf modules directory, eg 'search' // preg_match for letters, numbers, underscore, and hyphen. Reject anything else $m = (isset($_GET['m']) &amp;&amp; preg_match('/^(\w|-)+$/', $_GET['m'])) ? $_GET['m'] : $g_rb_default_module; // a = action, default is the index page of the module // preg_match for letters, numbers, underscore, and hyphen. Reject anything else $a = (isset($_GET['a']) &amp;&amp; preg_match('/^(\w|-)+$/', $_GET['a'])) ? $_GET['a'] : ""; $mobile = preg_match('/_mob$/', $a); if ($a == "") { if ($IsMobileBrowser) { $a = $g_rb_default_mobile_page; $mobile = true; } else { $a = $g_rb_default_page; } } // print = format for printing (minimal formating) $print = isset( $_REQUEST['print'] ) ? $_REQUEST['print'] : 'no'; $format = isset( $_REQUEST['format'] ) ? $_REQUEST['format'] : 'yes'; // Load the header stuff if ($mobile) { require "themes/$g_rb_theme/header_mob.php"; } else { require "themes/$g_rb_theme/header.php"; } // preg_match for letters, numbers, underscore, and hyphen. Reject anything else if (!empty($_REQUEST['dosql']) &amp;&amp; preg_match('/^(\w|-)+$/', $_REQUEST['dosql'])) { include "modules/$m/".$_REQUEST['dosql'].".php"; } $msg = $SMObj->getErrorMsg(); if ($msg != '') { echo $msg . "

"; $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:

(/etc/apache2/sites-available/phprecipebook.conf)

<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

Installing from git

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!

Qualifiers don't appear in recipe view

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".

Issue when deleting item

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

URL scheme not being honored (HTTPS to HTTP downgrade)

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:

  1. Activate SSL on nginx
  2. Access the application via https://recipes.example.org
  3. Click on login

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

  1. Configure::write('App.fullBaseUrl', 'https://recipes.example.org'); or an
  2. appropiate URL rewrite in nginx configuration

5.0.6 upgrade if admin account was renamed

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.

capture

../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');

Clean install giving errors

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

tables

Request: Update schema with EAN

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 ?

Import RecipeML or PHPRecipeBook Format

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?

Error message when adding image

when I go to create a new reciepe and add and image, this is the error that is returned. But the image appears to be added

eoor adding image

URL rewriting not working

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

Import from CSV?

Is it possible to import recipies from CSV or Excel?
If it is, how should the file be?

Using Backup Database

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.

Phprecipebook5Controller

hello, my installation ask me for an "Phprecipebook5Controller.php" file. Since that file doesn't exists, how I can create it?
Thk & rgds

Minor Bugs: Project Development

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

Deleting Recipe when in Shopping List Errors

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):

SQL schema problems

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.

Admin User should not be deletable

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

Online Vendor Product Codes

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

Core Ingredients More Actions link

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.

Unable to setup database schema

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.

database error when adding ingredients

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:

screen shot 2017-04-09 at 11 59 55 am

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.

Allow only authenticated users?

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.

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.