Update von 2.7.6 auf 2.80 klappt nicht - wegen DB Fehler

In this board you can talk about general questions about phpMyFAQ

Moderator: Thorsten

Post Reply
andi1000
Posts: 17
Joined: Sat May 19, 2012 4:31 pm

Update von 2.7.6 auf 2.80 klappt nicht - wegen DB Fehler

Post by andi1000 »

Hallo Zusammen,

nachdem unser Projekt nun ein halbes Jahr brach lag (mangels Zeit), wollte ich mich nun wieder damit beschäftigen.
Da es hier jedoch schon so viele Neuerungen gibt - nebenbei:super Leistung von Euch! - und unsere FAQ noch nicht aktiv ist, dachte ich mir gleich das 2.80 zu ziehen.
Aber es funzt nicht. Ich kann auf unserem Server weder ein Upgrade noch eine Neuinstallation aufsetzen.
Die alte 2.7.6 läuft jedoch, soweit mir bekannt - fehlerfrei.

Beim Upgrade kommt die Meldung, dass eine Tabelle nicht verändert werden kann, bei der Neuinstallation wird gemeldet, dass die Rechte zum Anlegen der 3 Order Image, Data, Attachments fehlen. Lege ich diese Ordner an, kann ich dann zwar die DB Daten ausfüllen, aber nach dem Klick auf "Installieren" kommt wieder eine Fehlermeldung, dass kein Zugriff auf die DB möglich ist. Aber es wird eine 0KB Große Datei angelegt mit dem Namen der DB.
Wo kann das Problem liegen?
Grüßle
Andi
Thorsten
Posts: 15560
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: Update von 2.7.6 auf 2.80 klappt nicht - wegen DB Fehler

Post by Thorsten »

Hi,

kannst du mir ein paar mehr Infos geben? Welche PHP Version, welche Datenbank?

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
andi1000
Posts: 17
Joined: Sat May 19, 2012 4:31 pm

Re: Update von 2.7.6 auf 2.80 klappt nicht - wegen DB Fehler

Post by andi1000 »

Hi Thorsten,

sorry vor lauter Schreck den Anhang vergessen. Also es ist ein Windows basierter Server mit einer einfachen SQLite-DB.
Hier der php info auszug:


PHP Version 5.3.5

System Windows NT 6.1 build 7601 (Unknow Windows version Standard Edition Service Pack 1) i586
Build Date Jan 5 2011 20:26:24
Compiler MSVC9 (Visual C++ 2008)
Architecture x86
Configure Command cscript /nologo configure.js "--enable-snapshot-build" "--disable-isapi" "--enable-debug-pack" "--disable-isapi" "--without-mssql" "--without-pdo-mssql" "--without-pi3web" "--with-pdo-oci=D:\php-sdk\oracle\instantclient10\sdk,shared" "--with-oci8=D:\php-sdk\oracle\instantclient10\sdk,shared" "--with-oci8-11g=D:\php-sdk\oracle\instantclient11\sdk,shared" "--enable-object-out-dir=../obj/" "--enable-com-dotnet" "--with-mcrypt=static"
Server API CGI/FastCGI
Virtual Directory Support enabled
Configuration File (php.ini) Path C:\Windows
Scan this dir for additional .ini files (none)
Additional .ini files parsed (none)
PHP API 20090626
PHP Extension 20090626
Zend Extension 220090626
Zend Extension Build API220090626,TS,VC9
PHP Extension Build API20090626,TS,VC9
Debug Build no
Thread Safety enabled
Zend Memory Manager enabled
Zend Multibyte Support disabled
IPv6 Support enabled
Registered PHP Streams php, file, glob, data, http, ftp, zip, compress.zlib, https, ftps, phar
Registered Stream Socket Transports tcp, udp, ssl, sslv3, sslv2, tls
Registered Stream Filters convert.iconv.*, mcrypt.*, mdecrypt.*, string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, dechunk, zlib.*

This program makes use of the Zend Scripting Language Engine:
Zend Engine v2.3.0, Copyright (c) 1998-2010 Zend Technologies
with the ionCube PHP Loader v4.0.5, Copyright (c) 2002-2011, by ionCube Ltd.

Configuration
bcmath
BCMath support enabled

Directive Local Value Master Value
bcmath.scale 0 0

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 0 0
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_dotnet
COM 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

Core
PHP Version 5.3.5

