Textpattern CMS

#316 2007-08-07 14:43:47

filip baraka

Member

Registered: 2006-06-05

Posts: 24

Re: MLP - The Multi-Lingual Publishing Pack

will try everything from scratch
posting my results asap

#317 2007-08-08 18:28:03

cnolle

Archived Plugin Author

Registered: 2004-03-21

Posts: 87

Website

Re: MLP - The Multi-Lingual Publishing Pack

Doing a site at the moment using MLP and have had to use TXP 4.04 to get it all working and I have come across a rather bizarre problem.

For some reason MLP adds a blank line at the top of all HTML pages that it is used on, which is not a problem in any browser except internet explorer on the MAC where a question mark is inserted on the blank line which breaks up the page.

Seems its a problem on other MLP sites as well. None of my other sites that have been designed using TXP allone have this issue. Anyway just wondering if anyone has encountered this oddity?

/Christian

Last edited by cnolle (2007-08-08 18:31:03)

#318 2007-08-08 18:50:43

ruud

Developer Emeritus

From: a galaxy far far away

Registered: 2006-06-04

Posts: 5,068

Website

Re: MLP - The Multi-Lingual Publishing Pack

christian, that may be caused by the BOM at the beginning of the document. Follow the link to find out how to remove it.

#319 2007-08-08 19:11:34

cnolle

Archived Plugin Author

Registered: 2004-03-21

Posts: 87

Website

Re: MLP - The Multi-Lingual Publishing Pack

I am pretty sure its MLP which causes it. I don’t have this problem on any other site that uses textpattern (i.e. without MLP). I am digging my way through all the code at the moment to see if I can spot the problem somewhere.

/Christian

#320 2007-08-08 19:14:48

ruud

Developer Emeritus

From: a galaxy far far away

Registered: 2006-06-04

Posts: 5,068

Website

Re: MLP - The Multi-Lingual Publishing Pack

cnolle… stop digging for a moment and read the previous few posts. Might save you some time ;)

#321 2007-08-08 21:01:43

cnolle

Archived Plugin Author

Registered: 2004-03-21

Posts: 87

Website

Re: MLP - The Multi-Lingual Publishing Pack

Ahh thank you, was too quick there.

Now I have 500 internal server errors though so don’t know if it solved the problem.

Edit: Got it all to work, the BOM trick solved my problem with IE for the MAC.

/Christian

Last edited by cnolle (2007-08-08 21:18:10)

#322 2007-08-09 13:35:00

beztak

Member

From: Czech Republic

Registered: 2005-07-21

Posts: 184

Website

Re: MLP - The Multi-Lingual Publishing Pack

Does anybody know why MLP total kills DOC file?

Last edited by beztak (2007-08-09 13:35:22)

---

Job: Plugo – tvorba eshopu
Projects: Czech free fonts

#323 2007-08-17 14:21:09

filip baraka

Member

Registered: 2006-06-05

Posts: 24

Re: MLP - The Multi-Lingual Publishing Pack

Got some results:)
still under Sections i see only one language under “Section Title [English]”
Categories are ok: displaying both langs
solutions?

Last edited by filip baraka (2007-08-17 14:22:02)

#324 2007-08-17 23:49:27

jmk

Member

Registered: 2006-09-04

Posts: 49

Re: MLP - The Multi-Lingual Publishing Pack

evening folks,
you are my last hope to get this plugin to work. i have tried everything, different php version (4.4.1), different mysql version (4.x.21) different txp version (4.0.4 stable) it just doesn’t wanna play with me. and the error message doesn’t make sense to me. so in the hope some of you guys/gals have an idea what else i could try, i have posted the mlp-tab error message, and the diagnostic output.

thank you all,
jmk

1. It requires MySQL Privileges 1 SELECT, INSERT, UPDATE, DELETE, CREATE, CREATE TEMPORARY TABLES, ALTER, LOCK TABLES, INDEX, DROP or above, current install is missing privs – or grants on DB (`db23543` as `db23543`) cannot be evaluated.

Textpattern version: 4.0.5 (r2466)
Last Update: 2007-08-16 19:38:18/2007-08-16 19:18:22
Document root: /kunden/domain.tld/webseiten/subdomain
$path_to_site: /kunden/domain.tld/webseiten/subdomain
Textpattern path: /kunden/domain.tld/webseiten/subdomain/textpattern
Permanent link mode: section_title
Temporary directory path: /kunden/domain.tld/webseiten/subdomain/textpattern/tmp
Site URL: subdomain.domain.tld
PHP version: 5.2.1
Register globals: 1
GD Image Library: bundled (2.0.28 compatible); supported formats: GIF, JPG, PNG.
Server Local Time: 2007-08-18 01:06:14
MySQL: 5.0.41-log
Locale: en_GB.UTF-8
Server: Apache/1.3 (Unix) mod_ssl/2.8.28 OpenSSL/0.9.8d AuthPG/1.3
PHP Server API: cgi
RFC 2616 headers: 0
Server OS: Linux 2.4.34.1-grsec
Active plugins: glx_admin_image-2006.1a, bas_img_selector-0.71, mcw_templates-0.2, nhn_typotuner-0.1a, zem_contact_reborn-4.0.3.17, zem_contact_lang-4.0.3.03, bos_image_display-0.41, art_meta_description-0.1, rss_admin_db_manager-4.3, gbp_admin_library-0.4.581, l10n-0.6.600

Pre-flight check:
————————————
/kunden/domain.tldwebseiten/subdomaintextpattern/setup/ still exists
Some Textpattern files are out of date: /lib/txplib_db.php
————————————

