Prestashop 1.5.6.2 creating tables with latin1_swedish_ci collation when installing new modules

[jstepp28]

I have spent many hours (days) trying to get MySQL setup to use utf8_general_ci as the default encoding, collation and connection encoding and I was happy that everything seemed fine.  I've completely started over and reinstalled my application into a new MySQL database.  I checked and all the charset and collation looked great.  I looked at my old install and began installing the modules and reconfiguring everything so I would have a nice clean application without modules that I do not intend to use on my live site but now I have several tables that are using latin1_swedish_ci collation and that are all from modules that were installed after the initial Prestashop application was installed.

 

There are some tables that are using utf8_unicode_ci collation as well???

 

I am not proud at this point.  If there is some "i" that needs to be dotted then please let me know what I'm doing wrong.  I am including the my.cnf and php.ini files here.  I only have 1GB of RAM on my VPS right now until I am ready to go live so I'm trying to keep memory usage down.

 

I appreciate any help because I am trying to get these issues fixed so I can start accepting orders but right now I'm not sure what is going on...

 

[mysqld]

open_files_limit=27522

key_buffer_size=16M

max_connections=5

bind-address-127.0.0.1

innodb_file_per_table=1

character-set-server = utf8

skip-character-set-client-handshake

default-storage-engine=innodb

 

[innodb]

innodb_buffer_pool_size = 16M

innodb_additional_mem_pool_size = 5M

innodb_log_file_size = 5M

innodb_log_buffer_size = 8M

innodb_flush_log_at_trx_commit = 1

innodb_lock_wait_timeout = 180

 

php.ini

 

;;;;;;;;;;;

; WARNING ;

;;;;;;;;;;;

; This is the default settings file for new PHP installations.

; By default, PHP installs itself with a configuration suitable for

; development purposes, and *NOT* for production purposes.

; For several security-oriented considerations that should be taken

; before going online with your site, please consult php.ini-recommended

; and http://php.net/manual/en/security.php.

 

 

;;;;;;;;;;;;;;;;;;;

; About this file ;

;;;;;;;;;;;;;;;;;;;

; This file controls many aspects of PHP's behavior.  In order for PHP to

; read it, it must be named 'php.ini'.  PHP looks for it in the current

; working directory, in the path designated by the environment variable

; PHPRC, and in the path that was defined in compile time (in that order).

; Under Windows, the compile-time path is the Windows directory.  The

; path in which the php.ini file is looked for can be overridden using

; the -c argument in command line mode.

;

; The syntax of the file is extremely simple.  Whitespace and Lines

; beginning with a semicolon are silently ignored (as you probably guessed).

; Section headers (e.g. [Foo]) are also silently ignored, even though

; they might mean something in the future.

;

; Directives are specified using the following syntax:

; directive = value

; Directive names are *case sensitive* - foo=bar is different from FOO=bar.

;

; The value can be a string, a number, a PHP constant (e.g. E_ALL or M_PI), one

; of the INI constants (On, Off, True, False, Yes, No and None) or an expression

; (e.g. E_ALL & ~E_NOTICE), or a quoted string ("foo").

;

; Expressions in the INI file are limited to bitwise operators and parentheses:

; |        bitwise OR

; &        bitwise AND

; ~        bitwise NOT

; !        boolean NOT

;

; Boolean flags can be turned on using the values 1, On, True or Yes.

; They can be turned off using the values 0, Off, False or No.

;

; An empty string can be denoted by simply not writing anything after the equal

; sign, or by using the None keyword:

;

;  foo =         ; sets foo to an empty string

;  foo = none    ; sets foo to an empty string

;  foo = "none"  ; sets foo to the string 'none'

;

; If you use constants in your value, and these constants belong to a

; dynamically loaded extension (either a PHP extension or a Zend extension),

; you may only use these constants *after* the line that loads the extension.

;

; All the values in the php.ini-dist file correspond to the builtin

; defaults (that is, if no php.ini is used, or if you delete these lines,

; the builtin defaults will be identical).

 

 

;;;;;;;;;;;;;;;;;;;;

; Language Options ;

;;;;;;;;;;;;;;;;;;;;

 

; Enable the PHP scripting language engine under Apache.

engine = On

date.default.timezone="America/Chicago"

date.timezone = "America/Chicago"

default_charset = UTF-8

input_encoding = UTF-8

output_encoding = UTF-8

internal_encoding = UTF-8

;register_long_arrays = Off

 

; Allow the <? tag.  Otherwise, only <?php and <script> tags are recognized.  

; NOTE: Using short tags should be avoided when developing applications or

; libraries that are meant for redistribution, or deployment on PHP

; servers which are not under your control, because short tags may not

; be supported on the target server. For portable, redistributable code,

; be sure not to use short tags.

short_open_tag = On

 

; Allow ASP-style  tags.

asp_tags = On

 

; The number of significant digits displayed in floating point numbers.

precision = 12

 

; Enforce year 2000 compliance (will cause problems with non-compliant browsers)

;y2k_compliance = On

 

; Output buffering allows you to send header lines (including cookies) even

; after you send body content, at the price of slowing PHP's output layer a

; bit.  You can enable output buffering during runtime by calling the output

; buffering functions.  You can also enable output buffering for all files by

; setting this directive to On.  If you wish to limit the size of the buffer

; to a certain size - you can use a maximum number of bytes instead of 'On', as

; a value for this directive (e.g., output_buffering=4096).

output_buffering = 8096 

 

; You can redirect all of the output of your scripts to a function.  For

; example, if you set output_handler to "mb_output_handler", character

; encoding will be transparently converted to the specified encoding.

; Setting any output handler automatically turns on output buffering.

; Note: People who wrote portable scripts should not depend on this ini

;       directive. Instead, explicitly set the output handler using ob_start().

;       Using this ini directive may cause problems unless you know what script 

;       is doing.

; Note: You cannot use both "mb_output_handler" with "ob_iconv_handler"

;       and you cannot use both "ob_gzhandler" and "zlib.output_compression". 

;output_handler = bzip2.decompress

 

; Transparent output compression using the zlib library

; Valid values for this option are 'off', 'on', or a specific buffer size

; to be used for compression (default is 4KB)

; Note: Resulting chunk size may vary due to nature of compression. PHP 

;       outputs chunks that are few hundreds bytes each as a result of 

;       compression. If you prefer a larger chunk size for better 

;       performance, enable output_buffering in addition.

; Note: You need to use zlib.output_handler instead of the standard

;       output_handler, or otherwise the output will be corrupted.

zlib.output_compression = On

 

; You cannot specify additional output handlers if zlib.output_compression

; is activated here. This setting does the same as output_handler but in

; a different order.

;zlib.output_handler = bzip2.decompress

 

; Implicit flush tells PHP to tell the output layer to flush itself

; automatically after every output block.  This is equivalent to calling the

; PHP function flush() after each and every call to print() or echo() and each

; and every HTML block.  Turning this option on has serious performance

; implications and is generally recommended for debugging purposes only.

;implicit_flush = Off

 

; The unserialize callback function will be called (with the undefined class'

; name as parameter), if the unserializer finds an undefined class

; which should be instanciated.

; A warning appears if the specified function is not defined, or if the

; function doesn't include/implement the missing class.

; So only set this entry, if you really want to implement such a 

; callback-function.

;unserialize_callback_func=

 

; When floats & doubles are serialized store serialize_precision significant

; digits after the floating point. The default value ensures that when floats

; are decoded with unserialize, the data will remain the same.

;serialize_precision = 100

 

; Whether to enable the ability to force arguments to be passed by reference

; at function call time.  This method is deprecated and is likely to be

; unsupported in future versions of PHP/Zend.  The encouraged method of

; specifying which arguments should be passed by reference is in the function

; declaration.  You're encouraged to try and turn this option Off and make

; sure your scripts work properly with it in order to ensure they will work

; with future versions of the language (you will receive a warning each time

; you use this feature, and the argument will be passed by value instead of by

; reference).

;allow_call_time_pass_reference = On

 

; Safe Mode

;

;safe_mode = Off ; deprecated

 

; By default, Safe Mode does a UID compare check when

; opening files. If you want to relax this to a GID compare,

; then turn on safe_mode_gid.

;safe_mode_gid = Off ; deprecated

 

; When safe_mode is on, UID/GID checks are bypassed when

; including files from this directory and its subdirectories.

; (directory must also be in include_path or full path must

; be used when including)

;safe_mode_include_dir = ; deprecated

 

; When safe_mode is on, only executables located in the safe_mode_exec_dir

; will be allowed to be executed via the exec family of functions.

;safe_mode_exec_dir = ; deprecated

 

; Setting certain environment variables may be a potential security breach.

; This directive contains a comma-delimited list of prefixes.  In Safe Mode,

; the user may only alter environment variables whose names begin with the

; prefixes supplied here.  By default, users will only be able to set

; environment variables that begin with PHP_ (e.g. PHP_FOO=BAR).

;

; Note:  If this directive is empty, PHP will let the user modify ANY

; environment variable!

;safe_mode_allowed_env_vars = PHP_ ; deprecated

 

; This directive contains a comma-delimited list of environment variables that

; the end user won't be able to change using putenv().  These variables will be

; protected even if safe_mode_allowed_env_vars is set to allow to change them.

;safe_mode_protected_env_vars = LD_LIBRARY_PATH ; deprecated

 

; open_basedir, if set, limits all file operations to the defined directory

; and below.  This directive makes most sense if used in a per-directory

; or per-virtualhost web server configuration file. This directive is

; *NOT* affected by whether Safe Mode is turned On or Off.

;open_basedir =

 

; This directive allows you to disable certain functions for security reasons.

; It receives a comma-delimited list of function names. This directive is

; *NOT* affected by whether Safe Mode is turned On or Off.

;disable_functions =

 

; This directive allows you to disable certain classes for security reasons.

; It receives a comma-delimited list of class names. This directive is

; *NOT* affected by whether Safe Mode is turned On or Off.

;disable_classes =

 

; Colors for Syntax Highlighting mode.  Anything that's acceptable in

; <font color="??????"> would work.

;highlight.string  = #DD0000

;highlight.comment = #FF9900

;highlight.keyword = #007700

;highlight.bg      = #FFFFFF

;highlight.default = #0000BB

;highlight.html    = #000000

 

 

;

; Misc

;

; Decides whether PHP may expose the fact that it is installed on the server

; (e.g. by adding its signature to the Web server header).  It is no security

; threat in any way, but it makes it possible to determine whether you use PHP

; on your server or not.

expose_php = Off

 

;;;;;;;;;;;;;;;;;;;

;Opcache Settings ;

;;;;;;;;;;;;;;;;;;;

 

;opcache.memory_consumption=64M

;opcache.interned_strings_buffer=8K

;opcache.max_accelerated_files=4000

;opcache.revalidate_freq=60

;opcache.fast_shutdown=1

;opcache.enable_cli=1

 

;;;;;;;;;;;;;;;;;;;

; Resource Limits ;

;;;;;;;;;;;;;;;;;;;

 

max_execution_time = 50000

max_input_time = 50000

max_input_vars=10000

memory_limit = 128M

upload_max_filesize = 64M

post_max_size = 32M

suhosin.get.max_vars=100000

suhosin.post.max_var=100000

;zlib.output_compression=On

zlib.output_compression_level = 6

 

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

; Error handling and logging ;

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

 

; error_reporting is a bit-field.  Or each number up to get desired error

; reporting level

; E_ALL             - All errors and warnings

; E_ERROR           - fatal run-time errors

; E_WARNING         - run-time warnings (non-fatal errors)

; E_PARSE           - compile-time parse errors

