HELP! My web site went to craps and I don't know why

juschillinnow

I have a php site. It's for a local intranet so I can't give the site out. The entire site is database driven with mySQL.

We started having some weird problems due to a virus, so I recently Reinstalled the apache server and php 4.2.2. I did it NOT as a module but as aaaaa...... whatever the other way to do it is.

My scripts seemed to be working fine for a little while. There wasn't much extensive use on them for that time so I'm sure no one would have really noticed if anything was wrong. However, we were ready to get back into the swing of things and nothing works.

It seems that I can't connect to the mySQL database

here's part of a script....

<?
$mysql_link = mysql_connect("localhost", "username", "password")
or die
("<p>Could not connect to the database!");
mysql_select_db("mydatabase", $mysql_link)
or die
("<p>Could not open the database!");
?>
if($submit)
{
if($selectWhat == 'all')
{
$query = "select * from products";
$mysql_result = mysql_query($query, $mysql_link);
print("<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">");

// Top Border

print("<tr><td style = \"border-bottom: 2 solid #000000\" align=\"center\"><b>Item #</b></td><td style = \"border-bottom: 2 solid #000000\" align=\"center\"><b>Asst</b></td><td style = \"border-bottom: 2 solid #000000\" align=\"center\"><b>Description</b></td><td style = \"border-bottom: 2 solid #000000\" align=\"center\"><b>S. Price</b></td><td style = \"border-bottom: 2 solid #000000\" align=\"center\"><b>C. Price</b></td><td style = \"border-bottom: 2 solid #000000\" align=\"center\"><b>Pack</b></td><td style = \"border-bottom: 2 solid #000000\" align=\"center\"><b>Code</b></td><td style = \"border-bottom: 2 solid #000000\" align=\"center\"><b>Truck?</b></td><td style = \"border-bottom: 2 solid #000000\" align=\"center\"><b>O. Price</b></td><td style = \"border-bottom: 2 solid #000000\" align=\"center\"><b>AP</b></td></tr>");

// End Top Border

This is the receiving end of the script. It queries the database depending on input

I went to the php.ini file and turned error = on

and this is what I got:

Warning: Supplied argument is not a valid MySQL result resource in c:\program files\apache group\apache\htdocs\listwhat.triple on line 176

I've also been getting error like:

Warning: Undefined variable: YES in c:\program files\apache group\apache\htdocs\productsDeleteAdmin.triple on line 2

What the heck is going on???

hand

The connect seems to be ok.
I hope line 176 is near your posted commands:
$query = "select * from products";
$mysql_result = mysql_query($query, $mysql_link);

To get further informations try to add an OR statemant to mysql_query() as shown below and run the script again.

<?
$mysql_link = mysql_connect("localhost", "username", "password")
	or die ("<p>Could not connect to the database!");
mysql_select_db("mydatabase", $mysql_link)
	or die ("<p>Could not open the database!");
// ...

if($submit) {
	if($selectWhat == 'all') {
		$query = "select * from products";
		$mysql_result = mysql_query($query, $mysql_link)
			or print "&gt;&gt;&gt; MySQL-Error: ".mysql_errno()." -&gt; ".mysql_error()."<br>\n";

	print("<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">");

// ...

For helping you it is importent to know the lines which are displayed at the error messages

Show us lines 170 - 176 of listwhat.triple and lines 1 - 2 of productsDeleteAdmin.triple

juschillinnow

I used what you gave me and this is the error i got:

Warning: MySQL: Unable to save result set in c:\program files\apache group\apache\htdocs\listwhat.triple on line 8

MySQL-Error: 1030 -> Got error 127 from table handler

hand

You have to repair database!

"ERROR 1030: Got error 127 from table handler"

The first thing to do is check the table:

check table table_name;

If you get errors, repair the table:

repair table table_name;

In some cases you may have to run this more than once to find and fix all the problems.

http://www.phpbuilder.com/board/showthread.php?s=&threadid=61085

http://www.faqts.com/knowledge_base/view.phtml/aid/5775/fid/83
http://www.mysql.com/doc/en/REPAIR_TABLE.html

juschillinnow

Thank you so much. I have had to do that before and didn't think to check this time. Last time though there was an error that told me to do so.

I don't know, in any case thanks a bunch.

Just out of curiosity, What causes the mySQL database to return a wrong row count???

hand

Originally posted by juschillinnow
I have had to do that before and didn't think to check this time.

Really? Normally it is not neccessary to repair a database or a table!

Since 4 years I have experiance with mySQL and never it was neccessary to repair a table!

juschillinnow

Once before! Really!

It took hours of research until I finally did something that showed me the error that was happening.

After taking the error number I found that it has something to do with mySQL returning a wrong row count. ie there are really 4965 rows and it returns 4964. It shutsdown and doesn't know what to do so it freezes.

HECK! I don't know, maybe I have something configured wrong somewhere. As long as it works I'm not messing with it ! 🙂

Thank again for you help.

Never did find out why mySQL would return a wrong row count though????