Ingredients do not get saved

mrweaver - April 21, 2008 - 16:31
Project:Recipe
Version:5.x-1.0
Component:Miscellaneous
Category:support request
Priority:normal
Assigned:Unassigned
Status:active
Description

Hi. I have tried this module and had a problem. When I save a recipe, the ingredients do not get saved. I get a long string of error messages that disappear when the final recipe is saved. And since they disappear, I can't reproduce them here. But they appear to be database-related.

Thanks
mrweaver

#1

marble - April 21, 2008 - 17:59

Hmm. Where do they appear, that they then disappear before you can copy them? Which database are you using (mysql or postgres?) Do any other drupal modules on your system work? Do you see any of them in your logs? (Administer->Logs->Recent Log Entries)

#2

mrweaver - April 21, 2008 - 19:48

I'm using Mysql database, other modules work fine. Thanks for reminding me to check my logs. Here is the error message.
Out of range value adjusted for column 'link' at row 1 query: INSERT INTO recipe_ingredient (name, link) VALUES ('pork chop', '') in C:\Program Files\Apache Group\Apache2\htdocs\includes\database.mysql.inc on line 172.

I guess it's getting hung up on the "link".

Thanks for getting back to me so quickly.

mrweaver

#3

marble - April 21, 2008 - 19:57

Could you try the patch at http://drupal.org/node/241423 and let me know if it fixes your problem?

#4

neel - April 22, 2008 - 12:28

I also have the same problem. I tried for patch, but it is not working. What to do next? please help.

#5

marble - April 22, 2008 - 17:42

neel: same problem, so same question: what's in your logs?

#6

brdwor - April 22, 2008 - 17:50

additional questions:
-What http server are you running?
-What php verison?
-What sql server and version?
-Did a previous release of Recipe.module work for you under Drupal 5.x?
-Was this an upgrade of an existing database or a fresh install?

#7

mrweaver - April 22, 2008 - 21:20

I tried the patch, and the ingredients are getting saved.

Thanks!

mrweaver

#8

neel - April 23, 2008 - 06:29

details about my system

Apache version 2.2.8 (Unix)
PHP version 5.2.5
MySQL version 4.1.22-standard
Architecture i686
Operating system Linux

I tried older versions but same problem was there so I did not use it. Now I saw new release so wanna try it. I un-installed that old one and installed this as fresh. but still problem is there.

Then I change the patch in main recipe module, but no change.

Please tell me what to do now.

 
 

Drupal is a registered trademark of Dries Buytaert.