SEOClerks

What do you do when you get stuck with something?



Write the reason you're deleting this FAQ

What do you do when you get stuck with something?

Learning how to work online has been a long and often bumpy road for me. I absolutely love learning how to do new things and implement them.... but only when it goes ok!

I am sort of joking here, but mostly not.
Learning most things is easy for me so I love it. I love learning something new, having a light bulb moment, going to my website and implementing it and sitting back to watch the results. There is just nothing better than this.

The other side of this coin is that I do almost everything for myself. Yes I outsource a few things but the majority I do myself.

There are certain things I don't catch on easily and I try and implement these things and it just doesn't happen for me.

I keep asking for advice and I keep trying and it just does not work. With these things I literally frustrate myself to tears.

One example of this is hosting a video on my own site. Yes I have watched all the videos about Filezilla and my ftp thing but I just don't get it and I have tried so many times.

Fortunately hosting a video on my own website was something I was thinking of doing and I had very specific reasons for maybe wanting to do it, but decided not to. Mostly because I couldn't do it LOL.

But this post is not about hosting a video on Wordpress. It is about what do YOU do when you get so stuck?

Comments

Please login or sign up to leave a comment

Join
idealmike
I Google it! What do you do when you get stuck with something? But if that doesn't help. I come on here and ask about it. Or if it's a really niche thing, I'll join a forum that it's related to and ask about it on there. But most things I do or need to know are SEO related so I can usually ask on here and find out about it. That's another good thing about the SEOClerks Community Discussions in that you never really need to go far to get the answers you need. Chances are if it's something you're stuck on, other people have been stuck on it at some point as well so you can usually find someone on here who has been and find a solution for it. Or most people are really friendly and want to help on here so will help you find a solution for it.

As for hosting a video on your own site. Yeah, if you have the MP4 file of it, you can just upload it to your site from the Media Importer. But doing that for a really large file will slow your page load speed right down to a crawl rate. Especially for people on a slow connection. Quite simply the best thing to do for large video files is to host them on YouTube and just use the embed code in your post/page instead. That way it only downloads as it plays instead of having to download the whole video into their browser first before it will play.

For small videos it's okay. Those that are around 5-20MB but anything more than this should just be embedded for the above reasons. What do you do when you get stuck with something?



Are you sure you want to delete this post?

Lynne
Thanks Mike, the one video is 70MB and the other one 20MB...

Anyway in case you are wondering why, these are the "SF videos where I got a Cease and Desist letter.

I am waiting for SF to go bang and then maybe I can upload them again to Youtube, what do you think? I mean if SF gets sued by members for being a scam and my original videos show them being a scam surely then they can't do anything to me?



Are you sure you want to delete this post?

Cristian
That's the problem on working alone on your own website. You need to learn everything and you need to implement everything you learn by yourself. I know for experience it can evolve into something very frustrating.

Try to disconnect every once in a while, maybe try and think outside the box or see the problem from a different angle. Keep in mind you can't do it all by yourself, not as you wish things should be done...so hire someone to fix and add everything you can't.

Find a good coder you can trust. Or better yet, if you have any, ask a friend to help you out! At least that's what I'm doing when I get into a problem that I want to pull my hair out.



Are you sure you want to delete this post?

Lynne
Oh well I am fortunate in that my sister is a web developer. She is more on the designer side but she has loads of people she works with in the industry and a friend of ours is a brilliant coder so he has helped me every now and then. So it is not like I am always completely alone.



Are you sure you want to delete this post?

Cristian
Cool, that's very cool! You're pretty lucky to have your sister! I pretty much had no one in this domain until I made some friends from previous and current work places.



Are you sure you want to delete this post?

anwebservices
Working online is very bumpy road for all of us, specially at beginning, but even after, because we are working in ever updating industry and have to be up to date with so many things, so we learn all the time.

Whenever i couldn't do something, i actually never give up. But i was searching day and night to solve my problem. Asking on different question / answer websites, forum etc. This community discussions is also good place to ask how to solve some problem in many niches. So i suggest you ask specific question, like "how to do this and that".

