Previous Thread
Next Thread
Print Thread
Hop To
#248511 02/25/2012 3:02 PM
Joined: Mar 2008
Posts: 262
enthusiast
enthusiast
Joined: Mar 2008
Posts: 262
I am messing around on my testing site and tried clearing cache and get the error below
Code
Script: /home/fgmcccom/public_html/testing/ubbthreads/cache_builders/post_island.php
Line#: 84
SQL Error: Table 'fgmcccom_pptest.ubbt_TOPICS' doesn't exist
SQL Error #: 1146
Query: select t1.TOPIC_ID,t1.POST_ID,t1.TOPIC_SUBJECT,t1.TOPIC_CREATED_TIME,t1.TOPIC_LAST_REPLY_TIME,t1.TOPIC_LAST_POST_ID,t1.TOPIC_LAST_POSTER_ID,t1.TOPIC_LAST_POSTER_NAME,t1.TOPIC_POSTER_NAME from ubbt_TOPICS as t1, ubbt_FORUMS as t2 where t2.FORUM_IS_GALLERY='0' and t1.FORUM_ID = t2.FORUM_ID and t1.TOPIC_IS_APPROVED = '1' and t1.TOPIC_LAST_REPLY_TIME > 1327622046 and t1.TOPIC_STATUS <> 'M' and t1.FORUM_ID in ('1','2') ORDER BY t1.TOPIC_LAST_REPLY_TIME desc limit 5 


Ian
http://www.firstgenmc.com/ubbthreads

"Experience is a hard teacher because she gives the test first, the lesson afterwords."
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
The MySQL Database fgmcccom_pptest is missing the table ubbt_TOPICS


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: Mar 2008
Posts: 262
enthusiast
enthusiast
Joined: Mar 2008
Posts: 262
Hmm it does not have any ubbt_ tables, I think it is trying to read both the PhotoPost and UBB databases... Why would post_island.php be doing that?


Ian
http://www.firstgenmc.com/ubbthreads

"Experience is a hard teacher because she gives the test first, the lesson afterwords."
Joined: Mar 2008
Posts: 262
enthusiast
enthusiast
Joined: Mar 2008
Posts: 262
I deleted a gallery forum today, and under Control Panel » Gallery Islands I have a Island with a blank source (not undefined) How can I get rid of it?


Ian
http://www.firstgenmc.com/ubbthreads

"Experience is a hard teacher because she gives the test first, the lesson afterwords."
Joined: Mar 2008
Posts: 262
enthusiast
enthusiast
Joined: Mar 2008
Posts: 262
Anyone?

Thanks!


Ian
http://www.firstgenmc.com/ubbthreads

"Experience is a hard teacher because she gives the test first, the lesson afterwords."
Joined: Jun 2006
Posts: 869
old hand
old hand
Joined: Jun 2006
Posts: 869
my members are getting these as well.

Both are cache problems..
Quote
UBB Message We encountered a problem. The reason reported was
Script: /home/clubadve/public_html/forum/cache_builders/popular_topics.php
Line#: 57
SQL Error: Error writing file '/tmp/MYsvs7Gw' (Errcode: 28)
SQL Error #: 3
Query: SELECT t.TOPIC_SUBJECT, t.TOPIC_VIEWS, t.POST_ID FROM ubbt_TOPICS t, ubbt_POSTS p, ubbt_FORUMS f, ubbt_USERS u WHERE t.FORUM_ID = f.FORUM_ID AND t.TOPIC_IS_APPROVED = 1 AND t.TOPIC_LAST_POST_ID = p.POST_ID AND t.TOPIC_LAST_POSTER_ID = u.USER_ID ORDER BY t.TOPIC_VIEWS DESC LIMIT 10


http://clubadventist.com/forums

No longer following the carrot

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
3 members (rootman, Gizmo, Nightcrawler), 562 guests, and 186 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)