Open Cart Template upgrade and some minor fixes.

Need help with a simple project...... 1. Fix this sql error. We get it sometimes as it spins the site in a circle, searches for domain and then after 20 minutes we get this error. This is the only error this site has, template is clean and well coded. Warning: mysqli::mysqli(): (HY000/2002): Can't connect to local MySQL server through socket '/var/lib/mysql/[login to view URL]' (2) in /home/kingasho/public_html/system/library/db/[login to view URL] on line 7 Warning: mysql_error() expects parameter 1 to be resource, object given in /home/kingasho/public_html/system/library/db/[login to view URL] on line 10 Warning: mysql_errno() expects parameter 1 to be resource, object given in /home/kingasho/public_html/system/library/db/[login to view URL] on line 10 Notice: Undefined variable: trace in /home/kingasho/public_html/system/library/db/[login to view URL] on line 10 Notice: Undefined variable: trace in /home/kingasho/public_html/system/library/db/[login to view URL] on line 10 Notice: Undefined variable: sql in /home/kingasho/public_html/system/library/db/[login to view URL] on line 10 Fatal error: Uncaught exception 'Exception' with message 'Error: <br />Error No: <br /> Error in: <b></b> line <b></b><br />' in /home/kingasho/public_html/system/library/db/[login to view URL] Stack trace: #0 /home/kingasho/public_html/system/library/[login to view URL](9): DB\MySQLi->__construct('localhost', 'kingasho_ocar46...', '4P0)SDA[12', 'kingasho_ocar46...', '3306') #1 /home/kingasho/public_html/system/[login to view URL](25): DB->__construct('mysqli', 'localhost', 'kingasho_ocar46...', '4P0)SDA[12', 'kingasho_ocar46...', '3306') #2 /home/kingasho/public_html/[login to view URL](34): require_once('/home/kingasho/...') #3 {main} thrown in /home/kingasho/public_html/system/library/db/[login to view URL] on line 10 [login to view URL] update upload for OpenCart 2.2 - Coysone 2.3 newest version (I have a download) Proably opencart and vqmod needs to be updated. 3. Upload SEO Pack extension to version 8.46. 3. Correct domain redirects – a. www and none www b. https:// and http:// When I do the SEO test – I get a message – TOO MANY REDIRECTS. It is a problem for google since they do not know what site to index?????? (see picture) I want to keep one domain. I am currently using canonical links for major pages since google does not know what to scan. 4. Check all the settings on google - few blocked parameters, [login to view URL], and like to ask how to remove 404 links from the site. I can do it myself but I have few questions how to remove them. Basically I like the site to index better and some settings preventing that. 5. Also check my [login to view URL] – I have them all correct but some are not blocking the links as they should.