New Installation of Joomla_3100-Stable-Full_Package_French_v1_1

Need help installing Joomla! 3.x? For all Joomla! 3.x installation issues please use this forum.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10
Post Reply
webesyn38
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Wed Aug 25, 2021 9:10 am

New Installation of Joomla_3100-Stable-Full_Package_French_v1_1

Post by webesyn38 » Wed Aug 25, 2021 9:21 am

Hello,

It is not my first Joomla! installation, but this time I got an error, but I do not understand the message and what to do to resolve it. Here's the message :
Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '94, 61, 'Dernières actions', '', '', 0, 'cpanel', 0, '0000-00-00 00:00:00', '00' at line 1
Has anyone had this problem ?
Has anyone an idea of what I should do ?

Thanks in advance for your help and advises.

PS. Please forgive me my English as it is not my mother language, I'm French

Richard67
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 236
Joined: Fri Sep 16, 2011 6:13 pm
Location: Germany
Contact:

Re: New Installation of Joomla_3100-Stable-Full_Package_French_v1_1

Post by Richard67 » Wed Aug 25, 2021 4:25 pm

When does this error happen? On installation? Or later?

Richard67
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 236
Joined: Fri Sep 16, 2011 6:13 pm
Location: Germany
Contact:

Re: New Installation of Joomla_3100-Stable-Full_Package_French_v1_1

Post by Richard67 » Wed Aug 25, 2021 4:31 pm

I found the reason: There is a syntax error in the localized French full installation package in file installation\sql\mysql\sample_brochure_fr.sql, line 170. That line should end with a comma because it's not the last row in that insert statement, but it ends with a semicolon.

I've noticed that the error is also present in the latest version 3.10.1.

Could you report that to the French translators, either here in the French forum or at https://www.joomla.fr/ ? Thanks in advance.

Richard67
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 236
Joined: Fri Sep 16, 2011 6:13 pm
Location: Germany
Contact:

Re: New Installation of Joomla_3100-Stable-Full_Package_French_v1_1

Post by Richard67 » Wed Aug 25, 2021 4:36 pm

P.S.: The error I've mentioned above only exists in the localized French package, not in the original English version of the CMS.

Richard67
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 236
Joined: Fri Sep 16, 2011 6:13 pm
Location: Germany
Contact:

Re: New Installation of Joomla_3100-Stable-Full_Package_French_v1_1

Post by Richard67 » Wed Aug 25, 2021 4:45 pm

P.P.S: I don't know if this is the only SQL error in the French localization. But the normal installation SQL looked ok. So if you make a new installation without choosing any sample data at the end it should work. But I recommend to use the newer version Joomla_3101-Stable-Full_Package_French_v1_1. Or if you need blog sample data and have time, wait until the next version comes which has hopefully the error corrected.

User avatar
sarki
Joomla! Guru
Joomla! Guru
Posts: 561
Joined: Mon Sep 19, 2005 2:34 pm
Location: Suisse
Contact:

Re: New Installation of Joomla_3100-Stable-Full_Package_French_v1_1

Post by sarki » Wed Aug 25, 2021 5:50 pm

Hello, yes it was an error in the SQL file of the French installation pack and not the official one, this error has been corrected today and a new Joomla 3.10.1 FR v2 pack has been made available on www.joomla.fr
French Joomla Translation & Support : www.joomla.fr
French JCE Translation & Support : www.sarki.ch/jce

User avatar
infograf768
Joomla! Master
Joomla! Master
Posts: 19117
Joined: Fri Aug 12, 2005 3:47 pm
Location: **Translation Matters**

Re: New Installation of Joomla_3100-Stable-Full_Package_French_v1_1

Post by infograf768 » Wed Aug 25, 2021 6:06 pm

fr-FR_joomla_lang_full_3.10.1v2 is now available directly in Joomla as an update.
Jean-Marie Simonet / infograf · http://www.info-graf.fr
---------------------------------
ex-Joomla Translation Coordination Team • ex-Joomla! Production Working Group


Post Reply

Return to “Installation Joomla! 3.x”