Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#1 2013-06-06 11:27:07

dorka
Member
Registered: 2012-10-04
Posts: 90

error after moving to new host

Hi there,
I get this error instead of homepage:

internal_error “Table ‘d31332_salon.textpattern’ doesn’t exist”
in /data/web/virtuals/31332/virtual/www/textpattern/lib/txplib_db.php at line 95
internal_error “Cannot modify header information – headers already sent by (output started at /data/web/virtuals/31332/virtual/www/textpattern/lib/txplib_misc.php:709)”
in /data/web/virtuals/31332/virtual/www/textpattern/lib/txplib_misc.php at line 2235
internal_error “Cannot modify header information – headers already sent by (output started at /data/web/virtuals/31332/virtual/www/textpattern/lib/txplib_misc.php:709)”
in /data/web/virtuals/31332/virtual/www/textpattern/lib/txplib_misc.php at line 2306
DB-Connect was successful, but the textpattern-table was not found.

I checked the topics here and made sure I have transferred the .htaccess file as advised in one of the topics here, I also checked my config.php file and I don’t see any problem there:

<?php
$txpcfg[‘db’] = ‘xxxx’;
$txpcfg[‘user’] = ‘xxxx’;
$txpcfg[‘pass’] = ‘xxxx’;
$txpcfg[‘host’] = ‘xxxx’;
$txpcfg[‘table_prefix’] = ‘’;
$txpcfg[‘txpath’] = ‘/data/web/xxxxxx/www/textpattern’;
$txpcfg[‘dbcharset’] = ‘utf8’;
?>

I also replaced the content of the lib directory by fresh one from the latest release of txp installation file. Nop!

Help me please!

Last edited by dorka (2013-06-06 11:33:45)

Offline

#2 2013-06-06 11:32:16

philwareham
Core designer
From: Haslemere, Surrey, UK
Registered: 2009-06-11
Posts: 3,564
Website GitHub Mastodon

Re: error after moving to new host

Slightly off-topic: please remove the config.php details from your previous post, you don’t want other people accessing your database (config.php file looks fine by the way, so that’s not the problem).

Last edited by philwareham (2013-06-06 11:33:19)

Offline

#3 2013-06-06 11:34:24

dorka
Member
Registered: 2012-10-04
Posts: 90

Re: error after moving to new host

Thanks for the warning :-)

Offline

#4 2013-06-06 11:38:29

philwareham
Core designer
From: Haslemere, Surrey, UK
Registered: 2009-06-11
Posts: 3,564
Website GitHub Mastodon

Re: error after moving to new host

It looks like the Textpattern database has not been moved to your new server, hence the system is looking database tables that don’t exist.

You need to migrate that database into your new host – your ISP should be able to help with that, or if you feel like doing it yourself this post might help

Last edited by philwareham (2013-06-06 11:38:48)

Offline

#5 2013-06-06 11:57:48

dorka
Member
Registered: 2012-10-04
Posts: 90

Re: error after moving to new host

Hi Phil, I did move my DB via PMA panel and the import went OK, but I just realized now what the error line says:
“Table ‘d31332_salon.textpattern’ doesn’t exist”
The proper name of the database is “d31332_salon” without the “.textpattern”. I seem to have the name right in the config file, but there must be another place where the wrong name is set. Where could that be?
BTW is it possible, that the wrong name comes from the fact, that I have more than one DB installed on my test server?

Offline

#6 2013-06-06 14:32:02

Gocom
Developer Emeritus
From: Helsinki, Finland
Registered: 2006-07-14
Posts: 4,533
Website

Re: error after moving to new host

The ‘textpattern’ is the name of the missing table the error message is referring to, not part of the name of the database.

Offline

#7 2013-06-06 15:00:49

dorka
Member
Registered: 2012-10-04
Posts: 90

Re: error after moving to new host

Ah, OK … I’m even more confused than, because I don’t see a table with this name in the original db either?! Any more ideas? Thanks guys…

Offline

#8 2013-06-06 15:49:39

uli
Moderator
From: Cologne
Registered: 2006-08-15
Posts: 4,303

Re: error after moving to new host

Did I understand you: You don’t have a table textpattern in the original DB but this DB run OK on the previous installation?

Edited to add: Are there any tables with prefix txp_ in your DB?

Last edited by uli (2013-06-06 15:50:57)


In bad weather I never leave home without wet_plugout, smd_where_used and adi_form_links

Offline

#9 2013-06-07 06:39:58

dorka
Member
Registered: 2012-10-04
Posts: 90

Re: error after moving to new host

Precisely so, Uli, the tables seem to be identical on both servers. On the old one txp is live & kicking.
Yes, there are txp_ prefixes in the db. Actually all tables in the db have this prefix, most of them have it double (txp_txp_…) with two exceptions, one of which is txp_textpattern. Isn’t that THE table in question?

Offline

#10 2013-06-07 07:51:23

etc
Developer
Registered: 2010-11-11
Posts: 5,028
Website GitHub

Re: error after moving to new host

It looks like table prefix is missing in your config.php:

$txpcfg['table_prefix'] = '';

should be

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

Offline

#11 2013-06-07 07:51:46

dorka
Member
Registered: 2012-10-04
Posts: 90

Re: error after moving to new host

Dear fellows, PROBLEM SOLVED! it was the prefixes in the table names. For some reason on the old server the system worked OK with an additional “txp_” prefix in the names of all tables in the db. On the new server I had to remove this extra prefixes. The reason why I didn’t realize this earlier is because when I tested the site I wanted to enter the backend right away, hence the only table wanted (and not found) was textpattern. Only when I tried to open the site itself the whole truth occurred – that the system couldn’t find any of the tables.
If some of you, smart and experienced guys, fills like shedding some more light on why it worked on the old server and it didn’t on the new one, I will be glad to learn more from you.
Any way thanks for the support and especially Uli for the usefull clue :-).
Have a nice day! … and nice weekend too! … life’s good :-)

Offline

#12 2013-06-07 15:33:11

uli
Moderator
From: Cologne
Registered: 2006-08-15
Posts: 4,303

Re: error after moving to new host

dorka wrote:

… life’s good :-)

What a nice message! :)


In bad weather I never leave home without wet_plugout, smd_where_used and adi_form_links

Offline

Board footer

Powered by FluxBB