Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Pages: 1
#1 2006-09-11 21:30:47
- kevinpotts
- Member
- From: Ghost Coast
- Registered: 2004-12-07
- Posts: 370
Very Serious MySQL problem
OK, here we go …
1. Have a TXP install running on Windows machine. It is version 4.0.1
2. Suddenly the whole site crashes and dies.
3. When I try to log in to TXP, I get the following error: “DB-Connect was succesful, but the textpattern-table was not found.”
4. Holy shit.
5. So I can’t login, so I can’t use Rob’s wonderful DB admin plugin, so I can’t repair the table.
6. I download and install MySQL Administrator
7. I successfully login to the DB and run repair commands across every table.
8. Except the table “textpattern” has a null name. For instance, a typical command for the table “txp_category” might look like this:
SELECT * FROM `rpmtxp`.`txp_category`
But the table for "textpattern" looks like this:
SELECT * FROM `rpmtxp`.``
9. As you can imagine, MySQL Administrator can neither read the contents of this table, rename it or repair it. When I run the repair command, I get the following:
<code>
Error – Table `rpmtxp`.`` could not be repaired.
MySQL Error Nr.1103
Incorrect table name ‘’
</code>
Please help. This is a client site and they are pissed.
Kevin
(graphicpush)
Offline
Re: Very Serious MySQL problem
perhaps a stupid idea: stop mysql server, rename the table in the filesystem from its current name to txp_category (not throught mysql or an administrator tool), restart mysql server.
Offline
Re: Very Serious MySQL problem
Not a direct help, I’m afraid, but maybe your host has recent backups. It’s certainly worth asking.
TXP Builders – finely-crafted code, design and txp
Offline
#4 2006-09-11 23:44:02
- zem
- Developer Emeritus
- From: Melbourne, Australia
- Registered: 2004-04-08
- Posts: 2,579
Re: Very Serious MySQL problem
Yes, sounds like you need to restore a backup. See also this FAQ.
Alex
Offline
#5 2006-09-12 00:54:36
- kevinpotts
- Member
- From: Ghost Coast
- Registered: 2004-12-07
- Posts: 370
Re: Very Serious MySQL problem
OK, some further clarification … I tried restoring the DB. The host only keeps records back 14 days. The corruption happened before then, because the first thing I tried was restoring from the last date. No worky.
Ruud, I can not simply rename the table because it is asking for me to add a field, and I don’t want to overwrite the old data. The primary goal of the surgery is recovery at this point. If I have to rebuild the TXP install, I will, but right now, I need to just get access to the data.
If some MySQL/PHP genius is willing to trade services, I will be happy to provide design time for whatever it takes to help me get this fixed. Time is of the essence.
Kevin
(graphicpush)
Offline
Re: Very Serious MySQL problem
If it’s an illegal table name, you probably can’t do anything from the Mysql/PHP point of view.
Tables generally don’t ask to add a field. Applications do… what application does?
If you have access to the directory on the server where the tables are physically stored, does it show set of files (probably 3) which represent the textpattern table and do they have sizes that look healthy (not zero would be nice)?
Offline
#7 2006-09-12 07:01:41
- zem
- Developer Emeritus
- From: Melbourne, Australia
- Registered: 2004-04-08
- Posts: 2,579
Re: Very Serious MySQL problem
For a quick fix, your best bet is probably to start with the tech support people at your hosting company. If nothing else, they should have the necessary system access to work directly with MySQL. (Whether or not the data can be restored is another issue).
Alex
Offline
#8 2006-09-12 11:56:04
- kevinpotts
- Member
- From: Ghost Coast
- Registered: 2004-12-07
- Posts: 370
Re: Very Serious MySQL problem
OK, thanks for the response. Here’s a question in two parts …
1. Does the “textpattern” table refer to all the data in the TXP admin, or is it something else?
2. If it is just TXP admin data, and if I completely reinstall TXP with the same DB, will it overwrite whatever data is in the non-corrupt tables now, like txp_categories, txp_css, etc?
I also tried upgrading the install to TXP 4.0.3 and got this error instead:
<code>
Fatal error: Call to undefined function: parse() in d:\path\tosite\textpattern\lib\txplib_misc.php on line 1309
</code>
Not sure if that offers any clues.
Last edited by kevinpotts (2006-09-12 11:58:41)
Kevin
(graphicpush)
Offline
Re: Very Serious MySQL problem
kevinpotts wrote:
OK, thanks for the response. Here’s a question in two parts …
1. Does the “textpattern” table refer to all the data in the TXP admin, or is it something else?
2. If it is just TXP admin data, and if I completely reinstall TXP with the same DB, will it overwrite whatever data is in the non-corrupt tables now, like txp_categories, txp_css, etc?
I also tried upgrading the install to TXP 4.0.3 and got this error instead:
<code>
Fatal error: Call to undefined function: parse() in d:\path\tosite\textpattern\lib\txplib_misc.php on line 1309
</code>
Not sure if that offers any clues.
Can you make a dump of a maximum of tables, if the pb is just in textpattern table I think it s not dramatic! after a dump make an install of txp and then restore the tables using phpmyadmin!
Before trying wait for confirmation (Maybe by Zem) that this method is correct!
Good luck
Offline
Re: Very Serious MySQL problem
‘textpattern’ is the table that contains the articles. Probably the most important table of them all.
Offline
#11 2006-09-12 12:32:01
- kevinpotts
- Member
- From: Ghost Coast
- Registered: 2004-12-07
- Posts: 370
Re: Very Serious MySQL problem
That’s what I thought. Darn.
Kevin
(graphicpush)
Offline
Pages: 1