.htaccess file contents:
————————————
RewriteEngine On
RewriteBase /

RewriteCond %{REQUEST_FILENAME} -f [OR]
RewriteCond %{REQUEST_FILENAME} -d
RewriteRule ^(.+) – [PT,L]

RewriteRule ^(.*) index.php
————————————

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

PHP extensions: libxml, xsl/0.1, xmlwriter/0.1, dom/20031129, xmlreader/0.1, xml, wddx, tokenizer/0.1, session, pcre, SimpleXML, soap, SPL, standard/5.2.1, Reflection, posix, pgsql, PDO, pdo_mysql/1.0.2, mysql/1.0, mhash, mcrypt, mbstring, json/1.2.1, imap, iconv, hash/1.0, gettext, gd, ftp, filter/0.11.0, exif/1.4 $Id: exif.c,v 1.173.2.5.2.11 2007/01/23 00:23:17 iliaa Exp $, dbase, dba, date/5.2.1, curl, ctype, calendar, bz2, bcmath, zlib/1.1, cgi, Zend Optimizer

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

#325 2007-08-18 08:04:39

ruud

Developer Emeritus

From: a galaxy far far away

Registered: 2006-06-04

Posts: 5,068

Website

Re: MLP - The Multi-Lingual Publishing Pack

jmk,
In your MySQL setup, there’s a database called ‘mysql’, containing a table called ‘db’. In that table the privileges mentioned in the error message have to be set to Y (yes) instead of N (No) for the user/db combination that you use for your textpattern install.

see also MySQL documentation on privileges

#326 2007-08-18 15:02:14

jmk

Member

Registered: 2006-09-04

Posts: 49

Re: MLP - The Multi-Lingual Publishing Pack

thanks for your answer, that was my first try, too. but i got this message back from my hoster:
——
Host: %
Db: db23543
User: db23543
Select_priv: Y
Insert_priv: Y
Update_priv: Y
Delete_priv: Y
Create_priv: Y
Drop_priv: Y
Grant_priv: Y
References_priv: Y
Index_priv: Y
Alter_priv: Y
Create_tmp_table_priv:
Lock_tables_priv: Y
Create_view_priv: Y
Show_view_priv: Y
Create_routine_priv: Y
Alter_routine_priv: Y
Execute_priv: Y
—-

#327 2007-08-18 15:17:14

ruud

Developer Emeritus

From: a galaxy far far away

Registered: 2006-06-04

Posts: 5,068

Website

Re: MLP - The Multi-Lingual Publishing Pack

Create_tmp_table_priv: … that should be set to Y

What happens if you add &debugwiz=1 or ?debugwiz=1 at the end of the query string when visiting the mlp-tab? And also switch your site status to ‘debug’. Both those things might provide some useful debug messages.

Last edited by ruud (2007-08-18 15:29:24)

#328 2007-08-18 15:42:54

jmk

Member

Registered: 2006-09-04

Posts: 49

Re: MLP - The Multi-Lingual Publishing Pack

ruud wrote:

Create_tmp_table_priv: … that should be set to Y

yup, it is, that was just a copy&paste error :)

What happens if you add &debugwiz=1 or ?debugwiz=1 at the end of the query string when visiting the mlp-tab? And also switch your site status to ‘debug’. Both those things might provide some useful debug messages.

finally i got a new method of getting information. thanks! alright, i got this output:

—-

Testing for privs to DB:`db23543` on Server:mysql5.domain.tld, v:5.0.41-log. Connected using user: db23543.

SHOW GRANTS FOR ‘db23543’@‘mysql5.domain.tld’;

Warning: There is no such grant defined for user ‘db23543’ on host ‘mysql5.domain.tld’ SHOW GRANTS FOR ‘db23543’@‘mysql5.domain.tld’; in /kunden/domain.tld/webseiten/subdomain/textpattern/lib/txplib_db.php on line 117

Initial SHOW GRANTS query failed, re-trying.

SHOW GRANTS;

There is no such grant defined for user ‘db23543’ on host ‘mysql5.domain.tld’

array ( 0 => ‘GRANT USAGE ON . TO \‘db23543\’@\‘ip_address\’ IDENTIFIED BY PASSWORD \’****************\’‘,
)

Mathed: string(69) “ privs – or grants on DB (`db23543` as `db23543`) cannot be evaluated”
——

does that help?

#329 2007-08-18 16:55:39

ruud

Developer Emeritus

From: a galaxy far far away

Registered: 2006-06-04

Posts: 5,068

Website

Re: MLP - The Multi-Lingual Publishing Pack

Ask your webhost why the SQL commands

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

and.

SHOW GRANTS;

don’t show grants but show this error instead: There is no such grant defined for user 'db23543' on host 'mysql5.domain.tld'

On second thought… is mysql5.domain.tld where your website is hosted or is it a dedicated MySQL server? In that case, try running SQL commands like:

SHOW GRANTS FOR 'db23543'@'name_of_server_where_your_website_is_hosted';
SHOW GRANTS FOR 'db23543'@'IP_number_of_server_where_your_website_is_hosted';
SHOW GRANTS FOR 'db23543'@'domain_name_of_your_website';

PS. if there’s a MySQL guru reading here, feel free to step in, because at this point I’m out of other ideas.

Last edited by ruud (2007-08-18 17:06:01)

#330 2007-08-18 19:43:56

jmk

Member

Registered: 2006-09-04

Posts: 49

Re: MLP - The Multi-Lingual Publishing Pack

thanks for your help so far, ruud, i really appreciate it! i gave my hoster the same error message, and so far no one has responded, so i/we will see.