When i create a service so it is not publishing. Can any body help?

jabrankhan52 Level 1

October 11, 2019, 7:15 am

Write the reason you're deleting this FAQ

When i create a service so it is not publishing. Can any body help?

Hey i m new here, i did create my service and when i click on submit button so nothing happend. can any body help please

Thanks

Comments

Please login or sign up to leave a comment

Join

sahupurna

I didn't concern with this type of issue on seoclerk before. You must have to raise your issue to customer support on
https://ionicware.zendesk.com/hc/en-us/requests/new

Update here after getting your issue resolved.

6 years ago

Are you sure you want to delete this post?

TommyCarey

Hey there,

Have you tried to re-submit it for approval?
Sometimes your service might get looked over because there are loads of new services being submitted each day. You can either re-submit it for approval or create a new one and delete the draft one. Contacting support about this might be your best route, but it seems that a few people are having this problem, so it might be a bug that is getting worked on as you're reading this.

Do you have any infractions?
A lot of times when someone runs into a problem here it is because their profile has a temporary restriction placed on it. This could happen from trying to take advantage of certain systems, sending too many unsolicited PMs to people, and various other things. I would check to see your profile standing and if there aren't any infractions then you're likely experiencing a bug that will get fixed soon.

Do you have a good internet connection?
Sometimes a service will start to be made and an internet connection might fail. When you finish typing everything in the description box and enter in all of your add-ons, you might not have a connection when you hit submit, and this will keep your service in draft mode. This is because you had a connection when you started writing out the product description but didn't have a connection when submitting it. The system thinks you simply left the service as is and didn't submit it, which is why I tell people to resubmit the service and see what happens.

Troubleshoot before contacting support
The support team here is already inundated with support tickets after switching to the new theme of this websites. You don't want to add more work onto their already busy schedule when you could have fixed this yourself. Figure out why you're stuck in draft mode, try to fix it yourself, and if all else fails you can submit a support ticket and give them an idea of what you're going through. They will be extremely grateful when you tell them all the steps you took to troubleshoot your problem, because it will speed up their entire process, and you will likely get your problem handled much quicker since they can carry on where you left off

When i create a service so it is not publishing. Can any body help?

I hope that helps

- Tommy Hey there, [b]Have you tried to re-submit it for approval?[/b] Sometimes your service might get looked over because there are loads of new services being submitted each day. You can either re-submit it for approval or create a new one and delete the draft one. Contacting support about this might be your best route, but it seems that a few people are having this problem, so it might be a bug that is getting worked on as you're reading this. [b]Do you have any infractions?[/b] A lot of times when someone runs into a problem here it is because their profile has a temporary restriction placed on it. This could happen from trying to take advantage of certain systems, sending too many unsolicited PMs to people, and various other things. I would check to see your profile standing and if there aren't any infractions then you're likely experiencing a bug that will get fixed soon. [b]Do you have a good internet connection?[/b] Sometimes a service will start to be made and an internet connection might fail. When you finish typing everything in the description box and enter in all of your add-ons, you might not have a connection when you hit submit, and this will keep your service in draft mode. This is because you had a connection when you started writing out the product description but didn't have a connection when submitting it. The system thinks you simply left the service as is and didn't submit it, which is why I tell people to resubmit the service and see what happens. [b]Troubleshoot before contacting support[/b] The support team here is already inundated with support tickets after switching to the new theme of this websites. You don't want to add more work onto their already busy schedule when you could have fixed this yourself. Figure out why you're stuck in draft mode, try to fix it yourself, and if all else fails you can submit a support ticket and give them an idea of what you're going through. They will be extremely grateful when you tell them all the steps you took to troubleshoot your problem, because it will speed up their entire process, and you will likely get your problem handled much quicker since they can carry on where you left off :) I hope that helps :) - Tommy

6 years ago

Are you sure you want to delete this post?

Avg Time	Count	SQL	Max	Min
0.248185	1	SELECT count(A.ansid) as total FROM answers as A, questions as Q where A.status='1' AND A.quesid=Q.quesid AND Q.CATID=34	0.248185	0.248185
0.063632	1	SELECT A.*, C.username, C.userlevel FROM questions A, categories_faq B, seoclerks.members C where A.status='1' AND A.catid=B.CATID AND A.userid=C.USERID AND B.seo='Google' ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 0, 40	0.063632	0.063632

SEOClerks

When i create a service so it is not publishing. Can any body help?

When i create a service so it is not publishing. Can any body help?

Comments

Please login or sign up to leave a comment

sahupurna

TommyCarey

Invalid SQL

Expensive SQL

Suspicious SQL

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='29267'	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='29267'	/opt/clerks-staging/docroot/viewfaq.php 496 () ()
SELECT * FROM seoclerks.members WHERE USERID='859046'	1	SELECT * FROM seoclerks.members WHERE USERID='859046'	/opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() ()
SELECT * FROM categories_faq WHERE CATID='43'	1	SELECT CATID, seo, name, metatitle, h2header, metakeywords, metadescription, metaheader, parentid, image_name FROM categories_faq WHERE CATID='43'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetCategorySeoFromType()
SELECT * FROM seoclerks.members WHERE USERID=859046	1	SELECT googleplus_profile FROM seoclerks.members WHERE USERID=859046	/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=29267 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=29267 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='29267' 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='29267' 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=188589 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=188589 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=188592 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=188592 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
UPDATE questions SET total_views = total_views + 1 WHERE quesid='29267'	1	UPDATE questions SET total_views = total_views + 1 WHERE quesid='29267'	/opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() ()
SELECT * FROM questions WHERE quesid!='29267' AND status='1' AND (question like '%When i create service publishing. body help? %' OR question like '%When%' OR question like '%create%' OR question like '%service%' OR question like '%publishing.%' OR question like '%body%' OR question like '%help?%') -- ORDER BY RAND() LIMIT 15	1	SELECT quesid, question, seo, userid FROM questions WHERE quesid!='29267' AND status='1' AND (question like '%When i create service publishing. body help? %' OR question like '%When%' OR question like '%create%' OR question like '%service%' OR question like '%publishing.%' OR question like '%body%' OR question like '%help?%') -- ORDER BY RAND() LIMIT 15	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
SELECT * FROM seoclerks.members WHERE USERID='3644' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='3644' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='1323' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='1323' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='498' limit 1	1	SELECT 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='3302' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='3302' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='7' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='7' 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=29267%' 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=29267%' 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='812751.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='812751.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
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 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()