Our site www.viart.com site is operated by latest Viart Shop 5 with default Clear design
Topic Information
Anjula
Anjula
Brief
We have updated the file 'block_articles_content.php for version 3.6.
 
Description
When changed via Articles Order, the order has not been reflected in the Articles Content block on the site.
 
Solution
We would recommend you to download an updated version of the file from here:
http://www.viart.com/downloads/block_articles_content-3.6.zip
 
Further, extract the above mentioned file into the 'blocks' folder of your shop. Do not forget to make a backup copy of the current file in case something goes wrong.
 
cy (Guest)
cy (Guest)
I added this block, but still does not seem to be working properly - surely we need a patch for block_articles_list.php too, no?
 
wputler
wputler
Hi - I came across this problem. I've reported it to Viart.
 
Here's what I did to get it to work:
 
block_articles_list.php, line 170
 
//$sql .= " ORDER BY aa.article_order ";
 
changed to:
$sql .= " ORDER BY a.article_order ";
 
Then that created another problem with the "Change Order Utility"
 
So, to get the Change Article Order to change both the assigned articles table and the articles table, I added this to admin_articles_order.php, line 50:
 
//$sql = " UPDATE " . $table_prefix . "articles_assigned ";
$sql = " UPDATE " . $table_prefix . "articles ";
$sql .= " SET article_order = " . intval($i + 1);
//$sql .= " WHERE category_id = " . $db->tosql($parent_category_id, INTEGER);
//$sql .= " AND article_id = " . $articles_ids[$i];
$sql .= " WHERE article_id = " . $articles_ids[$i];
$db->query($sql);
 
This has solved my problems, but I think there must be some confusion on where Viart wants the order set - the articles table or the articles_assigned table. Until that's resolved, this should work.
 
/Wendy