Accent problem ?!

Permalink Browser Info Environment
Hi,
Cool and usefull Tools your sky tabs ! but i have a huge problem in the tabs editor with accent. My Site is set in UTF8, all stuffs in ut8 ! but when i write any french text with exemple the 'à' mean &agrave ! it won't display correctly... showing this symbol � and if i update the tab, this hang the tabs ! all stuffs in disapear ?! Very very inconfortable ! it's impossible to work with that pb... could you help me please to debug this ?

thanks in advance

Regards

Olivier

Type: Pre-Sale
Status: In Progress
ogoncalves85
View Replies:
shahroq replied on at Permalink Reply
shahroq
Sure, i will test with utf8 characters and come back to you tomorrow,
shahroq replied on at Permalink Reply
shahroq
Hi, I guess it should have something to do with your database CHARSET. Make sure you set them to utf8.
ogoncalves85 replied on at Permalink Reply
ogoncalves85
Hi shahroq,

Thanks to check my query... ok i check the charset...
i ll feedback

SeeYa

Olivier
ogoncalves85 replied on at Permalink Reply 2 Attachments
ogoncalves85
HI,

So i check the database charset ! it seems to be allright ..; all stuffs are in UTF8 (unicode)

See attachements

Where else can i check ? any tips ?

...

olivier
ogoncalves85 replied on at Permalink Reply
ogoncalves85
... i notice that there is no pb with common accent... mean : é è..etc...

Juste only a bug with à (à)

?
shahroq replied on at Permalink Reply
shahroq
I couldn't re-create the issue on my own machine. Can you provide me your site credentials so i can check?
ogoncalves85 replied on at Permalink Reply
ogoncalves85
Hi,

Ok ! why not...;-) i set this and feedback soon as possible an account for you...

I notice another trick... i can't have more than 9 tabs ?! is there a setting somewhere to overide this limit please ?

Thanks

SeeYa
shahroq replied on at Permalink Reply
shahroq
For increase number of tabs check this topic:
https://www.concrete5.org/marketplace/addons/whale-sky-tabs/support/...
ogoncalves85 replied on at Permalink Reply
ogoncalves85
Great thanks ! perfectt !
ogoncalves85 replied on at Permalink Reply
ogoncalves85
Hi,

here is an access
"http://www.lachrysalide.institute/index.php/dashboard/blocks/whale_sky_tabs"

log as : debug1
pwd : Angelcode$

please test the Tab id : 41 ! (or other begin by copy)
there is a text with à you could see what append when edit/update...

DB and site are saved !

thanks in advance

Seeya

Olivier
shahroq replied on at Permalink Reply
shahroq
Definitely something wrong with your database Charset or Collation. Try execute this statement and see if fix the issue:
ALTER TABLE whaleSkyTabs CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;

