Sono su hosting aruba linux.
Tutto ok fino a quando si tratta di eseguire il codice per l'importazione del DB. In pratica ogni singola istruzione fallisce col medesimo errore:
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=utf8' at line 6
di seguito le caratteristiche phpinfo()
PHP Version 4.4.7
|
| System |
Linux webx63.ad.aruba.it 2.6.18-53.1.4.el5PAE #1 SMP Wed Feb 13 15:24:10 CET 2008 i686 |
| Build Date |
Nov 13 2007 11:19:00 |
| Configure Command |
'./configure' '--prefix=/php_4.4.7' '--with-mysql=/usr' '--with-jpeg-dir=/usr/lib/' '--with-zlib' '--with-png-dir=/usr/lib' '--with-config-file-path=/etc/apache/' '--with-gd' '--disable-debug' '--enable-inline-optimization' '--enable-memory-limit' '--with-imap=/usr/local/imap-2004g/' '--with-imap-ssl' '--with-mcrypt' '--enable-ftp' '--enable-xslt' '--with-xslt-sablot' '--with-ttf' '--with-freetype-dir=/usr/include/freetype2/freetype/' '--with-t1lib=/usr/include/' '--with-gettext' '--enable-exif' '--enable-bcmath' '--enable-calendar' '--with-dom' '--enable-discard-path' '--disable-path' '--with-bz2' '--with-mhash' '--with-mime-magic' '--with-curl' '--enable-wddx' '--with-expat' '--disable-ipv6' |
| Server API |
CGI |
| Virtual Directory Support |
disabled |
| Configuration File (php.ini) Path |
/etc/apache/php.ini |
| PHP API |
20020918 |
| PHP Extension |
20020429 |
| Zend Extension |
20050606 |
| Debug Build |
no |
| Zend Memory Manager |
enabled |
| Thread Safety |
disabled |
| Registered PHP Streams |
php, http, ftp, compress.bzip2, compress.zlib |
 This program makes use of the Zend Scripting Language Engine:
