Our site www.viart.com site is operated by latest Viart Shop 5 with default Clear design
Topic Information
ViArt Team (Guest)
ViArt Team (Guest)
Brief.
We have made a fix of admin_product.php after release 3.2 has been issued.
 
Description.
Subcomponents were not duplicated and caused an SQL error while selecting to duplicate product with properties.
 
Solution.
Please download an updated version of the files from here:
http://www.viart.com/downloads/admin_product-3.2.zip
Then extract the file admin_product.php into the folder 'admin' of your shop replacing the existing one.
Don't forget to make a backup copy of the current file in case something goes wrong.
 
Stephen Strother (Guest)
Stephen Strother (Guest)
Viart Team,
 
The subcomponent glitch and SQL error still exist. I just attempted to use the duplicate feature after uploading the fix file. Below is the error received:
 
=================
DB ERROR 1048
 
We are very sorry, but an error has occurred while processing your request. Please try the operation again by either pressing the Refresh button on your browser, or by going back one page using the Back button. If the error persists, please contact our web development team.
 
The details of the error are shown below. Please quote this in any correspondance regarding this problem.
 
Page URL: http://www.arlive.com/v/admin/admin_product.php
Referrer URL: http://www.arlive.com/v/admin/admin_product.php?category_id=51&item_id=139
Database error: Invalid SQL: INSERT INTO va_items_properties (property_id,item_id,property_name,property_description,control_type,control_style,required,use_on_list,use_on_details,use_on_ checkout,start_html,middle_html,end_html,control_code,onchange_code,onclick_code,property_type_id,sub_item_id,additional_price, use_on_second,property_order,property_style,before_control_html,after_control_html) VALUES (24,146,NULL,NULL,'LABEL',NULL,0,1,1,0,NULL,NULL,'
Wip Member
',NULL,NULL,NULL,1,0,NULL,0,1,NULL,'
What You Get
','
Only
')
MySQL Error: Column 'property_name' cannot be null
 
==========================
 
 
 
 
Brief.
We have made a fix of admin_product.php after release 3.2 has been issued.
 
Description.
Subcomponents were not duplicated and caused an SQL error while selecting to duplicate product with properties.
 
Solution.
Please download an updated version of the files from here:
http://www.viart.com/downloads/admin_product-3.2.zip
Then extract the file admin_product.php into the folder 'admin' of your shop replacing the existing one.
Don't forget to make a backup copy of the current file in case something goes wrong.