1

Тема: Ошибка SET CHARACTER SET 'utf8';

Привет всем , нужда очень скорая помощь,
Установил все компоненты на Windows XP настроил все
Установил 2 пенели
phpMyAdmin 2.11.1версию и
phpMyAdmin-3.3.8 версию
В phpMyAdmin 2.11.1 все работает прекрасно (ну почти)))
А в phpMyAdmin-3.3.8 при авторизации пишет

SET CHARACTER SET 'utf8'; 

Ответ MySQL:  
#1064 - You have an error in your SQL syntax near ''utf8'' at line 1

Что только не пробовал и что только не делал , весь гугл и яндексом перелопатил
Уже 2 суток не сплю)))
В чем может быть проблема ?
Уже по всем настройкам пробежал и конфиги все сделал и толку 0

2 (изменено: DmitryV, 2010-11-10 22:16:31)

Re: Ошибка SET CHARACTER SET 'utf8';

Файлы конфигов выложите phpmyadmin.
SET CHARACTER SET 'utf8'; от куда запись у Вас такая вылезает?
На моей странице есть мой скайп стукните щас разберемся и поправим...
создайте файл test.php
с содержимым:

<?php
phpinfo();
?>

запросите его с сервера, и посмотрим если в нем у Вас тоже полезут такие ошибки то тут надо смотреть не pma а настройки php и может какой скипт прописан при старте сценарев на php.

3 (изменено: seelf, 2010-11-10 22:32:57)

Re: Ошибка SET CHARACTER SET 'utf8';

DmitryV сказал:

SET CHARACTER SET 'utf8'; от куда запись у Вас такая вылезает?

При переходе в http://localhost/phpMyAdmin-3.3.8-all-languages/
Скайпа нетб но есть ася 520879

Вот конфиг

<?php
  $i = 0;
  $i++;

  $cfg['Servers'][$i]['verbose'] = 'demo';
  $cfg['Servers'][$i]['host'] = 'localhost';
  $cfg['Servers'][$i]['extension'] = 'mysqli';
  $cfg['Servers'][$i]['connect_type'] = 'tcp';
  $cfg['Servers'][$i]['compress'] = false;
  $cfg['Servers'][$i]['auth_type'] = 'config';
  $cfg['Servers'][$i]['user'] = 'root';
  $cfg['Servers'][$i]['password'] = 'Пароль; 
  $cfg['Servers'][$i]['auth_swekey_config'] = './swekey.conf';
  $cfg['Servers'][$i]['controluser'] = 'pma'; 
  $cfg['Servers'][$i]['controlpass'] = 'Пароль'; 
  $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
  $cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';
  $cfg['Servers'][$i]['relation'] = 'pma_relation';
  $cfg['Servers'][$i]['table_info'] = 'pma_table_info';
  $cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';
  $cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';
  $cfg['Servers'][$i]['column_info'] = 'pma_column_info';
  $cfg['Servers'][$i]['history'] = 'pma_history';
  $cfg['Servers'][$i]['tracking'] = 'pma_tracking';
  $cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';
  $cfg['blowfish_secret'] = '4c0c1272762599.39723094';

?>

Файл index.php с кодом инфы

System     Windows NT USERPC 5.1 build 2600 
Build Date     Sep 16 2009 19:39:11 
Configure Command     cscript /nologo configure.js "--enable-snapshot-build" "--enable-debug-pack" "--with-snapshot-template=d:\php-sdk\snap_5_2\vc6\x86\template" "--with-php-build=d:\php-sdk\snap_5_2\vc6\x86\php_build" "--with-pdo-oci=D:\php-sdk\oracle\instantclient10\sdk,shared" "--with-oci8=D:\php-sdk\oracle\instantclient10\sdk,shared" 
Server API     CGI/FastCGI 
Virtual Directory Support     enabled 
Configuration File (php.ini) Path     C:\WINDOWS 
Loaded Configuration File     D:\server\php6\php.ini 
Scan this dir for additional .ini files     (none) 
additional .ini files parsed     (none) 
PHP API     20041225 
PHP Extension     20060613 
Zend Extension     220060519 
Debug Build     no 
Thread Safety     enabled 
Zend Memory Manager     enabled 
IPv6 Support     enabled 
Registered PHP Streams     php, file, data, http, ftp, compress.zlib 
Registered Stream Socket Transports     tcp, udp 
Registered Stream Filters     convert.iconv.*, string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, zlib.* 

