Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
2 registered (Gizmo, SteveS), 38 Guests and 14 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 06/07/07
Posts: 4
Top Posters (30 Days)
Ruben 50
DennyP 24
Gizmo 23
Dunny 15
SteveS 13
AllenAyres 12
dbremer 10
SD 10
drkknght00 9
doug 8
Latest Photos
OK Corral Shoot Out
Testing
Basildon Train Station
Basildon Town Centre looking from the rounderbout
Basildon Town Square
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: 4424
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: 4424
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
Temporary Password email not being received
by
05/24/12 10:02 PM
Ability to "like" individual posts (not Facebook "likes)
by doug
05/23/12 09:03 AM
Island Permissions
by ThreadsUser
05/22/12 03:03 PM
streaming video
by prkrgrp
05/20/12 07:02 PM
New Posts Corrupted? Can someone help?
by PianoWorld
05/19/12 09:41 AM
Forum Stats
10492 Members
36 Forums
33842 Topics
181709 Posts

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