I attempted to upgrade 3 of my sites from 4.0.5 to 4.1 today. The first one worked fine. The other two got an error message during the last part of the process, upgrading the database. The front end site did not function correctly after the upgrade to I reverted to 4.0.5 using backups until I figure out what was wrong. Can anyone tell me what would cause this error?
 
Your database has been upgraded to 4.1
 
SQL queries succed: 206
SQL queries failed: 1
 
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 '2, 'SHOW_ORDER_RESTORE_MSG' , 'CHECKBOX' , NULL , NULL , 'show_restore' , 1 , 0' at line 1
SQL: INSERT INTO va_cms_blocks_properties (property_id,block_id,property_order,property_name,control_type,parent_property_id,parent_value_id,variable_name,default_value, required) VALUES (205, , 2, 'SHOW_ORDER_RESTORE_MSG' , 'CHECKBOX' , NULL , NULL , 'show_restore' , 1 , 0)

As explained in the ticket this error is not crucial and only says that system couldn't find the corresponding block to add a new 're-order' setting for it and the shop should be functional without it. To give more info we need access to the site.
 
Also I just checked upgrade from v.4.0.5 to 4.1 runs smoothly without any errors.
 
Regards,
ViArt Team

Thank you, Vera. All 3 sites are now working great. I had failed to copy the var_definitions.php from the includes folder; and, clearing cookies from my browser fixed the remaining issues.