Previous Thread
Next Thread
Print Thread
Hop To
#248511 02/25/2012 3:02 PM
Joined: Mar 2008
Posts: 262
Iann128 Offline OP
enthusiast
OP Offline
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,171
Likes: 101
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 16,171
Likes: 101
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
Iann128 Offline OP
enthusiast
OP Offline
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
Iann128 Offline OP
enthusiast
OP Offline
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
Iann128 Offline OP
enthusiast
OP Offline
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
Offline
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
RSS not working
by jsteinborn - 04/18/2022 2:46 PM
Largest UBB.threads forum
by Aaron101 - 04/06/2022 8:38 AM
News Block
by Aaron101 - 04/05/2022 6:48 PM
Who's Online Now
1 members (Morgan), 41 guests, and 63 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
gallery test
gallery test
by Mors, September 23
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Powered by UBB.threads™ PHP Forum Software 7.7.5