MLP - The Multi-Lingual Publishing Pack

azw · 2008-02-08 07:44:49

FireFusion, have you edited any of the files included with Textpattern? Or have you added PHP to the default page template?

I think that message usually means that you have extra spaces or empty lines or just text characters before your PHP tag on that page.

Last edited by azw (2008-02-08 07:45:50)

brunodario · 2008-02-08 19:57:11

Hi there Steve, first of all, thx for this great Pack!

I´m having some dificulties when publishing articles as described here (This thread details more things, including the custom fields hack i´ve performed wich i belive is the cause of the error but don´t know how to workaround)

When i publish an article the following warning shows up:

Warning: Column count doesn’t match value count at row 1 REPLACE INTO _1l10n_txp_en_us SELECT * FROM _1textpattern WHERE _1textpattern.ID=‘8’ LIMIT 1 in /home/santaluzlingerie/public_html/textpattern/lib/txplib_db.php on line 117

I´m a HTML coder/ Webdesigner wich means that anything related to DB issues is not familiar to me. I´ve started to take more atention to this after using Textpattern. If this is related to MLP, please give me some clues

Last edited by brunodario (2008-02-08 20:19:12)

FireFusion · 2008-02-08 21:20:49

It’s ok my problem was fixed. Just had to reupload some of the files.

net-carver · 2008-02-09 06:27:06

FireFusion

Thank you for the update.

brunodario

Yes, somethings definitely messed up with that SQL, no wonder it won’t work. Looks like something (perhaps the custom fields hack) is prepending a “_1” to the table names.

Please get in contact if you are still having problems.

AndrijaM · 2008-02-09 15:31:10

Hi,
after instaling MLP have the following errors:

Change the txp_lang table…

1. Extend `txp_lang.data` from TINYTEXT to TEXT : Done
2. Add the `txp_lang.l10n_owner` field : Failed

Add the per-language article tables…

1. Add the Srpski [l10n_txp_sr_rs] table : Failed
2. Add the English (GB) [l10n_txp_en_gb] table : Failed
3. Add the Русский [l10n_txp_ru_ru] table : Failed

It is a fresh new txp instalation, no other plugins, no articles, just the default settings. What could be the problem?

Also, I am wandering, if I have a 3 language web site, is it possible to customise everything on every version, not just articles, but for instance, if I want to put a different logo on every version, how would I do that?
Is there maybe some list of web sites using MLP, I only saw the demonstration site.

Thanks!

Last edited by AndrijaM (2008-02-09 15:32:04)

azw · 2008-02-10 09:41:40

If I select Spanish as the “Currently Active Language” in Admin > Preferences > Language, the page labels become Spanish when I save the selection. But as soon as I go to another tab in the back end, the labels are displayed in English again. The odd thing is that the Currently Active Language is still set as Spanish.

Is this a problem I can fix?

brunodario · 2008-02-11 13:18:04

Steve, thanx for the support.

I didn´t “solved” my problem but i prefered to restore the DB and work with another kind of custom field solution instead of trying to make the hack work.

An update: The txp tag <txp:newer/> and <txp:older/> aren´t working. They return blank links.
I´ve already restored my DB and i don´t belive this is the hack faults anymore. Any clues?

Last edited by brunodario (2008-02-11 20:21:33)

azw · 2008-02-11 17:56:40

AndrijaM wrote:

… after instaling MLP have the following errors:
Change the txp_lang table…
2. Add the `txp_lang.l10n_owner` field : Failed
Add the per-language article tables…
1. Add the Srpski [l10n_txp_sr_rs] table : Failed
2. Add the English (GB) [l10n_txp_en_gb] table : Failed
3. Add the Русский [l10n_txp_ru_ru] table : Failed

Hello, AndrijaM,

Those errors probably mean that you don’t have proper permissions set for your database. I think the “user” you list in your config file has to have all permissions. I don’t remember the names of all of the permissions, but they include things like: create, add, delete. If you have access to a database manager in your site’s control panel you probably can change the permissions there.

azw · 2008-02-11 20:40:01

AndrijaM, I’m once again able to look at my own Cpanel control panel now, so I’ll give you a few more tips. I think this will work for you, but let us know if it doesn’t.

If you can access your control panel, look for an option that says something like “MySQL Databases”. Go there. Probably at the bottom of that page, you’ll see a listing of the “Current Users”. On mine the only option is to delete a user.

If that’s what you find, too, perhaps the easiest solution would be to open your configuration file: config.php. Find the user name and password, which will look like this:

$txpcfg[‘user’] = ‘someName’;
$txpcfg[‘pass’] = ‘somePassword’;

(Obviously, the part within the quotes is what matters. Don’t copy the quotes or the rest of the code.)

Then go back to your control panel, delete the current user with that same name you found in config.php.
Next in the control panel’s database page, add a new user using the same user name and password as what is in your config.php file. When you do this, be sure to check “All” when you see an option to set the new user’s permissions (or maybe they’re called priviledges).

