Hi dxerty.
Thanks a lot for this contribution!

I didn't notice that those 3 strings were missing in the french file.
I just integrated them, with a few corrections:

- don't forget to escape all quotes to avoid syntax errors ('Vous n'avez pas...' => 'Vous n\'avez pas...')
- "... devez vous connectez" => "... devez vous connecter"
- "... de connexion infructueuses!." => "de connexion infructueuses !"
(Note that we can simplify "tentatives de connexion infructueuses" into "échecs de connexion": much shorter and same meaning.)

The new file is attached.

Le mardi 31 juillet 2012 03:29:53 UTC+2, dxerty a écrit :

'error101'                => 'Vous n'avez pas la permission de voir cette tâche.',
'error102'                => 'Vous n'avez pas la permission de voir cette tâche, vous devez vous connectez.',
'error71'                 => 'Compte verrouillé pendant %d minutes en raison de trop nombreuses tentatives de connexion infructueuses!.',

--
You received this message because you are subscribed to the Google Groups "flyspray" group.
To view this discussion on the web visit https://groups.google.com/d/msg/flyspray/-/qB_RN0TAX2wJ.
To post to this group, send email to flyspray-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to flyspray+unsubscribe <at> googlegroups.com.
For more options, visit this group at http://groups.google.com/group/flyspray?hl=en.

Thanks for the update, I can apply it tonight (8+ hours from this posting) if no one else does by then.

On Wednesday, August 1, 2012 2:15:47 AM UTC-6, Trigone wrote:

Hi dxerty.
Thanks a lot for this contribution!

I didn't notice that those 3 strings were missing in the french file.
I just integrated them, with a few corrections:

- don't forget to escape all quotes to avoid syntax errors ('Vous n'avez pas...' => 'Vous n\'avez pas...')
- "... devez vous connectez" => "... devez vous connecter"
- "... de connexion infructueuses!." => "de connexion infructueuses !"
(Note that we can simplify "tentatives de connexion infructueuses" into "échecs de connexion": much shorter and same meaning.)

The new file is attached.

Le mardi 31 juillet 2012 03:29:53 UTC+2, dxerty a écrit :

'error101'                => 'Vous n'avez pas la permission de voir cette tâche.',
'error102'                => 'Vous n'avez pas la permission de voir cette tâche, vous devez vous connectez.',
'error71'                 => 'Compte verrouillé pendant %d minutes en raison de trop nombreuses tentatives de connexion infructueuses!.',

--
You received this message because you are subscribed to the Google Groups "flyspray" group.
To view this discussion on the web visit https://groups.google.com/d/msg/flyspray/-/CzycyArB7y4J.
To post to this group, send email to flyspray-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to flyspray+unsubscribe <at> googlegroups.com.
For more options, visit this group at http://groups.google.com/group/flyspray?hl=en.

this has been added to the latest.  Thanks.

On Wednesday, August 1, 2012 8:26:22 AM UTC-6, Scott H wrote:

Thanks for the update, I can apply it tonight (8+ hours from this posting) if no one else does by then.

On Wednesday, August 1, 2012 2:15:47 AM UTC-6, Trigone wrote:

Hi dxerty.
Thanks a lot for this contribution!

I didn't notice that those 3 strings were missing in the french file.
I just integrated them, with a few corrections:

- don't forget to escape all quotes to avoid syntax errors ('Vous n'avez pas...' => 'Vous n\'avez pas...')
- "... devez vous connectez" => "... devez vous connecter"
- "... de connexion infructueuses!." => "de connexion infructueuses !"
(Note that we can simplify "tentatives de connexion infructueuses" into "échecs de connexion": much shorter and same meaning.)

The new file is attached.

Le mardi 31 juillet 2012 03:29:53 UTC+2, dxerty a écrit :

'error101'                => 'Vous n'avez pas la permission de voir cette tâche.',
'error102'                => 'Vous n'avez pas la permission de voir cette tâche, vous devez vous connectez.',
'error71'                 => 'Compte verrouillé pendant %d minutes en raison de trop nombreuses tentatives de connexion infructueuses!.',

--
You received this message because you are subscribed to the Google Groups "flyspray" group.
To view this discussion on the web visit https://groups.google.com/d/msg/flyspray/-/37FdDlpatvEJ.
To post to this group, send email to flyspray-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to flyspray+unsubscribe <at> googlegroups.com.
For more options, visit this group at http://groups.google.com/group/flyspray?hl=en.

I have installed Flyspray  0.9.9.7 with postgresql 8.4.11 and php 5.3.3.

I have faced the following issues:

•  I had the following error message on top of the scereen:

• In overview page, the activity, stats and progress information where not working : a broken image was displayed instead of the expected information.
  Looking to errors messages, the problem was linked to the usage of MYSQL functions (not supported by Postgres) in SQL queries: from_unixtime and str_to_date.
  Thanks to http://postgres.cz/wiki/P%C5%99echod_z_MySQL and 

  http://janusz.slota.name/blog/2009/06/mysql-from_unixtime-and-unix_timestamp-functions-in-postgresql/,
  I solved the issue by performing the following SQL queries directly in the database (but it should be better to directly modified the SQL query in the code...):

CREATE OR REPLACE FUNCTION get_format(text, text)

• RETURNS text AS $$

    SELECT CASE lower($1)

               WHEN 'date' THEN

                   CASE lower($2)

                       WHEN 'usa' THEN '%m.%d.%Y'

                       WHEN 'jis' THEN '%Y-%m-%d'

                       WHEN 'iso' THEN '%Y-%m-%d'

                       WHEN 'eur' THEN '%d.%m.%Y'

                       WHEN 'internal' THEN '%Y%m%d'

                   END

               WHEN 'datetime' THEN

                   CASE lower($2)

                       WHEN 'usa' THEN '%Y-%m-%d %H-.%i.%s'

                       WHEN 'jis' THEN '%Y-%m-%d %H:%i:%s'

                       WHEN 'iso' THEN '%Y-%m-%d %H:%i:%s'

                       WHEN 'eur' THEN '%Y-%m-%d %H.%i.%s'

                       WHEN 'internal' THEN '%Y%m%d%H%i%s'

                   END

               WHEN 'time' THEN

                   CASE lower($2)

                       WHEN 'usa' THEN '%h:%i:%s %p'

                       WHEN 'jis' THEN '%H:%i:%s'

                       WHEN 'iso' THEN '%H:%i:%s'

                       WHEN 'eur' THEN '%H.%i.%s'

                       WHEN 'internal' THEN '%H%i%s'

                   END

           END;

  $$ LANGUAGE sql;

   
  

  CREATE OR REPLACE FUNCTION str_to_date(text, text)RETURNS date AS $$  SELECT to_date($1, _mysqlf_pgsql($2))$$ LANGUAGE sql;

   

  
  

  CREATE OR REPLACE FUNCTION from_unixtime(INTEGER) RETURNS TIMESTAMP AS '        SELECT to_timestamp($1)::timestamp AS result' LANGUAGE 'SQL';

Regards,

--
You received this message because you are subscribed to the Google Groups "flyspray" group.
To view this discussion on the web visit https://groups.google.com/d/msg/flyspray/-/46X8ZCyR7C0J.
To post to this group, send email to flyspray-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to flyspray+unsubscribe <at> googlegroups.com.
For more options, visit this group at http://groups.google.com/group/flyspray?hl=en.