Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
5 registered (ayawkho, SteveS, Tainted, Mike L, KuKuKaChu), 29 Guests and 14 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 03/21/08
Posts: 224
Top Posters (30 Days)
Ruben 61
SD 52
Gizmo 48
gliderdad 33
Dunny 21
driv 18
dbremer 16
Stan 13
Mark S 13
Steve C 10
Latest Photos
Testing
Basildon Train Station
Basildon Town Centre looking from the rounderbout
Basildon Town Square
Gizzo Marx
Page 1 of 3 1 2 3 >
Topic Options
#238187 - 07/25/10 01:06 PM Forum crashed after server SQL repair - HELP
teamzr1 Offline
enthusiast
Registered: 06/19/07
Posts: 249
The hostserver where my UBB is loaded to my domain did a SQL database repairs for another software issue and now I find when going to my forum it is crashed saying

We encountered a problem. The reason reported was

Database error only visible to forum administrators


---------------

How can I get to Admin directly (URL) ? page to fix this ASAP or via the Cpanel of the host for SQL ?

Never seen this in 10 years of UBB use so no idea how to quickly fix this

When I try to go directly to admin logn I get

Fatal error: Call to a member function error() on a non-object in /home1/teamzron/public_html/ubbthreads/libs/mysql.inc.php on line 77

Thanks for any help


Edited by teamzr1 (07/25/10 01:10 PM)
_________________________
JR
Team ZR-1 Corvette Racer's
Top
Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
#238188 - 07/25/10 01:08 PM Re: Forum crashed after server SQL repair - HELP [Re: teamzr1]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
You'll want to get to the root cause of the error. If you don't have SQL error logging turned on, then you'll want to edit the libs/mysql.inc.php file and change the line that says:

$showerror = 0;

to

$showerror =1;

Then report back here with what the actual error is.
Top
#238189 - 07/25/10 01:14 PM Re: Forum crashed after server SQL repair - HELP [Re: Rick]
teamzr1 Offline
enthusiast
Registered: 06/19/07
Posts: 249
Does the error I added to above help ?

via Cpanel on host the phpAdmin was used and the databases were all set to repair and then to optimize
After that forum was broken
_________________________
JR
Team ZR-1 Corvette Racer's
Top
#238190 - 07/25/10 01:21 PM Re: Forum crashed after server SQL repair - HELP [Re: teamzr1]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
Not particularly. It's trying to throw an admin error but can't. We really need to see the actual database error.
Top
#238191 - 07/25/10 01:21 PM Re: Forum crashed after server SQL repair - HELP [Re: Rick]
teamzr1 Offline
enthusiast
Registered: 06/19/07
Posts: 249
Changing to 1 and now get

We encountered a problem. The reason reported was

Script:
Line#:
SQL Error: Access denied for user 'teamzron'@'localhost' (using password: YES)
SQL Error #: 1045
Query: Unable to connect to the database!
_________________________
JR
Team ZR-1 Corvette Racer's
Top
#238192 - 07/25/10 01:22 PM Re: Forum crashed after server SQL repair - HELP [Re: teamzr1]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
Ok, so it's a database access issue. It seems somehow they've taken away your access to your database. If you've got cpanel you might want to go into the MySQL databases section and confirm that the proper user has access to the database, or create a new user if necessary.
Top
#238193 - 07/25/10 01:28 PM Re: Forum crashed after server SQL repair - HELP [Re: Rick]
teamzr1 Offline
enthusiast
Registered: 06/19/07
Posts: 249
Which database is for UBB ?


teamzron_bdd1 0.05 MB
teamzron_bdd1 Delete User
Delete Database
teamzron_dprj1 0.20 MB
teamzron_dprj1 Delete User
Delete Database
teamzron_mychat1 0.00 MB
teamzron_mychat1 Delete User
Delete Database
teamzron_nhs1 0.16 MB
teamzron_nhs1 Delete User
Delete Database
teamzron_pfc01 0.00 MB
teamzron_pfc01 Delete User
Delete Database
teamzron_zc1 72.77 MB
teamzron_zc1 Delete User
_________________________
JR
Team ZR-1 Corvette Racer's
Top
#238194 - 07/25/10 01:36 PM Re: Forum crashed after server SQL repair - HELP [Re: teamzr1]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
It looks like the teamzron_zc1, but to be sure, take a look at your includes/config.inc.php file and look at the DATABASE_NAME in that file to verify.
Top
#238195 - 07/25/10 01:38 PM Re: Forum crashed after server SQL repair - HELP [Re: teamzr1]
Ruben Offline

Registered: 12/20/03
Posts: 4268
Loc: Lutz,FL
If you don't recall your database name then you may want to start with looking at includes/config.inc.php.

The top few lines will tell you all the info needed.
Quote:
<?php
$config = array (
'DATABASE_SERVER' => 'yourhost',
'DATABASE_USER' => 'username',
'DATABASE_PASSWORD' => 'password',
'DATABASE_NAME' => 'databasename',
'TABLE_PREFIX' => 'ubbt_',( this is the default setting)
_________________________
Blue Man Group
Top
#238196 - 07/25/10 01:45 PM Re: Forum crashed after server SQL repair - HELP [Re: teamzr1]
Ruben Offline

Registered: 12/20/03
Posts: 4268
Loc: Lutz,FL
Whats up with the delete user line?
Quote:
teamzron_zc1 Delete User
_________________________
Blue Man Group
Top
Page 1 of 3 1 2 3 >



Moderator:  AllenAyres, Harold, Ian, Ron M 
Shout Box

Today's Birthdays
No Birthdays
Recent Topics
Edit Post
by Bert
Today at 01:19 PM
A positive note
by SteveS
Yesterday at 09:36 PM
How to locate links to particular site if they are only used in images?
by Conrad
02/10/12 09:41 PM
Pictures not displaying
by Marker23
02/09/12 10:04 PM
Issue with logging out constantly
by Flanuva
02/09/12 07:05 PM
Forum Stats
10214 Members
36 Forums
33667 Topics
180917 Posts

Max Online: 978 @ 06/24/07 11:19 PM
Random Image