Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#1 2010-11-30 17:21:44

angelika
Member
Registered: 2010-11-30
Posts: 13

ok to upgrade from 4.0.6 to 4.3.0?

Is it advisable to upgrade from 4.0.6 to 4.3.0 or should I do it in several steps?

/angelika

Offline

#2 2010-11-30 18:08:55

ruud
Developer Emeritus
From: a galaxy far far away
Registered: 2006-06-04
Posts: 5,068
Website

Re: ok to upgrade from 4.0.6 to 4.3.0?

TXP updates itself step by step anyway, so it shouldn’t matter if you upgrade from 4.0.6 to 4.0.8 to 4.2. to 4.3 or just upgrade in one big step (which is easier). If such an upgrade would fail, that’s a bug.

If you have plugins installed, you should make sure they are compatible with 4.3. Most plugins are. Some are not. Some just require you to install a newer version of the plugin.

Offline

#3 2010-11-30 18:31:46

angelika
Member
Registered: 2010-11-30
Posts: 13

Re: ok to upgrade from 4.0.6 to 4.3.0?

Ok, thanks a lot! There are a few files in the plugin folder. I’ll try and find some info on them.

I did run into a bunch of problems unfortunately and the site isn’t working right now. I get a few “Warning: Unknown column ‘user_name’ in ‘where clause’ select name, val from txp_prefs where prefs_id=1 AND user_name=’‘ in /www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/lib/txplib_db.php on line 89” even though I’ve logged in and out. I get a ton of notices. And it feels like I’m getting every error message there is under Diagnostics:

$path_to_site is not set (update index.php) ?
$path_to_site is inaccessible.: ?
/index.php is inaccessible ?
Image directory is not writable: /
File directory path is not writable:
Temporary directory path is not writable: ?
.htaccess file is missing ?
/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/setup/ still exists ?
no_temp_dir ?
Temporary directory path and Plugin cache directory path should not match. ?

I’ve been acquainted with Textpattern for about two hours now and I have no idea where to start…

/angelika

Offline

#4 2010-11-30 18:58:46

els
Moderator
From: The Netherlands
Registered: 2004-06-06
Posts: 7,458

Re: ok to upgrade from 4.0.6 to 4.3.0?

Can you post the ‘high’ diagnostics? You will also find a list of installed plugins there (they are not supposed to be in a ‘plugins’ folder, but in the database).

So you solved your other issue?

Offline

#5 2010-11-30 19:00:51

maverick
Member
From: Southeastern Michigan, USA
Registered: 2005-01-14
Posts: 976
Website

Re: ok to upgrade from 4.0.6 to 4.3.0?

angelika wrote:

I did run into a bunch of problems unfortunately and the site isn’t working right now.

.htaccess file is missing ?

The Txp download contains a .htacess file. Some ftp clients don’t always upload it, or it otherwise gets missed. Find it in your download and upload it to the same directory that index.php is in.

$path_to_site is not set (update index.php) ?
bq. $path_to_site is inaccessible.: ?
bq. /index.php is inaccessible ?

I’m thinking (perhaps wrongly) that these may go away w/ the .htaccess file properly uploaded.

I get a few “Warning: Unknown column ‘user_name’ in ‘where clause’ select name, val from txp_prefs where prefs_id=1 AND user_name=’‘ in /www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/lib/txplib_db.php on line 89” even though I’ve logged in and out.

It sounds almost like this warning issue at the 4.2.0 upgrade. Once you make the other fixes try logging in and out and see if it goes away.

Image directory is not writable: /
bq. File directory path is not writable:
bq. Temporary directory path is not writable: ?’

This is probably a permissions issue. Some ftp clients don’t set the permissions correctly on upload. You need to CHMOD the permissions (alternately, change the permissions w/ your ftp client). Usually 755 will work.

/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/setup/ still exists ?

This is normal, and requires the textpattern/setup folder be deleted manually once set up is done. It is deleted for security purposes.

no_temp_dir ?

This is usually automatically there, but can be manually created and in advance preferences you can set the path to it if need be.

Temporary directory path and Plugin cache directory path should not match. ?

By default plugins are stored in the database, and I don’t think there isn’t a cache directory for them in a standard install . There is a way to have the plugins in their own directory outside of the database – I think it may be with a plugin but have to check Correction: The plugin cache is also set in the advance preferences. It is optional. I know others use it regularly and can give some insight.

I’ve been acquainted with Textpattern for about two hours now and I have no idea where to start…

