Broken (and neglected) TXP install - need help to fix it up

Qwest · 2012-01-09 14:30:57

Afternoon all.

I built a site for a client about 6 years ago, originally built on txp 4.0.4 and it worked a charm. Over the years, I’ve upgraded it a few times at the client request but yesterday, I received a text from the client asking if I could check it out as the site appears to be down.

Sure enough, it’s not working and appears to have been down for a month or so. The error message (I neglected to copy it) but gave an error

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in (absolute path)/txplib_misc.php at line 180.

Line 180 was simply if (mysql_num_rows($rs)) break; or something like that. That was from memory.

Thinking that the host had done something, I upgraded Textpattern to the latest 4.4.1 but alas, I’m still not getting anywhere.

I’ve now got the following errors:

Warning: Table ‘eliteproductions.tp404_textpattern’ doesn’t exist describe `tp404_textpattern` in /websites/123reg/LinuxPackage21/el/it/ep/eliteproductions.co.uk/public_html/textpattern/lib/txplib_db.php on line 89

Warning: Cannot modify header information – headers already sent by (output started at /websites/123reg/LinuxPackage21/el/it/ep/eliteproductions.co.uk/public_html/textpattern/lib/txplib_db.php:89) in /websites/123reg/LinuxPackage21/el/it/ep/eliteproductions.co.uk/public_html/textpattern/lib/txplib_misc.php on line 1943

Warning: Table ‘eliteproductions.tp404_txp_page’ doesn’t exist select user_html from tp404_txp_page as txp_page where name=‘error_503’ in /websites/123reg/LinuxPackage21/el/it/ep/eliteproductions.co.uk/public_html/textpattern/lib/txplib_db.php on line 89

Warning: Table ‘eliteproductions.tp404_txp_page’ doesn’t exist select user_html from tp404_txp_page as txp_page where name=‘error_default’ in /websites/123reg/LinuxPackage21/el/it/ep/eliteproductions.co.uk/public_html/textpattern/lib/txplib_db.php on line 89

Warning: Cannot modify header information – headers already sent by (output started at /websites/123reg/LinuxPackage21/el/it/ep/eliteproductions.co.uk/public_html/textpattern/lib/txplib_db.php:89) in /websites/123reg/LinuxPackage21/el/it/ep/eliteproductions.co.uk/public_html/textpattern/lib/txplib_misc.php on line 2011

DB-Connect was successful, but the textpattern-table was not found.

So I’m kinda hoping someone can point me in the right direction. I don’t fancy doing a complete rebuild :)

Many thanks,

Qwest · 2012-01-09 14:34:25

I’ve just tried running http://eliteproductions.co.uk/textpattern/update/update.php << obviously the URL i’m working on…

This produces the same error from the first time round.

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /websites/123reg/LinuxPackage21/el/it/ep/eliteproductions.co.uk/public_html/textpattern/lib/txplib_misc.php on line 215

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /websites/123reg/LinuxPackage21/el/it/ep/eliteproductions.co.uk/public_html/textpattern/lib/txplib_misc.php on line 215

Unknown section

line 215 is if (mysql_num_rows($rs)) break; and the function it’s part of relates to loading languages (load_lang($lang))

wet · 2012-01-09 15:05:44

Looks like the database is broken. Can you try to check and repair the db tables from phpMyAdmin or any other MySQL client?

Dragondz · 2012-01-09 15:25:57

Had a same message for all my website till i update an article, making a repare table on textpattern table solved the problem (i am on hostgator), but i dont know what changed on textpattern or hosting that make that happen, what is curious is that it happen only once per domaine!!

Qwest · 2012-01-09 18:58:53

Wet, thanks for the idea.

My clients host (supanames / 123-reg) aren’t very good when it comes to their hosting and they use their own flavour of phpMyAdmin complete with less control and less options.

I don’t get an option to check OR repair the db tables but I do get the option to run SQL from the entry box. Any ideas how I’d go about checking and or repairing the tables?

Speaking of which, didn’t the db structure / naming change with 4.3 or 4.4? I’ve not had the chance to do that yet so could that be giving the symptom that the database is broken?!

Dragondz, I’ll give that a go once I can repair the db tables.

MattD · 2012-01-09 22:33:26

Qwest wrote:

Any ideas how I’d go about checking and or repairing the tables?

REPAIR TABLE

lazlo · 2012-01-10 04:27:45

rss_admin_db_manager is an indispensable plugin gives you the ability to repair DB directly from the extension tab.

Qwest · 2012-01-10 15:41:31

MattD, thanks, I’ve gone through & repaired the tables in the database, but no joy – it’s still showing me the error.

http://eliteproductions.co.uk

lazlo, thanks for the recommendation but I can’t actually get into Txp in order to activate said plugin :(

philwareham · 2012-01-10 16:19:07

Since I know you use a Mac, can you successfully connect to the mySQL database using an app such as Sequel Pro?

MattD · 2012-01-10 17:40:21

Does the table exist?

Warning: Table 'eliteproductions.tp404_textpattern' doesn't exist describe `tp404_textpattern`

Qwest · 2012-01-10 18:18:30

Hi MattD, yes, the db is called eliteproductions and tp404_textpattern does exist (screenie) – could there be an issue with one of the rows within tp404_textpattern?

Phil, I do indeed use a mac but unfortunately, client host doesn’t allow remote connections.

Dragondz · 2012-01-10 19:33:22

Hi

have you tryed reparing the table called “textpattern” ?

Textpattern CMS

Textpattern CMS support forum

#1 2012-01-09 14:30:57

Broken (and neglected) TXP install - need help to fix it up

#2 2012-01-09 14:34:25

Re: Broken (and neglected) TXP install - need help to fix it up

#3 2012-01-09 15:05:44

Re: Broken (and neglected) TXP install - need help to fix it up

#4 2012-01-09 15:25:57

Re: Broken (and neglected) TXP install - need help to fix it up

#5 2012-01-09 18:58:53

Re: Broken (and neglected) TXP install - need help to fix it up

#6 2012-01-09 22:33:26

Re: Broken (and neglected) TXP install - need help to fix it up

#7 2012-01-10 04:27:45

Re: Broken (and neglected) TXP install - need help to fix it up

#8 2012-01-10 15:41:31

Re: Broken (and neglected) TXP install - need help to fix it up

#9 2012-01-10 16:19:07

Re: Broken (and neglected) TXP install - need help to fix it up

#10 2012-01-10 17:40:21

Re: Broken (and neglected) TXP install - need help to fix it up

#11 2012-01-10 18:18:30

Re: Broken (and neglected) TXP install - need help to fix it up

#12 2012-01-10 19:33:22

Re: Broken (and neglected) TXP install - need help to fix it up

Board footer