Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
#1 2008-03-28 19:02:30
- els
- Moderator
- From: The Netherlands
- Registered: 2004-06-06
- Posts: 7,458
what kind of activities could cause db table problems?
On one TXP site the textpattern table is frequently giving problems, sometimes the site displays without content or it does not display at all. So far repairing the textpattern table every time solved the problem.
The host mentioned a ‘blocked column’ (not sure if this is the right term, I’m translating from Spanish here), and a frequent occurrence of that might be caused by an overload on the table or a poorly constructed table.
Because of the suggested ‘overload’ I wonder if certain activities, like posting or editing very frequently, or posting large articles, could cause a malfunctioning table? The textpattern table has 79 records and is 660KB, that can’t be too much can it?
Would it help if we export the textpattern table data, drop the table in the database, create a new table manually and import the data again?
Last edited by els (2008-03-28 19:03:46)
Offline
Re: what kind of activities could cause db table problems?
What’s the spanish error message?
Offline
Re: what kind of activities could cause db table problems?
Gremlins? :P Your database might be corrupt physically, so I’d go through with your plan and backup and recreate. Truncate the logs table and optimize the database before you export too.
MySQL can store TBs, so that size shouldn’t be a problem.
Offline
#4 2008-03-28 21:32:17
- els
- Moderator
- From: The Netherlands
- Registered: 2004-06-06
- Posts: 7,458
Re: what kind of activities could cause db table problems?
ruud wrote:
What’s the spanish error message?
It’s not an error message, it’s the reply the user received from his host:
… tenia una columna bloqueada, cosa que le pasa frecuentemente, esto suele pasar si hay una sobrecarga sobre la tabla o esta esta mal construida, usted mismo puede desbloquearla utilizando la utilidad de reparar tablas de phpmyadmin.
And it’s not a site of mine, and I don’t have access to it. It might be better if the user himself would post here? Though I don’t really think it’s a TXP problem.
If all tables (structure and data) are exported, the db is deleted and re-created, and the tables are restored, will existing table issues be restored as well? Would it be better to only export the data and re-create the tables manually?
Offline
#5 2008-03-28 21:34:23
- els
- Moderator
- From: The Netherlands
- Registered: 2004-06-06
- Posts: 7,458
Re: what kind of activities could cause db table problems?
jm:
Couldn’t you write a plugin? jmd_kill_gremlins ;)
Offline
Re: what kind of activities could cause db table problems?
Ooh, found a FAQ
Offline
#7 2008-03-28 21:50:15
- els
- Moderator
- From: The Netherlands
- Registered: 2004-06-06
- Posts: 7,458
Re: what kind of activities could cause db table problems?
Yes, I know that FAQ. I’ll point it out to the user :) Thanks.
Offline
Re: what kind of activities could cause db table problems?
Els wrote:
jm:
Couldn’t you write a plugin? jmd_kill_gremlins ;)
class JMD_KillGremlins
{
// determine appropriate kill method based on time and location
public function __construct($time, $location)
{
}
private function sunlight()
{
}
private function microwave()
{
}
private function mixer()
{
}
private function decapitation($how)
{
}
}Off to rewatch Gremlins :D
Last edited by jm (2008-03-28 22:08:34)
Offline