; E_NOTICE          - run-time notices (these are warnings which often result

;                     from a bug in your code, but it's possible that it was

;                     intentional (e.g., using an uninitialized variable and

;                     relying on the fact it's automatically initialized to an

;                     empty string)

; E_CORE_ERROR      - fatal errors that occur during PHP's initial startup

; E_CORE_WARNING    - warnings (non-fatal errors) that occur during PHP's

;                     initial startup

; E_COMPILE_ERROR   - fatal compile-time errors

; E_COMPILE_WARNING - compile-time warnings (non-fatal errors)

; E_USER_ERROR      - user-generated error message

; E_USER_WARNING    - user-generated warning message

; E_USER_NOTICE     - user-generated notice message

;

; Examples:

;

;   - Show all errors, except for notices

;

error_reporting = E_ALL & ~E_NOTICE & ~E_DEPRECATED

;

;   - Show only errors

;

;error_reporting = E_COMPILE_ERROR|E_ERROR|E_CORE_ERROR

;

;   - Show all errors except for notices

;

;error_reporting = E_ALL & ~E_NOTICE & ~E_DEPRECATED

 

; Print out errors (as a part of the output).  For production web sites,

; you're strongly encouraged to turn this feature off, and use error logging

; instead (see below).  Keeping display_errors enabled on a production web site

; may reveal security information to end users, such as file paths on your Web

; server, your database schema or other information.

display_errors = On

 

; Even when display_errors is on, errors that occur during PHP's startup

; sequence are not displayed.  It's strongly recommended to keep

; display_startup_errors off, except for when debugging.

display_startup_errors = On

 

; Log errors into a log file (server-specific log, stderr, or error_log (below))

; As stated above, you're strongly advised to use error logging in place of

; error displaying on production web sites.

log_errors = On

 

; Set maximum length of log_errors. In error_log information about the source is

; added. The default is 1024 and 0 allows to not apply any maximum length at all.

log_errors_max_len = 4096

 

; Do not log repeated messages. Repeated errors must occur in same file on same

; line until ignore_repeated_source is set true.

ignore_repeated_errors = Off

 

; Ignore source of message when ignoring repeated messages. When this setting 

; is On you will not log errors with repeated messages from different files or

; sourcelines.

;ignore_repeated_source = Off

 

; If this parameter is set to Off, then memory leaks will not be shown (on

; stdout or in the log). This has only effect in a debug compile, and if 

; error reporting includes E_WARNING in the allowed list

report_memleaks = On

 

; Store the last error/warning message in $php_errormsg (boolean).

track_errors = On

 

; Disable the inclusion of HTML tags in error messages.

;html_errors = On

  

; If html_errors is set On PHP produces clickable error messages that direct 

; to a page describing the error or function causing the error in detail.

; You can download a copy of the PHP manual from http://www.php.net/docs.php 

; and change docref_root to the base URL of your local copy including the

; leading '/'. You must also specify the file extension being used including 

; the dot.

;docref_root = "/phpmanual/"

;docref_ext = ".html"

  

; String to output before an error message.

;error_prepend_string = "<font color=ff0000>"

 

; String to output after an error message.

error_append_string = "</font>"

 

; Log errors to specified file.

error_log = error_log

 

; Log errors to syslog (Event Log on NT, not valid in Windows 95).

;error_log = syslog

 

 

;;;;;;;;;;;;;;;;;

; Data Handling ;

;;;;;;;;;;;;;;;;;

;

; Note - track_vars is ALWAYS enabled as of PHP 4.0.3

 

; The separator used in PHP generated URLs to separate arguments.

; Default is "&". 

;arg_separator.output = "&"

 

; List of separator(s) used by PHP to parse input URLs into variables.

; Default is "&". 

; NOTE: Every character in this directive is considered as separator!

;arg_separator.input = ";&"

 

; This directive describes the order in which PHP registers GET, POST, Cookie,

; Environment and Built-in variables (G, P, C, E & S respectively, often

; referred to as EGPCS or GPC).  Registration is done from left to right, newer

; values override older values.

variables_order = "EGPCS"

 

; Whether or not to register the EGPCS variables as global variables.  You may

; want to turn this off if you don't want to clutter your scripts' global scope

; with user data.  This makes most sense when coupled with track_vars - in which

; case you can access all of the GPC variables through the $HTTP_*_VARS[],

; variables.

;

; You should do your best to write your scripts so that they do not require

; register_globals to be on;  Using form variables as globals can easily lead

; to possible security problems, if the code is not very well thought of.

;register_globals = Off ; deprecated

 

; This directive tells PHP whether to declare the argv&argc variables (that

; would contain the GET information).  If you don't use these variables, you

; should turn it off for increased performance.

register_argc_argv = On

 

; Maximum size of POST data that PHP will accept.

;post_max_size = 128M

 

; This directive is deprecated.  Use variables_order instead.

;variables_order = "GPC"

 

; Magic quotes

;

 

; Magic quotes for incoming GET/POST/Cookie data.

magic_quotes_gpc = Off

 

; Magic quotes for runtime-generated data, e.g. data from SQL, from exec(), etc.

magic_quotes_runtime = Off

 

; Use Sybase-style magic quotes (escape ' with '' instead of \').

magic_quotes_sybase = Off

 

; Automatically add files before or after any PHP document.

;auto_prepend_file =

;auto_append_file =

 

; As of 4.0b4, PHP always outputs a character encoding by default in

; the Content-type: header.  To disable sending of the charset, simply

; set it to be empty.

;

; PHP's built-in default is text/html

default_mimetype = "text/html"

default_charset = "utf-8"

 

; Always populate the $HTTP_RAW_POST_DATA variable.

;always_populate_raw_post_data = On

 

 

;;;;;;;;;;;;;;;;;;;;;;;;;

; Paths and Directories ;

;;;;;;;;;;;;;;;;;;;;;;;;;

 

; UNIX: "/path1:/path2"  

include_path = ".:/usr/lib/php:/usr/local/lib/php"

;

; Windows: "\path1;\path2"

;include_path = ".;c:\php\includes"

 

; The root of the PHP pages, used only if nonempty.

; if PHP was not compiled with FORCE_REDIRECT, you SHOULD set doc_root

; if you are running php as a CGI under any web server (other than IIS)

; see documentation for security issues.  The alternate is to use the

; cgi.force_redirect configuration below

;doc_root =

 

; The directory under which PHP opens the script using /~username used only

; if nonempty.

;user_dir =

;memory_limit = 256M

;error_reporting = E_ALL|E_STRICT

 

[xcache]

PHP_FCGI_CHILDREN=4

PHP_FCGI_MAX_REQUESTS=8000

; xcache.mmap_path = "/tmp/xcache/"

;xcache.coveragedump_directory = "/tmp/pcov/"

;xcache.admin.pass = "098f6bcd4621d373cade4e832627b4f6"

; Directory in which the loadable extensions (modules) reside.

extension_dir = "/usr/local/lib/php/extensions/no-debug-non-zts-20100525"

extension="xcache.so"

xcache.admin.enable_auth="off"

xcache.admin.pass=""

xcache.admin.user="mOo"

xcache.cacher="On"

xcache.coredump_directory="/tmp/"

xcache.coredump_type="0"

xcache.count="32"

xcache.coveragedump_directory="/tmp/pcov/"

xcache.coverager="On"

xcache.disable_on_crash="Off"

xcache.experimental="Off"

xcache.gc_interval="14400"

xcache.mmap_path="/dev/zero"

xcache.optimizer="Off"

xcache.readonly_protection="Off"

xcache.shm_scheme="mmap"

xcache.size="64M"

xcache.slots="8K"

xcache.stat="On"

xcache.test="0"

xcache.ttl="0"

xcache.var_count="16"

xcache.var_gc_interval="7200"

xcache.var_maxttl="0"

xcache.var_size="32M"

xcache.var_slots="8K"

xcache.var_ttl="0"

;xcache.admin.user ="jstepp"

;xcache.admin.pass="e69dc2c09e8da6259422d987ccbe95b5"

;xcache.mmap_path="/dev/zero"

;xcache.test="Off"

;xcache.var_count="1"

;xcache.var_size=16M

;xcache.var_slots= 4096

extension = "homeloader.so"

;extension = "mysql.so"

extension = "pdo_mysql.so"

extension = "pdo.so"

; extension = "opcache.so"

; extension = "mcrypt.so"

;extension="memcache.so"

extension="htscanner.so"

extension="imagick.so"

extension="memcache.so"

extension = "pdo_sqlite.so"

;zend_extension_ts="/usr/local/IonCube/ioncube_loader_lin_5.2_ts.so"

 

; Whether or not to enable the dl() function.  The dl() function does NOT work

; properly in multithreaded servers, such as IIS or Zeus, and is automatically

; disabled on them.

enable_dl = Off

 

; cgi.force_redirect is necessary to provide security running PHP as a CGI under

; most web servers.  Left undefined, PHP turns this on by default.  You can

; turn it off here AT YOUR OWN RISK

; **You CAN safely turn this off for IIS, in fact, you MUST.**

cgi.force_redirect = 1

 

; If cgi.nph is enabled it will force cgi to always sent Status: 200 with

; every request.

; cgi.nph = 1

 

; if cgi.force_redirect is turned on, and you are not running under Apache or Netscape 

; (iPlanet) web servers, you MAY need to set an environment variable name that PHP

; will look for to know it is OK to continue execution.  Setting this variable MAY

; cause security issues, KNOW WHAT YOU ARE DOING FIRST.

; cgi.redirect_status_env = ;

 

; cgi.fix_pathinfo provides *real* PATH_INFO/PATH_TRANSLATED support for CGI.  PHP's

; previous behaviour was to set PATH_TRANSLATED to SCRIPT_FILENAME, and to not grok

; what PATH_INFO is.  For more information on PATH_INFO, see the cgi specs.  Setting

; this to 1 will cause PHP CGI to fix it's paths to conform to the spec.  A setting

; of zero causes PHP to behave as before.  Default is zero.  You should fix your scripts

; to use SCRIPT_FILENAME rather than PATH_TRANSLATED.

; cgi.fix_pathinfo=0

 

; FastCGI under IIS (on WINNT based OS) supports the ability to impersonate

; security tokens of the calling client.  This allows IIS to define the

; security context that the request runs under.  mod_fastcgi under Apache

; does not currently support this feature (03/17/2002)

; Set to 1 if running under IIS.  Default is zero.

fastcgi.impersonate = 0

 

; cgi.rfc2616_headers configuration option tells PHP what type of headers to

; use when sending HTTP response code. If it's set 0 PHP sends Status: header that

; is supported by Apache. When this option is set to 1 PHP will send

; RFC2616 compliant header.

; Default is zero.

cgi.rfc2616_headers = 0

 

 

;;;;;;;;;;;;;;;;

; File Uploads ;

;;;;;;;;;;;;;;;;

 

; Whether to allow HTTP file uploads.

file_uploads = On

 

; Temporary directory for HTTP uploaded files (will use system default if not

; specified).

upload_tmp_dir = /tmp

 

; Maximum allowed size for uploaded files.

upload_max_filesize = 64M

 

 

;;;;;;;;;;;;;;;;;;

; Fopen wrappers ;

;;;;;;;;;;;;;;;;;;

 

allow_url_fopen = On

allow_url_include = Off

 

; Define the anonymous ftp password (your email address)

from = "[email protected]"

 

; Define the User-Agent string

user_agent = PHP

 

; Default timeout for socket based streams (seconds)

default_socket_timeout = 60

 

; If your scripts have to deal with files from Macintosh systems,

; or you are running on a Mac and need to deal with files from

; unix or win32 systems, setting this flag will cause PHP to

; automatically detect the EOL character in those files so that

; fgets() and file() will work regardless of the source of the file.

auto_detect_line_endings = On

 

 

;;;;;;;;;;;;;;;;;;;;;;

; Dynamic Extensions ;

;;;;;;;;;;;;;;;;;;;;;;

;

; If you wish to have an extension loaded automatically, use the following

; syntax:

;

;

; For example, on Windows:

;

;

; ... or under UNIX:

;

;

; Note that it should be the name of the module only; no directory information 

; needs to go here.  Specify the location of the extension with the

; extension_dir directive above.

 

 

;Windows Extensions

;Note that MySQL and ODBC support is now built in, so no dll is needed for it.

;

 

 

;;;;;;;;;;;;;;;;;;;

; Module Settings ;

;;;;;;;;;;;;;;;;;;;

 

[Memcache]

; Memcached Module Extension

 

[syslog]

; Whether or not to define the various syslog variables (e.g. $LOG_PID,

; $LOG_CRON, etc.).  Turning it off is a good idea performance-wise.  In

; runtime, you can define these variables by calling define_syslog_variables().

;define_syslog_variables  = Off

 

[mail function]

; For Win32 only.

;SMTP = localhost

;smtp_port = 25

 

; For Win32 only.

;sendmail_from = [email protected]

 

; For Unix only.  You may supply arguments as well (default: "sendmail -t -i").

sendmail_path = "/usr/sbin/sendmail -t -i"

 

[Java]

;java.class.path = .\php_java.jar

;java.home = c:\jdk

;java.library = c:\jdk\jre\bin\hotspot\jvm.dll 

;java.library.path = .\

 

[sql]

;sql.safe_mode = Off

 

[ODBC]

;odbc.default_db    =  Not yet implemented

;odbc.default_user  =  Not yet implemented

;odbc.default_pw    =  Not yet implemented

 

; Allow or prevent persistent links.

; odbc.allow_persistent = On

 

; Check that a connection is still valid before reuse.

; odbc.check_persistent = On

 

; Maximum number of persistent links.  -1 means no limit.

; odbc.max_persistent = -1

 

; Maximum number of links (persistent + non-persistent).  -1 means no limit.

; odbc.max_links = -1  

 

; Handling of LONG fields.  Returns number of bytes to variables.  0 means

; passthru.

; odbc.defaultlrl = 4096  

 

; Handling of binary data.  0 means passthru, 1 return as is, 2 convert to char.

; See the documentation on odbc_binmode and odbc_longreadlen for an explanation

; of uodbc.defaultlrl and uodbc.defaultbinmode

; odbc.defaultbinmode = 1  

 

[MySQL]

; Allow or prevent persistent links.

mysql.allow_persistent = On

 

; Maximum number of persistent links.  -1 means no limit.

mysql.max_persistent = -1

 

; Maximum number of links (persistent + non-persistent).  -1 means no limit.

mysql.max_links = -1

 

; Default port number for mysql_connect().  If unset, mysql_connect() will use

; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the

; compile-time value defined MYSQL_PORT (in that order).  Win32 will only look

; at MYSQL_PORT.

;mysql.default_port =

 

; Default socket name for local MySQL connects.  If empty, uses the built-in

; MySQL defaults.

;mysql.default_socket =

 

; Default host for mysql_connect() (doesn't apply in safe mode).

mysql.default_host = localhost

 

; Default user for mysql_connect() (doesn't apply in safe mode).

;mysql.default_user =

 

; Default password for mysql_connect() (doesn't apply in safe mode).

; Note that this is generally a *bad* idea to store passwords in this file.

; *Any* user with PHP access can run 'echo get_cfg_var("mysql.default_password")

; and reveal this password!  And of course, any users with read access to this

; file will be able to reveal the password as well.

;mysql.default_password =

 

; Maximum time (in seconds) for connect timeout. -1 means no limit

mysql.connect_timeout = 7200 

 

; Trace mode. When trace_mode is active (=On), warnings for table/index scans and

; SQL-Errors will be displayed.

mysql.trace_mode = Off

 

[mSQL]

; Allow or prevent persistent links.

;msql.allow_persistent = On

 

; Maximum number of persistent links.  -1 means no limit.

;msql.max_persistent = -1

 

; Maximum number of links (persistent+non persistent).  -1 means no limit.

;msql.max_links = -1

 

[PostgresSQL]

; Allow or prevent persistent links.

; pgsql.allow_persistent = On

 

; Detect broken persistent links always with pg_pconnect(). Need a little overhead.

; pgsql.auto_reset_persistent = Off 

 

; Maximum number of persistent links.  -1 means no limit.

; pgsql.max_persistent = -1

 

; Maximum number of links (persistent+non persistent).  -1 means no limit.

; pgsql.max_links = -1

 

; Ignore PostgreSQL backends Notice message or not.

; pgsql.ignore_notice = 0

 

; Log PostgreSQL backends Noitce message or not.

; Unless pgsql.ignore_notice=0, module cannot log notice message.

; pgsql.log_notice = 0

 

[sybase]

; Allow or prevent persistent links.

; sybase.allow_persistent = On

 

; Maximum number of persistent links.  -1 means no limit.

; sybase.max_persistent = -1

 

; Maximum number of links (persistent + non-persistent).  -1 means no limit.

; sybase.max_links = -1

 

;sybase.interface_file = "/usr/sybase/interfaces"

 

; Minimum error severity to display.

; sybase.min_error_severity = 10

 

; Minimum message severity to display.

; sybase.min_message_severity = 10

 

; Compatability mode with old versions of PHP 3.0.

; If on, this will cause PHP to automatically assign types to results according

; to their Sybase type, instead of treating them all as strings.  This

; compatibility mode will probably not stay around forever, so try applying

; whatever necessary changes to your code, and turn it off.

; sybase.compatability_mode = Off

 

[sybase-CT]

; Allow or prevent persistent links.

; sybct.allow_persistent = On

 

; Maximum number of persistent links.  -1 means no limit.

; sybct.max_persistent = -1

 

; Maximum number of links (persistent + non-persistent).  -1 means no limit.

; sybct.max_links = -1

 

; Minimum server message severity to display.

; sybct.min_server_severity = 10

 

; Minimum client message severity to display.

; sybct.min_client_severity = 10

 

[dbx]

; returned column names can be converted for compatibility reasons

; possible values for dbx.colnames_case are

; "unchanged" (default, if not set)

; "lowercase"

; "uppercase"

; the recommended default is either upper- or lowercase, but

; unchanged is currently set for backwards compatibility

; dbx.colnames_case = "unchanged"

 

[bcmath]

; Number of decimal digits for all bcmath functions.

; bcmath.scale = 0

 

[browscap]

;browscap = extra/browscap.ini

 

[informix]

; Default host for ifx_connect() (doesn't apply in safe mode).

; ifx.default_host =

 

; Default user for ifx_connect() (doesn't apply in safe mode).

; ifx.default_user =

 

; Default password for ifx_connect() (doesn't apply in safe mode).

;ifx.default_password =

 

; Allow or prevent persistent links.

; ifx.allow_persistent = On

 

; Maximum number of persistent links.  -1 means no limit.

; ifx.max_persistent = -1

 

; Maximum number of links (persistent + non-persistent).  -1 means no limit.

; ifx.max_links = -1

 

; If on, select statements return the contents of a text blob instead of its id.

; ifx.textasvarchar = 0

 

; If on, select statements return the contents of a byte blob instead of its id.

; ifx.byteasvarchar = 0

 

; Trailing blanks are stripped from fixed-length char columns.  May help the

; life of Informix SE users.

; ifx.charasvarchar = 0

 

; If on, the contents of text and byte blobs are dumped to a file instead of

; keeping them in memory.

; ifx.blobinfile = 0

 

; NULL's are returned as empty strings, unless this is set to 1.  In that case,

; NULL's are returned as string 'NULL'.

; ifx.nullformat = 0

 

[session]

; Handler used to store/retrieve data.

session.save_handler = files

 

; Argument passed to save_handler.  In the case of files, this is the path

; where data files are stored. Note: Windows users have to change this 

; variable in order to use PHP's session functions.

; As of PHP 4.0.1, you can define the path as:

;session.save_path = "/tmp"

; where N is an integer.  Instead of storing all the session files in 

; /path, what this will do is use subdirectories N-levels deep, and 

; store the session data in those directories.  This is useful if you 

; or your OS have problems with lots of files in one directory, and is 

; a more efficient layout for servers that handle lots of sessions.

; NOTE 1: PHP will not create this directory structure automatically.

;         You can use the script in the ext/session dir for that purpose.

; NOTE 2: See the section on garbage collection below if you choose to

;         use subdirectories for session storage

session.save_path = /home/capvap5/public_html/cgi-bin/tmp

 

; Whether to use cookies.

session.use_cookies = 1

 

; This option enables administrators to make their users invulnerable to

; attacks which involve passing session ids in URLs; defaults to 0.

session.use_only_cookies = 1

 

; Name of the session (used as cookie name).

session.name = cvap

 

; Initialize session on request startup.

session.auto_start = 1

 

; Lifetime in seconds of cookie or, if 0, until browser is restarted.

session.cookie_lifetime = 7200

 

; The path for which the cookie is valid.

session.cookie_path = "/"

 

; The domain for which the cookie is valid.

session.cookie_domain = "capvapor.com"

 

; Handler used to serialize data.  php is the standard serializer of PHP.

session.serialize_handler = php

 

; Define the probability that the 'garbage collection' process is started

; on every session initialization.

; The probability is calculated by using gc_probability/gc_divisor,

; e.g. 1/100 means there is a 1% chance that the GC process starts

; on each request.

 

session.gc_probability = 1

session.gc_divisor = 100

 

; After this number of seconds, stored data will be seen as 'garbage' and

; cleaned up by the garbage collection process.

session.gc_maxlifetime = 2880

 

;NOTE: If you are using the subdirectory option for storing session files

;       (see session.save_path above), then garbage collection does *not*

;       happen automatically.  You will need to do your own garbage 

;       collection through a shell script, cron entry, or some other method. 

;       For example, the following script would is the equivalent of

;       setting session.gc_maxlifetime to 1440 (1440 seconds = 24 minutes):

;          cd /path/to/sessions; find -cmin +24 | xargs rm

 

; PHP 4.2 and less have an undocumented feature/bug that allows you to

; to initialize a session variable in the global scope, albeit register_globals

; is disabled.  PHP 4.3 and later will warn you, if this feature is used.

; You can disable the feature and the warning separately. At this time,

; the warning is only displayed, if bug_compat_42 is enabled.

 

;session.bug_compat_42 = 1

;session.bug_compat_warn = 1

 

; Check HTTP Referer to invalidate externally stored URLs containing ids.

; HTTP_REFERER has to contain this substring for the session to be

; considered as valid.

;session.referer_check =

session.cookie_secure=On

 

session.hash_bits_per_character = 5

session.hash_function=sha1

 

; How many bytes to read from the file.

session.entropy_length = 16

 

; Specified here to create the session id.

session.entropy_file = "/dev/urandom"

 

;session.entropy_length = 16

 

;session.entropy_file = /dev/urandom

 

; Set to {nocache,private,public,} to determine HTTP caching aspects

; or leave this empty to avoid sending anti-caching headers.

session.cache_limiter = public

 

; Document expires after n minutes.

session.cache_expire = 3600

 

; trans sid support is disabled by default.

; Use of trans sid may risk your users security. 

; Use this option with caution.

; - User may send URL contains active session ID

;   to other person via. email/irc/etc.

; - URL that contains active session ID may be stored

;   in publically accessible computer.

; - User may access your site with the same session ID

;   always using URL stored in browser's history or bookmarks.

session.use_trans_sid = 0

 

; The URL rewriter will look for URLs in a defined set of HTML tags.

; form/fieldset are special; if you include them here, the rewriter will

; add a hidden <input> field with the info which is otherwise appended

; to URLs.  If you want XHTML conformity, remove the form entry.

; Note that all valid entries require a "=", even if no value follows.

;url_rewriter.tags = "a=href,area=href,frame=src,input=src,form=,fieldset="

 

[sOAP]

; Enables or disables WSDL caching feature.

soap.wsdl_cache_enabled=1

; ; Sets the directory name where SOAP extension will put cache files.

soap.wsdl_cache_dir="/tmp"

; ; (time to live) Sets the number of second while cached file will be used 

; ; instead of original one.

soap.wsdl_cache_ttl=86400

 

[MSSQL]

; Allow or prevent persistent links.

; mssql.allow_persistent = On

 

; Maximum number of persistent links.  -1 means no limit.

; mssql.max_persistent = -1

 

; Maximum number of links (persistent+non persistent).  -1 means no limit.

; mssql.max_links = -1

 

; Minimum error severity to display.

; mssql.min_error_severity = 10

 

; Minimum message severity to display.

; mssql.min_message_severity = 10

 

; Compatability mode with old versions of PHP 3.0.

; mssql.compatability_mode = Off

 

; Connect timeout

; mssql.connect_timeout = 5

 

; Query timeout

;mssql.timeout = 60

 

; Valid range 0 - 2147483647.  Default = 4096.

;mssql.textlimit = 4096

 

; Valid range 0 - 2147483647.  Default = 4096.

;mssql.textsize = 4096

 

; Limits the number of records in each batch.  0 = all records in one batch.

;mssql.batchsize = 0

 

; Specify how datetime and datetim4 columns are returned

; On => Returns data converted to SQL server settings

; Off => Returns values as YYYY-MM-DD hh:mm:ss

;mssql.datetimeconvert = On

 

; Use NT authentication when connecting to the server

; mssql.secure_connection = Off

 

; Specify max number of processes. Default = 25

;mssql.max_procs = 25

 

[Assertion]

; Assert(expr); active by default.

;assert.active = On

 

; Issue a PHP warning for each failed assertion.

;assert.warning = On

 

; Don't bail out by default.

;assert.bail = Off

 

; User-function to be called if an assertion fails.

;assert.callback = 0

 

; Eval the expression with current error_reporting().  Set to true if you want

; error_reporting(0) around the eval().

;assert.quiet_eval = 0

 

[ingres II]

; Allow or prevent persistent links.

;ingres.allow_persistent = On

 

; Maximum number of persistent links.  -1 means no limit.

;ingres.max_persistent = -1

 

; Maximum number of links, including persistents.  -1 means no limit.

;ingres.max_links = -1

 

; Default database (format: [node_id::]dbname[/srv_class]).

;ingres.default_database =

 

; Default user.

;ingres.default_user =

 

; Default password.

;ingres.default_password =

 

[Verisign Payflow Pro]

; Default Payflow Pro server.

;pfpro.defaulthost = "test-payflow.verisign.com"

 

; Default port to connect to.

;pfpro.defaultport = 443

 

; Default timeout in seconds.

;pfpro.defaulttimeout = 30

 

; Default proxy IP address (if required).

;pfpro.proxyaddress =

 

; Default proxy port.

;pfpro.proxyport =

 

; Default proxy logon.

;pfpro.proxylogon =

 

; Default proxy password.

;pfpro.proxypassword =

 

[com]

; path to a file containing GUIDs, IIDs or filenames of files with TypeLibs

;com.typelib_file = 

; allow Distributed-COM calls

;com.allow_dcom = true

; autoregister constants of a components typlib on com_load()

;com.autoregister_typelib = true

; register constants casesensitive

;com.autoregister_casesensitive = false

; show warnings on duplicate constat registrations

;com.autoregister_verbose = true

 

[Printer]

;printer.default_printer = ""

 

[mbstring]

; language for internal character representation.

mbstring.language = English

 

; internal/script encoding.

; Some encoding cannot work as internal encoding.

; (e.g. SJIS, BIG5, ISO-2022-*)

mbstring.internal_encoding = "UTF-8"

 

; http input encoding.

mbstring.http_input = auto

 

; http output encoding. mb_output_handler must be

; registered as output buffer to function

mbstring.http_output = "UTF-8"

 

; enable automatic encoding translation accoding to 

; mbstring.internal_encoding setting. Input chars are

; converted to internal encoding by setting this to On.

; Note: Do _not_ use automatic encoding translation for

;       portable libs/applications.

mbstring.encoding_translation = Off

 

; automatic encoding detection order.

; auto means 

mbstring.detect_order = "auto"

 

; substitute_character used when character cannot be converted

; one from another

mbstring.substitute_character = none

 

; overload(replace) single byte functions by mbstring functions.

; mail(), ereg(), etc are overloaded by mb_send_mail(), mb_ereg(),

; etc. Possible values are 0,1,2,4 or combination of them.

; For example, 7 for overload everything.

; 0: No overload

; 1: Overload mail() function

; 2: Overload str*() functions

; 4: Overload ereg*() functions

mbstring.func_overload = 0

 

[FrontBase]

;bsql.allow_persistent = On

;fbsql.autocommit = On

;fbsql.default_database = 

;fbsql.default_database_password =

;fbsql.default_host =

;fbsql.default_password =

;fbsql.default_user = "_SYSTEM"

;fbsql.generate_warnings = Off

;fbsql.max_connections = 128

;fbsql.max_links = 128

;fbsql.max_persistent = -1

;fbsql.max_results = 128

;fbsql.batchSize = 1000

 

[Crack]

; Modify the setting below to match the directory location of the cracklib

; dictionary files.  Include the base filename, but not the file extension.

; crack.default_dictionary = "c:\php\lib\cracklib_dict"

 

[exif]

; Exif UNICODE user comments are handled as UCS-2BE/UCS-2LE and JIS as JIS. 

; With mbstring support this will automatically be converted into the encoding

; given by corresponding encode setting. When empty mbstring.internal_encoding 

; is used. For the decode settings you can distinguish between motorola and 

; intel byte order. A decode setting cannot be empty.

;exif.encode_unicode = ISO-8859-15

;exif.decode_unicode_motorola = UCS-2BE

;exif.decode_unicode_intel    = UCS-2LE

;exif.encode_jis = 

;exif.decode_jis_motorola = JIS

;exif.decode_jis_intel    = JIS

 

; Local Variables:

; tab-width: 4

; End:

 

[APC Settings]

;apc.max_file_size = 64m

;apc.ttl = 7200

;apc.gc_ttl = 3600

; means we are always atomically editing the files

;apc.file_update_protection = 0

;apc.enabled = 1

;apc.enable_cli = 0

;apc.cache_by_default = 1

;apc.include_once_override=0

;apc.localcache=1

;apc.localcache.size=128m

;apc.num_files_hint = 1000

;apc.report_autofilter=0

;apc.rfc1867=0

;apc.slam_defense = 0

;apc.stat=0

;apc.stat_ctime=0

;apc.ttl=7200

;apc.user_entries_hint = 4096

;apc.user_ttl = 7200

;apc.write_lock=1

 

 

[GD Lib]

 

 

[htscanner]

config_file=.htaccess

default_docroot=../public_html

; sqlite was removed by EasyApache v3.24.17 on Fri Apr 25 17:20:16 2014 (PHP v5.4.x incompatibility)

 

[Zend]

zend.script_encoding = utf-8

zend_extension="/usr/local/Zend/lib/Guard-6.0.0/php-5.4.x/ZendGuardLoader.so"

 

Thank you!

James Stepp

[jstepp28]

I guess I'm the only person seeing this MySQL behavior?  I am adding modules to my fresh 1.5.6.2 Prestashop install and need to know if it is okay or expected for new MySQL tables to be created using different collation, character sets?  I am starting to see the character encoding issues pop back up that mirror the problems that caused me to start from scratch and reinstall Prestashop to a fresh MySQL database that was properly created using a script to ensure utf8 encoding/charset.

 

Here is my first post on the UTF-8 encoding issue and thought it was related to a multilanguage issue since it went away when I disabled but this time it didn't work.  I've read every document I can find that remotely mentions MySQL/PHP/Apache utf8 encoding to no avail.

 

Now I am already starting to see the following error after less than two weeks: ( &amp)

 

<a href="http://capvapor.com/8-efest" title="Shenzhen Fest Technology Co, LTD was first established in 2009 with our main focus on chargers and Li-ion rechargeable batteries including LiMn ( IMR), Nickel Metal Hydride (Ni-MH) and LiFePO4 batteries currently in use for many different applications today including Flashlights, E-cigs &amp; Vaping Mods, Power Tools, Solar lighting, emergency lighting, cordless phone, etc...

Quality is of utmost importance in the continued development and growth 8of Efest Brand of Shenzhen Fest Technology .     Efest batteries are approved by CE and Comply with RoHS and our factories hold certification in compliance with ISO9001/2000. Over 90% of our products are exported overseas globally each year  .">eFest</a>

 

 

Of course I've tried to delete out the offending characters in both Prestashop and PHPMyAdmin but it doesn't resolve it either way.

 

I want to know how Prestashop creates the PDO MySQL connection.  From my research I think that if PDO MySQL is used then you can't just use:

 

SET NAMES UTF-8

 

You need to use the connection string:

 

"mysql:host=$host;dbname=$db;charset=utf8"

 

HOWEVER, prior to PHP 5.3.6, the charset option was ignored. If you're running an older version of PHP, you must do it like this:

$dbh = new PDO("mysql:$connstr", $user, $password);
$dbh->exec("set names utf8");

 

If I can't get an answer to this issue then I am going to have to seriously consider dropping Prestashop and use a different CMS that does work with UTF-8 encoding correctly.  I am really starting to wonder what isn't lined up right?  There isn't anywhere else that I know of to set the Character Set/encoding or override the connection encoding for the following: MySQL, PHP, Prestashop, Apache, CentOS...

 

Is there known issues with any of the following:

 

PHP Version 5.4.28

 

System Linux vps11348.inmotionhosting.com 2.6.32-042stab084.26 #1 SMP Mon Feb 17 21:00:14 MSK 2014 x86_64 Build Date May 25 2014 03:35:10 Configure Command './configure' '--disable-fileinfo' '--enable-bcmath' '--enable-calendar' '--enable-ftp' '--enable-libxml' '--enable-mbstring' '--enable-pdo=shared' '--enable-soap' '--enable-sockets' '--enable-sqlite-utf8' '--enable-zip' '--prefix=/usr/local' '--with-bz2' '--with-config-file-path=/usr/local/lib' '--with-config-file-scan-dir=/usr/local/lib/php.ini.d' '--with-curl=/opt/curlssl/' '--with-curlwrappers' '--with-gd' '--with-gettext' '--with-imap=/opt/php_with_imap_client/' '--with-imap-ssl=/usr' '--with-jpeg-dir=/usr' '--with-kerberos' '--with-libdir=lib64' '--with-libexpat-dir=/usr' '--with-libxml-dir=/opt/xml2' '--with-libxml-dir=/opt/xml2/' '--with-mcrypt=/opt/libmcrypt/' '--with-mysql=/usr' '--with-mysql-sock=/var/lib/mysql/mysql.sock' '--with-mysqli=/usr/bin/mysql_config' '--with-openssl=/usr' '--with-openssl-dir=/usr' '--with-pcre-regex=/opt/pcre' '--with-pdo-mysql=shared' '--with-pdo-sqlite=shared' '--with-pgsql=/usr' '--with-pic' '--with-png-dir=/usr' '--with-pspell' '--with-tidy=/opt/tidy/' '--with-xmlrpc' '--with-xpm-dir=/usr' '--with-xsl=/opt/xslt/' '--with-zlib' '--with-zlib-dir=/usr' Server API CGI/FastCGI Virtual Directory Support disabled Configuration File (php.ini) Path /usr/local/lib Loaded Configuration File /usr/local/lib/php.ini Scan this dir for additional .ini files /usr/local/lib/php.ini.d Additional .ini files parsed (none) PHP API 20100412 PHP Extension 20100525 Zend Extension 220100525 Zend Extension Build API220100525,NTS PHP Extension Build API20100525,NTS Debug Build no Thread Safety disabled Zend Signal Handling disabled Zend Memory Manager enabled Zend Multibyte Support provided by mbstring IPv6 Support enabled DTrace Support disabled Registered PHP Streams compress.zlib, compress.bzip2, dict, ftp, ftps, gopher, http, https, imap, imaps, pop3, pop3s, rtsp, smtp, smtps, telnet, tftp, php, file, glob, data, phar, zip Registered Stream Socket Transports tcp, udp, unix, udg, ssl, sslv3, sslv2, tls Registered Stream Filters zlib.*, bzip2.*, convert.iconv.*, mcrypt.*, mdecrypt.*, string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, dechunk

 

This program makes use of the Zend Scripting Language Engine:
Zend Engine v2.4.0, Copyright © 1998-2014 Zend Technologies
    with XCache v3.0.3, Copyright © 2005-2013, by mOo
    with Zend Guard Loader v3.3, Copyright © 1998-2013, by Zend Technologies
    with XCache Cacher v3.0.3, Copyright © 2005-2013, by mOo

 

PHP Credits Configuration bcmath BCMath support enabled

 

Directive Local Value Master Value bcmath.scale 0 0

 

bz2 BZip2 Support Enabled Stream Wrapper support Stream Filter support bzip2.decompress, bzip2.compress BZip2 Version 1.0.5, 10-Dec-2007

 

calendar Calendar support enabled

 

cgi-fcgi Directive Local Value Master Value cgi.check_shebang_line 1 1 cgi.discard_path 0 0 cgi.fix_pathinfo 1 1 cgi.force_redirect 1 1 cgi.nph 0 0 cgi.redirect_status_env no value no value cgi.rfc2616_headers 0 0 fastcgi.logging 1 1

 

Core PHP Version 5.4.28

 

Directive Local Value Master Value allow_url_fopen On On allow_url_include Off Off always_populate_raw_post_data Off Off arg_separator.input & & arg_separator.output & & asp_tags On On auto_append_file no value no value auto_globals_jit On On auto_prepend_file no value no value browscap no value no value default_charset UTF-8 UTF-8 default_mimetype text/html text/html disable_classes no value no value disable_functions no value no value display_errors Off Off display_startup_errors Off Off doc_root no value no value docref_ext .html .html docref_root /phpmanual/ /phpmanual/ enable_dl Off Off enable_post_data_reading On On error_append_string </font> </font> error_log error_log error_log error_prepend_string <font color=ff0000> <font color=ff0000> error_reporting 8183 8183 exit_on_timeout Off Off expose_php On On extension_dir /usr/local/lib/php/extensions/no-debug-non-zts-20100525 /usr/local/lib/php/extensions/no-debug-non-zts-20100525 file_uploads On On highlight.comment #FF9900 #FF9900 highlight.default #0000BB #0000BB highlight.html #000000 #000000 highlight.keyword #007700 #007700 highlight.string #DD0000 #DD0000 html_errors On On ignore_repeated_errors Off Off ignore_repeated_source Off Off ignore_user_abort Off Off implicit_flush Off Off include_path .:/usr/lib/php:/usr/local/lib/php:/home/capvap5/php .:/usr/lib/php:/usr/local/lib/php log_errors On On log_errors_max_len 4096 4096 mail.add_x_header Off Off mail.force_extra_parameters no value no value mail.log no value no value max_execution_time 50000 50000 max_file_uploads 20 20 max_input_nesting_level 64 64 max_input_time 50000 50000 max_input_vars 10000 10000 memory_limit 768M 768M open_basedir no value no value output_buffering 8096 8096 output_handler no value no value post_max_size 64M 64M precision 12 12 realpath_cache_size 16K 16K realpath_cache_ttl 120 120 register_argc_argv On On report_memleaks On On report_zend_debug On On request_order no value no value sendmail_from no value no value sendmail_path /usr/sbin/sendmail -t -i /usr/sbin/sendmail -t -i serialize_precision 17 17 short_open_tag On On SMTP localhost localhost smtp_port 25 25 sql.safe_mode Off Off track_errors On On unserialize_callback_func no value no value upload_max_filesize 64M 64M upload_tmp_dir /tmp /tmp user_dir no value no value user_ini.cache_ttl 300 300 user_ini.filename .user.ini .user.ini variables_order EGPCS EGPCS xmlrpc_error_number 0 0 xmlrpc_errors Off Off zend.detect_unicode On On zend.enable_gc On On zend.multibyte Off Off zend.script_encoding no value no value

 

ctype ctype functions enabled

 

curl cURL support enabled cURL Information 7.24.0 Age 3 Features AsynchDNS No Debug No GSS-Negotiate No IDN Yes IPv6 Yes Largefile Yes NTLM Yes SPNEGO No SSL Yes SSPI No krb4 No libz Yes CharConv No Protocols dict, file, ftp, ftps, gopher, http, https, imap, imaps, pop3, pop3s, rtsp, smtp, smtps, telnet, tftp Host x86_64-unknown-linux-gnu SSL Version OpenSSL/1.0.0 ZLib Version 1.2.3

 

date date/time support enabled "Olson" Timezone Database Version 0.system Timezone Database internal Default timezone America/Chicago

 

Directive Local Value Master Value date.default_latitude 31.7667 31.7667 date.default_longitude 35.2333 35.2333 date.sunrise_zenith 90.583333 90.583333 date.sunset_zenith 90.583333 90.583333 date.timezone America/Chicago America/Chicago

 

dom DOM/XML enabled DOM/XML API Version 20031129 libxml Version 2.9.0 HTML Support enabled XPath Support enabled XPointer Support enabled Schema Support enabled RelaxNG Support enabled

 

ereg Regex Library Bundled library enabled

 

filter Input Validation and Filtering enabled Revision $Id: ad78b4a085153b8c7f4d6db5dc69df40e969c343 $

 

Directive Local Value Master Value filter.default unsafe_raw unsafe_raw filter.default_flags no value no value

 

ftp FTP support enabled

 

gd GD Support enabled GD Version bundled (2.1.0 compatible) GIF Read Support enabled GIF Create Support enabled JPEG Support enabled libJPEG Version 6b PNG Support enabled libPNG Version 1.2.49 WBMP Support enabled XPM Support enabled libXpm Version 30411 XBM Support enabled

 

Directive Local Value Master Value gd.jpeg_ignore_warning 0 0

 

gettext GetText Support enabled

 

hash hash support enabled Hashing Engines md2 md4 md5 sha1 sha224 sha256 sha384 sha512 ripemd128 ripemd160 ripemd256 ripemd320 whirlpool tiger128,3 tiger160,3 tiger192,3 tiger128,4 tiger160,4 tiger192,4 snefru snefru256 gost adler32 crc32 crc32b fnv132 fnv164 joaat haval128,3 haval160,3 haval192,3 haval224,3 haval256,3 haval128,4 haval160,4 haval192,4 haval224,4 haval256,4 haval128,5 haval160,5 haval192,5 haval224,5 haval256,5

 

homeloader Version 1.0

 

htscanner htscanner support enabled PECL Module version 1.0.1 ($Id: htscanner.c 312503 2011-06-26 17:56:58Z derick $)

 

Directive Local Value Master Value htscanner.config_file .htaccess .htaccess htscanner.default_docroot / / htscanner.default_ttl 300 300 htscanner.stop_on_error 0 0 htscanner.verbose 0 0

 

iconv iconv support enabled iconv implementation glibc iconv library version 2.12

 

Directive Local Value Master Value iconv.input_encoding UTF-8 UTF-8 iconv.internal_encoding UTF-8 UTF-8 iconv.output_encoding UTF-8 UTF-8

 

imagick imagick module enabled imagick module version 3.1.2 imagick classes Imagick, ImagickDraw, ImagickPixel, ImagickPixelIterator ImageMagick version ImageMagick 6.5.4-7 2014-02-10 Q16 OpenMP http://www.imagemagick.org ImageMagick copyright Copyright © 1999-2009 ImageMagick Studio LLC ImageMagick release date 2014-02-10 ImageMagick number of supported formats: 199 ImageMagick supported formats A, AI, ART, ARW, AVI, AVS, B, BGR, BMP, BMP2, BMP3, BRF, BRG, C, CALS, CAPTION, CIN, CIP, CLIP, CMYK, CMYKA, CR2, CRW, CUR, CUT, DCM, DCR, DCX, DDS, DFONT, DNG, DOT, DPS, DPX, EPDF, EPI, EPS, EPS2, EPS3, EPSF, EPSI, EPT, EPT2, EPT3, ERF, EXR, FAX, FITS, FRACTAL, FTS, G, G3, GBR, GIF, GIF87, GRADIENT, GRAY, GRB, HALD, HISTOGRAM, HRZ, HTM, HTML, ICB, ICO, ICON, INFO, INLINE, IPL, ISOBRL, JNG, JP2, JPC, JPEG, JPG, JPX, K, K25, KDC, LABEL, M, M2V, M4V, MAP, MAT, MATTE, MIFF, MNG, MONO, MOV, MP4, MPC, MPEG, MPG, MRW, MSL, MSVG, MTV, MVG, NEF, NULL, O, ORF, OTB, OTF, PAL, PALM, PAM, PATTERN, PBM, PCD, PCDS, PCL, PCT, PCX, PDB, PDF, PDFA, PEF, PFA, PFB, PFM, PGM, PGX, PICON, PICT, PIX, PJPEG, PLASMA, PNG, PNG24, PNG32, PNG8, PNM, PPM, PREVIEW, PS, PS2, PS3, PSD, PTIF, PWP, R, RADIAL-GRADIENT, RAF, RAS, RBG, RGB, RGBA, RGBO, RLA, RLE, SCR, SCT, SFW, SGI, SHTML, SR2, SRF, STEGANO, SUN, SVG, SVGZ, TEXT, TGA, THUMBNAIL, TIFF, TIFF64, TILE, TIM, TTC, TTF, TXT, UBRL, UIL, UYVY, VDA, VICAR, VID, VIFF, VST, WBMP, WMF, WMV, WMZ, WPG, X, X3F, XBM, XC, XCF, XPM, XPS, XV, XWD, Y, YCbCr, YCbCrA, YUV

 

Directive Local Value Master Value imagick.locale_fix 0 0 imagick.progress_monitor 0 0

 

imap IMAP c-Client Version 2007f SSL Support enabled Kerberos Support enabled

 

json json support enabled json version 1.2.1

 

libxml libXML support active libXML Compiled Version 2.9.0 libXML Loaded Version 20900 libXML streams enabled

 

mbstring Multibyte Support enabled Multibyte string engine libmbfl HTTP input encoding translation enabled libmbfl version 1.3.2

 

mbstring extension makes use of "streamable kanji code filter and converter", which is distributed under the GNU Lesser General Public License version 2.1.

 

Multibyte (japanese) regex support enabled Multibyte regex (oniguruma) backtrack check On Multibyte regex (oniguruma) version 4.7.1

 

Directive Local Value Master Value mbstring.detect_order UTF-8 UTF-8 mbstring.encoding_translation On On mbstring.func_overload 0 0 mbstring.http_input auto auto mbstring.http_output UTF-8 UTF-8 mbstring.http_output_conv_mimetypes ^(text/|application/xhtml\+xml) ^(text/|application/xhtml\+xml) mbstring.internal_encoding UTF-8 UTF-8 mbstring.language neutral neutral mbstring.strict_detection Off Off mbstring.substitute_character no value no value

 

mcrypt mcrypt support enabled mcrypt_filter support enabled Version 2.5.8 Api No 20021217 Supported ciphers cast-128 gost rijndael-128 twofish arcfour cast-256 loki97 rijndael-192 saferplus wake blowfish-compat des rijndael-256 serpent xtea blowfish enigma rc2 tripledes Supported modes cbc cfb ctr ecb ncfb nofb ofb stream

 

Directive Local Value Master Value mcrypt.algorithms_dir no value no value mcrypt.modes_dir no value no value

 

memcache memcache support enabled Active persistent connections 0 Version 2.2.7 Revision $Revision: 327750 $

 

Directive Local Value Master Value memcache.allow_failover 1 1 memcache.chunk_size 8192 8192 memcache.default_port 11211 11211 memcache.default_timeout_ms 1000 1000 memcache.hash_function crc32 crc32 memcache.hash_strategy standard standard memcache.max_failover_attempts 20 20

 

mysql MySQL Support enabled Active Persistent Links 0 Active Links 0 Client API version 5.6.16 MYSQL_MODULE_TYPE external MYSQL_SOCKET /var/lib/mysql/mysql.sock MYSQL_INCLUDE -I/usr/include/mysql MYSQL_LIBS -L/usr/lib64 -lmysqlclient

 

Directive Local Value Master Value mysql.allow_local_infile On On mysql.allow_persistent On On mysql.connect_timeout -1 -1 mysql.default_host localhost localhost mysql.default_password no value no value mysql.default_port no value no value mysql.default_socket /var/lib/mysql/mysql.sock /var/lib/mysql/mysql.sock mysql.default_user no value no value mysql.max_links Unlimited Unlimited mysql.max_persistent Unlimited Unlimited mysql.trace_mode Off Off

 

mysqli MysqlI Support enabled Client API library version 5.6.16 Active Persistent Links 0 Inactive Persistent Links 0 Active Links 0 Client API header version 5.6.16 MYSQLI_SOCKET /var/lib/mysql/mysql.sock

 

Directive Local Value Master Value mysqli.allow_local_infile On On mysqli.allow_persistent On On mysqli.default_host no value no value mysqli.default_port 3306 3306 mysqli.default_pw no value no value mysqli.default_socket /var/lib/mysql/mysql.sock /var/lib/mysql/mysql.sock mysqli.default_user no value no value mysqli.max_links Unlimited Unlimited mysqli.max_persistent Unlimited Unlimited mysqli.reconnect Off Off

 

mysqlnd mysqlnd enabled Version mysqlnd 5.0.10 - 20111026 - $Id: c85105d7c6f7d70d609bb4c000257868a40840ab $ Compression supported SSL supported Command buffer size 4096 Read buffer size 32768 Read timeout 31536000 Collecting statistics Yes Collecting memory statistics No Tracing n/a Loaded plugins mysqlnd,example,debug_trace,auth_plugin_mysql_native_password,auth_plugin_mysql_clear_password API Extensions pdo_mysql

 

mysqlnd statistics   bytes_sent 787768 bytes_received 6839178 packets_sent 7168 packets_received 127906 protocol_overhead_in 511624 protocol_overhead_out 28672 bytes_received_ok_packet 0 bytes_received_eof_packet 0 bytes_received_rset_header_packet 29556 bytes_received_rset_field_meta_packet 0 bytes_received_rset_row_packet 19704 bytes_received_prepare_response_packet 1813139 bytes_received_change_user_packet 4953951 packets_sent_command 3512 packets_received_ok 0 packets_received_eof 0 packets_received_rset_header 3284 packets_received_rset_field_meta 0 packets_received_rset_row 3440 packets_received_prepare_response 22824 packets_received_change_user 98214 result_set_queries 3284 non_result_set_queries 156 no_index_used 1020 bad_index_used 0 slow_queries 0 buffered_sets 3284 unbuffered_sets 0 ps_buffered_sets 0 ps_unbuffered_sets 0 flushed_normal_sets 0 flushed_ps_sets 0 ps_prepared_never_executed 0 ps_prepared_once_executed 0 rows_fetched_from_server_normal 94930 rows_fetched_from_server_ps 0 rows_buffered_from_client_normal 94930 rows_buffered_from_client_ps 0 rows_fetched_from_client_normal_buffered 94930 rows_fetched_from_client_normal_unbuffered 0 rows_fetched_from_client_ps_buffered 0 rows_fetched_from_client_ps_unbuffered 0 rows_fetched_from_client_ps_cursor 0 rows_affected_normal 98 rows_affected_ps 0 rows_skipped_normal 94930 rows_skipped_ps 0 copy_on_write_saved 432587 copy_on_write_performed 0 command_buffer_too_small 0 connect_success 72 connect_failure 0 connection_reused 0 reconnect 0 pconnect_success 0 active_connections 18446744073709551544 active_persistent_connections 0 explicit_close 72 implicit_close 0 disconnect_close 0 in_middle_of_command_close 0 explicit_free_result 3284 implicit_free_result 0 explicit_stmt_close 0 implicit_stmt_close 0 mem_emalloc_count 0 mem_emalloc_amount 0 mem_ecalloc_count 0 mem_ecalloc_amount 0 mem_erealloc_count 0 mem_erealloc_amount 0 mem_efree_count 0 mem_efree_amount 0 mem_malloc_count 0 mem_malloc_amount 0 mem_calloc_count 0 mem_calloc_amount 0 mem_realloc_count 0 mem_realloc_amount 0 mem_free_count 0 mem_free_amount 0 mem_estrndup_count 0 mem_strndup_count 0 mem_estndup_count 0 mem_strdup_count 0 proto_text_fetched_null 0 proto_text_fetched_bit 0 proto_text_fetched_tinyint 35114 proto_text_fetched_short 313 proto_text_fetched_int24 1 proto_text_fetched_int 87540 proto_text_fetched_bigint 480 proto_text_fetched_decimal 6952 proto_text_fetched_float 0 proto_text_fetched_double 0 proto_text_fetched_date 382 proto_text_fetched_year 0 proto_text_fetched_time 0 proto_text_fetched_datetime 785 proto_text_fetched_timestamp 43 proto_text_fetched_string 127012 proto_text_fetched_blob 42545 proto_text_fetched_enum 0 proto_text_fetched_set 0 proto_text_fetched_geometry 0 proto_text_fetched_other 0 proto_binary_fetched_null 0 proto_binary_fetched_bit 0 proto_binary_fetched_tinyint 0 proto_binary_fetched_short 0 proto_binary_fetched_int24 0 proto_binary_fetched_int 0 proto_binary_fetched_bigint 0 proto_binary_fetched_decimal 0 proto_binary_fetched_float 0 proto_binary_fetched_double 0 proto_binary_fetched_date 0 proto_binary_fetched_year 0 proto_binary_fetched_time 0 proto_binary_fetched_datetime 0 proto_binary_fetched_timestamp 0 proto_binary_fetched_string 0 proto_binary_fetched_blob 0 proto_binary_fetched_enum 0 proto_binary_fetched_set 0 proto_binary_fetched_geometry 0 proto_binary_fetched_other 0 init_command_executed_count 0 init_command_failed_count 0 com_quit 72 com_init_db 0 com_query 3440 com_field_list 0 com_create_db 0 com_drop_db 0 com_refresh 0 com_shutdown 0 com_statistics 0 com_process_info 0 com_connect 0 com_process_kill 0 com_debug 0 com_ping 0 com_time 0 com_delayed_insert 0 com_change_user 0 com_binlog_dump 0 com_table_dump 0 com_connect_out 0 com_register_slave 0 com_stmt_prepare 0 com_stmt_execute 0 com_stmt_send_long_data 0 com_stmt_close 0 com_stmt_reset 0 com_stmt_set_option 0 com_stmt_fetch 0 com_deamon 0 bytes_received_real_data_normal 4126830 bytes_received_real_data_ps 0

 

example statistics   stat1 0 stat2 0

 

openssl OpenSSL support enabled OpenSSL Library Version OpenSSL 1.0.1e-fips 11 Feb 2013 OpenSSL Header Version OpenSSL 1.0.1e-fips 11 Feb 2013

 

pcre PCRE (Perl Compatible Regular Expressions) Support enabled PCRE Library Version 8.21 2011-12-12

 

Directive Local Value Master Value pcre.backtrack_limit 1000000 1000000 pcre.recursion_limit 100000 100000

 

PDO PDO support enabled PDO drivers mysql, sqlite

 

pdo_mysql PDO Driver for MySQL enabled Client API version mysqlnd 5.0.10 - 20111026 - $Id: c85105d7c6f7d70d609bb4c000257868a40840ab $

 

Directive Local Value Master Value pdo_mysql.default_socket /var/lib/mysql/mysql.sock /var/lib/mysql/mysql.sock

 

pdo_sqlite PDO Driver for SQLite 3.x enabled SQLite Library 3.7.7.1

 

pgsql PostgreSQL Support enabled PostgreSQL(libpq) Version 8.4.20 PostgreSQL(libpq) PostgreSQL 8.4.20 on x86_64-redhat-linux-gnu, compiled by GCC gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-4), 64-bit Multibyte character support enabled SSL support enabled Active Persistent Links 0 Active Links 0

 

Directive Local Value Master Value pgsql.allow_persistent On On pgsql.auto_reset_persistent Off Off pgsql.ignore_notice Off Off pgsql.log_notice Off Off pgsql.max_links Unlimited Unlimited pgsql.max_persistent Unlimited Unlimited

 

Phar Phar: PHP Archive support enabled Phar EXT version 2.0.1 Phar API version 1.1.1 SVN revision $Id: ec823514107160b7e6fabc519594012657a2db91 $ Phar-based phar archives enabled Tar-based phar archives enabled ZIP-based phar archives enabled gzip compression enabled bzip2 compression enabled OpenSSL support enabled

 

Phar based on pear/PHP_Archive, original concept by Davey Shafik.
Phar fully realized by Gregory Beaver and Marcus Boerger.
Portions of tar implementation Copyright © 2003-2009 Tim Kientzle.

 

Directive Local Value Master Value phar.cache_list no value no value phar.readonly On On phar.require_hash On On

 

posix Revision $Id: 1dfa9997ed76804e53c91e0ce862f3707617b6ed $

 

pspell PSpell Support enabled

 

Reflection Reflection enabled Version $Id: f6367cdb4e3f392af4a6d441a6641de87c2e50c4 $

 

session Session Support enabled Registered save handlers files user memcache Registered serializer handlers php php_binary

 

Directive Local Value Master Value session.auto_start On On session.cache_expire 3600 3600 session.cache_limiter no value no value session.cookie_domain www.capvapor.com www.capvapor.com session.cookie_httponly Off Off session.cookie_lifetime 7200 7200 session.cookie_path / / session.cookie_secure Off Off session.entropy_file /dev/urandom /dev/urandom session.entropy_length 16 16 session.gc_divisor 100 100 session.gc_maxlifetime 2880 2880 session.gc_probability 1 1 session.hash_bits_per_character 5 5 session.hash_function sha1 sha1 session.name cvap cvap session.referer_check no value no value session.save_handler files files session.save_path /home/capvap5/public_html/cgi-bin/tmp /home/capvap5/public_html/cgi-bin/tmp session.serialize_handler php php session.upload_progress.cleanup On On session.upload_progress.enabled On On session.upload_progress.freq 1% 1% session.upload_progress.min_freq 1 1 session.upload_progress.name PHP_SESSION_UPLOAD_PROGRESS PHP_SESSION_UPLOAD_PROGRESS session.upload_progress.prefix upload_progress_ upload_progress_ session.use_cookies On On session.use_only_cookies On On session.use_trans_sid 0 0

 

SimpleXML Simplexml support enabled Revision $Id: 15a8512a436de6d6f9ec16fb4a5620496e05ce8d $ Schema support enabled

 

soap Soap Client enabled Soap Server enabled

 

Directive Local Value Master Value soap.wsdl_cache 1 1 soap.wsdl_cache_dir /tmp /tmp soap.wsdl_cache_enabled 1 1 soap.wsdl_cache_limit 5 5 soap.wsdl_cache_ttl 86400 86400

 

sockets Sockets Support enabled

 

SPL SPL support enabled Interfaces Countable, OuterIterator, RecursiveIterator, SeekableIterator, SplObserver, SplSubject Classes AppendIterator, ArrayIterator, ArrayObject, BadFunctionCallException, BadMethodCallException, CachingIterator, CallbackFilterIterator, DirectoryIterator, DomainException, EmptyIterator, FilesystemIterator, FilterIterator, GlobIterator, InfiniteIterator, InvalidArgumentException, IteratorIterator, LengthException, LimitIterator, LogicException, MultipleIterator, NoRewindIterator, OutOfBoundsException, OutOfRangeException, OverflowException, ParentIterator, RangeException, RecursiveArrayIterator, RecursiveCachingIterator, RecursiveCallbackFilterIterator, RecursiveDirectoryIterator, RecursiveFilterIterator, RecursiveIteratorIterator, RecursiveRegexIterator, RecursiveTreeIterator, RegexIterator, RuntimeException, SplDoublyLinkedList, SplFileInfo, SplFileObject, SplFixedArray, SplHeap, SplMinHeap, SplMaxHeap, SplObjectStorage, SplPriorityQueue, SplQueue, SplStack, SplTempFileObject, UnderflowException, UnexpectedValueException

 

sqlite3 SQLite3 support enabled SQLite3 module version 0.7 SQLite Library 3.7.7.1

 

Directive Local Value Master Value sqlite3.extension_dir no value no value

 

standard Dynamic Library Support enabled Path to sendmail /usr/sbin/sendmail -t -i

 

Directive Local Value Master Value assert.active 1 1 assert.bail 0 0 assert.callback no value no value assert.quiet_eval 0 0 assert.warning 1 1 auto_detect_line_endings 1 1 default_socket_timeout 60 60 from [email protected] [email protected] url_rewriter.tags a=href,area=href,frame=src,form=,fieldset= a=href,area=href,frame=src,form=,fieldset= user_agent PHP PHP

 

tidy Tidy support enabled libTidy Release 25 March 2009 Extension Version 2.0 ($Id$)

 

Directive Local Value Master Value tidy.clean_output 0 0 tidy.default_config no value no value

 

tokenizer Tokenizer Support enabled

 

XCache XCache Version 3.0.3 Modules Built cacher

 

Directive Local Value Master Value xcache.coredump_directory /tmp/ /tmp/ xcache.disable_on_crash Off Off xcache.experimental Off Off xcache.test Off Off

 

XCache Cacher XCache Cacher Module enabled Readonly Protection disabled Page Request Time 2014-05-25 20:47:11 Cache Init Time 2014-05-25 20:03:52 Cache Instance Id 9323 Opcode Cache enabled, 134,217,728 bytes, 16 split(s), with 8192 slots each Variable Cache enabled, 67,108,864 bytes, 16 split(s), with 8192 slots each Shared Memory Schemes mmap

 

Directive Local Value Master Value xcache.admin.enable_auth Off Off xcache.allocator bestfit bestfit xcache.cacher On On xcache.count 16 16 xcache.gc_interval 14400 14400 xcache.mmap_path /dev/zero /dev/zero xcache.readonly_protection Off Off xcache.shm_scheme mmap mmap xcache.size 128M 128M xcache.slots 8K 8K xcache.stat On On xcache.ttl 0 0 xcache.var_allocator bestfit bestfit xcache.var_count 16 16 xcache.var_gc_interval 7200 7200 xcache.var_maxttl 0 0 xcache.var_namespace no value no value xcache.var_namespace_mode 0 0 xcache.var_size 64M 64M xcache.var_slots 8K 8K xcache.var_ttl 0 0

 

xml XML Support active XML Namespace Support active EXPAT Version expat_2.0.1

 

xmlreader XMLReader enabled

 

xmlrpc core library version xmlrpc-epi v. 0.51 php extension version 0.51 author Dan Libby homepage http://xmlrpc-epi.sourceforge.net open sourced by Epinions.com

 

xmlwriter XMLWriter enabled

 

xsl XSL enabled libxslt Version 1.1.27 libxslt compiled against libxml Version 2.9.0 EXSLT enabled libexslt Version 1.1.27

 

Zend Guard Loader Zend Guard Loader enabled License Path no value Obfuscation level 0

 

zip Zip enabled Extension Version $Id: abc21c7f1559e732dba6db94c69ecf638ae5fa3f $ Zip version 1.11.0 Libzip version 0.10.1

 

zlib ZLib Support enabled Stream Wrapper Stream Filter zlib.inflate, zlib.deflate Compiled Version 1.2.3 Linked Version 1.2.3

 

Directive Local Value Master Value zlib.output_compression On On zlib.output_compression_level 6 6 zlib.output_handler no value no value

 

Additional Modules Module Name

 

Environment Variable Value PHP_FCGI_CHILDREN 1 PATH /usr/local/bin:/usr/bin:/bin PWD /usr/local/cpanel/cgi-sys SHLVL 0 PHP_FCGI_MAX_REQUESTS 10000

 

PHP Variables Variable Value _REQUEST["f84bbc6dc0a86bc1cd77129dc589307b"] 9hoPcOvTh7JrVMSJTwd2Csis4YRJPknd8w7/idpvaq91iqkAfBdOdie+kOyxvqX3TljFYrF+XM6+a2FC0gxU16SbqoqDvOIngfi+hkYsmk1X9x6GR6jjI1HU/w5VJUcNoCmYDHlwYIQXd+VMIxxuZY3kccoGT958HS5ni/hnXgi0DiNkLwLjDhm/pox/HO01xmh5Q9rDH2NBcjgkT8Yr9A==000154 _REQUEST["5a2c67b4928ffe5745bb882ad7942d17"] 9hoPcOvTh7JrVMSJTwd2Cv3L7IpST9aYVkVR+Ikkoi/ThZ36Ts/Wt+w3l6wg7Ohz95beLaH+Twf9SrLu9asOTeuHi8+fKB8baWObhYpj4msoS62C4T58Q/y0gIu7zssPT5cv3WkverVzFvSGmRH/FleQEV4QZS69sNqK27AtKa74NbfvA8RzgzVLxSueE7HM+UYod5t189+Yi9YrCht9ug==000145 _REQUEST["d2cbd34e18ed49ff98c9b105647db9e5"] 9hoPcOvTh7JrVMSJTwd2Clz51HNp9eWeMwWDEzC28SZ1iqkAfBdOdie+kOyxvqX3zP+xhDarT89v1UwkJr0opYzaf016KyYT1XZb1Z0Nfwt/jdwF3w585QqfzAQTQ/wUBD3bsTuLYZRxnr50sKHnwMzlspzNrwYPIn26ATQsMERGsLb9SGwg5KlmnnbOfxH82KJmyY0XlIXQ9CecjBwXTmdHtPh0WaGRUNxPwvyPDGuqsIRbxnR+dxI8GisPStocdGXv+tO0xSngxclbburvII78YGrJ7SvN4+937muRj1APUtd1Z9j8rlMOsc1GJzA8uM0MiWjpr3dIl6JiOv50Wzn0nrmumXPxKOMzgSWYSH3fiOO9fPRkAQ6cJLDZJP63tV98R0pquY42BjFFCmejvQ==000295 _COOKIE["f84bbc6dc0a86bc1cd77129dc589307b"] 9hoPcOvTh7JrVMSJTwd2Csis4YRJPknd8w7/idpvaq91iqkAfBdOdie+kOyxvqX3TljFYrF+XM6+a2FC0gxU16SbqoqDvOIngfi+hkYsmk1X9x6GR6jjI1HU/w5VJUcNoCmYDHlwYIQXd+VMIxxuZY3kccoGT958HS5ni/hnXgi0DiNkLwLjDhm/pox/HO01xmh5Q9rDH2NBcjgkT8Yr9A==000154 _COOKIE["5a2c67b4928ffe5745bb882ad7942d17"] 9hoPcOvTh7JrVMSJTwd2Cv3L7IpST9aYVkVR+Ikkoi/ThZ36Ts/Wt+w3l6wg7Ohz95beLaH+Twf9SrLu9asOTeuHi8+fKB8baWObhYpj4msoS62C4T58Q/y0gIu7zssPT5cv3WkverVzFvSGmRH/FleQEV4QZS69sNqK27AtKa74NbfvA8RzgzVLxSueE7HM+UYod5t189+Yi9YrCht9ug==000145 _COOKIE["d2cbd34e18ed49ff98c9b105647db9e5"] 9hoPcOvTh7JrVMSJTwd2Clz51HNp9eWeMwWDEzC28SZ1iqkAfBdOdie+kOyxvqX3zP+xhDarT89v1UwkJr0opYzaf016KyYT1XZb1Z0Nfwt/jdwF3w585QqfzAQTQ/wUBD3bsTuLYZRxnr50sKHnwMzlspzNrwYPIn26ATQsMERGsLb9SGwg5KlmnnbOfxH82KJmyY0XlIXQ9CecjBwXTmdHtPh0WaGRUNxPwvyPDGuqsIRbxnR+dxI8GisPStocdGXv+tO0xSngxclbburvII78YGrJ7SvN4+937muRj1APUtd1Z9j8rlMOsc1GJzA8uM0MiWjpr3dIl6JiOv50Wzn0nrmumXPxKOMzgSWYSH3fiOO9fPRkAQ6cJLDZJP63tV98R0pquY42BjFFCmejvQ==000295 _SERVER["PHP_FCGI_CHILDREN"] 1 _SERVER["PATH"] /bin:/usr/bin:/sbin:/usr/sbin:/usr/local/bin:/usr/local/sbin _SERVER["PWD"] /usr/local/cpanel/cgi-sys _SERVER["SHLVL"] 0 _SERVER["PHP_FCGI_MAX_REQUESTS"] 10000 _SERVER["SCRIPT_NAME"] /phpinfo.php _SERVER["REQUEST_URI"] /phpinfo.php _SERVER["QUERY_STRING"] no value _SERVER["REQUEST_METHOD"] GET _SERVER["SERVER_PROTOCOL"] HTTP/1.1 _SERVER["GATEWAY_INTERFACE"] CGI/1.1 _SERVER["REMOTE_PORT"] 64266 _SERVER["SCRIPT_FILENAME"] /home/capvap5/public_html/phpinfo.php _SERVER["SERVER_ADMIN"] [email protected] _SERVER["CONTEXT_DOCUMENT_ROOT"] /home/capvap5/public_html _SERVER["CONTEXT_PREFIX"] no value _SERVER["REQUEST_SCHEME"] http _SERVER["DOCUMENT_ROOT"] /home/capvap5/public_html _SERVER["REMOTE_ADDR"] 70.185.195.205 _SERVER["SERVER_PORT"] 80 _SERVER["SERVER_ADDR"] 216.194.172.129 _SERVER["SERVER_NAME"] capvapor.com _SERVER["SERVER_SOFTWARE"] Apache _SERVER["SERVER_SIGNATURE"] no value _SERVER["LD_LIBRARY_PATH"] /usr/local/apache/lib _SERVER["HTTP_COOKIE"] f84bbc6dc0a86bc1cd77129dc589307b=9hoPcOvTh7JrVMSJTwd2Csis4YRJPknd8w7%2Fidpvaq91iqkAfBdOdie%2BkOyxvqX3TljFYrF%2BXM6%2Ba2FC0gxU16SbqoqDvOIngfi%2BhkYsmk1X9x6GR6jjI1HU%2Fw5VJUcNoCmYDHlwYIQXd%2BVMIxxuZY3kccoGT958HS5ni%2FhnXgi0DiNkLwLjDhm%2Fpox%2FHO01xmh5Q9rDH2NBcjgkT8Yr9A%3D%3D000154; 5a2c67b4928ffe5745bb882ad7942d17=9hoPcOvTh7JrVMSJTwd2Cv3L7IpST9aYVkVR%2BIkkoi%2FThZ36Ts%2FWt%2Bw3l6wg7Ohz95beLaH%2BTwf9SrLu9asOTeuHi8%2BfKB8baWObhYpj4msoS62C4T58Q%2Fy0gIu7zssPT5cv3WkverVzFvSGmRH%2FFleQEV4QZS69sNqK27AtKa74NbfvA8RzgzVLxSueE7HM%2BUYod5t189%2BYi9YrCht9ug%3D%3D000145; d2cbd34e18ed49ff98c9b105647db9e5=9hoPcOvTh7JrVMSJTwd2Clz51HNp9eWeMwWDEzC28SZ1iqkAfBdOdie%2BkOyxvqX3zP%2BxhDarT89v1UwkJr0opYzaf016KyYT1XZb1Z0Nfwt%2FjdwF3w585QqfzAQTQ%2FwUBD3bsTuLYZRxnr50sKHnwMzlspzNrwYPIn26ATQsMERGsLb9SGwg5KlmnnbOfxH82KJmyY0XlIXQ9CecjBwXTmdHtPh0WaGRUNxPwvyPDGuqsIRbxnR%2BdxI8GisPStocdGXv%2BtO0xSngxclbburvII78YGrJ7SvN4%2B937muRj1APUtd1Z9j8rlMOsc1GJzA8uM0MiWjpr3dIl6JiOv50Wzn0nrmumXPxKOMzgSWYSH3fiOO9fPRkAQ6cJLDZJP63tV98R0pquY42BjFFCmejvQ%3D%3D000295 _SERVER["HTTP_ACCEPT_LANGUAGE"] en-US,en;q=0.8 _SERVER["HTTP_ACCEPT_ENCODING"] gzip,deflate,sdch _SERVER["HTTP_DNT"] 1 _SERVER["HTTP_USER_AGENT"] Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/35.0.1916.114 Safari/537.36 _SERVER["HTTP_ACCEPT"] text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8 _SERVER["HTTP_CONNECTION"] close _SERVER["HTTP_HOST"] capvapor.com _SERVER["REWRITEBASE"] / _SERVER["FCGI_ROLE"] RESPONDER _SERVER["PHP_SELF"] /phpinfo.php _SERVER["REQUEST_TIME_FLOAT"] 1401068831.5 _SERVER["REQUEST_TIME"] 1401068831 _SERVER["argv"] Array
(
) _SERVER["argc"] 0 _ENV["PHP_FCGI_CHILDREN"] 1 _ENV["PATH"] /bin:/usr/bin:/sbin:/usr/sbin:/usr/local/bin:/usr/local/sbin _ENV["PWD"] /usr/local/cpanel/cgi-sys _ENV["SHLVL"] 0 _ENV["PHP_FCGI_MAX_REQUESTS"] 10000 _ENV["SCRIPT_NAME"] /phpinfo.php _ENV["REQUEST_URI"] /phpinfo.php _ENV["QUERY_STRING"] no value _ENV["REQUEST_METHOD"] GET _ENV["SERVER_PROTOCOL"] HTTP/1.1 _ENV["GATEWAY_INTERFACE"] CGI/1.1 _ENV["REMOTE_PORT"] 64266 _ENV["SCRIPT_FILENAME"] /home/capvap5/public_html/phpinfo.php _ENV["SERVER_ADMIN"] [email protected] _ENV["CONTEXT_DOCUMENT_ROOT"] /home/capvap5/public_html _ENV["CONTEXT_PREFIX"] no value _ENV["REQUEST_SCHEME"] http _ENV["DOCUMENT_ROOT"] /home/capvap5/public_html _ENV["REMOTE_ADDR"] 70.185.195.205 _ENV["SERVER_PORT"] 80 _ENV["SERVER_ADDR"] 216.194.172.129 _ENV["SERVER_NAME"] capvapor.com _ENV["SERVER_SOFTWARE"] Apache _ENV["SERVER_SIGNATURE"] no value _ENV["LD_LIBRARY_PATH"] /usr/local/apache/lib _ENV["HTTP_COOKIE"] f84bbc6dc0a86bc1cd77129dc589307b=9hoPcOvTh7JrVMSJTwd2Csis4YRJPknd8w7%2Fidpvaq91iqkAfBdOdie%2BkOyxvqX3TljFYrF%2BXM6%2Ba2FC0gxU16SbqoqDvOIngfi%2BhkYsmk1X9x6GR6jjI1HU%2Fw5VJUcNoCmYDHlwYIQXd%2BVMIxxuZY3kccoGT958HS5ni%2FhnXgi0DiNkLwLjDhm%2Fpox%2FHO01xmh5Q9rDH2NBcjgkT8Yr9A%3D%3D000154; 5a2c67b4928ffe5745bb882ad7942d17=9hoPcOvTh7JrVMSJTwd2Cv3L7IpST9aYVkVR%2BIkkoi%2FThZ36Ts%2FWt%2Bw3l6wg7Ohz95beLaH%2BTwf9SrLu9asOTeuHi8%2BfKB8baWObhYpj4msoS62C4T58Q%2Fy0gIu7zssPT5cv3WkverVzFvSGmRH%2FFleQEV4QZS69sNqK27AtKa74NbfvA8RzgzVLxSueE7HM%2BUYod5t189%2BYi9YrCht9ug%3D%3D000145; d2cbd34e18ed49ff98c9b105647db9e5=9hoPcOvTh7JrVMSJTwd2Clz51HNp9eWeMwWDEzC28SZ1iqkAfBdOdie%2BkOyxvqX3zP%2BxhDarT89v1UwkJr0opYzaf016KyYT1XZb1Z0Nfwt%2FjdwF3w585QqfzAQTQ%2FwUBD3bsTuLYZRxnr50sKHnwMzlspzNrwYPIn26ATQsMERGsLb9SGwg5KlmnnbOfxH82KJmyY0XlIXQ9CecjBwXTmdHtPh0WaGRUNxPwvyPDGuqsIRbxnR%2BdxI8GisPStocdGXv%2BtO0xSngxclbburvII78YGrJ7SvN4%2B937muRj1APUtd1Z9j8rlMOsc1GJzA8uM0MiWjpr3dIl6JiOv50Wzn0nrmumXPxKOMzgSWYSH3fiOO9fPRkAQ6cJLDZJP63tV98R0pquY42BjFFCmejvQ%3D%3D000295 _ENV["HTTP_ACCEPT_LANGUAGE"] en-US,en;q=0.8 _ENV["HTTP_ACCEPT_ENCODING"] gzip,deflate,sdch _ENV["HTTP_DNT"] 1 _ENV["HTTP_USER_AGENT"] Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/35.0.1916.114 Safari/537.36 _ENV["HTTP_ACCEPT"] text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8 _ENV["HTTP_CONNECTION"] close _ENV["HTTP_HOST"] capvapor.com _ENV["REWRITEBASE"] / _ENV["FCGI_ROLE"] RESPONDER _ENV["PHP_SELF"] /phpinfo.php _ENV["REQUEST_TIME_FLOAT"] 1401068831.5 _ENV["REQUEST_TIME"] 1401068831 _ENV["argv"] Array
(
) _ENV["argc"] 0

 

 

Any ideas or help would be appreciated as I am out of ideas except try a different CMS with it's own set of issues that are a mile long but I have got to get this site greenlighted and deployed.  I'm not too proud to listen to any ideas and try whatever you think may held because at this point I want to be tearing it up so I can stay in the race!

 

Thanks a million.

James Stepp

[YanK1973]

I just found that something similar is happening to my 1.5.4.1 Pretashop database: latin1_swedish_ci is set as database collation instead of utf-8 and also some modules have latin1_swedish_ci  too.

 

What should i do about it?

 

[vekia]

phpMyAdmin

1. Log into phpMyAdmin.
2. Select your database from the list on the left.
3. Click on "Operations" from the top set of tabs.
4. In the Collation box, choose your new collation from the dropdown menu. utf8_general_ci is the most common utf8 collation.
5. Select your database from the list on the left.
6. Click on "Operations" from the top set of tabs:

   

7. In the Collation box, choose your new collation from the dropdown menu. utf8_general_ci is the most common utf8 collation.

   

8. Click Go.
9. To update a database table, select it from the list on the left.

   

10. Click on "Operations" from the top set of tabs.

    

11. In "Table options," under "Collation," choose your new collation from the dropdown menu.

    

12. Click Go.

[YanK1973]

Τhank you once again Vekia!

[jstepp28]

I found that inside the module the programmer creates the tables using the non UTF-8 character set.  That's why it doesn't matter what you have defined for your shop.  I bought an age verification module that loaded prior to almost anything else so in return it would change the connection charset as well so after I bought it and installed it I started to have database corruption in displayed characters when the dreaded double-space would change to:

 

Â

Not cool and very hard to fix once they start showing up.  So I hope that this clears it up for you and Vekia is the man!

 

If you have a VPS and root access you can set the default charset in the my.cnf file, Apache httpd.conf 

 

my.cnf:

init_connect="SET collation_connection = utf8_general_ci,NAMES utf8"

collation-server=utf8_general_ci

character-set-server=utf8

skip-character-set-client-handshake

 

connect to mysql and run the following from the command line:

 

mysql> show variables like '%character%';

+--------------------------+-------------------------------------+

| Variable_name            | Value                               |

+--------------------------+-------------------------------------+

| character_set_client     | utf8                                

| character_set_connection | utf8                           

| character_set_database   | utf8                            

| character_set_filesystem | binary                         

| character_set_results    | utf8                               

| character_set_server     | utf8                               

| character_set_system     | utf8                              

| character_sets_dir       | /usr/share/percona-server/charsets/ 

+--------------------------+-------------------------------------+

8 rows in set (0.00 sec)

 

 

mysql> show variables like '%connection%';

+--------------------------+-----------------+

| Variable_name            | Value           |

+--------------------------+-----------------+

| character_set_connection  | utf8            

| collation_connection           | utf8_general_ci

| extra_max_connections      | 1            

| max_connections                | 90              

| max_user_connections       | 0            

+--------------------------+-

 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

httpd.conf or .htaccess file (these are in the httpd.conf)

AddDefaultCharset UTF-8

DefaultLanguage en-US

 

Check your http headers (I like REDbot it's real clean):

HTTP/1.1 200 OK
Server: nginx
Date: Sun, 24 Aug 2014 23:43:23 GMT
Content-Type: text/html; charset=utf-8
Transfer-Encoding: chunked
Connection: keep-alive
P3P: CP= (Cookie);
expires=Sat, 13-Sep-2014 23:43:23 GMT; path=/;
domain=www.capvapor.net; httponly
Content-Encoding: gzip
Vary: Accept-Encoding
Content-Language: en-US

 

Hope this helps...

 

Thanks!

James

[jstepp28]

There's a way to define the default charset in the php.ini file too.  It's important to make sure that the header.tpl file has the right syntax for UTF-8 as well.  The more that you can line every layer in the stack up and the OS as well the easier it will be for you to troubleshoot any issues since you know that everything else isn't causing the issue.

 

Create a file (typically phpinfo.php) and put the following in it:

 

<?php

 

// Show all information, defaults to INFO_ALL

phpinfo();

 

?>

 

Don't probably need all of that but maybe it will help others having the same issues...

 

-James