Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
#1 2009-01-01 20:27:00
- tilunanda
- New Member
- Registered: 2008-12-18
- Posts: 8
[resolved] [Solved] trying to upgrade db to MySql5 - help?
I needed to upgrade MySql4 to MySql5, as my host isnt supporting the former any longer.
So, I upgraded to Txp 4.0.7 and things were looking ok with MySql4 db.
Couldn’t find any specific faq on upgrading db, so I just tried changing my config file to reflect the MySql5 db (which I had transferred old table info to via my host’s transfer tool. phpMyAdmin shows tables looking ok).
After adjusting config, I get this:
Warning: Table ‘ensemble_new.txptextpattern’ doesn’t exist describe `txptextpattern` in /home/ensemble/www/www/textpattern/lib/txplib_db.php on line 82
Warning: Cannot modify header information – headers already sent by (output started at /home/ensemble/www/www/textpattern/lib/txplib_db.php:82) in /home/ensemble/www/www/textpattern/lib/txplib_misc.php on line 1728
Warning: Table ‘ensemble_new.txptxp_page’ doesn’t exist select user_html from txptxp_page as txp_page where name=‘error_503’ in /home/ensemble/www/www/textpattern/lib/txplib_db.php on line 82
Warning: Table ‘ensemble_new.txptxp_page’ doesn’t exist select user_html from txptxp_page as txp_page where name=‘error_default’ in /home/ensemble/www/www/textpattern/lib/txplib_db.php on line 82
Warning: Cannot modify header information – headers already sent by (output started at /home/ensemble/www/www/textpattern/lib/txplib_db.php:82) in /home/ensemble/www/www/textpattern/lib/txplib_misc.php on line 1794
Any ideas what I ought to do to rectify this??
cheers
jen
Last edited by els (2012-05-16 19:35:08)
Offline
#2 2009-01-03 05:42:26
- vinref
- New Member
- Registered: 2008-12-31
- Posts: 6
Re: [resolved] [Solved] trying to upgrade db to MySql5 - help?
Hello
I also stopped at the same installation stage. My error messages are:
Warning: Table ‘[…edited…].textpattern’ doesn’t exist describe `textpattern` in /home/vinref/Web/[…edited…]/textpattern/lib/txplib_db.php on line 82
Warning: Table ‘[…edited…].txp_page’ doesn’t exist select user_html from txp_page where name=‘error_503’ in /home/vinref/Web/[…edited…]/textpattern/lib/txplib_db.php on line 82
Warning: Table ‘[…edited…].txp_page’ doesn’t exist select user_html from txp_page where name=‘error_default’ in /home/vinref/Web/[…edited…]/textpattern/lib/txplib_db.php on line 82
DB-Connect was succesful, but the textpattern-table was not found.
This is my first install of Textpattern. Platform is Textpattern 4.0.7, MySQL 5.0.67, PHP 5.2.6, Apache 2.0.63, NetBSD 4.0.1.
I granted the following privileges to the account used by the Textpattern install: CREATE, DROP, DELETE, INDEX, INSERT, SELECT, UPDATE. I flushed privileges and issused ‘@USE db_name’ so the privileges take effect. I even used the root account, to no avail.
Thanks in advance, Vince
Last edited by vinref (2009-01-03 05:50:13)
Offline
Re: [resolved] [Solved] trying to upgrade db to MySql5 - help?
Please post your FULL diagnostics (non-censored).
Offline
#4 2009-01-03 15:30:04
- tilunanda
- New Member
- Registered: 2008-12-18
- Posts: 8
Re: [resolved] [Solved] trying to upgrade db to MySql5 - help?
These are my diagnostics, when I am using the MySql4 database…
Textpattern version: 4.0.7 (r3033)
Last Update: 2009-01-01 19:56:05/2009-01-01 18:47:33
Document root: /home/ensemble/www/www
$path_to_site: /home/ensemble/www/www
Textpattern path: /home/ensemble/www/www/textpattern
Permanent link mode: messy
Temporary directory path: /home/ensemble/www/www/textpattern/tmp
Site URL: ensemble-pi.org
TZ: America/New_York
PHP version: 5.2.6
Register globals: 1
GD Image Library: version bundled (2.0.34 compatible), supported formats: GIF, JPG, PNG
Server Local Time: 2009-01-03 10:29:01
MySQL: 4.0.27-log
Locale: en_US.UTF-8
Server: Apache
PHP Server API: cgi
RFC 2616 headers: 0
Server OS: Linux 2.6.27.6-grsec
Active plugins: zem_contact-0.6, mkp_version-4.0, mdp_sectionmenu-0.5, glx_if-0.6.4, mdp_calendar-1.0, rss_suparchive-0.18, jnm_audio-0.3
.htaccess file contents:
————————————
#DirectoryIndex index.php index.html
#Options +FollowSymLinks
#Options -Indexes
<IfModule mod_rewrite.c> RewriteEngine On #RewriteBase /relative/web/path/
RewriteCond %{REQUEST_FILENAME} -f [OR] RewriteCond %{REQUEST_FILENAME} -d RewriteRule ^(.+) – [PT,L]
RewriteCond %{REQUEST_URI} !=/favicon.ico RewriteRule ^(.*) index.php
RewriteCond %{HTTP:Authorization} !^$
RewriteRule .* – [E=REMOTE_USER:%{HTTP:Authorization}]
</IfModule>
#php_value register_globals 0
————————————
Offline
Re: [resolved] [Solved] trying to upgrade db to MySql5 - help?
Do you have a database called “ensemble_new” and does it contain a table called “txptextpattern”?
Offline
#6 2009-01-03 17:10:15
- tilunanda
- New Member
- Registered: 2008-12-18
- Posts: 8
Re: [resolved] [Solved] trying to upgrade db to MySql5 - help?
my database is called “ensemble_new”
I have no table called “txptextpattern”
I do have a table called “textpattern” and all other tables have “txp_” prefix
Offline
Re: [resolved] [Solved] trying to upgrade db to MySql5 - help?
In your textpattern/config.php file there’s a setting for database table prefix. I think that’s set to 'txp'
, while it should be set to ''
(empty string).
Offline
#8 2009-01-03 18:17:15
- tilunanda
- New Member
- Registered: 2008-12-18
- Posts: 8
Re: [resolved] [Solved] trying to upgrade db to MySql5 - help?
that’s it!!
thanks!
Offline
#9 2009-02-23 06:50:54
- vinref
- New Member
- Registered: 2008-12-31
- Posts: 6
Re: [resolved] [Solved] trying to upgrade db to MySql5 - help?
Thanks for the help. I fixed this particular issue myself. It was a misconfiguration in the virtual host declarations in httpd.conf.
Offline