Directive 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 Off Off
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_prepend_string no value no value
error_reporting 22519 22519
exit_on_timeout Off Off
expose_php Off Off
file_uploads On On
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 .;C:\php\pear .;C:\php\pear
log_errors On On
log_errors_max_len 1024 1024
magic_quotes_gpc Off Off
magic_quotes_runtime Off Off
magic_quotes_sybase Off Off
mail.add_x_header Off Off
mail.force_extra_parameters no value no value
mail.log no value no value
max_execution_time 1920 1920
max_file_uploads 20 20
max_input_nesting_level 64 64
max_input_time -1 -1
memory_limit 128M 128M
open_basedir no value no value
output_buffering 4096 4096
output_handler no value no value
post_max_size 2048M 2048M
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
request_order no value no value
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 no value no value
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 2048M 2048M
upload_tmp_dir no value no value
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
y2k_compliance Off Off
zend.enable_gc On On

ctype
ctype functions enabled

date
date/time support enabled
"Olson" Timezone Database Version 2010.15
Timezone Database internal
Default timezone Europe/Amsterdam

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 Europe/Amsterdam Europe/Amsterdam

dom
DOM/XML enabled
DOM/XML API Version 20031129
libxml Version 2.7.7
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 $Revision: 298196 $

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.0.34 compatible)
FreeType Support enabled
FreeType Linkage with freetype
FreeType Version 2.4.3
GIF Read Support enabled
GIF Create Support enabled
JPEG Support enabled
libJPEG Version 6b
PNG Support enabled
libPNG Version 1.2.44
WBMP Support enabled
XBM Support enabled

Directive Local Value Master Value
gd.jpeg_ignore_warning 0 0

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 salsa10 salsa20 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


iconv
iconv 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

imap
IMAP c-Client Version 2001
SSL Support enabled

json
json support enabled
json version 1.2.1

ldap
LDAP Support enabled
RCS Version $Id: ldap.c 299434 2010-05-17 20:09:42Z pajoye $
Total Links 0/unlimited
API Version 3001
Vendor Name OpenLDAP
Vendor Version 20319
SASL Support Enabled

Directive Local Value Master Value
ldap.max_links Unlimited Unlimited

libxml
libXML support active
libXML Compiled Version 2.7.7
libXML Loaded Version 20707
libXML streams enabled

mailparse
mailparse support enabled
Extension Version 2.1.3
Revision $Revision: 1.54 $

Directive Local Value Master Value
mailparse.def_charset us-ascii us-ascii

mbstring
Multibyte Support enabled
Multibyte string engine libmbfl
HTTP input encoding translation disabled

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) version 4.7.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.http_output_conv_mimetypes ^(text/|application/xhtml\+xml) ^(text/|application/xhtml\+xml)
mbstring.internal_encoding no value no value
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 cast-256 loki97 rijndael-192 saferplus wake blowfish-compat des rijndael-256 serpent xtea blowfish enigma rc2 tripledes arcfour
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 Emulated Support

mysqlnd
mysqlnd enabled
Version mysqlnd 5.0.7-dev - 091210 - $Revision: 304625 $
Compression supported
SSL not supported
Command buffer size 4096
Read buffer size 32768
Read timeout 31536000
Collecting statistics Yes
Collecting memory statistics No
Tracing n/a

Client statistics
bytes_sent 0
bytes_received 0
packets_sent 0
packets_received 0
protocol_overhead_in 0
protocol_overhead_out 0
bytes_received_ok_packet 0
bytes_received_eof_packet 0
bytes_received_rset_header_packet 0
bytes_received_rset_field_meta_packet 0
bytes_received_rset_row_packet 0
bytes_received_prepare_response_packet 0
bytes_received_change_user_packet 0
packets_sent_command 0
packets_received_ok 0
packets_received_eof 0
packets_received_rset_header 0
packets_received_rset_field_meta 0
packets_received_rset_row 0
packets_received_prepare_response 0
packets_received_change_user 0
result_set_queries 0
non_result_set_queries 0
no_index_used 0
bad_index_used 0
slow_queries 0
buffered_sets 0
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 0
rows_fetched_from_server_ps 0
rows_buffered_from_client_normal 0
rows_buffered_from_client_ps 0
rows_fetched_from_client_normal_buffered 0
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 0
rows_affected_ps 0
rows_skipped_normal 0
rows_skipped_ps 0
copy_on_write_saved 0
copy_on_write_performed 0
command_buffer_too_small 0
connect_success 0
connect_failure 0
connection_reused 0
reconnect 0
pconnect_success 0
active_connections 0
active_persistent_connections 0
explicit_close 0
implicit_close 0
disconnect_close 0
in_middle_of_command_close 0
explicit_free_result 0
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 0
proto_text_fetched_short 0
proto_text_fetched_int24 0
proto_text_fetched_int 0
proto_text_fetched_bigint 0
proto_text_fetched_decimal 0
proto_text_fetched_float 0
proto_text_fetched_double 0
proto_text_fetched_date 0
proto_text_fetched_year 0
proto_text_fetched_time 0
proto_text_fetched_datetime 0
proto_text_fetched_timestamp 0
proto_text_fetched_string 0
proto_text_fetched_blob 0
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 0
com_init_db 0
com_query 0
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 0
bytes_received_real_data_ps 0

