Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Pages: 1
#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’;
?>
Help me please!
Last edited by dorka (2013-06-06 11:33:45)
Offline
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
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
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,306
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
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,306
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
Pages: 1