Joomla! Template 002041 - Item Support

Somebody worked on my website an used this template. Since then Joomla updated but the template for some reason didn't, so I am stuck on version 3.02 which causes issues. Can someone tell me how I can update it?

Thanks,

Alex
Hello EUROLUX,
We are sorry, we do not see this item under you Purchased items section.
Please contact to the person who developed to you your site.

Regards, AS Team.
I realize that there is nothing under the account, I just opened it. The person who worked on my site abandoned it and I have to clean up the mess now. I have no way to contact him. The question I have is should the template update automatically in Joomla?
Hello EUROLUX,
Sorry, Joomla templates can't be updated automatically.

Regards, AS Team.
Well then how do I update it?
Hello EUROLUX,
First you have to purchase this template, then update your files accordingly to the our Release page:
http://www.astemplates.com/joomla-template-news/152-002041

Please do not forget about backups.

Regards, AS Team.
How do I update them in Joomla. In your "How to" you only refer to install but no update instructions.
Hello EUROLUX,
You have just to upload the updated files on your server via FTP.
Before replacing please backup old files, probably the person who worked on your website made some important changes.

Regards, AS Team.
OK, I updated to the 3.1.0 version and still getting error on my homepage:

1064 - 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 'ORDER BY RAND()' at line 25 SQL=SELECT content.id AS ID, cats.name AS cat_name, cats.alias AS cat_alias, content.catid AS cat_id, users.name AS author, users.email AS author_email, users.id AS author_id, content_rating.rating_sum AS rating_sum, content_rating.rating_count AS rating_count FROM afqcd_k2_items AS content LEFT JOIN afqcd_k2_categories AS cats ON cats.id = content.catid LEFT JOIN afqcd_users AS users ON users.id = content.created_by LEFT JOIN afqcd_k2_rating AS content_rating ON content.id = content_rating.itemID WHERE ORDER BY RAND()


Any idea what might cause this?
Hello EUROLUX,
This error message is related to K2 component, have you updated it as well? What is your site url please?

Regards, AS Team.
I have the latest version of K2 (2.6.9) installed. My website is not online yet, as I am still working yet. The url is el.euroluxkitchens.ca
Hello EUROLUX,
Does your website installed using quick-start installation package? Sorry, without to see your site we can't help you.

Regards, AS Team.
Item Name:
002041
Author:
Downloads:
5039
Sales:
1233
Created:
2012-10-18
Updated:
2016-10-18
Item Version:
3.3.0
$29.00
Regular License
This item may be used for a single domain only.
$39.00
Extended License

AS Designing Templates Club

Templates Club
Get an access to all 96 items designed and developed by AS Designing team plus all the future items which will be released over the course of your club subscription.

Price starting from $59.00