odbc
ODBC 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

openssl
OpenSSL support enabled
OpenSSL Library Version OpenSSL 0.9.8q 2 Dec 2010
OpenSSL Header Version OpenSSL 0.9.8q 2 Dec 2010

pcre
PCRE (Perl Compatible Regular Expressions) Support enabled
PCRE Library Version 8.10 2010-06-25

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

PDO
PDO support enabled
PDO drivers sqlite, sqlite2

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

Phar
Phar: PHP Archive support enabled
Phar EXT version 2.0.1
Phar API version 1.1.1
SVN revision $Revision: 305584 $
Phar-based phar archives enabled
Tar-based phar archives enabled
ZIP-based phar archives enabled
gzip compression enabled
bzip2 compression disabled (install pecl/bz2)
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 (c) 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

pspell
PSpell Support enabled

Reflection
Reflection enabled
Version $Revision: 305605 $

session
Session Support enabled
Registered save handlers files user sqlite
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 86400 86400
session.gc_probability 0 0
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.serialize_handler php php
session.use_cookies On On
session.use_only_cookies On On
session.use_trans_sid 0 0

SimpleXML
Simplexml support enabled
Revision $Revision: 302715 $
Schema support enabled

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

SQLite
SQLite support enabled
PECL Module version 2.0-dev $Id: sqlite.c 305507 2010-11-18 15:22:22Z pajoye $
SQLite Library 2.8.17
SQLite Encoding iso8859

Directive Local Value Master Value
sqlite.assoc_case 0 0

standard
Dynamic Library Support enabled
Internal Sendmail Support for Windows enabled

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

template
Version 2.0.0

tidy
Tidy support enabled
libTidy Release 25 March 2009
Extension Version 2.0 ($Id: tidy.c 305507 2010-11-18 15:22:22Z pajoye $)

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

tnef
Version 1.0

tokenizer
Tokenizer Support enabled

wddx
WDDX Support enabled
WDDX Session Serializer enabled

xml
XML Support active
XML Namespace Support active
libxml2 Version 2.7.7

xmlreader
XMLReader enabled

xmlwriter
XMLWriter enabled

zip
Zip enabled
Extension Version $Id: php_zip.c 305848 2010-11-30 11:04:06Z pajoye $
Zip version 1.9.1
Libzip version 0.9.0

zlib
ZLib 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 Modules
Module Name
ionCube Loader

Environment
Variable Value
ALLUSERSPROFILE C:\ProgramData
APPDATA C:\Windows\system32\config\systemprofile\AppData\Roaming
CommonProgramFiles C:\Program Files (x86)\Common Files
CommonProgramFiles(x86) C:\Program Files (x86)\Common Files
CommonProgramW6432 C:\Program Files\Common Files
ComSpec C:\Windows\system32\cmd.exe
FP_NO_HOST_CHECK NO
LOCALAPPDATA C:\Windows\system32\config\systemprofile\AppData\Local
NUMBER_OF_PROCESSORS 8
OS Windows_NT
Path C:\Program Files (x86)\php;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Common Files\Acronis\SnapAPI\;C:\Program Files (x86)\Acronis\CommandLineTool\;
PATHEXT .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
PROCESSOR_ARCHITECTURE x86
PROCESSOR_ARCHITEW6432 AMD64
PROCESSOR_IDENTIFIER Intel64 Family 6 Model 26 Stepping 5, GenuineIntel
PROCESSOR_LEVEL 6
PROCESSOR_REVISION 1a05
ProgramData C:\ProgramData
ProgramFiles C:\Program Files (x86)
ProgramFiles(x86) C:\Program Files (x86)
ProgramW6432 C:\Program Files
PSModulePath C:\Windows\system32\WindowsPowerShell\v1.0\Modules\
PUBLIC C:\Users\Public
SystemDrive C:
SystemRoot C:\Windows
TEMP C:\Windows\TEMP
TMP C:\Windows\TEMP
USERPROFILE C:\Windows\system32\config\systemprofile
windir C:\Windows
PHP_FCGI_MAX_REQUESTS 20000

