MLP - The Multi-Lingual Publishing Pack

Bloke · 2016-12-12 19:21:21

spiridon wrote #303243:

Can I replace the renditions tables by views?

Never tried it, but I guess so. For the duplicated portions at least. Not sure how you’d do it though, because each rendition table holds content in its own language and points back to the master language. How would you control feed freshness, for example?

If you can get it to work with Views, then I’d love to see it working as it would simplify a lot of back-end code.

spiridon · 2016-12-13 17:08:12

I commented out some lines in the l10n_admin.php and l10n_admin_classes.php and create views – it works!

But this in txp 4.5.4… First, I will update txp to 4.6.2.

Of course I will share the results. I hope it will works!

Last edited by spiridon (2016-12-13 17:30:34)

spiridon · 2016-12-13 17:40:31

TXP 4.6.2 and last MLP – a small mistake:

l10n -> Notice: Undefined variable: installed_l10n_version on line 30
l10n -> Notice: Undefined variable: l10n_release_version on line 30

textpattern/lib/l10n_admin.php:14 Netcarver\MLP\Kickstart->l10n_upgrade()
textpattern/lib/txplib_misc.php(1782) : eval()'d code:402 include_once()
textpattern/lib/txplib_misc.php:1782 eval()
textpattern/index.php:194 load_plugins()

Last edited by spiridon (2016-12-13 17:48:31)

funtoosh · 2016-12-16 16:09:07