If it didn't work, plz send me a dump from whaleSkyTabs table.
ogoncalves85 replied on at Permalink Reply 1 Attachment
ogoncalves85
..OK...
DONE it! but no change ((

to bypass the pb... i replace à by à when edit and update... it's the only way to keep the componenet functional and DB no corrupt... but at each edit (reload from DB) i must redo the replacement... long job... not easy for users...

so, please here is the current dump... watch by example the tab id 22 (any all tab with no copy before are online stuff to show)

you notice that the Sql store well the à but when edit... it doesnt show correctly .
when i edit the tab 41 you test ! i see that :
sdfds�

...maybe the parser have a misstake somewhere ? how to dig in this affair ?

thanks for your help

concrete5 Environment Information

# concrete5 Version
Core Version - 5.7.5.11
Version Installed - 5.7.5.11
Database Version - 20160615000000

# concrete5 Packages
Background Image and Overlay (0.9.9), Block Designer (2.5.3), Buttons Factory Pro (2.0.3), Cloneamental (0.9.3), Custom Export-Import (1.1.4), Honest Websites Back To Top (1.0.1), Image Link With Content (1.1), Login/Logout Link (1.0), Login Page Background (0.9), Palette (1.0.2), Vivid Carousel (1.0.1), Vivid Simple Accordion (1.0.1), Webli Content PopUp (1.0), Whale Grid Gallery (2.3.3), Whale OWL Carousel (2.5.7.8), Whale Sky Tabs (1.1.6)

# concrete5 Overrides
languages/da_DK/LC_MESSAGES/messages.mo, languages/da_DK/LC_MESSAGES, languages/da_DK, languages/de_DE/LC_MESSAGES/messages.mo, languages/de_DE/LC_MESSAGES, languages/de_DE, languages/el_GR/LC_MESSAGES/messages.mo, languages/el_GR/LC_MESSAGES, languages/el_GR, languages/fi_FI/LC_MESSAGES/messages.mo, languages/fi_FI/LC_MESSAGES, languages/fi_FI, languages/fr_FR/LC_MESSAGES/messages.mo, languages/fr_FR/LC_MESSAGES, languages/fr_FR, languages/it_IT/LC_MESSAGES/messages.mo, languages/it_IT/LC_MESSAGES, languages/it_IT, languages/ja_JP/LC_MESSAGES/messages.mo, languages/ja_JP/LC_MESSAGES, languages/ja_JP, languages/nl_NL/LC_MESSAGES/messages.mo, languages/nl_NL/LC_MESSAGES, languages/nl_NL, languages/ru_RU/LC_MESSAGES/messages.mo, languages/ru_RU/LC_MESSAGES, languages/ru_RU, languages/sl_SI/LC_MESSAGES/messages.mo, languages/sl_SI/LC_MESSAGES, languages/sl_SI, languages/sv_SE/LC_MESSAGES/messages.mo, languages/sv_SE/LC_MESSAGES, languages/sv_SE, languages/tr_TR/LC_MESSAGES/messages.mo, languages/tr_TR/LC_MESSAGES, languages/tr_TR, languages/da_DK/LC_MESSAGES/messages.mo, languages/da_DK/LC_MESSAGES, languages/da_DK, languages/de_DE/LC_MESSAGES/messages.mo, languages/de_DE/LC_MESSAGES, languages/de_DE, languages/el_GR/LC_MESSAGES/messages.mo, languages/el_GR/LC_MESSAGES, languages/el_GR, languages/fi_FI/LC_MESSAGES/messages.mo, languages/fi_FI/LC_MESSAGES, languages/fi_FI, languages/fr_FR/LC_MESSAGES/messages.mo, languages/fr_FR/LC_MESSAGES, languages/fr_FR, languages/it_IT/LC_MESSAGES/messages.mo, languages/it_IT/LC_MESSAGES, languages/it_IT, languages/ja_JP/LC_MESSAGES/messages.mo, languages/ja_JP/LC_MESSAGES, languages/ja_JP, languages/nl_NL/LC_MESSAGES/messages.mo, languages/nl_NL/LC_MESSAGES, languages/nl_NL, languages/ru_RU/LC_MESSAGES/messages.mo, languages/ru_RU/LC_MESSAGES, languages/ru_RU, languages/sl_SI/LC_MESSAGES/messages.mo, languages/sl_SI/LC_MESSAGES, languages/sl_SI, languages/sv_SE/LC_MESSAGES/messages.mo, languages/sv_SE/LC_MESSAGES, languages/sv_SE, languages/tr_TR/LC_MESSAGES/messages.mo, languages/tr_TR/LC_MESSAGES, languages/tr_TR

# concrete5 Cache Settings
Block Cache - Off
Overrides Cache - Off
Full Page Caching - On - If blocks on the particular page allow it.
Full Page Cache Lifetime - Every 30 minutes.

# Server Software
Microsoft-IIS/7.5

# Server API
cgi-fcgi

# PHP Version
5.6.28

# PHP Extensions
bcmath, calendar, cgi-fcgi, Core, ctype, curl, date, dom, ereg, fileinfo, filter, ftp, gd, gettext, hash, iconv, imap, json, libxml, mbstring, mcrypt, mhash, mysql, mysqli, mysqlnd, odbc, openssl, pcre, PDO, pdo_mysql, pdo_sqlite, pdo_sqlsrv, Phar, Reflection, session, SimpleXML, sockets, SPL, sqlite3, sqlsrv, standard, tokenizer, wddx, xml, xmlreader, xmlwriter, xsl, zip, zlib

# PHP Settings
max_execution_time - 600
log_errors_max_len - 1024
max_file_uploads - 20
max_input_nesting_level - 64
max_input_time - 60
max_input_vars - 1000
memory_limit - 128M
post_max_size - 20M
sql.safe_mode - Off
upload_max_filesize - 20M
mysql.max_links - Unlimited
mysql.max_persistent - Unlimited
mysqli.max_links - Unlimited
mysqli.max_persistent - Unlimited
odbc.max_links - Unlimited
odbc.max_persistent - Unlimited
pcre.backtrack_limit - 1000000
pcre.recursion_limit - 100000
pdo_sqlsrv.client_buffer_max_kb_size - 10240
session.cache_limiter - <i>no value</i>
session.gc_maxlifetime - 1440

Browser User-Agent String

Mozilla/5.0 (Windows NT 10.0; WOW64; rv:54.0) Gecko/20100101 Firefox/54.0

Hide Post Content

This will replace the post content with the message: "Content has been removed by an Administrator"

Hide Content

Request Refund

You may not request a refund that is not currently owned by you.