Page 8 of 11

Re: how to add youtube BBCode to your phpBB forum

Posted: May 20th, 2011, 12:01 pm
by Blue Frost
Hey it's in my SQL, I'm trying to find a way to clean the stuff out and reset some things.
My SQL database / Access PHP My admin / Show MySQL runtime information .
I have a few things to clean out and Flush.
What I need is a way to do it, I don't know how to set permission and the places I look are vague as usual for a novice.

Re: how to add youtube BBCode to your phpBB forum

Posted: May 25th, 2011, 7:32 pm
by andy1
hi blue!! k, PHP My admin scares me too and i don't do there much cept run some basic queries.

to set the permissions tho you don't need PHP My admin you need the part of your cPanel where you made the database and made your user - that's where you'd be able to set the permissions of the user to whatever you want them to be. let me know if you want me to look around your cpanel if you can't find it easily.

Re: how to add youtube BBCode to your phpBB forum

Posted: May 26th, 2011, 9:41 am
by Blue Frost
Hummm Ill take a look but I'm still kind of lost as you know, it's aggravating that I'm the owner and admin and still have to get the permissions set up.

Re: how to add youtube BBCode to your phpBB forum

Posted: May 26th, 2011, 8:06 pm
by andy1
shouldn't be too hard blue! you could also ask your host to help you find it in cPanel they should be able to tell you exactly the name of the item you should click on that takes you where permissions are set - should be something like "MySQL databases"

Re: how to add youtube BBCode to your phpBB forum

Posted: May 26th, 2011, 10:42 pm
by Blue Frost
I'm still looking, I don't have a clue though :blush: Ill get it sometime though and say why didn't I see that.

Re: how to add youtube BBCode to your phpBB forum

Posted: May 26th, 2011, 11:02 pm
by andy1
aw i know what you mean, happens to me all the time, esp with the forum stuff i saw once or twice since i started this:))..

this is how "MySQL databases" icon looks like in my cPanel (it's the first one in the row).
Screen shot 2011-05-26 at 11.03.21 PM.png

Re: how to add youtube BBCode to your phpBB forum

Posted: May 27th, 2011, 9:53 am
by Blue Frost
Hey I'm jealous, I have no elephants or dolphins :001_unsure:
Mine isn't as nice as yours is :001_unsure: Ill look in a while and see if I can do something, I'm not mentally up to it at the moment :tongue_smilie:

Re: how to add youtube BBCode to your phpBB forum

Posted: May 27th, 2011, 1:36 pm
by andy1
i know what you mean blue:)).. hey if the forum is working then it's no rush.. and as far as elephants and dolphins lol i have to admit i've never noticed them before:)) - just tells you how tense i am when i have to login my cPanel to do things:))

mind you my host is pretty good esp as of late and they've even dropped the price down - now it's $3.71 per month for hosting package i have so it's more than reasonable (i used to pay 6 bucks a month for that same thing when i first started)

Re: how to add youtube BBCode to your phpBB forum

Posted: May 27th, 2011, 6:30 pm
by Blue Frost
LOL the animals are cute but no matter really, it's how it runs right :) if I knew more mine would fly really. My main issues are like I mentioned, the two over installs.
It left a lot of trash and messed up settings in the root directory. I got rid of like 90 files that was redundant and doubles a few week ago, some causing little issues and slowing stuff a bit.
In the SQl I had to get rid of several double columns, and keys also that caused some errors, and now I need to flush some tables to complete the cleaning I believe.
Optimization is the next thing to try, it should help a lot on the lag.

The only thing I need is knowledge to do it all, it's so complicated to someone that don't know.

Re: how to add youtube BBCode to your phpBB forum

Posted: May 28th, 2011, 1:25 am
by andy1
oh blue i'm one of those that don't know - sounds like you can do things in MySQL that i've never attempted cuz i never dared:)). i think it's great that you try things out that's really the only way to learn..

and listen if you ever want a clean slate start this is what to do - http://www.phpbb.com/community/docs/INS ... pdate_full (the part titled "full package") - you'd lose the style changes you made and any modifications but at least your code will be as clean as a whistle.

Re: how to add youtube BBCode to your phpBB forum

Posted: May 30th, 2011, 9:43 am
by Blue Frost
Oh I don't know what I'm doing at all, I just take the chances that maybe I shouldn't. I took out some double columns and files from it is all, and tried to clean a little but only solved a few little errors.
I still have plenty to go, and I need to learn. The bad thing is I forget all I learn to quick anymore.

Re: how to add youtube BBCode to your phpBB forum

Posted: June 3rd, 2011, 12:27 am
by andy1
hi blue!! yeah forget easily cuz you don't use it very often - at least that's my problem:)..

Re: how to add youtube BBCode to your phpBB forum

Posted: June 3rd, 2011, 11:44 pm
by Blue Frost
Yeah that's a big issue for me, and I have so many other things on my mind taking my concentration as you likely do.
It would really help if they would explain it in a more simple way, and with more pictures. :)

Re: how to add youtube BBCode to your phpBB forum

Posted: June 5th, 2011, 1:09 pm
by andy1
agreed!!.. ugh just had a problem recently blue, wonder if you have the same thing happening.

do you have a google webmasters tools account? in case you don't i think it's a good idea to make it, not because it'll do wonders for your SEO (as it won't or not overnight anyway) but because it'll tell you if you have problematic topics - i find that they usually get generated during server's lag time. they get assigned the number in the database but because the connection times-out they don't actually materialize in your forum index. now the way google sees them is as if they have a very old start date, something like 1969 (not sure why is that), and as a result of them not really being in your forum index, google sees them as error pages on your website.

now google seeing an error is not the best if you want to run a reputable site lol but it's not the best also because i'm not sure if those ghost topics are a potential security risk either (probably not - but i just don't like having them around) so i like to delete them every time they show up. this topic says how to do it through my phpadmin http://www.phpbb.com/community/viewtopi ... #p11900195 (it's super easy) so try maybe doing that when you have a minute, as it's just another way of checking the board - so make the webmasters account and then once you upload your sitemap (you can make a free sitemap using various websites out there if you don't want to install the sitemap mod, just google 'free sitemap') check how google sees it.

oh another way (much simpler really) to find those topic is this: go to your moderator control panel and order all the topics by the ascending date - if you see any showing as "started" in 1969, it's probably good to delete them:)

Re: how to add youtube BBCode to your phpBB forum

Posted: June 5th, 2011, 1:12 pm
by andy1
ugh that's a long post, hope it doesn't bore you to death lol hi!:)