vgpro248
Level 1
Write the reason you're deleting this FAQ
Hello
Please help me
I made an order, however
My order did not increase anyviews!
So, what I can do now?
Are you sure you want to delete this post?
Are you sure you want to delete this post?
| Match | Count | SQL | Script |
| SELECT * FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-86400 | 1 | SELECT 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='29484' | 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='29484' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='855514' | 1 | SELECT * FROM seoclerks.members WHERE USERID='855514' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM seoclerks.members WHERE USERID=855514 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=855514 | /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=29484 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=29484
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='29484' 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='29484' 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=188978 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=188978
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=188949 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=188949
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=188987 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=188987
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='29484' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='29484' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='29484' AND status='1' AND (question like '%My order increase anyviews!%' OR question like '%order%' OR question like '%increase%' OR question like '%anyviews!%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='29484' AND status='1'
AND (question like '%My order increase anyviews!%' OR question like '%order%' OR question like '%increase%' OR question like '%anyviews!%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM seoclerks.members WHERE USERID='1129' limit 1 | 1 | SELECT 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='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 seoclerks.members WHERE USERID='2255' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='2255' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='9' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='9' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='1303' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='1303' 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=29484%' 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=29484%'
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='19821.png' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='19821.png' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='840116.png' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='840116.png' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='804697.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='804697.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() |
| count(*) | sql1 | error_msg |
|---|
| Load | Count | SQL | Max | Min |
| Avg Time | Count | SQL | Max | Min |
TommyCarey
I'm a little confused about your discussion.
You purchased something and your views haven't increased?
I assume this would mean you've purchased a traffic package of some sort.
- or -
You created a service and you haven't gotten any views?
Meaning you haven't gotten any views, or sales, through a service you created here, but it doesn't seem like you have any services listed so I will assume it's my first point.
Purchased a traffic service and haven't gotten any views
What you should do is remind the freelancer you've purchased from that your order is in progress and you're wondering when the traffic will start to come in. Sometimes a freelancer will get a bunch of orders, check all of them, and miss a few when they start to do the work. This is normal human error and should be forgiven unless the seller is blatantly ignoring you and is trying to take your money and run. The good thing about this, if they're just trying to take your money, is that you need to approve the finalized service before they get access to the funds. Never accept an order as completed if you aren't happy with it.
Be polite - Never start a conversation with "Why haven't you started my order!" or something similar to that, because it will never end well and the service provider may do a bad job since they feel you're not their best client. Yes, this happens and it shouldn't, but that is why you should be polite from the start and never assume anything
Ask questions - You need to ask them simple questions like "When do you think you will be able to start my order?" or "How long do you think it will be until the order is finished?" because this will show you're an active member, on top of your orders, and the seller will likely get your work done on time if they know they'll get paid immediately after it's finished.
Give time extensions - If a seller asks for a time extension, let them have it, because you never know what they're dealing with in their personal life. They could be dealing with a loss in their family, they could be sick, or they could have had a vacation planned the day you ordered from them. I always give time extensions if the seller needs it because I know the work will get finished eventually. If you're ordering an SEO service and need it done immediately, you probably don't realize that SEO takes months to take effect, and that means your order that will be 2 days late is not going to matter month in the overall plans for your website.
If you truly believe the service provider you've purchased from is not doing the work, or they're giving you the run around, you can then ask for a mutual cancellation and get the money put back into your account here. You can ask for a mutual cancellation, but the service provider can deny it, and that's when you would want to open up a support ticket to get everything resolved. When I try to do a mutual cancellation I will always try 2-3 times if the service provider keeps rejecting it. If they reject it the first time without an explanation, I will ask for a mutual cancellation a second time, and if they deny it without responding I will go to cancel a third time and open a support ticket so the staff and administrators can take over and see that I haven't gotten my order and the seller is prolonging the process too much.
There are a lot of things you can do but I urge you to stay positive and try working with the seller. If the seller really didn't provide a service that they claimed they would perform, you can mutually cancel it or bring in the big guns and have the staff and admins work it out for you
Thanks,
Tommy
https://www.seoclerks.com/user/TommyCarey Hi there, I'm a little confused about your discussion. [u]You purchased something and your views haven't increased?[/u] I assume this would mean you've purchased a traffic package of some sort. [b]- or -[/b] [u] You created a service and you haven't gotten any views?[/u] Meaning you haven't gotten any views, or sales, through a service you created here, but it doesn't seem like you have any services listed so I will assume it's my first point. [size=100][b]Purchased a traffic service and haven't gotten any views[/b][/size] What you should do is remind the freelancer you've purchased from that your order is in progress and you're wondering when the traffic will start to come in. Sometimes a freelancer will get a bunch of orders, check all of them, and miss a few when they start to do the work. This is normal human error and should be forgiven unless the seller is blatantly ignoring you and is trying to take your money and run. The good thing about this, if they're just trying to take your money, is that you need to approve the finalized service before they get access to the funds. Never accept an order as completed if you aren't happy with it. [u]Be polite -[/u] Never start a conversation with "Why haven't you started my order!" or something similar to that, because it will never end well and the service provider may do a bad job since they feel you're not their best client. Yes, this happens and it shouldn't, but that is why you should be polite from the start and never assume anything :) [u]Ask questions -[/u] You need to ask them simple questions like "When do you think you will be able to start my order?" or "How long do you think it will be until the order is finished?" because this will show you're an active member, on top of your orders, and the seller will likely get your work done on time if they know they'll get paid immediately after it's finished. [u]Give time extensions -[/u] If a seller asks for a time extension, let them have it, because you never know what they're dealing with in their personal life. They could be dealing with a loss in their family, they could be sick, or they could have had a vacation planned the day you ordered from them. I always give time extensions if the seller needs it because I know the work will get finished eventually. If you're ordering an SEO service and need it done immediately, you probably don't realize that SEO takes months to take effect, and that means your order that will be 2 days late is not going to matter month in the overall plans for your website. If you truly believe the service provider you've purchased from is not doing the work, or they're giving you the run around, you can then ask for a mutual cancellation and get the money put back into your account here. You can ask for a mutual cancellation, but the service provider can deny it, and that's when you would want to open up a support ticket to get everything resolved. When I try to do a mutual cancellation I will always try 2-3 times if the service provider keeps rejecting it. If they reject it the first time without an explanation, I will ask for a mutual cancellation a second time, and if they deny it without responding I will go to cancel a third time and open a support ticket so the staff and administrators can take over and see that I haven't gotten my order and the seller is prolonging the process too much. There are a lot of things you can do but I urge you to stay positive and try working with the seller. If the seller really didn't provide a service that they claimed they would perform, you can mutually cancel it or bring in the big guns and have the staff and admins work it out for you :) Thanks, Tommy https://www.seoclerks.com/user/TommyCarey
Are you sure you want to delete this post?