UBB.threads PHP Forum Software Community Forums UBB.threads 7 Version 7 Support Emergency! Please help

For some reason, overnight (I didn't change anything), my forum seems "broken." When you visit the homepage you get a message that says:

----

Script: /forums/scripts/cfrm.inc.php
Line#: 180
SQL Error: Can't open file: 'ubbt_ONLINE.MYI' (errno: 145)
SQL Error #: 1016
Query: SELECT ONLINE_BROWSING_FORUM,COUNT(*),ONLINE_USER_TYPE FROM ubbt_ONLINE WHERE ONLINE_LAST_ACTIVITY > 1217499456 GROUP BY ONLINE_BROWSING_FORUM,ONLINE_USER_TYPE

Please use your back button to return to the previous page.

-----

The address is http://www.lymecommunity.com

Can someone please help me fix this? I did not change a thing, so I wonder if it is a server-side issue? HELP!

Thanks

Bryan

online table is a memory based table... but just go to phpmyadmin and 'repair' ubbt_ONLINE

should be really quick, since it's not a huge table.

I just ran "database repair" and it appears nothing happened? Still getting the error screen...??

My control panel on the forum still works but the forum itself is toast? Help?

so you went into phpmyadmin and did


and it was happy?

matter of fact, since you have your admin cpanel, you can do it from database tools, sql command

also, what version of ubbt are you running?

I just did that and it worked! Well, it sort of worked. Now some pages on the forum work and others do not. This is another error message I am getting elsewhere. Should I run another execute command in the control panel like I just did? Whatever you recommended DID work but not completely. Here is the new error:

---
Script: /forums/scripts/showflat.inc.php
Line#: 416
SQL Error: File './lymediseaseforums/ubbt_TOPIC_VIEWS.MYD' not found (Errcode: 13)
SQL Error #: 1105
Query: insert into ubbt_TOPIC_VIEWS (TOPIC_ID) values ( 2631 )

Please use your back button to return to the previous page.
---

ugh...

you need to run repair on ubbt_TOPIC_VIEWS now


same idea, but different table name.. dunno if you really did a successful overall DB repair..

this may be pointing to other problems though.. Tables shouldn't 'go away'

I did that and it could not be completed, maybe I entered the wrong command?

Result:

error File './lymediseaseforums/ubbt_TOPIC_VIEWS.MYD' not found (Errcode: 13)

Command:

REPAIR TABLE ubbt_TOPIC_VIEWS;



In my table information, ubbt_TOPIC_VIEWS is showing as only being 1 byte. Does that mean it got lost? Missing, dead?

ugh.. lookin like you have some serious problems with your mysql DB..

do you have a backup?

In my table information, ubbt_TOPIC_VIEWS is showing as only being 1 byte. Does that mean it got lost? Missing, dead?

Can I give you the user name and password for my forum and you can check it out?

I don't know how these could have been corrupted...there have been no changes recently, although I do allow people to post in HTML, maybe someone posted some kind of hack?

sure.. PM me.. we might even have to login to your host cpanel and look closer..

but i can start at the forum level

and NEVER allow peeps to post in html !!! it's my #1 rule.. i don't even allow my other admins to do that..

only ME!

with the new custom bbcode in 7.3.1 that i added, you should never have to give anyone HTML capability at all..

No, I DO NOT think I have any recent backup unless Yahoo! automatically backs this stuff up.

Any news on this fix SirDude? You gonna have time to look into it today? THANKS.

In my phpmyadmin, this is what the table ubbt_TOPIC_VIEWS looks like...it is apparently "in use." Is it gone? How do I fix it? Can I restore it somehow from the original install software? Here is a screenshot: http://www.lymecommunity.com/see.JPG

HELP

i'll need phpmyadmin access now.. nothing can be done from the forum side..

Sirdude fixed the problem...thanks for the help, saved my forum! :-)

Bryan

you're welcome.. good luck and do backups!!

and disable HTML !!

Sirdude, I must call upon your noble help once again. My forum looks to be now having the same (?) problem again! Can you help me? I have tried everything I know how and can't fix it. Here is the error message:

Script: /forums/libs/ubbthreads.inc.php
Line#: 2074
SQL Error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (46)
SQL Error #: 2002
Query: select t1.USER_DISPLAY_NAME,t1.USER_PASSWORD,t1.USER_SESSION_ID, t1.USER_MEMBERSHIP_LEVEL, t2.USER_TOTAL_PM, t1.USER_ID, t1.USER_IS_BANNED,t1.USER_IS_UNDERAGE, t2.USER_STYLE,t2.USER_HIDE_LEFT_COLUMN,t2.USER_HIDE_RIGHT_COLUMN from ubbt_USERS AS t1, ubbt_USER_PROFILE as t2 where t1.USER_ID = '' and t1.USER_ID = t2.USER_ID

You can also see the error message on the forum homepage itself: http://www.lymecommunity.com

Help!!

Thanks,

Bryan

EDITING NOW: Appears that I resolved the issue by going back through SirDude's previous advice and applying some of it this time around. Thanks again SirDude...looks like your advice saved me again. If this fix didn't work for some reason, I will be back, you can be sure of it! THANK YOU

Well, the error itself was:

Chances are, you just "waited out the storm" from a webhost issue...

OK, I'm having this issue AGAIN. Similar type of message. Can someone help? See:
http://www.lymecommunity.com/forums/ubbthreads.php/ubb/search

Thanks, Bryan

It looks as if your ubbt_ONLINE table might be corrupted. Luckily the data in it isn't important. What you need to do is go into phpmyadmin and repair the table. Let us know how that goes.

What if I can't find PHP my admin? It must be installed somewhere but I DON'T have a directory for it?

I just fixed it by following the same instructions given at the beginning of this thread. This is how pathetic I am: I had to ALSO find my phpadmin access by looking in a PM with SirDude from years ago :-) In that same thread he was chastising me for not upgrading ... that was 2 years ago! Now I should probably REALLY upgrade! What are the advantages of upgrading? If I seem stupid, its because I am :-) At least with forums!

Depending on your hosts configuration usually entering in the url of database server it will usually take you to there. Now don't take this the wrong way but if you don't know where phpmyadmin is then you likely don't know what you are doing and are at risk of further damaging your database. If you send me a PM I can take a quick look tonight for you if you want.

Security and stability are the big reasons. You'd also benefit from having the facebook and twitter buttons. You're also getting free help here, and at least personally like giving help to people who are current on their license (not like we can tell).

Some important changes you could quickly make to improve your search engine ranking: I'd change the title of your forum to "Lyme Disease Community Forum" and get rid of your image header and use H1 and H2 tags for your text. You also have two sets of title tags which isn't good. Google is having a hard time getting a good description for you in their SERP, so you might want to change your meta description.

http://www.google.com/search?client...+disease+forum&ie=UTF-8&oe=UTF-8