Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online Now
2 registered members (isaac, Gizmo), 85 guests, and 291 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
usrbingeek
usrbingeek
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
JAISP 2
Latest Photos
Test
Testing to drag photos
Comfortable Cats
Test
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
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
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/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 09:25 AM
11/11/18 09: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... :-)


Shout Box
Today's Birthdays
No Birthdays
Recent Topics
Reddy Kilowatt
by SteveS. 11/20/18 08:30 AM
testar
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
Forums36
Topics35,168
Posts191,613
Members12,114
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.6.2