Previous Thread
Next Thread
Print Thread
Hop To
Joined: Jan 2010
Posts: 9
M
Stranger
Stranger
M Offline
Joined: Jan 2010
Posts: 9
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?

Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
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.
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: Jan 2010
Posts: 9
M
Stranger
Stranger
M Offline
Joined: Jan 2010
Posts: 9
Please accept my apologies for not replying sooner...

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


Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
0 members (), 744 guests, and 147 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)