I really hope someone can help me solve a UBBthreads crash by my domain host provider.
In short they crashed my domain and they were doing a full restore today Now they say they restored everything BUT the SQL databases they could not fix
Now when going to my forum all that is seen as the screenshot attached below below Version is one less then what you show as the newest update This UBB forum has been online since early days of mid to late 1990s and has countless important techie type of posts ( about 7,000), tons of Corvette (car) photos, video, etc and I really do not want to lose that history content
How can I fix, since I cannot get to main forum page I of course cannot then click on the control/admin to get there so what ways to fix the database issues I would bet with the backup and restores host service did today that maybe the UBBthreads data base files can be recovered,
Shown below is all the databases I have, do not know which is for UBBthreads but tried the repair function for each and did not fix the problem
Please help as many of the users are world wide and this has been down now for over 24 hours so they have to wonder what or if the forum comes back See both screenshots below
Take and open the file libs/mysql.inc.php and look for a variable named "$showerror" (~line 269):
Code
$showerror = 0;
Take and change that variable to a 1 and your forum will now print all of the mysql errors to the browser so that anyone can now view them; please take care to reverse this change when everything is working properly.
In snooping around directories on host server I found a URL for Control panel I then loaded it.
Not sure if this is for the version 7.5.x I have been using for some years or from a older version but when going to that URL instead of showing the CP it is as shown below and I did not want to try it as it might cause further problems and delete the countless posts/content forum had
Do I try this for a fix or someone lead me to whats needed to fix that SQL issue ?
This file you mention is this lib directly directly in the UBBthreads directory ?
Yes, you must edit the file in a plain text editor such as Notepad, Edit+, or Notepad++.
Originally Posted by teamzr1
Then if I can do what you mention what do I then do to correct those errors ?
Depends on the error, could just be that one of your tables crashed, in which case you'd run the repair command on the database.
It appears your error is: "SQL Error: Table 'teamzr5_zc3.ubbt_USERS' doesn't exist"; either the table has been deleted, the forum is set to use the wrong database, or something is drastically wrong...
You don't just "install" a table; the table should have already been there, that particular table is where ALL of your user data (login names, passwords, etc) without it you don't have any users on your forum.
To MANAGE the table you'd have to have a tool like PHPMyAdmin installed.
As for the CP you "found" (your CP won't work for Threads since your user table is broken) is for UBB.Classic, the predecessor to what you're running now (whoever did the upgrade for you should have set those files not to be executed for security).
Before reading this I did was with PHPmyadmin exported all the tables from zc2 and then exported them all to zc3 and that got both the forum and the control panel working
Problem is the newest posts and content on forum is back from 2010 :-( so looks like the host provider did a number on me when they did restores Forum does say it is version 7.5.6p2
I hate to tell you that you are probably hosed. From your posts it appears that your newest database is zc3. Zc2 will not help unless it is based on the same current version. Which zc2 is possibly from a older version that you upgraded from in 2010? Hence why all post are 2010 and older?
This is a reason that we should not rely on our hosts to make backups and restore them.
I have no idea what version you were using for zc3 or zc2 but I can tell you that the post you made above referencing cgi.jpg is from the classic version that does not work if you are using a newer version. If you don't have a backup yourself your best option is to contact the host again. And point out the fact that the zc3 database is blank, if that is in fact the database that you were currently using. At best ask them to restore it again or from a older backup. You may loose current posts but at least it will work again.Or be more current and correct.
Also copying a database from a older version of ubb to use on a newer version of ubb is not a good idea either. When you bypass the upgrade scripts. The web page may report the correct version of UBB since you did not change the scripts but if the database tables are not formatted correctly for that version you looking for big time trouble.
Blue Man Group There is no such thing as stupid questions. Just stupid answers