PHP Variables
Variable Value
_REQUEST["use_cookies"] 1
_REQUEST["sess_suffix"] basic
_REQUEST["lastUsername"] sdecker
_REQUEST["lastLogin"] |pro
_COOKIE["use_cookies"] 1
_COOKIE["sess_suffix"] basic
_COOKIE["lastUsername"] sdecker
_COOKIE["lastLogin"] |pro
_SERVER["ALLUSERSPROFILE"] C:\ProgramData
_SERVER["APPDATA"] C:\Windows\system32\config\systemprofile\AppData\Roaming
_SERVER["CommonProgramFiles"] C:\Program Files (x86)\Common Files
_SERVER["CommonProgramFiles(x86)"] C:\Program Files (x86)\Common Files
_SERVER["CommonProgramW6432"] C:\Program Files\Common Files
_SERVER["ComSpec"] C:\Windows\system32\cmd.exe
_SERVER["FP_NO_HOST_CHECK"] NO
_SERVER["LOCALAPPDATA"] C:\Windows\system32\config\systemprofile\AppData\Local
_SERVER["NUMBER_OF_PROCESSORS"] 8
_SERVER["OS"] Windows_NT
_SERVER["Path"] C:\Program Files (x86)\php;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Common Files\Acronis\SnapAPI\;C:\Program Files (x86)\Acronis\CommandLineTool\;
_SERVER["PATHEXT"] .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
_SERVER["PROCESSOR_ARCHITECTURE"] x86
_SERVER["PROCESSOR_ARCHITEW6432"] AMD64
_SERVER["PROCESSOR_IDENTIFIER"] Intel64 Family 6 Model 26 Stepping 5, GenuineIntel
_SERVER["PROCESSOR_LEVEL"] 6
_SERVER["PROCESSOR_REVISION"] 1a05
_SERVER["ProgramData"] C:\ProgramData
_SERVER["ProgramFiles"] C:\Program Files (x86)
_SERVER["ProgramFiles(x86)"] C:\Program Files (x86)
_SERVER["ProgramW6432"] C:\Program Files
_SERVER["PSModulePath"] C:\Windows\system32\WindowsPowerShell\v1.0\Modules\
_SERVER["PUBLIC"] C:\Users\Public
_SERVER["SystemDrive"] C:
_SERVER["SystemRoot"] C:\Windows
_SERVER["TEMP"] C:\Windows\TEMP
_SERVER["TMP"] C:\Windows\TEMP
_SERVER["USERPROFILE"] C:\Windows\system32\config\systemprofile
_SERVER["windir"] C:\Windows
_SERVER["PHP_FCGI_MAX_REQUESTS"] 20000
_SERVER["FCGI_ROLE"] RESPONDER
_SERVER["SERVER_PROTOCOL"] HTTP/1.1
_SERVER["GATEWAY_INTERFACE"] CGI/1.1
_SERVER["SERVER_PORT"] xxxxx
_SERVER["REMOTE_ADDR"] 192.168.xxx.xx
_SERVER["SERVER_NAME"] 192.168.xxx.xx
_SERVER["SERVER_THREAD"] 2460
_SERVER["SERVER_TIMEOUT"] 150000
_SERVER["SERVER_SYNCPUSH_SUPPORT"] 1
_SERVER["SCRIPT_NAME"] /ockb/admin/info.php
_SERVER["HTTP_HOST"] 192.168.xxx.xx:xxxxx
_SERVER["HTTP_USER_AGENT"] Mozilla/5.0 (Windows NT 5.1; rv:21.0) Gecko/20100101 Firefox/21.0
_SERVER["HTTP_ACCEPT"] text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
_SERVER["HTTP_ACCEPT_LANGUAGE"] de-de,de;q=0.8,en-us;q=0.5,en;q=0.3
_SERVER["HTTP_ACCEPT_ENCODING"] gzip, deflate
_SERVER["HTTP_DNT"] 1
_SERVER["HTTP_COOKIE"] use_cookies=1; sess_suffix=basic; lastUsername=sdecker; lastLogin=%7Cpro
_SERVER["HTTP_CONNECTION"] keep-alive
_SERVER["HTTPS"] OFF
_SERVER["REQUEST_METHOD"] GET
_SERVER["REQUEST_URI"] /ockb/admin/info.php
_SERVER["PHP_SELF"] /ockb/admin/info.php
_SERVER["REQUEST_TIME"] 1371477849
_SERVER["argv"]

