PatRoy

Thanks. I had to escape 3 times the backslach afterall : preg_replace("/\w+\\\/", "", $str); Cheers for your help

Hello, I'm sure my error isn't much, but I can't seem to remove part of a string... This is an example string: Stack trace: #0 /mnt/HD/HD_a2/DATA/WWW/html/calchom/include/CorbeauPerdu/Database/DBWrapperStatement.php(525): CorbeauPerdu\Database\DBWrapperStatement->_stmtCommitOnEachExec_HOTFIX() #1 /mnt/HD/HD_a2/DATA/WWW/html/calchom/include/CorbeauPerdu/Database/DBWrapperStatement.php(378): CorbeauPerdu\Database\DBWrapperStatement->_runMultiStatement(true) #2 /mnt/HD/HD_a2/DATA/WWW/html/calchom/include/CorbeauPerdu/Database/DBWrapper.php(773): CorbeauPerdu\Database\DBWrapperStatement->runStatement(false, true) #3 /mnt/HD/HD_a2/DATA/WWW/html/calchom/include/CorbeauPerdu/Database/DBWrapper.php(708): CorbeauPerdu\Database\DBWrapper->_storeDataEXE('INSERT INTO tbl...', Array, Array, true) #4 /mnt/HD/HD_a2/DATA/WWW/html/calchom/test.php(112): CorbeauPerdu\Database\DBWrapper->storeData('INSERT INTO tbl...', Array, Array, true, true) #5 {main} I want to remove, in this case, all instances of "CorbeauPerdu\Database\" . These could be other words of course... I tried the following regex in preg_replace(), which seems to work if I test in http://regex101.com/, but doesn't seem to work at all: $pattern = "/\w+\\\w+\\/"; echo "Fixed = ".preg_replace($pattern, "", $str); On top of that, my error log keeps telling me: Warning: preg_replace(): No ending delimiter '/' found ... Any ideas on what I'm doing wrong here? Much thanks Pat

Just as an update, I haven't yet managed to upgrade my PHP on my NAS: it is pretty difficult to compile because of a series of problems, which leads to having to recompile other libs (i.e. wrong PCRE version), which leads to other problems... For now, I changed my code for that particular function so that it replaces my SQL ':variable' to the PDO::quote(values), and PDO::exec() instead of using bindParam. This way, I can keep my PDO::ATTR_EMULATE_PREPARES => FALSE, and it works... I don't like it, because it's a little slower, but don't have a choice for now

