Previous Thread
Next Thread
Print Thread
Hop To
MySQL error on delete post
#181036 03/20/2007 3:42 AM
Joined: Jun 2006
Posts: 136
Okusi Offline OP
member
OP Offline
member
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
Re: MySQL error on delete post
Okusi #181070 03/20/2007 11:26 AM
Joined: Jun 2006
Posts: 9,243
Former Developer
Offline
Former Developer
Joined: Jun 2006
Posts: 9,243
It looks like the posts table has some index corruption. I'd close the forums and repair the table. REPAIR ubbt_POSTS

Re: MySQL error on delete post
Rick #181178 03/20/2007 8:50 PM
Joined: Jun 2006
Posts: 136
Okusi Offline OP
member
OP Offline
member
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
Re: MySQL error on delete post
Okusi #181376 03/22/2007 8:03 PM
Joined: Jun 2006
Posts: 136
Okusi Offline OP
member
OP Offline
member
Joined: Jun 2006
Posts: 136
.


Okusi Associates -- Indonesian business and management services

Link Copied to Clipboard
ShoutChat Box
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
allow photos to a PM?
by Morgan - 04/03/2020 4:24 PM
SFS Login Detection Issue [NotABug]
by Ruben - 03/29/2020 1:16 PM
possible bug?
by Morgan - 03/29/2020 5:18 AM
Who's Online Now
1 members (1 invisible), 69 guests, and 39 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Amusing Terain Scenics
Amusing Terain Scenics
by isaac, August 19
Sky places
Sky places
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 7.7.4