Previous Thread
Next Thread
Print Thread
Hop To
Joined: Jan 2004
Posts: 13
N
NitroX Offline OP
Stranger
OP Offline
Stranger
N
Joined: Jan 2004
Posts: 13
Hi, I'm still using UBBThreads 6.5.5. I know i should be upgraded. Planned for th next couple of months to finally bring it to the latest version after changing ISP.

It seem one of the mysql database files has been damaged or corrupted. I have a back up from two weeks ago. Below is the error message being received:

We cannot proceed.
Script: /var/www/nitroexpresscom/public_html/ubbthreads/ubbt.inc.php
Line#: 552
SQL Error: Table './nitroexpress_com/w3t_Online' is marked as crashed and should be repaired
SQL Error #: 145
Query: REPLACE INTO w3t_Online (O_Username,O_Uid,O_Last,O_What,O_Board,O_Extra,O_Read,O_Type) VALUES ('NitroX','3','1494921504','dosearch','','','','r')

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

Can just the backed up database file for w3t_Online be replaced in the current mysql database to fix this problem?

Or does the whole mysql database backup from two weeks ago, has to be used to replace the current database? Loosing two weeks of posts?

Thanks.

I am not experienced in using mysql directly. In the past I have only used the tools in the 6.5.5 admin menu.

The ISP support staff may do it for me. Otherwise may need some help in how to do this.

Thank you for any assistance.

Joined: Jan 2004
Posts: 13
N
NitroX Offline OP
Stranger
OP Offline
Stranger
N
Joined: Jan 2004
Posts: 13
If needed willing to hire someone to assist.

Joined: Jun 2006
Posts: 16,060
Likes: 69
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 16,060
Likes: 69
Originally Posted by NitroX
We cannot proceed.
Script: /var/www/nitroexpresscom/public_html/ubbthreads/ubbt.inc.php
Line#: 552
SQL Error: Table './nitroexpress_com/w3t_Online' is marked as crashed and should be repaired
SQL Error #: 145
Query: REPLACE INTO w3t_Online (O_Username,O_Uid,O_Last,O_What,O_Board,O_Extra,O_Read,O_Type) VALUES ('NitroX','3','1494921504','dosearch','','','','r')
So, load up PHPMyAdmin on the server and select any tables marked as crashed and choose "repair" from the action dropdown (PHPMyAdmin is generally supplied from your webhost, it is not a part of UBB.threads).

If you're looking for services (support, upgrades, migrations, etc) please see the link in my signature.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Jan 2004
Posts: 13
N
NitroX Offline OP
Stranger
OP Offline
Stranger
N
Joined: Jan 2004
Posts: 13
Thanks. Will try the ISP support staff first as I do not believe I have access. If that fails, will speak to you. Thanks again.

Joined: Jan 2004
Posts: 13
N
NitroX Offline OP
Stranger
OP Offline
Stranger
N
Joined: Jan 2004
Posts: 13
Hi Gizmo, sorry to bother you with such a simple question. I am been given the link to the PHPMyAdmin s/w on the ISP. But for the life of me can not find any menu item referring to Repair Table after selecting the "Online" table which needs repairs. Can you point me to where it is? Looked through the documentation as well, as well as every menu item. Does it require a scipt to be entered after using one of the menu items?

I believe it is PHPMyAdmin version 3.0.1.1

Joined: Apr 2004
Posts: 1,837
Likes: 110
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Apr 2004
Posts: 1,837
Likes: 110
What youre looking for inside phpMyAdmin is at the very bottom of the database list.

1) select the tables you want to repair
2) use the drop-down menu at the bottom to select "Repair table" (see attached image posted below)
then read the results on the next page. if all goes well, you'll get a positive confirmation message.

example:
[Linked Image from id242.com]


Current developer of UBB.threads PHP Forum Software
Current Release: UBBT 7.7.5 // Work In Progress: soon
isaac @ id242.com // my forum @ CelicaHobby.com
Joined: Jan 2004
Posts: 13
N
NitroX Offline OP
Stranger
OP Offline
Stranger
N
Joined: Jan 2004
Posts: 13
Thanks got it to work.

Will probably be in touch when migrating and upgrading.


Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Gobal announcement replies.
by Ruben - 04/09/2021 1:46 PM
Strange parse error in faq.php
by Baldeagle - 04/06/2021 1:12 AM
Upgrading to 7.7.5: Error:
by BB - 04/02/2021 10:48 AM
Does UBB 7.7.5 support webp images
by Ruben - 03/27/2021 12:00 PM
Does UBB support webp image. For insert image
by Ruben - 03/27/2021 9:49 AM
Who's Online Now
1 members (JAISP), 46 guests, and 84 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
gallery test
gallery test
by Mors, September 23
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Powered by UBB.threads™ PHP Forum Software 7.7.5