xampp 64bit

[ErtiAV]

Hello dear,

I'm wondering, are you going to do the xampp 64 bit version?
I'm running xampp on my workstation with 32GB ram. But I couldn't this ram because of 32bit.
Always I'm getting php exhausted error.

It will be very helpful if 64bit is developed.

Thank you very much.

[EDIT by Altrea: moved to the english section of this board]

[Nobbie]

Always I'm getting php exhausted error.

I dont think that error is due to 32/64 bit, its simply a question of php.ini configuration. If you provide the full error message, we can find out how to improve your php.ini. Would be better than waiting for a 64bit version (which would fail anyway with insufficient settings in php.ini). If you really really need an 64bit version, you have to switch to Linux (or another distribution than Xampp).

A last note: this is a german forum, the english part is in the bottom.

[ErtiAV]

Thank you for quick reply.
I have to use Windows and I am very pleased xampp.
My php.ini file

[PHP]
engine = On

short_open_tag = On

precision = 14

output_buffering = 4096

zlib.output_compression = Off

implicit_flush = Off

unserialize_callback_func =

serialize_precision = 17

disable_functions =

disable_classes =

zend.enable_gc = On

expose_php = On

max_execution_time = 300

max_input_time = 60

max_input_vars = 3000

memory_limit = 2048M

error_reporting = E_ALL | E_STRICT

display_errors = On

display_startup_errors = On

log_errors = On

log_errors_max_len = 1024

ignore_repeated_errors = Off

ignore_repeated_source = Off

report_memleaks = On

track_errors = On

html_errors = On

error_log = php_errors.log

variables_order = "GPCS"

request_order = "GP"

register_argc_argv = Off

auto_globals_jit = On

post_max_size = 1024M

auto_prepend_file =

auto_append_file =

default_mimetype = "text/html"

default_charset = "UTF-8"

include_path = \xampp\php\PEAR
doc_root =

user_dir =

extension_dir = "E:\xampp\php\ext"

enable_dl = On

file_uploads = On

upload_tmp_dir = "E:\xampp\tmp"

upload_max_filesize = 512M

max_file_uploads = 20

allow_url_fopen = On

allow_url_include = Off

default_socket_timeout = 60

extension=php_bz2.dll
extension=php_curl.dll
extension=php_fileinfo.dll
extension=php_gd2.dll
extension=php_gettext.dll
;extension=php_gmp.dll
;extension=php_intl.dll
extension=php_imap.dll
;extension=php_interbase.dll
;extension=php_ldap.dll
extension=php_mbstring.dll
extension=php_exif.dll
extension=php_mysqli.dll
extension=php_oci8_12c.dll
;extension=php_openssl.dll
;extension=php_pdo_firebird.dll
extension=php_pdo_mysql.dll
extension=php_pdo_oci.dll
extension=php_pdo_odbc.dll
extension=php_pdo_pgsql.dll
extension=php_pdo_sqlite.dll
;extension=php_pgsql.dll
;extension=php_shmop.dll
;extension=php_snmp.dll

extension=php_soap.dll
extension=php_sockets.dll
extension=php_sqlite3.dll
;extension=php_tidy.dll
extension=php_xmlrpc.dll
extension=php_xsl.dll
;extension=php_sqlsrv.dll
;extension=php_pdo_sqlsrv_56_ts.dll
;extension=php_sqlsrv_56_ts.dll
;extension=php_sqlsrv_7_nts.dll
extension=php_sqlsrv_7_ts.dll
;;;;;;;;;;;;;;;;;;;
; Module Settings ;
;;;;;;;;;;;;;;;;;;;
asp_tags=Off
display_startup_errors=On
track_errors=Off
y2k_compliance=On
allow_call_time_pass_reference=Off
safe_mode=Off
safe_mode_gid=Off
safe_mode_allowed_env_vars=PHP_
safe_mode_protected_env_vars=LD_LIBRARY_PATH
error_log="E:\xampp\php\logs\php_error_log"
register_globals=Off
register_long_arrays=Off
magic_quotes_gpc=Off
magic_quotes_runtime=Off
magic_quotes_sybase=Off
extension=php_openssl.dll
extension=php_ftp.dll

[CLI Server]
cli_server.color = On

[Date]

[filter]

[iconv]

[intl]

[sqlite3]

[Pcre]

[Pdo]
pdo_mysql.default_socket="MySQL"

[Pdo_mysql]
pdo_mysql.cache_size = 2000

pdo_mysql.default_socket=

[Phar]

[mail function]
SMTP = localhost
smtp_port = 25

mail.add_x_header = On

[SQL]
sql.safe_mode = Off

[ODBC]
odbc.allow_persistent = On

odbc.check_persistent = On

odbc.max_persistent = -1

odbc.max_links = -1

odbc.defaultlrl = 4096

odbc.defaultbinmode = 1

[Interbase]
ibase.allow_persistent = 1

ibase.max_persistent = -1

ibase.max_links = -1

ibase.timestampformat = "%Y-%m-%d %H:%M:%S"

