SEOClerks

Noticed a problem with SEOclerks pages when going to the next one



Write the reason you're deleting this FAQ

Noticed a problem with SEOclerks pages when going to the next one

Alright so I am just starting this thread to help SEOclerks out a little bit. Don't want to message them directly as it is not really a support issue. Anyway, I was looking to buy some FB likes and came across a small issue.

When I look for something on any site I have the habit of using the search bar. So I typed in "facebook likes" and sorted by price. I began scrolling and when I arrived at the bottom, clicked the button to go to the next. When the next page loaded, a service for $99 was at the top, and considering I sorted by price that just wasn't workin' for me. So i tried multiple times and also sorted in multiple way and arrived at the same issue every time. The page would reset to being sorted by relevance.

This doesn't seem to happen with anything else other than "facebook likes". I tested other keywords that might be typed into the search bar but everything else acted as expected.

As a buyer this is frustrating to me because I wanted to scroll through the services by price and couldn't do so once I got passed the first page.

As a seller this also is bothersome, 1). Because if I got discouraged as a buyer (didn't purchase any FB likes) from trying multiple times to search in a way that I wanted to and was unsuccessful, then other buyers are probably becoming frustrated also and 2). say that I am selling FB likes and I have a service for $2. I couldn't even get to the page with all of the $2 sellers. I don't sell FB likes but it would bother me if I did.

Well I hope this helps out a little. Felt like I needed to let you guys know and I see many staff members in the forums and figured this was the best way.

Cheers

Comments

Please login or sign up to leave a comment

Join
akshat112
Hey!
Can you please tell that the $99 service you saw at top was featured one?
If yes, it will be showing on top.



Are you sure you want to delete this post?

ericplotz1
Hey!
Can you please tell that the $99 service you saw at top was featured one?
If yes, it will be showing on top.

No it wasn't featured and the whole page was mixed up with various prices. Page 2 wouldn't have the featured services at the top anyway. Also if you hit the sort buttons it doesn't show a featured service at the top anymore either. If it did I would have noticed Noticed a problem with SEOclerks pages when going to the next one

Cheers



Are you sure you want to delete this post?

sunil0021
Yup it's normal if you want low prices then seoclerks system show you price list from low to high so when you move towards other pages rates may increase. You should contact staff because there is a section "Report a bug" if you think it's a bug Noticed a problem with SEOclerks pages when going to the next one

- Sunil Bishnoi



Are you sure you want to delete this post?

ericplotz1
Yup it's normal if you want low prices then seoclerks system show you price list from low to high so when you move towards other pages rates may increase. You should contact staff because there is a section "Report a bug" if you think it's a bug Noticed a problem with SEOclerks pages when going to the next one

- Sunil Bishnoi

Sunil I understand that. I do not think you understood me. When I sorted by price for "facebook likes" (only facebook likes is where the problem occurs, I've checked) i finished scrolling through the first page which was all $1 services. Now normally when you go to the next page after sorting by prices it would've continued on with the $1 and $2 and on to the $3 and so on, but instead it went back to being sorted by relevance and all the prices were mixed up again so I could not get to the next prices up from $1. It was just mixed prices on the second page. But I will report this in the report a bug. Thanks!



Are you sure you want to delete this post?

akshat112
Ok,
I have forwarded this issue to the technical team.
Thanks for reporting!



Are you sure you want to delete this post?

ericplotz1
You are welcome askhat!!! Noticed a problem with SEOclerks pages when going to the next one



Are you sure you want to delete this post?

ionicware
Hi ericplotz1 - thanks for reporting. There was certainly an issue there and it has now been fixed.
Let me know if you find anything else.



Are you sure you want to delete this post?

ericplotz1
Hi ericplotz1 - thanks for reporting. There was certainly an issue there and it has now been fixed.
Let me know if you find anything else.


I most definitely will Jordan. I really like this community and if there is anyway I can help to improve it, I will. Thanks to you Jordan for building Seoclerks!

Cheers



Are you sure you want to delete this post?

Sean101
Are you still needing help for this or will I go ahead and archive this thread?



Are you sure you want to delete this post?

ericplotz1
They fixed the issue. Thanks Sean!



Are you sure you want to delete this post?

Sean101
They fixed the issue. Thanks Sean!

Cool, thanks for the reply letting me know. Noticed a problem with SEOclerks pages when going to the next one
I will now lock and archive this thread. Noticed a problem with SEOclerks pages when going to the next one



Are you sure you want to delete this post?

Order Now
Process Time: 1.2486770153046

Possible Duplicate queries found!
MatchCountSQLScript
SELECT * FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-864001SELECT querystring, added FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-86400

/opt/clerks-staging/docroot/include/functions/includes/security.php 398 fetchMemberLedger() include_once()

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

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

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

/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=1218141SELECT googleplus_profile FROM seoclerks.members WHERE USERID=121814

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

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

SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='12586' 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='12586' 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=59906 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=59906 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=59907 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=59907 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=59908 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=59908 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=59909 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=59909 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=59910 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=59910 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=59911 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=59911 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=59912 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=59912 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=59913 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=59913 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=59914 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=59914 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=59915 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=59915 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=59916 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=59916 LIMIT 5

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

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

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

SELECT * FROM questions WHERE quesid!='12586' AND status='1' AND (question like '%Noticed problem SEOclerks pages one%' OR question like '%Noticed%' OR question like '%problem%' OR question like '%SEOclerks%' OR question like '%pages%') -- ORDER BY RAND() LIMIT 151SELECT quesid, question, seo, userid FROM questions WHERE quesid!='12586' AND status='1' AND (question like '%Noticed problem SEOclerks pages one%' OR question like '%Noticed%' OR question like '%problem%' OR question like '%SEOclerks%' OR question like '%pages%') -- ORDER BY RAND() LIMIT 15

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

SELECT * FROM seoclerks.members WHERE USERID='498' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='498' 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 11SELECT 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='184' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='184' limit 1

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

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='2921' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='2921' 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=12586%' 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=12586%' 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='82856.png'1SELECT profilepicture FROM seoclerks.members WHERE USERID='82856.png'

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

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

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

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

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

SELECT * FROM seoclerks.members WHERE USERID='1.png'1SELECT profilepicture FROM seoclerks.members WHERE USERID='1.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