Ошибки при инсталле в Postgresql

[disa]

Добрый день.
Покурил форум и начал установку форума по иснтрукции. Скачал архивы, распаковал, проверил доступы. На страничке с БД ввел нужного юзера и пароль, в результате создалось 63таблицы, 36сиквенсов и на экране, а также в логе субд ошибки ниже.

phpinfo() ниже лога

Прошу помочь проинсталлить форум в постгрес без ошибок.

Код Выделить Развернуть

субд
root@:/ # pkg info | grep post
postgresql94-client-9.4.5      PostgreSQL database (client)
postgresql94-server-9.4.5      The most advanced open-source database available anywhere
лог ошибок:

Код Выделить Развернуть

Nov 30 04:34:18  postgres[869]: [4-1] ERROR:  relation "smf_settings" does not exist at character 34
Nov 30 04:34:18  postgres[869]: [4-2] STATEMENT: 
Nov 30 04:34:18  postgres[869]: [4-3] SELECT variable, value
Nov 30 04:34:18  postgres[869]: [4-4] FROM smf_settings
Nov 30 04:34:23  postgres[869]: [5-1] ERROR:  syntax error at or near "s" at character 78
Nov 30 04:34:23  postgres[869]: [5-2] STATEMENT: 
Nov 30 04:34:23  postgres[869]: [5-3]
Nov 30 04:34:23  postgres[869]: [5-4]
Nov 30 04:34:23  postgres[869]: [5-5] INSERT INTO smf_calendar_holidays (title, event_date) VALUES ('New Year\'s', '0004-01-01');
Nov 30 04:34:23  postgres[869]: [6-1] ERROR:  syntax error at or near "s" at character 77
Nov 30 04:34:23  postgres[869]: [6-2] STATEMENT: 
Nov 30 04:34:23  postgres[869]: [6-3] INSERT INTO smf_calendar_holidays (title, event_date) VALUES ('Valentine\'s Day', '0004-02-14');
Nov 30 04:34:23  postgres[869]: [7-1] ERROR:  syntax error at or near "s" at character 79
Nov 30 04:34:23  postgres[869]: [7-2] STATEMENT: 
Nov 30 04:34:23  postgres[869]: [7-3] INSERT INTO smf_calendar_holidays (title, event_date) VALUES ('St. Patrick\'s Day', '0004-03-17');
Nov 30 04:34:23  postgres[869]: [8-1] ERROR:  syntax error at or near "s" at character 74
Nov 30 04:34:23  postgres[869]: [8-2] STATEMENT: 
Nov 30 04:34:23  postgres[869]: [8-3] INSERT INTO smf_calendar_holidays (title, event_date) VALUES ('Mother\'s Day', '2010-05-09');
Nov 30 04:34:23  postgres[869]: [9-1] ERROR:  syntax error at or near "s" at character 74
Nov 30 04:34:23  postgres[869]: [9-2] STATEMENT: 
Nov 30 04:34:23  postgres[869]: [9-3] INSERT INTO smf_calendar_holidays (title, event_date) VALUES ('Mother\'s Day', '2011-05-08');
Nov 30 04:34:23  postgres[869]: [10-1] ERROR:  syntax error at or near "s" at character 74
Nov 30 04:34:23  postgres[869]: [10-2] STATEMENT: 
Nov 30 04:34:23  postgres[869]: [10-3] INSERT INTO smf_calendar_holidays (title, event_date) VALUES ('Mother\'s Day', '2012-05-13');
Nov 30 04:34:23  postgres[869]: [11-1] ERROR:  syntax error at or near "s" at character 74
Nov 30 04:34:23  postgres[869]: [11-2] STATEMENT: 
Nov 30 04:34:23  postgres[869]: [11-3] INSERT INTO smf_calendar_holidays (title, event_date) VALUES ('Mother\'s Day', '2013-05-12');
Nov 30 04:34:23  postgres[869]: [12-1] ERROR:  syntax error at or near "s" at character 74
Nov 30 04:34:23  postgres[869]: [12-2] STATEMENT: 
Nov 30 04:34:23  postgres[869]: [12-3] INSERT INTO smf_calendar_holidays (title, event_date) VALUES ('Mother\'s Day', '2014-05-11');
Nov 30 04:34:23  postgres[869]: [13-1] ERROR:  syntax error at or near "s" at character 74
Nov 30 04:34:23  postgres[869]: [13-2] STATEMENT: 
Nov 30 04:34:23  postgres[869]: [13-3] INSERT INTO smf_calendar_holidays (title, event_date) VALUES ('Mother\'s Day', '2015-05-10');
Nov 30 04:34:23  postgres[869]: [14-1] ERROR:  syntax error at or near "s" at character 74
Nov 30 04:34:23  postgres[869]: [14-2] STATEMENT: 
Nov 30 04:34:23  postgres[869]: [14-3] INSERT INTO smf_calendar_holidays (title, event_date) VALUES ('Mother\'s Day', '2016-05-08');
Nov 30 04:34:23  postgres[869]: [15-1] ERROR:  syntax error at or near "s" at character 74
Nov 30 04:34:23  postgres[869]: [15-2] STATEMENT: 
Nov 30 04:34:23  postgres[869]: [15-3] INSERT INTO smf_calendar_holidays (title, event_date) VALUES ('Mother\'s Day', '2017-05-14');
Nov 30 04:34:23  postgres[869]: [16-1] ERROR:  syntax error at or near "s" at character 74
Nov 30 04:34:23  postgres[869]: [16-2] STATEMENT: 
Nov 30 04:34:23  postgres[869]: [16-3] INSERT INTO smf_calendar_holidays (title, event_date) VALUES ('Mother\'s Day', '2018-05-13');
Nov 30 04:34:23  postgres[869]: [17-1] ERROR:  syntax error at or near "s" at character 74
Nov 30 04:34:23  postgres[869]: [17-2] STATEMENT: 
Nov 30 04:34:23  postgres[869]: [17-3] INSERT INTO smf_calendar_holidays (title, event_date) VALUES ('Mother\'s Day', '2019-05-12');
Nov 30 04:34:23  postgres[869]: [18-1] ERROR:  syntax error at or near "s" at character 74
Nov 30 04:34:23  postgres[869]: [18-2] STATEMENT: 
Nov 30 04:34:23  postgres[869]: [18-3] INSERT INTO smf_calendar_holidays (title, event_date) VALUES ('Mother\'s Day', '2020-05-10');
Nov 30 04:34:23  postgres[869]: [19-1] ERROR:  syntax error at or near "s" at character 74
Nov 30 04:34:23  postgres[869]: [19-2] STATEMENT: 
Nov 30 04:34:23  postgres[869]: [19-3] INSERT INTO smf_calendar_holidays (title, event_date) VALUES ('Father\'s Day', '2010-06-20');
Nov 30 04:34:23  postgres[869]: [20-1] ERROR:  syntax error at or near "s" at character 74
Nov 30 04:34:23  postgres[869]: [20-2] STATEMENT: 
Nov 30 04:34:23  postgres[869]: [20-3] INSERT INTO smf_calendar_holidays (title, event_date) VALUES ('Father\'s Day', '2011-06-19');
Nov 30 04:34:23  postgres[869]: [21-1] ERROR:  syntax error at or near "s" at character 74
Nov 30 04:34:23  postgres[869]: [21-2] STATEMENT: 
Nov 30 04:34:23  postgres[869]: [21-3] INSERT INTO smf_calendar_holidays (title, event_date) VALUES ('Father\'s Day', '2012-06-17');
Nov 30 04:34:23  postgres[869]: [22-1] ERROR:  syntax error at or near "s" at character 74
Nov 30 04:34:23  postgres[869]: [22-2] STATEMENT: 
Nov 30 04:34:23  postgres[869]: [22-3] INSERT INTO smf_calendar_holidays (title, event_date) VALUES ('Father\'s Day', '2013-06-16');
Nov 30 04:34:23  postgres[869]: [23-1] ERROR:  syntax error at or near "s" at character 74
Nov 30 04:34:23  postgres[869]: [23-2] STATEMENT: 
Nov 30 04:34:23  postgres[869]: [23-3] INSERT INTO smf_calendar_holidays (title, event_date) VALUES ('Father\'s Day', '2014-06-15');
Nov 30 04:34:23  postgres[869]: [24-1] ERROR:  syntax error at or near "s" at character 74
Nov 30 04:34:23  postgres[869]: [24-2] STATEMENT: 
Nov 30 04:34:23  postgres[869]: [24-3] INSERT INTO smf_calendar_holidays (title, event_date) VALUES ('Father\'s Day', '2015-06-21');
Nov 30 04:34:23  postgres[869]: [25-1] ERROR:  syntax error at or near "s" at character 74
Nov 30 04:34:23  postgres[869]: [25-2] STATEMENT: 
Nov 30 04:34:23  postgres[869]: [25-3] INSERT INTO smf_calendar_holidays (title, event_date) VALUES ('Father\'s Day', '2016-06-19');
Nov 30 04:34:23  postgres[869]: [26-1] ERROR:  syntax error at or near "s" at character 74
Nov 30 04:34:23  postgres[869]: [26-2] STATEMENT: 
Nov 30 04:34:23  postgres[869]: [26-3] INSERT INTO smf_calendar_holidays (title, event_date) VALUES ('Father\'s Day', '2017-06-18');
Nov 30 04:34:23  postgres[869]: [27-1] ERROR:  syntax error at or near "s" at character 74
Nov 30 04:34:23  postgres[869]: [27-2] STATEMENT: 
Nov 30 04:34:23  postgres[869]: [27-3] INSERT INTO smf_calendar_holidays (title, event_date) VALUES ('Father\'s Day', '2018-06-17');
Nov 30 04:34:23  postgres[869]: [28-1] ERROR:  syntax error at or near "s" at character 74
Nov 30 04:34:23  postgres[869]: [28-2] STATEMENT: 
Nov 30 04:34:23  postgres[869]: [28-3] INSERT INTO smf_calendar_holidays (title, event_date) VALUES ('Father\'s Day', '2019-06-16');
Nov 30 04:34:23  postgres[869]: [29-1] ERROR:  syntax error at or near "s" at character 74
Nov 30 04:34:23  postgres[869]: [29-2] STATEMENT: 
Nov 30 04:34:23  postgres[869]: [29-3] INSERT INTO smf_calendar_holidays (title, event_date) VALUES ('Father\'s Day', '2020-06-21');
Nov 30 04:34:31  postgres[869]: [30-1] ERROR:  syntax error at or near "(" at character 91
Nov 30 04:34:31  postgres[869]: [30-2] STATEMENT: 
Nov 30 04:34:31  postgres[869]: [30-3] INSERT INTO smf_smileys (code, filename, description, smiley_order, hidden) VALUES (':\'(', 'cry.gif', 'РM-^_лаСM-^GСM-^CСM- РёР№', 15, 0);
phpinfo():