Array
(
)

_SERVER["argc"] 0
_ENV["ALLUSERSPROFILE"] C:\ProgramData
_ENV["APPDATA"] C:\Windows\system32\config\systemprofile\AppData\Roaming
_ENV["CommonProgramFiles"] C:\Program Files (x86)\Common Files
_ENV["CommonProgramFiles(x86)"] C:\Program Files (x86)\Common Files
_ENV["CommonProgramW6432"] C:\Program Files\Common Files
_ENV["ComSpec"] C:\Windows\system32\cmd.exe
_ENV["FP_NO_HOST_CHECK"] NO
_ENV["LOCALAPPDATA"] C:\Windows\system32\config\systemprofile\AppData\Local
_ENV["NUMBER_OF_PROCESSORS"] 8
_ENV["OS"] Windows_NT
_ENV["Path"] C:\Program Files (x86)\php;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Common Files\Acronis\SnapAPI\;C:\Program Files (x86)\Acronis\CommandLineTool\;
_ENV["PATHEXT"] .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
_ENV["PROCESSOR_ARCHITECTURE"] x86
_ENV["PROCESSOR_ARCHITEW6432"] AMD64
_ENV["PROCESSOR_IDENTIFIER"] Intel64 Family 6 Model 26 Stepping 5, GenuineIntel
_ENV["PROCESSOR_LEVEL"] 6
_ENV["PROCESSOR_REVISION"] 1a05
_ENV["ProgramData"] C:\ProgramData
_ENV["ProgramFiles"] C:\Program Files (x86)
_ENV["ProgramFiles(x86)"] C:\Program Files (x86)
_ENV["ProgramW6432"] C:\Program Files
_ENV["PSModulePath"] C:\Windows\system32\WindowsPowerShell\v1.0\Modules\
_ENV["PUBLIC"] C:\Users\Public
_ENV["SystemDrive"] C:
_ENV["SystemRoot"] C:\Windows
_ENV["TEMP"] C:\Windows\TEMP
_ENV["TMP"] C:\Windows\TEMP

_ENV["USERPROFILE"] C:\Windows\system32\config\systemprofile
_ENV["windir"] C:\Windows
_ENV["PHP_FCGI_MAX_REQUESTS"] 20000
_ENV["FCGI_ROLE"] RESPONDER
_ENV["SERVER_PROTOCOL"] HTTP/1.1
_ENV["GATEWAY_INTERFACE"] CGI/1.1
_ENV["SERVER_PORT"] xxxxx
_ENV["REMOTE_ADDR"] 192.168.xxx.xx
_ENV["SERVER_NAME"] 192.168.xxx.xx
_ENV["SERVER_THREAD"] 2460
_ENV["SERVER_TIMEOUT"] 150000
_ENV["SERVER_SYNCPUSH_SUPPORT"] 1
_ENV["SCRIPT_NAME"] /ockb/admin/info.php
_ENV["HTTP_HOST"] 192.168.xxx.xx:xxxxx
_ENV["HTTP_USER_AGENT"] Mozilla/5.0 (Windows NT 5.1; rv:21.0) Gecko/20100101 Firefox/21.0
_ENV["HTTP_ACCEPT"] text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
_ENV["HTTP_ACCEPT_LANGUAGE"] de-de,de;q=0.8,en-us;q=0.5,en;q=0.3
_ENV["HTTP_ACCEPT_ENCODING"] gzip, deflate
_ENV["HTTP_DNT"] 1
_ENV["HTTP_COOKIE"] use_cookies=1; sess_suffix=basic; lastUsername=sdecker; lastLogin=%7Cpro
_ENV["HTTP_CONNECTION"] keep-alive
_ENV["HTTPS"] OFF
_ENV["REQUEST_METHOD"] GET
_ENV["REQUEST_URI"] /ockb/admin/info.php

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@php.net.
Thorsten
Posts: 15560
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: Update von 2.7.6 auf 2.80 klappt nicht - wegen DB Fehler

