Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online Now
0 registered members (), 59 guests, and 384 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
Morgan
Morgan
Sweden
Posts: 518
Joined: June 2006
Show All Member Profiles 
Top Posters(30 Days)
Gizmo 17
M4TT 12
FREAK 8
Ruben 8
isaac 4
mmkk 4
Latest Photos
Chinese Buddhist temple.
My buddha beads.
Rendered Walls
Multi-Screen wallpaper
Stockholm Metro
Previous Thread
Next Thread
Print Thread
Errors caused by the w3t_Online file in mysql #260198
05/16/17 02:46 PM
05/16/17 02:46 PM
Joined: Jan 2004
Posts: 11
N
NitroX Offline OP
stranger
NitroX  Offline OP
stranger
N
Joined: Jan 2004
Posts: 11
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.

Re: Errors caused by the w3t_Online file in mysql [Re: NitroX] #260199
05/16/17 03:46 PM
05/16/17 03:46 PM
Joined: Jan 2004
Posts: 11
N
NitroX Offline OP
stranger
NitroX  Offline OP
stranger
N
Joined: Jan 2004
Posts: 11
If needed willing to hire someone to assist.

Re: Errors caused by the w3t_Online file in mysql [Re: NitroX] #260200
05/16/17 04:09 PM
05/16/17 04:09 PM
Joined: Jun 2006
Posts: 16,788
Portland, OR; USA
Gizmo Offline
UBB.threads Developer
Gizmo  Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 16,788
Portland, OR; USA
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.
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!
Re: Errors caused by the w3t_Online file in mysql [Re: NitroX] #260201
05/16/17 04:16 PM
05/16/17 04:16 PM
Joined: Jan 2004
Posts: 11
N
NitroX Offline OP
stranger
NitroX  Offline OP
stranger
N
Joined: Jan 2004
Posts: 11
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.

Re: Errors caused by the w3t_Online file in mysql [Re: NitroX] #260202
05/17/17 05:52 AM
05/17/17 05:52 AM
Joined: Jan 2004
Posts: 11
N
NitroX Offline OP
stranger
NitroX  Offline OP
stranger
N
Joined: Jan 2004
Posts: 11
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

Re: Errors caused by the w3t_Online file in mysql [Re: NitroX] #260203
05/17/17 06:55 AM
05/17/17 06:55 AM
Joined: Apr 2004
Posts: 1,004
California
isaac Offline
UBB.threads Developer
isaac  Offline
UBB.threads Developer
Joined: Apr 2004
Posts: 1,004
California
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]

Re: Errors caused by the w3t_Online file in mysql [Re: NitroX] #260204
05/17/17 12:10 PM
05/17/17 12:10 PM
Joined: Jan 2004
Posts: 11
N
NitroX Offline OP
stranger
NitroX  Offline OP
stranger
N
Joined: Jan 2004
Posts: 11
Thanks got it to work.

Will probably be in touch when migrating and upgrading.


Shout Box
Today's Birthdays
No Birthdays
Recent Topics
Users Unable to Upload Avatar [Not a Bug]
by M4TT. 12/13/17 08:51 AM
Shout Box Sound Effect
by M4TT. 11/29/17 08:28 PM
Ad island
by TGCsanderson. 11/25/17 06:41 PM
Taking to long to connect to DB
by AstroCat. 11/24/17 12:34 PM
Forum Statistics
Forums36
Topics35,015
Posts190,544
Members12,045
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.6.1
(Snapshot build 20171106)