Of course, it’s possible that you don’t have the rights necessary to do this. If this doesn’t work, you may have to talk to your web host.’

AndrijaM · 2008-02-12 07:55:58

Thanks for helping, but I am working on a local server on my computer.
In mysql there is only one user, the root one, which if I’m not wrong, should have all permissions. The user in my config file is root. And with that user I instaled txp, which should mean that it can create tables, becouse everything is working.
edit:
just checked: show grants for root@localhost;
it has all privileges as it supposed to.

Last edited by AndrijaM (2008-02-12 08:09:55)

AndrijaM · 2008-02-13 17:44:15

Well, I dont know why this was not working, but after instaling apache, mysql and php with xampp, now instalation of mlp went well.
But I do have the following issue:

when I put <txp:l10n_lang_list /> on home page, a get a list of 3 different languages. I cloned one article on every three languages, just to have some article.
But, after clicking on some other languages I get the following error:

Object not found!

The requested URL was not found on this server… and something more.

What am I missing now?

marios · 2008-02-13 20:08:40

AndrijaM wrote:

when I put <txp:l10n_lang_list /> on home page, a get a list of 3 different languages. I cloned one article on every three languages, just to have some article.
But, after clicking on some other languages I get the following error:

What am I missing now?

There is actually nothing wrong with it. The Idea behind this from Steve’s side was, to not display lang list link items, in cases, where there is no localized content available.

So for instance, let’s say, you have set up three languages, and you had cloned into the other two without setting to live, the default behavior, is to not output any links and in case the URL get’s requested to generate a 404 Pageheader.
(URL only titles should also be changed for each localized version)

May be I misunderstood something about what you meant?

regards, marios

AndrijaM · 2008-02-14 10:51:25

Ok now, something is definitly not wright, becouse I did everything like in the 23 min admin demo. I even used the same languages english and greek, and again there’s something with the urls:

Object not found!
The requested URL was not found on this server…

Also, I tried with messy urls and with section/title – same thing again.

I have cloned the default article that comes with txp instaltation, and put it in status live, no draft.
Also, I am using the 4.0.6 version maybe its got something to do with that? And I’m on the local server using xampp.

(URL only titles should also be changed for each localized version) they are changed.

Any suggestions?

Last edited by AndrijaM (2008-02-14 11:02:52)

els · 2008-02-14 18:15:14

AndrijaM wrote:

I am using the 4.0.6 version maybe its got something to do with that?

See here…

maniqui · 2008-02-16 22:53:38

net-carver wrote about MLP and 4.0.6 compatibility:

not asked before (I think) and not yet.

I’ve compared 4.0.5 txplib_db.php (rev. 2406) and 4.0.6 txplib_db.php (rev. 2784). There are just minor changes.

Also, I have been looking for differences between MLP txplib_db.php (based on rev. 1879) and 4.0.6 txplib_db.php (rev. 2784). There aren’t too many differencies, aside from those introduced by MLP and those between 4.0.5 and 4.0.6 versions of that file.

So, the question is: if I just merge the changes on MLP txplib_db.php version with 4.0.6 version of the same file… would that just be enough to make MLP compatible with 4.0.6?

Or there are other major things I’m ignoring?

I guess I will have to try! I’ll come back and report.

Last edited by maniqui (2008-02-16 22:55:35)

Textpattern CMS

Textpattern CMS support forum

#616 2008-02-08 07:44:49

Re: MLP - The Multi-Lingual Publishing Pack

#617 2008-02-08 19:57:11

Re: MLP - The Multi-Lingual Publishing Pack

#618 2008-02-08 21:20:49

Re: MLP - The Multi-Lingual Publishing Pack

#619 2008-02-09 06:27:06

Re: MLP - The Multi-Lingual Publishing Pack

#620 2008-02-09 15:31:10

Re: MLP - The Multi-Lingual Publishing Pack

#621 2008-02-10 09:41:40

Re: MLP - The Multi-Lingual Publishing Pack

#622 2008-02-11 13:18:04

Re: MLP - The Multi-Lingual Publishing Pack

#623 2008-02-11 17:56:40

Re: MLP - The Multi-Lingual Publishing Pack

#624 2008-02-11 20:40:01

Re: MLP - The Multi-Lingual Publishing Pack

#625 2008-02-12 07:55:58

Re: MLP - The Multi-Lingual Publishing Pack

#626 2008-02-13 17:44:15

Re: MLP - The Multi-Lingual Publishing Pack

#627 2008-02-13 20:08:40

Re: MLP - The Multi-Lingual Publishing Pack

#628 2008-02-14 10:51:25

Re: MLP - The Multi-Lingual Publishing Pack

#629 2008-02-14 18:15:14

Re: MLP - The Multi-Lingual Publishing Pack

#630 2008-02-16 22:53:38

Re: MLP - The Multi-Lingual Publishing Pack

Board footer