[mysql] Warning: Unable to save result set in... Opcje

[yalus]

witam

co jakis czas podczas wykonywania zapytania dostaje taki oto komunikat:

Warning:
Unable to save result set in /mirror/common/global.php on line 1734


ponizej przedstawiam zapytanie przy ktorym pojawia sie ten warning:-

[PHP] pobierz, plaintext 
define("rowsPerPage", 200);
 
 
function szukaj($str,$offset,$order)
{
 
$sql="
		Select * from 
			tblcustomers, 
			tblmain, 
			tblsettings 
		where 
			tblcustomers.mobile_number=tblmain.mobile_number and 
			tblmain.mobile_number=tblsettings.mobile_number and 
			(tblcustomers.first_name like '%".$str."%' or tblcustomers.last_name like '%".$str."%' or tblcustomers.mobile_number like '%".$str."%')  
		order by 
			$order desc limit ".$offset.",".rowsPerPage";		
 
	//linia 1734 w moim skrypcie:
	$result = mysql_query($sql);
 
}
[PHP] pobierz, plaintext 

a tutaj strokture tabel

[SQL] pobierz, plaintext 
CREATE TABLE `tblcustomers` (
  `mobile_number` char(11) NOT NULL DEFAULT '00000000000',
  `bussines_name` char(50) NOT NULL DEFAULT '',
  `bussines_type` char(50) DEFAULT NULL,
  `first_name` char(50) NOT NULL DEFAULT '',
  `last_name` char(50) NOT NULL DEFAULT '',
  `house_name` char(50) NOT NULL DEFAULT '',
  `house_number` char(50) NOT NULL DEFAULT '',
  `street_name` char(50) NOT NULL DEFAULT '',
  `city` char(50) NOT NULL DEFAULT '',
  `post_code` char(10) NOT NULL DEFAULT '',
  `customer_last` char(50) NOT NULL DEFAULT '',
  `customer_first` char(50) NOT NULL DEFAULT '',
  `marketeer` char(3) NOT NULL DEFAULT 'yes',
  `type` char(8) DEFAULT NULL,
  UNIQUE KEY `mobile_number` (`mobile_number`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
 
 
CREATE TABLE `tblmain` (
  `mobile_number` char(11) NOT NULL DEFAULT '00000000000',
  `init` char(2) NOT NULL DEFAULT '',
  `status` char(20) NOT NULL DEFAULT '',
  UNIQUE KEY `mobile_number` (`mobile_number`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
 
 
CREATE TABLE `tblsettings` (
  `mobile_number` varchar(11) NOT NULL DEFAULT '00000000000',
  `current_phone` varchar(50) NOT NULL DEFAULT '',
  `last_upgrade` varchar(100) NOT NULL DEFAULT '',
  `extra_charge` varchar(50) NOT NULL DEFAULT '',
  `company_delivery` varchar(50) NOT NULL DEFAULT '',
  `date_delivery` varchar(50) NOT NULL DEFAULT '',
  `handsfree` char(3) NOT NULL DEFAULT '',
  `bluetooth` char(3) NOT NULL DEFAULT '',
  `insurance` char(3) NOT NULL DEFAULT '',
  `part_exchange` varchar(50) NOT NULL DEFAULT '',
  `brochure` char(3) NOT NULL DEFAULT '',
  `loyalty_discount` varchar(5) NOT NULL DEFAULT '',
  `date_of_birth` date NOT NULL DEFAULT '1970-01-01',
  `way_to_pay_bill` varchar(50) NOT NULL DEFAULT '',
  `imei` varchar(50) NOT NULL DEFAULT '',
  `urn_code` varchar(50) NOT NULL DEFAULT '',
  `land_line` varchar(50) NOT NULL DEFAULT '',
  `email` varchar(50) NOT NULL DEFAULT '',
  `date_of_sold` date NOT NULL DEFAULT '1970-01-01',
  `date_of_connect` date NOT NULL DEFAULT '1970-01-01',
  `upgrade` int(5) NOT NULL DEFAULT '0',
  `agreement_number` varchar(50) NOT NULL DEFAULT '',
  `term_of_contract` varchar(50) NOT NULL DEFAULT '',
  `tmobile_password` varchar(50) NOT NULL DEFAULT '',
  `date_of_check` date NOT NULL DEFAULT '1970-01-01',
  `seller` char(2) NOT NULL DEFAULT '',
  `car_charger` char(3) DEFAULT '',
  `cover` char(3) DEFAULT '',
  `avaliableOffer` text,
  `change_network` char(50) DEFAULT NULL,
  `pik_off` char(3) DEFAULT NULL,
  UNIQUE KEY `mobile_number` (`mobile_number`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
[SQL] pobierz, plaintext 

wszystkie powyzsze tabele zawieraja ponad 100000 rekordow

co moze byc przyczyna tego bledu?

[icetique]

http://textpattern.com/faq/36/warning-unab...save-result-set