This program makes use of the Zend Scripting Language Engine:
Zend Engine v2.2.0, Copyright (c) 1998-2009 Zend Technologies
    with Zend Extension Manager v1.2.0, Copyright (c) 2003-2007, by Zend Technologies
    with Zend Optimizer v3.3.0, Copyright (c) 1998-2007, by Zend Technologies


PHP Credits
Configuration
PHP CoreDirective    Local Value    Master Value
allow_call_time_pass_reference    On    On
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    Off    Off
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    no value    no value
default_mimetype    text/html    text/html
define_syslog_variables    Off    Off
disable_classes    no value    no value
disable_functions    no value    no value
display_errors    On    On
display_startup_errors    Off    Off
doc_root    no value    no value
docref_ext    no value    no value
docref_root    no value    no value
enable_dl    On    On
error_append_string    <script language=JavaScript src='/denwer/errors/phperror_js.php'></script>    <script language=JavaScript src='/denwer/errors/phperror_js.php'></script>
error_log    no value    no value
error_prepend_string    <!--error-->    <!--error-->
error_reporting    6135    6135
expose_php    On    On
extension_dir    D:/server/php6/ext/    D:/server/php6/ext/
file_uploads    On    On
highlight.bg    #FFFFFF    #FFFFFF
highlight.comment    #FF8000    #FF8000
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    .;c:\php\includes    .;c:\php\includes
log_errors    Off    Off
log_errors_max_len    1024    1024
magic_quotes_gpc    On    On
magic_quotes_runtime    Off    Off
magic_quotes_sybase    Off    Off
mail.force_extra_parameters    no value    no value
max_execution_time    30    30
max_input_nesting_level    64    64
max_input_time    60    60
memory_limit    128M    128M
open_basedir    no value    no value
output_buffering    no value    no value
output_handler    no value    no value
post_max_size    16M    16M
precision    12    12
realpath_cache_size    16K    16K
realpath_cache_ttl    120    120
register_argc_argv    On    On
register_globals    Off    Off
register_long_arrays    On    On
report_memleaks    On    On
report_zend_debug    On    On
safe_mode    Off    Off
safe_mode_exec_dir    no value    no value
safe_mode_gid    Off    Off
safe_mode_include_dir    no value    no value
sendmail_from    me@localhost.com    me@localhost.com
sendmail_path    D:/server/sendmail -t -i    D:/server/sendmail -t -i
serialize_precision    100    100
short_open_tag    On    On
SMTP    localhost    localhost
smtp_port    25    25
sql.safe_mode    Off    Off
track_errors    Off    Off
unserialize_callback_func    no value    no value
upload_max_filesize    32M    32M
upload_tmp_dir    D:/server/php6/tmp    D:/server/php6/tmp
user_dir    no value    no value
variables_order    EGPCS    EGPCS
xmlrpc_error_number    0    0
xmlrpc_errors    Off    Off
y2k_compliance    On    On
zend.ze1_compatibility_mode    Off    Off


bcmathBCMath support     enabled 


calendarCalendar support     enabled 


cgi-fcgiDirective    Local Value    Master Value
cgi.check_shebang_line    1    1
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.impersonate    0    0
fastcgi.logging    1    1


com_dotnetCOM support    enabled
DCOM support    disabled
.Net support    enabled

Directive    Local Value    Master Value
com.allow_dcom    0    0
com.autoregister_casesensitive    1    1
com.autoregister_typelib    0    0
com.autoregister_verbose    0    0
com.code_page    no value    no value
com.typelib_file    no value    no value


ctypectype functions     enabled 


curlcURL support     enabled 
cURL Information     libcurl/7.19.6 OpenSSL/0.9.8k zlib/1.2.3 


datedate/time support     enabled 
"Olson" Timezone Database Version     2009.13 
Timezone Database     internal 
Default timezone     Europe/Moscow 

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    no value    no value


domDOM/XML     enabled 
DOM/XML API Version     20031129 
libxml Version     2.7.3 
HTML Support     enabled 
XPath Support     enabled 
XPointer Support     enabled 
Schema Support     enabled 
RelaxNG Support     enabled 


filterInput Validation and Filtering     enabled 
Revision     $Revision: 288083 $ 

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


ftpFTP support     enabled 


