Tech Question and Answer

alornishan1 Level 1

December 15, 2014, 8:14 am

Write the reason you're deleting this FAQ

Tech Question and Answer

WiFi is not working in my laptop, what is the solution?
Answer: First uninstall the WiFi device software from your laptop, Download a latest version from the laptop manufacturer website and install it.
If this problem still occurs, then, it seems that there is a problem of WiFi device. You may need to contact the customer care.
2. How to remove shortcut virus from PC?
Answer: Shortcut virus is a virus which is annoying more and more. It generally creates a disgusting problem. To get rid from it, you can use latest version of updated antivirus. Also you use latest version of malware bytes.
Can download malware bytes from here:
https://www.malwarebytes.org/
3. How can I recover deleted data?
Ans : If you accidently delete data, then you can still recover that data, though sometimes these data may be corrupted. You can use data recovery software to recover data. There are so many software you can find online to recover data like Recover My Files, Easy Data Recovery, Media Rescue Pro, Photo Rescue pro etc. You can also get help from the search engine to get the information about data recovery.
4. How can I open ZIP or RAR file?
Ans : Generally some files we download from the internet are packed as rar or ZIP. We need to open or extract files from it. To do this we need to install WinRAR or winZIP software in our PC.
Also if you are using windows 7 or later version then, you can download and install 7 ZIP.
You can download WinRAR from here:
http://www.rarlab.com/download.htm
5. How to secure a folder in PC?
Ans : Sometimes it is needed to secure one or more folder in a PC. Because some folder contains important information or personal information. There are so many software through which you can secure your folder in PC. Some of them are folder lock, hide my folder, Password folder, PC security etc. For more this types of software you can search in the search engines.
You can download folder lock from here:
http://download.cnet.com/Folder-Lo..._4-10063343.html

Comments

Please login or sign up to leave a comment

Join

ppscslv

Good to know! Thank you very much for sharing these...

11 years ago

Are you sure you want to delete this post?

chetaseo

thanks for the info. nice share atleast i have gained alot here. no knowledge is a waste.

11 years ago

Are you sure you want to delete this post?

sanfora

good information and very helpful about the wifi i just contact the provider company and they fix it for no problems

11 years ago

Are you sure you want to delete this post?

Corzhens

I had an experience of lost data in USB which I failed to recover. I really don’t know why the directory of the files were lost but the files seem to be there because the capacity of the USB drive did not change. However, I couldn’t access the files. And after a week of trying and asking around, I formatted the USB so I can re-use the occupied space. Maybe if I had read this discussion earlier, I could have recovered those lost files.

8 years ago

Are you sure you want to delete this post?

Avg Time	Count	SQL	Max	Min
0.518724	1	SELECT A.*, C.username, C.profilepicture, C.userlevel, C.ratingcount, C.rating, C.lastlogin, C.ip, C.lip, C.profile_data from posts A, seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND category IN (18) AND gtags like'%Linkbuil%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 40	0.518724	0.518724
0.464397	1	SELECT A.*, C.username, C.profilepicture, C.userlevel, C.ratingcount, C.rating, C.lastlogin, C.ip, C.lip, C.profile_data from posts A, seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND category IN (46) AND gtags like'%Unique%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 40	0.464397	0.464397
0.426841	1	SELECT A.*, C.username, C.profilepicture, C.userlevel, C.ratingcount, C.rating, C.lastlogin, C.ip, C.lip, C.profile_data from posts A, seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND category IN (22) AND gtags like'%highquality%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 40	0.426841	0.426841
0.296486	1	SELECT count(A.PID) as total from posts A , seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND A.USERID=C.USERID AND category IN (16) AND gtags like'%References%' AND type !=99	0.296486	0.296486
0.118401	1	SELECT * FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%Blog-website%') ORDER BY total_recommendations desc LIMIT 0,40	0.118401	0.118401

SEOClerks

Tech Question and Answer

Tech Question and Answer

Comments

Please login or sign up to leave a comment

ppscslv

chetaseo

sanfora

Corzhens

Invalid SQL

Expensive SQL

Suspicious SQL

Match	Count	SQL	Script
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='14219'	1	SELECT 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='14219'	/opt/clerks-staging/docroot/viewfaq.php 496 () ()
SELECT * FROM seoclerks.members WHERE USERID='69871'	1	SELECT * FROM seoclerks.members WHERE USERID='69871'	/opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() ()
SELECT * FROM seoclerks.members WHERE USERID=69871	1	SELECT googleplus_profile FROM seoclerks.members WHERE USERID=69871	/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=14219 LIMIT 5	1	SELECT m.username FROM ratings_faq as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=14219 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='14219' AND a.userid=b.USERID and b.status='1' AND a.status=1 ORDER BY a.combined_votes DESC, a.date_answered asc	1	SELECT 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='14219' 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=73476 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=73476 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=73477 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=73477 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=73478 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=73478 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=153278 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=153278 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
UPDATE questions SET total_views = total_views + 1 WHERE quesid='14219'	1	UPDATE questions SET total_views = total_views + 1 WHERE quesid='14219'	/opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() ()
SELECT * FROM questions WHERE quesid!='14219' AND status='1' AND (question like '%Tech Question Answer%' OR question like '%Tech%' OR question like '%Question%' OR question like '%Answer%') -- ORDER BY RAND() LIMIT 15	1	SELECT quesid, question, seo, userid FROM questions WHERE quesid!='14219' AND status='1' AND (question like '%Tech Question Answer%' OR question like '%Tech%' OR question like '%Question%' OR question like '%Answer%') -- ORDER BY RAND() LIMIT 15	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
SELECT * FROM seoclerks.members WHERE USERID='43' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='43' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='1186' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='1186' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='2875' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='2875' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='1490' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='1490' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='1220' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='1220' 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=14219%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID	1	SELECT USERID, username FROM members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=14219%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
SELECT * FROM categories	1	SELECT * FROM categories	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache()
select * from categories_software order by name asc	1	select * 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 asc	1	select * 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 asc	1	select * 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='6995.png'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='6995.png'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='198791.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='198791.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='60292.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='60292.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='600657.jpg'	1	SELECT 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 asc	1	select * from categories_faq order by name asc	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetFaqCategories()