[PHP-DEV] PHP 4.0 Bug #10223: Not allows to retrive text column from DB
From: [EMAIL PROTECTED]
Operating system: WIN NT
PHP version: 4.0.4pl1
PHP Bug Type: ODBC related
Bug description: Not allows to retrive text column from DB
$cur=odbc_exec($conn,"myProcedure $id");
if(!$cur) {
/* error handler */
}
odbc_binmode($cur, ODBC_BINMODE_PASSTHRU);
odbc_longreadlen($cur, 24568); /* Allow 24kb thru */
while(odbc_fetch_row($cur)){
$lyrics = odbc_result($cur,1);
/* this is place where I get this line:
SQL error: [Microsoft][ODBC SQL Server Driver]Invalid Descriptor Index, SQL state
S1002 in SQLGetData in... */
--
Edit Bug report at: http://bugs.php.net/?id=10223edit=1
--
PHP Development Mailing List http://www.php.net/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DEV] [PATCH] DB_DataObject and DB_DataObject_Generator
Hi,
Here's a small patch for the DataObject classes. The rationale is as
follows. I'm using multiple databases with the same schema, and this
schema is enforced so there are no differences. I'd like to use the same
static options array for DataObject, except for DSN, and the same table
definitions. So, I define option database_genericname =
?://?:?@?/specific_name, so that `genericname' is always the same, and
`specific_name' is the actual name of the database that I need to
access. I'm building options array on the fly instead of initializing it
from ini file. Also, my tables settings are stored in `genericname.ini'
rather than in `specificname.ini'.
For this purpose, as well as for Generator methods to generate
everything for `genericname' as opposed to the `specificname', I'd like
to preserve the value of DataObject::_database property if it's set.
It's always possible to access the real database name using a connection
object and _database_dsn_md5 property, and _dsn property is available
for DSN storage, so I'd like _database property to reflect the name
given in options, as defined at
http://pear.php.net/manual/en/packages.database.db-dataobject.configuration.php
in the section regarding database_* and table_* options.
The only patching that's required is in the _connect method, very much
inline with the rest of code IMHO. The patch also contains a tiny fix
for Generator accessing the `extends' property that doesn't exist (it's
optional so the call is valid).
Thank you!
Sergey Lipnevich,
Source Mage GNU/Linux maintainer for `collab' section,
http://www.sourcemage.org/.
--- DataObject.php-original 2002-12-03 17:51:07.0 -0500
+++ DataObject.php 2002-12-03 18:09:45.0 -0500
@@ -946,7 +946,8 @@
);
return;
}
-$this-_database =
$connections[$this-_database_dsn_md5]-dsn[database];
+if (!$this-_database)
+$this-_database =
+$connections[$this-_database_dsn_md5]-dsn[database];
return;
}
@@ -954,8 +955,10 @@
$dsn = @$this-_database_dsn;
if (!$dsn) {
-if ($database = @$options[table_{$this-__table}]) {
-$dsn = $options[database_{$database}];
+if (!$this-_database)
+$this-_database = @$options[table_{$this-__table}];
+if (@$this-_database) {
+$dsn = $options[database_{$this-_database}];
} else if ($options['database']) {
$dsn = $options['database'];
}
@@ -966,7 +969,8 @@
if (!$GLOBALS['_DB_DATAOBJECT_PRODUCTION']) {
$this-debug(USING CACHE, CONNECT,3);
}
-$this-_database =
$connections[$this-_database_dsn_md5]-dsn[database];
+if (!$this-_database)
+$this-_database =
+$connections[$this-_database_dsn_md5]-dsn[database];
return;
}
if (!$GLOBALS['_DB_DATAOBJECT_PRODUCTION']) {
@@ -987,7 +991,8 @@
}
-$this-_database = $connections[$this-_database_dsn_md5]-dsn[database];
+if (!$this-_database)
+$this-_database =
+$connections[$this-_database_dsn_md5]-dsn[database];
return TRUE;
}
/**
--- DataObject/Generator.php-original 2002-12-03 18:07:29.0 -0500
+++ DataObject/Generator.php2002-12-03 18:06:07.0 -0500
@@ -270,7 +270,7 @@
if (!file_exists($base))
mkdir($base,0755);
$class_prefix = $options['class_prefix'];
-if ($extends = $options['extends']) {
+if ($extends = @$options['extends']) {
$this-_extends = $extends;
$this-_extendsFile = $options['extends_location'];
}
--
PHP Development Mailing List http://www.php.net/
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DEV] Re: [PATCH] DB_DataObject and DB_DataObject_Generator
Please disregard, wrong group :-(...
Sergey wrote:
Hi,
Here's a small patch for the DataObject classes. The rationale is as
follows. I'm using multiple databases with the same schema, and this
schema is enforced so there are no differences. I'd like to use the same
static options array for DataObject, except for DSN, and the same table
definitions. So, I define option database_genericname =
?://?:?@?/specific_name, so that `genericname' is always the same, and
`specific_name' is the actual name of the database that I need to
access. I'm building options array on the fly instead of initializing it
from ini file. Also, my tables settings are stored in `genericname.ini'
rather than in `specificname.ini'.
For this purpose, as well as for Generator methods to generate
everything for `genericname' as opposed to the `specificname', I'd like
to preserve the value of DataObject::_database property if it's set.
It's always possible to access the real database name using a connection
object and _database_dsn_md5 property, and _dsn property is available
for DSN storage, so I'd like _database property to reflect the name
given in options, as defined at
http://pear.php.net/manual/en/packages.database.db-dataobject.configuration.php
in the section regarding database_* and table_* options.
The only patching that's required is in the _connect method, very much
inline with the rest of code IMHO. The patch also contains a tiny fix
for Generator accessing the `extends' property that doesn't exist (it's
optional so the call is valid).
Thank you!
Sergey Lipnevich,
Source Mage GNU/Linux maintainer for `collab' section,
http://www.sourcemage.org/.
--- DataObject.php-original 2002-12-03 17:51:07.0 -0500
+++ DataObject.php 2002-12-03 18:09:45.0 -0500
@@ -946,7 +946,8 @@
);
return;
}
-$this-_database = $connections[$this-_database_dsn_md5]-dsn[database];
+if (!$this-_database)
+$this-_database = $connections[$this-_database_dsn_md5]-dsn[database];
return;
}
@@ -954,8 +955,10 @@
$dsn = @$this-_database_dsn;
if (!$dsn) {
-if ($database = @$options[table_{$this-__table}]) {
-$dsn = $options[database_{$database}];
+if (!$this-_database)
+$this-_database = @$options[table_{$this-__table}];
+if (@$this-_database) {
+$dsn = $options[database_{$this-_database}];
} else if ($options['database']) {
$dsn = $options['database'];
}
@@ -966,7 +969,8 @@
if (!$GLOBALS['_DB_DATAOBJECT_PRODUCTION']) {
$this-debug(USING CACHE, CONNECT,3);
}
-$this-_database = $connections[$this-_database_dsn_md5]-dsn[database];
+if (!$this-_database)
+$this-_database = $connections[$this-_database_dsn_md5]-dsn[database];
return;
}
if (!$GLOBALS['_DB_DATAOBJECT_PRODUCTION']) {
@@ -987,7 +991,8 @@
}
-$this-_database = $connections[$this-_database_dsn_md5]-dsn[database];
+if (!$this-_database)
+$this-_database = $connections[$this-_database_dsn_md5]-dsn[database];
return TRUE;
}
/**
--- DataObject/Generator.php-original 2002-12-03 18:07:29.0 -0500
+++ DataObject/Generator.php 2002-12-03 18:06:07.0 -0500
@@ -270,7 +270,7 @@
if (!file_exists($base))
mkdir($base,0755);
$class_prefix = $options['class_prefix'];
-if ($extends = $options['extends']) {
+if ($extends = @$options['extends']) {
$this-_extends = $extends;
$this-_extendsFile = $options['extends_location'];
}
--
PHP Development Mailing List http://www.php.net/
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DEV] Time for 4.0.5?
On Mon, 19 Feb 2001, Derick Rethans wrote: On Mon, 19 Feb 2001, Sascha Schumann wrote: what do people think about a PHP 4.0.5 release? Let me know your thoughts. Sounds like a good idea, but I would like to fix the bugs in the mcrypt extension before this release. What about making March 1, 2001 making the day for RC 1? I need some time too (one or two weeks) to finish mnoGoSearch extension to support all of features of mnoGoSearch - 3.1.10. It seems to me that March 1 is the resonable date for RC1 8) -- Regards. Sergey aka gluke. -- PHP Development Mailing List http://www.php.net/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DEV] news.php.net search
Hi! Can anybody give me more information regarding search at news.php.net ? Who is author of it ? Does it use php mnoGoSearch extension ? Thank you. -- Regards. Sergey aka gluke. -- PHP Development Mailing List http://www.php.net/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DEV] Bug #11780: udm_find makes php crash
On 28 Jun 2001 [EMAIL PROTECTED] wrote: From: [EMAIL PROTECTED] Operating system: Linux PHP version: 4.0.6 PHP Bug Type: Unknown/Other Function Bug description: udm_find makes php crash Important notice: It seems to crash ONLY when the word belongs the dictionary (dict table). (This seems to prove that the udm_agent is well-defined) Try to recompile mnogosearch without threads, then recompile php. Please give me feedback if it helps. Thank you. -- PHP Development Mailing List http://www.php.net/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DEV] Bug System
Hi! Please tell me: can i install php bug tracking system on my server ? Can i download it an use it ? Is it free ? -- Regards. Sergey aka gluke. -- PHP Development Mailing List http://www.php.net/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DEV] CVS account email change
Hi! My primary email address has been changed from [EMAIL PROTECTED] to [EMAIL PROTECTED] Please update my cvs account (gluke). Thank you. -- Regards. Sergey aka gluke. -- PHP Development Mailing List http://www.php.net/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DEV] CVS question
Hi! Can anybody help me with some question ? I making mnogosearch extension module. Currently my cvs session look like this: cvs up editing cvs ci So i always work with development versions of PHP. The question is: How can i update module for upcoming 4.1.0 release to make sure that 4.1.0 contains all important changes ? -- Regards. Sergey aka gluke. -- PHP Development Mailing List http://www.php.net/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DEV] PHP cvs help
Hi! Please help me with some CVS question. I need to migrate latest mngosearch extension from php-4.2dev branch into php-4.1.x branch. To do that i run: cvs update -r php_4_1_1 ... update mnogosearch files... ... remove test.php ... cvs remove test.php ... adding index.php ... cvs commit Here is i got an error: ? ext/mnogosearch/index.php cvs server: sticky tag `php_4_1_1' for file `ext/mnogosearch/config.m4' is not a branch cvs server: sticky tag `php_4_1_1' for file `ext/mnogosearch/php_mnogo.c' is not a branch cvs server: sticky tag `php_4_1_1' for file `ext/mnogosearch/php_mnogo.h' is not a branch Can't open test.php: No such file or directory cvs [server aborted]: correct above errors first! cvs commit: saving log message in /tmp/cvs7j5zFJ Can anyone help me what i am doing wrong ? Another error i get while trying to add a new file index.php: cvs add index.php [gluke@faust mnogosearch]$ cvs add index.php cvs server: cannot add file on non-branch tag php_4_1_1 What wtong here ? Please help ! -- Regards, Sergey aka gluke. -- PHP Development Mailing List http://www.php.net/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DEV] PHP cvs help
On Sun, 23 Dec 2001 [EMAIL PROTECTED] wrote: I need to migrate latest mngosearch extension from php-4.2dev branch into php-4.1.x branch. Please do not MFH before discussing it, merging to the 4.1 branch is only needed for important bugfixes, and not for simply updating the extension. Ok. Lets discuss it. It is very pity that PHP-4.1.0 was released with old mnogosearch extension module. It does not support a new mnogosearch-3.2.x branch. So i have really many questions from users. They cannot compile php-4.1.0 with mnogosearch-3.2.x. So i want to update mnogosearch module to make sure that next upcoming PHP release (4.1.1 ?) will come with updated extension. Can i update it ? To do that i run: cvs update -r php_4_1_1 the php_4_1_1 is the release tag, you should never touch those. The working branch is PHP_4_0_7. Thank you. I will try once more with this branch. -- Regards. Sergey aka gluke. -- PHP Development Mailing List http://www.php.net/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DEV] PHP cvs help
On Tue, 25 Dec 2001 [EMAIL PROTECTED] wrote: So i want to update mnogosearch module to make sure that next upcoming PHP release (4.1.1 ?) will come with updated extension. Can i update it ? It's too late anyway, as 4.1.1 is already packaged, and going to be released tomorrow. If new functionality is added, we need a whole new cycle of release candidates. ok. Then i will wait and update module after 4.1.1 will be released. Will the working branch tag (PHP_4_0_7) remain for PHP 4.1.x ? -- Regards. Sergey aka gluke. -- PHP Development Mailing List http://www.php.net/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DEV] PHP cvs help
On Tue, 25 Dec 2001 [EMAIL PROTECTED] wrote: ok. Then i will wait and update module after 4.1.1 will be released. Will the working branch tag (PHP_4_0_7) remain for PHP 4.1.x ? Yes, but you really should not new functionality (support for new versions) into an old branch. Even for 4.1.2+ versions ? I undestood you as i should not update module for upcoming 4.1.1 release, but i can update it for next 4.1.2+ versions before next release cycle will begin. Am i wrong ? We actiually do intensive new module testing and i think its very stable enough to call it 'release version'. So i ask you permission to update module in PHP-4.1.2+ -- Regards. Sergey aka gluke. -- PHP Development Mailing List http://www.php.net/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DEV] CVS account request
Hello, I want to contribute some functions to openssl and sockets extantions, like SSL/TSL support for internet connections. I've made some patches for 4.2.3 - you can see it on my homepage: www.sergey-smitienko.com.ua/files/. -- The Emperor wants to control the outer space, Yoda wants to explore the inner space.That's the fundamental difference between the good and the bad sides of the Force. -- PHP Development Mailing List http://www.php.net/ To unsubscribe, visit: http://www.php.net/unsub.php
