Jump to content

MySQL client ran out of memory

humble365

By humble365
in MySQL Help

Recommended Posts

humble365 Newbie

humble365

Posted
Posted

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.

Link to comment
https://forums.phpfreaks.com/topic/208814-mysql-client-ran-out-of-memory/
Share on other sites

Archived

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

Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.