[resolved] [Solved] trying to upgrade db to MySql5 - help?

tilunanda · 2009-01-01 20:27:00

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)

vinref · 2009-01-03 05:42:26

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)

ruud · 2009-01-03 13:38:44

Please post your FULL diagnostics (non-censored).

tilunanda · 2009-01-03 15:30:04

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

————————————

ruud · 2009-01-03 17:01:41

Do you have a database called “ensemble_new” and does it contain a table called “txptextpattern”?

tilunanda · 2009-01-03 17:10:15

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

ruud · 2009-01-03 17:51:44

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).

tilunanda · 2009-01-03 18:17:15

that’s it!!
thanks!

vinref · 2009-02-23 06:50:54

Thanks for the help. I fixed this particular issue myself. It was a misconfiguration in the virtual host declarations in httpd.conf.

Textpattern CMS

Textpattern CMS support forum

#1 2009-01-01 20:27:00

[resolved] [Solved] trying to upgrade db to MySql5 - help?

#2 2009-01-03 05:42:26

Re: [resolved] [Solved] trying to upgrade db to MySql5 - help?

#3 2009-01-03 13:38:44

Re: [resolved] [Solved] trying to upgrade db to MySql5 - help?

#4 2009-01-03 15:30:04

Re: [resolved] [Solved] trying to upgrade db to MySql5 - help?

#5 2009-01-03 17:01:41

Re: [resolved] [Solved] trying to upgrade db to MySql5 - help?

#6 2009-01-03 17:10:15

Re: [resolved] [Solved] trying to upgrade db to MySql5 - help?

#7 2009-01-03 17:51:44

Re: [resolved] [Solved] trying to upgrade db to MySql5 - help?

#8 2009-01-03 18:17:15

Re: [resolved] [Solved] trying to upgrade db to MySql5 - help?

#9 2009-02-23 06:50:54

Re: [resolved] [Solved] trying to upgrade db to MySql5 - help?

Board footer