Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Pages: 1
Comments not working after upgrade
Hi all,
I’ve recently upgraded a site which was running TXP RC1 to 4.0.3 and my comments no longer work. The comment previews but will not submit.
I’ve looked around the forums and found that modified comment form code may be a problem, but I’ve replaced it with the default code and it still does not work.
Sorry if this question has already been answered elsewhere, but I searched the forum and could not find a solution that works for me.
You can see the problem <a href=“http://www.travel-dive.com/new/article/78/john-boyle-underwater-film-maker-interview#comment”>here</a>
Thanks in advance.
Roan
Offline
Re: Comments not working after upgrade
Have you modified any of the files?
Please post your high level diagnostics. And if possible turn debugging mode on.
Your forms do not contain a nonce, not even after preview or reload of the page and I am not sure how that can happen at all…
Offline
Re: Comments not working after upgrade
Hi Sencer,
Thanks for all your help.
I might have done something which is a bit unorthodox and it may account for my problems.
Instead of directly upgrading TXP. I installed 4.0.3 clean on my new server space. I then copied over all of my OLD (RC 1) DB tables from the older install to the new one.
Basically I’m moving to a new server and had to install 4.0.3 clean and import data.
Could this be creating the problem?
Anyway my diagnostics are:
Textpattern version: 4.0.3 (r1188)
last_update: 2006-01-04 18:18:03/2006-01-04 16:49:38
Document root: /webroot/ifdnrg_sites/www.travel-dive.co.uk (/var/www/html/ifdnrg_sites/www.travel-dive.co.uk)
$path_to_site: /var/www/html/ifdnrg_sites/www.travel-dive.co.uk/new
Textpattern path: /var/www/html/ifdnrg_sites/www.travel-dive.co.uk/new/textpattern
Permanent link mode: section_id_title
Temp folder: /tmp
Site URL: www.travel-dive.com/new
PHP version: 4.4.1
Register globals: 1
Server time: 2006-01-23 11:09:40
MySQL: 4.1.8
Locale: en_GB
Server: Apache/1.3.33 (Unix) PHP/4.4.1
Apache version: Apache/1.3.33 (Unix) PHP/4.4.1
PHP mode: apache
Operating System: Linux 2.4.26
Pre-flight check:
————————————
Image directory is not writable: /var/www/html/ifdnrg_sites/www.travel-dive.co.uk/new/images
/var/www/html/ifdnrg_sites/www.travel-dive.co.uk/new/textpattern/setup/ still exists
————————————
.htaccess file contents:
————————————
#DirectoryIndex index.php index.html
#Options +FollowSymLinks
#RewriteBase /relative/web/path/
<IfModule mod_rewrite.c> RewriteEngine On RewriteCond %{REQUEST_FILENAME} -f [OR] RewriteCond %{REQUEST_FILENAME} -d RewriteRule ^(.+) – [PT,L]
RewriteRule ^(.*) index.php </IfModule>#php_value register_globals 0
————————————
Charset (default/config): latin1/utf8
character_set_client: utf8
character_set_connection: utf8
character_set_database: latin1
character_set_results: utf8
character_set_server: latin1
character_set_system: utf8
character_sets_dir: /var/lib/mysql/mysql/charsets/
19 Tables: textpattern is latin1, txp_category is latin1, txp_css is latin1, txp_discuss is latin1, txp_discuss_ipban is latin1, txp_discuss_nonce is latin1, txp_file is latin1, txp_form is latin1, txp_image is latin1, txp_link is latin1, txp_log is latin1, txp_log_mention is latin1, txp_page is latin1, txp_plugin is latin1, txp_prefs is latin1, txp_section is latin1
PHP extensions: xml, tokenizer/0.1, sysvshm, sysvsem, standard/4.4.1, sockets, session, posix, pcre, overload, mysql, ming, gettext, gd, ftp, exif/1.4 $Id: exif.c,v 1.118.2.37.2.3 2005/10/10 06:07:16 helly Exp $, curl, ctype, zlib/1.1, openssl, apache, ionCube Loader
/include/txp_category.php: r1154 (dffd7979531373149c74e3eedfbb50e2)
/include/txp_plugin.php: r1167 (c2c7d7fc1e4918c79cd3658c62e4fbda)
/include/txp_auth.php: r1166 (3e2eaca7b151e14561125ab68e722203)
/include/txp_form.php: r947 (c0e4393328985742bd81cda61d10d5ed)
/include/txp_section.php: r1154 (d85c1ce405fccd9dac364c8ef4eb72eb)
/include/txp_tag.php: r1134 (3e2dfbd6fdccf0693c147ba22a9705e7)
/include/txp_list.php: r1042 (e85d2de1c63b41f0e5bdcf268e3c487b)
/include/txp_page.php: r876 (e22dc37b465b87757722732a225b25f3)
/include/txp_discuss.php: r1170 (1e56e08cc95c255783410076db12529f)
/include/txp_prefs.php: r1170 (c806be1b1f238e75a5ff6b7cf8432d17)
/include/txp_log.php: r906 (68c4f32b70ce41a349f197b6bba6c200)
/include/txp_preview.php: r628 (a16f84b6610fc66db0bce51e25b7af34)
/include/txp_image.php: r1168 (e8ec79ff9b3a21c356ee23da7973b1f0)
/include/txp_article.php: r1170 (88689d7469d16c13d51bd4adff03ebd7)
/include/txp_css.php: r922 (0c596d9968052b89581d1ca65a77c5de)
/include/txp_admin.php: r1074 (7e87ff0e29101593fb170b1a2de9fd59)
/include/txp_link.php: r1154 (7c0c55ff6580793dff0626f169e64ad6)
/include/txp_diag.php: r1154 (5d66b90f7e7720dd0e3526ca1b24cf89)
/lib/admin_config.php: r877 (9aea12193cc76eea1964eb0383ec6513)
/lib/txplib_misc.php: r1170 (7000a1b27aa40c90978211e6cff358ec)
/lib/taglib.php: r628 (493878f922262157601c26a999a1c478)
/lib/txplib_head.php: r1183 (fb85b66b4e379476935233f844844bef)
/lib/classTextile.php: r1141 (b066c2bfa94a26ae3d70b245dcf81369)
/lib/txplib_html.php: r1166 (bd11de6e6daa3391eab75a46db55ae36)
/lib/txplib_db.php: r1170 (f5f6eede244987b99bfcb80efbf345fb)
/lib/IXRClass.php: r765 (2efb0fb05b55c634072b0bae9af38bdd)
/lib/txplib_forms.php: r950 (74da2c67abe4786c353ea416c13656eb)
/publish/taghandlers.php: r1188 (4e8eaeb0543d8fde09d6e423af4253b9)
/publish/atom.php: r1117 (14c1aa23c708898d7723b3d6b9c89050)
/publish/log.php: r864 (c3d16d3dfe375819a19fcd62398e4b86)
/publish/comment.php: r1187 (d55dde574418d2eaf6a394d703056d9a)
/publish/search.php: r884 (80f942f1dc301857c2fa9dcb16aa1246)
/publish/rss.php: r1099 (ce0d82b9435d8f1de01c8e2b6c585f93)
/publish.php: r1186 (d5c20bf2298e87969575f9e622bf2797)
/index.php: r1172 (52f753ebb51c1f7d5312485d9dbad7e4)
/css.php: r944 (df1c754417bdfb4e97a2c83ae5b454ee)
debugging mode is now on.
Thanks again.
Offline
Re: Comments not working after upgrade
Fatal error: select nonce, secret from `txp_discuss_nonce` where nonce in (‘19209d7e2435e0ae5a2e5cd9abbe1fec’)Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation ‘ IN ‘ select nonce, secret from `txp_discuss_nonce` where nonce in (‘19209d7e2435e0ae5a2e5cd9abbe1fec’)
That is your problem. The reason is:
Instead of directly upgrading TXP. I installed 4.0.3 clean on my new server space. I then copied over all of my OLD (RC 1) DB tables from the older install to the new one.
By making a fresh install, Textpattern probably chose a different charset for your database (it chooses the best available option). By importing tables with a different charset you ended up with your problems.
Solution: First move your site, then update it to 4.0.3. Make sure you keep your old config.php.
(If you feel very brave, you might try simply removing the line about charset/utf8 from your current config.php. Textpattern will default to latin1 for db-access. It’s possible you might encounter other problems though…)
Offline
Re: Comments not working after upgrade
Thanks Sencer.
I thought this might have been the problem.
I’ll give it a go.
Offline
Pages: 1