 | MEMBER LOGIN |
|
|
 |
|
 | SERVICES & FEATURES |
|
|
|
|
 | THE 20 LATEST PROJECTS |
| POPULAR NEW PROJECTS |
|
|
| |
|
Status: |
Closed (Cancelled)
|
|
Budget: |
N/A
|
|
Created: |
7/23/2010 at 8:35 EST
|
|
Cancelled: |
8/14/2010 at 0:18 EST
|
|
Project Creator: |
|
|
Description: |
Hello,
I got a charset problem in a french forum :
http://www.deathblow.cc/index.php?n=forum
Here's the details of the problem :
- When posting a message with any accent on it inside the forum (é,à,è,ô,ê, etc...), the message is cut at this first accent.
For example, if i put a message while posting in forums like "Vais-je arriver à faire marcher l'encodage de mon site un jour".
The result is "Vais-je arriver "...
If we modify directly an existing word directly to the database with SQLYog for example : The word "Boite a Idee" to "Boite à Idée".
Display on forums : "Boite à Idée"
Please try by creating an account on website and posting somewhere to test.
---------------------------------------------------------------------
The server run on Debian Lenny en 64 bits with Plesk 9.5.
We got root on the server.
Here what we have done to try to correct the problem :
1. Check locales on server UTF-8, ISO-8859-1 and ISO-8859-15 is correctly installed.
2. Modify file /etc/apache2/conf.d/charset with inside :
AddDefaultCharset ISO-8859-15
Then restart apache2
3. Modify cms header with :
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="fr" lang="fr">
<head>
<meta http-equiv="content-type" content="text/html; charset=iso-8859-15"/>
4. Add .htaccess content to any folder :
AddDefaultCharset ISO-8859-15
php_value default_charset ISO-8859-15
5. Investigated the forum topic table with the mysql command line :
ALTER TABLE f_forums CONVERT TO CHARACTER SET latin1 COLLATE latin1_general_cs;
6. Changed mysqld config :
[mysqld]
init-connect ='SET NAMES latin1'
7. Put in my.cnf in section [mysqld] [mysql] and [mysqldump]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=latin1
Then, no changes ! Start to pulling my hair !
I think Developer who bid must have knowledge on :
- php
- mysql
- Linux debian
Thanks for bidding
|
|
Tags: |
PHP, MySQL, Modification, Conversion, CMS, XML, XHTML, Forum, htaccess, Plesk |
| |
 |
|
Messages Posted: 11 |
|
Programmers |
Bid  |
Delivery Time |
Time of Bid |
Rating |
|
|
sat12345 |
$50 |
2 days |
7/26/2010 at 8:09 EST | 
(7 reviews) | |
| plz check PMB..
| | |
|
darvidont |
$50 |
3 days |
7/23/2010 at 11:07 EST | 
(14 reviews) |  |
| Can do this task fast and professional for a reasonable money.
| | |
|
precisecoder |
$100 |
2 days |
7/23/2010 at 13:31 EST | (No Feedback Yet) | |
| Please see pmb.
| | |
|
aruhat |
$199 |
10 days |
7/26/2010 at 6:17 EST | 
(7 reviews) | |
| Hi
Please see PMB.
Regards
Maulik
| | |
|
buly |
$250 |
1 day |
7/23/2010 at 9:49 EST |
(1 review) | |
| It's easy, I can start today evening if you give me access to your server
| | |
|
nicelancerjob |
$299 |
25 days |
7/24/2010 at 2:14 EST |
(5 reviews) | |
| Hello,
I have studied job description.
I am 100%confident and interested to work with you.
Thanks
Nicelancerjob
| | |
|
oscommers |
$300 |
6 days |
7/23/2010 at 9:25 EST |
(1 review) | |
| We are a team of highly skilled professionals including project managers, domain experts, designers, analyst
programmers and quality assurance. We have state-of-the-art facilities. We take pride in providing quality
solutions within agreed time and budget.
| | |
| |