Код Выделить Развернуть

PHP logo
PHP Version 5.6.14

System FreeBSD 10.2-RELEASE-p5 FreeBSD 10.2-RELEASE-p5 #0 r289875: Sun Oct 25 00:53:26 NOVT 2015 sibfaktor@bsdvm.local:/usr/obj/usr/src/sys/ZFS386 i386
Build Date Nov 30 2015 02:35:32
Configure Command './configure' '--with-layout=GNU' '--localstatedir=/var' '--with-config-file-scan-dir=/usr/local/etc/php' '--disable-all' '--enable-libxml' '--enable-mysqlnd' '--with-libxml-dir=/usr/local' '--with-pcre-regex=/usr/local' '--with-zlib-dir=/usr' '--program-prefix=' '--enable-fpm' '--with-fpm-user=www' '--with-fpm-group=www' '--with-regex=php' '--with-zend-vm=CALL' '--enable-maintainer-zts' '--disable-ipv6' '--prefix=/usr/local' '--mandir=/usr/local/man' '--infodir=/usr/local/info/' '--build=i386-portbld-freebsd10.2' 'build_alias=i386-portbld-freebsd10.2' 'CC=cc' 'CFLAGS=-O2 '-pipe' '-fstack-protector' '-fno-strict-aliasing'' 'LDFLAGS= '-fstack-protector'' 'LIBS=-lpthread' 'CPPFLAGS=' 'CPP=cpp' 'CXX=c++' 'CXXFLAGS=-O2 '-pipe' '-fstack-protector' '-fno-strict-aliasing'
Server API FPM/FastCGI
Virtual Directory Support enabled
Configuration File (php.ini) Path /usr/local/etc
Loaded Configuration File /usr/local/etc/php.ini
Scan this dir for additional .ini files /usr/local/etc/php
Additional .ini files parsed /usr/local/etc/php/extensions.ini
PHP API 20131106
PHP Extension 20131226
Zend Extension 220131226
Zend Extension Build API220131226,TS
PHP Extension Build API20131226,TS
Debug Build no
Thread Safety enabled
Zend Signal Handling disabled
Zend Memory Manager enabled
Zend Multibyte Support disabled
IPv6 Support disabled
DTrace Support disabled
Registered PHP Streams php, file, glob, data, http, ftp, phar
Registered Stream Socket Transports tcp, udp, unix, udg
Registered Stream Filters string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, dechunk, convert.iconv.*
Zend logo This program makes use of the Zend Scripting Language Engine:
Zend Engine v2.6.0, Copyright (c) 1998-2015 Zend Technologies
    with Zend OPcache v7.0.6-dev, Copyright (c) 1999-2015, by Zend Technologies
