Previous Thread
Next Thread
Print Thread
Hop To
Joined: Jun 2006
Posts: 987
Likes: 24
Old Hand
Old Hand
Joined: Jun 2006
Posts: 987
Likes: 24
hi
Our forum is down please advice, Is this something you experienced before?
Any ideas? See link to 7.6 forum below in signature

Quote
Morgan, why is it I can login on my phone but not on my computer? A page comes up that says "We encountered a problem. The reason reported was: database error only visible to administrators".

I see the same message my self on my computer and on my Ipad I see going to the admin dashboard

Quote
Fatal error: Call to a member function error() on null in /home/britbike/public_html/forums/libs/mysql.inc.php on line 62

Please advice, thanks


Morgan Johansson
BritBike Forum
https://www.britbike.com/forums/ubbthreads.php
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
http://www.britbike.com/forums/ubbthreads.php
Quote
Database error only visible to forum administrators

If you have logging for MySQL errors on, go look at the error in the log; if not then open /libs/mysql.inc.php and find the line:
Code
$showerror = 0;

Replace with:
Code
$showerror = 1;

And the error will display to the browser.


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: Jun 2006
Posts: 987
Likes: 24
Old Hand
Old Hand
Joined: Jun 2006
Posts: 987
Likes: 24
Gizmo, I did above and now it reads

Quote
We encountered a problem. The reason reported was:
Script: /home/britbike/public_html/forums/libs/user.inc.php
Line#: 334
SQL Error: Table 'ubbt_bbfCACHED_PERMISSIONS' is marked as crashed and should be repaired
SQL Error #: 1194
Query: select USER_ID,FORUM_PERMISSIONS,SITE_PERMISSIONS,CP_PERMISSIONS from ubbt_bbfCACHED_PERMISSIONS where USER_ID = 1



Morgan Johansson
BritBike Forum
https://www.britbike.com/forums/ubbthreads.php
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
Well, theres your answer:
Quote
SQL Error: Table 'ubbt_bbfCACHED_PERMISSIONS' is marked as crashed and should be repaired

You can either run a repair via PHPMyAdmin or via the command line:
Code
 mysqlcheck --repair --all-databases


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: Jun 2006
Posts: 987
Likes: 24
Old Hand
Old Hand
Joined: Jun 2006
Posts: 987
Likes: 24
Let see
I have login to PHPMyAdmin and went to SQL and put your " mysqlcheck --repair --all-databases" in and it read
Quote
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysqlcheck --repair --all-databases' at line 1

Not really sure how to do this can you guide me?


Morgan Johansson
BritBike Forum
https://www.britbike.com/forums/ubbthreads.php
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
PHPMyAdmin is not the command line.

Look at the list of databases in PHPMyAdmin, select any that're crashed, select repair at the bottom of the page. Or ask your host to do it.


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: Jun 2006
Posts: 987
Likes: 24
Old Hand
Old Hand
Joined: Jun 2006
Posts: 987
Likes: 24
Gizmo
I had open a ticket and it seems that the host fixed it they responded check your site now and it seems to work.
do you know what might have caused it?
Thanks for your reply


Morgan Johansson
BritBike Forum
https://www.britbike.com/forums/ubbthreads.php
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116


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: Jun 2006
Posts: 987
Likes: 24
Old Hand
Old Hand
Joined: Jun 2006
Posts: 987
Likes: 24
Thanks I will read it tomorrow I have one hour until my alarm clock goes on
cheers
Morgan


Morgan Johansson
BritBike Forum
https://www.britbike.com/forums/ubbthreads.php

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
1 members (Havenofsobriety), 458 guests, and 91 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)