ibase.dateformat = "%Y-%m-%d"

ibase.timeformat = "%H:%M:%S"

[MySQLi]
mysqli.max_persistent = -1

mysqli.allow_local_infile = On

mysqli.allow_persistent = On

mysqli.max_links = -1

mysqli.cache_size = 2000

mysqli.default_port = 3306

mysqli.default_socket = "MySQL"

mysqli.default_host =

mysqli.default_user =

mysqli.default_pw =

mysqli.reconnect = Off

[mysqlnd]
mysqlnd.collect_statistics = On

mysqlnd.collect_memory_statistics = Off

[OCI8]
oci8.max_persistent = 50

oci8.persistent_timeout = 300

oci8.ping_interval = 0

oci8.connection_class = MYPHPAPP

oci8.old_oci_close_semantics = On

[PostgreSQL]
pgsql.allow_persistent = On

pgsql.auto_reset_persistent = Off

pgsql.max_persistent = -1

pgsql.max_links = -1

pgsql.ignore_notice = 0

pgsql.log_notice = 0

[bcmath]
bcmath.scale = 0

[browscap]
browscap = "E:\xampp\php\extras\browscap.ini"

[Session]
session.save_handler = files

session.save_path = "E:\xampp\tmp"

session.use_strict_mode = 1

session.use_cookies = 1

session.use_only_cookies = 0

session.name = PHPSESSID

session.auto_start = 0

session.cookie_lifetime = 0

session.cookie_path = /

session.cookie_domain =

session.cookie_httponly =

session.serialize_handler = php

session.gc_probability = 1

session.gc_divisor = 1000

session.gc_maxlifetime = 1440

session.referer_check =

session.entropy_length = 0

session.cache_limiter = nocache

session.cache_expire = 180

session.use_trans_sid = 0

session.hash_function = 0

session.hash_bits_per_character = 5

url_rewriter.tags = "a=href,area=href,frame=src,input=src,form=fakeentry"

[Assertion]
zend.assertions = 1

[COM]

[mbstring]

[gd]

[exif]

[Tidy]
tidy.clean_output = Off

[soap]
soap.wsdl_cache_enabled=1

soap.wsdl_cache_dir="/tmp"

soap.wsdl_cache_ttl=86400

soap.wsdl_cache_limit = 5

[sysvshm]

[ldap]
ldap.max_links = -1

[mcrypt]

[dba]

[opcache]

[curl]

[openssl]

[Syslog]
define_syslog_variables=Off
[Session]
define_syslog_variables=Off
[Date]
date.timezone=Asia/Istanbul
[MySQL]
mysql.allow_local_infile=On
mysql.allow_persistent=On
mysql.cache_size=2000
mysql.max_persistent=-1
mysql.max_link=-1
mysql.default_port=3306
mysql.default_socket="MySQL"
mysql.connect_timeout=3
mysql.trace_mode=Off
[Sybase-CT]
sybct.allow_persistent=On
sybct.max_persistent=-1
sybct.max_links=-1
sybct.min_server_severity=10
sybct.min_client_severity=10
[MSSQL]
mssql.allow_persistent=On
mssql.max_persistent=-1
mssql.max_links=-1
mssql.min_error_severity=10
mssql.min_message_severity=10
mssql.compatability_mode=Off
mssql.secure_connection=Off

[Nobbie]

My php.ini file

??

Thats not what i asked for:

If you provide the full error message, we can find out how to improve your php.ini.

[ErtiAV]

[21-Dec-2016 02:34:30 Europe/Istanbul] PHP Fatal error: Out of memory (allocated 138412032) (tried to allocate 20480 bytes) in E:\xampp\htdocs\excel_spread\PHPExcel\CachedObjectStorage\CacheBase.php on line 177

[21-Dec-2016 02:35:22 Europe/Istanbul] PHP Fatal error: Out of memory (allocated 134217728) (tried to allocate 20480 bytes) in E:\xampp\htdocs\excel_spread\PHPExcel\CachedObjectStorage\CacheBase.php on line 177

[21-Dec-2016 02:36:10 Europe/Istanbul] PHP Fatal error: Out of memory (allocated 115343360) (tried to allocate 3670016 bytes) in E:\xampp\htdocs\excel_spread\PHPExcel\CachedObjectStorage\CacheBase.php on line 177

[21-Dec-2016 02:36:44 Europe/Istanbul] PHP Fatal error: Out of memory (allocated 44040192) (tried to allocate 30579920 bytes) in E:\xampp\htdocs\defect_details.php on line 189

[21-Dec-2016 02:37:10 Europe/Istanbul] PHP Fatal error: Out of memory (allocated 2097152) (tried to allocate 917504 bytes) in E:\xampp\htdocs\repairgeneral.php on line 202

[21-Dec-2016 02:37:10 Europe/Istanbul] PHP Fatal error: Out of memory (allocated 125829120) (tried to allocate 4096 bytes) in E:\xampp\htdocs\excel_spread\PHPExcel\CachedObjectStorage\PHPTemp.php on line 60

