Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

What is the issue PHP Warning: mysql_num_rows(): ERRORS


Guest

Recommended Posts

[11-Sep-2007 23:41:09] PHP Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/xxxxx/public_html/shop/includes/functions/database.php on line 103

 

[11-Sep-2007 23:54:27] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/xxxxx/public_html/shop/checkout_process.php:39) in /home/xxxxx/public_html/shop/includes/functions/general.php on line 33

 

I have been seeing this error for 3 days now.

 

Also when site is getting spidered for updates.

Link to comment
Share on other sites

See the link in my signature. That should fix the second, which may fix the first.

 

Jack

What effect does this have, I got this from error log:

mysql_slow_queries:

 

# Wed Sep 12 17:53:09 2007

# Query_time: 2 Lock_time: 0 Rows_sent: 25 Rows_examined: 238021

use datpcsto_pcstore;

select distinct p.products_image, p.products_model, m.manufacturers_id, p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products p left join manufacturers m using(manufacturers_id) left join specials s on p.products_id = s.products_id, products_description pd, categories c, products_to_categories p2c where p.products_status = '1' and p.products_id = pd.products_id and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and ((pd.products_name like '%wii%' or p.products_model like '%wii%' or m.manufacturers_name like '%wii%') ) order by pd.products_name limit 0, 25

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...