SEOClerks



Write the reason you're deleting this FAQ

Suggestion Archives

Hello ClerkNation,
I have a suggestion regarding the Suggestion & Feedback forum. My suggestion is to add a locked Sub-Forum and call it "Completed Archives". This is because, when suggestions & feedback that are very outdated and just starting to cluster up the Suggestion & Feedback forum can be moved there, still to be accessed but will help clean up the Suggestion & Feedback forum to help the staff & even members see what threads are still needing to be seen and so that we don't waste our time replying to threads that are months old and no longer serve a purpose.

Thoughts?

Regards,
Jadster

Comments

Please login or sign up to leave a comment

Join
NaturalWriter
I think that suggestion would be worth looking at, or at least figure out different ways to go about it. In many existing forums, they tend to remove threads after they are aged, and collecting dust. They don't delete them as people can still access them through profiles.

There are so many things a person could do here to make it more organized.
There are a few thing which are taking up a lot of unnecessary bandwidth now.
For example here's some:

  • The WTB section and all the "Completed" Or "Ended" listings
  • Alerts you can't delete
  • Messages you can only put in archives


Imagine what it's going to be like another year down the road!



Are you sure you want to delete this post?

Jadster
Thank you NaturalWriter,
I feel that those examples can help but my suggestion was more for this specific forum but your idea works as well. And I do hope a staff can see this soon but I know how busy they can be so I won't bother them with it now.

Regards,
Jadster



Are you sure you want to delete this post?

Sean101
I have a "Resolved Issues" sub-forum in my Feedback & Suggestion forum on my own website. Want to see something similar added here then? This way old threads about fixed / resolved / dealt with issues and suggestions can be kept away from the ones that people are still talking about. Suggestion Archives



Are you sure you want to delete this post?

Jadster
I have a "Resolved Issues" sub-forum in my Feedback & Suggestion forum on my own website. Want to see something similar added here then? This way old threads about fixed / resolved / dealt with issues and suggestions can be kept away from the ones that people are still talking about. Suggestion Archives

That is exactly what I mean Suggestion Archives
That way it would just keep this more organized and make it easier for the staff to handle the topics that still need attention.



Are you sure you want to delete this post?

NaturalWriter
I have a "Resolved Issues" sub-forum in my Feedback & Suggestion forum on my own website. Want to see something similar added here then? This way old threads about fixed / resolved / dealt with issues and suggestions can be kept away from the ones that people are still talking about. Suggestion Archives


That is an awesome idea! That will help the clutter in the forum a bit Suggestion Archives



Are you sure you want to delete this post?

Sean101
I have now added this suggestion..
From now on, after your suggestion, issue, etc.. is dealt with, the thread you created in the Suggestions & Feedback will be locked and then moved to the new Resolved / Archived Issues sub-forum.

Ill now have a look through each of the threads closing the ones that are dealt with and old and it will soon be clean and tidy with only the current feedback & suggestion in it. Suggestion Archives

Thanks for the suggestion, I will leave this thread open for now to see if anyone has anything to say or ask, etc.. about this new addition, but then ill go ahead and lock this too and move it with the rest. Suggestion Archives



Are you sure you want to delete this post?

NaturalWriter
I have now added this suggestion..
From now on, after your suggestion, issue, etc.. is dealt with, the thread you created in the Suggestions & Feedback will be locked and then moved to the new Resolved / Archived Issues sub-forum.

Ill now have a look through each of the threads closing the ones that are dealt with and old and it will soon be clean and tidy with only the current feedback & suggestion in it. Suggestion Archives

Thanks for the suggestion, I will leave this thread open for now to see if anyone has anything to say or ask, etc.. about this new addition, but then ill go ahead and lock this too and move it with the rest. Suggestion Archives


Have you given any thought to the "Bumping Business Better" thread, or the "Cleaning Up The WTB Section"?



Are you sure you want to delete this post?

Sean101
Ill have a read at them just now. Suggestion Archives



Are you sure you want to delete this post?

Sean101
I have locked and archived most of the old threads in this forum. There is still 4 pages left, please feel free to report any of the threads in this forum you think should be locked. Suggestion Archives Thanks. Suggestion Archives



Are you sure you want to delete this post?

Sean101
I think all or almost all of the current threads are now active, ones that die off though will be archived when the time comes. Suggestion Archives I will go ahead and lock and archive this thread too, if anyone has any other feedback, questions, suggestions, etc.. feel free to create a new thread in the Suggestions & Feedback Forum. Suggestion Archives Thanks!



Are you sure you want to delete this post?

Order Now
Process Time: 2.4140019416809

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='12573'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='12573'

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

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

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

SELECT * FROM categories_faq WHERE CATID='39'1SELECT CATID, seo, name, metatitle, h2header, metakeywords, metadescription, metaheader, parentid, image_name FROM categories_faq WHERE CATID='39'

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

SELECT * FROM seoclerks.members WHERE USERID=869461SELECT googleplus_profile FROM seoclerks.members WHERE USERID=86946

/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=12573 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=12573 LIMIT 5

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

SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='12573' 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='12573' 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=59823 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=59823 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=59824 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=59824 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=59825 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=59825 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=59826 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=59826 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=59827 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=59827 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=59828 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=59828 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=59829 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=59829 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=59830 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=59830 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=59831 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=59831 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=59832 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=59832 LIMIT 5

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

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

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

SELECT * FROM questions WHERE quesid!='12573' AND status='1' AND (question like '%Suggestion Archives%' OR question like '%Suggestion%' OR question like '%Archives%') -- ORDER BY RAND() LIMIT 151SELECT quesid, question, seo, userid FROM questions WHERE quesid!='12573' AND status='1' AND (question like '%Suggestion Archives%' OR question like '%Suggestion%' OR question like '%Archives%') -- ORDER BY RAND() LIMIT 15

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

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

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

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

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

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

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

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

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

SELECT * FROM seoclerks.members WHERE USERID='20911' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='20911' 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=12573%' 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=12573%' 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='168430.png'1SELECT profilepicture FROM seoclerks.members WHERE USERID='168430.png'

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

SELECT * FROM seoclerks.members WHERE USERID='1856.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='1856.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.0923101SELECT * FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%Deindexing%') ORDER BY total_recommendations desc LIMIT 0,400.0923100.092310
0.0672231SELECT count(USERID) AS total FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%Deindexing%') 0.0672230.067223