Probably seems like a rough introduction – but don’t worry – it doesn’t sound like anything that can’t be easily fixed :) Txp upgrades have been among the easiest I’ve every experienced – once you become familiar with them.

Last edited by maverick (2010-11-30 19:10:06)

Offline

#6 2010-11-30 19:09:26

angelika
Member
Registered: 2010-11-30
Posts: 13

Re: ok to upgrade from 4.0.6 to 4.3.0?

@Els

Here are the diagnostics for the high setting:
Textpattern version: 4.3.0 (r3451)
Last Update: 1970-01-01 00:00:00/2010-11-30 17:27:47
Document root: /www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html
$path_to_site:
Textpattern path: /www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern
Permanent link mode:
Temporary directory path:
Site URL:
PHP version: 5.3.3
GD Image Library: bundled (2.0.34 compatible); supported formats: GIF, JPG, PNG.
Server TZ: Europe/Stockholm
Server Local Time: 2010-11-30 20:08:16
DST enabled?:
Automatically adjust DST setting?:
Time Zone: ()
MySQL: 5.0.45-log
Locale:
Server: Apache/2.2.17 (FreeBSD) PHP/5.3.3 with Suhosin-Patch mod_ssl/2.2.17 OpenSSL/0.9.8n
Apache version: Apache/2.2.17 (FreeBSD) PHP/5.3.3 with Suhosin-Patch mod_ssl/2.2.17 OpenSSL/0.9.8n
PHP Server API: apache2handler
RFC 2616 headers:
Server OS: FreeBSD 8.1-LOOPIA_007
Active plugins: chh_if_data-0.10, rss_admin_show_adv_opts-0.3, jcd_cart-0.1m
Admin-side theme:

Pre-flight check:
————————————
$path_to_site is not set (update index.php)
$path_to_site is inaccessible.:
/index.php is inaccessible
Image directory is not writable: /
File directory path is not writable:
Temporary directory path is not writable:
.htaccess file is missing
no_temp_dir
Temporary directory path and Plugin cache directory path should <strong>not</strong> match.
————————————

Charset (default/config): latin1/utf8
character_set_client: utf8
character_set_connection: utf8
character_set_database: latin1
character_set_filesystem: binary
character_set_results: utf8
character_set_server: latin1
character_set_system: utf8
character_sets_dir: /usr/local/share/mysql/charsets/
17 Tables: OK

10 Custom Fields: custom_1, custom_2, custom_3, custom_4, custom_5, custom_6, custom_7, custom_8, custom_9, custom_10 (10)

PHP extensions: Core/5.3.3, date/5.3.3, ereg, libxml, pcre, Reflection/$Revision: 300393 $, SPL/0.2, hash/1.0, session, apache2handler, SimpleXML/0.1, xmlwriter/0.1, posix, calendar, mcrypt, standard/5.3.3, mbstring, dom/20031129, imap, exif/1.4 $Id: exif.c 293036 2010-01-03 09:23:27Z sebastian $, ftp, mysql/1.0, xml, mysqlnd/mysqlnd 5.0.7-dev – 091210 – $Revision: 300533 $, soap, gettext, openssl, PDO/1.0.4dev, xmlreader/0.1, curl, gd, json/1.2.1, bcmath, zlib/1.1, iconv, pdo_mysql/1.0.2, mysqli/0.1, ctype, tidy/2.0, zip/1.9.1, tokenizer/0.1, filter/0.11.0, mhash

Apache modules: core, prefork, http_core, mod_so, mod_actions, mod_alias, mod_auth_basic, mod_auth_digest, mod_authn_alias, mod_authn_default, mod_authn_file, mod_authn_anon, mod_authz_default, mod_authz_groupfile, mod_authz_host, mod_authz_user, mod_autoindex, mod_cgi, mod_deflate, mod_dir, mod_env, mod_expires, mod_headers, mod_include, mod_info, mod_log_config, mod_log_forensic, mod_logio, mod_mime_magic, mod_mime, mod_negotiation, mod_php5, mod_rewrite, mod_security2, mod_setenvif, mod_ssl, mod_status, mod_unique_id, mod_version

