Re: [PHP-DB] pdo_mysql segfault error
Well this is not the proper list for these kind of questions but since you posted know that you should include the apache compile time options. Well I think that you should recompile apache, because mysql support is probably compiled in and since you upgraded mysql you should compile apache to use the new one. In order to figure out your compile time options you could use: httpd -V and httpd -l is useful too if you want to know the compiled in modules. Thodoris. Slith wrote: i'm trying to enable pdo_mysql extension, however i keep getting the following segfault error when i restart apache: httpd[20567]: segfault at 0020abef8f07 rip 0020abef8f07 rsp 006e6ad0 error 14 my setup is the following: Apache 1.3.37 php 5.2.2 mysql 5.0.41 not sure wether this problem is cause by my newer mysql version or 64bit server. has any gotten PDO_MYSQL on 64bit server? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] showing warnings
Hi
i have added index on both columns but still same warning is issued by mysql
then what i do now
John Mertic [EMAIL PROTECTED] wrote:
Is the table 'Mobile_Tunes' indexed at all? If not, you may want to
consider adding one at least one 'Tune_Type' and another on
'Tune_Name'.
John
On 9/10/07, Asim wrote:
Hi
script is following
if(isset($_GET['SearchTune']))
{
$tunename = substr($_GET['tune_name'],0,3);
$tunetype = $_GET['tune_type'];
$sql = SELECT Tune_Name,Tune_Type FROM Mobile_Tunes WHERE Tune_Name LIKE
'.$tunename.%' AND Tune_Type = '.$tunetype.';
}
else
{
$sql = SELECT Tune_Name,Tune_Type FROM Mobile_Tunes;
}
...
function
max_page($sql,$total_rows,$rows_per_page,$max_pages)
{
$all_rs = mysql_query($sql);
if(!$all_rs)
{
echo Sorry! Try again.;
return false;
}
$total_rows = mysql_num_rows($all_rs);
mysql_free_result($all_rs);
//mysql_close($link);
$max_pages = ceil($total_rows/$rows_per_page);
return $max_pages;
}
when i use this function it shows following warning
Warning: mysql_query(): Your query requires a full tablescan (table
Mobile_Tunes, 5 rows affected). Use EXPLAIN to optimize your query. in
D:\Program Files\Apache
Group\Apache2\htdocs\Breez\mtunes_main.php on line 47
now can you tell me some solution
bye
John Mertic wrote:
Can you provide the script you are running and the exact error message
you are getting?
John
On 9/9/07, Asim wrote:
Hi
in my script when i scan whole table for result set to display in my page
it shows warning that suggest me to use
EXPLAIN statement but i donot need it as i have to show records on page
how to avoid this warning?
Bye
Asim Jamil - 0092 345 4025907, Pakistan
-
Be a better Globetrotter. Get better travel answers from someone who
knows.
Yahoo! Answers - Check it out.
--
--
John Mertic Explaining a joke
is like dissecting a frog: you
[EMAIL PROTECTED] understand it better,
but the frog dies in the
process.
-Mark Twain
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Asim Jamil - 0092 345 4025907, Pakistan
Be a better Heartthrob. Get better relationship answers from someone who
knows.
Yahoo! Answers - Check it out.
--
--
John Mertic Explaining a joke
is like dissecting a frog: you
[EMAIL PROTECTED] understand it better,
but the frog dies in the
process.
-Mark Twain
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Asim Jamil - 0092 345 4025907, Pakistan
-
Looking for a deal? Find great prices on flights and hotels with Yahoo!
FareChase.
Re: [PHP-DB] showing warnings
Hi
i have added index on both columns but still same warning is issued by mysql
then what i do now?
BYE
John Mertic [EMAIL PROTECTED] wrote:
Is the table 'Mobile_Tunes' indexed at all? If not, you may want to
consider adding one at least one 'Tune_Type' and another on
'Tune_Name'.
John
On 9/10/07, Asim wrote:
Hi
script is following
if(isset($_GET['SearchTune']))
{
$tunename = substr($_GET['tune_name'],0,3);
$tunetype = $_GET['tune_type'];
$sql = SELECT Tune_Name,Tune_Type FROM Mobile_Tunes WHERE Tune_Name LIKE
'.$tunename.%' AND Tune_Type = '.$tunetype.';
}
else
{
$sql = SELECT Tune_Name,Tune_Type FROM Mobile_Tunes;
}
...
function
max_page($sql,$total_rows,$rows_per_page,$max_pages)
{
$all_rs = mysql_query($sql);
if(!$all_rs)
{
echo Sorry! Try again.;
return false;
}
$total_rows = mysql_num_rows($all_rs);
mysql_free_result($all_rs);
//mysql_close($link);
$max_pages = ceil($total_rows/$rows_per_page);
return $max_pages;
}
when i use this function it shows following warning
Warning: mysql_query(): Your query requires a full tablescan (table
Mobile_Tunes, 5 rows affected). Use EXPLAIN to optimize your query. in
D:\Program Files\Apache
Group\Apache2\htdocs\Breez\mtunes_main.php on line 47
now can you tell me some solution
bye
John Mertic wrote:
Can you provide the script you are running and the exact error message
you are getting?
John
On 9/9/07, Asim wrote:
Hi
in my script when i scan whole table for result set to display in my page
it shows warning that suggest me to use
EXPLAIN statement but i donot need it as i have to show records on page
how to avoid this warning?
Bye
Asim Jamil - 0092 345 4025907, Pakistan
-
Be a better Globetrotter. Get better travel answers from someone who
knows.
Yahoo! Answers - Check it out.
--
--
John Mertic Explaining a joke
is like dissecting a frog: you
[EMAIL PROTECTED] understand it better,
but the frog dies in the
process.
-Mark Twain
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Asim Jamil - 0092 345 4025907, Pakistan
Be a better Heartthrob. Get better relationship answers from someone who
knows.
Yahoo! Answers - Check it out.
--
--
John Mertic Explaining a joke
is like dissecting a frog: you
[EMAIL PROTECTED] understand it better,
but the frog dies in the
process.
-Mark Twain
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Asim Jamil - 0092 345 4025907, Pakistan
-
Take the Internet to Go: Yahoo!Go puts the Internet in your pocket: mail, news,
photos more.
Re: [PHP-DB] showing warnings
Run the query through MySQL directly prepending EXPLAIN to the query
and attach the results here.
John
On 9/10/07, Asim [EMAIL PROTECTED] wrote:
Hi
i have added index on both columns but still same warning is issued by mysql
then what i do now
John Mertic [EMAIL PROTECTED] wrote:
Is the table 'Mobile_Tunes' indexed at all? If not, you may want to
consider adding one at least one 'Tune_Type' and another on
'Tune_Name'.
John
On 9/10/07, Asim wrote:
Hi
script is following
if(isset($_GET['SearchTune']))
{
$tunename = substr($_GET['tune_name'],0,3);
$tunetype = $_GET['tune_type'];
$sql = SELECT Tune_Name,Tune_Type FROM Mobile_Tunes WHERE Tune_Name LIKE
'.$tunename.%' AND Tune_Type = '.$tunetype.';
}
else
{
$sql = SELECT Tune_Name,Tune_Type FROM Mobile_Tunes;
}
...
function
max_page($sql,$total_rows,$rows_per_page,$max_pages)
{
$all_rs = mysql_query($sql);
if(!$all_rs)
{
echo Sorry! Try again.;
return false;
}
$total_rows = mysql_num_rows($all_rs);
mysql_free_result($all_rs);
//mysql_close($link);
$max_pages = ceil($total_rows/$rows_per_page);
return $max_pages;
}
when i use this function it shows following warning
Warning: mysql_query(): Your query requires a full tablescan (table
Mobile_Tunes, 5 rows affected). Use EXPLAIN to optimize your query. in
D:\Program Files\Apache
Group\Apache2\htdocs\Breez\mtunes_main.php on line 47
now can you tell me some solution
bye
John Mertic wrote:
Can you provide the script you are running and the exact error message
you are getting?
John
On 9/9/07, Asim wrote:
Hi
in my script when i scan whole table for result set to display in my
page
it shows warning that suggest me to use
EXPLAIN statement but i donot need it as i have to show records on page
how to avoid this warning?
Bye
Asim Jamil - 0092 345 4025907, Pakistan
-
Be a better Globetrotter. Get better travel answers from someone who
knows.
Yahoo! Answers - Check it out.
--
--
John Mertic Explaining a joke
is like dissecting a frog: you
[EMAIL PROTECTED] understand it better,
but the frog dies in the
process.
-Mark Twain
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Asim Jamil - 0092 345 4025907, Pakistan
Be a better Heartthrob. Get better relationship answers from someone who
knows.
Yahoo! Answers - Check it out.
--
--
John Mertic Explaining a joke
is like dissecting a frog: you
[EMAIL PROTECTED] understand it better,
but the frog dies in the
process.
-Mark Twain
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Asim Jamil - 0092 345 4025907, Pakistan
Looking for a deal? Find great prices on flights and hotels with Yahoo!
FareChase.
--
--
John MerticExplaining a joke
is like dissecting a frog: you
[EMAIL PROTECTED] understand it better,
but the frog dies in the
process.
-Mark Twain
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] ? SELECT TABLE Command
Hi,
I've got a PHP program I wrote a year or so ago with the oddest line of code. I
know I didn't come up with it myself; I must have adapted it from a book or
something, but I have checked all the books it could have come from and could
not find it in any of them, nor can I find any such command anywhere else. It
is an SQL query (probably MySQL, but perhaps SQLite or possibly even PGSQL or
mSQL):
$query=SELECT TABLE $tablename;;
if (mysql_query($query, $link)) {
echo($indent.The table, '$tablename', was successfully opened.br /\n);
}
To make things even stranger, it works fine in the original program that I put
it in (although what, if anything, it does is beyond me), but fails when I try
it in another program (yes, I took care of $tablename).
Does anyone have any idea where this bizarre piece of code came from, what it
does, if it's valid, or why it works even though such a command does not even
seem to exist? This is has had me baffled for several months now.
Thanks.
--
Mike W.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] mssql_connect not working from command line
I had cronjobs running fine on Linux which included a file which called mssql_connect. Today when I run the cronjob script directly from the command line, I get: PHP Fatal error: Call to undefined function mssql_connect() in /the/included/file.php on line # Fatal error: Call to undefined function mssql_connect() in /the/included/file.php on line # I also notice that the cronjob started failing 1 month ago. The file is owned by the command line user and apache is in its group and vice versa. However, a web page that includes the same file with the mssql_connect call still works fine, and now it makes sense that I see mssql is still enabled in phpinfo. The admin says nothing changed. Is there a setting that must have been changed to disallow this function from working on the command line? I'm using PHP Version 5.1.6 and /etc/php.ini has changed 2 months ago and the cronjob worked since then. _ Gear up for Halo® 3 with free downloads and an exclusive offer. http://gethalo3gear.com?ocid=SeptemberWLHalo3_MSNHMTxt_1 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] ? SELECT TABLE Command
Please fix your reply-to address.
It
is an SQL query (probably MySQL, but perhaps SQLite or possibly even PGSQL or
mSQL):
The line after $query should tell you what uses it ;)
$query=SELECT TABLE $tablename;;
if (mysql_query($query, $link)) {
echo($indent.The table, '$tablename', was successfully opened.br /\n);
}
To make things even stranger, it works fine in the original program that I put
it in (although what, if anything, it does is beyond me), but fails when I try
it in another program (yes, I took care of $tablename).
What's the exact query that's run? Maybe $tablename contains more than
just a table name.
Different mysql version? Maybe it was in an older version of mysql but
they removed it.
It doesn't work in mysql5 or mysql4.0, maybe it does in an older version
though.
Looks like you're trying to check that the mysql user you connected as
has access to that table.
--
Postgresql php tutorials
http://www.designmagick.com/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] mssql_connect not working from command line
However, a web page that includes the same file with the mssql_connect call still works fine, and now it makes sense that I see mssql is still enabled in phpinfo. The apache version of the php.ini file is different to the cli version. Make sure you are looking at the right one. On debian I have two separate directories for each config - /etc/php5/apache2/ and /etc/php5/cli/ Try this: php -i | grep 'php.ini' from the command line to work out which php.ini to look at. -- Postgresql php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] ? SELECT TABLE Command
Chris wrote (in news:[EMAIL PROTECTED]):
It is an SQL query (probably MySQL, but perhaps SQLite or possibly even
PGSQL or mSQL):
The line after $query should tell you what uses it ;)
Sorry, I meant the book may have been about any of those; I was skimming through
a bunch of SQL books at that time and dont know which one I got it from.
$query=SELECT TABLE $tablename;;
if (mysql_query($query, $link)) {
echo($indent.The table, '$tablename', was successfully opened.br
/\n); }
To make things even stranger, it works fine in the original program that I
put it in (although what, if anything, it does is beyond me), but fails
when I try it in another program (yes, I took care of $tablename).
What's the exact query that's run? Maybe $tablename contains more than just a
table name.
Nope, its just
SELECT TABLE lyrics;
Different mysql version? Maybe it was in an older version of mysql but they
removed it.
It doesn't work in mysql5 or mysql4.0, maybe it does in an older version
though.
Looks like you're trying to check that the mysql user you connected as has
access to that table.
It really feels like a command I may have used in the SQLite analyzer or
something. However, Im sure I copied it from an example script in a book. I
ve put holds on all the books on PHP and (My)SQL at the library and will check
them all.
--
Mike W.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] showing warnings
Hi
this result is shown by mysql on running command prompt
mysql explain SELECT Tune_Name,Tune_Type FROM Mobile_Tunes;
+--+--+---+--+-+--+--+---+
| table| type | possible_keys | key | key_len | ref | rows |
Extra |
+--+--+---+--+-+--+--+---+
| Mobile_Tunes | ALL | NULL | NULL |NULL | NULL |4 |
|
+--+--+---+--+-+--+--+---+
1 row in set (0.00 sec)
mysql
and
mysql SELECT Tune_Name,Tune_Type FROM Mobile_Tunes;
+---+---+
| Tune_Name | Tune_Type |
+---+---+
| pakistani | midi |
| pakistan2 | midi |
| usa | midi |
| uk| midi |
+---+---+
4 rows in set (0.00 sec)
mysql
now what next?
bye
John Mertic [EMAIL PROTECTED] wrote: Run the query through MySQL directly
prepending EXPLAIN to the query
and attach the results here.
John
On 9/10/07, Asim wrote:
Hi
i have added index on both columns but still same warning is issued by mysql
then what i do now
John Mertic wrote:
Is the table 'Mobile_Tunes' indexed at all? If not, you may want to
consider adding one at least one 'Tune_Type' and another on
'Tune_Name'.
John
On 9/10/07, Asim wrote:
Hi
script is following
if(isset($_GET['SearchTune']))
{
$tunename = substr($_GET['tune_name'],0,3);
$tunetype = $_GET['tune_type'];
$sql = SELECT Tune_Name,Tune_Type FROM Mobile_Tunes WHERE Tune_Name LIKE
'.$tunename.%' AND Tune_Type = '.$tunetype.';
}
else
{
$sql = SELECT Tune_Name,Tune_Type FROM Mobile_Tunes;
}
...
function
max_page($sql,$total_rows,$rows_per_page,$max_pages)
{
$all_rs = mysql_query($sql);
if(!$all_rs)
{
echo Sorry! Try again.;
return false;
}
$total_rows = mysql_num_rows($all_rs);
mysql_free_result($all_rs);
//mysql_close($link);
$max_pages = ceil($total_rows/$rows_per_page);
return $max_pages;
}
when i use this function it shows following warning
Warning: mysql_query(): Your query requires a full tablescan (table
Mobile_Tunes, 5 rows affected). Use EXPLAIN to optimize your query. in
D:\Program Files\Apache
Group\Apache2\htdocs\Breez\mtunes_main.php on line 47
now can you tell me some solution
bye
John Mertic wrote:
Can you provide the script you are running and the exact error message
you are getting?
John
On 9/9/07, Asim wrote:
Hi
in my script when i scan whole table for result set to display in my
page
it shows warning that suggest me to use
EXPLAIN statement but i donot need it as i have to show records on page
how to avoid this warning?
Bye
Asim Jamil - 0092 345 4025907, Pakistan
-
Be a better Globetrotter. Get better travel answers from someone who
knows.
Yahoo! Answers - Check it out.
--
--
John Mertic Explaining a joke
is like dissecting a frog: you
[EMAIL PROTECTED] understand it better,
but the frog dies in the
process.
-Mark Twain
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Asim Jamil - 0092 345 4025907, Pakistan
Be a better Heartthrob. Get better relationship answers from someone who
knows.
Yahoo! Answers - Check it out.
--
--
John Mertic Explaining a joke
is like dissecting a frog: you
[EMAIL PROTECTED] understand it better,
but the frog dies in the
process.
-Mark Twain
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Asim Jamil - 0092 345 4025907, Pakistan
Looking for a deal? Find great prices on flights and hotels with Yahoo!
FareChase.
--
--
John Mertic Explaining a joke
is like dissecting a frog: you
[EMAIL PROTECTED] understand it better,
but the frog dies in the
process.
-Mark Twain
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Asim Jamil - 0092 345 4025907, Pakistan
-
Tonight's top picks. What will you watch tonight? Preview the hottest shows on
Yahoo! TV.
