|
Joined: Nov 2006
Posts: 46
newbie
|
newbie
Joined: Nov 2006
Posts: 46 |
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.comCan 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
|
|
|
|
Joined: Apr 2007
Posts: 3,940 Likes: 1
Former Developer
|
Former Developer
Joined: Apr 2007
Posts: 3,940 Likes: 1 |
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.
|
|
|
|
Joined: Nov 2006
Posts: 46
newbie
|
newbie
Joined: Nov 2006
Posts: 46 |
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?
Last edited by theskyking; 07/31/2008 2:41 PM.
|
|
|
|
Joined: Apr 2007
Posts: 3,940 Likes: 1
Former Developer
|
Former Developer
Joined: Apr 2007
Posts: 3,940 Likes: 1 |
so you went into phpmyadmin and did REPAIR TABLE ubbt_ONLINE; 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?
|
|
|
|
Joined: Nov 2006
Posts: 46
newbie
|
newbie
Joined: Nov 2006
Posts: 46 |
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. ---
|
|
|
|
Joined: Apr 2007
Posts: 3,940 Likes: 1
Former Developer
|
Former Developer
Joined: Apr 2007
Posts: 3,940 Likes: 1 |
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'
|
|
|
|
Joined: Nov 2006
Posts: 46
newbie
|
newbie
Joined: Nov 2006
Posts: 46 |
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?
Last edited by theskyking; 07/31/2008 4:12 PM.
|
|
|
|
Joined: Apr 2007
Posts: 3,940 Likes: 1
Former Developer
|
Former Developer
Joined: Apr 2007
Posts: 3,940 Likes: 1 |
ugh.. lookin like you have some serious problems with your mysql DB..
do you have a backup?
|
|
|
|
Joined: Nov 2006
Posts: 46
newbie
|
newbie
Joined: Nov 2006
Posts: 46 |
In my table information, ubbt_TOPIC_VIEWS is showing as only being 1 byte. Does that mean it got lost? Missing, dead?
|
|
|
|
Joined: Nov 2006
Posts: 46
newbie
|
newbie
Joined: Nov 2006
Posts: 46 |
Can I give you the user name and password for my forum and you can check it out?
|
|
|
|
Joined: Nov 2006
Posts: 46
newbie
|
newbie
Joined: Nov 2006
Posts: 46 |
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?
|
|
|
|
Joined: Apr 2007
Posts: 3,940 Likes: 1
Former Developer
|
Former Developer
Joined: Apr 2007
Posts: 3,940 Likes: 1 |
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..
|
|
|
|
Joined: Nov 2006
Posts: 46
newbie
|
newbie
Joined: Nov 2006
Posts: 46 |
No, I DO NOT think I have any recent backup unless Yahoo! automatically backs this stuff up.
|
|
|
|
Joined: Nov 2006
Posts: 46
newbie
|
newbie
Joined: Nov 2006
Posts: 46 |
Any news on this fix SirDude? You gonna have time to look into it today? THANKS.
|
|
|
|
Joined: Nov 2006
Posts: 46
newbie
|
newbie
Joined: Nov 2006
Posts: 46 |
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.JPGHELP
|
|
|
|
Joined: Apr 2007
Posts: 3,940 Likes: 1
Former Developer
|
Former Developer
Joined: Apr 2007
Posts: 3,940 Likes: 1 |
i'll need phpmyadmin access now.. nothing can be done from the forum side..
|
|
|
|
Joined: Nov 2006
Posts: 46
newbie
|
newbie
Joined: Nov 2006
Posts: 46 |
Sirdude fixed the problem...thanks for the help, saved my forum! :-)
Bryan
|
|
|
|
Joined: Apr 2007
Posts: 3,940 Likes: 1
Former Developer
|
Former Developer
Joined: Apr 2007
Posts: 3,940 Likes: 1 |
you're welcome.. good luck and do backups!! and disable HTML !!
|
|
|
|
Joined: Nov 2006
Posts: 46
newbie
|
newbie
Joined: Nov 2006
Posts: 46 |
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.comHelp!! 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
Last edited by theskyking; 11/22/2008 12:05 PM. Reason: APPEARS RESOLVED
|
|
|
|
Joined: Jun 2006
Posts: 16,301 Likes: 116
|
Joined: Jun 2006
Posts: 16,301 Likes: 116 |
Well, the error itself was: SQL Error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (46) Chances are, you just "waited out the storm" from a webhost issue...
|
|
|
|
Joined: Jun 2004
Posts: 207
enthusiast
|
enthusiast
Joined: Jun 2004
Posts: 207 |
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.
Won't you take me to Funkytown?
|
|
|
|
Joined: Nov 2006
Posts: 46
newbie
|
newbie
Joined: Nov 2006
Posts: 46 |
What if I can't find PHP my admin? It must be installed somewhere but I DON'T have a directory for it?
|
|
|
|
Joined: Nov 2006
Posts: 46
newbie
|
newbie
Joined: Nov 2006
Posts: 46 |
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!
|
|
|
|
Joined: Jun 2004
Posts: 207
enthusiast
|
enthusiast
Joined: Jun 2004
Posts: 207 |
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.
Won't you take me to Funkytown?
|
|
|
|
Joined: Jun 2004
Posts: 207
enthusiast
|
enthusiast
Joined: Jun 2004
Posts: 207 |
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
Won't you take me to Funkytown?
|
|
|
0 members (),
719
guests, and
142
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|