Portal Forums Calendar Active Threads
Previous Thread
Next Thread
Print Thread
Hop To
Edit a post, error message
#223879 03/10/2009 10:19 AM
Joined: Jan 2008
Posts: 222
Netherlands - Valkenswaard
Robje01
Offline
enthusiast
Robje01
enthusiast
Offline
Joined: Jan 2008
Posts: 222
Netherlands - Valkenswaard
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
Re: Edit a post, error message
Robje01 #223880 03/10/2009 10:24 AM
Joined: Jan 2008
Posts: 222
Netherlands - Valkenswaard
Robje01
Offline
enthusiast
Robje01
enthusiast
Offline
Joined: Jan 2008
Posts: 222
Netherlands - Valkenswaard
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
Re: Edit a post, error message
Robje01 #223881 03/10/2009 10:29 AM
Joined: Mar 2008
Posts: 327
Las Vegas, NV
D
DLWebmaestro Offline
Enthusiast
DLWebmaestro
Enthusiast
D Offline
Joined: Mar 2008
Posts: 327
Las Vegas, NV
Run this:
SQL Query
repair table ubbt_POSTS
Re: Edit a post, error message
DLWebmaestro #223882 03/10/2009 10:36 AM
Joined: Mar 2008
Posts: 327
Las Vegas, NV
D
DLWebmaestro Offline
Enthusiast
DLWebmaestro
Enthusiast
D Offline
Joined: Mar 2008
Posts: 327
Las Vegas, NV
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.
Re: Edit a post, error message
DLWebmaestro #223895 03/10/2009 2:43 PM
Joined: Jul 2006
Posts: 4,057
Liverpool : England : UK
Mark S Offline
Mark S
Offline
Joined: Jul 2006
Posts: 4,057
Liverpool : England : UK
what do they do that php admin cant ?

curious ?

BOOM !! Version v7.6.1.1
People who inspire me Isaac ME Gizmo
Re: Edit a post, error message
Mark S #223918 03/10/2009 11:34 PM
Joined: Mar 2008
Posts: 327
Las Vegas, NV
D
DLWebmaestro Offline
Enthusiast
DLWebmaestro
Enthusiast
D Offline
Joined: Mar 2008
Posts: 327
Las Vegas, NV
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.
Re: Edit a post, error message
DLWebmaestro #223926 03/11/2009 6:45 AM
Joined: Jan 2008
Posts: 222
Netherlands - Valkenswaard
Robje01
Offline
enthusiast
Robje01
enthusiast
Offline
Joined: Jan 2008
Posts: 222
Netherlands - Valkenswaard
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
PHP 8 bug in membermanage.tmpl
by phoenix011235 - 09/08/2026 7:47 PM
Are any of these legitmate?
by Baldeagle - 09/06/2026 1:37 PM
After server reboot
by Morgan - 09/02/2026 8:27 AM
Email Settings
by Outdoorking - 05/13/2026 2:44 AM
Who's Online Now
1 members (Havenofsobriety), 176 guests, and 163 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Ride safe!
Ride safe!
by Morgan, December 7
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Forum Rules · Mark All Read Contact Us · Forum Help · UBBCentral
Powered by UBB.threads™ PHP Forum Software 8.1.0
(Snapshot build 20260527)