Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online Now
2 registered members (isaac, Gizmo), 74 guests, and 159 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
Posts: 125
Joined: June 2011
Show All Member Profiles 
Top Posters(30 Days)
isaac 28
Gizmo 14
Zarzal 12
DennyP 12
Ruben 11
Morgan 10
SteveS 7
JAISP 4
Slaz 1
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 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: 15,720
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... :-)


ShoutChat Box
Today's Birthdays
NewZealandNZ
Recent Topics
Gallery link in editor
by Zarzal. 01/18/19 06:54 PM
Lack of memory - change PHP version ???
by Morgan. 01/16/19 04:10 PM
[7.6.2] English
by isaac. 01/13/19 11:31 AM
[7.6.1] English
by isaac. 01/13/19 11:31 AM
7.6.2 file attachment cleanup
by Zarzal. 01/09/19 07:29 AM
Forum Statistics
Forums35
Topics35,199
Posts191,808
Members12,131
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.7.0
(Preview build 20190118)