SEOClerks

Clear
Sign In Join

Can someone help me change my site to HTTPS please?!

  • styleisland1980 Level 1
    • 22

    Write the reason you're deleting this FAQ

    Can someone help me change my site to HTTPS please?!

    Desperate to find someone who can  help me switch from htttp to https as per the new GOOGLE rules - keep seeing everyone saying we need to switch but no clue how, any help would BE much appreciated!!! Thanks, Blake 

    #Seo #Https #Security #Blog Web Hosting & Server
    Share post:

    Comments

    Please login or sign up to leave a comment

    Join
    Tronia

    Tronia

    I actually went through setting up the SSL certificate recently and it honestly isn't hard at all.

    I am not sure which web hosting company you are currently using but majority sells the SSL and even help you through installation. I know that NameCheap does and they even have a click type of install that you can do through the Cpanel.

    So, before you try and do it all yourself contact the web host and see if they sell it and set it up/guide you through.
    9 years ago

    Are you sure you want to delete this post?

    idealmike

    idealmike

    Hi Bake my best advice to you, based on what you've said is that you should contact your webhost about it. They might even be good enough to install and set it up for you. They might try and sell you their SSL though. And you might be able to get that cheaper through your domain registrar like NameCheap or GoDaddy or even buy an SSL cert through Comodo or another SSL provider. Whether you buy/use your webhosts SSL or another one, you can use either on your site. Most SSL providers give you instructions on how to install it. Plus if your site has CPanel? Or your webhost might have a knowledge bank page on it with instructions on how to set it up. If your site does have Cpanel then you might be able to make use of the free SSL option if there is one. My webhost's Cpanel has that and I sometimes use it to quickly install SSL on a new site as it's pretty straightforward! Can someone help me change my site to HTTPS please?!

    Moral of the story, you're either going to have to roll up your sleeves and get your hands dirty and try not to break something and learn how to do it. It actually sounds much more complicated than it really is and it used to be really complicated but the whole process has been simplified much more today believe it or not lol or you can hire a freelancer with the skills to do it for you! Can someone help me change my site to HTTPS please?!

    Hope this helps and good luck!

    Mike.
    9 years ago

    Are you sure you want to delete this post?

    DarthHazard

    DarthHazard

    I was really confused at first as well when I wanted to setup SSL for my site as well since I had never done it before but it's actually really easy once you know what you are doing. You can get an SSL certificate from sites like GoDaddy but if you do not want to spend money then you can get a free one from LetsEncrypt (but you will have to renew it every 3 months). All you will have to do is contact your host and they will handle most of it (as long as they support LetsEncrypt).
    9 years ago

    Are you sure you want to delete this post?

    styleisland1980

    styleisland1980

    thank you so much for the advice and help!!!
    9 years ago

    Are you sure you want to delete this post?

    Authord

    Authord

    you need to contact your hosting company, and check if they have site support so you can tell them you need to change to HTTPS. That's if you don't see any provision to acquire the SSL certificate. Then when you contact your hosting company, they will give you the guidelines to do that, some even come with just a single click, once you have paid for it, depending on your hosting company.
    9 years ago

    Are you sure you want to delete this post?

    overcast

    overcast

    I think you can get Let's encrypt SSL. You can have it through the Cpanel of your host. You can ask them to deploy that system on their hosting services. And this may take time but it is definitely doable. You can see that some of the HTTPS would be leading for the new browsers. You can also use other paid SSL options. You may have to get it from the reasonable priced hosting services. You can then attach that to your hosting. That works out just fine.
    9 years ago

    Are you sure you want to delete this post?

    kgord

    kgord

    It sounds like you have had several people answer your discussion here so my guess is that you will have your site switched back to https in no time. It is a good thing there are people available who can help with these concerns.
    9 years ago

    Are you sure you want to delete this post?

    keen2write

    keen2write

    I did it through my hosting provider. Namecheap, did it for me I paid for the SSL and they did it within 5 minutes so yeah ask your web host and depending on who you're with some don't mind doing it for you.
    9 years ago

    Are you sure you want to delete this post?

    potentialwriter

    potentialwriter

    Changing your site to https is quite simple and what you can do yourself simply by going to the settings page of your control panel. You are going to edit your site to https redirects, but you will be warned that this change may affect some other features within your account. Thus, you will be asked if you would love to continue with this option. The decision lies with you. You are in full control.
    8 years ago

    Are you sure you want to delete this post?

    overcast

    overcast

    I think CPanel now has that automated. And it can be done even without we doing anything. So the HTTPS is going by default for the sites. So it seems like a good thing to do. For this I am guessing the web hosts need to upgrade the cpanel on their own. I have hawkhost where it is done automatically.
    8 years ago

    Are you sure you want to delete this post?

    vinaya

    vinaya

    In order to use https on your site, you should get a SSL certificate from your host. You can use free SSL certificate from Letsencrypt. However, if your host does not support letsencrypt, it is very difficult to do it by yourself unless you know coding.
    8 years ago

    Are you sure you want to delete this post?

    overcast

    overcast

    I have to agree with this. I have letsencrypt on the cpanel. But many hosts like hostgator and few others are avoiding that. They want to make money from the paid SSL. And for that reason they don't allow the feature for the HTTPS. So it;d be reasonable to make use of the other options that you have with you. That's going to help a lot.
    8 years ago

    Are you sure you want to delete this post?

    vinaya

    vinaya

    Generally speaking, the web hosts that sell SSL does not support free SSL certificates. For instance, I use namecheap and namecheap does not support free SSL, if you want to use HTTPS, you will have to buy security certificates from namecheap. However, there are many hosts that support free security certificates.
    8 years ago

    Are you sure you want to delete this post?

    overcast

    overcast

    Yes they want to make money selling things. So they don't allow users to use free service. And that way they are staying in a business. I hope that changes soon. Because letsencrypt should be offered by your webhost. And otherwise they are not worth using because google prefers SSL based websites. And lack of SSL reduces your SEO.
    8 years ago

    Are you sure you want to delete this post?

    vinaya

    vinaya

    In my observation, most of the big web hosting companies do not support free SSL because they also sell security certificates. Most of the small web hosts support free SSL. Why should you pay for a thing this is already available for free. Therefore, it is better to change to the host that offer free SSL.
    8 years ago

    Are you sure you want to delete this post?

    overcast

    overcast

    I think big ones do support the free SSL. e.g. companies like digitalocean, rackspace, linode, etc are big companies that support free SSL. But namecheap, godaddy, hostgator companies from EIG brands. They don't support the free SSL. The reason being they want to make money and want to take advantage of the people who don't know about this.
    8 years ago

    Are you sure you want to delete this post?

    potentialwriter

    potentialwriter

    Changing your website from http to https shouldn't be an issue at all. It depends on your choice when you were trying to buy the domain. Usually, options are given as to what kind of protection and privacy you are willing to give your domain or website. Charges go along with these selections depending on your preference. For instance, when I was ordering for my own domain, I paid for SSL certificate, privacy and protection which the https is all about. The https, when attached to your domain, adds privacy and protection to your website.
    8 years ago

    Are you sure you want to delete this post?

    itommy

    itommy

    It is not hard to change to https but first I need to know which hosting control panel are you using?
    Setting up https based on hosting control panel will help us to setup right configuration because on each control panel as directadmin, cpanel, plesk..etc then there are quick way to setup, even you just enable some features on Cpanel as openSSL then you could use https without more configurations for your sites.
    8 years ago

    Are you sure you want to delete this post?

    dotzonet

    dotzonet

    Use cloudflare to set SSL, you can make the websie http to https
    8 years ago

    Are you sure you want to delete this post?

    clerkukr

    clerkukr

    Hostgator provide it to all their customers for free and paid, and switch it if customer ask about.
    7 years ago

    Are you sure you want to delete this post?

    Corzhens

    Corzhens

    Wait a minute there. May I know if getting an SSL certificate will cost you money? If yes then how much would it cost me to convert my site to HTTPS by using that SSL certificate? Another question is about the validity of the HTTPS site with the old Chrome because there are HTTPS sites that we couldn’t access using Chrome that we had to shift to Firefox to be able to access it. Any ideas?
    7 years ago

    Are you sure you want to delete this post?

    Order Now
    Process Time: 0.4782440662384

    Possible Duplicate queries found!
    MatchCountSQLScript
    SELECT * FROM `questions` as q JOIN categories_faq as c ON q.catid=c.CATID WHERE (q.status=1 OR (q.status=2 AND userid='') ) AND q.quesid='24427'1SELECT q.*, c.seo as CatSEO, c.name as CatName, c.parentid FROM `questions` as q JOIN categories_faq as c ON q.catid=c.CATID WHERE (q.status=1 OR (q.status=2 AND userid='') ) AND q.quesid='24427'

    		/opt/clerks-staging/docroot/viewfaq.php 496 () ()

    SELECT * FROM seoclerks.members WHERE USERID='605518'1SELECT * FROM seoclerks.members WHERE USERID='605518'

    		/opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() ()

    SELECT * FROM seoclerks.members WHERE USERID=6055181SELECT googleplus_profile FROM seoclerks.members WHERE USERID=605518

    		/opt/clerks-staging/docroot/include/functions/main.php 16914 GetGooglePlusProfileFromId() ()

    SELECT * FROM ratings_faq as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=24427 LIMIT 51SELECT m.username FROM ratings_faq as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=24427 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='24427' AND a.userid=b.USERID and b.status='1' AND a.status=1 ORDER BY a.combined_votes DESC, a.date_answered asc1SELECT a.answer, a.USERID, a.upvotes, a.downvotes, a.ansid, a.parentid, a.combined_votes, a.date_answered, b.username, b.userlevel, b.profilepicture FROM answers a, seoclerks.members b WHERE a.quesid='24427' AND a.userid=b.USERID and b.status='1' AND a.status=1 ORDER BY a.combined_votes DESC, a.date_answered asc

    		/opt/clerks-staging/docroot/viewfaq.php 1245 () ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=135177 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=135177 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=135154 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=135154 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=135157 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=135157 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=135194 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=135194 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=135217 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=135217 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=135273 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=135273 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=135638 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=135638 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=135781 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=135781 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=140162 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=140162 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=152999 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=152999 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=140776 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=140776 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=160895 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=160895 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=161058 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=161058 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=161107 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=161107 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=161126 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=161126 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=161295 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=161295 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=142731 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=142731 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=151390 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=151390 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=154993 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=154993 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=172864 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=172864 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=175078 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=175078 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    UPDATE questions SET total_views = total_views + 1 WHERE quesid='24427'1UPDATE questions SET total_views = total_views + 1 WHERE quesid='24427'

    		/opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() ()

    SELECT * FROM questions WHERE quesid!='24427' AND status='1' AND (question like '%Can change site HTTPS please?! %' OR question like '%change%' OR question like '%site%' OR question like '%HTTPS%' OR question like '%please?!%') -- ORDER BY RAND() LIMIT 151SELECT quesid, question, seo, userid FROM questions WHERE quesid!='24427' AND status='1' AND (question like '%Can change site HTTPS please?! %' OR question like '%change%' OR question like '%site%' OR question like '%HTTPS%' OR question like '%please?!%') -- ORDER BY RAND() LIMIT 15

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()

    SELECT * FROM seoclerks.members WHERE USERID='632' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='632' limit 1

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()

    SELECT * FROM seoclerks.members WHERE USERID='1129' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='1129' limit 1

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()

    SELECT * FROM seoclerks.members WHERE USERID='231' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='231' limit 1

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()

    SELECT * FROM members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=24427%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID 1SELECT USERID, username FROM members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=24427%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()

    SELECT * FROM categories1SELECT * FROM categories

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache()

    select * from categories_software order by name asc1select * from categories_software order by name asc

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetSoftwareCategories()

    select * from categories_wanttobuy order by name asc1select * from categories_wanttobuy order by name asc

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_wantcategories()

    select * from categories_wanttotrade order by name asc1select * from categories_wanttotrade order by name asc

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_tradecategories()

    SELECT * FROM seoclerks.members WHERE USERID='584702.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='584702.jpg'

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='272.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='272.jpg'

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='599711.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='599711.jpg'

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='605518.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='605518.jpg'

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='614330.png'1SELECT profilepicture FROM seoclerks.members WHERE USERID='614330.png'

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='589438.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='589438.jpg'

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='322073.png'1SELECT profilepicture FROM seoclerks.members WHERE USERID='322073.png'

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='585810.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='585810.jpg'

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='275652.png'1SELECT profilepicture FROM seoclerks.members WHERE USERID='275652.png'

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='600657.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='600657.jpg'

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    select * from categories_faq order by name asc1select * from categories_faq order by name asc

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetFaqCategories()

    Invalid SQL

    count(*)sql1error_msg

    Expensive SQL

    Tuning the following SQL could reduce the server load substantially
    LoadCountSQLMaxMin

    Suspicious SQL

    The following SQL have high average execution times
    Avg TimeCountSQLMaxMin
    0.1389291SELECT A.*, B.seo, B.name as categoryname, C.username, C.userlevel, C.lastlogin, C.ip, C.profilepicture FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID AND (A.tags LIKE '%Liars%' OR A.skills LIKE '%Liars%') ORDER BY A.lastgigedit desc LIMIT 0,400.1389290.138929
    0.1106821SELECT COUNT(A.wantid) AS total FROM wanttobuy as A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID AND (A.tags LIKE '%Liars%' OR A.skills LIKE '%Liars%')0.1106820.110682