/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/index.php: r3189 (b58ca188e05a48b31d1025d61e026725)
/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/css.php: r3189 (5e7fe7ea948c7e9ec2e56e34a01f4bb6)
/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/css.php: r3189 (4e131ff20d1da3e20b2c629292138653)
/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/include/import/import_b2.php: r3446 (e05c2808566822ed4a6e525ee4bc4192)
/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/include/import/import_blogger.php: r3446 (2096da3f746152301620e18a4ccfe0f8)
/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/include/import/import_mt.php: r3446 (f0be9ce384eec112f8e70687458173cc)
/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/include/import/import_mtdb.php: r3446 (c8f07f5a6db990382e4a30a1d57333e6)
/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/include/import/import_wp.php: r3446 (0740155a2d06657893acc7c7d968770d)
/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/include/txp_admin.php: r3386 (ffb4129e774cfbb8643c2e05f37f3507)
/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/include/txp_article.php: r3440 (db97df274f245047f305ff75b1e20560)
/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/include/txp_auth.php: r3374 (a7f13cd308c5c500105f2b5994cc3aad)
/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/include/txp_category.php: r3374 (5af7cf31692bb2213f93babfef5a6657)
/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/include/txp_css.php: r3379 (88587e0dc2d159be4e521dbf33de7bb7)
/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/include/txp_diag.php: r3446 (1903c263988e7ce4d705e5f0d7ee5bdf)
/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/include/txp_discuss.php: r3374 (ec56dc03cb9ac06f5f026d0a3daf3bac)
/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/include/txp_file.php: r3416 (3159e53e1f35099257be71fe85adf021)
/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/include/txp_form.php: r3382 (e6574a6280585918bd7d4c6d202c3b85)
/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/include/txp_image.php: r3441 (9a93e09c68754dd10f1dc007914652d9)
/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/include/txp_import.php: r3374 (3dbc737eaa1def0771d76344ff7fb116)
/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/include/txp_link.php: r3374 (bb85e92bc8df2363676817a10c0d5801)
/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/include/txp_list.php: r3374 (88af3230cf8dc28747b10a1fea20800a)
/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/include/txp_log.php: r3374 (acb6773311e80fbf87a38587c99a7d2d)
/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/include/txp_page.php: r3379 (92d4d3d0dd9d6ef46fb6e1fdb6d1b0b1)
/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/include/txp_plugin.php: r3374 (d73a4547e590fc476279278fa8aeb391)
/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/include/txp_prefs.php: r3445 (959c2a15daf42c8c6da5957b98b0213d)
/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/include/txp_preview.php: r1238 (d55a3df200602c69eb65c72dc8ad7477)
/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/include/txp_section.php: r3374 (d496b080b90519a9a6e180b0fd0451f8)
/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/include/txp_tag.php: r3444 (b8634c90e7ea16c60d1370a867e91626)
/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/index.php: r3451 (dd519f665b0ffb952246f5d91170134c)
/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/jquery.js: unknown (e4958bd2e32d9fcd6115a585ed17a9cc)
/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/lib/IXRClass.php: r3394 (f8621cd5f0f36c69360aa2033e4065af)
/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/lib/admin_config.php: r3386 (6b2b6db38da2baa82f5557a6e29bad97)
/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/lib/class.thumb.php: r3301 (6ca1ad88082438f88cae6416dcb29822)
/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/lib/classTextile.php: r3438 (734d0ebd2f9e7c4c84bf93bf5cde5d58)
/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/lib/constants.php: r3318 (a2b38baeb4ba77f9dfdd4ad71e277549)
/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/lib/taglib.php: r2868 (c9676967585577f0a0b329803761d516)
/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/lib/txplib_admin.php: r3047 (d5211ebfac4f3b6d00f22d459f3cdf69)
/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/lib/txplib_db.php: r3389 (3324a5dab30f68bda3fa7218514f91b7)
/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/lib/txplib_forms.php: r3372 (447c117e7072a73e67ebe2dc41fe46ee)
/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/lib/txplib_head.php: r3388 (e59cdf9aa24c4d2fb88d0d45076be68e)
/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/lib/txplib_html.php: r3372 (17041abcc0779d22a6224feb8dfd3492)
/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/lib/txplib_misc.php: r3437 (b9de32008e7a9ac596e637d993aab37e)
/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/lib/txplib_theme.php: r3388 (99262eb207d3b49a343ad4b5c1dd3e64)
/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/lib/txplib_update.php: r2812 (54d6fa23f3f3fc5c2cb31262c6aa343f)
/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/lib/txplib_wrapper.php: r2931 (22f292521a595090b46300354db6df57)
/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/publish.php: r3433 (3469e21a32b2411d56e57701baf296f6)
/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/publish/atom.php: r3399 (9a4eeebe17b8c833bc382b6287fbb168)
/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/publish/comment.php: r3395 (8a55386ccfd856bd5df68c84058e5ba0)
/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/publish/log.php: r3247 (257c3a247f0ca6a21513beb2f09d76c6)
/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/publish/rss.php: r3399 (da9ab0c78c57b4169a360dfa0aa6c753)
/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/publish/search.php: r2812 (22762b20f6281fd132248ec42e5ee9af)
/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/publish/taghandlers.php: r3443 (e9a2a51863fd241cd8e7e8c0785120ab)
/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/textpattern.js: r3369 (b87b0a897cc2259aa5132da030764c9d)
/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/theme/classic/classic.php: r3191 (8af2d7091676308c93021843c629812d)
/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/update/_to_1.0.0.php: r3047 (8aa7c3d82aad8df47adf96e92f124137)
/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/update/_to_4.0.2.php: r3047 (81324dcf9bed59bacd73789c2b650305)
/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/update/_to_4.0.3.php: r3047 (c237b669e57b7fe0ea2f8c7cc9d69557)
/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/update/_to_4.0.4.php: r3047 (d3e62265ff5ad36a8a7de23e6148f6f9)
/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/update/_to_4.0.5.php: r2894 (7f5fe789f58a202e23c1b430a2659110)
/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/update/_to_4.0.6.php: r3047 (687e230c2c6a46a6c73d3e97ee368d92)
/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/update/_to_4.0.7.php: r3014 (fa83153d09e2e533ce41f69799b90f5c)
/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/update/_to_4.0.8.php: r3057 (26d76a86cb95757355958e06b6063afe)
/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/update/_to_4.2.0.php: r3233 (9bd2be46df10e2f0561634a2de4cdc63)
/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/update/_to_4.3.0.php: r3304 (0f57c27668c4f791530830d92b146dde)
/www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/update/_update.php: r3451 (9d15292f6117490393ff999cd052027e)

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

