Search the Community

In preparation to "go live" I recently upgraded from a shared service account to a dedicated VPS. I mistakenly thought that when they migrated my site they would migrate the setup that I was using on the Shared server to ensure no loss of functionality/compatibility however I have had nothing but trouble since I made the switch. It's a good thing since I believe that if you don't have hell you don't learn but this is ridiculous. My provider said this is an application issue and they won't assist me with troubleshooting it. Current Config: Server information: Linux #1 SMP Mon Feb 17 21:00:14 MSK 2014 x86_64 Server software version: Apache PHP version: 5.4.27 Memory limit: 384M Max execution time: 50000 Database information MySQL version: 5.6.16 MySQL engine: InnoDB Tables prefix: ps_ Store information PrestaShop version: 1.5.6.2 Shop URL: https://capvapor.com/ Current theme in use: default Here is the story so you have some background: I didn't realize there was an issue until my Products' short descriptions started complaining about being too long. I was adding attributes to Products and hit the save button and it kept happening to each Product so I went to look and that's when I saw multiple  characters between the period and the start of the next sentence. I am showing my age but I always double space even though it isn't required because I like the way it looks. It inserts the  character between the spaces every time I change anything associated with the product. When I started looking for the cause I noticed that there were different Collation settings in MySQL and Character settings even a few MyISAM tables peppered through the database. I loaded my first Prestashop site using the Softalicious tool. It is on a cPanel/WHM CentOS/Redhat Linux box. My unix is rusty but I used to manage several Informix SQL Sun boxes for SWB Wireless (if that doesn't tell you my age nothing will). So I can trudge through most things but for the life of me this MySQL configuration is eating my lunch... Since I first noticed the problem I have searched everywhere to find and implement a fix to this issue without success. Here is a list of items that I have found and changed in the attempt to get this resolved. Entered: This has a strong peppermint flavor with a menthol kick that really pops in your mouth. It has a super throat hit and reminds me of the great new chewing gum flavors out there. It really is amazing! Displays/Commits: This has a strong peppermint flavor with a menthol kick that really pops in your mouth.  It has a super throat hit and reminds me of the great new chewing gum flavors out there.  It really is amazing! 1) Set the my.cnf file to the following trying to get the defaults set to utf8: [mysqld] max_connections = 100 query_cache_size = 32M query_cache_limit=1M skip-external-locking key_buffer_size = 32M max_allowed_packet = 8M table_open_cache = 64M sort_buffer_size = 256K join_buffer_size = 1M net_buffer_length = 8K read_buffer_size = 1024K read_rnd_buffer_size = 1M myisam_sort_buffer_size = 16M innodb_file_per_table tmp_table_size = 32M max_heap_table_size = 32M thread_cache_size = 50 table_open_cache=500 table_definition_cache=500 open_files_limit=26520 wait_timeout = 30 connect_timeout = 1 low_priority_updates=1 concurrent_insert=2 character-set-server = utf8 collation-server = utf8_unicode_ci init_connect = 'SET NAMES utf8' character-set-client-handshake = FALSE # This setting ensures that aio limits are not exceeded # (default is 65536, each instance of mysql takes 2661 with this enabled) innodb_use_native_aio = 0 #open_files_limit=32768 Here are my prestashop db results of: show variables like "%character%";show variables like "%collation%"; Variable_name Value collation_connection utf8mb4_general_ci collation_database utf8_unicode_ci collation_server utf8_unicode_ci Anyone that has fixed this that can point me in the right direction would be very appreciated! I am attaching some current files that are from MySQL and the modules installed. If you need anything else please let me know. Thanks in advance! J Stepp capvapdb_mysql.txt mysql-variables.txt show-installed.txt