Configuration

cgi-fcgi

php-fpm active
Directive Local Value Master Value
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.error_header no value no value
fastcgi.logging 1 1
fpm.config no value no value
Core

PHP Version 5.6.14
Directive Local Value Master Value
allow_url_fopen On On
allow_url_include Off Off
always_populate_raw_post_data 0 0
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 UTF-8 UTF-8
default_mimetype text/html text/html
disable_clantispam by SMFRC 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
enable_post_data_reading On On
error_append_string no value no value
error_log no value no value
error_prepend_string no value no value
error_reporting 32767 32767
exit_on_timeout Off Off
expose_php On On
extension_dir /usr/local/lib/php/20131226-zts /usr/local/lib/php/20131226-zts
file_uploads On On
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/local/share/pear .:/usr/local/share/pear
input_encoding no value no value
internal_encoding no value no value
log_errors On On
log_errors_max_len 1024 1024
mail.add_x_header Off Off
mail.force_extra_parameters no value no value
mail.log no value no value
max_execution_time 30 30
max_file_uploads 20 20
max_input_nesting_level 64 64
max_input_time 60 60
max_input_vars 1000 1000
memory_limit 128M 128M
open_basedir no value no value
output_buffering 4096 4096
output_encoding no value no value
output_handler no value no value
post_max_size 8M 8M
precision 14 14
realpath_cache_size 16K 16K
realpath_cache_ttl 120 120
register_argc_argv Off Off
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 100 100
short_open_tag Off Off
SMTP localhost localhost
smtp_port 25 25
sql.safe_mode Off Off
sys_temp_dir no value no value
track_errors Off Off
unserialize_callback_func no value no value
upload_max_filesize 20M 20M
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 GPCS GPCS
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
date


