[Typo3-german] Re: [Typo3-german] Re: [Typo3-german] Re: [Typo3-german] Database Analyzer: Kann ein Datenbankfeld nicht ändern
Xaver
rxreichart at bluewin.ch
Thu Sep 22 12:13:34 CEST 2005
Xaver schrieb:
> Peter Niederlag schrieb:
> Danke Peter für deine prompte Antwort>
>
> Hi,
>
>>
>> Xaver schrieb:
>>
>>> Erhalte im Database Analyzer folgende Meldung: Changing fields
>>> ALTER TABLE be_users CHANGE lang lang char(4) NOT NULL default '
>>> Current value: varchar(4) NOT NULL default ''
>>> Habe das Häckchen gesetzt und Auf Write to Database geklickt. Egal wie
>>> oft ich dies durchführe, im Analyzer zeigt sich immer wieder das gleiche
>>> Ergebnis. Woran kann das liegen
>>
>>
>>
>> TYPO3 Version?
>
> Version 3.8.0
>
>> MySQL Version?
>
> Version 4.0.20
> Obwohl ich im Install Tool keinerlei Fehlermeldung habe, einen
> Backendadmin mit Passwort angelegt habe und bis auf diesen einen Eintrag
> in der Database scheinbar auch alles in Ordnung ist, erhalte ich einen
> 500er Internal Server Error, wenn ich mich in einem neuen Fenster im
> Backend anmelden will. Kann dies etwas damit zu tun haben. Hatte Typo3
> schon mehrmals bei einem anderen Provider installiert, aber noch nie
> dieses Problem gehabt?
>
>>
>> Da gab es mal den berühmten bug 416
>> http://bugs.typo3.org/view.php?id=416
>>
>> Cu,
>> Peter
>
> Herzlichen Dank für deine Hinweise
> Gruss Xaver
P.S.:
Hier noch die PHP Info als Hinweis:
PHP Logo
PHP Version 4.3.8
System FreeBSD server-r002.hostpoint.ch 4.10-RELEASE-p16 FreeBSD
4.10-RELEASE-p16 #3: Th i386
Build Date Aug 20 2004 15:15:40
Configure Command './configure' '--prefix=/usr/local/php4'
'--with-layout=GNU' '--disable-pear' '--enable-versioning'
'--enable-memory-limit' '--enable-discard-path' '--with-zlib-dir=/usr'
'--with-regex=php' '--disable-all' '--enable-bcmath' '--with-bz2=/usr'
'--enable-calendar' '--enable-ctype' '--with-curl=/usr/local'
'--with-dom=/usr/local' '--with-dom-xslt=/usr/local'
'--with-dom-exslt=/usr/local' '--enable-exif' '--enable-ftp'
'--with-gd=/usr/local' '--enable-gd-native-ttf'
'--with-freetype-dir=/usr/local' '--with-t1lib=/usr/local'
'--with-jpeg-dir=/usr/local' '--with-png-dir=/usr/local'
'--with-gettext=/usr/local' '--with-iconv-dir=/usr/local'
'--with-mcrypt=/usr/local' '--with-mhash=/usr/local'
'--with-mime-magic=/usr/share/misc/magic.mime' '--with-ming=/usr/local'
'--with-mysql=/usr/local' '--with-ldap=/usr/local'
'--with-openssl-dir=/usr' '--with-openssl=/usr' '--enable-overload'
'--with-pdflib=/usr/local' '--with-pcre-regex=yes' '--enable-posix'
'--enable-session' '--enable-sockets' '--with-expat-dir=/usr/local'
'--enable-xml' '--with-xmlrpc' '--enable-xslt'
'--with-xslt-sablot=/usr/local' '--with-zip=/usr/local'
'--with-zlib=yes' '--with-imap=/usr/local' '--with-imap-ssl=/usr/local'
Server API CGI
Virtual Directory Support disabled
Configuration File (php.ini) Path /usr/local/php4/etc/php.ini
PHP API 20020918
PHP Extension 20020429
Zend Extension 20021010
Debug Build no
Thread Safety disabled
Registered PHP Streams php, http, ftp, https, ftps, compress.bzip2,
compress.zlib
Zend logo This program makes use of the Zend Scripting Language Engine:
Zend Engine v1.3.0, Copyright (c) 1998-2004 Zend Technologies
PHP Credits
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 error_log error_log
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 #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 .:/usr/lib/php:/usr/local/lib/php
.:/usr/lib/php:/usr/local/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 30 30
max_input_time -1 -1
memory_limit 32M 32M
open_basedir no value no value
output_buffering no value no value
output_handler no value no value
post_max_size 55M 55M
precision 14 14
register_argc_argv On On
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 no value no value
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 2M 2M
upload_tmp_dir /tmp /tmp
user_dir no value no value
variables_order EGPCS EGPCS
xmlrpc_error_number 0 0
xmlrpc_errors Off Off
y2k_compliance Off Off
bcmath
BCMath support enabled
bz2
BZip2 Support Enabled
BZip2 Version 1.0.2, 30-Dec-2001
calendar
Calendar support enabled
ctype
ctype functions enabled
curl
CURL support enabled
CURL Information libcurl/7.12.1 OpenSSL/0.9.7d zlib/1.1.4
domxml
DOM/XML enabled
DOM/XML API Version 20020815
libxml Version 20611
HTML Support enabled
XPath Support enabled
XPointer Support enabled
DOM/XSLT enabled
libxslt Version 1.1.8
libxslt compiled against libxml Version 2.6.11
DOM/EXSLT enabled
libexslt Version 1.1.8
exif
EXIF Support enabled
EXIF Version 1.4 $Id: exif.c,v 1.118.2.27 2003/12/17 09:08:37 helly Exp $
Supported EXIF Version 0220
Supported filetypes JPEG,TIFF
ftp
FTP support enabled
gd
GD Support enabled
GD Version 2.0 or higher
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
gettext
GetText Support enabled
imap
IMAP c-Client Version 2000
SSL Support enabled
ldap
LDAP Support enabled
RCS Version $Id: ldap.c,v 1.130.2.10 2004/06/01 21:05:33 iliaa Exp $
Total Links 0/unlimited
API Version 3001
Vendor Name OpenLDAP
Vendor Version 20215
mcrypt
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
MHASH support Enabled
MHASH API Version 20020524
mime_magic
mime_magic support enabled
Directive Local Value Master Value
mime_magic.magicfile /usr/share/misc/magic.mime /usr/share/misc/magic.mime
ming
Ming SWF output library enabled
Version 0.2a
mysql
MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version 4.0.20
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /tmp/mysql.sock
MYSQL_INCLUDE -I/usr/local/include/mysql
MYSQL_LIBS -L/usr/local/lib/mysql -lmysqlclient
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
openssl
OpenSSL support enabled
OpenSSL Version OpenSSL 0.9.7d 17 Mar 2004
overload
User-Space Object Overloading Support enabled
pcre
PCRE (Perl Compatible Regular Expressions) Support enabled
PCRE Library Version 4.5 01-December-2003
pdf
PDF Support enabled
PDFlib GmbH Version 5.0.3
Revision $Revision: 1.112.2.9 $
posix
Revision $Revision: 1.51.2.2 $
session
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 On On
sockets
Sockets Support enabled
standard
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,form=,fieldset=
a=href,area=href,frame=src,form=,fieldset=
user_agent no value no value
xml
XML Support active
XML Namespace Support active
EXPAT Version expat_1.95.8
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
xslt
XSLT support enabled
Backend Sablotron
Sablotron Version 1.0.1
Sablotron Information Cflags: -O -pipe -march=pentiumpro Libs:
-L/usr/local/lib -liconv -lexpat Prefix: /usr/local
zip
Zip support enabled
zlib
ZLib Support enabled
Compiled Version 1.1.4
Linked Version 1.1.4
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
Module Name
Environment
Variable Value
DOCUMENT_ROOT /home/hservch/public_html
HTTP_ACCEPT
text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
HTTP_ACCEPT_CHARSET ISO-8859-1,utf-8;q=0.7,*;q=0.7
HTTP_ACCEPT_ENCODING gzip,deflate
HTTP_ACCEPT_LANGUAGE de-de,de;q=0.8,en-us;q=0.5,en;q=0.3
HTTP_CACHE_CONTROL max-age=0
HTTP_CONNECTION keep-alive
HTTP_COOKIE cprelogin=no
HTTP_HOST hserv.ch
HTTP_KEEP_ALIVE 300
HTTP_USER_AGENT Mozilla/5.0 (Windows; U; Windows NT 5.1; de-DE;
rv:1.7.10) Gecko/20050717 Firefox/1.0.6
PATH /bin:/usr/bin
REMOTE_ADDR 195.186.205.98
REMOTE_HOST 98.205.186.195.cust.bluewin.ch
REMOTE_PORT 1686
SCRIPT_FILENAME /home/hservch/public_html/phpinfo.php
SERVER_ADDR 217.26.53.183
SERVER_ADMIN webmaster at hserv.ch
SERVER_NAME www.hserv.ch
SERVER_PORT 80
SERVER_SIGNATURE <ADDRESS>Apache/1.3.31 Server at www.hserv.ch Port
80</ADDRESS>
SERVER_SOFTWARE Apache/1.3.31 (Unix) mod_auth_passthrough/1.8
FrontPage/5.0.2.2510a mod_log_bytes/1.2 mod_bwlimited/1.4 mod_ssl/2.8.19
OpenSSL/0.9.7d
PHP_VERSION PHP4
GATEWAY_INTERFACE CGI/1.1
SERVER_PROTOCOL HTTP/1.1
REQUEST_METHOD GET
REQUEST_URI /phpinfo.php
SCRIPT_NAME /phpinfo.php
PATH_TRANSLATED /home/hservch/public_html/phpinfo.php
REDIRECT_STATUS 200
PHP Variables
Variable Value
PHP_SELF /phpinfo.php
_REQUEST["cprelogin"] no
_COOKIE["cprelogin"] no
_SERVER["DOCUMENT_ROOT"] /home/hservch/public_html
_SERVER["HTTP_ACCEPT"]
text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
_SERVER["HTTP_ACCEPT_CHARSET"] ISO-8859-1,utf-8;q=0.7,*;q=0.7
_SERVER["HTTP_ACCEPT_ENCODING"] gzip,deflate
_SERVER["HTTP_ACCEPT_LANGUAGE"] de-de,de;q=0.8,en-us;q=0.5,en;q=0.3
_SERVER["HTTP_CACHE_CONTROL"] max-age=0
_SERVER["HTTP_CONNECTION"] keep-alive
_SERVER["HTTP_COOKIE"] cprelogin=no
_SERVER["HTTP_HOST"] hserv.ch
_SERVER["HTTP_KEEP_ALIVE"] 300
_SERVER["HTTP_USER_AGENT"] Mozilla/5.0 (Windows; U; Windows NT 5.1;
de-DE; rv:1.7.10) Gecko/20050717 Firefox/1.0.6
_SERVER["PATH"] /bin:/usr/bin
_SERVER["REMOTE_ADDR"] 195.186.205.98
_SERVER["REMOTE_HOST"] 98.205.186.195.cust.bluewin.ch
_SERVER["REMOTE_PORT"] 1686
_SERVER["SCRIPT_FILENAME"] /home/hservch/public_html/phpinfo.php
_SERVER["SERVER_ADDR"] 217.26.53.183
_SERVER["SERVER_ADMIN"] webmaster at hserv.ch
_SERVER["SERVER_NAME"] www.hserv.ch
_SERVER["SERVER_PORT"] 80
_SERVER["SERVER_SIGNATURE"] <ADDRESS>Apache/1.3.31 Server at
www.hserv.ch Port 80</ADDRESS>
_SERVER["SERVER_SOFTWARE"] Apache/1.3.31 (Unix) mod_auth_passthrough/1.8
FrontPage/5.0.2.2510a mod_log_bytes/1.2 mod_bwlimited/1.4 mod_ssl/2.8.19
OpenSSL/0.9.7d
_SERVER["PHP_VERSION"] PHP4
_SERVER["GATEWAY_INTERFACE"] CGI/1.1
_SERVER["SERVER_PROTOCOL"] HTTP/1.1
_SERVER["REQUEST_METHOD"] GET
_SERVER["REQUEST_URI"] /phpinfo.php
_SERVER["SCRIPT_NAME"] /phpinfo.php
_SERVER["PATH_TRANSLATED"] /home/hservch/public_html/phpinfo.php
_SERVER["REDIRECT_STATUS"] 200
_SERVER["PHP_SELF"] /phpinfo.php
_SERVER["argv"]
Array
(
)
_SERVER["argc"] 0
_ENV["DOCUMENT_ROOT"] /home/hservch/public_html
_ENV["HTTP_ACCEPT"]
text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
_ENV["HTTP_ACCEPT_CHARSET"] ISO-8859-1,utf-8;q=0.7,*;q=0.7
_ENV["HTTP_ACCEPT_ENCODING"] gzip,deflate
_ENV["HTTP_ACCEPT_LANGUAGE"] de-de,de;q=0.8,en-us;q=0.5,en;q=0.3
_ENV["HTTP_CACHE_CONTROL"] max-age=0
_ENV["HTTP_CONNECTION"] keep-alive
_ENV["HTTP_COOKIE"] cprelogin=no
_ENV["HTTP_HOST"] hserv.ch
_ENV["HTTP_KEEP_ALIVE"] 300
_ENV["HTTP_USER_AGENT"] Mozilla/5.0 (Windows; U; Windows NT 5.1; de-DE;
rv:1.7.10) Gecko/20050717 Firefox/1.0.6
_ENV["PATH"] /bin:/usr/bin
_ENV["REMOTE_ADDR"] 195.186.205.98
_ENV["REMOTE_HOST"] 98.205.186.195.cust.bluewin.ch
_ENV["REMOTE_PORT"] 1686
_ENV["SCRIPT_FILENAME"] /home/hservch/public_html/phpinfo.php
_ENV["SERVER_ADDR"] 217.26.53.183
_ENV["SERVER_ADMIN"] webmaster at hserv.ch
_ENV["SERVER_NAME"] www.hserv.ch
_ENV["SERVER_PORT"] 80
_ENV["SERVER_SIGNATURE"] <ADDRESS>Apache/1.3.31 Server at www.hserv.ch
Port 80</ADDRESS>
_ENV["SERVER_SOFTWARE"] Apache/1.3.31 (Unix) mod_auth_passthrough/1.8
FrontPage/5.0.2.2510a mod_log_bytes/1.2 mod_bwlimited/1.4 mod_ssl/2.8.19
OpenSSL/0.9.7d
_ENV["PHP_VERSION"] PHP4
_ENV["GATEWAY_INTERFACE"] CGI/1.1
_ENV["SERVER_PROTOCOL"] HTTP/1.1
_ENV["REQUEST_METHOD"] GET
_ENV["REQUEST_URI"] /phpinfo.php
_ENV["SCRIPT_NAME"] /phpinfo.php
_ENV["PATH_TRANSLATED"] /home/hservch/public_html/phpinfo.php
_ENV["REDIRECT_STATUS"] 200
PHP License
This program is free software; you can redistribute it and/or modify it
under the terms of the PHP License as published by the PHP Group and
included in the distribution in the file: LICENSE
This program is distributed in the hope that it will be useful, but
WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
If you did not receive a copy of the PHP license, or have any questions
about PHP licensing, please contact license at php.net.
More information about the TYPO3-german
mailing list