MySQL client ran out of memory

[humble365]

Dear friends

Can you please help me in solving following error? The error is listed below:

 

Warning: mysql_query() [function.mysql-query]: Unable to save result set in  jobs/db.php on line 39

MySQL client ran out of memory

 

In line 39

 

line 35 :  function JB_mysql_query($sql) {

line 36 : global $jb_query_c;

line 37 : $jb_query_c++;

line 38 : global $jb_mysql_link;

line 39 : $result = mysql_query($sql, $jb_mysql_link) or die(mysql_error());

line 40 :

line 41 : return $result;

line 42 :  }

 

when I echo the value of $sql it displays :

SELECT * FROM `jb_variables` where `key` = 'LAST_HOUSEKEEP_RUN' UPDATE `jb_variables` SET `val`='YES' WHERE `key`='HOUSEKEEP_RUNNING' AND `val`='NO' DELETE FROM `jb_sessions` WHERE UNIX_TIMESTAMP(DATE_SUB('2010-07-25 06:48:55', INTERVAL 1440 SECOND)) > UNIX_TIMESTAMP(last_request_time) REPLACE INTO jb_variables (`key`, `val`) VALUES ('LAST_HOUSEKEEP_RUN', '1280040534') SELECT * FROM `jb_variables` where `key` = 'LAST_MAIL_QUEUE_RUN' UPDATE `jb_variables` SET `val`='YES' WHERE `key`='MAIL_QUEUE_RUNNING' AND `val`='NO' SELECT * from mail_queue where (status='queued' OR status='error') AND retry_count <= 5 AND template_id!='12' order by mail_date DESCUPDATE mail_queue SET status='error', retry_count=retry_count+1, error_msg='could not determine the SMTP to connect', `date_stamp`='2010-07-25 06:48:55' WHERE mail_id=191056UPDATE mail_queue SET status='error', retry_count=retry_count+1, error_msg='could not determine the SMTP to connect', `date_stamp`='2010-07-25 06:48:55' WHERE mail_id=123331UPDATE mail_queue SET status='error', retry_count=retry_count+1, error_msg='could not determine the SMTP to connect', `date_stamp`='2010-07-25 06:48:55' WHERE mail_id=123330UPDATE mail_queue SET status='error', retry_count=retry_count+1, error_msg='could not determine the SMTP to connect', `date_stamp`='2010-07-25 06:48:55' WHERE mail_id=123327UPDATE mail_queue SET status='error', retry_count=retry_count+1, error_msg='could not determine the SMTP to connect', `date_stamp`='2010-07-25 06:48:55' WHERE mail_id=123326UPDATE mail_queue SET status='error', retry_count=retry_count+1, error_msg='could not determine the SMTP to connect', `date_stamp`='2010-07-25 06:48:55' WHERE mail_id=123325UPDATE mail_queue SET status='error', retry_count=retry_count+1, error_msg='could not determine the SMTP to connect', `date_stamp`='2010-07-25 06:48:55' WHERE mail_id=123324UPDATE mail_queue SET status='error', retry_count=retry_count+1, error_msg='could not determine the SMTP to connect', `date_stamp`='2010-07-25 06:48:55' WHERE mail_id=123321UPDATE mail_queue SET status='error', retry_count=retry_count+1, error_msg='could not determine the SMTP to connect', `date_stamp`='2010-07-25 06:48:55' WHERE mail_id=123320UPDATE mail_queue SET status='error', retry_count=retry_count+1, error_msg='could not determine the SMTP to connect', `date_stamp`='2010-07-25 06:48:55' WHERE mail_id=123319UPDATE mail_queue SET status='error', retry_count=retry_count+1, error_msg='could not determine the SMTP to connect', `date_stamp`='2010-07-25 06:48:55' WHERE mail_id=123318UPDATE mail_queue SET status='error', retry_count=retry_count+1, error_msg='could not determine the SMTP to connect', `date_stamp`='2010-07-25 06:48:55' WHERE mail_id=123315UPDATE mail_queue SET status='error', retry_count=retry_count+1, error_msg='could not determine the SMTP to connect', `date_stamp`='2010-07-25 06:48:55' WHERE mail_id=123314UPDATE mail_queue SET status='error', retry_count=retry_count+1, error_msg='could not determine the SMTP to connect', `date_stamp`='2010-07-25 06:48:55' WHERE mail_id=123313UPDATE mail_queue SET status='error', retry_count=retry_count+1, error_msg='could not determine the SMTP to connect', `date_stamp`='2010-07-25 06:48:55' WHERE mail_id=123309UPDATE mail_queue SET status='error', retry_count=retry_count+1, error_msg='could not determine the SMTP to connect', `date_stamp`='2010-07-25 06:48:55' WHERE mail_id=123310UPDATE mail_queue SET status='error', retry_count=retry_count+1, error_msg='could not determine the SMTP to connect', `date_stamp`='2010-07-25 06:48:55' WHERE mail_id=123306UPDATE mail_queue SET status='error', retry_count=retry_count+1, error_msg='could not determine the SMTP to connect', `date_stamp`='2010-07-25 06:48:55' WHERE mail_id=123305UPDATE mail_queue SET status='error', retry_count=retry_count+1, error_msg='could not determine the SMTP to connect', `date_stamp`='2010-07-25 06:48:55' WHERE mail_id=123304UPDATE mail_queue SET status='error', retry_count=retry_count+1, error_msg='could not determine the SMTP to connect', `date_stamp`='2010-07-25 06:48:55' WHERE mail_id=123303REPLACE INTO jb_variables (`key`, `val`) VALUES ('LAST_MAIL_QUEUE_RUN', '1280040535') UPDATE `jb_variables` SET `val`='NO' WHERE `key`='MAIL_QUEUE_RUNNING' SELECT * from jb_config WHERE `key`='MON_ENABLED' OR `key`='MON_POP3_PORT' OR `key`='MON_EMAIL_POP_USER' OR `key`='MON_EMAIL_POP_SERVER' or `key`='MON_EMAIL_POP_PASS' OR `key`='MON_LOG_DAYS' SELECT * FROM `jb_variables` where `key` = 'LAST_HOURLY_RUN' SELECT * FROM subscription_invoices WHERE ((`status`='Completed' ) OR ((`status`='Pending') AND `reason`='jb_credit_advanced')) AND UNIX_TIMESTAMP(`subscr_end`)+3600 < UNIX_TIMESTAMP('2010-07-25 06:48:55')SELECT * FROM membership_invoices WHERE ((`status`='Completed' ) OR ((`status`='Pending') AND `reason`='jb_credit_advanced')) AND (UNIX_TIMESTAMP(`member_end`)+30 < UNIX_TIMESTAMP('2010-07-25 06:48:55')) AND months_duration > 0 REPLACE INTO jb_variables (`key`, `val`) VALUES ('LAST_HOURLY_RUN', '1280040535') SELECT field_id FROM form_fields WHERE field_type='CATEGORY' AND form_id='1' SELECT post_id, `6`,`14`,`15` FROM posts_table WHERE DATE_SUB('2010-07-25 06:48:55',INTERVAL 20 DAY) >= `post_date` AND expired='N' AND post_mode='premium' SELECT field_id FROM form_fields WHERE field_type='CATEGORY' AND form_id='1' SELECT post_id, `6`,`14`,`15` FROM posts_table WHERE DATE_SUB('2010-07-25 06:48:55',INTERVAL 90 DAY) >= `post_date` AND expired='N' AND post_mode<>'premium' SELECT * FROM form_fields WHERE field_type='CATEGORY' and form_id='1' SELECT * FROM lang WHERE is_active='Y' SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='0' AND (lang='EN') and form_id=1 ORDER BY list_order, NAME SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='23' AND (lang='EN') and form_id='1' ORDER BY list_order, NAME ASC SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='20' AND (lang='EN') and form_id='1' ORDER BY list_order, NAME ASC SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='1' AND (lang='EN') and form_id='1' ORDER BY list_order, NAME ASC SELECT * FROM lang WHERE is_active='Y' SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='23' AND (lang='EN') and form_id=1 ORDER BY list_order, NAME SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='82' AND (lang='EN') and form_id='1' ORDER BY list_order, NAME ASC SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='88' AND (lang='EN') and form_id='1' ORDER BY list_order, NAME ASC SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='96' AND (lang='EN') and form_id='1' ORDER BY list_order, NAME ASC SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='97' AND (lang='EN') and form_id='1' ORDER BY list_order, NAME ASC SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='92' AND (lang='EN') and form_id='1' ORDER BY list_order, NAME ASC SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='93' AND (lang='EN') and form_id='1' ORDER BY list_order, NAME ASC SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='94' AND (lang='EN') and form_id='1' ORDER BY list_order, NAME ASC SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='95' AND (lang='EN') and form_id='1' ORDER BY list_order, NAME ASC SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='98' AND (lang='EN') and form_id='1' ORDER BY list_order, NAME ASC SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='100' AND (lang='EN') and form_id='1' ORDER BY list_order, NAME ASC SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='99' AND (lang='EN') and form_id='1' ORDER BY list_order, NAME ASC SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='101' AND (lang='EN') and form_id='1' ORDER BY list_order, NAME ASC SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='89' AND (lang='EN') and form_id='1' ORDER BY list_order, NAME ASC SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='78' AND (lang='EN') and form_id='1' ORDER BY list_order, NAME ASC SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='87' AND (lang='EN') and form_id='1' ORDER BY list_order, NAME ASC SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='81' AND (lang='EN') and form_id='1' ORDER BY list_order, NAME ASC SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='86' AND (lang='EN') and form_id='1' ORDER BY list_order, NAME ASC SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='83' AND (lang='EN') and form_id='1' ORDER BY list_order, NAME ASC SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='85' AND (lang='EN') and form_id='1' ORDER BY list_order, NAME ASC SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='79' AND (lang='EN') and form_id='1' ORDER BY list_order, NAME ASC SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='80' AND (lang='EN') and form_id='1' ORDER BY list_order, NAME ASC SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='84' AND (lang='EN') and form_id='1' ORDER BY list_order, NAME ASC SELECT * from categories WHERE parent_category_id='23' SELECT * FROM lang WHERE is_active='Y' SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='78' AND (lang='EN') and form_id=1 ORDER BY list_order, NAME SELECT * FROM lang WHERE is_active='Y' SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='79' AND (lang='EN') and form_id=1 ORDER BY list_order, NAME SELECT * FROM lang WHERE is_active='Y' SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='80' AND (lang='EN') and form_id=1 ORDER BY list_order, NAME SELECT * FROM lang WHERE is_active='Y' SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='81' AND (lang='EN') and form_id=1 ORDER BY list_order, NAME SELECT * FROM lang WHERE is_active='Y' SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='82' AND (lang='EN') and form_id=1 ORDER BY list_order, NAME SELECT * FROM lang WHERE is_active='Y' SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='83' AND (lang='EN') and form_id=1 ORDER BY list_order, NAME SELECT * FROM lang WHERE is_active='Y' SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='84' AND (lang='EN') and form_id=1 ORDER BY list_order, NAME SELECT * FROM lang WHERE is_active='Y' SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='85' AND (lang='EN') and form_id=1 ORDER BY list_order, NAME SELECT * FROM lang WHERE is_active='Y' SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='86' AND (lang='EN') and form_id=1 ORDER BY list_order, NAME SELECT * FROM lang WHERE is_active='Y' SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='87' AND (lang='EN') and form_id=1 ORDER BY list_order, NAME SELECT * FROM lang WHERE is_active='Y' SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='88' AND (lang='EN') and form_id=1 ORDER BY list_order, NAME SELECT * FROM lang WHERE is_active='Y' SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='89' AND (lang='EN') and form_id=1 ORDER BY list_order, NAME SELECT * FROM lang WHERE is_active='Y' SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='95' AND (lang='EN') and form_id=1 ORDER BY list_order, NAME SELECT * FROM lang WHERE is_active='Y' SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='94' AND (lang='EN') and form_id=1 ORDER BY list_order, NAME SELECT * FROM lang WHERE is_active='Y' SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='92' AND (lang='EN') and form_id=1 ORDER BY list_order, NAME SELECT * FROM lang WHERE is_active='Y' SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='93' AND (lang='EN') and form_id=1 ORDER BY list_order, NAME SELECT * FROM lang WHERE is_active='Y' SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='96' AND (lang='EN') and form_id=1 ORDER BY list_order, NAME SELECT * FROM lang WHERE is_active='Y' SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='97' AND (lang='EN') and form_id=1 ORDER BY list_order, NAME SELECT * FROM lang WHERE is_active='Y' SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='98' AND (lang='EN') and form_id=1 ORDER BY list_order, NAME SELECT * FROM lang WHERE is_active='Y' SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='99' AND (lang='EN') and form_id=1 ORDER BY list_order, NAME SELECT * FROM lang WHERE is_active='Y' SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='100' AND (lang='EN') and form_id=1 ORDER BY list_order, NAME SELECT * FROM lang WHERE is_active='Y' SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='101' AND (lang='EN') and form_id=1 ORDER BY list_order, NAME SELECT * FROM lang WHERE is_active='Y' SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='20' AND (lang='EN') and form_id=1 ORDER BY list_order, NAME SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='22' AND (lang='EN') and form_id='1' ORDER BY list_order, NAME ASC SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='21' AND (lang='EN') and form_id='1' ORDER BY list_order, NAME ASC SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='26' AND (lang='EN') and form_id='1' ORDER BY list_order, NAME ASC SELECT * from categories WHERE parent_category_id='20' SELECT * FROM lang WHERE is_active='Y' SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='21' AND (lang='EN') and form_id=1 ORDER BY list_order, NAME SELECT * FROM lang WHERE is_active='Y' SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='22' AND (lang='EN') and form_id=1 ORDER BY list_order, NAME SELECT * FROM lang WHERE is_active='Y' SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='26' AND (lang='EN') and form_id=1 ORDER BY list_order, NAME SELECT * FROM lang WHERE is_active='Y' SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='1' AND (lang='EN') and form_id=1 ORDER BY list_order, NAME SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='68' AND (lang='EN') and form_id='1' ORDER BY list_order, NAME ASC SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='75' AND (lang='EN') and form_id='1' ORDER BY list_order, NAME ASC SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='74' AND (lang='EN') and form_id='1' ORDER BY list_order, NAME ASC SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='65' AND (lang='EN') and form_id='1' ORDER BY list_order, NAME ASC SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='76' AND (lang='EN') and form_id='1' ORDER BY list_order, NAME ASC SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='71' AND (lang='EN') and form_id='1' ORDER BY list_order, NAME ASC SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='73' AND (lang='EN') and form_id='1' ORDER BY list_order, NAME ASC SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='67' AND (lang='EN') and form_id='1' ORDER BY list_order, NAME ASC SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='69' AND (lang='EN') and form_id='1' ORDER BY list_order, NAME ASC SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='72' AND (lang='EN') and form_id='1' ORDER BY list_order, NAME ASC SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='102' AND (lang='EN') and form_id='1' ORDER BY list_order, NAME ASC SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='66' AND (lang='EN') and form_id='1' ORDER BY list_order, NAME ASC SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='70' AND (lang='EN') and form_id='1' ORDER BY list_order, NAME ASC SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='77' AND (lang='EN') and form_id='1' ORDER BY list_order, NAME ASC SELECT * from categories WHERE parent_category_id='1' SELECT * FROM lang WHERE is_active='Y' SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='65' AND (lang='EN') and form_id=1 ORDER BY list_order, NAME SELECT * FROM lang WHERE is_active='Y' SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='66' AND (lang='EN') and form_id=1 ORDER BY list_order, NAME SELECT * FROM lang WHERE is_active='Y' SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='67' AND (lang='EN') and form_id=1 ORDER BY list_order, NAME SELECT * FROM lang WHERE is_active='Y' SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='68' AND (lang='EN') and form_id=1 ORDER BY list_order, NAME SELECT * FROM lang WHERE is_active='Y' SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='69' AND (lang='EN') and form_id=1 ORDER BY list_order, NAME SELECT * FROM lang WHERE is_active='Y' SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='70' AND (lang='EN') and form_id=1 ORDER BY list_order, NAME SELECT * FROM lang WHERE is_active='Y' SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='71' AND (lang='EN') and form_id=1 ORDER BY list_order, NAME SELECT * FROM lang WHERE is_active='Y' SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='72' AND (lang='EN') and form_id=1 ORDER BY list_order, NAME SELECT * FROM lang WHERE is_active='Y' SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='73' AND (lang='EN') and form_id=1 ORDER BY list_order, NAME SELECT * FROM lang WHERE is_active='Y' SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='74' AND (lang='EN') and form_id=1 ORDER BY list_order, NAME SELECT * FROM lang WHERE is_active='Y' SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='75' AND (lang='EN') and form_id=1 ORDER BY list_order, NAME SELECT * FROM lang WHERE is_active='Y' SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='76' AND (lang='EN') and form_id=1 ORDER BY list_order, NAME SELECT * FROM lang WHERE is_active='Y' SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='77' AND (lang='EN') and form_id=1 ORDER BY list_order, NAME SELECT * FROM lang WHERE is_active='Y' SELECT categories.category_id, categories.category_name, lang, cat_name_translations.category_name AS NAME, obj_count, seo_fname FROM categories LEFT JOIN cat_name_translations ON categories.category_id=cat_name_translations.category_id WHERE parent_category_id='102' AND (lang='EN') and form_id=1 ORDER BY list_order, NAME SELECT count(*) FROM posts_table WHERE expired='N' AND approved='Y' REPLACE INTO jb_variables (`key`, `val`) VALUES ('POST_COUNT_AP','4') SELECT count(*) FROM posts_table WHERE expired='N' AND approved='N' AND `reason`!=''REPLACE INTO jb_variables (`key`, `val`) VALUES ('POST_COUNT_NA','0') SELECT count(*) FROM posts_table WHERE expired='N' AND post_mode='premium' AND approved='Y' REPLACE INTO jb_variables (`key`, `val`) VALUES ('POST_COUNT_PAP','0') SELECT count(*) FROM posts_table WHERE expired='N' AND reason='' AND approved='N' REPLACE INTO jb_variables (`key`, `val`) VALUES ('POST_COUNT_WA','0') SELECT count(*) FROM posts_table WHERE expired='Y' REPLACE INTO jb_variables (`key`, `val`) VALUES ('POST_COUNT_EX','129') SELECT count(*) FROM resumes_table WHERE approved='Y' AND status='ACT' REPLACE INTO jb_variables (`key`, `val`) VALUES ('ACT_RESUME_COUNT','231') SELECT count(*) FROM resumes_table REPLACE INTO jb_variables (`key`, `val`) VALUES ('RESUME_COUNT','237') SELECT count(*) FROM resumes_tableREPLACE INTO jb_variables (`key`, `val`) VALUES ('PROFILE_COUNT','237') SELECT count(*) FROM employersREPLACE INTO jb_variables (`key`, `val`) VALUES ('EMPLOYER_COUNT','83') SELECT count(*) FROM usersREPLACE INTO jb_variables (`key`, `val`) VALUES ('USER_COUNT','12615') UPDATE `jb_variables` SET `val`='NO' WHERE `key`='HOUSEKEEP_RUNNING' 

 

This sql statement frequently changes when we refresh. And this is called in every pages in the site.

Looking forward to hear soon.

[trq]

Put simply, your client (PHP) does not have enough memory to execute the query.

 

To put it frankly, I'm not surprised.

[humble365]

but when i asked with my host master, he said he has enought memory. Is there any php/Mysql code or any idea to control this error?

[Mchl]

Another thing is that mysql_query() can't run more than one query at once, and here you have... a lot of queries.

[fenway]

but when i asked with my host master, he said he has enought memory. Is there any php/Mysql code or any idea to control this error?

Yes -- one query at a time.  Seriously.