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

MattD · 2012-01-10 19:54:04

And your certain Textpattern is going to this same database right?
Are you connecting as the same user that Textpattern is?
Can you do DESC tp404_textpattern succesfully from your mysql client?

Throwing darts now sorry.

Edit: Looks likes there have been other occurances of this issue

Last edited by MattD (2012-01-10 19:56:10)

Qwest · 2012-01-10 21:14:27

Dragondz, yes, I’ve tried repairing textpattern, and that’s all OK.

MattD, the hosting only has one DB on it. Interestingly, when I go to eliteproductions.co.uk/textpattern, it gives me the following error:

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

Which, as it suggests, can’t find the textpattern DB – I know it’s there, I’m LOOKING AT IT!

I typed DESC tp404_textpattern which come back successful.

One thing I will mention, and I’m not sure it’s relevant… Every error message that appears shows me this absolute URL

/websites/123reg/ LinuxPackage21 /el/it/ep/eliteproductions.co.uk/public_html/textpattern/lib/txplib_db.php

however my config.php has LinuxPackage24 within the absolute URL. I’m wondering whether 123-reg / supanames have done something to change it (!) – but more importantly, where is it taking the 21 URL from when I’ve specied 24?

jakob · 2012-01-10 21:43:52

and you have the table prefix set up properly in your config.php, e.g. txpcfg['table_prefix'] = 'tp404_';?

Qwest · 2012-01-10 21:47:04

$txpcfg['table_prefix'] = 'tp404_';

Copied & pasted

Qwest · 2012-01-12 06:17:30

Anyone got any ideas on how to rectify this?

I went and renamed my config file and effectively went through the installation again to a different table in my db to see if it was a host issue or just a Txp issue but that installed fine (few errors once complete though?).

So it’d suggest that there’s something fundamentally wrong with my database correct?

Dragondz · 2012-01-12 08:32:56

Hard to say what s going wrong!

I think you must compare the two config.php files to see where is the différence and also compare each table to see if there is something different too!

MattD · 2012-01-12 18:18:33

What errors did you have on the new install?

Qwest · 2012-01-12 21:22:59

dragondz, config.php files are identical except for the table prefix.

The host (Supanames/123-reg fwiw), i think are having trouble – domain shows ‘Database Unavailable’ even when I try to log into my server control panel! Will check again in the morning.

Meanwhile, I ahve logged a support ticket to see if they have changed anything.

maruchan · 2012-01-13 01:07:39

I would definitely test this on a different host if they don’t come up with anything.

Qwest · 2012-01-17 13:41:20

So an update.

it turns out that 123-reg have taken over Supanames and are in the process of moving everyone over to 123-reg. This involved playing around with the database servers and as such, stuff got changed.

I should be back up & running tonight once I receive a MySQL backup and import it back into the new mysql database!

Thanks for all your help guys!

Textpattern CMS

Textpattern CMS support forum

#13 2012-01-10 19:54:04

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

#14 2012-01-10 21:14:27

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

#15 2012-01-10 21:43:52

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

#16 2012-01-10 21:47:04

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

#17 2012-01-12 06:17:30

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

#18 2012-01-12 08:32:56

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

#19 2012-01-12 18:18:33

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

#20 2012-01-12 21:22:59

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

#21 2012-01-13 01:07:39

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

#22 2012-01-17 13:41:20

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

Board footer