Problem after new install

aberg · August 7th, 2009, 02:09 PM

I have make a new phrase.php file and have tried to install it in the database.
But that give a blanc screen after try to install this.
So first question is how I can import the new phrase.php file in the database.
It give a dupicatie error, but I have use the example italian file like this:

$query[] ="DELETE FROM {$pp_db_prefix}phrases WHERE langid=2;";
$query[] ="INSERT INTO {$pp_db_prefix}languages VALUES (2, 'Dutch', 'NL', 'UTF-8', 'ltr');";
$query[] = "INSERT INTO {$pp_db_prefix}phrases VALUES (1, 'admgrp1', 'Global Options', 'Global Options', '2');";
$query[] = "INSERT INTO {$pp_db_prefix}phrases VALUES (2, 'admgrp2', 'Admin Options', 'Admin Options', '2');";
$query[] = "INSERT INTO {$pp_db_prefix}phrases VALUES (3, 'admgrp3', 'Index Options', 'Index Options', '2');";

Next problem is the new installation.
After restore the database I get still the duplicate errors and a blanc screen.
So I have make a new installation.
There where no errors and I get in the admin screen where everythings seems to work fine.
But when I call the index files ( back to user index) I get a blanc screen (http-fault 500 Interne servererror)
I use the intergrate version (Vbulletin 3.8.3)
Any idea why I get the blanc screen ??

Chuck S · August 7th, 2009, 03:20 PM

How about we back up some

If you start with a fresh clean database and do a normal install do things work with the default english?

I need to really determine what your doing and what point things fail.

aberg · August 8th, 2009, 08:17 AM

Thanks for replay, you are right I'am a fool to forget back-up my database.
I'ts my fault and so I have to start over again.
First fault is found, also you have right that I must setting the default language on English and now it's working ok.

Now please support for input the Dutch language file.
I have included it here, so you can see what I have make now.
My question is how I now can put this file in the database.
I have try it to do it with the install script what is included photopost but that gives the problems.

I hope you can tell me what I now must do.
Thanks for support!

Chuck S · August 8th, 2009, 03:55 PM

well if your using a clean install and your file is correct to install a dutch language you should just be able to upload and run the actual modified phrases.php file

I see your file is not a translation its all english

There is another way to do it if you want to translate strings one at a time dont worry about this file just use the add a language thing in admin enter dutch and when you save the dutch entry it will clone all the language strings. You can then set the global language to dutch. then you can use the view language strings and change them one at a time.

aberg · August 9th, 2009, 12:04 PM

Thanks, I know not all english is translation to Dutch.
I have only the most users files translate.
In the administration is isn't a problem for me.
I have now install the program wiht the english phrase.php file.
What I now searching / want is to use the Dutch phrase.php I have translate.
If I use this I get the errors as above.

So please can you give me I idea to use this file?
If I do it trought the administration menu I must startover again and it's a lot of work to do it so.

Chuck S · August 9th, 2009, 02:35 PM

You will get a delete error if you already have a dutch language added. So what is the exact error?

If you run the file and check under languages is dutch listed there?

If it is and you set your global language to dutch does your site view fine?

aberg · August 9th, 2009, 03:07 PM

Let try to explaine it:

Now the programm is working fine, but I have only Englisch installed.
Now I do the next steps:

Uploading the phrase.php file
Uploading the upgrade.php
Run the upgrade step and choos for import the language strings

After run this I get this error:
Preparing to update database...
Error performing MySQL command: INSERT INTO cp_languages VALUES (2, 'Dutch', 'NL', 'UTF-8', 'ltr');
Error: Duplicate entry '2' for key 1

Error performing MySQL command: INSERT INTO cp_phrases VALUES (1, 'admgrp1', 'Global Options', 'Global Options', '2');
Error: Duplicate entry '1' for key 1

Error performing MySQL command: INSERT INTO cp_phrases VALUES (2, 'admgrp2', 'Admin Options', 'Admin Options', '2');
Error: Duplicate entry '2' for key 1

Error performing MySQL command: INSERT INTO cp_phrases VALUES (3, 'admgrp3', 'Index Options', 'Index Options', '2');
Error: Duplicate entry '3' for key 1

Error performing MySQL command: INSERT INTO cp_phrases VALUES (4, 'admgrp4', 'Show Categories Options', 'Show Categories Options', '2');
Error: Duplicate entry '4' for key 1

Error performing MySQL command: INSERT INTO cp_phrases VALUES (5, 'admgrp5', 'Show Ad Options', 'Show Ad Options', '2');
Error: Duplicate entry '5' for key 1

after this I must install the whole scripts again, because I get a blanc page
See image.
So what do I wrong????

Chuck S · August 9th, 2009, 04:52 PM

The numeric numbers in the actual queries can not be there.

Example

Code:

Content visible to verified customers only.

would say be

Code:

Content visible to verified customers only.

see the difference no number can be assigned it needs to be ''

aberg · August 10th, 2009, 10:36 AM

Thanks, Does this means that I must remove all numbers before the queries?
( in the phrase numbers 1 to 1374)

Chuck S · August 10th, 2009, 04:49 PM

Yes you remove the id field numbers as thats an autoincrement field and adding additional languages you do not number them.

aberg · August 11th, 2009, 10:41 AM

Well this translation is a hell of a job.
I don;t understand why this is changed in the new versions.
It would be more friendly when it is easy to translate the file and input it in the database.
I stop now, because I get again errors and must restore the database.
I go searching for a other programm because what will happen when there come a update?
I hope this this will not be the future for the language file in photopost.
When making a programm please keep in mind that not al the customers are living in English area.

By the way, sorry Chuck this isn't for you.
You give great support.

Chuck S · August 11th, 2009, 09:43 PM

aberg

This is pretty well the way vbulletin does languages. Moving the language strings into the database allows changing them to be much easier and allows the addition of languages to be way easier.

No one said making a language file was ever easy. However once you make an additional language its pretty easy to make others. The way things are done opens the door to even better additions in the future.

aberg · August 12th, 2009, 02:34 PM

Yes, agreed with that.
But in vbulletin is it very easy to import a new language.
The way in the classifieds is complicate and give me a lot of errors.

Chuck S · August 12th, 2009, 05:06 PM

It gives no errors if a proper file to run/import is made same as vbulletin. That really is the point here. I dont really know that the way I do it now is harder I mean vb you upload a properly formatted xml file and then the program parsed that as sql queries. In classifieds you upload a new file with queries called whatever you wish phrases.php german.php whatever and run it in your browser. it will do exactly the same thing vb does add a language and phrases to the database. The real test is getting through the learning curve of doing something new. So whether you create an xml file or a php file with queries its all the same.