It'll take me quite a bit of effort, cause I can't find packages for it for my NAS (it's running Fonz Fun_plug 0.7)... Kinda old, and VERY slow to compile on... I'll still see if I can manage to compile a newer version.. However, I doubt this is a PHP 7.1 issue (?), since I did manage to install PHP 7.1.33 on my PC and my code is working fine there... I'll repost when / if I manage to still compile a newer php ...

UPDATE: alrighty, I finally managed to get gdb working on my server. Here's the output of GDB : root@datahub:/mnt/HD/HD_a2/DATA/NAS_Core_Dumps# gdb /ffp/bin/php-cgi core-php-cgi.11576 GNU gdb (GDB) 7.3.1 Copyright (C) 2011 Free Software Foundation, Inc. License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html> This is free software: you are free to change and redistribute it. There is NO WARRANTY, to the extent permitted by law. Type "show copying" and "show warranty" for details. This GDB was configured as "armv5tel-unknown-linux-gnueabi". For bug reporting instructions, please see: <http://www.gnu.org/software/gdb/bugs/>... Reading symbols from /mnt/HD/HD_a2/ffp/bin/php-cgi...(no debugging symbols found)...done. [New LWP 11576] [Thread debugging using libthread_db enabled] Core was generated by `/ffp/bin/php-cgi test.php'. Program terminated with signal 11, Segmentation fault. #0 0x40d4c494 in pdo_mysql_stmt_param_hook () from /ffp/lib/php/modules/pdo_mysql.so (gdb) bt #0 0x40d4c494 in pdo_mysql_stmt_param_hook () from /ffp/lib/php/modules/pdo_mysql.so #1 0x000ce55c in ?? () Cannot access memory at address 0x0 #2 0x000ce55c in ?? () Cannot access memory at address 0x0 Backtrace stopped: previous frame identical to this frame (corrupt stack?) Not sure what to think about this backtrace line... "Backtrace stopped: previous frame identical to this frame (corrupt stack?)". I don't really understand it all... Thanks again for your help guys

Okay, I see what you mean about the autocommit... I tried as you said, essentially either remove the ATTR_AUTOCOMMIT => false, or I tried setting it to TRUE also.. I've kept only the $stmt->execute() in my loop, removing the beginTransaction() and commit(), but no luck.... I'm still getting a segfault / http 500 error It really is just the "ATTR_EMULATE_PREPARES => FALSE" causing this segfault... I've managed to get PHP 7.1.33 on my working PC, although not quite the same as on my server (7.1.4), and still working on PC.... I'm very puzzled here....

Hey Barand, All valid points, but none that'll help my problem out To answer you... Okay for the autocommit attribute.. though it doesn't change anything in my case.. Here's the thing: I WANT to commit on every inserts! I already have another function as you said and did, but I want to be able to have a choice to commit on every row of data, and if one fails, just populate an array of failed ones, and keep on trying the remaining data... It's a very "generic" DB Wrapper I've written, which I'll hope to use in other projects. Doing it JUST like you did, if one fails, then everything is rolled back.. For the passwords... yep I know this... but it was for code clarity Thanks

Just as a FYI, I got gdb-7.3.1 installed from a package for my NAS, but when trying to run it with the coredump, I get the following: root@datahub:/mnt/HD/HD_a2/DATA/NAS_Core_Dumps# gdb /ffp/bin/php-cgi core-php-cgi.12447 GNU gdb (GDB) 7.3.1 Copyright (C) 2011 Free Software Foundation, Inc. License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html> This is free software: you are free to change and redistribute it. There is NO WARRANTY, to the extent permitted by law. Type "show copying" and "show warranty" for details. This GDB was configured as "arm-ffp-linux-uclibcgnueabi". For bug reporting instructions, please see: <http://www.gnu.org/software/gdb/bugs/>... Reading symbols from /mnt/HD/HD_a2/ffp/bin/php-cgi...I'm sorry, Dave, I can't do that. Symbol format `elf32-littlearm' unknown. .... But, that's beyond the scope of this post... Trying to build another gdb from source for now..

Thanks for your reply. Okay, I managed to get the coredump, but I'm still trying really hard to get gdb installed and working properly on my NAS server... No luck yet, but working on it. Meanwhile, digging deeper, I did find exactly what was causing the segfault. It's my PDO Attribute: PDO::ATTR_EMULATE_PREPARES => false If I set this to TRUE, then it works... Now, this is an issue for me, since I'm using this to protect against SQL injections... Any ideas ? P.s.: as soon as I can get gdb working properly, I'll re-post trace... Is there any way I can just submit the coredump somewhere, or do I absolutely need to 'gdb php-cgi corefile' ? Thanks again.

Hi folks, Running, PHP 7.1.4 Lighttpd/1.4.32 on a small NAS, which is kinda old.... but all I've got as a server ;) I'll try my best to explain my problem... hopefully someone can shed some light on this... Essentially, I've written a "database wrapper" to handle any DB requests (selects, inserts, etc). It's using PDO... At some point in my dbwrapper, I create a wrapperStatement object, passing along by reference, the PDO connection. After creating this wrapperStatement object, I call a function within it that'll do multiple inserts.... On my NAS, this multiInserts() function seems to be cause a 500 http server error. When I tried running the same script, directly on the server's command line with php-cgi, I get a Segmentation Fault. HOWEVER, I've installed PHP and Lighttpd on my working PC, and the code in multiInserts() just works ! class dbwrapper { ... $con = &$this->getConnection(); $dbwrapperStmnt = new wrapperStatement($con) $dbwrapperStmnt->multiInserts(); ... } class wrapperStatement { private $_conn; public function __construct(&$conn){ $this->_conn = &$conn; } public function multiInserts(){ // init data $data = array ( array ( "jdoe1", "jdoe1@email.ca", "abc1"), array ( "jdoe2", "jdoe2@email.ca", "abc2"), array ( "jdoe3", "jdoe3@email.ca", "abc3"), array ( "jdoe4", "jdoe4@email.ca", "abc4"), array ( "jdoe5", "jdoe5@email.ca", "abc5"), ); // init variables $username = null; $email = null; $passwd = null; $sql = "INSERT INTO users (USERNAME, EMAIL, PASSWD) VALUES (:username, :email, :passwd)"; try { $con = new PDO("mysql:dbname=somedb;host=somehost;port=3306", "user", "passwd"); $con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); //$con = $this->_conn; $stmt = $con->prepare($sql); $stmt->bindParam(':username', $username, PDO::PARAM_STR); $stmt->bindParam(':email', $email, PDO::PARAM_STR); $stmt->bindParam(':passwd', $passwd, PDO::PARAM_STR); } catch ( PDOException $ex ) { die($ex->getMessage()); } $errorList = array (); $totalRows = count($data); for ( $row = 0; $row < $totalRows; $row ++ ) { $username = $data[$row][0]; $email = $data[$row][1]; $passwd = $data[$row][2]; try { $con->beginTransaction(); $stmt->execute(); $con->commit(); } catch ( PDOException $ex ) { // HERE!!! // IF USING $this->_conn AS CONNECTION, SEGFAULT IS PRODUCED ON ROLLBACK! if ( $con->inTransaction() ) $con->rollBack(); // just push the error to an array of failed transactions array_push($errorList, array ( $row, $ex->errorInfo[1], $ex->getMessage() )); } } if ( $errorList ) { // print the errors foreach ( $errorList as $error ) { echo "Row #:" . $error[0] . "<br>"; echo "Code :" . $error[1] . "<br>"; echo "Mesg :" . $error[2] . "<br><br>"; } } } } Now, I've pin-pointed the exact line causing the segfault, and it's when I try a rollback() if I got errors (i.e. duplicate username, etc). What I've also found, if running on my NAS, is that if instead of using $this->_conn as my connection object (which I really should!), I create a NEW PDO object and use that one instead, it works, no segfaults!! At first, I thought it might have something to do with passing my $con has reference to my wrapperStatement constructor (perhaps I had done it wrong?), so I checked with var_dump($con)... Before creating my wrapperStatement constructor, inside my dbwrapper... var_dump($con) = object(PDO)#2 (0) { } And after, checking $this->_conn inside multiInserts() : var_dump($this->_conn) = object(PDO)#2 (0) { } So, the #2 tells me it's the same object! (or am I mistaking?). It should be good. I still tried passing the $con object to my statement constructor as a 'copied' value instead of a reference, and problem remains.. changes nothing! So, I'm very confused here as to what could be happening ? As additional info, my original $con object passed to the statement has the following PDO Attributes $pdoAttribs = [ PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC, PDO::ATTR_EMULATE_PREPARES => false, PDO::ATTR_AUTOCOMMIT => false, PDO::ATTR_PERSISTENT => true ]; Also, I do not have the exact same versions of PHP / Lighttpd on my server as on my working PC Server: PHP 7.1.4 Lighttpd/1.4.32 PC: PHP 7.4.3 Lighttpd/1.4.55 But, it's complicated to get the same versions installed everywhere... HOWERVER, I did at least match the configurations for both lighttpd and php configs. Here's a link to my phpinfo() : http://corbeauperdu.ddns.net/phpinfo.php And as for my lighttpd.conf : # Special Configuration file for the DNS-325 # web servers are declared as virtual hosts # include, relative to dirname of main config file include "/etc/lighttpd/lighttpd.conf" # adding extra modules server.modules += ( "mod_redirect" ) server.modules += ( "mod_compress" ) # PRoy: enable compression module server.modules += ( "mod_expire" ) # PRoy: used to set expiry time for cache on clients # add support for new virtual host $HTTP["host"] =~ "(^|\.)myhost.ddns.net$" { server.document-root = "/srv/WWW/html" server.errorlog = "/srv/WWW/logs/error.log" server.error-handler-404 = "/blog/index.php" accesslog.filename = "/srv/WWW/logs/access.log" # files to check for if / is requested index-file.names = ( "index.php", "index.html", "index.htm" ) ########### # PRoy: compress content to DISK as to save CPU-cycles when requesting these file types (otherwise, CPU will compress it all everytime!) compress.allowed-encodings = ("gzip", "deflate") compress.filetype = ("text/plain", "text/html", "text/javascript", "text/css", "text/xml" ) compress.cache-dir = "/srv/WWW/tmp/wwwcache" ########### # PRoy: setup CACHING on clients # make clients think their content is already up-to-date # mod_expire will actually send a Cache-Control / Expires HTTP header on each item it's called upon (css, jpg, or etc) or called URL path # # Cache based on suffix $HTTP["url"] =~ "\.(jpg|gif|png|css|js|eot|svg|ttf|woff|woff2)$" { expire.url = ( "" => "access plus 13 months" ) } # Cache based on path expire.url += ( "/calchom/css/" => "access plus 13 months", "/blog/videos/" => "access plus 13 months", ) # Anything else not caught by mod_expires will be cached on client with these directives setenv.add-response-header += ( # cache for 1 month #"Cache-Control" => "public, max-age=2592000, must-revalidate, proxy-revalidate" # no cache at all! "Cache-Control" => "no-store, no-cache, must-revalidate, proxy-revalidate, max-age=0, post-check=0, pre-check=0" ) ########### cgi.assign = (".cgi" => "") static-file.exclude-extensions = ( ".php", ".pl", ".fcgi", ".cgi" ) flv-streaming.extensions = ( ".flv" ) ########## # PHP Server configuration php-cgi vs php-fpm) # PHP-CGI (2020-02-02 : works good!) # Normally, PHP-FPM should be faster, but not on NAS (?) fastcgi.server = ( ".php" => ("localhost" => ("bin-path" => "/ffp/bin/php-cgi", "socket" => "/tmp/php-cgi.socket", "bin-environment" => ( "PHP_FCGI_CHILDREN" => "0" ), "max-procs" => "1") ) ) ########### server.upload-dirs=( "/srv/WWW/tmp/wwwuploads" ) server.max-request-size = 4194303 server.network-backend="writev" } I know this is a long post, and a long shot.... Hopping to hear back from you folks. Million thanks!! Pat

I just tried changing this setting to '0' and it fixed the issue.... I can't really develop locally, so I'll set this to 0 seconds while I'm developping my project, and change it back to 60 afterwards. Thanks for your help :))

Here's my phpinfo() : http://corbeauperdu.ddns.net/phpinfo.php I tried disabling cache from my browser's dev tools , as you said kicken, but problem remains Additional info, if it applies, I'm running php-cgi and not php-fpm on server because the fpm one seems to work slower for me.... (it's a very old NAS) ... fastcgi.server = ( ".php" => ("localhost" => ("bin-path" => "/ffp/bin/php-cgi", "socket" => "/tmp/php-cgi.socket", "bin-environment" => ( "PHP_FCGI_CHILDREN" => "0" ), "max-procs" => "1") ) ) # also had these instruction in my lighty config... don't (yet) what it's for... server.max-request-size = 65536 server.network-backend="writev" server.use-noatime = "enable"