Hey there,
I have the same problem that giampablo stated before ( http://forum.textpattern.com/viewtopic.php?pid=302529#p302529 ), there is no way to fill in section titles for any but the default language.
How can I solve this? Where would these go in phpmyadmin?

Cheers,
-M

Manaus · 2016-12-20 09:08:48

Hallo, I’ve followed the suggested route for upgrading a 4.5.7 website to 4.6.2, and upgraded the MLP package with the latest from branch 4.6.x, but I get a broken homepage (content is missing), and in the admin side clicking on the renditions button yields a blank white page.
These are the steps I’ve taken:

disable plugins
logout
upgrade txp files
upgrade mlp files
login
install plugins via the ied_plugin_composer
enable mlp plugins
diagnosics
go in debug mode

In debug mode I see just:

l10n -> Notice: Undefined variable: installed_l10n_version on line 30
l10n -> Notice: Undefined variable: l10n_release_version on line 30

Thanks for any suggestion…

funtoosh · 2016-12-20 13:20:26

Manaus, can you tell us which PHP version you are using on that particular host? Maybe that’s what is causing the problem. Could it be 5.4 or below?
If possible, try selecting a higher version …

I had problems with the ied_plugin_composer-rendered files on one server as well.

Good luck,
-f

Manaus · 2016-12-20 18:06:24

Hi Funtoosh, yes it is the 5.4.10 one, might be that?

Manaus · 2016-12-21 17:21:48

Anyone can provide a rendered version of MLP 4.6.0 for a server running 5.3.29 on TXP 4.6.2? Thanks!!!!

Manaus · 2016-12-22 11:51:52

Hi, I just tried to start off scratch, downloading fresh versions of Txp 4.6.2 and MLP 4.6.0,

installed languages
installed ied_plugin_composer
installed MLP files
logged in
activated MLP plugins
run MLP wizard

and when I click on Renditions I get a blank page…

spiridon · 2016-12-22 13:12:34

That happened

Manaus, in Prefs, turn Production status in ‘Live’ or ‘Testing’

Last edited by spiridon (2016-12-22 13:14:00)

Bloke · 2016-12-22 13:22:56

Sorry for the hassles this is causing. I’ll try and fix it. Alternatively, anyone who fancies submitting any Pull Requests, please feel free to do so.

Bloke · 2016-12-22 13:41:51

Incidentally, the white screen thing is (I think) to do with the $trace functionality, which is why it goes away if you put the site in Live mode. But I cannot figure out why it occurs.

Anyone digging into error logs will probably find this:

PHP Fatal error:  Call to a member function start() on a non-object in /path/to/textpattern/lib/txplib_db.php on line 404.

Now, if you dump out the contents of q and trace just before that point in txplib_db.php:

echo ‘<pre>’;
var_dump($q, $trace);
echo ‘</pre>’;

you get a bunch of perfectly valid queries spewed to the page, followed by a bunch of trace info. But at some point, the trace info cuts off midway through. Like it’s running out of memory or resources or something and just dies. Then it kicks out that error message to the logs and Txp doesn’t render anything: white screen of death. What’s more bizarre, refreshing the page seems to cut the trace dump off at varying places.

If it was an escaping issue, it should fail consistently, but it doesn’t. I’m totally stumped. Anyone with any clues, please offer suggestions.

Manaus · 2016-12-22 14:53:28

Thanks spiridon, the only way it’s working is in live mode, the other two fail…

spiridon · 2016-12-29 19:02:11

Bloke wrote #303245:

If you can get it to work with Views, then I’d love to see it working as it would simplify a lot of back-end code.

Stef, I did it on my website.

I replaced tables by views

DROP TABLE l10n_txp_uk_ua;
CREATE VIEW l10n_txp_uk_ua AS SELECT * FROM textpattern WHERE l10n_lang='uk-ua';
DROP TABLE l10n_txp_ru_ru;
CREATE VIEW l10n_txp_ru_ru AS SELECT * FROM textpattern WHERE l10n_lang='ru-ru';

Then, in the file textpattern/lib/l10n_admin_classes.php I commented out some lines in the functions clone rendition, delete article and delete rendition.

In the front-end, nothing changes, does not work faster and not slower. In the back-end, I made changes only to make it work. I have not changed the code for creating tables (views) during the initialization of the plugin and not optimized queries (When you update the article to run UPDATE twice: for textpattern table and l10n_txp_LANG_CODE table)

I just wanted to reduce the volume DB. ( I have 98 megs was reduced to 50).

Сode can be found here: github.com/dshovchko/MLP/tree/v4.6.0.tables2views

If someone is interested I will finish the work.

PS. Also in the file textpattern/lib/l10n_admin.php I commented out the function call _l10n_create_temp_textpattern(). Nothing but freezes when you open the reditions list, it did not.

Last edited by spiridon (2017-01-23 18:18:16)

Bloke · 2016-12-29 20:12:05

spiridon wrote #303434:

I replaced tables by views

Awesome! I’ll check out your code, thank you.

If someone is interested I will finish the work.

Interested. Interested. Interested!

PS. Also in the file textpattern/lib/l10n_admin.php I commented out the function call _l10n_create_temp_textpattern().

The temporary tables cause nothing but trouble. If we can get rid of them, it’d be soooo much better. We also need to fix that bug/warning you found in the upgrade script. Need to find some time to do all this stuff. If you have some code or pull requests available to patch against the 4.6.0 branch, it would be a HUGE help.

Thank you for all the work you’ve put into this.

Textpattern CMS

Textpattern CMS support forum

#2371 2016-12-12 19:21:21

Re: MLP - The Multi-Lingual Publishing Pack

spiridon wrote #303243:

#2372 2016-12-13 17:08:12

Re: MLP - The Multi-Lingual Publishing Pack

#2373 2016-12-13 17:40:31

Re: MLP - The Multi-Lingual Publishing Pack

#2374 2016-12-16 16:09:07

Re: MLP - The Multi-Lingual Publishing Pack

#2375 2016-12-20 09:08:48

Re: MLP - The Multi-Lingual Publishing Pack

#2376 2016-12-20 13:20:26

Re: MLP - The Multi-Lingual Publishing Pack

#2377 2016-12-20 18:06:24

Re: MLP - The Multi-Lingual Publishing Pack

#2378 2016-12-21 17:21:48

Re: MLP - The Multi-Lingual Publishing Pack

#2379 2016-12-22 11:51:52

Re: MLP - The Multi-Lingual Publishing Pack

#2380 2016-12-22 13:12:34

Re: MLP - The Multi-Lingual Publishing Pack

#2381 2016-12-22 13:22:56

Re: MLP - The Multi-Lingual Publishing Pack

#2382 2016-12-22 13:41:51

Re: MLP - The Multi-Lingual Publishing Pack

#2383 2016-12-22 14:53:28

Re: MLP - The Multi-Lingual Publishing Pack

#2384 2016-12-29 19:02:11

Re: MLP - The Multi-Lingual Publishing Pack

Bloke wrote #303245:

#2385 2016-12-29 20:12:05

Re: MLP - The Multi-Lingual Publishing Pack

spiridon wrote #303434:

Board footer