Update menu item

When i click 'submit': 'Database error: unable to update menu item id: 1'

Lieven,

Have you checked that your db user has the correct privileges to update records, etc. If so, could you give me a bit more detail as I have doubled checked my installation and cannot replicate the error.

Regards

Peter

privileges are ok. When i copy the sql and try to execute in phpMyAdmin
sql:

UPDATE mymenugen_menu_items SET menu_title = 'Menu Item 1', position = 1, parent_id = '', image = '', hr_line = 'no', page_id = 100 WHERE id = '1'

MySql: error 1264, out of range value adjusted for column 'parent_id' at row 1

I am using MYSQL client v3.23.49 - my guess is you are using a different version and/or that it is stricter on passing empty strings. Please could you try and add the following to mymenugen_class.php.

Insert at line 302:
if(empty($this->parent_id)) $this->parent_id = 0;

Insert at line 333 (after inserting above):
if(empty($this->parent_id)) $this->parent_id = 0;


This will force the parent to have a value of zero (top level) if none specified. If you could test and let me know I would be very grateful. If this is the case I will work out a tidy answer and post a new version.

Many thanks

Peter

I use MySql 5.0. It works now correctly. Thanks very much for the quick answers!

Other (cosmetic :-) ) problems: the icons for 'delete this item', 'insert new line' 'move this item up' and 'move this item down' doens't show. (IE 7.0). In Firefox they don't show up also. And in Firefox the 'tooltips' are not popping up on hovering the field, they just are shown as plain text on the screen, messing up the display.

Thanks for looking at it.

Thanks for letting me know. I'll create an upgrade soon with a more tidy fix for the problem, as well as the ones you have pointed out.