MyBB Source

Yes i did a backup of my forum (1.4.9) to upgrade to (1.4.10)
and Custom Forms plugin gave me this error when i tried to import my backup

¿Could anyone help to me recover this?
i have like 20 forms i don't wish to make them all again :(

Thanks in advance

Quote:consulta SQL:

INSERT INTO ez2_forms_items( 'item_id', 'form_id', 'name', 'description', 'TYPE', 'options', 'default_value', 'cols', 'ROWS', ''size ', 'maxlength ', 'class ', 'required ', '
ORDER ' ) VALUES ('1 ','1 ','Nombre ','Ingresa tu nombre ','1 ','','','0 ','0 ','','','','1 ','0 '); INSERT INTO ez2_forms_items ( 'item_id ', 'form_id ', 'name ', 'description ', '
TYPE ' , 'options ', 'default_value ', 'cols ', '
ROWS ' , ''size', 'maxlength', 'class', 'required', 'order' )
VALUES (
'2', '1', 'Email', 'Email', '1', '', '', '0', '0', '', '', '', '1', '0'
);

MySQL ha dicho: Documentación
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''item_id', 'form_id', 'name', 'description', 'TYPE' , 'options', 'default_value'' at line 1

---

Fixed with:

Quote:INSERT INTO `ez2_forms_items` (`item_id`, `form_id`, `name`, `description`, `TYPE`, `options`, `default_value`, `cols`, `ROWS`, `size`, `maxlength`, `class`, `required`, `ORDER` )
VALUES (
'1', '1', 'Nombre', 'Ingresa tu nombre', '1', '', '', '0', '0', '', '', '', '1', '0'
);