Warning: phpinfo(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /www-site/disa-defilt/index.php on line 12
date/time support enabled
"Olson" Timezone Database Version 2015.6
Timezone Database internal
Default timezone UTC
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
dom

DOM/XML enabled
DOM/XML API Version 20031129
libxml Version 2.9.2
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: 86120bba568c551914a35636ec408f1e7e66af32 $
Directive Local Value Master Value
filter.default unsafe_raw unsafe_raw
filter.default_flags no value no value
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 gost-crypto adler32 crc32 crc32b fnv132 fnv1a32 fnv164 fnv1a64 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
iconv

iconv support enabled
iconv implementation libiconv
iconv library version 1.14
Directive Local Value Master Value
iconv.input_encoding no value no value
iconv.internal_encoding no value no value
iconv.output_encoding no value no value
json

json support enabled
json version 1.2.1
libxml

libXML support active
libXML Compiled Version 2.9.2
libXML Loaded Version 20902
libXML streams enabled
mhash

MHASH support Enabled
MHASH API Version Emulated Support
mysqlnd

mysqlnd enabled
Version mysqlnd 5.0.11-dev - 20120503 - $Id: 3c688b6bbc30d36af3ac34fdd4b7b5b787fe5555 $
Compression not supported
core SSL supported
extended SSL not 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,debug_trace,auth_plugin_mysql_native_password,auth_plugin_mysql_clear_password
API Extensions no value
mysqlnd 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
pcre

PCRE (Perl Compatible Regular Expressions) Support enabled
PCRE Library Version 8.37 2015-04-28
Directive Local Value Master Value
pcre.backtrack_limit 1000000 1000000
pcre.recursion_limit 100000 100000
PDO

PDO support enabled
PDO drivers sqlite
pdo_sqlite

PDO Driver for SQLite 3.x enabled
SQLite Library 3.9.1
pgsql

PostgreSQL Support enabled
PostgreSQL(libpq) Version 9.3.9
PostgreSQL(libpq) PostgreSQL 9.3.9 on i386-portbld-freebsd10.1, compiled by FreeBSD clang version 3.4.1 (tags/RELEASE_34/dot1-final 208032) 20140512, 32-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.2
Phar API version 1.1.1
SVN revision $Id: 72d7e004b07d106bb1ef7c5663a186cbae621385 $
Phar-based phar archives enabled
Tar-based phar archives enabled
ZIP-based phar archives enabled
gzip compression disabled (install ext/zlib)
bzip2 compression disabled (install pecl/bz2)
OpenSSL support disabled (install ext/openssl)
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
posix

Revision $Id: 5d20de77687b7d961b15450873fa23b9e64a136a $
Reflection

Reflection enabled
Version $Id: eff8bdc65b0beaf8f4ade6f06f848e6d43dfd826 $
session

Session Support enabled
Registered save handlers files user
Registered serializer handlers php_serialize php php_binary
Directive Local Value Master Value
session.auto_start Off Off
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 1000 1000
session.gc_maxlifetime 1440 1440
session.gc_probability 1 1
session.hash_bits_per_character 5 5
session.hash_function 0 0
session.name PHPSESSID PHPSESSID
session.referer_check no value no value
session.save_handler files files
session.save_path /tmp/forum_sessions /tmp/forum_sessions
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_strict_mode Off Off
session.use_trans_sid 0 0
SimpleXML

Simplexml support enabled
Revision $Id: 6b8e23a01a85046737ef7d31346da5164505c179 $
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
SPL

SPL support enabled
Interfaces Countable, OuterIterator, RecursiveIterator, SeekableIterator, SplObserver, SplSubject
Clantispam by SMFRC 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-dev
SQLite Library 3.9.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 0 0
default_socket_timeout 60 60
from no value no value
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

Tokenizer Support enabled
xml

XML Support active
XML Namespace Support active
libxml2 Version 2.9.2
xmlreader

XMLReader enabled
xmlwriter

XMLWriter enabled
Zend OPcache

Opcode Caching Up and Running
Optimization Enabled
Startup OK
Shared memory model mmap
Cache hits 0
Cache misses 1
Used memory 112024
Free memory 66996840
Wasted memory 0
Cached scripts 1
Cached keys 1
Max keys 3907
OOM restarts 0
Hash keys restarts 0
Manual restarts 0
Directive Local Value Master Value
opcache.blacklist_filename no value no value
opcache.consistency_checks 0 0
opcache.dups_fix Off Off
opcache.enable On On
opcache.enable_cli Off Off
opcache.enable_file_override Off Off
opcache.error_log no value no value
opcache.fast_shutdown 0 0
opcache.file_update_protection 2 2
opcache.force_restart_timeout 180 180
opcache.inherited_hack On On
opcache.interned_strings_buffer 4 4
opcache.load_comments 1 1
opcache.log_verbosity_level 1 1
opcache.max_accelerated_files 2000 2000
opcache.max_file_size 0 0
opcache.max_wasted_percentage 5 5
opcache.memory_consumption 64 64
opcache.optimization_level 0xFFFFFFFF 0xFFFFFFFF
opcache.preferred_memory_model no value no value
opcache.protect_memory 0 0
opcache.restrict_api no value no value
opcache.revalidate_freq 2 2
opcache.revalidate_path Off Off
opcache.save_comments 1 1
opcache.use_cwd On On
opcache.validate_timestamps On On
Additional Modules

Module Name
Environment

Variable Value
HOME /nonexistent
USER www
PHP Variables

Variable Value
_SERVER["HOME"] /nonexistent
_SERVER["USER"] www
_SERVER["FCGI_ROLE"] RESPONDER
_SERVER["SCRIPT_FILENAME"] /www-site/disa-defilt/index.php
_SERVER["QUERY_STRING"] no value
_SERVER["REQUEST_METHOD"] GET
_SERVER["CONTENT_TYPE"] no value
_SERVER["CONTENT_LENGTH"] no value
_SERVER["SCRIPT_NAME"] /index.php
_SERVER["REQUEST_URI"] /
_SERVER["DOCUMENT_URI"] /index.php
_SERVER["DOCUMENT_ROOT"] /usr/local/etc/nginx/html
_SERVER["SERVER_PROTOCOL"] HTTP/1.1
_SERVER["GATEWAY_INTERFACE"] CGI/1.1
_SERVER["SERVER_SOFTWARE"] nginx/1.8.0
_SERVER["REMOTE_ADDR"] 192.168.0.84
_SERVER["REMOTE_PORT"] 64115
_SERVER["SERVER_ADDR"] 192.168.0.103
_SERVER["SERVER_PORT"] 80
_SERVER["SERVER_NAME"] disa-defilt
_SERVER["REDIRECT_STATUS"] 200
_SERVER["HTTP_HOST"] 192.168.0.103
_SERVER["HTTP_CONNECTION"] keep-alive
_SERVER["HTTP_CACHE_CONTROL"] max-age=0
_SERVER["HTTP_ACCEPT"] text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8
_SERVER["HTTP_UPGRADE_INSECURE_REQUESTS"] 1
_SERVER["HTTP_USER_AGENT"] Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/46.0.2490.86 Safari/537.36
_SERVER["HTTP_ACCEPT_ENCODING"] gzip, deflate, sdch
_SERVER["HTTP_ACCEPT_LANGUAGE"] ru-RU,ru;q=0.8,en-US;q=0.6,en;q=0.4
_SERVER["PHP_SELF"] /index.php
_SERVER["REQUEST_TIME_FLOAT"] 1448948053.7282
_SERVER["REQUEST_TIME"] 1448948053
PHP Credits

PHP Group
Thies C. Arntzen, Stig Bakken, Shane Caraveo, Andi Gutmans, Rasmus Lerdorf, Sam Ruby, Sascha Schumann, Zeev Suraski, Jim Winstead, Andrei Zmievski
Language Design & Concept
Andi Gutmans, Rasmus Lerdorf, Zeev Suraski, Marcus Boerger
PHP Authors
Contribution Authors
Zend Scripting Language Engine Andi Gutmans, Zeev Suraski, Stanislav Malyshev, Marcus Boerger, Dmitry Stogov, Xinchen Hui, Nikita Popov
Extension Module API Andi Gutmans, Zeev Suraski, Andrei Zmievski
UNIX Build and Modularization Stig Bakken, Sascha Schumann, Jani Taskinen
Windows Port Shane Caraveo, Zeev Suraski, Wez Furlong, Pierre-Alain Joye, Anatol Belski
Server API (SAPI) Abstraction Layer Andi Gutmans, Shane Caraveo, Zeev Suraski
Streams Abstraction Layer Wez Furlong, Sara Golemon
PHP Data Objects Layer Wez Furlong, Marcus Boerger, Sterling Hughes, George Schlossnagle, Ilia Alshanetsky
Output Handler Zeev Suraski, Thies C. Arntzen, Marcus Boerger, Michael Wallner
SAPI Modules
Contribution Authors
AOLserver Sascha Schumann
Apache 1.3 (apache_hooks) Rasmus Lerdorf, Zeev Suraski, Stig Bakken, David Sklar, George Schlossnagle, Lukas Schroeder
Apache 1.3 Rasmus Lerdorf, Zeev Suraski, Stig Bakken, David Sklar
Apache 2.0 Filter Sascha Schumann, Aaron Bannert
Apache 2.0 Handler Ian Holsman, Justin Erenkrantz (based on Apache 2.0 Filter code)
Caudium / Roxen David Hedbor
CGI / FastCGI Rasmus Lerdorf, Stig Bakken, Shane Caraveo, Dmitry Stogov
CLI Edin Kadribasic, Marcus Boerger, Johannes Schlueter, Moriyoshi Koizumi, Xinchen Hui
Continuity Alex Leigh (based on nsapi code)
Embed Edin Kadribasic
FastCGI Process Manager Andrei Nigmatulin, dreamcat4, Antony Dovgal, Jerome Loyet
ISAPI Andi Gutmans, Zeev Suraski
litespeed George Wang
NSAPI Jayakumar Muthukumarasamy, Uwe Schindler
phpdbg Felipe Pena, Joe Watkins, Bob Weinand
phttpd Thies C. Arntzen
pi3web Holger Zimmermann
Sendmail Milter Harald Radi
thttpd Sascha Schumann
tux Sascha Schumann
WebJames Alex Waugh
Module Authors
Module Authors
BC Math Andi Gutmans
Bzip2 Sterling Hughes
Calendar Shane Caraveo, Colin Viebrock, Hartmut Holzgraefe, Wez Furlong
COM and .Net Wez Furlong
ctype Hartmut Holzgraefe
cURL Sterling Hughes
Date/Time Support Derick Rethans
DB-LIB (MS SQL, Sybase) Wez Furlong, Frank M. Kromann
DBA Sascha Schumann, Marcus Boerger
DOM Christian Stocker, Rob Richards, Marcus Boerger
enchant Pierre-Alain Joye, Ilia Alshanetsky
ereg Rasmus Lerdorf, Jim Winstead, Jaakko Hyvätti
EXIF Rasmus Lerdorf, Marcus Boerger
fileinfo Ilia Alshanetsky, Pierre Alain Joye, Scott MacVicar, Derick Rethans
Firebird driver for PDO Ard Biesheuvel
FTP Stefan Esser, Andrew Skalski
GD imaging Rasmus Lerdorf, Stig Bakken, Jim Winstead, Jouni Ahto, Ilia Alshanetsky, Pierre-Alain Joye, Marcus Boerger
GetText Alex Plotnick
GNU GMP support Stanislav Malyshev
Iconv Rui Hirokawa, Stig Bakken, Moriyoshi Koizumi
IMAP Rex Logan, Mark Musone, Brian Wang, Kaj-Michael Lang, Antoni Pamies Olive, Rasmus Lerdorf, Andrew Skalski, Chuck Hagenbuch, Daniel R Kalowsky
Input Filter Rasmus Lerdorf, Derick Rethans, Pierre-Alain Joye, Ilia Alshanetsky
InterBase Jouni Ahto, Andrew Avdeev, Ard Biesheuvel
Internationalization Ed Batutis, Vladimir Iordanov, Dmitry Lakhtyuk, Stanislav Malyshev, Vadim Savchuk, Kirti Velankar
JSON Omar Kilani, Scott MacVicar
LDAP Amitay Isaacs, Eric Warnke, Rasmus Lerdorf, Gerrit Thomson, Stig Venaas
LIBXML Christian Stocker, Rob Richards, Marcus Boerger, Wez Furlong, Shane Caraveo
mcrypt Sascha Schumann, Derick Rethans
MS SQL Frank M. Kromann
Multibyte String Functions Tsukada Takuya, Rui Hirokawa
MySQL driver for PDO George Schlossnagle, Wez Furlong, Ilia Alshanetsky, Johannes Schlueter
MySQL Zeev Suraski, Zak Greant, Georg Richter, Andrey Hristov
MySQLi Zak Greant, Georg Richter, Andrey Hristov, Ulf Wendel
MySQLnd Andrey Hristov, Ulf Wendel, Georg Richter, Johannes Schlüter
OCI8 Stig Bakken, Thies C. Arntzen, Andy Sautins, David Benson, Maxim Maletsky, Harald Radi, Antony Dovgal, Andi Gutmans, Wez Furlong, Christopher Jones, Oracle Corporation
ODBC driver for PDO Wez Furlong
ODBC Stig Bakken, Andreas Karajannis, Frank M. Kromann, Daniel R. Kalowsky
OpenSSL Stig Venaas, Wez Furlong, Sascha Kettler, Scott MacVicar
Oracle (OCI) driver for PDO Wez Furlong
pcntl Jason Greene, Arnaud Le Blanc
Perl Compatible Regexps Andrei Zmievski
PHP Archive Gregory Beaver, Marcus Boerger
PHP Data Objects Wez Furlong, Marcus Boerger, Sterling Hughes, George Schlossnagle, Ilia Alshanetsky
PHP hash Sara Golemon, Rasmus Lerdorf, Stefan Esser, Michael Wallner, Scott MacVicar
Posix Kristian Koehntopp
PostgreSQL driver for PDO Edin Kadribasic, Ilia Alshanetsky
PostgreSQL Jouni Ahto, Zeev Suraski, Yasuo Ohgaki, Chris Kings-Lynne
Pspell Vlad Krupin
Readline Thies C. Arntzen
Recode Kristian Koehntopp
Reflection Marcus Boerger, Timm Friebe, George Schlossnagle, Andrei Zmievski, Johannes Schlueter
Sessions Sascha Schumann, Andrei Zmievski
Shared Memory Operations Slava Poliakov, Ilia Alshanetsky
SimpleXML Sterling Hughes, Marcus Boerger, Rob Richards
SNMP Rasmus Lerdorf, Harrie Hazewinkel, Mike Jackson, Steven Lawrance, Johann Hanne, Boris Lytochkin
SOAP Brad Lafountain, Shane Caraveo, Dmitry Stogov
Sockets Chris Vandomelen, Sterling Hughes, Daniel Beulshausen, Jason Greene
SPL Marcus Boerger, Etienne Kneuss
SQLite 3.x driver for PDO Wez Furlong
SQLite3 Scott MacVicar, Ilia Alshanetsky, Brad Dewar
Sybase-CT Zeev Suraski, Tom May, Timm Friebe
System V Message based IPC Wez Furlong
System V Semaphores Tom May
System V Shared Memory Christian Cartus
tidy John Coggeshall, Ilia Alshanetsky
tokenizer Andrei Zmievski, Johannes Schlueter
WDDX Andrei Zmievski
XML Stig Bakken, Thies C. Arntzen, Sterling Hughes
XMLReader Rob Richards
xmlrpc Dan Libby
XMLWriter Rob Richards, Pierre-Alain Joye
XSL Christian Stocker, Rob Richards
Zip Pierre-Alain Joye, Remi Collet
Zlib Rasmus Lerdorf, Stefan Roehrich, Zeev Suraski, Jade Nicoletti, Michael Wallner
PHP Documentation
Authors Mehdi Achour, Friedhelm Betz, Antony Dovgal, Nuno Lopes, Hannes Magnusson, Georg Richter, Damien Seguy, Jakub Vrana, Adam Harvey, Peter Cowburn
Editor Philip Olson
User Note Maintainers Daniel P. Brown, Thiago Henrique Pojda
Other Contributors Previously active authors, editors and other contributors are listed in the manual.
PHP Quality Assurance Team
Ilia Alshanetsky, Joerg Behrens, Antony Dovgal, Stefan Esser, Moriyoshi Koizumi, Magnus Maatta, Sebastian Nohn, Derick Rethans, Melvyn Sopacua, Jani Taskinen, Pierre-Alain Joye, Dmitry Stogov, Felipe Pena, David Soria Parra, Stanislav Malyshev, Julien Pauli, Stephen Zarkos, Anatol Belski, Remi Collet, Ferenc Kovacs
Websites and Infrastructure team
PHP Websites Team Rasmus Lerdorf, Hannes Magnusson, Philip Olson, Lukas Kahwe Smith, Pierre-Alain Joye, Kalle Sommer Nielsen, Peter Cowburn, Adam Harvey, Ferenc Kovacs, Levi Morrison
Event Maintainers Damien Seguy, Daniel P. Brown
Network Infrastructure Daniel P. Brown
Windows Infrastructure Alex Schoenmaker
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.


[Mavn]

1. Чем обусловлен выбор Postgres? будет какой-то гигантский форум? если нет, то я бы советовал выбрать mysql версию
2. это довольно известная бага, можно попробовать заменить \' -> "
3. или попробовать вообще не вносить данные их тех таблиц где ошибки я не думаю что праздники на английском языке особо нужная фича для ру форума, смайлы можно и руками потом забить, это не трудно инструкция в разделе документация имеется
4. Данный баг или в следующей версии 2.0 пофиксят или перенесут на 2.1, т.е. не быстро

вообще если так разбираться если есть выбор между MySQL и Postgres версией форума и если выбор не упирается в выбор бд в силу каких то технологических причин я бы советовал присмотреться к MySQL версии

[valdnieks]

PostgreSQL для хайлоад проектов, забить и установить мускул.

[disa]

Спасибо!
Пострес специально поставил, давно хотел поработать в нем. Это же исток многих субд )

