Desperate database issue

carrotrope · 2009-08-29 09:39:03

Hi,

Very worried here. I was in the process of upgrading to 4.2.0 and accidentally overwrote the old config.php file. It’s been a long time since I dealt with the MySQL side of things on this host, so had completely forgotten the details, and tried a fresh install, just so it would spit out the correct elements in the new config.php. Now I’m getting this – www.zeegen.com and this – www.zeegen.com/textpattern

Have I overwritten the database? Have I completely wiped all the previous information that was there? (pages, sections, CSS, etc..) is there any way this has a happy ending?

Thanks!
Jez

els · 2009-08-29 11:12:14

I don’t think it’s possible to overwrite the database this way. Do you have access to it through phpMyAdmin? You can check the database name and the table prefix (if any) there.

carrotrope · 2009-08-29 11:14:22

I do, and all the database details now in config.php are correct, but yet I still get all those errors and have no idea how to rectify them and get Textpattern working again…

jstubbs · 2009-08-29 11:18:02

Installing 4.2.0 via FTP isn’t going to change or affect your DB, so I would suggest you start by checking you have all the files in place – try overwriting all the files again and take particular care to follow the instructions.

Then I would check the contents of the database you used before upgrading – are the contents still in that db?

carrotrope · 2009-08-29 11:32:02

Hi,

So I’ve uploaded all the 4.2.0 files as detailed in the Upgrading section of the readme file and I’m still getting the exact same errors. On the front page:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/home/zeegenc1/textpattern/lib/txplib_misc.php on line 180

Unknown section

And when I try to access the admin section:

Warning: Table ‘DB13241219.txp_textpattern’ doesn’t exist describe `txp_textpattern` in /var/www/home/zeegenc1/textpattern/lib/txplib_db.php on line 85

Warning: Cannot modify header information – headers already sent by (output started at /var/www/home/zeegenc1/textpattern/lib/txplib_db.php:85) in /var/www/home/zeegenc1/textpattern/lib/txplib_misc.php on line 1823

Warning: Table ‘DB13241219.txp_txp_page’ doesn’t exist select user_html from txp_txp_page as txp_page where name=‘error_503’ in /var/www/home/zeegenc1/textpattern/lib/txplib_db.php on line 85

Warning: Table ‘DB13241219.txp_txp_page’ doesn’t exist select user_html from txp_txp_page as txp_page where name=‘error_default’ in /var/www/home/zeegenc1/textpattern/lib/txplib_db.php on line 85

Warning: Cannot modify header information – headers already sent by (output started at /var/www/home/zeegenc1/textpattern/lib/txplib_db.php:85) in /var/www/home/zeegenc1/textpattern/lib/txplib_misc.php on line 1887

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

I have looked in phpMyAdmin and all the content seems to be there…
Jez

jstubbs · 2009-08-29 11:36:00

Is this DB13241219 the same DB that you had before, or the one you used for the fresh install?

carrotrope · 2009-08-29 11:37:35

The same DB.

jstubbs · 2009-08-29 11:39:00

Try repairing it via phpMyAdmin.

carrotrope · 2009-08-29 11:42:03

Repaired everything, still no change.

els · 2009-08-29 11:46:52

Do your tables actually have the prefix txp_?

Last edited by els (2009-08-29 11:47:20)

jstubbs · 2009-08-29 11:48:16

Can you post the contents of your config.php file? Just take out the password and username :-)

carrotrope · 2009-08-29 11:50:51

Els – yep! Everything but the ‘textpattern’ table has the txp_ prefix (which is the same on all my other installations of Textpattern).

Jonathan – sure! Here it is:

<?php
$txpcfg[‘db’] = ‘DB13241219’;
$txpcfg[‘user’] = ‘**********’;
$txpcfg[‘pass’] = ‘**********’;
$txpcfg[‘host’] = ’213.188.134.182’;
$txpcfg[‘table_prefix’] = ‘txp_’;
$txpcfg[‘txpath’] = ‘/var/www/home/zeegenc1/textpattern’;
$txpcfg[‘dbcharset’] = ‘latin1’;
?>

Textpattern CMS

Textpattern CMS support forum

#1 2009-08-29 09:39:03

Desperate database issue

#2 2009-08-29 11:12:14

Re: Desperate database issue

#3 2009-08-29 11:14:22

Re: Desperate database issue

#4 2009-08-29 11:18:02

Re: Desperate database issue

#5 2009-08-29 11:32:02

Re: Desperate database issue

#6 2009-08-29 11:36:00

Re: Desperate database issue

#7 2009-08-29 11:37:35

Re: Desperate database issue

#8 2009-08-29 11:39:00

Re: Desperate database issue

#9 2009-08-29 11:42:03

Re: Desperate database issue

#10 2009-08-29 11:46:52

Re: Desperate database issue

#11 2009-08-29 11:48:16

Re: Desperate database issue

#12 2009-08-29 11:50:51

Re: Desperate database issue

Board footer