Hello folks, I'm running PHP Version 7.1.4, on Lighttpd 1.4.32 on my old NAS device (so can't really do PHP /Lighttpd updates). I'm developing this project that uses sessions, but have a really annoying problem where every time I do a change in a PHP file, reloading the page in my browser won't show the change right away, as if it was cached somehow, showing still older version... I have to keep hitting reload in my browser for, let's say ~40 seconds or so, and at some point, it will show my changes. This drives me nuts when trying to troubleshoot a problem! The thing is, it happens only with PHP files. Changes in regular HTML files are reflected right away. I've tried the followings in order to pin-out the problem: cleared my browser's cache completely added the following cache-control directives inside my Lighty server config file: setenv.add-response-header += ("Cache-Control" => "no-store, no-cache, must-revalidate, proxy-revalidate, max-age=0, post-check=0, pre-check=0") set nocache session limiter in php.ini: session.cache_limiter = nocache manually changed the HTTP Headers right from the PHP file: header("Expires: Tue, 03 Jul 2001 06:00:00 GMT", true); header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT", true); header("Cache-Control: no-store, no-cache, must-revalidate, max-age=0, post-check=0, pre-check=0", true); header("Pragma: no-cache", true); header("Connection: close", true); Problem always remains the same. And yes, I did confirm with a HTTP Headers Chrome plugin that the headers were indeed modified on every try that I did above... As of try#4, my headers in my PHP files look like: Content-Language en P3P CP='CURa ADMa DEVa PSAo PSDo OUR BUS UNI PUR INT DEM STA PRE COM NAV OTC NOI DSP COR' Cache-Control no-store, no-cache, must-revalidate, proxy-revalidate, max-age=0, post-check=0, pre-check=0 Cache-Control no-store, no-cache, must-revalidate, max-age=0, post-check=0, pre-check=0 X-Powered-By PHP/7.1.4 Expires Tue, 03 Jul 2001 06:00:00 GMT Last-Modified Sat, 22 Feb 2020 20:18:01 GMT Pragma no-cache Connection close Content-Encoding gzip Vary Accept-Encoding Content-type text/html; charset=UTF-8 Transfer-Encoding chunked Date Sat, 22 Feb 2020 20:18:01 GMT Server lighttpd/1.4.32 Running out of ideas here... Any help would be great! Cheers, Pat