[PHP] Re: [PHP-WIN] 5.3.9RC2 and 5.4RC2
On Mon, Nov 28, 2011 at 1:34 AM, Pierre Joye wrote: > On Mon, Nov 28, 2011 at 5:51 AM, Tommy Pham wrote: > >> Can someone please confirm if you're able to create/drop MySQL >> database on using phpMyAdmin with PHP 5.3.9RC2 or PHP5.4RC2? > > Please use the sqlsrv or mysql functions directly with CREATE/DROP > queries in a little script, it will be easier to debug. > > Cheers, > -- > Pierre > > @pierrejoye | http://blog.thepimp.net | http://www.libgd.org > I don't know what happened last night. After about 2 hours trying to make some progress but failed, I called it a night. I just tried again to see if I had the same problems as last night. Apparently, I don't, even after several attempts to duplicate last night problems. Anyway, I got a few things setup to facilitate troubleshooting the compatibilities, including bug report Doc #60404. Here comes a wall of text from about 5-6 hours of testing, mostly for sqlsrv ... LOL. 5.3.5 5.3.9RC2 5.4.0RC2 error_reporting E_ALL & ~E_DEPRECATED & ~E_STRICT 22527 22527 22527 file_uploads On On On log_errors On On On log_errors_max_len 0 0 0 max_execution_time 300 300 300 max_input_time 60 60 60 memory_limit 128M 128M 128M post_max_size 20M 20M 20M upload_max_filesize 20M 20M 20M Drupal 7.9 + MySQL 5.5-rc >> install OK OK OK Drupal 7.9 + MySQL 5.5-rc >> using1 OK OK OK Drupal 7.9 + SQL Server 10.50.2500 >> install OK Error[3] Error[4] Drupal 7.9 + SQL Server 10.50.2500 >> using1 OK partial[2] partial[2] SQL Server install - Working Set (memory) 186,636K SQL Server install - Private Working Set (memory) 145,760K SQL Server install - Commit Size (memory) 147,736K MySQL install - Working Set (memory) 123,552K MySQL install - Private Working Set (memory) 86,332K MySQL install - Commit Size (memory) 87,648K 1. Create and Edit the short article in the home page in each PHP version. 2. Sometimes generates HTTP Error 500.0 when reading/creating/editing a new article. 3. Always receive HTTP Error 500.0 after creating about 25 tables out of 73 max. 4. SQLSTATE[IMSSP]: An error occurred substituting the named parameters. For 5.3.5 and 5.3.9RC2, sqlsrv driver is the same (ExtensionVer) version 2.0.1802.200 and I have xdebug trace logs of every execution. I didn't bother with the memory comparison for 5.3.9RC2 and 5.4.0RC2 since Drupal 7.9 failed to install for sqlsvr. There error_log file doesn't have any errors prior to and when PHP crashed suddenly, generating the HTTP 500. 5.3.5 has 62 extensions: Core, PDO, PDO_ODBC, Phar, Reflection, SPL, SimpleXML, bcmath, bz2, calendar, cgi-fcgi, com_dotnet, ctype, curl, date, dom, enchant, ereg, exif, filter, ftp, gd, gettext, gmp, hash, iconv, imap, intl, json, ldap, libxml, mbstring, mcrypt, mhash, mysql, mysqli, mysqlnd, odbc, openssl, pcre, pdo_mysql, pdo_pgsql, pdo_sqlsrv, pgsql, session, shmop, soap, sockets, sqlsrv, standard, tidy, tokenizer, wddx, wincache, xdebug, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, zlib 5.3.9RC2 has 63 extensions: Core, PDO, PDO_ODBC, Phar, Reflection, SPL, SimpleXML, bcmath, bz2, calendar, cgi-fcgi, com_dotnet, ctype, curl, date, dom, enchant, ereg, exif, fileinfo, filter, ftp, gd, gettext, gmp, hash, iconv, imap, intl, json, ldap, libxml, mbstring, mcrypt, mhash, mysql, mysqli, mysqlnd, odbc, openssl, pcre, pdo_mysql, pdo_pgsql, pdo_sqlsrv, pgsql, session, shmop, soap, sockets, sqlsrv, standard, tidy, tokenizer, wddx, wincache, xdebug, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, zlib 5.4.0RC2 has 60 extensions: Core, PDO, PDO_ODBC, Phar, Reflection, SPL, SimpleXML, bcmath, bz2, calendar, cgi-fcgi, com_dotnet, ctype, curl, date, dom, ereg, exif, fileinfo, filter, ftp, gd, gettext, gmp, hash, iconv, imap, intl, json, ldap, libxml, mbstring, mcrypt, mhash, mysql, mysqli, mysqlnd, odbc, openssl, pcre, pdo_mysql, pdo_pgsql, pdo_sqlsrv, pgsql, session, shmop, soap, sockets, sqlsrv, standard, tidy, tokenizer, wddx, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, zlib If anyone is interested, here's my code for cleaning the db automatically and reporting PHP version, the database (server & client) version - specifically for Drupal 7.9: function exceptionHandler($e) { echo $e->getMessage(); print_r($e->getTrace()); } set_exception_handler('exception_handler'); $settings = 'sites/default/settings.php'; /** broken - file locking by IIS ** if (isset($_GET['use'])) { //if (!unlink($settings)) //throw new Exception('Error removing old settings'); $source = "sites/default/settings.{$_GET['use']}.php"; switch ($_GET['use']) { case 'mysql': case 'mssql': if (file_exists($source)) copy($source, $settings); //if (!copy(__DIR__.'/sites/default/settings.mysql.php', __DIR__.'/'.$settings)) //throw new Exception('Error copying MySQL settings.'); break; } } */ require_once ($set
[PHP] Re: [PHP-WIN] 5.3.9RC2 and 5.4RC2
On Mon, Nov 28, 2011 at 5:51 AM, Tommy Pham wrote: > Can someone please confirm if you're able to create/drop MySQL > database on using phpMyAdmin with PHP 5.3.9RC2 or PHP5.4RC2? Please use the sqlsrv or mysql functions directly with CREATE/DROP queries in a little script, it will be easier to debug. Cheers, -- Pierre @pierrejoye | http://blog.thepimp.net | http://www.libgd.org -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: [PHP-WIN] 5.3.9RC2 and 5.4RC2
On Sun, Nov 27, 2011 at 7:32 AM, Pierre Joye wrote: > hi, > > I just uploaded two zip for sqlsrv and 5.4. I did not test them and > they are no official builds, only for testing purposes (so is 5.4 :). > > you can find them at http://www.php.net/~pierre/ > > Cheers, > Hi Pierre, I really appreciate your help with the sqlsrv build. It seems that I'm having problems test installing Drupal 7 with it. So I tried test installing on MySQL instead to see if the driver is the issue. Apparently that fails also. Then I went to pull up phpMyAdmin v3.4.7 to do some create/drop databases. Nothing works and no errors reported. Using PHP Manager for IIS, I tested 3 configurations that I have: 5.3.5 nts 5.3.9RC2 nts 5.4RC2 nts The only PHP version that would create/drop MySQL database via phpMyAdmin is 5.3.5 nts :( Platform is Win08R2/IIS7.5 SP1 with all current patches. MySQL is 5.5.7-rc (official binary). Can someone please confirm if you're able to create/drop MySQL database on using phpMyAdmin with PHP 5.3.9RC2 or PHP5.4RC2? phpMyAdmin reports MySQL client driver version: 5.3.9RC2 as mysqlnd 5.0.8-dev - 20102224 - $Revision: 318113 $ 5.4RC2 as mysqlnd 5.0.10-dev - 20111026 - $Revision: 318612 $ Thanks again, Tommy -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] RE: [PHP-WIN] 5.3.9RC2 and 5.4RC2
Well, she is new to Wincache at least: Jenny Lawrence http://forums.iis.net/t/1174639.aspx Keith Davis (214) 906-5183 -Original Message- From: Pierre Joye [mailto:pierre@gmail.com] Sent: Sunday, November 27, 2011 6:20 PM To: Keith Davis Cc: Tommy Pham; php-general@lists.php.net; php-wind...@lists.php.net Subject: Re: [PHP-WIN] 5.3.9RC2 and 5.4RC2 On Mon, Nov 28, 2011 at 1:07 AM, Keith Davis wrote: > Thanks Pierre! And thanks Tommy for bringing that up. I've been discussing > the Wincache issue for some time and also brought it up with the new MS > person assigned to it, but I had completely forgot to check sqlsrv and that > would have been a big problem for us. The new person? I did not hear of a new switch lately (there was one earlier this year but then not). Cheers, > > Keith Davis (214) 906-5183 > > > -Original Message- > From: Pierre Joye [mailto:pierre@gmail.com] > Sent: Sunday, November 27, 2011 9:33 AM > To: Tommy Pham > Cc: php-general@lists.php.net; php-wind...@lists.php.net > Subject: Re: [PHP-WIN] 5.3.9RC2 and 5.4RC2 > > hi, > > I just uploaded two zip for sqlsrv and 5.4. I did not test them and they are > no official builds, only for testing purposes (so is 5.4 :). > > you can find them at http://www.php.net/~pierre/ > > Cheers, > > On Sat, Nov 26, 2011 at 9:43 AM, Tommy Pham wrote: >> Hi everyone, >> >> 5.3.9RC2 works fine with all my apps so far. 5.4RC2 broke with >> sqlsvr and its PDO in addition to Wincache, which I've already brought to MS' >> attention. What's the estimated official release of 5.4? I can't >> wait for the feature session.upload_progress* in 5.4 which I need to >> do some testing as how I can implement that into my existing apps!!! >> That's just awesome!! Thanks for all your continuous hard work :) >> >> Platform: Win08R2/IIS7.5 SP1 with current patches running PHP as FastCGI. >> >> Applications: >> drupal, joomla, mediawiki, wordpress, and a few of my own :) >> >> Cheers, >> Tommy >> >> -- >> PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: >> http://www.php.net/unsub.php >> >> > > > > -- > Pierre > > @pierrejoye | http://blog.thepimp.net | http://www.libgd.org > > -- > PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: > http://www.php.net/unsub.php > > > > This message (including any attachments) may contain confidential or > otherwise privileged information and is intended only for the individual(s) > to which it is addressed. If you are not the named addressee you should not > disseminate, distribute or copy this e-mail. Please notify the sender > immediately by e-mail if you have received this e-mail by mistake and delete > this e-mail from your system. E-mail transmission cannot be guaranteed to be > secured or error-free as information could be intercepted, corrupted, lost, > destroyed, arrive late or incomplete, or contain viruses. The sender > therefore does not accept liability for any errors or omissions in the > contents of this message or that arise as a result of e-mail transmission. If > verification is required please request a hard-copy version from the sender. > > www.pridedallas.com > > -- Pierre @pierrejoye | http://blog.thepimp.net | http://www.libgd.org -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: [PHP-WIN] 5.3.9RC2 and 5.4RC2
On Mon, Nov 28, 2011 at 1:07 AM, Keith Davis wrote: > Thanks Pierre! And thanks Tommy for bringing that up. I've been discussing > the Wincache issue for some time and also brought it up with the new MS > person assigned to it, but I had completely forgot to check sqlsrv and that > would have been a big problem for us. The new person? I did not hear of a new switch lately (there was one earlier this year but then not). Cheers, > > Keith Davis (214) 906-5183 > > > -Original Message- > From: Pierre Joye [mailto:pierre@gmail.com] > Sent: Sunday, November 27, 2011 9:33 AM > To: Tommy Pham > Cc: php-general@lists.php.net; php-wind...@lists.php.net > Subject: Re: [PHP-WIN] 5.3.9RC2 and 5.4RC2 > > hi, > > I just uploaded two zip for sqlsrv and 5.4. I did not test them and they are > no official builds, only for testing purposes (so is 5.4 :). > > you can find them at http://www.php.net/~pierre/ > > Cheers, > > On Sat, Nov 26, 2011 at 9:43 AM, Tommy Pham wrote: >> Hi everyone, >> >> 5.3.9RC2 works fine with all my apps so far. 5.4RC2 broke with sqlsvr >> and its PDO in addition to Wincache, which I've already brought to MS' >> attention. What's the estimated official release of 5.4? I can't >> wait for the feature session.upload_progress* in 5.4 which I need to >> do some testing as how I can implement that into my existing apps!!! >> That's just awesome!! Thanks for all your continuous hard work :) >> >> Platform: Win08R2/IIS7.5 SP1 with current patches running PHP as FastCGI. >> >> Applications: >> drupal, joomla, mediawiki, wordpress, and a few of my own :) >> >> Cheers, >> Tommy >> >> -- >> PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: >> http://www.php.net/unsub.php >> >> > > > > -- > Pierre > > @pierrejoye | http://blog.thepimp.net | http://www.libgd.org > > -- > PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: > http://www.php.net/unsub.php > > > > This message (including any attachments) may contain confidential or > otherwise privileged information and is intended only for the individual(s) > to which it is addressed. If you are not the named addressee you should not > disseminate, distribute or copy this e-mail. Please notify the sender > immediately by e-mail if you have received this e-mail by mistake and delete > this e-mail from your system. E-mail transmission cannot be guaranteed to be > secured or error-free as information could be intercepted, corrupted, lost, > destroyed, arrive late or incomplete, or contain viruses. The sender > therefore does not accept liability for any errors or omissions in the > contents of this message or that arise as a result of e-mail transmission. If > verification is required please request a hard-copy version from the sender. > > www.pridedallas.com > > -- Pierre @pierrejoye | http://blog.thepimp.net | http://www.libgd.org -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] RE: [PHP-WIN] 5.3.9RC2 and 5.4RC2
Thanks Pierre! And thanks Tommy for bringing that up. I've been discussing the Wincache issue for some time and also brought it up with the new MS person assigned to it, but I had completely forgot to check sqlsrv and that would have been a big problem for us. Keith Davis (214) 906-5183 -Original Message- From: Pierre Joye [mailto:pierre@gmail.com] Sent: Sunday, November 27, 2011 9:33 AM To: Tommy Pham Cc: php-general@lists.php.net; php-wind...@lists.php.net Subject: Re: [PHP-WIN] 5.3.9RC2 and 5.4RC2 hi, I just uploaded two zip for sqlsrv and 5.4. I did not test them and they are no official builds, only for testing purposes (so is 5.4 :). you can find them at http://www.php.net/~pierre/ Cheers, On Sat, Nov 26, 2011 at 9:43 AM, Tommy Pham wrote: > Hi everyone, > > 5.3.9RC2 works fine with all my apps so far. 5.4RC2 broke with sqlsvr > and its PDO in addition to Wincache, which I've already brought to MS' > attention. What's the estimated official release of 5.4? I can't > wait for the feature session.upload_progress* in 5.4 which I need to > do some testing as how I can implement that into my existing apps!!! > That's just awesome!! Thanks for all your continuous hard work :) > > Platform: Win08R2/IIS7.5 SP1 with current patches running PHP as FastCGI. > > Applications: > drupal, joomla, mediawiki, wordpress, and a few of my own :) > > Cheers, > Tommy > > -- > PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: > http://www.php.net/unsub.php > > -- Pierre @pierrejoye | http://blog.thepimp.net | http://www.libgd.org -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php This message (including any attachments) may contain confidential or otherwise privileged information and is intended only for the individual(s) to which it is addressed. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secured or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message or that arise as a result of e-mail transmission. If verification is required please request a hard-copy version from the sender. www.pridedallas.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: [PHP-WIN] 5.3.9RC2 and 5.4RC2
hi, I just uploaded two zip for sqlsrv and 5.4. I did not test them and they are no official builds, only for testing purposes (so is 5.4 :). you can find them at http://www.php.net/~pierre/ Cheers, On Sat, Nov 26, 2011 at 9:43 AM, Tommy Pham wrote: > Hi everyone, > > 5.3.9RC2 works fine with all my apps so far. 5.4RC2 broke with sqlsvr > and its PDO in addition to Wincache, which I've already brought to MS' > attention. What's the estimated official release of 5.4? I can't > wait for the feature session.upload_progress* in 5.4 which I need to > do some testing as how I can implement that into my existing apps!!! > That's just awesome!! Thanks for all your continuous hard work :) > > Platform: Win08R2/IIS7.5 SP1 with current patches running PHP as FastCGI. > > Applications: > drupal, joomla, mediawiki, wordpress, and a few of my own :) > > Cheers, > Tommy > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- Pierre @pierrejoye | http://blog.thepimp.net | http://www.libgd.org -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: [PHP-WIN] 5.3.9RC2 and 5.4RC2
On Sun, Nov 27, 2011 at 2:39 PM, Pierre Joye wrote: > hi, > > On Sat, Nov 26, 2011 at 9:43 AM, Tommy Pham wrote: > > Hi everyone, > > > > 5.3.9RC2 works fine with all my apps so far. 5.4RC2 broke with sqlsvr > > and its PDO in addition to Wincache, which I've already brought to MS' > > attention. > > Please report a bug at http://pecl.php.net/package/sqlsrv > http://pecl.php.net/package/wincache. > > however I do not see what could be broken with 5.3.9, there is no > change that could affect these extensions. I think that he meant that only 5.4 is affected by those problems. -- Ferenc Kovács @Tyr43l - http://tyrael.hu
[PHP] Re: [PHP-WIN] 5.3.9RC2 and 5.4RC2
hi, On Sat, Nov 26, 2011 at 9:43 AM, Tommy Pham wrote: > Hi everyone, > > 5.3.9RC2 works fine with all my apps so far. 5.4RC2 broke with sqlsvr > and its PDO in addition to Wincache, which I've already brought to MS' > attention. Please report a bug at http://pecl.php.net/package/sqlsrv http://pecl.php.net/package/wincache. however I do not see what could be broken with 5.3.9, there is no change that could affect these extensions. > What's the estimated official release of 5.4? See https://wiki.php.net/todo/php54 There is no deadline for the final release as we do not know yet all possible issues we may find during the RCs phase. Cheers, -- Pierre @pierrejoye | http://blog.thepimp.net | http://www.libgd.org -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php