Our site www.viart.com site is operated by latest Viart Shop 5 with default Clear design
Topic Information
Anjula
Anjula
Brief.
We have slightly modified the following scripts after release 3.3.2 has been issued, namely:
block_ads_hot.php
block_ads_sellers.php
block_articles_hot.php
block_merchants.php
block_products_list.php
block_products_related_purchase.php
block_products_top_rated.php
block_products_top_sellers.php
 
Description.
The below SQL error appeared while installing the shop with postgresql 8.1.9:
 
PostgreSQL Error Message: ERROR: column "a.is_remote_rss" must appear in the GROUP BY clause or be used in an aggregate function
Session halted.
 
Solution.
Please download an updated version of the files from here:
http://www.viart.com/downloads/postgre_update-3.3.2.zip
Then extract the above mentioned files into the 'blocks' folder of your shop replacing existing ones. Don't forget to make backup copies of the current files in case something goes wrong.
Last modified: 18 Dec 2007 11:06 AM
 
mANYO (Guest)
mANYO (Guest)
Hi,
 
Thx for update!
Pls check the download link.
(no download only jump to http://www.viart.com/friendly_url.php)
 
WBR,
Manyo
 
Anjula
Anjula
Hello,
 
Thanks for pointing to that. Please, try the download link again: http://viart.com/downloads/postgre_update-3.3.2.zip
 
It is working now.
 
Best regards,
ViArt Support Team