Previous Thread
Next Thread
Print Thread
Hop To
#223879 03/10/2009 10:19 AM
Joined: Jan 2008
Posts: 222
enthusiast
enthusiast
Joined: Jan 2008
Posts: 222
When i edit a post and remove some text i receive this error:

Quote
UBB Message
The following problem occurred:
Script: /data/vhosts/www.freesat.nl/forum/scripts/modifypost.inc.php
Line#: 391
SQL Error: Incorrect key file for table './vanden/ubbt_POSTS.MYI'; try to repair it
SQL Error #: 126
Query: update ubbt_POSTS set POST_SUBJECT = 'Re: Subject something' , POST_BODY = 'bladibladibladibla
and some more blabla

Some link i removed

Name / Alias' , POST_DEFAULT_BODY = 'bladibladibladibla
and some more blabla

Name / Alias.\r\n\r\nName / Alias', POST_ICON = 'book.gif' , POST_LAST_EDITED_TIME= 0 , POST_LAST_EDIT_REASON = '' , POST_LAST_EDITED_BY = 'My_Alias' , POST_ADD_SIGNATURE = 1 , POST_HAS_FILE = 0, POST_MARKUP_TYPE = 'markup' where POST_ID = 32378


What went wrong?

Rob


My place to be: http://www.freesat.nl
Joined: Jan 2008
Posts: 222
enthusiast
enthusiast
Joined: Jan 2008
Posts: 222
I repaired my database and now it works (again), but i had this several times this week.

Does anyone know how this could happen?

I wrote the downloads module but this one only reads from this table.

Rob


My place to be: http://www.freesat.nl
Joined: Mar 2008
Posts: 326
D
Enthusiast
Enthusiast
D Offline
Joined: Mar 2008
Posts: 326
Run this:
SQL Query
repair table ubbt_POSTS

Joined: Mar 2008
Posts: 326
D
Enthusiast
Enthusiast
D Offline
Joined: Mar 2008
Posts: 326
Oops, that's what I get for leaving to see a man about a horse before replying.

Two more things you can try are:

Telnet into your server and run
Code
mysqlcheck -r
Telnet into your server, stop MySQL, run
Code
myisamchk -r
, then start MySQL.

Joined: Jul 2006
Posts: 4,057
Joined: Jul 2006
Posts: 4,057
what do they do that php admin cant ?

curious ?


BOOM !! Version v7.6.1.1
People who inspire me Isaac ME Gizmo
Joined: Mar 2008
Posts: 326
D
Enthusiast
Enthusiast
D Offline
Joined: Mar 2008
Posts: 326
With those options, nothing AFAIK; I just like attacking problems from all different angles.

Are you able to restart MySQL? If so, give that a shot and see how things go.

If you can and do restart, and it is still happening, it would lead me to think it may be a hardware problem.

Joined: Jan 2008
Posts: 222
enthusiast
enthusiast
Joined: Jan 2008
Posts: 222
I'm running a cronjob now which checks if the database needs to be fixed, if so the myisamchk command runs...
So i don't need to stay home and check every minute smile

Thanks all


My place to be: http://www.freesat.nl

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Bots
by Outdoorking - 04/13/2024 5:08 PM
Can you add html to language files?
by Baldeagle - 04/07/2024 2:41 PM
Do I need to rebuild my database?
by Baldeagle - 04/07/2024 2:58 AM
This is not a bug, but a suggestion
by Baldeagle - 04/05/2024 11:25 PM
spam issues
by ECNet - 03/19/2024 11:45 PM
Who's Online Now
1 members (1 invisible), 875 guests, and 141 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)