RE: [PHP] Out of memory error message
Guys, I've finally been able to solve this problem. See: http://franklin.oit.unc.edu/cgi-bin/lyris.pl?visit=freetdsid=178084891. The problem was being caused by http://www.freetds.org/faq.html#textdata. I solved it by modifying my SQL statement like so: $sql = SET TEXTSIZE 2048 SELECT Item.ItemNumber,Item.Description,Item.Type,Item.Comments,Inventory.Site,Inve ntory.Location,Inventory.ItemNumber,Inventory.SerialNumber,Inventory.Lot,Inv entory.OnHandQuantity FROM Item,Inventory WHERE (Item.ItemNumber='$ViewItemNumber' AND Item.ItemNumber=Inventory.ItemNumber); So far, it appears to be working! No problems yet that I can see! Just wanted to share! O From Now 'Till Then, \-Reginald Alex Mullin /\ 212-894-1690 -Original Message- From: Mullin, Reginald Sent: Monday, April 22, 2002 10:30 AM To: 'Chris Hewitt' Cc: [EMAIL PROTECTED] Subject: RE: [PHP] Out of memory error message Chris, Thanks for your feedback. Note: The ItemNumber is the Primary key for the Item table and the Foreign key for the Inventory table. Also, I'm only selecting a limited number of fields in the MSSQL query string. P.S.: If it were a PHP/MSSQL error, shouldn't the browser spit out an error message as well? O From Now 'Till Then, \-Reginald Alex Mullin /\ 212-894-1690 -Original Message- From: Chris Hewitt [SMTP:[EMAIL PROTECTED]] Sent: Saturday, April 20, 2002 7:10 AM To: Mullin, Reginald Subject:Re: [PHP] Out of memory error message Reginald, I assume both the Item and Inventory tables have an index on ItemNumber? If not then a full table scan would want lots of memory and time if the tables contain a large number of rows. Just a thought. HTH Chris Mullin, Reginald wrote: Hi Guys, Does anyone know what the following error message is and how I can go about solving it? ***ERROR MSG*** Out of memory during large request for 2147487744 bytes, total sbrk() is 1459608 bytes. This error message gets written to Apache's error logs every other time I execute my MSSQL query. The web browser then displays The page cannot be displayed error (404). ***SAMPLE MSSQL QUERY*** if ($ViewItemNumber){ $ViewItemNumber = urldecode($ViewItemNumber); $sql = SELECT Item.ItemNumber,Item.Description,Item.Type,Item.Comments,Inventory.Site,I nve ntory.Location,Inventory.ItemNumber,Inventory.SerialNumber,Inventory.Lot, Inv entory.OnHandQuantity FROM Item,Inventory WHERE (Item.ItemNumber='$ViewItemNumber' AND Item.ItemNumber=Inventory.ItemNumber); $query = mssql_query($sql) or die (THE SECOND (2) TABLE SELECTION FAILED.); $results = mssql_fetch_array($query); echo $results['ItemNumber']; } Note: I'm running LAMP locally (NY) and connecting remotely to a Windows 2000 box running MS SQL Server 2000 (UK) with the FreeTDS package. O From Now 'Till Then, \-Reginald Alex Mullin /\ 212-894-1690 ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the postmaster at [EMAIL PROTECTED] www.sothebys.com ** ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the postmaster at [EMAIL PROTECTED] www.sothebys.com ** -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Out of memory error message
Chris, Thanks for your feedback. Note: The ItemNumber is the Primary key for the Item table and the Foreign key for the Inventory table. Also, I'm only selecting a limited number of fields in the MSSQL query string. P.S.: If it were a PHP/MSSQL error, shouldn't the browser spit out an error message as well? O From Now 'Till Then, \-Reginald Alex Mullin /\ 212-894-1690 -Original Message- From: Chris Hewitt [SMTP:[EMAIL PROTECTED]] Sent: Saturday, April 20, 2002 7:10 AM To: Mullin, Reginald Subject: Re: [PHP] Out of memory error message Reginald, I assume both the Item and Inventory tables have an index on ItemNumber? If not then a full table scan would want lots of memory and time if the tables contain a large number of rows. Just a thought. HTH Chris Mullin, Reginald wrote: Hi Guys, Does anyone know what the following error message is and how I can go about solving it? ***ERROR MSG*** Out of memory during large request for 2147487744 bytes, total sbrk() is 1459608 bytes. This error message gets written to Apache's error logs every other time I execute my MSSQL query. The web browser then displays The page cannot be displayed error (404). ***SAMPLE MSSQL QUERY*** if ($ViewItemNumber){ $ViewItemNumber = urldecode($ViewItemNumber); $sql = SELECT Item.ItemNumber,Item.Description,Item.Type,Item.Comments,Inventory.Site,I nve ntory.Location,Inventory.ItemNumber,Inventory.SerialNumber,Inventory.Lot, Inv entory.OnHandQuantity FROM Item,Inventory WHERE (Item.ItemNumber='$ViewItemNumber' AND Item.ItemNumber=Inventory.ItemNumber); $query = mssql_query($sql) or die (THE SECOND (2) TABLE SELECTION FAILED.); $results = mssql_fetch_array($query); echo $results['ItemNumber']; } Note: I'm running LAMP locally (NY) and connecting remotely to a Windows 2000 box running MS SQL Server 2000 (UK) with the FreeTDS package. O From Now 'Till Then, \-Reginald Alex Mullin /\ 212-894-1690 ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the postmaster at [EMAIL PROTECTED] www.sothebys.com ** ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the postmaster at [EMAIL PROTECTED] www.sothebys.com ** -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Out of memory error message
Hi Guys, Does anyone know what the following error message is and how I can go about solving it? ***ERROR MSG*** Out of memory during large request for 2147487744 bytes, total sbrk() is 1459608 bytes. This error message gets written to Apache's error logs every other time I execute my MSSQL query. The web browser then displays The page cannot be displayed error (404). ***SAMPLE MSSQL QUERY*** if ($ViewItemNumber){ $ViewItemNumber = urldecode($ViewItemNumber); $sql = SELECT Item.ItemNumber,Item.Description,Item.Type,Item.Comments,Inventory.Site,Inve ntory.Location,Inventory.ItemNumber,Inventory.SerialNumber,Inventory.Lot,Inv entory.OnHandQuantity FROM Item,Inventory WHERE (Item.ItemNumber='$ViewItemNumber' AND Item.ItemNumber=Inventory.ItemNumber); $query = mssql_query($sql) or die (THE SECOND (2) TABLE SELECTION FAILED.); $results = mssql_fetch_array($query); echo $results['ItemNumber']; } Note: I'm running LAMP locally (NY) and connecting remotely to a Windows 2000 box running MS SQL Server 2000 (UK) with the FreeTDS package. O From Now 'Till Then, \-Reginald Alex Mullin /\ 212-894-1690 ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the postmaster at [EMAIL PROTECTED] www.sothebys.com ** -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php