MLP - The Multi-Lingual Publishing Pack

jmk · 2007-08-21 12:32:15

you know what, i tried to figure out where exactly the error is, and i put small “echo br,‘one’;” etc lines in the source. that showed me, that i do get an output from the first routine, namely:

SHOW GRANTS FOR 'db23543'@'mysql5.domain.tld';

which means, $rows isn’t empty, and understandably, the second routine is skiped.

right now i got to these lines (thats around line 4535):

if( !empty( $rows ) )
{
echo br,'one';
$rows = $this->strip_pws( $rows );
if( $debug ) 
{
echo br,'two';
echo dmp( $rows );
echo br,'three';
}

and i get this output

one
two
array (
  0 => 'GRANT USAGE ON *.* TO \'db23543\'@\'mysql5.domain.tld\' IDENTIFIED BY PASSWORD \'****************\'',
)
three

does that make any sense to you?

Last edited by jmk (2007-08-21 12:35:22)

ruud · 2007-08-21 12:43:28

Without spending more time on it, that doesn’t make sense to me. If I were you, I’d just short-circuit the can_install function by making it return ‘true’ at the beginning, since you already know for sure that the grants it checks for are present (your webhost told you).

jmk · 2007-08-21 12:56:34

yup, it is strange indeed! it seems as if this line

$rows = @getThings( $sql )

doesn’t return what is expected. what is that, btw? how should this line look like (maybe others can help)?

the short circuiting is an option, but for the sake of others, i wanted to find the root of the problem.

jmk · 2007-08-21 13:10:29

ah, i found out, that i was a little wrong i my earlier post. the output ist not

SHOW GRANTS FOR 'db23543'@'mysql5.domain.tld';

but it is

array (
  0 => 'GRANT USAGE ON *.* TO \'db23543\'@\'mysql5.domain.tld\' IDENTIFIED BY PASSWORD \'****************\'',
)

non the less, there should evidently be another line which should say something like

array (
  0 => 'GRANT USAGE ON *.* TO \'dbo200884203\'@\'%\' IDENTIFIED BY PASSWORD \'****************\'',
  1 => 'GRANT ALL PRIVILEGES ON `db200884203`.* TO \'dbo200884203\'@\'%\'',
)

usuario · 2007-08-22 11:27:15

I have a clean instalation of TXP 4.0.5 (r2466) but when installed a MLP i get a Fatal error with zem_contact_lang-mlp and clean_url_data_failed

1. Fatal error when active zem_contact_lang-mlp plugin and browsing my site:

Fatal error: Cannot redeclare zem_contact_gtxt() (previously declared in /var/www/vhosts/xxxx.xx/subdomains/txp/httpdocs/textpattern/lib/txplib_misc.php(534) : eval()’d code:2) in /var/www/vhosts/xxxx.xx/subdomains/txp/httpdocs/textpattern/lib/txplib_misc.php(534) : eval()’d code on line 75

2. clean_url_data_failed with MLP

My Pre-flight check:

Textpattern version: 4.0.5 (r2466)
Last Update: 2007-08-14 11:03:30/2007-08-14 10:58:08
Document root: /var/www/vhosts/xxxx.xx/subdomains/txp/httpdocs
$path_to_site: /var/www/vhosts/xxxx.xx/subdomains/txp/httpdocs
Textpattern path: /var/www/vhosts/xxxx.xx/subdomains/txp/httpdocs/textpattern
Permanent link mode: section_id_title
open_basedir: /var/www/vhosts/xxxx.xx/subdomains/txp/httpdocs:/tmp
Temporary directory path: /tmp
Site URL: txp.xxxx.xx
PHP version: 5.0.4
GD Image Library: bundled (2.0.28 compatible); supported formats: GIF, JPG, PNG.
Server Local Time: 2007-08-22 12:57:01
MySQL: 4.1.20
Locale: en_GB.UTF-8
Server: Apache/2.0.54 (Fedora)
Apache version: Apache/2.0.54 (Fedora)
PHP Server API: apache2handler
RFC 2616 headers:
Server OS: Linux 2.6.17-1.2142_FC4smp
Active plugins: rss_admin_db_manager-4.3, ign_password_protect-0.4.2d, mem_self_register-0.8.3, asy_wondertag-0.5, zem_contact_reborn-4.0.3.20-t, zem_contact_lang-4.0.3.6, pap_contact_cleaner-0.1, gbp_admin_library-0.4.581, TXPhorum-0.2, l10n-0.6.600

Pre-flight check:
————————————
Some Textpattern files are out of date: /lib/txplib_db.php
clean_url_data_failed: ?
————————————

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

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: utf8
character_set_results: utf8
character_set_server: latin1
character_set_system: utf8
character_sets_dir: /usr/share/mysql/charsets/
17 Tables: -

PHP extensions: yp, xml, wddx, tokenizer/0.1, sysvshm, sysvsem, sysvmsg, standard/5.0.4, SPL, sockets, SimpleXML, shmop, session, pspell, posix, pcre, mime_magic/0.1, iconv, gmp, gettext, ftp, exif/1.4 $Id: exif.c,v 1.162.2.8 2005/03/17 17:20:35 iliaa Exp $, dio/0.1, dbx, curl, ctype, calendar, bz2, zlib/1.1, openssl, libxml, apache2handler, dom/20031129, gd, imap, ldap, mbstring, mysql, mysqli/0.1, SQLite, xsl/0.1, ionCube Loader

Apache modules: core, prefork, http_core, mod_so, mod_access, mod_auth, mod_auth_anon, mod_auth_dbm, mod_auth_digest, util_ldap, mod_auth_ldap, mod_include, mod_log_config, mod_logio, mod_env, mod_cern_meta, mod_expires, mod_deflate, mod_headers, mod_usertrack, mod_setenvif, mod_mime, mod_dav, mod_status, mod_autoindex, mod_asis, mod_info, mod_dav_fs, mod_vhost_alias, mod_negotiation, mod_dir, mod_actions, mod_speling, mod_userdir, mod_alias, mod_rewrite, mod_proxy, proxy_ftp, proxy_http, proxy_connect, mod_cache, mod_suexec, mod_disk_cache, mod_file_cache, mod_mem_cache, mod_cgi, mod_fpcgid, mod_jk, mod_perl, mod_php5, mod_python, mod_ssl

pretext_data: 376b889940bfa6fd696416dc9d47f083
array ( ‘id’ => ‘’, ‘s’ => ‘’, ‘c’ => ‘’, ‘q’ => ‘’, ‘pg’ => ‘’, ‘p’ => ‘’, ‘month’ => ‘’, ‘author’ => ‘’, ‘request_uri’ => ‘/a13766419129f1c19333cd744a6a14ac/?txpcleantest=1’, ‘qs’ => ‘txpcleantest=1’, ‘subpath’ => ‘\\/’, ‘req’ => ‘/a13766419129f1c19333cd744a6a14ac/?txpcleantest=1’,
)

/include/txp_category.php: r2243 (3706fea923cd77f7053f7803de169df4)
/include/txp_plugin.php: r1917 (c63f72f33986c08367672fc9fe7b42dd)
/include/txp_auth.php: r2356 (33255ec1ea1a825163c78272496d8783)
/include/txp_form.php: r1913 (ecea3fecf9d7d1f8088cda67f097eceb)
/include/txp_section.php: r1891 (1f0121b3e2969d94bc8a7fb98bfdfbd5)
/include/txp_tag.php: r2260 (1bd67bdb9dcfb72e34ea967e39406216)
/include/txp_list.php: r2450 (997a3b1bec7115bf49b76f62b28da146)
/include/txp_page.php: r2099 (56bde34b6c7bcb9123ac91e73065e894)
/include/txp_discuss.php: r2451 (91e0b29ef39a9471ae5c78d0b1bba086)
/include/txp_prefs.php: r2405 (a4b76476930b2376199f23fbfd5f1ac9)
/include/txp_log.php: r2439 (16730c34e2a437dd88b8f5cc7eff8218)
/include/txp_preview.php: r1238 (696728f35f3557b648c011bb4d6496c3)
/include/txp_image.php: r2439 (9fac6ed0d9d4c3d8196492051f38dc9a)
/include/txp_article.php: r2453 (bdac8fcac5df2f93f10afa7e50c3fb6f)
/include/txp_css.php: r2403 (4e8c52bb1cf5bfe2e2f0640892f9b92e)
/include/txp_admin.php: r2403 (f8700a3d453ece08e7f137b47c967eda)
/include/txp_link.php: r2463 (0a0171bf606296106332d3fdcb83a678)
/include/txp_diag.php: r2361 (dccf3269049dd25e59afdd7ad8d235cd)
/include/txp_file.php: r2403 (e62abd5fcadabe629322ed17135d89eb)
/include/txp_import.php: r1238 (70a6207c0f3604ecfc4b20369986c4d7)
/lib/admin_config.php: r1747 (a2eb09f94d7902a6e95750fc4abcea17)
/lib/txplib_misc.php: r2464 (615afd44a10311f1c0b7852d9bc15d24)
/lib/taglib.php: r1535 (9b519f9dc88791e5ee8eacc029dd6975)
/lib/txplib_head.php: r2404 (2e067b25997cf67cddbdd365570e69d5)
/lib/classTextile.php: r2462 (a031e2ea894e339711c601f230c5ee71)
/lib/txplib_html.php: r2403 (97e173da3058b438513df67fd7d1ceca)
/lib/txplib_db.php: r1879 (125d6835470af76be4b0b369533e25cf)
/lib/IXRClass.php: r765 (137b91497628f0058a2fca9eba5c3b7f)
/lib/txplib_forms.php: r2403 (438a734b52acef40b36d8a3ba23987e8)
/lib/class.thumb.php: r2329 (b2a2fda54371dbd6c40ba553941f090e)
/lib/constants.php: r2361 (ab6d51668fab1e3c98e7d520b1a59f0f)
/lib/txplib_update.php: r1239 (10f28a986d23187b436369dc29ab552f)
/lib/txplib_wrapper.php: r2286 (419125ec74a17a70bf1e86ebfcd45253)
/publish/taghandlers.php: r2444 (cc9de8f2018b01398a2ba542c5f5bdc6)
/publish/atom.php: r2402 (46c4402717f695fde0d49d806adfa4c4)
/publish/log.php: r1637 (5254d0f3942086bc55723923307a51db)
/publish/comment.php: r2460 (2d1ae1dec0784f044e7005fa5ed50930)
/publish/search.php: r1748 (8c86ebcb5be08e214d81ca15a32164ca)
/publish/rss.php: r2393 (09aac29bf22ffa71c1e118e851cff3c3)
/publish.php: r2436 (7087864f1e7c6efe096d3b8e07c350b1)
/index.php: r2466 (30ecf35de5c1edc6ef68e780c8c79daa)
/css.php: r944 (8beba8f83a091068723435cdcdc02f2f)

Can anyone help? thanks.

ruud · 2007-08-22 11:33:39

usuario, uninstall the zem_contact_lang plugin, because zem_contact_lang-mlp replaces it.

The clean_url thing may be related to the “BOM” issue (see earlier in this topic).

Last edited by ruud (2007-08-22 11:43:10)

usuario · 2007-08-22 11:44:39

thanks a lot !

usuario · 2007-08-22 17:18:10

ruud wrote:

Hmm.. I’ve just downloaded the MLP pack.
/textpattern/lib/l10n_base.php has a BOM at the beginning. Because that’s before the <?php tag and assuming that file is loaded on each page load before the template is used, that BOM is sent to the browser before the template is parsed (the BOM is at the very beginning of the page as it arrives in the browser, before the DOCTYPE).

Try the notepad trick with that file: open it in notepad -> save as type ANSI (it should be 3 bytes smaller) -> upload it to your site, replacing the original l10n_base.php file.

I follow the instructions ( the file is not 3 bytes smaller) but the clean_url_data_failed with MLP persist.

ruud · 2007-08-22 17:28:21

Is it just the clean url test that fails, or do clean urls not work on your website (the first doesn’t necessarily imply the second).

usuario · 2007-08-22 17:42:22

The clean urls works on my site (3 pages and 3 languages: archive, default, error_default), but the clean url test that fails.
The problem is an error on the test?

marios · 2007-08-22 18:58:10

There is one Bug that I found, that might lead to confusion. ( That’s with TXP 4.05 ).
It has to do with the lang select on the Content Write Tab. It happens, when I am editing an already existing article ( Let’s say a rendition, that is not in the default language. A clone thereof. )

The lang autoselect feature does not work in my setup, when switching from such a rendition in the MLP articles table to Content Write, causing confusion, when the lang select dropdown isn’t manually selected to its correct language.

Allthough the error_message:

Error, a rendition already exists in that language

appears, while resaving the article, what happens is that the lang codes in the I10_lang column of the correspendant l10n_txp_xx_xx

( I’m getting a 2KB overhad as a result in that lang table too)

table will be altered in the db, which will then lead to wrong pagecontent-rendering on the frontend in a language, that isn’t supposed to appear.

In the meantime, I assumed, that manually correcting those values fixes the Issue..

I haven’t looked yet at the values in I10_articles yet. ( May be those get altered to )

regards, marios

Last edited by marios (2007-08-22 19:11:48)

marios · 2007-08-22 22:50:41

One more thought on the article/rendition subject:

I think it would make sense to also have one additional tag to enable a default rendition to be rendered on all localized pages.
Sometimes you want to display an add or some content, that stays the same for all languages, using an article form instead of an output form.

The tag could look like this:

<txp:mlp_enable_pagerendering>
	<!-- article (called by id) to be rendered in all languages  -->
    </txp:mlp_enable_pagerendering>

Since the ID numbers are unique for all renditions and are currently not rendered in other languages than itself, I think that this would make sense.

(Just a thought )

regards, marios

Last edited by marios (2007-08-22 22:52:46)

Textpattern CMS

Textpattern CMS support forum

#337 2007-08-21 12:32:15

Re: MLP - The Multi-Lingual Publishing Pack

#338 2007-08-21 12:43:28

Re: MLP - The Multi-Lingual Publishing Pack

#339 2007-08-21 12:56:34

Re: MLP - The Multi-Lingual Publishing Pack

#340 2007-08-21 13:10:29

Re: MLP - The Multi-Lingual Publishing Pack

#341 2007-08-22 11:27:15

Re: MLP - The Multi-Lingual Publishing Pack

#342 2007-08-22 11:33:39

Re: MLP - The Multi-Lingual Publishing Pack

#343 2007-08-22 11:44:39

Re: MLP - The Multi-Lingual Publishing Pack

#344 2007-08-22 17:18:10

Re: MLP - The Multi-Lingual Publishing Pack

#345 2007-08-22 17:28:21

Re: MLP - The Multi-Lingual Publishing Pack

#346 2007-08-22 17:42:22

Re: MLP - The Multi-Lingual Publishing Pack

#347 2007-08-22 18:58:10

Re: MLP - The Multi-Lingual Publishing Pack

#348 2007-08-22 22:50:41

Re: MLP - The Multi-Lingual Publishing Pack

Board footer