Offline

#7 2010-11-30 19:17:33

els
Moderator
From: The Netherlands
Registered: 2004-06-06
Posts: 7,458

Re: ok to upgrade from 4.0.6 to 4.3.0?

Thank you. Can you first have a look at maverick’s post, and see if it gets rid of some of the errors?

About the plugins: chh_if_data still works, but can be replaced by native txp tags; what rss_admin_show_adv_opts does is now native txp behaviour (it doesn’t work well with recent txp versions, so you’d better remove it); I don’t know about jcd_cart.

Last edited by els (2010-11-30 19:18:46)

Offline

#8 2010-11-30 19:20:16

angelika
Member
Registered: 2010-11-30
Posts: 13

Re: ok to upgrade from 4.0.6 to 4.3.0?

@maverick

Thanks so much for your advice. Replies:
1. I have checked and double checked that the .htaccess file has been uploaded. The new file was slightly different than the old one, and I have tried using both of them. The old one had “RewriteBase /” and in the new one this is commented out.
2. Both the images, files and tmp folders are set to 777 now, but the error message about them not being accessible is still there.
3. I removed the setup folder, so that’s solved at least.
4. The tmp folder is in textpattern/tmp, the path is set under Pref. -> Advanced and it is also set to 777, still error message.
5. Not really sure what to do about plugins, not even sure if there are any or if it is just some random files in a plugin folder. If I can get the rest to work I’ll worry about that later…

The site is http://afroart.se/. If you click on some of the links you will see that the url says that you are on a different page, but you are still on the start page. It’s like none of the content can be found.

/Angelika

Offline

#9 2010-11-30 19:35:52

angelika
Member
Registered: 2010-11-30
Posts: 13

Re: ok to upgrade from 4.0.6 to 4.3.0?

Another clue, perhaps: When I look at the sites markup, i find an image and the src should be http://afroart.se/images/107.jpg, but it’s only http://afroart.se//107.jpg. When I look at the Pref. -> Advanced the Image directory is “images”.

Last edited by angelika (2010-11-30 19:36:35)

Offline

#10 2010-11-30 19:37:41

maverick
Member
From: Southeastern Michigan, USA
Registered: 2005-01-14
Posts: 976
Website

Re: ok to upgrade from 4.0.6 to 4.3.0?

angelika wrote:

Now we are sort of getting into the “that should have done it, why didn’t it” territory. We’ve got a great community here on the forums, and between us I’m sure we can help you get things working.

Just out of curiosity (to be thorough) – have you double checked your config file to make sure everything is okay there?

3. I removed the setup folder, so that’s solved at least.

Progress is good :)

The site is http://afroart.se/.

In the meantime – jumping over to the minor issues on the public side – regarding the two tag errors:

