Previous Thread
Next Thread
Print Thread
Hop To
#249082 05/09/2012 1:35 PM
Joined: Apr 2004
Posts: 232
Likes: 1
D
DennyP Offline OP
Enthusiast
OP Offline
Enthusiast
D
Joined: Apr 2004
Posts: 232
Likes: 1
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 ...
Quote
We encountered a problem. The reason reported was
Database error only visible to forum administrators

Where can I find out more about the error?

Are they any steps I missed?

Last edited by DennyP; 05/09/2012 2:01 PM.

DennyP - www.dennyp.com
DennyP Travel
Joined: Dec 2003
Posts: 6,375
Likes: 52
Online Yawn
Joined: Dec 2003
Posts: 6,375
Likes: 52
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.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Jun 2006
Posts: 16,085
Likes: 76
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 16,085
Likes: 76
open libs/mysql.inc.php and find a line that has $showerrors and set it to 1


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: Dec 2003
Posts: 6,375
Likes: 52
Online Yawn
Joined: Dec 2003
Posts: 6,375
Likes: 52
Is there a echo here???


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Apr 2004
Posts: 232
Likes: 1
D
DennyP Offline OP
Enthusiast
OP Offline
Enthusiast
D
Joined: Apr 2004
Posts: 232
Likes: 1
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.


DennyP - www.dennyp.com
DennyP Travel
Joined: Dec 2003
Posts: 6,375
Likes: 52
Online Yawn
Joined: Dec 2003
Posts: 6,375
Likes: 52
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.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Apr 2004
Posts: 232
Likes: 1
D
DennyP Offline OP
Enthusiast
OP Offline
Enthusiast
D
Joined: Apr 2004
Posts: 232
Likes: 1
I appreciate the help.


DennyP - www.dennyp.com
DennyP Travel
Joined: Dec 2003
Posts: 6,375
Likes: 52
Online Yawn
Joined: Dec 2003
Posts: 6,375
Likes: 52
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


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Jun 2006
Posts: 16,085
Likes: 76
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 16,085
Likes: 76
Originally Posted by Ruben
Is there a echo here???
That's what I get while working and replying to posts at the same time...


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: Dec 2003
Posts: 6,375
Likes: 52
Online Yawn
Joined: Dec 2003
Posts: 6,375
Likes: 52
Just having fun with this. grin
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.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Jun 2006
Posts: 16,085
Likes: 76
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 16,085
Likes: 76
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...


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: Dec 2003
Posts: 6,375
Likes: 52
Online Yawn
Joined: Dec 2003
Posts: 6,375
Likes: 52


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Apr 2004
Posts: 232
Likes: 1
D
DennyP Offline OP
Enthusiast
OP Offline
Enthusiast
D
Joined: Apr 2004
Posts: 232
Likes: 1
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
Quote
There was a problem looking up this post in our database.
when I click on it.

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


DennyP - www.dennyp.com
DennyP Travel
Joined: Jan 2008
Posts: 514
addict
Offline
addict
Joined: Jan 2008
Posts: 514
Have you run the rebuild tools for the forum... I think this may help your issue.


Joined: Dec 2003
Posts: 6,375
Likes: 52
Online Yawn
Joined: Dec 2003
Posts: 6,375
Likes: 52
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.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Jan 2008
Posts: 514
addict
Offline
addict
Joined: Jan 2008
Posts: 514
Ruben and I posted at the same time. I apologize for the double posting on it

Joined: Apr 2004
Posts: 232
Likes: 1
D
DennyP Offline OP
Enthusiast
OP Offline
Enthusiast
D
Joined: Apr 2004
Posts: 232
Likes: 1
I mentioned in my earlier posting that I ran all the rebuild scripts.

Quote
After I restored the database tables I ran all the maintenance rebuilds just to be sure.

And, yes, some did take a long time.

Last edited by DennyP; 05/10/2012 6:07 PM.

DennyP - www.dennyp.com
DennyP Travel
Joined: Dec 2003
Posts: 6,375
Likes: 52
Online Yawn
Joined: Dec 2003
Posts: 6,375
Likes: 52
No apology needed Dunny we are on the same boat.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Dec 2003
Posts: 6,375
Likes: 52
Online Yawn
Joined: Dec 2003
Posts: 6,375
Likes: 52
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.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Apr 2004
Posts: 232
Likes: 1
D
DennyP Offline OP
Enthusiast
OP Offline
Enthusiast
D
Joined: Apr 2004
Posts: 232
Likes: 1
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.)

Last edited by DennyP; 05/10/2012 6:32 PM.