gdGD Support     enabled 
GD Version     bundled (2.0.34 compatible) 
FreeType Support     enabled 
FreeType Linkage     with freetype 
FreeType Version     2.1.9 
T1Lib Support     enabled 
GIF Read Support     enabled 
GIF Create Support     enabled 
JPG Support     enabled 
PNG Support     enabled 
WBMP Support     enabled 
XBM Support     enabled 


hashhash support     enabled 
Hashing Engines     md2 md4 md5 sha1 sha256 sha384 sha512 ripemd128 ripemd160 ripemd256 ripemd320 whirlpool tiger128,3 tiger160,3 tiger192,3 tiger128,4 tiger160,4 tiger192,4 snefru gost adler32 crc32 crc32b 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 


iconviconv support     enabled 
iconv implementation     "libiconv" 
iconv library version     1.11 

Directive    Local Value    Master Value
iconv.input_encoding    ISO-8859-1    ISO-8859-1
iconv.internal_encoding    ISO-8859-1    ISO-8859-1
iconv.output_encoding    ISO-8859-1    ISO-8859-1


jsonjson support     enabled 
json version     1.2.1 


libxmllibXML support     active 
libXML Version     2.7.3 
libXML streams     enabled 


mbstringMultibyte Support     enabled 
Multibyte string engine     libmbfl 
Multibyte (japanese) regex support     enabled 
Multibyte regex (oniguruma) version     4.4.4 
Multibyte regex (oniguruma) backtrack check     On 

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

Directive    Local Value    Master Value
mbstring.detect_order    no value    no value
mbstring.encoding_translation    Off    Off
mbstring.func_overload    0    0
mbstring.http_input    pass    pass
mbstring.http_output    pass    pass
mbstring.internal_encoding    no value    no value
mbstring.language    neutral    neutral
mbstring.strict_detection    Off    Off
mbstring.substitute_character    no value    no value


mcryptmcrypt support    enabled
Version     2.5.7 
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


mysqlMySQL Support    enabled
Active Persistent Links     0 
Active Links     0 
Client API version     5.0.51a 

Directive    Local Value    Master Value
mysql.allow_persistent    On    On
mysql.connect_timeout    60    60
mysql.default_host    no value    no value
mysql.default_password    no value    no value
mysql.default_port    no value    no value
mysql.default_socket    no value    no value
mysql.default_user    no value    no value
mysql.max_links    Unlimited    Unlimited
mysql.max_persistent    Unlimited    Unlimited
mysql.trace_mode    Off    Off


mysqliMysqlI Support    enabled
Client API library version     5.0.51a 
Client API header version     5.0.51a 
MYSQLI_SOCKET     /tmp/mysql.sock 

Directive    Local Value    Master Value
mysqli.default_host    no value    no value
mysqli.default_port    3306    3306
mysqli.default_pw    no value    no value
mysqli.default_socket    no value    no value
mysqli.default_user    no value    no value
mysqli.max_links    Unlimited    Unlimited
mysqli.reconnect    Off    Off


odbcODBC Support    enabled
Active Persistent Links     0 
Active Links     0 
ODBC library     Win32 

Directive    Local Value    Master Value
odbc.allow_persistent    On    On
odbc.check_persistent    On    On
odbc.default_cursortype    Static cursor    Static cursor
odbc.default_db    no value    no value
odbc.default_pw    no value    no value
odbc.default_user    no value    no value
odbc.defaultbinmode    return as is    return as is
odbc.defaultlrl    return up to 4096 bytes    return up to 4096 bytes
odbc.max_links    Unlimited    Unlimited
odbc.max_persistent    Unlimited    Unlimited


pcrePCRE (Perl Compatible Regular Expressions) Support     enabled 
PCRE Library Version     7.9 2009-04-11 

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


PDOPDO support    enabled
PDO drivers     mysql 


pdo_mysqlPDO Driver for MySQL, client library version    5.0.51a


ReflectionReflection    enabled
Version     $Id: php_reflection.c 287991 2009-09-03 14:02:51Z sebastian $ 


sessionSession Support     enabled 
Registered save handlers     files user 
Registered serializer handlers     php php_binary wddx 

