<br>Module: advertising<br>Class: CAdvBanner<br>File: /home/bitrix/www/bitrix/modules/advertising/classes/mysql/advertising.php<br>Function: GetPageWeights_RS<br>Line: 943<br><font color=#ff0000>MySQL Query Error: 
				SELECT DISTINCT
					B.TYPE_SID,
					B.ID					BANNER_ID,
					B.WEIGHT				BANNER_WEIGHT,
					B.SHOWS_FOR_VISITOR,
					B.FIX_CLICK,
					B.FIX_SHOW,
					B.KEYWORDS				BANNER_KEYWORDS,
					DATE_FORMAT(B.DATE_SHOW_FIRST, '%d.%m.%Y %H:%i:%s')		DATE_SHOW_FIRST,
					DATE_FORMAT(B.DATE_SHOW_FROM, '%d.%m.%Y %H:%i:%s')			DATE_SHOW_FROM,
					DATE_FORMAT(B.DATE_SHOW_TO, '%d.%m.%Y %H:%i:%s')			DATE_SHOW_TO,
					B.FLYUNIFORM			FLYUNIFORM,
					B.MAX_SHOW_COUNT		MAX_SHOW_COUNT,
					B.SHOW_COUNT			SHOW_COUNT,
					C.ID					CONTRACT_ID,
					C.WEIGHT				CONTRACT_WEIGHT,
					C.KEYWORDS				CONTRACT_KEYWORDS
				FROM
					b_adv_type T

				INNER JOIN b_adv_banner B ON (
						B.ACTIVE='Y'
					and	B.TYPE_SID = T.SID
					and	B.STATUS_SID = 'PUBLISHED'
					and (B.FOR_NEW_GUEST is null or B.FOR_NEW_GUEST='Y')
					and	(ifnull(B.MAX_SHOW_COUNT,0)&gt;ifnull(B.SHOW_COUNT,0) or ifnull(B.MAX_SHOW_COUNT,0)=0)
					and (ifnull(B.MAX_CLICK_COUNT,0)&gt;ifnull(B.CLICK_COUNT,0) or ifnull(B.MAX_CLICK_COUNT,0)=0)
					and (ifnull(B.MAX_VISITOR_COUNT,0)&gt;ifnull(B.VISITOR_COUNT,0) or ifnull(B.MAX_VISITOR_COUNT,0)=0)
					and (B.DATE_SHOW_FROM&lt;=now() or B.DATE_SHOW_FROM is null or length(B.DATE_SHOW_FROM)&lt;=0)
					and (B.DATE_SHOW_TO&gt;=now() or B.DATE_SHOW_TO is null or length(B.DATE_SHOW_TO)&lt;=0))

				INNER JOIN b_adv_banner_2_site BS ON (
						BS.BANNER_ID = B.ID
					and BS.SITE_ID = 's1')

				INNER JOIN b_adv_contract C ON (
						C.ID = B.CONTRACT_ID
					and C.ACTIVE='Y'
					and	(ifnull(C.MAX_SHOW_COUNT,0)&gt;ifnull(C.SHOW_COUNT,0) or ifnull(C.MAX_SHOW_COUNT,0)=0)
					and (ifnull(C.MAX_CLICK_COUNT,0)&gt;ifnull(C.CLICK_COUNT,0) or ifnull(C.MAX_CLICK_COUNT,0)=0)
					and (ifnull(C.MAX_VISITOR_COUNT,0)&gt;ifnull(C.VISITOR_COUNT,0) or ifnull(C.MAX_VISITOR_COUNT,0)=0)
					and (C.DATE_SHOW_FROM&lt;=now() or C.DATE_SHOW_FROM is null or length(C.DATE_SHOW_FROM)&lt;=0)
					and (C.DATE_SHOW_TO&gt;=now() or C.DATE_SHOW_TO is null or length(C.DATE_SHOW_TO)&lt;=0))

				INNER JOIN b_adv_contract_2_site CS ON (
						CS.CONTRACT_ID = B.CONTRACT_ID
					and CS.SITE_ID = 's1')

				INNER JOIN b_adv_contract_2_type CT ON (
						CT.CONTRACT_ID = C.ID
					and (CT.TYPE_SID = 'ALL' or CT.TYPE_SID = T.SID))

				INNER JOIN b_adv_banner_2_weekday BW ON (
						BW.BANNER_ID = B.ID
					and BW.C_WEEKDAY='FRIDAY'
					and BW.C_HOUR = '1')

				INNER JOIN b_adv_contract_2_weekday CW ON (
						CW.CONTRACT_ID = C.ID
					and CW.C_WEEKDAY='FRIDAY'
					and CW.C_HOUR = '1')

				LEFT JOIN b_adv_banner_2_group UG1 ON (
					(UG1.BANNER_ID = B.ID
					and UG1.GROUP_ID in (2) and UG1.GROUP_ID&lt;&gt;2)
				)

				LEFT JOIN b_adv_banner_2_page BP1 ON (
						BP1.BANNER_ID = B.ID
					and BP1.SHOW_ON_PAGE='Y')

				LEFT JOIN b_adv_banner_2_page BP2 ON (
						BP2.BANNER_ID = B.ID
					and BP2.SHOW_ON_PAGE='N'
					and '/catalog/objects/vyklyuchatel_arl_zw_switch_2kh1000va/index.php?PAGEN_1=316&amp;city_name=%D0%9D%D0%BE%D0%B2%D0%BE%D1%80%D0%BE%D1%81%D1%81%D0%B8%D0%B9%D1%81%D0%BA' like concat(BP2.PAGE, '%'))

				LEFT JOIN b_adv_contract_2_page	CP1 ON (
						CP1.CONTRACT_ID = C.ID
					and CP1.SHOW_ON_PAGE='Y')

				LEFT JOIN b_adv_contract_2_page CP2 ON (
						CP2.CONTRACT_ID = C.ID
					and CP2.SHOW_ON_PAGE='N'
					and '/catalog/objects/vyklyuchatel_arl_zw_switch_2kh1000va/index.php?PAGEN_1=316&amp;city_name=%D0%9D%D0%BE%D0%B2%D0%BE%D1%80%D0%BE%D1%81%D1%81%D0%B8%D0%B9%D1%81%D0%BA' like concat(CP2.PAGE, '%'))

				LEFT JOIN b_adv_banner_2_stat_adv	BA	ON BA.BANNER_ID = B.ID
				LEFT JOIN b_adv_banner_2_country BC ON BC.BANNER_ID = B.ID AND (
					(
						(B.STAT_TYPE is null OR length(B.STAT_TYPE)=0 OR B.STAT_TYPE='COUNTRY')
						AND BC.COUNTRY_ID=''
					) OR (
						B.STAT_TYPE='REGION'
						AND BC.COUNTRY_ID=''
						AND BC.REGION=''
					) OR (
						B.STAT_TYPE='CITY'
						AND BC.CITY_ID='0'
					)
				)

				WHERE
					T.ACTIVE = 'Y'

				and (
					B.STAT_COUNT is null
					or B.STAT_COUNT = 0
					or BC.BANNER_ID is not null
				)
				and BP2.ID is null
				and CP2.ID is null
				and (BP1.ID is null or '/catalog/objects/vyklyuchatel_arl_zw_switch_2kh1000va/index.php?PAGEN_1=316&amp;city_name=%D0%9D%D0%BE%D0%B2%D0%BE%D1%80%D0%BE%D1%81%D1%81%D0%B8%D0%B9%D1%81%D0%BA' like concat(BP1.PAGE, '%'))
				and (CP1.ID is null or '/catalog/objects/vyklyuchatel_arl_zw_switch_2kh1000va/index.php?PAGEN_1=316&amp;city_name=%D0%9D%D0%BE%D0%B2%D0%BE%D1%80%D0%BE%D1%81%D1%81%D0%B8%D0%B9%D1%81%D0%BA' like concat(CP1.PAGE, '%'))
				and (BA.STAT_ADV_ID is null or BA.STAT_ADV_ID='0')
				and (BC.COUNTRY_ID is null or BC.COUNTRY_ID='')

				and
				(
					(B.SHOW_USER_GROUP = 'Y' and UG1.GROUP_ID is not null)
					or
					(B.SHOW_USER_GROUP &lt;&gt; 'Y' and UG1.GROUP_ID is null)
				)

				ORDER BY B.TYPE_SID desc, C.ID desc
				</font>[[2006] MySQL server has gone away]<br><br>
