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 issued a fix for problem with editing of Header Menu Items after release 3.3.1 has been issued.
 
Description.
An error like the following appears after pressing 'Edit Menu Item' link on Administration > Layouts > [Layout Name] > Site Navigation.
 
DB Error 1054
...
Database error: Invalid SQL: SELECT layout_id, menu_order, menu_title, menu_url, menu_target, submenu_style_name, menu_image, menu_image_active, show_non_logged, show_logged, parent_menu_id FROM va_header_links WHERE menu_id=52
MySQL Error: Unknown column 'submenu_style_name' in 'field list'
 
Solution.
Please download a script from here:
http://www.viart.com/downloads/va_fix_header_links-3.3.1.zip
Then extract it into the root folder of your shop and run in web browser window like in the following example:
http://www.example.com/va_fix_header_links.php
Don't forget to make a backup copy of the database in case something goes wrong.
You should see query text in case operation was completed successfully.
After database update is completed just delete this file from web site root.
 
PayCards
PayCards
Seems to have a typo in the fix:
 
DB ERROR 1054
 
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.paycardshop.com/va_fix_header_links.php
Referrer URL:
Database error: Invalid SQL: ALTER TABLE va_header_links CHANGE COLUMN sudmenu_style_name submenu_style_name VARCHAR(64)
MySQL Error: Unknown column 'sudmenu_style_name' in 'va_header_links'
 
 
sudmenu.. should be submenu.. right??
 
Richie