php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #6091 Work with 2 or more IBase DB cause segmentation fault
Submitted: 2000-08-10 22:24 UTC Modified: 2001-04-28 15:32 UTC
From: pasha at autospravka dot com dot ua Assigned:
Status: Closed Package: InterBase related
PHP Version: 4.0.0 OS: FreeBSD 4.0 Release
Private report: No CVE-ID: None
 [2000-08-10 22:24 UTC] pasha at autospravka dot com dot ua
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>";
?>

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2000-08-31 09:04 UTC] stas@php.net
reclassify (in fact, we should have bug type for each extension, anyone?)
 [2000-11-01 11:09 UTC] sniper@php.net
reclassified
 [2001-03-31 11:19 UTC] cynic@php.net
do you still experience this error?
 [2001-04-28 15:32 UTC] derick@php.net
No feedback. If this problem persists with PHP 4.0.5 which
will be released next week, please reopen this report.

Derick
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Mon Dec 30 14:01:28 2024 UTC