For hosting your own video on your WordPress website you didn't need to use FileZilla and upload it to your host that way! You can simply go to your WordPress administration panel > media > add new media, then upload your video. Same process as if you want to add new photo to your blog. However, i am not so sure it's best option to do, because it can slow down your post / page where you displaying your hosted video. Ofc depending on your hosting capabilities. Hosting it on YouTube or some other video hosting website is good idea to save your bandwidth and speed up your website browsing. I know there is sometime need to keep it private or hosted on own hosting, but it's just my two cents. So just try use WP admin option i mentioned ;)



Are you sure you want to delete this post?

Lynne
OMG can it really be so simple to host a video on my blog, Anwebservies? LOL and you know what sometimes that is exactly how things come about for me.
I usually keep asking and keep trying until I come right. Sometimes when I am struggling with something for a while and I can't get it then I leave it for a while and very often the answer just lands in my lap. Like it did right now with your answer. I asked so many people and I did online searches... all of this pointed to the FileZilla option.

I will try your way, I may still have need of it. Not right now, I am waiting for something specific to happen before I can do that. Cryptic, yes I know! These videos I cant upload to Youtube. They have already been published there and I had to remove them... As soon as something happens I will be able to upload them again to Youtube or to my own website.



Are you sure you want to delete this post?

anwebservices
OK if you need more assistance later on, don't hesitate to ask. I am working with WordPress for long time, so i can help with things when you need them. Just try to upload one short video as i mentioned for test drive ;)



Are you sure you want to delete this post?

Lynne
Thank you! I am sure that will go just fine when I get there. I would really like to upload them to Youtube again but I might get into trouble LOL.

I really appreciate your helpfulness What do you do when you get stuck with something?



Are you sure you want to delete this post?

anwebservices
Sorry i forgot to mention that you will probably need plugin to display / embed your self hosted video in post, so you can find one here https://wordpress.org/plugins/search.php?q=video



Are you sure you want to delete this post?

Lynne
Thank you so much! I will look into that and give it a go soon What do you do when you get stuck with something?



Are you sure you want to delete this post?

Corzhens
Not only in freelancing but also in other tasks, it is best to leave for a while what you are doing when you hit the wall. Take time to give your mind some rest by taking a short walk or to chat with people around. And when you cone back, you will have a clear mind and also have a recourse on how to go about it.



Are you sure you want to delete this post?

augusta
Getting stuck in somethings is imminent for the mere fact we are busy trying to do one thing or the other.Can remember when I was trying to put my blogs together got stuck several times.Sometimes I will rest but some I will ask people or Google.So when I get stuck the above can be done.



Are you sure you want to delete this post?

Barida
I always try to take some time off and relax with friends and family members when I get stuck on something. I know that it was all about lacking creativity, so I try to get it by freeing up thing in my mind.



Are you sure you want to delete this post?

Order Now
Process Time: 0.80171298980713

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

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

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

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

SELECT * FROM seoclerks.members WHERE USERID=3066321SELECT googleplus_profile FROM seoclerks.members WHERE USERID=306632

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

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

SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='18925' 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='18925' 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=104536 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=104536 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=104539 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=104539 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=104784 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=104784 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=104786 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=104786 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=104790 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=104790 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=104492 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=104492 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=104495 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=104495 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=104510 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=104510 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=104512 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=104512 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=104513 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=104513 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=104515 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=104515 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=135740 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=135740 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=135760 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=135760 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=136616 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=136616 LIMIT 5

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

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

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

SELECT * FROM questions WHERE quesid!='18925' AND status='1' AND (question like '% you stuck something?%' OR question like '%stuck%' OR question like '%something?%') -- ORDER BY RAND() LIMIT 151SELECT quesid, question, seo, userid FROM questions WHERE quesid!='18925' AND status='1' AND (question like '% you stuck something?%' OR question like '%stuck%' OR question like '%something?%') -- ORDER BY RAND() LIMIT 15

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

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

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

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

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

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

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

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

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

SELECT * FROM seoclerks.members WHERE USERID='114307' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='114307' 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=18925%' 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=18925%' 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='272.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='272.jpg'

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

SELECT * FROM seoclerks.members WHERE USERID='306632.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='306632.jpg'

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

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

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

SELECT * FROM seoclerks.members WHERE USERID='254580.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='254580.jpg'

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

SELECT * FROM seoclerks.members WHERE USERID='600657.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='600657.jpg'

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

SELECT * FROM seoclerks.members WHERE USERID='617077.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='617077.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
4.1316451SELECT 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 (42,64,90) AND gtags like'%Shops%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 404.1316454.131645