[21-Dec-2016 02:39:00 Europe/Istanbul] PHP Fatal error: Out of memory (allocated 117440512) (tried to allocate 3670016 bytes) in E:\xampp\htdocs\excel_spread\PHPExcel\CachedObjectStorage\CacheBase.php on line 177

[21-Dec-2016 03:11:16 Europe/Istanbul] PHP Fatal error: Out of memory (allocated 140509184) (tried to allocate 7340032 bytes) in E:\xampp\htdocs\excel_spread\PHPExcel\CachedObjectStorage\CacheBase.php on line 177

[21-Dec-2016 03:12:13 Europe/Istanbul] PHP Fatal error: Out of memory (allocated 115343360) (tried to allocate 20480 bytes) in E:\xampp\htdocs\excel_spread\PHPExcel\CachedObjectStorage\CacheBase.php on line 177

[21-Dec-2016 03:13:11 Europe/Istanbul] PHP Fatal error: Out of memory (allocated 106954752) (tried to allocate 20480 bytes) in E:\xampp\htdocs\excel_spread\PHPExcel\CachedObjectStorage\CacheBase.php on line 177

[21-Dec-2016 03:13:32 Europe/Istanbul] PHP Fatal error: Out of memory (allocated 54525952) (tried to allocate 4096 bytes) in E:\xampp\htdocs\excel_spread\PHPExcel\CachedObjectStorage\PHPTemp.php on line 60

[21-Dec-2016 03:15:02 Europe/Istanbul] PHP Fatal error: Out of memory (allocated 140509184) (tried to allocate 7340032 bytes) in E:\xampp\htdocs\excel_spread\PHPExcel\CachedObjectStorage\CacheBase.php on line 177

[Nobbie]

I wonder that even in the worst case PHP only allocated less than 150MB and then failed, this is not quite a limit for a 32bit environment, which is restricted to 4096MB and each thread (process) is restricted to 2048MB - both by far more than only 150MB. In some case it already fails far earlier after only allocating 2MB.

This looks like a very bad memory management in PHPExcel and I also found many forums and postings in the internet, which also tells about these kind of problems with PHPExcel. I am not sure if a 64bit environment would help to solve the problem, as it is also reported that PDFExcel also has big runtime problems, it takes too long for large excel spreadsheets.

Here http://stackoverflow.com/questions/4817 ... 4mb-of-ram a few alternative libraries are recommended, you may try to adapt your scripts to these libraries. Or try to run your code on an Linux 64bit environment, there is a 64bit Xampp as well, but as i told before, i am unsure if 64bit really helps in this case. All in all the PDFExcel API seems to waist ressources in a very bad way.

[ErtiAV]

Thank you for quick reply.

I am aware of PHPExcel memory issues. I have to use PHPExcel because very develop create excel sheet. If there are alternative have same capabilities like PHPExcel please let me know.

The article you sent is just for reading, so this useless for me.

On the other hand, It works fine on IIS same machine. But I have to use Xammp, because I am using several script/function. And some script/function doesn't run IIS.

The site I made consists of about 1000 pages. So revision is a really hard work.

I hope the Xampp 64 bit is done as soon as possible.

Thank you for your support.

[Altrea]

Do it yourself.
Use the Apache Win64 Binaries from here https://www.apachelounge.com/download/
Use the PHP x64 version from here http://windows.php.net/download/
and put it all together.

XAMPP is not made for production environments. It is for local test and development purposes only.

[Nobbie]

The article you sent is just for reading, so this useless for me.

Are you kidding?? You either did not read it carefully, or you did not understand it. There are lots of hints how to fix the memory problem, as well there are links to other solutions and APIs. I cannot believe that you really overlooked all that. But finally, it is your problem, i tried to help, it is on you make the best out of it.

I hope the Xampp 64 bit is done as soon as possible.

There is already Xampp 64 bit, your problem is WIndows. Use Linux instead (or OSX) and you have a 64bit Xampp installation immediately. As Apache, Php etc. are developed and maintained in Linux environments, this is superior to any poor Windows installation. Why WIndows??

[ErtiAV]

Nobbie be sure. I read a lot of documents this issue. Many of them about reading excel.

I want to use Linux but company rules! I think I do it myself.

thanks both of you.

[Nobbie]

I want to use Linux but company rules! I think I do it myself.

If I were you, what about this idea:

a) setup Linux server with Xampp 64bit and try to solve the problems on that server. If it works...

b) ... call your boss, show him the well working Linux server, after then show him the struggling Windows environment incuding all crashes ...

c) ... and then ask your boss, which server should we use?

Merry Christmas!

[ErtiAV]

Sounds great, but unfortunately I'm working for a multinational company. And my company signed a software contract with Microsoft.
I will build up one by one.
Thank you very much.

Marry Chirstmas

[Nobbie]

Sounds great, but unfortunately I'm working for a multinational company. And my company signed a software contract with Microsoft.

That is real strange - on the one hand, your company goes with Microsoft and denies Linux, but the Webserver is build with Apache (Xampp) instead of IIS. That is crazy!