Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online Now
3 registered members (DLWebmaestro, Ruben, M4TT), 57 guests, and 253 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
Crasher
Crasher
Midlands, UK
Posts: 136
Joined: July 2005
Show All Member Profiles 
Top Posters(30 Days)
isaac 44
M4TT 26
Ruben 24
Gizmo 23
Morgan 13
Jake 4
Latest Photos
Big stuff
Test
Testing to drag photos
Comfortable Cats
Test
Previous Thread
Next Thread
Print Thread
The table 'ubbt_topic_views' is full #261803
11/01/18 08:12 PM
11/01/18 08:12 PM
M
Metamatic  Offline OP
Stranger
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
Re: The table 'ubbt_topic_views' is full [Re: Metamatic] #261804
11/01/18 08:52 PM
11/01/18 08:52 PM
Gizmo  Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 15,808
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/login.inc.php and Find:
Code
trigger_subscriptions();

Add Below:
Code
 // TRIGGER: Update the views
    update_views_counter();


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 10:25 AM
11/11/18 10:25 AM
M
Metamatic  Offline OP
Stranger
Joined: Jan 2010
Posts: 4
Please accept my apologies for not replying sooner...

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


ShoutChat Box
Today's Birthdays
No Birthdays
Recent Topics
Can i go from 7.6.0 to 7.7.1 directly?
by Crasher - 03/21/19 12:15 PM
Follow Thread Button Not Aligned
by M4TT - 03/16/19 09:24 PM
Author Content Portrait Avatars
by M4TT - 03/16/19 09:12 PM
problem with ubbthreads dark scheme
by TheBrit - 03/15/19 04:17 PM
7.7.1 Forums and Categories
by AstroCat - 03/15/19 08:16 AM
Forum Statistics
Forums35
Topics35,260
Posts192,302
Members12,143
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.7.2
(Snapshot build 20190227)