MLP - The Multi-Lingual Publishing Pack

net-carver · 2007-02-16 18:39:29

Zanza

Do you have a pre 4.1.2 version of MySQL?

If so, can you try editing the /lib/l10n_admin_classes.php file and change line 4460 from…

$sql = “SHOW GRANTS;”;

to…

$sql = “SHOW GRANTS FOR ‘$user’@’”.$txpcfg[‘host’].”’;”;

Looks like pre 4.1.2 MySQL doesn’t accept the simple form.

Please let me know if that fixes it for you.

Last edited by net-carver (2007-02-16 18:39:53)

lee · 2007-02-17 00:10:48

The Articles column in the MLP tab is not updated if the primary language article title changes.

Zanza · 2007-02-17 11:12:12

net-carver wrote:

*Zanza*Do you have a pre 4.1.2 version of MySQL?

Yes.

If so, can you try editing the /lib/l10n_admin_classes.php file and change line 4460 from… $sql = “SHOW GRANTS;”; to… $sql = “SHOW GRANTS FOR ‘$user’@’”.$txpcfg[‘host’].”’;”;

Now the error message disappear, but still the wizard tell me that the user doesn’t have all privileges on localhost and that wizard can’t run. :-(

I checked once more in my control panel, and the user does have all privileges. The only thing I noted is that the user has privileges on the specific database name, while your plugin is checking on ‘localhost’. I tried manually change this, but with no luck.

Don’t know if this could be a issue.

Z.

guiguibonbon · 2007-02-17 13:09:15

Same problem as Zanza over here. Going to check what could be happening too. Steve, about the section issue and concerning your email, i’ve changed everything, so there’s not much use in sending the dump of my txp_section table. I’ll try to reproduce it in a while, when i’ll have a bit less urging work.

guiguibonbon · 2007-02-17 13:25:21

Ok, I did the following:

skipped the can_install() function by having it returning “true” whatever happens

Result :

Many more points succeed in the wizard than previously, but not all yet. Points that fail : 1.1 , 1.2, 5.6 -> 5.9, 5.15 -> 5.22, 6

It also gives this error :

A problem occured while loading the plugin: l10n -> User_Warning: Table ‘promateria_be.abc_l10n_articles’ doesn’t exist
insert into abc_l10n_articles set `names`=‘First Post’, `members`=‘a:1:{s:5:“en-gb”;s:1:“1”;}’ on line 117

which makes sense since it failed at installing that table.

UPDATE: I made the SQL query about the privileges, which tells me the user has all privileges. Conclusion : I guess there both are erros in the can_install() function and in the wizard, e.g. the failures in the wizard are not due to unsufficient privileges. I’ll keep digging into it.

UPDATE II: I think I have the can_install error; see there’s something i don’t get in the whole process. Once it reaches the check_row() function, in my cases the row says “ GRANT ALL PRIVILEGES ON `[db]`.* TO ‘[user]’@‘localhost’ “. The function performs all sorts of tests on it if “GRANT ALL PRIVILEGES” is not foud, but there’s no else {}. Shouldn’t it be something like :

if( false === strpos( $row , ‘GRANT ALL PRIVILEGES’ ) ) {…} else return true;

?? I’m not getting how this only occurs with me and Zanza though. But hey, I haven’t ever worked with mysql privileges, so I’m not really the one to know.

UPDATE III: Regarding wizard step 1.1 & 1.2: it’s still that good’ol charset problem. I’ve run the query manually, even with the correct charset (latin1 in my case) – it doesn’t accept it. I just stripped it, it now works of course. Going to check what’s up with the other steps.

UPDATE IV: It now says step 3 doesn’t work, I guess that’s because it’s done already.

UPDATE V: Right… well basicaly all errors came down to the charset problem again. I just made the charset function to return ‘’; the wizard still indicated errors, but by now that was all due to the steps already having been done. I closed my browser, then restarted it and reconnected, the plugin was working, yet again with the article tab and rendition tab not working. Deja-vu. I’m now going to do a new install, and empty out those bugging functions from the beginning, just to make shure if the two misfunctioning tabs are due to a bad install or are real bugs.

UPDATA VI: Real bug. Install went brilliantly, tabs still not rendering.

Last edited by guiguibonbon (2007-02-17 15:54:39)

net-carver · 2007-02-17 15:50:49

Zanza

Now the error message disappear, but still the wizard tell me that the user doesn’t have all privileges on localhost and that wizard can’t run. :-(

Ok. What privilage does it say is missing? Can you email me the installer message that appears for you?

The only thing I noted is that the user has privileges on the specific database name, while your plugin is checking on ‘localhost’. I tried manually change this, but with no luck.

That ‘localhost’ is the machine running the MySQL server, not the particular DB in question.

The check routine will then parse all the returned privilages until it finds the ones for the DB that TxP is using and check those so it should find your privilages ok.

For now you could go down the same route as guiguibonbon and try overriding this check and see what happens. To do that just change line 4335 of l10n_admin_classes,php from…

$can_setup_cleanup = $this->can_install();

to…

$can_setup_cleanup = true;

guiguibonbon · 2007-02-17 15:58:02

Zanza:

and afterwards go to line 92 in l10n_base.php and replace

return $result;

to

return ‘’;

Last edited by guiguibonbon (2007-02-17 15:58:18)

guiguibonbon · 2007-02-17 15:59:53

Steve:

where are the functions for rendering the write tab? I’m going to comment out pieces of code one by one to see where the problem is.

Last edited by guiguibonbon (2007-02-17 16:04:12)

net-carver · 2007-02-17 16:04:47

guiguibonbon

I’ll email them over to you.

Last edited by net-carver (2007-02-17 16:05:12)

narf · 2007-02-17 18:21:03

Hello all,

are they any hints for getting this very nice pack to work under my environment? Its complaining about missing myQSL User privileges at setup… (i double checked the privileges…), i was using the latest release for MLP (15-02-2007).

Textpattern version: 4.0.4 (r1956)
Last Update: 2007-02-13 11:52:45/2007-02-13 11:48:36
(…)
PHP version: 4.4.4
Register globals: 1
MySQL: 4.0.27-standard-log
Locale: en_GB.UTF-8
Server: Apache/1.3.33 (Unix)
PHP Server API: cgi
RFC 2616 headers:
Server OS: Linux 2.4

Unfortunately i created the TXP database as en-iso-8859-1 instead of en-utf-8 :-(. Would you recommend creating a clean Setup with UTF-8 before installing the MLP Pack?

thx for hints!
N.

colak · 2007-02-17 18:55:41

started experimenting with the plugin/mod on my local host… Here are the specs

Last Update: 2006-11-09 08:45:30/2006-08-31 15:47:57
Document root: /Applications/MAMP/htdocs
$path_to_site: /Applications/MAMP/htdocs/neme
Textpattern path: /Applications/MAMP/htdocs/neme/textpattern
Permanent link mode: id_title
upload_tmp_dir: /Applications/MAMP/tmp/php
Temporary directory path: localhost:8888/neme/textpattern/tmp
Site URL: localhost:8888/neme
PHP version: 5.1.4
Server Local Time: 2007-02-17 20:38:22
MySQL: 5.0.19
Locale: en_GB
Server: Apache/2.0.55 (Unix) PHP/5.1.4 DAV/2 mod_ssl/2.0.55 OpenSSL/0.9.7l
Apache version: Apache/2.0.55 (Unix) PHP/5.1.4 DAV/2 mod_ssl/2.0.55 OpenSSL/0.9.7l
PHP Server API: apache2handler
RFC 2616 headers:
Server OS: Darwin 7.9.0

These are the errors I get

front end

Fatal error: Cannot redeclare _check_version() (previously declared in /Applications/MAMP/htdocs/neme/textpattern/lib/txplib_misc.php(459) : eval()’d code:634) in /Applications/MAMP/htdocs/neme/textpattern/lib/txplib_misc.php(459) : eval()’d code on line 96

login page/write tab and a number of other tabs but not the plugin tab where I have disabled all except the ones coming with mlp

A problem occured while loading the plugin: gbp_admin_library -> Notice: Constant gbp_id already defined on line 4
Fatal error: Class ‘GBPAdminView’ not found in /Applications/MAMP/htdocs/neme/textpattern/lib/txplib_misc.php(459) : eval()’d code on line 12

It is not an emergency for us to have the plugin live but I would like to sort out the problems well ahead of that time:)
I’ve seen the plugin working in other sites so I know that it is going to be one of those invaluable ones to have…

Last edited by colak (2007-02-17 18:56:36)

net-carver · 2007-02-17 19:47:21

narf

are they any hints for getting this very nice pack to work under my environment?

At the moment I would recommend not running this on anything earlier than MySQL 4.1 — I’m working with guiguibonbon to straighten things out with MySQL 4.0.x

net-carver · 2007-02-17 19:50:05

colak

can you email me your diagnostics set to ‘high’ — that looks like a conflict with another plugin you have installed.

net-carver · 2007-02-18 01:03:33

All

WIll be posting more regular development snapshots on my site. Thanks to guiguibonbon’s help we have identified some issues on MySQL 4.0.x platforms and there are some more to go yet.

Zanza

You should find the latest snapshot fixes the problem with the ‘missing’ privilages problem.

colak · 2007-02-18 07:33:23

net-carver wrote:

colak
can you email me your diagnostics set to ‘high’ — that looks like a conflict with another plugin you have installed.

Hi steve, You are right… I woke up this morning and rechecked it. I thought that I have disabled all the plugins except those of the mlp pack but I had the gbp_l10n enabled as I mistakenly identified it as being a part of the pack. I guess that it conflicted with the l10n plugin. I can now see all tabs and I will start enabling the plugins one by one so as to check if there any further conflicts.

Textpattern CMS

Textpattern CMS support forum

#76 2007-02-16 18:39:29

Re: MLP - The Multi-Lingual Publishing Pack

#77 2007-02-17 00:10:48

Re: MLP - The Multi-Lingual Publishing Pack

#78 2007-02-17 11:12:12

Re: MLP - The Multi-Lingual Publishing Pack

#79 2007-02-17 13:09:15

Re: MLP - The Multi-Lingual Publishing Pack

#80 2007-02-17 13:25:21

Re: MLP - The Multi-Lingual Publishing Pack

#81 2007-02-17 15:50:49

Re: MLP - The Multi-Lingual Publishing Pack

#82 2007-02-17 15:58:02

Re: MLP - The Multi-Lingual Publishing Pack

#83 2007-02-17 15:59:53

Re: MLP - The Multi-Lingual Publishing Pack

#84 2007-02-17 16:04:47

Re: MLP - The Multi-Lingual Publishing Pack

#85 2007-02-17 18:21:03

Re: MLP - The Multi-Lingual Publishing Pack

#86 2007-02-17 18:55:41

Re: MLP - The Multi-Lingual Publishing Pack

#87 2007-02-17 19:47:21

Re: MLP - The Multi-Lingual Publishing Pack

#88 2007-02-17 19:50:05

Re: MLP - The Multi-Lingual Publishing Pack

#89 2007-02-18 01:03:33

Re: MLP - The Multi-Lingual Publishing Pack

#90 2007-02-18 07:33:23

Re: MLP - The Multi-Lingual Publishing Pack

Board footer