Directive    Local Value    Master Value
session.auto_start    Off    Off
session.bug_compat_42    On    On
session.bug_compat_warn    On    On
session.cache_expire    180    180
session.cache_limiter    nocache    nocache
session.cookie_domain    no value    no value
session.cookie_httponly    Off    Off
session.cookie_lifetime    0    0
session.cookie_path    /    /
session.cookie_secure    Off    Off
session.entropy_file    no value    no value
session.entropy_length    0    0
session.gc_divisor    100    100
session.gc_maxlifetime    3440    3440
session.gc_probability    1    1
session.hash_bits_per_character    4    4
session.hash_function    0    0
session.name    PHPSESSID    PHPSESSID
session.referer_check    no value    no value
session.save_handler    files    files
session.save_path    D:/server/php5/tmp    D:/server/php5/tmp
session.serialize_handler    php    php
session.use_cookies    On    On
session.use_only_cookies    Off    Off
session.use_trans_sid    0    0


SimpleXMLSimplexml support    enabled
Revision     $Revision: 272374 $ 
Schema support     enabled 


SPLSPL support    enabled
Interfaces     Countable, OuterIterator, RecursiveIterator, SeekableIterator, SplObserver, SplSubject 
Classes     AppendIterator, ArrayIterator, ArrayObject, BadFunctionCallException, BadMethodCallException, CachingIterator, DirectoryIterator, DomainException, EmptyIterator, FilterIterator, InfiniteIterator, InvalidArgumentException, IteratorIterator, LengthException, LimitIterator, LogicException, NoRewindIterator, OutOfBoundsException, OutOfRangeException, OverflowException, ParentIterator, RangeException, RecursiveArrayIterator, RecursiveCachingIterator, RecursiveDirectoryIterator, RecursiveFilterIterator, RecursiveIteratorIterator, RecursiveRegexIterator, RegexIterator, RuntimeException, SimpleXMLIterator, SplFileInfo, SplFileObject, SplObjectStorage, SplTempFileObject, UnderflowException, UnexpectedValueException 


standardRegex Library     Bundled library enabled 
Dynamic Library Support     enabled 
Path to sendmail     D:/server/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    0    0
default_socket_timeout    60    60
safe_mode_allowed_env_vars    PHP_    PHP_
safe_mode_protected_env_vars    LD_LIBRARY_PATH    LD_LIBRARY_PATH
url_rewriter.tags    a=href,area=href,frame=src,input=src,form=,fieldset=    a=href,area=href,frame=src,input=src,form=,fieldset=
user_agent    no value    no value


tokenizerTokenizer Support     enabled 


wddxWDDX Support    enabled
WDDX Session Serializer     enabled 


xmlXML Support     active 
XML Namespace Support     active 
libxml2 Version     2.7.3 


xmlreaderXMLReader     enabled 


xmlwriterXMLWriter     enabled 


Zend OptimizerOptimization Pass 1     enabled 
Optimization Pass 2     enabled 
Optimization Pass 3     enabled 
Optimization Pass 4     enabled 
Optimization Pass 9     disabled 
Zend Loader     enabled 
License Path     no value 
Obfuscation level     3 


zlibZLib Support     enabled 
Stream Wrapper support     compress.zlib:// 
Stream Filter support     zlib.inflate, zlib.deflate 
Compiled Version     1.2.3 
Linked Version     1.2.3 

Directive    Local Value    Master Value
zlib.output_compression    Off    Off
zlib.output_compression_level    -1    -1
zlib.output_handler    no value    no value


Additional ModulesModule Name


