Previous Thread
Next Thread
Print Thread
Hop To
#265722 10/02/2023 6:05 PM
Joined: Jun 2006
Posts: 319
Enthusiast
Enthusiast
Joined: Jun 2006
Posts: 319
Hi All,

Today I received this error message and don't know what to do any help would be appreciated.

Database error only visible to forum administrators

Joined: Jun 2006
Posts: 16,299
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,299
Likes: 116
To see the actual error message you'll need to look at the UBB.threads error log or set the following to "1" in libs/mysqli.inc.php in order to read the error to the browser

Code
$showerror = 0;


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: 319
Enthusiast
Enthusiast
Joined: Jun 2006
Posts: 319
Originally Posted by Gizmo
You'll need to look at the UBB.threads error log or set the following to "1" in libs/mysqli.inc.php in order to read the error to the browser

Code
$showerror = 0;

Have not updated to the latest database and this is the error showing.

[02-Oct-2023 06:37:10 America/Los_Angeles] PHP Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/xxxxxx/public_html/ubb.sitemap.php on line 234

Joined: Jun 2006
Posts: 16,299
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,299
Likes: 116
It would appear that someone updated your PHP build to PHP7 and you're on an unsupported build (v7.7.x supports PHP7, nothing currently supports PHP8 until we finish the final testing on our core assets).


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: 319
Enthusiast
Enthusiast
Joined: Jun 2006
Posts: 319
Error message that I am getting after changing the file is
Script: /home/xxxx/public_html/forum/libs/html.inc.php
Line: 433
SQL Error: The table 'ubbt_ONLINE' is full
SQL Error: 1114
REPLACE INTO
ubbt_ONLINE
(USER_ID, ONLINE_DISPLAY_NAME, ONLINE_LAST_ACTIVITY, ONLINE_SCRIPT_NAME, ONLINE_BROWSING_FORUM, ONLINE_USER_TYPE, ONLINE_USER_IP, ONLINE_REFERER, ONLINE_AGENT, ONLINE_POST_ID, ONLINE_POST_SUBJECT)
VALUES
(1, '-ANON-45.125.247.117', 1696286388, 'portal', '', 'a', '45.125.247.117', '', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36', 0, '')

Last edited by Outdoorking; 10/02/2023 6:42 PM.
Joined: Jun 2006
Posts: 16,299
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,299
Likes: 116
Code
Script: /home/outdoork/public_html/forum/libs/html.inc.php
Line: 433
SQL Error: The table 'ubbt_ONLINE' is full
SQL Error: 1114

You'll need to truncate the ubbt_ONLINE table (remove all data) to proceed; there is some information here about configuring it to write to disk vs memory which would stop the error from happening again on large forums.


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: 319
Enthusiast
Enthusiast
Joined: Jun 2006
Posts: 319
Hi Gizmo,

So I just tick all the files ( in the in that file) phpMyadmin and delete them all.

Is that correct because I have never done this before and don't want to kill the database

Joined: Jun 2006
Posts: 16,299
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,299
Likes: 116
While viewing the ubbt_ONLINE table you would click the "operations" tab and then "Empty the table (TRUNCATE)" link at the bottom of the PHPMyAdmin page in the "Delete data or table" section.
Attachments
screenshot-myadmin.virtualnightclub.net-2023.10.02-16_13_49.png


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: 319
Enthusiast
Enthusiast
Joined: Jun 2006
Posts: 319
Originally Posted by Gizmo
While viewing the ubbt_ONLINE table you would click the "operations" tab and then "Empty the table (TRUNCATE)" link at the bottom of the PHPMyAdmin page in the "Delete data or table" section.

Thank you for being so patient with me with the issue.

I have done what you have said, and now the forum is back up and running again.

Joined: Jun 2006
Posts: 16,299
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,299
Likes: 116
I'm glad to hear you're all up and running again smile. Not a problem, I didn't want to leave you guys under water.


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!

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Bots
by Outdoorking - 04/13/2024 5:08 PM
Can you add html to language files?
by Baldeagle - 04/07/2024 2:41 PM
Do I need to rebuild my database?
by Baldeagle - 04/07/2024 2:58 AM
This is not a bug, but a suggestion
by Baldeagle - 04/05/2024 11:25 PM
Is UBB.threads still going?
by Aaron101 - 04/01/2022 8:18 AM
Who's Online Now
2 members (Napalm, 1 invisible), 867 guests, and 189 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)