UBB.threads PHP Forum Software Community Forums UBB.threads 7 Version 7 Support Never did a backup...Now I might be toast

When I upgraded to UBBthreads I never performed subsequent backups. (I didn't know how using the myPHP interface) and now I may be burnt toast. Network Solutions suffered some kind of catastrophe last night and now I just see this:

UBB Error
We encountered a problem. The reason reported was

Database error only visible to forum administrators

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

The databases generate errors like they are not there when I access the myPHP interface.

Can anyone speculate what might have happened here? Another application I have that reads from a database is also not working and when I go into the myPHP interface I get error messages that the tables are not found. I didn't install UBB so I am not a expert.

I am updating my calls to Network Solutions here:

http://www.popularwireless.com

I alerted my users to the down time in my blog and shortly afterward the blog DB was corrupt when it had survived the first catastrophe. I don't know whether the ISP erased the message or just thought I was complaining about the blog.

I'd be willing to pay the fees from the UBB folks to help diagnose this. The site is part of my livelihood and an essential part of a new non-profit group.

If you don't have SQL error logging turned on, then what you can do is edit the libs/mysql.inc.php script. Around line 281 of that file you'll see this:

$showerror = 0;

Change that, to:

$showerror = 1;

This should then display the actual database error and we can give more advice on what to do next.

Thanks Rick I'm off to to do the edit.

Interesting. I can't find the php scripts or a LIBS directory. In the old UBB directory Rick?

nevermind. I found them.

We encountered a problem. The reason reported was

Script: /data/4/0/138/114/301929/user/306957/htdocs/forum/libs/ubbthreads.inc.php
Line#: 2179
SQL Error: Can't open file: 'ubbt_USERS.MYI' (errno: 145)
SQL Error #: 1016
Query: select t2.USER_TIME_OFFSET,t2.USER_TOPIC_VIEW_TYPE,t2.USER_TIME_FORMAT,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,t2.USER_LANGUAGE,t2.USER_MOOD,t2.USER_RELATIVE_TIME from ubbt_USERS AS t1, ubbt_USER_PROFILE as t2 where t1.USER_ID = 4 and t1.USER_ID = t2.USER_ID

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

I can also attempt access via the Network Solutions myPHP panel and copy that error. I have another PHP application that usese a smaller database with two tables and the smaller database reports the tables are not there.

error code 145 is for a crashed table. So basically you'll need to repair that table. If you have something like phpmyadmin installed you can run the following SQL command on your database.

repair table ubbt_USERS

OK. I'll go to that interface and report back.

Here's is what appears in the left column of the myPHP interface.

Warning: Cannot modify header information - headers already sent by (output started at /usr/services/mysql/phpmyadmin/left.php:92) in /usr/services/mysql/phpmyadmin/libraries/ob.lib.php on line 61

Error

SQL query: DocumentationEdit

SELECT COUNT( * ) AS num
FROM `ubbwireless`.`ubbt_USERS`

MySQL said: Documentation
#1016 - Can't open file: 'ubbt_USERS.MYI' (errno: 145)

Is repair table ubbt_USERS considered a Query? I cretaed tables for another datbase I made by using the import option which ran the command lines in an SQL sript. Do I import this line in a text file or run this as a query. I don't see a "command" window. I do see a QUERY window.

Yes, the repair statement would go in the query window.

Table Op Msg_type Msg_text
ubbwireless.ubbt_USERS repair status OK

Rick, where do I send the money dude? Flowers for the wife? Toy for the kid? Call the boss what?

Oh and is there a FAQ on how to do a back up?

I need to hurry up and setup the feedback/testimonial forum

Yep, Gizmo has a topic in the FAQ forum:

here

No kidding.

UBB ROCKS.

Rick, my Alexa status went from 900,000 something to just above 500,000. My advertising income is pleasant enough, my USERS think UBB is the BOMB...I just can't say enough good things. I'd like you to upgrade my site now if you think the latest version warrants it. I have the scratch at the moment sir.

Is there a T-Shirt? UBB gear?

I don't have SSH access to this company's machines. I assume then I need to use a backup option somewhere in the product or use myPHP admin to export tables? I'll start another thread....

phpmyadmin has an 'export' option. you can then select to gzip the result.

if all goes well, you'll have something like 'yoursite.sql.gz' ready to d/l to your computer

I think that with a db over about 50-100mb phpmyadmin will not provide a "complete dump" as it'll hit the php maximum execution time and kill the file...

you really need ssh access to use the items in the backup faq entry, but it's the best way to do a backup.

I believe you my be able to find some php scripts which create a dump in your webspace which isn't too out of the ordinary, assuming you can use system() or exec()... Heck, they may even use something differant

What about the backup routine from cron - can't it backup your DB as part of the site properly on *nix ?

Well, you could do what I did on one of my sites... I set cron to execute a backup.c file, chmodded 777, then set in there the commands i wanted to have run, which creates a folder, backs up the sql database, tars the directory, then ftps it elsewhere and then removes the archive... kind of advanced for a beginner though lol

Just send each Moderator & Admin cash - we will not complain

Seriously, glad you are all back up and running

Oh and don't forget to do that backup

Yeh, this little moderator L-O-V-E-S getting donations or payment... though development is generally the means hehe...

Hope you get a backup solution in place though

you never complain about all the thousands of dollars I send you....

...I assume you do get it all

Thousands of dollars? Psh, if I where getting thousands of dollars you'd have a private developer in yer pocket :x...