This entry is in revision and can not be displayed

ITS Net Services · Post by **ITS Net Services** » Thu Apr 27, 2006 8:55 pm

Ok great.

Hopefully it will be in less than 4 hours because i have a client coming over that needs a FAQ system.

Post by **Thorsten** » Thu Apr 27, 2006 9:01 pm

Hi,

the problem is that your browser language is quite strange and that causes trouble... we'll try to fix that.

bye
Thorsten

matteo · Post by **matteo** » Thu Apr 27, 2006 9:18 pm

Hi,
just to be sure to exactly replicate your environment, could you confirm that you've changed no files from the original PMF 1.6.0? Are PATH_TO_PMFINSTALL/inc/constants.php and the PATH_TO_PMFINSTALL/lang/language_*.php files the original ones?
Could you also post the result of a simple test PHP page, creating just a plain text file in which copy the code below?

Code: Select all

<?php
if (isset($_SERVER['HTTP_ACCEPT_LANGUAGE'])) {
    print "<pre>Browser language preferences: ".$_SERVER['HTTP_ACCEPT_LANGUAGE']."</pre>";
}
?>

TIA,
Matteo

ITS Net Services · Post by **ITS Net Services** » Thu Apr 27, 2006 9:24 pm

First let me start off by saying, i installed version 1.5.8 originally. Then i saw 1.6.0 was released and installed that.

Both of them have done the same thing to me. The only thing i have changed in the constants.php file was the logout time. And that was only in version 1.6.0

Here are the results of the php file.

Browser language preferences: en-us,en;q=0.5

matteo · Post by **matteo** » Thu Apr 27, 2006 9:30 pm

Hi,

ITS Net Services wrote:First let me start off by saying, i installed version 1.5.8 originally. Then i saw 1.6.0 was released and installed that.

Both of them have done the same thing to me. The only thing i have changed in the constants.php file was the logout time. And that was only in version 1.6.0

thanks for this info.

ITS Net Services wrote: Here are the results of the php file.

Browser language preferences: en-us,en;q=0.5

Just for giving you one more chance for your presentation we kindly suggest you to temporarly change your browser language preferences in order to let the en (English) language be first. This tip plus the fixing of your DB ("en-US"->"en") should be the temp workaround.
TIA,
Matteo

matteo · Post by **matteo** » Thu Apr 27, 2006 9:42 pm

Hi,

ITS Net Services wrote:Here are the results of the php file.

Browser language preferences: en-us,en;q=0.5

could you also post the result of this PHP code below?

Code: Select all

<?php
if (isset($_SERVER['HTTP_ACCEPT_LANGUAGE'])) {
    print "<pre>Browser language preferences: ".$_SERVER['HTTP_ACCEPT_LANGUAGE']."</pre>";
}
if (isset($_COOKIE['pmf_lang'])) {
    print "<pre>pmf_lang cookie: ".$_COOKIE['pmf_lang']."</pre>";
}
if (isset($_COOKIE['pmf_sid'])) {
    print "<pre>pmf_sid cookie: ".$_COOKIE['pmf_sid']."</pre>";
}
?>

TIA,
Matteo

ITS Net Services · Post by **ITS Net Services** » Thu Apr 27, 2006 10:15 pm

matteo wrote: Just for giving you one more chance for your presentation we kindly suggest you to temporarly change your browser language preferences in order to let the en (English) language be first. This tip plus the fixing of your DB ("en-US"->"en") should be the temp workaround.
TIA,
Matteo

Thanks for that, i will try and hope that works. I am using Mozilla FF. That may or not be part of the problem. I have tried IE but have the same issue.

Here are the results of the 2nd php file you asked me to run. It is the same as the first.

Browser language preferences: en-us,en;q=0.5

matteo · Post by **matteo** » Thu Apr 27, 2006 10:26 pm

Hi,

ITS Net Services wrote:Here are the results of the 2nd php file you asked me to run. It is the same as the first.

Browser language preferences: en-us,en;q=0.5

This means that you don't have any cookie coming from other apps that could break the PMF ones: good info.

Let's go on debugging, could you try again as described below:

put the 2nd test file just under the root of the PMF installation;
open the PMF homepage;
change the link in the same browser window with the one of the test page

?
The expected result is something like this:

Code: Select all

Browser language preferences: en-us
pmf_lang cookie: en
pmf_sid cookie: 8

ITS Net Services · Post by **ITS Net Services** » Thu Apr 27, 2006 10:34 pm

I changed the browser settings, and queried the database. No luck

Same problem.

Here is the result of the 2nd test file in the PMF directory. It was close to what you expected.

Browser language preferences: en,en-us;q=0.5

pmf_lang cookie: en

pmf_sid cookie: 7

matteo · Post by **matteo** » Thu Apr 27, 2006 10:46 pm

Hi,

ITS Net Services wrote:I changed the browser settings, and queried the database. No luck Same problem.

could you check your DB tables, precisely:

faqcategoryrelations;
faqchanges;
faqdata;
faqdata_revisions;
faqvisits.

through phpMyAdmin to find out if you've some entries like "en-US" instead of "en"?

ITS Net Services · Post by **ITS Net Services** » Thu Apr 27, 2006 10:54 pm

Yes i found some that are using en_US instead of en-

faqcategoryrelations
faqdata
faqdata_revisions
faqvisits

How can i change that?

matteo · Post by **matteo** » Thu Apr 27, 2006 11:08 pm

Hi,

ITS Net Services wrote:How can i change that?

You can apply these queries below, one by one:

UPDATE faqcategoryrelations SET category_lang = 'en', record_lang = 'en'
UPDATE faqchanges SET lang = 'en'
UPDATE faqdata SET lang = 'en'
UPDATE faqdata_revisions SET lang = 'en'
UPDATE faqvisits SET lang = 'en'

ITS Net Services · Post by **ITS Net Services** » Thu Apr 27, 2006 11:22 pm

WOOOOOO HOOOOOO!!!!!!!!!!

Its working!!!!

Good Job Guys!!!!!!

Thanks alot Matteo & Thorsten

I am in your debt.

This issue will be resolved in revision 1.6.1 correct?

Post by **Thorsten** » Fri Apr 28, 2006 5:43 am

Hi,

ITS Net Services wrote:This issue will be resolved in revision 1.6.1 correct?

yes, we're fixing that.

bye
Thorsten

Post by **Thorsten** » Fri Apr 28, 2006 10:38 am

Hi,

I need another information from you. Can you add a file called info.php in your FAQ directory with the following content:

Code: Select all

<?php phpinfo(); ?>

and post the link here?

Thanks!

bye
Thorsten