EnvironmentVariable    Value
REDIRECT_HANDLER     application/x-httpd-php6 
REDIRECT_STATUS     200 
HTTP_USER_AGENT     Opera/9.63 (Windows NT 5.1; U; MRA 5.7 (build 03757); MRSPUTNIK OW 2, 3, 0, 288; ru) Presto/2.1.1 
HTTP_HOST     localhost 
HTTP_ACCEPT     text/html, application/xml;q=0.9, application/xhtml+xml, image/png, image/jpeg, image/gif, image/x-xbitmap, */*;q=0.1 
HTTP_ACCEPT_LANGUAGE     ru-RU,ru;q=0.9,en;q=0.8 
HTTP_ACCEPT_CHARSET     iso-8859-1, utf-8, utf-16, *;q=0.1 
HTTP_ACCEPT_ENCODING     deflate, gzip, x-gzip, identity, *;q=0 
HTTP_COOKIE     vc=4 
HTTP_COOKIE2     $Version=1 
HTTP_CONNECTION     Keep-Alive, TE 
HTTP_TE     deflate, gzip, chunked, identity, trailers 
PATH     D:\server\php6\;D:\server\Perl\bin\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;D:\server\mysql\bin 
SystemRoot     C:\WINDOWS 
COMSPEC     C:\WINDOWS\system32\cmd.exe 
PATHEXT     .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH 
WINDIR     C:\WINDOWS 
SERVER_SIGNATURE     <address>Apache/2.2.2 (Win32) Server at localhost Port 80</address> 
SERVER_SOFTWARE     Apache/2.2.2 (Win32) 
SERVER_NAME     localhost 
SERVER_ADDR     127.0.0.1 
SERVER_PORT     80 
REMOTE_ADDR     127.0.0.1 
DOCUMENT_ROOT     D:/server/www 
SERVER_ADMIN     localhost@127.0.0.1 
SCRIPT_FILENAME     D:\server\www\index.php 
REMOTE_PORT     12504 
REDIRECT_URL     /index.php 
GATEWAY_INTERFACE     CGI/1.1 
SERVER_PROTOCOL     HTTP/1.1 
REQUEST_METHOD     GET 
QUERY_STRING     no value 
REQUEST_URI     / 
SCRIPT_NAME     /index.php 
ORIG_SCRIPT_FILENAME     D:/server/php6/php.exe 
ORIG_PATH_INFO     /index.php 
ORIG_PATH_TRANSLATED     D:\server\www\index.php 
ORIG_SCRIPT_NAME     /php6/php.exe 


PHP VariablesVariable    Value
_REQUEST["vc"]    4
_COOKIE["vc"]    4
_SERVER["REDIRECT_HANDLER"]    application/x-httpd-php6
_SERVER["REDIRECT_STATUS"]    200
_SERVER["HTTP_USER_AGENT"]    Opera/9.63 (Windows NT 5.1; U; MRA 5.7 (build 03757); MRSPUTNIK OW 2, 3, 0, 288; ru) Presto/2.1.1
_SERVER["HTTP_HOST"]    localhost
_SERVER["HTTP_ACCEPT"]    text/html, application/xml;q=0.9, application/xhtml+xml, image/png, image/jpeg, image/gif, image/x-xbitmap, */*;q=0.1
_SERVER["HTTP_ACCEPT_LANGUAGE"]    ru-RU,ru;q=0.9,en;q=0.8
_SERVER["HTTP_ACCEPT_CHARSET"]    iso-8859-1, utf-8, utf-16, *;q=0.1
_SERVER["HTTP_ACCEPT_ENCODING"]    deflate, gzip, x-gzip, identity, *;q=0
_SERVER["HTTP_COOKIE"]    vc=4
_SERVER["HTTP_COOKIE2"]    $Version=1
_SERVER["HTTP_CONNECTION"]    Keep-Alive, TE
_SERVER["HTTP_TE"]    deflate, gzip, chunked, identity, trailers
_SERVER["PATH"]    D:\server\php6\;D:\server\Perl\bin\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;D:\server\mysql\bin
_SERVER["SystemRoot"]    C:\WINDOWS
_SERVER["COMSPEC"]    C:\WINDOWS\system32\cmd.exe
_SERVER["PATHEXT"]    .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
_SERVER["WINDIR"]    C:\WINDOWS
_SERVER["SERVER_SIGNATURE"]    <address>Apache/2.2.2 (Win32) Server at localhost Port 80</address> 
_SERVER["SERVER_SOFTWARE"]    Apache/2.2.2 (Win32)
_SERVER["SERVER_NAME"]    localhost
_SERVER["SERVER_ADDR"]    127.0.0.1
_SERVER["SERVER_PORT"]    80
_SERVER["REMOTE_ADDR"]    127.0.0.1
_SERVER["DOCUMENT_ROOT"]    D:/server/www
_SERVER["SERVER_ADMIN"]    localhost@127.0.0.1
_SERVER["SCRIPT_FILENAME"]    D:\server\www\index.php
_SERVER["REMOTE_PORT"]    12504
_SERVER["REDIRECT_URL"]    /index.php
_SERVER["GATEWAY_INTERFACE"]    CGI/1.1
_SERVER["SERVER_PROTOCOL"]    HTTP/1.1
_SERVER["REQUEST_METHOD"]    GET
_SERVER["QUERY_STRING"]    no value
_SERVER["REQUEST_URI"]    /
_SERVER["SCRIPT_NAME"]    /index.php
_SERVER["ORIG_SCRIPT_FILENAME"]    D:/server/php6/php.exe
_SERVER["ORIG_PATH_INFO"]    /index.php
_SERVER["ORIG_PATH_TRANSLATED"]    D:\server\www\index.php
_SERVER["ORIG_SCRIPT_NAME"]    /php6/php.exe
_SERVER["PHP_SELF"]    /index.php
_SERVER["REQUEST_TIME"]    1275866928
_SERVER["argv"]    Array
(
)
_SERVER["argc"]    0
_ENV["REDIRECT_HANDLER"]    application/x-httpd-php6
_ENV["REDIRECT_STATUS"]    200
_ENV["HTTP_USER_AGENT"]    Opera/9.63 (Windows NT 5.1; U; MRA 5.7 (build 03757); MRSPUTNIK OW 2, 3, 0, 288; ru) Presto/2.1.1
_ENV["HTTP_HOST"]    localhost
_ENV["HTTP_ACCEPT"]    text/html, application/xml;q=0.9, application/xhtml+xml, image/png, image/jpeg, image/gif, image/x-xbitmap, */*;q=0.1
_ENV["HTTP_ACCEPT_LANGUAGE"]    ru-RU,ru;q=0.9,en;q=0.8
_ENV["HTTP_ACCEPT_CHARSET"]    iso-8859-1, utf-8, utf-16, *;q=0.1
_ENV["HTTP_ACCEPT_ENCODING"]    deflate, gzip, x-gzip, identity, *;q=0
_ENV["HTTP_COOKIE"]    vc=4
_ENV["HTTP_COOKIE2"]    $Version=1
_ENV["HTTP_CONNECTION"]    Keep-Alive, TE
_ENV["HTTP_TE"]    deflate, gzip, chunked, identity, trailers
_ENV["PATH"]    D:\server\php6\;D:\server\Perl\bin\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;D:\server\mysql\bin
_ENV["SystemRoot"]    C:\WINDOWS
_ENV["COMSPEC"]    C:\WINDOWS\system32\cmd.exe
_ENV["PATHEXT"]    .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
_ENV["WINDIR"]    C:\WINDOWS
_ENV["SERVER_SIGNATURE"]    <address>Apache/2.2.2 (Win32) Server at localhost Port 80</address> 
_ENV["SERVER_SOFTWARE"]    Apache/2.2.2 (Win32)
_ENV["SERVER_NAME"]    localhost
_ENV["SERVER_ADDR"]    127.0.0.1
_ENV["SERVER_PORT"]    80
_ENV["REMOTE_ADDR"]    127.0.0.1
_ENV["DOCUMENT_ROOT"]    D:/server/www
_ENV["SERVER_ADMIN"]    localhost@127.0.0.1
_ENV["SCRIPT_FILENAME"]    D:\server\www\index.php
_ENV["REMOTE_PORT"]    12504
_ENV["REDIRECT_URL"]    /index.php
_ENV["GATEWAY_INTERFACE"]    CGI/1.1
_ENV["SERVER_PROTOCOL"]    HTTP/1.1
_ENV["REQUEST_METHOD"]    GET
_ENV["QUERY_STRING"]    no value
_ENV["REQUEST_URI"]    /
_ENV["SCRIPT_NAME"]    /index.php
_ENV["ORIG_SCRIPT_FILENAME"]    D:/server/php6/php.exe
_ENV["ORIG_PATH_INFO"]    /index.php
_ENV["ORIG_PATH_TRANSLATED"]    D:\server\www\index.php
_ENV["ORIG_SCRIPT_NAME"]    /php6/php.exe

4 (изменено: DmitryV, 2010-11-10 22:44:49)

Re: Ошибка SET CHARACTER SET 'utf8';

$cfg['Servers'][$i]['auth_swekey_config'] = './swekey.conf';
используеться только при методе интификации cookie если у Вас метод конфиг то эта инструкция не поддерживаеться уберите её или если Вы авторизуетесь через USB ключ то метод авторизации смените на cookie.

5

Re: Ошибка SET CHARACTER SET 'utf8';

seelf сказал:

You have an error in your SQL syntax near ''utf8''

Попробуйте в my.ini очистить директиву sql-mode, после чего перезагрузите MySQL.

sql-mode=""

6

Re: Ошибка SET CHARACTER SET 'utf8';

там все хуже, щас настраиваем....

7

Re: Ошибка SET CHARACTER SET 'utf8';

Вопрос закрыт  -  причина  много копицй програм ))))) big_smile