Previous Thread
Next Thread
Print Thread
Hop To
#181036 03/20/2007 3:42 AM
Joined: Jun 2006
Posts: 136
O
member
member
O Offline
Joined: Jun 2006
Posts: 136
i just saw this MySQL error on my system

Quote
Tue, Mar 20 2007 14:04:42 +0800
chewwyUK Script: /home/webadmin/jakchat.com/html/forums/scripts/doexpirethreads.inc.php - Line: 161
DELETE FROM ubbt_POSTS
WHERE TOPIC_ID = 2986
- Incorrect key file for table 'ubbt_POSTS'; try to repair it

apparently caused by someone trying to delete one of their own posts.

is this a problem?


Okusi Associates -- Indonesian business and management services
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
It looks like the posts table has some index corruption. I'd close the forums and repair the table. REPAIR ubbt_POSTS

Joined: Jun 2006
Posts: 136
O
member
member
O Offline
Joined: Jun 2006
Posts: 136
thanks, i'll give that a go. however, before i do, i've just cgot a new batch of error messages as follows:

Quote
Script: /home/webadmin/jakchat.com/html/forums/scripts/postlist.inc.php - Line: 706
select t1.TOPIC_ID,t1.POST_ID,t2.USER_DISPLAY_NAME,t1.TOPIC_CREATED_TIME,t1.TOPIC_LAST_REPLY_TIME,t1.TOPIC_SUBJECT,
t1.TOPIC_STATUS,t1.TOPIC_IS_APPROVED,t1.TOPIC_ICON,t1.TOPIC_VIEWS,t1.TOPIC_REPLIES,t1.TOPIC_TOTAL_RATES,
t1.TOPIC_RATING,t3.USER_NAME_COLOR,t2.USER_MEMBERSHIP_LEVEL,t1.USER_ID,t1.TOPIC_IS_STICKY,t1.TOPIC_LAST_POSTER_ID,
t1.TOPIC_LAST_POSTER_NAME,t1.TOPIC_LAST_POST_ID,t1.TOPIC_IS_EVENT,t1.TOPIC_HAS_FILE,t1.TOPIC_HAS_POLL
from ubbt_TOPICS as t1
left join ubbt_USERS as t2 on t1.USER_ID = t2.USER_ID
left join ubbt_USER_PROFILE as t3 on t1.USER_ID = t3.USER_ID
where t1.FORUM_ID = 3
and t1.TOPIC_IS_STICKY = '0'

AND t1.TOPIC_IS_APPROVED = '1'
ORDER BY t1.TOPIC_LAST_REPLY_TIME desc
LIMIT -25, 26
- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-25, 26' at line 13



Okusi Associates -- Indonesian business and management services
Joined: Jun 2006
Posts: 136
O
member
member
O Offline
Joined: Jun 2006
Posts: 136
.


Okusi Associates -- Indonesian business and management services

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 (), 396 guests, and 110 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)