Tag error: <txp:jcd_cart page=“1” /> -> Textpattern Warning: tag does not exist on line 1183
bq. Tag error: <txp:php> -> Textpattern Notice: php_code_disabled_page on line 3739

– as a quick way of explanation – since you are new, you may not realize:

The errors are showing publicly because of the “mode” Textpattern is set in (debug, testing, live).

The txp:jcd is a plugin, as Els noted. It is either missing from the database or it is not enabled in Admin -> plugin tab.

For the php tag error you might check that the advanced preferences. You can set whether to use php there. Perhaps upgrading reset it to “off” as a security precaution.

Offline

#11 2010-11-30 19:52:29

maverick
Member
From: Southeastern Michigan, USA
Registered: 2005-01-14
Posts: 976
Website

Re: ok to upgrade from 4.0.6 to 4.3.0?

angelika wrote:

1. I have checked and double checked that the .htaccess file has been uploaded. The new file was slightly different than the old one, and I have tried using both of them. The old one had “RewriteBase /” and in the new one this is commented out.

Yet in the diagnostics it still thinks it is missing. Hmmm. Those more familiar with .htaccess files than I am will know, but it seems that URLS are messed up, and I would guess this is part of why.

To be honest — and I can’t say whether this is good advice or not, :) but I’d back up my current install if it isn’t already (so you can reapply the config.php file, customizations, file folder, image folder, etc.), delete the current install completely, then reupload it fresh again. (making sure the ftp client is set to ACSII mode). Just to make sure that something had not been corrupted.

I would then drag a copy of the config. file back and see what, if any, or the errors went away.

Sometimes a bad upload does strange things and this helps rule that out.

Not sure if that is an option for you in this situation . . .

Offline

#12 2010-11-30 20:00:59

angelika
Member
Registered: 2010-11-30
Posts: 13

Re: ok to upgrade from 4.0.6 to 4.3.0?

I’m so very grateful for all your help!

The config.php file seems fine to me. It contains db, user, pass, host, table_prefix (empty), txpath and dbcharset. All the values seem ok. The txpath is /www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern, which corresponds to what you see in the diagnostics info.

The mode is set to Test. I think I’ll leave it like that for the time being, I don’t want to miss any messages. The only setting that is of when it comes to php is “Allow raw PHP?”. I set it to yes, but the error was still there, so I set it back to no. I can find the plugin in the txp_plugin table, but under the Plugin tab there are only error messages and a field for uploading new plugins. Error messages:

Warning: Unknown column ‘user_name’ in ‘where clause’ select name, val from txp_prefs where prefs_id=1 AND user_name=’‘ in /www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/lib/txplib_db.php on line 89

Notice: Undefined variable: language in /www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/index.php on line 70

Warning: Unknown column ‘user_name’ in ‘where clause’ select name, val from txp_prefs where prefs_id=1 AND user_name=‘afroart’ in /www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/lib/txplib_db.php on line 89

Warning: Unknown column ‘user_name’ in ‘where clause’ select name from txp_prefs where name = ‘plugin_sort_column’ AND user_name = ‘afroart’ in /www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/lib/txplib_db.php on line 89

Warning: Unknown column ‘user_name’ in ‘field list’ insert into txp_prefs set name = ‘plugin_sort_column’, val = ‘name’, event = ‘plugin’, html = ‘’, type = ‘2’, position = ‘0’, user_name = ‘afroart’, prefs_id = 1 in /www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/lib/txplib_db.php on line 89

Warning: Unknown column ‘user_name’ in ‘where clause’ select name from txp_prefs where name = ‘plugin_sort_dir’ AND user_name = ‘afroart’ in /www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/lib/txplib_db.php on line 89

Warning: Unknown column ‘user_name’ in ‘field list’ insert into txp_prefs set name = ‘plugin_sort_dir’, val = ‘asc’, event = ‘plugin’, html = ‘’, type = ‘2’, position = ‘0’, user_name = ‘afroart’, prefs_id = 1 in /www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/lib/txplib_db.php on line 89

Warning: Unknown column ‘load_order’ in ‘field list’ select name, status, author, author_uri, version, description, length(help) as help, abs(strcmp(md5(code),code_md5)) as modified, load_order, flags from txp_plugin where 1 order by name asc in /www/webvol10/ja/3oi6qf59yq8nd9e/afroart.se/public_html/textpattern/lib/txplib_db.php on line 89

Also, the error messages seem to be true, there really is no column named user_name in the txp_prefs. Should there be? Is there som db script that has not been run?

/Angelika

Offline

Board footer

Powered by FluxBB