Post by Thorsten »

Hi,

hier ist der Bugfix: https://github.com/thorsten/phpMyFAQ/co ... 137c2dc051

Oder du wartest auf die 2.8.1, kommt die nächsten Tage.

Danke für den Hinweis!

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
andi1000
Posts: 17
Joined: Sat May 19, 2012 4:31 pm

Re: Update von 2.7.6 auf 2.80 klappt nicht - wegen DB Fehler

Post by andi1000 »

OK,

ich werde mal das Release testen und dann mit der 2.81 updaten.
Danke!
Andi


Update: Ich warte doch auf das Release - der Codeauszug(die Zeilenummern alter Source) passt leider nicht zu der update.php, die in dem 2.80 zip ausgeliefert wird. Ich habe es versucht in meine Version reinzustricken, aber da scheint zwischenzeitlich noch einiges andere geändert zu sein.
andi1000
Posts: 17
Joined: Sat May 19, 2012 4:31 pm

Re: Update von 2.7.6 auf 2.80 klappt nicht - wegen DB Fehler

Post by andi1000 »

Hallo Thorsten,

das Update klappt leider auch mit der 2.8.1 nicht. Es kommt jetzt in Schritt 3 die Meldung:

DB error: constraint failed
INSERT INTO oc_kbfaqright (right_id, name, description, for_users, for_groups) VALUES (39, 'addfaq', 'Right to add FAQs in frontend', 1, 1)
Grüße
Andi
Thorsten
Posts: 15560
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: Update von 2.7.6 auf 2.80 klappt nicht - wegen DB Fehler

Post by Thorsten »

Hi,

war das die gleiche DB, die du schonmal versucht hast, zu aktualisieren? Wenn ja, dann hast du diese Einträge sicher schon... dann lösch mal bitte aus der install/update.php diesen Code raus, ab Zeile 566:

Code: Select all

        $query[] = "INSERT INTO " . PMF_Db::getTablePrefix() . "faqright (right_id, name, description, for_users, for_groups) VALUES
            (39, 'addfaq', 'Right to add FAQs in frontend', 1, 1)";
        $query[] = "INSERT INTO " . PMF_Db::getTablePrefix() . "faquser_right (user_id, right_id) VALUES (1, 39)";
        $query[] = "INSERT INTO " . PMF_Db::getTablePrefix() . "faqright (right_id, name, description, for_users, for_groups) VALUES
            (40, 'addquestion', 'Right to add questions in frontend', 1, 1)";
        $query[] = "INSERT INTO " . PMF_Db::getTablePrefix() . "faquser_right (user_id, right_id) VALUES (1, 40)";
        $query[] = "INSERT INTO " . PMF_Db::getTablePrefix() . "faqright (right_id, name, description, for_users, for_groups) VALUES
            (41, 'addcomment', 'Right to add comments in frontend', 1, 1)";
        $query[] = "INSERT INTO " . PMF_Db::getTablePrefix() . "faquser_right (user_id, right_id) VALUES (1, 41)";

        $faqConfig->add('cache.varnishEnable', 'false');
        $faqConfig->add('cache.varnishHost', '127.0.0.1');
        $faqConfig->add('cache.varnishPort', '2000');
        $faqConfig->add('cache.varnishSecret', '');
        $faqConfig->add('cache.varnishTimeout', '500');

        $faqConfig->add('security.forcePasswordUpdate', 'true');
bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
andi1000
Posts: 17
Joined: Sat May 19, 2012 4:31 pm

Re: Update von 2.7.6 auf 2.80 klappt nicht - wegen DB Fehler

Post by andi1000 »

Hallo Thorsetn,

super, hat geklappt. Hätt ich auch selbst drauf kommen können - die alte 2.7.6 DB von vor dem ersten Update-Versuch einzusetzen.
Danke!
Andreas
Thorsten
Posts: 15560
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: Update von 2.7.6 auf 2.80 klappt nicht - wegen DB Fehler

Post by Thorsten »

Hi,

super! Habt ihr viele Nutzer auf eurer FAQ? Ich frage wegen SQLite, ich nutze das nur zum Testen...

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
Post Reply