DennyP - www.dennyp.com
DennyP Travel
Joined: Jun 2006
Posts: 16,085
Likes: 76
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 16,085
Likes: 76
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?


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: Dec 2003
Posts: 6,375
Likes: 52
Online Yawn
Joined: Dec 2003
Posts: 6,375
Likes: 52
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.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Apr 2004
Posts: 232
Likes: 1
D
DennyP Offline OP
Enthusiast
OP Offline
Enthusiast
D
Joined: Apr 2004
Posts: 232
Likes: 1
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.


DennyP - www.dennyp.com
DennyP Travel
Joined: Apr 2004
Posts: 232
Likes: 1
D
DennyP Offline OP
Enthusiast
OP Offline
Enthusiast
D
Joined: Apr 2004
Posts: 232
Likes: 1
Originally Posted by Ruben
Something is out of sync with what you used to restore the site with.
I used the mysql source command from the root user.


DennyP - www.dennyp.com
DennyP Travel
Joined: Apr 2004
Posts: 232
Likes: 1
D
DennyP Offline OP
Enthusiast
OP Offline
Enthusiast
D
Joined: Apr 2004
Posts: 232
Likes: 1
Originally Posted by Ruben
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.
No I didn't do that because the master drive on my system was replaced and all the files/directories started off clean.


DennyP - www.dennyp.com
DennyP Travel
Joined: Dec 2003
Posts: 6,375
Likes: 52
Online Yawn
Joined: Dec 2003
Posts: 6,375
Likes: 52
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.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Apr 2004
Posts: 232
Likes: 1
D
DennyP Offline OP
Enthusiast
OP Offline
Enthusiast
D
Joined: Apr 2004
Posts: 232
Likes: 1
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.


DennyP - www.dennyp.com
DennyP Travel
Joined: Dec 2003
Posts: 6,375
Likes: 52
Online Yawn
Joined: Dec 2003
Posts: 6,375
Likes: 52
Understood!
Good luck!


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Apr 2004
Posts: 232
Likes: 1
D
DennyP Offline OP
Enthusiast
OP Offline
Enthusiast
D
Joined: Apr 2004
Posts: 232
Likes: 1
[/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.


DennyP - www.dennyp.com
DennyP Travel
Joined: Dec 2003
Posts: 1,796
Pooh-Bah
Offline
Pooh-Bah
Joined: Dec 2003
Posts: 1,796
Have you tried repairing the forum posts and forum topics tables?


- Allen
- ThreadsDev | PraiseCafe
Joined: Dec 2003
Posts: 1,796
Pooh-Bah
Offline
Pooh-Bah
Joined: Dec 2003
Posts: 1,796
REPAIR TABLE ubbt_FORUMS

REPAIR TABLE ubbt_TOPICS


- Allen
- ThreadsDev | PraiseCafe
Joined: Apr 2004
Posts: 232
Likes: 1
D
DennyP Offline OP
Enthusiast
OP Offline
Enthusiast
D
Joined: Apr 2004
Posts: 232
Likes: 1
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.


DennyP - www.dennyp.com
DennyP Travel
Joined: Dec 2003
Posts: 1,796
Pooh-Bah
Offline
Pooh-Bah
Joined: Dec 2003
Posts: 1,796
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.


- Allen
- ThreadsDev | PraiseCafe
Joined: Apr 2004
Posts: 232
Likes: 1
D
DennyP Offline OP
Enthusiast
OP Offline
Enthusiast
D
Joined: Apr 2004
Posts: 232
Likes: 1
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.


DennyP - www.dennyp.com
DennyP Travel
Joined: Apr 2004
Posts: 232
Likes: 1
D
DennyP Offline OP
Enthusiast
OP Offline
Enthusiast
D
Joined: Apr 2004
Posts: 232
Likes: 1
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.


DennyP - www.dennyp.com
DennyP Travel
Joined: Dec 2003
Posts: 1,796
Pooh-Bah
Offline
Pooh-Bah
Joined: Dec 2003
Posts: 1,796
Sure, each command should only take a few seconds to run at most, and run them separately - repair the topics then forums.


- Allen
- ThreadsDev | PraiseCafe
Joined: Apr 2004
Posts: 232
Likes: 1
D
DennyP Offline OP
Enthusiast
OP Offline
Enthusiast
D
Joined: Apr 2004
Posts: 232
Likes: 1
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.


DennyP - www.dennyp.com
DennyP Travel

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
IMG Options
by mmem700 - 06/12/2021 10:14 AM
Custom Island database updates
by Pak Chan - 06/09/2021 2:11 PM
PHP 8 support + which php engine is used in IIS?
by luket - 06/08/2021 7:05 AM
7.7.5 Update error
by ECNet - 05/30/2021 8:08 PM
Re: Custom Island Questions
by ECNet - 05/30/2021 5:00 PM
Who's Online Now
1 members (Ruben), 61 guests, and 97 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