Zend Engine v1.3.0, Copyright (c) 1998-2004 Zend Technologies |
Configuration
PHP Core
| Directive |
Local Value |
Master Value |
| allow_call_time_pass_reference |
On |
On |
| allow_url_fopen |
On |
On |
| 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_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 |
no value |
no value |
| error_log |
no value |
no value |
| error_prepend_string |
no value |
no value |
| error_reporting |
2039 |
2039 |
| expose_php |
On |
On |
| extension_dir |
./ |
./ |
| file_uploads |
On |
On |
| gpc_order |
GPC |
GPC |
| highlight.bg |
#FFFFFF |
#FFFFFF |
| highlight.comment |
#FF9900 |
#FF9900 |
| highlight.default |
#0000CC |
#0000CC |
| highlight.html |
#000000 |
#000000 |
| highlight.keyword |
#006600 |
#006600 |
| highlight.string |
#CC0000 |
#CC0000 |
| 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 |
.:/php/lib/php/ |
.:/php/lib/php/ |
| log_errors |
On |
On |
| log_errors_max_len |
1024 |
1024 |
| magic_quotes_gpc |
On |
On |
| magic_quotes_runtime |
Off |
Off |
| magic_quotes_sybase |
Off |
Off |
| max_execution_time |
120 |
120 |
| max_input_time |
-1 |
-1 |
| memory_limit |
24M |
24M |
| open_basedir |
no value |
no value |
| output_buffering |
4096 |
4096 |
| output_handler |
no value |
no value |
| post_max_size |
8M |
8M |
| precision |
14 |
14 |
| register_argc_argv |
Off |
Off |
| register_globals |
On |
On |
| report_memleaks |
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 |
/usr/sbin/sendmail -t -i |
/usr/sbin/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 |
50M |
50M |
| upload_tmp_dir |
/tmp/ |
/tmp/ |
| user_dir |
home |
home |
| variables_order |
GPCS |
GPCS |
| xmlrpc_error_number |
0 |
0 |
| xmlrpc_errors |
Off |
Off |
| y2k_compliance |
Off |
Off |
| BZip2 Support |
Enabled |
| BZip2 Version |
1.0.3, 15-Feb-2005 |
| CURL support |
enabled |
| CURL Information |
libcurl/7.15.5 OpenSSL/0.9.8b zlib/1.2.3 libidn/0.6.5 |
| DOM/XML |
enabled |
| DOM/XML API Version |
20020815 |
| libxml Version |
20626 |
| HTML Support |
enabled |
| XPath Support |
enabled |
| XPointer Support |
enabled |
| EXIF Support |
enabled |
| EXIF Version |
1.4 $Id: exif.c,v 1.118.2.37.2.7 2007/01/09 11:38:04 tony2001 Exp $ |
| Supported EXIF Version |
0220 |
| Supported filetypes |
JPEG,TIFF |
| GD Support |
enabled |
| GD Version |
bundled (2.0.28 compatible) |
| FreeType Support |
enabled |
| FreeType Linkage |
with freetype |
| T1Lib Support |
enabled |
| GIF Read Support |
enabled |
| GIF Create Support |
enabled |
| JPG Support |
enabled |
| PNG Support |
enabled |
| WBMP Support |
enabled |
| XBM Support |
enabled |
| IMAP c-Client Version |
2004 |
| SSL Support |
enabled |
| mcrypt support |
enabled |
| version |
>= 2.4.x |
| 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 |
| MHASH support |
Enabled |
| MHASH API Version |
20060101 |
| mime_magic support |
enabled |
| Directive |
Local Value |
Master Value |
| mime_magic.magicfile |
/etc/apache/magic |
/etc/apache/magic |
| MySQL Support |
enabled |
| Active Persistent Links |
0 |
| Active Links |
0 |
| Client API version |
5.0.22 |
| MYSQL_MODULE_TYPE |
external |
| MYSQL_SOCKET |
/var/lib/mysql/mysql.sock |
| MYSQL_INCLUDE |
-I/usr/include/mysql |
| MYSQL_LIBS |
-L/usr/lib/mysql -lmysqlclient |
| Directive |
Local Value |
Master Value |
| mysql.allow_persistent |
Off |
Off |
| 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 |
10 |
10 |
| mysql.trace_mode |
Off |
Off |
| User-Space Object Overloading Support |
enabled |
| PCRE (Perl Compatible Regular Expressions) Support |
enabled |
| PCRE Library Version |
7.0 18-Dec-2006 |
| Revision |
$Revision: 1.51.2.4.2.3 $ |
| Session Support |
enabled |
| Registered save handlers |
files user |
| 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_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 |
1440 |
1440 |
| session.gc_probability |
1 |
1 |
| session.name |
PHPSESSID |
PHPSESSID |
| session.referer_check |
no value |
no value |
| session.save_handler |
files |
files |
| session.save_path |
/tmp |
/tmp |
| session.serialize_handler |
php |
php |
| session.use_cookies |
On |
On |
| session.use_only_cookies |
Off |
Off |
| session.use_trans_sid |
Off |
Off |
| Regex Library |
Bundled library enabled |
| 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 |
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=fakeentry |
a=href,area=href,frame=src,input=src,form=fakeentry |
| user_agent |
no value |
no value |
| Tokenizer Support |
enabled |
| WDDX Support |
enabled |
| WDDX Session Serializer |
enabled |
| XML Support |
active |
| XML Namespace Support |
active |
| EXPAT Version |
1.95.6 |
| XSLT support |
enabled |
| Backend |
Sablotron |
| Sablotron Version |
1.0.2 |
| Sablotron Information |
Cflags: -g -O2 Libs: -L/usr/local/lib -lexpat Prefix: /usr/local |
| ZLib Support |
enabled |
| 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 Modules
