Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
4 registered (alissarose, KuKuKaChu, Dunny, id242), 40 Guests and 14 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 06/05/06
Posts: 469
Top Posters (30 Days)
Ruben 51
Gizmo 24
DennyP 24
Dunny 15
SteveS 14
AllenAyres 12
SD 10
dbremer 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 2 1 2 >
Topic Options
#189563 - 07/01/07 07:49 PM Help please - Fatal error
ThreadsUser Offline
member
Registered: 11/22/06
Posts: 163
There was a problem with our server this evening, I'm not sure what yet. When it came back I had to repair the tables and posts before the forums would work again. I was then able to post as admin.

I then became a user to see if they could post and I was presented with this message:

Database error only visible to forum administrators

I could then not log back in as admin and am now shown this:

Fatal error: Call to a member function error() on a non-object in /home/vhost/domain.com/html/libs/mysql.inc.php on line 210

Any ideas as to what I can do to fix this please \:\)
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."
#189565 - 07/01/07 07:52 PM Re: Help please - Fatal error [Re: ThreadsUser]
Gizmo Offline

Registered: 06/05/06
Posts: 14995
Loc: Portland, OR; USA
Well, the SQL error is only available to admin's; so you'll need to get the content of the error to see what the problem is; you can do this by either enabling sql logging in the control panel or theres a "tick" in the /libs/mysql.inc.php file to show errors to all users (just search for error i think)
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#189566 - 07/01/07 07:56 PM Re: Help please - Fatal error [Re: Gizmo]
ThreadsUser Offline
member
Registered: 11/22/06
Posts: 163
Thankyou Gizmo. I cannot get into the control panel now \:\(
Top
#189569 - 07/01/07 08:03 PM Re: Help please - Fatal error [Re: ThreadsUser]
ThreadsUser Offline
member
Registered: 11/22/06
Posts: 163
I edited the file and now I get this message:

Fatal error: Class 'sql' not found in /home/vhost/domain.com/html/libs/ubbthreads.inc.php on line 115
Top
#189573 - 07/01/07 08:06 PM Re: Help please - Fatal error [Re: ThreadsUser]
ThreadsUser Offline
member
Registered: 11/22/06
Posts: 163
Parse error: syntax error, unexpected $end in /home/vhost/domain.com/html/libs/mysql.inc.php on line 40
Top
#189580 - 07/01/07 08:18 PM Re: Help please - Fatal error [Re: ThreadsUser]
ThreadsUser Offline
member
Registered: 11/22/06
Posts: 163
From admin screen:

Fatal error: Call to a member function error() on a non-object in /home/vhost/domain.com/html/libs/mysql.inc.php on line 210

From users screen:

Script: /home/vhost/domain.com/html/libs/ubbthreads.inc.php
Line#: 2026
SQL Error: Table 'ubbt_CACHED_PERMISSIONS' is marked as crashed and should be repaired
SQL Error #: 1194
Query: delete from ubbt_CACHED_PERMISSIONS where CACHED_TIMESTAMP < '1183295190'
Top
#189585 - 07/01/07 09:02 PM Re: Help please - Fatal error [Re: ThreadsUser]
Gizmo Offline

Registered: 06/05/06
Posts: 14995
Loc: Portland, OR; USA
What exactly did you do to mysql.inc.php?

By changing:
$showerror = 0;

to:
$showerror = 1;

it should not throw ANY errors other than the anticipated mysql errors...
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#189586 - 07/01/07 09:04 PM Re: Help please - Fatal error [Re: Gizmo]
ThreadsUser Offline
member
Registered: 11/22/06
Posts: 163
just changed 0 to 1 \:\)

It then shows users:

Script: /home/vhost/domain.com/html/libs/ubbthreads.inc.php
Line#: 2026
SQL Error: Table 'ubbt_CACHED_PERMISSIONS' is marked as crashed and should be repaired
SQL Error #: 1194
Query: delete from ubbt_CACHED_PERMISSIONS where CACHED_TIMESTAMP < '1183295190'
Top
#189588 - 07/01/07 09:13 PM Re: Help please - Fatal error [Re: ThreadsUser]
Gizmo Offline

Registered: 06/05/06
Posts: 14995
Loc: Portland, OR; USA
Run this query from your admin center in database tools, if you can't access your CP, use PHPMyAdmin (or some other similar MySQL database tool) and run the following command:
 Code:
REPAIR TABLE `ubbt_CACHED_PERMISSIONS` 
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#189592 - 07/01/07 09:22 PM Re: Help please - Fatal error [Re: Gizmo]
ThreadsUser Offline
member
Registered: 11/22/06
Posts: 163
Done. Received

threads.ubbt_CACHED_PERMISSIONS repair status OK

but still no joy \:\(
Top
Page 1 of 2 1 2 >



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
10490 Members
36 Forums
33841 Topics
181708 Posts

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