[PHP-DEV] PHP 4.0 Bug #6091 Updated: Work with 2 or more IBase DB cause segmentation fault From: cynic <email protected>
Date: 03/31/01

ID: 6091
Updated by: cynic
Reported By: pasha <email protected>
Old-Status: Open
Status: Feedback
Bug Type: InterBase related
Assigned To:
Comments:

do you still experience this error?

Previous Comments:
---------------------------------------------------------------------------

[2000-11-01 11:09:12] sniper <email protected>
reclassified

---------------------------------------------------------------------------

[2000-08-31 09:04:11] stas <email protected>
reclassify (in fact, we should have bug type for each extension, anyone?)

---------------------------------------------------------------------------

[2000-08-10 22:24:37] pasha <email protected>
If remove comment and try to work with both of databases
in same time, this cause segmentation fault with creation
core dump

In php 3.015 all work good

<?php
  require '$DBZAKAZ$.inc';
// $DB_ZAKAZ = ibase_connect($DB_ZAKAZ_PATH, $USERNAME, $PASSWORD);
  $DB_MAILBOX = ibase_connect($DB_MAILBOX_PATH, $USERNAME, $PASSWORD);

  $Insert_ML = ibase_prepare($DB_MAILBOX, "insert into MAILS_LIST
    values (?, ?, ?, ?, ?, NULL, NULL, 0, ?)");
  $Insert_MB = ibase_prepare($DB_MAILBOX, "insert into MAILS_BODY
    values (?, ?)");
// $Update_ZS = ibase_prepare($DB_ZAKAZ, "update ZAKAZ_FOR_NEW
// set SENDET="T" where ID=?");
  $SQL_MB_NEW_NO = ibase_prepare($DB_MAILBOX,
    "select * from GET_NO_NEW_MAILS_BODY");
  $SQL_ML_NEW_NO = ibase_prepare($DB_MAILBOX,
    "select * from GET_NO_NEW_MAILS_LIST");
// $SQL_Phone = ibase_prepare($DB_ZAKAZ,
// "select * from PHONE_FOR_NEW_ZAKAZ where ZAKAZ_ID=?");
// $SQL_PhoneRecordCount = ibase_prepare($DB_ZAKAZ,
// "select count(*) from PHONE_FOR_NEW_ZAKAZ where ZAKAZ_ID=?");
// $SQL_Option = ibase_prepare($DB_ZAKAZ,
// "select * from OPTIONS_FOR_ZAKAZ_NEW_VIEW where ZAKAZ_ID=?");
// $SQL_OptionRecordCount = ibase_prepare($DB_ZAKAZ,
// "select count(*) from OPTIONS_FOR_ZAKAZ_NEW_VIEW where ZAKAZ_ID=?");
// $SQL_Fillial = ibase_prepare($DB_ZAKAZ,
// "select * from fillials_list where (ZAKAZ='t' or ZAKAZ='T')
// and E_MAIL is not null and id in (select parrent_fillial
// from marki_for_zakaz where marka=?)");
// $SQL_FillialRecordCount = ibase_prepare($DB_ZAKAZ,
// "select count(*) from fillials_list where (ZAKAZ='t' or ZAKAZ='T')
// and E_MAIL is not null and id in (select parrent_fillial
// from marki_for_zakaz where marka=?)");

// Work with Data
// Free Queries
  ibase_free_query($Insert_ML);
  ibase_free_query($Insert_MB);
// ibase_free_query($Update_ZS);
  ibase_free_query($SQL_MB_NEW_NO);
  ibase_free_query($SQL_ML_NEW_NO);
// ibase_free_query($SQL_Phone);
// ibase_free_query($SQL_PhoneRecordCount);
// ibase_free_query($SQL_Option);
// ibase_free_query($SQL_OptionRecordCount);
// ibase_free_query($SQL_Fillial);
// ibase_free_query($SQL_FillialRecordCount);

// ibase_close($DB_ZAKAZ);
  ibase_close($DB_MAILBOX);
  echo "<B>Ok!!!</B>";
?>

---------------------------------------------------------------------------

ATTENTION! Do NOT reply to this email!
To reply, use the web interface found at http://bugs.php.net/?id=6091&edit=2 

-- 
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: php-dev-unsubscribe <email protected>
For additional commands, e-mail: php-dev-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>