UBB.threads PHP Forum Software Community Forums UBB.threads Version 7/8 Support Rebuilding ubbthreads

Running ubbThreads 7.5.6.p2.

I had to have my Red Hat/Plesk server reloaded due to a corruption problem. Before the reload, I was able to export the ubbthreads database (all tables in one file) and copied the ubbthreads folder from httpdocs.

I installed the copied ubbthreads folder on the reloaded system.

I defined the ubbthreads database through mysql. I used the mysql source command to reload the database backup. I didn't see any errors or warnings. phpMyAdmin lists the ubbthreads tables.

I checked the database user and password fields in the config.inc.php file and they match the userid and password used when I created the database.

I checked the directories and files permissions per the documentation.

Upon entering the system I get this error ...

Where can I find out more about the error?

Are they any steps I missed?

Well if you never enabled the mysql error logs in ubb,you will get that generic message but no detail files to view in the folder it would be stored in.

If there are any helpful details.

There is a cheat however to see if it is reporting anything specific.
Edit libs/mysql.inc.php.
search for $showerror = 0
change that value to 1.
if there is any additional errors reported it will appear in the browser.

Just note though when done change it back to 0.
because all users will see the details.

But usually that error is related to a connection issue to the mysql database.
Meaning server name,user name.password. or the connection is just not there.

open libs/mysql.inc.php and find a line that has $showerrors and set it to 1

Is there a echo here???

Thanks for the help. Turns out my backups didn't have all the tables on them. Specifically the ubbt_USERS table was missing. It looks like the tables at the end of the alphabet were not picked up. For some reason they must not have been highlighted during the export.

I'm going to see if I can get my server rebooted off of my old master drive temporarily to get a good backup.

Missing tables will hose it for sure.
Good luck on your restore process.

Don't forget to reset the value back to 0 when done.
You don't want everyone to see the info displayed.

I appreciate the help.

No problemo.
Once you get running again. Turn on your error logs in the ubb control panel.
Then you can ftp to the error logs and view them instead of using the work around of editing mysql.inc.php

That's what I get while working and replying to posts at the same time...

Just having fun with this.
I am already looking at placing this in the wiki.
I am tired of answering this secret method multiple times.
Since I myself can never remember what value to change.

yeah, like the url to testing the image libraries... i get tired of having to look through the search every time I want to use it lol...

Okay I just added a wiki item on this at:
http://www.ubbwiki.com/article/view/1/database-error-only-visible-to-forum-administrators.html

It looks like my restore worked. After I restored the database tables I ran all the maintenance rebuilds just to be sure.

I currently have it the board in maintenance mode while I check out the board. I noticed that the links in the post and topic islands aren't working. Is that because they need to be refreshed and will automatically do that once the board is reopened?

I also have a few postings (looks like the most recent ones) that I can't access. I also can't delete them. Any suggestions on how to delete them? One of them is a sticky topic that is at the top of every forum. I can't delete it. I get the message when I click on it.

I appreciate the help from yesterday. It was very useful.

Have you run the rebuild tools for the forum... I think this may help your issue.

I am not to sure on all your issues.
Could be just a issue with date stamps on your restore files.
Have you tried going through all the content re-builders in the ubb control panel yet?

FYI,
Some of them may take a extremely long time based on the number of members and posts.

Ruben and I posted at the same time. I apologize for the double posting on it

I mentioned in my earlier posting that I ran all the rebuild scripts.


And, yes, some did take a long time.

No apology needed Dunny we are on the same boat.

Okay I see your ran the rebuild scripts. But also I see your real issue appears to be the islands.

So the next step would be to clear cache.
And by that it may be a extra step since you were hosed.
So what I would do is ftp to your cache folder delete all files except for the htm html files.
Then run the clear cache utility in the ubb control panel.
That will rebuild the scripts for your islands and ensure that they have all been rebuilt.

That might get you closer on target.
Next item might be the sessions folder. But that should not really be a issue. Unless you have hundreds of files there. But a browser cache could also be a culprit.

Not just the islands, but I have some postings that I can't see or delete.

Following your instructions above (I had no html files in the cache directory) the result was that the islands are fine.

But I still have some posts that I can't see or delete. Any other suggestions? I appreciate your assistance. (By "not see" I mean I can see an entry in the forum topic list but when I click on it I get the error message posted earlier.)

I think the island issue is simply one of "things need to be made", when you make a new post does it show in an island?

Have you purged everything out of the /cache and /templates/compiled directories and run the clear cache function in the control panel?

Nope, not at this juncture.
It sounds like you might need some database editing.
Something is out of sync with what you used to restore the site with.

Also I hope you did attempt to clear cache on your web browser because that also could be a issue with all the changes you have performed.

Additional information ...

So far it looks like the only topics that I can't access are sticky topics and global announcements. Perhaps that helps to narrow down the problem.

I've checked several dozen others with no problem.

I used the mysql source command from the root user.

No I didn't do that because the master drive on my system was replaced and all the files/directories started off clean.

All I can say is back to the rebuild content option which has seven scripts to run.
Try all seven again I guess.
Other than that you may need assistance from UBB.
If the clear cache has improved your situation then maybe running the re builders again will resolve you problem.

That seems like a reasonable suggestion. I'll run all the rebuild scripts in the order listed. That will have to wait until later tonight. I want to give my users a chance to use the system for a while. It's been down for 2 days and people are in withdrawal.

Understood!
Good luck!

[/b]I rebooted my server and ran all 7 rebuild scripts.

I still have sticky topics and global announcements that I click on and still get [b]There was a problem looking up this post in our database. when I click on them in the topic list.

I would like to delete them but can't.

Suggestions.

Have you tried repairing the forum posts and forum topics tables?

REPAIR TABLE ubbt_FORUMS

REPAIR TABLE ubbt_TOPICS

Are the above commands entered through mysql? If so, I assume I need to issue a USE ubbthreads statement first.

Should I have the message board set in maintenance mode?

Thank you.

You should put it in maintenance mode, but use the mysql tools section in your control panel, the second tab. Use the commands as written.

I will have to wait until late tonight to do this when I can boot users off the system for a while.

I will report back on the results.

Thank you.

As a side note, the 2 sticky posts and global announcements show "-1" in the Replies column in the Forum/Topics list page. They should show 0. Obviously this further flags these as problems.

Those two topics were added to the board long before the backup was taken that was used in the restore. So something in either the sql load or the ubbthreads content rebuilder scrips got those posts messed up.

I will run the REPAIR commands later tonight and will report back.

Sure, each command should only take a few seconds to run at most, and run them separately - repair the topics then forums.

I though I'd report back on the final resolution to this problem.

I discovered by looking through some of the forums that there were a number of posts missing and some users were missing, too. A further investigation showed that it appeared that not all records were exported successfully during my backup. I had been using phpMyAdmin to do an export. I broke up the tables into 4 groups because some (like the posts table) were really large. But even doing this missed some records possibly due to a query length limit restriction.

So I booted up my old master drive and did the backup via mysqldump from root on the system. That worked and got all the records into one file.

I did do the rebuild scripts anyway just to be sure. Even the sticky posts and global announcements that I couldn't access before were fixed.

I appreciate everyone's input above.