Site Links
Pricing & Order
Members Area
Support Options
Who's Online Now
2 registered members (isaac, Gizmo), 85 guests, and 291 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
Burlington, VT
Posts: 115
Joined: June 2006
Show All Member Profiles 
Top Posters(30 Days)
Gizmo 23
Morgan 12
Ruben 8
SteveS 6
isaac 5
Latest Photos
Testing to drag photos
Comfortable Cats
BSA photos
Previous Thread
Next Thread
Print Thread
The table 'ubbt_topic_views' is full #261803
11/01/18 07:12 PM
11/01/18 07:12 PM
Metamatic  Offline OP
Joined: Jan 2010
Posts: 4
I've been running a UBB Bulletin Board for years without any issue - and I've just been confronted with the following error message...

Line#: 417
SQL Error: The table 'ubbt_topic_views' is full
SQL Error #: 1114
Query: insert into ubbt_TOPIC_VIEWS (TOPIC_ID) values ( 2834 )

The version I'm running is 7.5.6p1. Can anyone please suggest what I need to do in order to resolve this?

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."
Re: The table 'ubbt_topic_views' is full [Re: Metamatic] #261804
11/01/18 07:52 PM
11/01/18 07:52 PM
Gizmo  Online Tapedshut
UBB.threads Developer
Joined: Jun 2006
Posts: 17,002
Portland, OR; USA
This error was fixed in v7.6.0; basically the memory/heap table gets full and isn't purged unless a new post is made; sites with little activity will see the tables getting full.

The initial solution was to purge and recreate the table (see this post from 2007).

The fix was to add the trigger to the login page, which results in the cache purge occurring every time the login page is accessed (versus just when a post is made):
Open /scripts/ and Find:

Add Below:
 // TRIGGER: Update the views

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.
Need to Upgrade?
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!
Re: The table 'ubbt_topic_views' is full [Re: Gizmo] #261817
11/11/18 09:25 AM
11/11/18 09:25 AM
Metamatic  Offline OP
Joined: Jan 2010
Posts: 4
Please accept my apologies for not replying sooner...

Your fix worked a treat - I'm very grateful... :-)

Shout Box
Today's Birthdays
No Birthdays
Recent Topics
Reddy Kilowatt
by SteveS. 11/20/18 08:30 AM
by Morgan. 11/18/18 02:33 PM
Phishing SCAM emails
by Morgan. 11/16/18 01:28 PM
Repliers can change thread title
by Baldeagle. 11/12/18 08:49 PM
Tabs In Header
by AstroCat. 11/11/18 08:33 AM
Forum Statistics
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.6.2