<table cellpadding="1" cellspacing="0" width="35%" bgcolor="#9C9A9C">
	<tr>
		<td><table cellpadding="5" cellspacing="0" width="100%">
			<tr>
				<td bgcolor="#FFFFFF" align="center">
					<FONT face="Verdana, Arial, Helvetica, sans-serif" size="-1">
					<font color="#FF0000"><b>DB query error.</b></font><br>
					Please try later.
					</font><br>
									</td>
			</tr>
		</table></td>
	</tr>
</table>
<br><br><br>
<br />
<b>Fatal error</b>:  Uncaught Bitrix\Main\DB\SqlQueryException: Mysql query error: (2006) MySQL server has gone away in /home/bitrix/www/bitrix/modules/main/lib/db/mysqliconnection.php:137
Stack trace:
#0 /home/bitrix/www/bitrix/modules/main/lib/db/mysqlcommonconnection.php(132): Bitrix\Main\DB\MysqliConnection-&gt;queryInternal('SELECT * FROM `...')
#1 /home/bitrix/www/bitrix/modules/main/lib/db/connection.php(716): Bitrix\Main\DB\MysqlCommonConnection-&gt;getTableFields('b_sec_session')
#2 /home/bitrix/www/bitrix/modules/main/lib/db/sqlhelper.php(387): Bitrix\Main\DB\Connection-&gt;getTableField('b_sec_session', 'SESSION_ID')
#3 /home/bitrix/www/bitrix/modules/main/lib/entity/datamanager.php(975): Bitrix\Main\DB\SqlHelper-&gt;prepareAssignment('b_sec_session', 'SESSION_ID', 'PcJITSWbudLAC6e...')
#4 /home/bitrix/www/bitrix/modules/security/classes/general/session_db.php(92): Bitrix\Main\Entity\DataManager::delete(Array)
#5 [internal function]: CSecuritySessionDB::write('PcJITSWbudLAC6e...', 'SESS_AUTH|a:1:{...')
#6 [internal function]: sess in <b>/home/bitrix/www/bitrix/modules/main/lib/db/mysqliconnection.php</b> on line <b>137</b><br />