а первая ошибка о чем говорит? про smf_settings

[Mavn]

о том же... что и остальные...неправильный синктаксис

[disa]

Уважаемые, а вот это сообщение об ошибке в логе о чем говорит?:

Код Выделить Развернуть

Nov 30 04:34:18  postgres[869]: [4-1] ERROR:  relation "smf_settings" does not exist at character 34
Nov 30 04:34:18  postgres[869]: [4-2] STATEMENT: 
Nov 30 04:34:18  postgres[869]: [4-3]            SELECT variable, value
Nov 30 04:34:18  postgres[869]: [4-4]            FROM smf_settings

происходит селект по несуществующей таблице, но ведь этого быть не должно, значит что-то выполняется не в своей очередности?

в Install.php нашел такой кусок кода:

Код Выделить Развернуть

// Before running any of the queries, let's make sure another version isn't already installed.
$result = $smcFunc['db_query']('', '
SELECT variable, value
FROM {db_prefix}settings',
array(
'db_error_skip' => true,
)
);

уж совершенно случайно, не является ли сообщение об ошибке в логе субд следствием того, что через пхп так категорически неверно проверяется наличие таблицы с настройками?

[valdnieks]

PostgreSQL – унифицированный сервер баз данных, имеющий единый движок – storage engine.

В MySQL другие.

