Previous Thread
Next Thread
Print Thread
Hop To
Joined: Jan 2004
Posts: 15
N
Stranger
Stranger
N Offline
Joined: Jan 2004
Posts: 15
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: 15
N
Stranger
Stranger
N Offline
Joined: Jan 2004
Posts: 15
If needed willing to hire someone to assist.

Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
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: 15
N
Stranger
Stranger
N Offline
Joined: Jan 2004
Posts: 15
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: 15
N
Stranger
Stranger
N Offline
Joined: Jan 2004
Posts: 15
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,945
Likes: 145
UBB.threads Developer
UBB.threads Developer
Joined: Apr 2004
Posts: 1,945
Likes: 145
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 // Preview: UBBT 8.0.0
isaac @ id242.com // my forum @ CelicaHobby.com
Joined: Jan 2004
Posts: 15
N
Stranger
Stranger
N Offline
Joined: Jan 2004
Posts: 15
Thanks got it to work.

Will probably be in touch when migrating and upgrading.

Joined: Jan 2004
Posts: 15
N
Stranger
Stranger
N Offline
Joined: Jan 2004
Posts: 15
Originally Posted by NitroX
Thanks got it to work.

Will probably be in touch when migrating and upgrading.


Unfortunately it has crashed again. Fixing it currently.

Definitely need to upgrade to the current version NOW. wink

Joined: Jan 2004
Posts: 15
N
Stranger
Stranger
N Offline
Joined: Jan 2004
Posts: 15
Can the v6.5.5 be upgraded directly to the current version? v7.7.5?

Is there still a page with notes on upgrading from v6 to v7.7.5? Link please? I will have a search for one. Thanks.

Last edited by NitroX; 11/24/2023 2:51 PM.
Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
you did not say if it is classic or ubbthreads wwwthreads.

The docs tab up top has most info
https://www.ubbcentral.com/docs.php

If it has a mysql database
I would do it in at least two steps start with v7.2 see if all is well check you member count for moderators users .
Ver 7 is when they added global mods and sometimes everybody becomes a moderator
Then upgrade all the way.

Importers are in the member download page.
I looked at this a little closer you need to use the importer to get to v7.2 then use the upgrade tool to get to the current v7

Last edited by Ruben; 11/24/2023 3:35 PM. Reason: Added comment

Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
It's a PHPMyAdmin screen so it'd be UBBThreads 6.5.5

I still do my v6 upgrades as v7.0.0 -> v7.2 -> Latest; once v8 is out it'd be v7.0.0 -> v7.2 -> v7.5.x -> v8


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!

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
1 members (rootman), 641 guests, and 112 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)