Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Re: Feedback to: Help us test the release candidate for the upcoming 4.0.7
i just wanted to upgrade an installation to the latest RC and now i’m getting this error:
Warning: Unknown column 'load_order' in 'order clause' select name, code, version from txp_plugin where status = 1 AND type IN (1,3) order by load_order in /textpattern/lib/txplib_db.php on line 82
and when i go to the plugin section:
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 from txp_plugin where 1 order by name asc in /textpattern/lib/txplib_db.php on line 82
Last edited by sthmtc (2008-11-23 21:08:15)
Offline
Re: Feedback to: Help us test the release candidate for the upcoming 4.0.7
What version were you updating from?
Offline
Re: Feedback to: Help us test the release candidate for the upcoming 4.0.7
4.0.6
Offline
Re: Feedback to: Help us test the release candidate for the upcoming 4.0.7
Strange, as Textpattern would add the missing column load_order as a part of the update procedure from a clean 4.0.6 to 4.0.7 RC.
This SQL statement would force TXP to reapply all updates: DELETE FROM txp_prefs WHERE name='dbupdatetime' (replace txp_prefs with your prefixed table name like myprefixtxp_prefs)
Offline
Re: Feedback to: Help us test the release candidate for the upcoming 4.0.7
the_ghost wrote:
Do filenames appear in url?
For instance, <txp:file_download_link /> builds clean URIs like so: http://example.com/file_download/42/foo.bar
Offline
Re: Feedback to: Help us test the release candidate for the upcoming 4.0.7
sthmtc wrote:
4.0.6
Sven, was this site installed or updated with 4.0.6 before or after 2008-Nov-07?
Offline
Re: Feedback to: Help us test the release candidate for the upcoming 4.0.7
wet wrote:
For instance,
<txp:file_download_link />builds clean URIs like so: http://example.com/file_download/42/foo.bar
Oops, you’re right. But some idea I have – can’t we left filename’s in native language, but don’t use them in url, or use translitarated version? I think that txp handles right download by id – the filename is for recognition only. And, if it’s so, translitarated url would be the happy medium. Because we can built nice links, where <txp:file_download_name /> would look good and url would be safe.
Providing help in hacking ATM! Come to courses and don’t forget to bring us notebook and hammer! What for notebook? What a kind of hacker you are without notebok?
Offline
Re: Feedback to: Help us test the release candidate for the upcoming 4.0.7
the_ghost wrote:
Oops, you’re right. But some idea I have – can’t we left filename’s in native language, but don’t use them in url, or use translitarated version?
This would probably break existing URIs and backwards compatibility.
Offline
Re: Feedback to: Help us test the release candidate for the upcoming 4.0.7
wet wrote:
This would probably break existing URIs and backwards compatibility.
I have an old 4.0.6 version and filenames aren’t converted threre – only spaces converted into +. If we left current behoviour or make names transliterated it’s very oncomfortable to build files’ archives – because in this way we have only one ontouchable filed – files’ description and we have to use it as file name, ot develop some php code for exploding this field into 2 or more by some special chars (like there is plugin for series of values in one custom_field).
Last edited by the_ghost (2008-11-24 09:56:31)
Providing help in hacking ATM! Come to courses and don’t forget to bring us notebook and hammer! What for notebook? What a kind of hacker you are without notebok?
Offline
#70 2008-11-24 12:27:02
- Olhado
- New Member
- Registered: 2008-10-28
- Posts: 3
Re: Feedback to: Help us test the release candidate for the upcoming 4.0.7
the_ghost wrote:
I have an old 4.0.6 version and filenames aren’t converted threre – only spaces converted into
+.
It’s true :) For example: mp3 with raw russian in filename — TxP 4.0.6 and there is no problems with downloading, playing, etc. And CMS works fine.
But not in 4.0.7
Last edited by Olhado (2008-11-24 12:27:46)
Sorry for bad English
Offline
Re: Feedback to: Help us test the release candidate for the upcoming 4.0.7
Olhado wrote:
It’s true :) For example: mp3 with raw russian in filename (http://khasandivers.co.cc/file_download/2/%D0%91%D0%BE%D0%B9+%D1%83+%D0%BE%D0%B7%D0%B5%D1%80%D0%B0+%D0%A5%D0%B0%D1%81%D0%B0%D0%BD-%D0%90%D0%BD%D1%81%D0%B0%D0%BC%D0%B1%D0%BB%D1%8C+%D0%BF%D0%B5%D1%81%D0%BD%D0%B8.mp3)
We know, that this “works”. But it requires percent-encoded filenames (see above), which might impose a security risk. The sanitization of file names as a security precaution is part of 4.0.7.
Offline
Re: Feedback to: Help us test the release candidate for the upcoming 4.0.7
wet wrote:
Strange, as Textpattern would add the missing column
load_orderas a part of the update procedure from a clean 4.0.6 to 4.0.7 RC.
So could this be a bug? I never had any issues upgrading Textpattern in that particular environment.
Offline