[disa]

Всех приветствую.
Установил форум в новую чистую БД Postgresql, предварительно поменяв где нужно /' на ".
Проинсталлилось без ошибок, но при заходе на форум увидел, что нет графики. Включил отображение кода и вижу, что вместо путей, куда поставлен форум, кое-где есть ссылки на 127.0.0.1/smf.



запускаю пролетавший на форуме repair_settings.php и вижу такую картину:



это ошибка инсталлятора? Может поправить нужно в следующих релизах?

[GeorG]

Исправьте пути на предложные repair settings (пощёлкайте по синеньким надписям внизу) и сохраните, должно заработать.

[disa]

Исправьте пути на предложные repair settings (пощёлкайте по синеньким надписям внизу) и сохраните, должно заработать.

Да понятно дело, что я догадался исправить и у меня пока работает.

Я хотел обратить внимание заинтересованных лиц на ошибку инсталляции, вношу, так сказать, вклад в развитие проекта.
А вот насчет предыдущего сообщения, о проверке наличия таблицы селектом - пока тоже ответа нет.

[digger®]

Да понятно дело, что я догадался исправить и у меня пока работает.

Я хотел обратить внимание заинтересованных лиц на ошибку инсталляции, вношу, так сказать, вклад в развитие проекта.

Это не ошибка инсталляции, это ваш веб-сервер такой путь инсталлятору выдал.

[disa]

Это не ошибка инсталляции, это ваш веб-сервер такой путь инсталлятору выдал.

Хм, именно в таком виде, что для каких-то директорий правильный путь, а для каких-то неверный? Хорошо, я проверю еще раз настройки ввв сервера

[digger®]

Хм, именно в таком виде, что для каких-то директорий правильный путь, а для каких-то неверный? Хорошо, я проверю еще раз настройки ввв сервера

Не для "каких-то", а для всех урлов у вас такой выставился. А при установке в локальном окружении, вообще, нет смысла обсуждать такие вопросы.