forum.bitel.ru :: Просмотр темы - В клиенте не отображаются поинты, адреса

04.03.2009 10:05:06 SELECT contract.title, contract.comment, address.address, phone.val as phone_number, contract.status, tariff_plan.title as tariff, contract.date1 as date_start, contract.date2 as date_end, que.val as queue, (b.summa1 + b.summa2 - b.summa3 - b.summa4) as balance, status.date1 as statusDate, status.status as statusN, status.comment as reason, service.date1 as serviceDate, mobile.val as mobile_number, serviceCer.date1 as cerDate FROM contract LEFT JOIN contract_parameter_type_1 as phone ON contract.id=phone.cid AND phone.pid=1 LEFT JOIN contract_parameter_type_2 as address ON contract.id=address.cid AND address.pid=3 LEFT JOIN contract_tariff on contract_tariff.cid = contract.id AND (contract_tariff.date1 <= ? OR contract_tariff.date1 is NULL) AND (contract_tariff.date2 >= ? OR contract_tariff.date2 is NULL) LEFT JOIN tariff_plan on contract_tariff.tpid= tariff_plan.id LEFT JOIN contract_parameter_type_1 as que ON contract.id=que.cid AND que.pid=1 LEFT JOIN address_house as house ON house.id=address.hid LEFT JOIN temp_balance ON temp_balance.cid=contract.id LEFT JOIN contract_balance as b ON b.cid=contract.id AND b.mm = temp_balance.mm AND b.yy = temp_balance.yy LEFT JOIN temp_status ON temp_status.cid=contract.id LEFT JOIN contract_status as status on status.cid = contract.id AND (status.date1 <= ? OR status.date1 is NULL) AND (status.date2 >= ? OR status.date2 is NULL) AND status.date1 = temp_status.date AND (status.status = 3 OR status.status = 4) LEFT JOIN temp_service ON temp_service.cid=contract.id LEFT JOIN contract_service as service on service.cid = contract.id AND (service.date1 <= ? OR service.date1 is NULL) AND (service.date2 >= ? OR service.date2 is NULL) AND service.date1 = temp_service.date AND service.sid = 1 LEFT JOIN contract_parameter_type_1 as mobile ON contract.id=mobile.cid AND mobile.pid=1 LEFT JOIN contract_service as serviceCer ON serviceCer.cid = contract.id AND serviceCer.sid = 1 WHERE 1=1 AND contract_tariff.tpid IN (6, 7, 8, 9) ORDER BY contract.title
04.03.2009 10:05:06 getting results
131
04.03.2009 10:05:44 SELECT contract.title, contract.comment, address.address, phone.val as phone_number, contract.status, tariff_plan.title as tariff, contract.date1 as date_start, contract.date2 as date_end, que.val as queue, (b.summa1 + b.summa2 - b.summa3 - b.summa4) as balance, status.date1 as statusDate, status.status as statusN, status.comment as reason, service.date1 as serviceDate, mobile.val as mobile_number, serviceCer.date1 as cerDate FROM contract LEFT JOIN contract_parameter_type_1 as phone ON contract.id=phone.cid AND phone.pid=1 LEFT JOIN contract_parameter_type_2 as address ON contract.id=address.cid AND address.pid=3 LEFT JOIN contract_tariff on contract_tariff.cid = contract.id AND (contract_tariff.date1 <= ? OR contract_tariff.date1 is NULL) AND (contract_tariff.date2 >= ? OR contract_tariff.date2 is NULL) LEFT JOIN tariff_plan on contract_tariff.tpid= tariff_plan.id LEFT JOIN contract_parameter_type_1 as que ON contract.id=que.cid AND que.pid=1 LEFT JOIN address_house as house ON house.id=address.hid LEFT JOIN temp_balance ON temp_balance.cid=contract.id LEFT JOIN contract_balance as b ON b.cid=contract.id AND b.mm = temp_balance.mm AND b.yy = temp_balance.yy LEFT JOIN temp_status ON temp_status.cid=contract.id LEFT JOIN contract_status as status on status.cid = contract.id AND (status.date1 <= ? OR status.date1 is NULL) AND (status.date2 >= ? OR status.date2 is NULL) AND status.date1 = temp_status.date AND (status.status = 3 OR status.status = 4) LEFT JOIN temp_service ON temp_service.cid=contract.id LEFT JOIN contract_service as service on service.cid = contract.id AND (service.date1 <= ? OR service.date1 is NULL) AND (service.date2 >= ? OR service.date2 is NULL) AND service.date1 = temp_service.date AND service.sid = 1 LEFT JOIN contract_parameter_type_1 as mobile ON contract.id=mobile.cid AND mobile.pid=1 LEFT JOIN contract_service as serviceCer ON serviceCer.cid = contract.id AND serviceCer.sid = 1 WHERE 1=1 AND contract_tariff.tpid IN (10) ORDER BY contract.title
04.03.2009 10:05:44 getting results
90
[Fatal Error] :1:1: Content is not allowed in prolog.
[Fatal Error] :1:1: Content is not allowed in prolog.
[Fatal Error] :1:1: Content is not allowed in prolog.
[Fatal Error] :1:1: Content is not allowed in prolog.
[Fatal Error] :1:1: Content is not allowed in prolog.
04.03.2009 10:07:43 SELECT contract.title, contract.comment, address.address, phone.val as phone_number, contract.status, tariff_plan.title as tariff, contract.date1 as date_start, contract.date2 as date_end, que.val as queue, (b.summa1 + b.summa2 - b.summa3 - b.summa4) as balance, status.date1 as statusDate, status.status as statusN, status.comment as reason, service.date1 as serviceDate, mobile.val as mobile_number, serviceCer.date1 as cerDate FROM contract LEFT JOIN contract_parameter_type_1 as phone ON contract.id=phone.cid AND phone.pid=1 LEFT JOIN contract_parameter_type_2 as address ON contract.id=address.cid AND address.pid=3 LEFT JOIN contract_tariff on contract_tariff.cid = contract.id AND (contract_tariff.date1 <= ? OR contract_tariff.date1 is NULL) AND (contract_tariff.date2 >= ? OR contract_tariff.date2 is NULL) LEFT JOIN tariff_plan on contract_tariff.tpid= tariff_plan.id LEFT JOIN contract_parameter_type_1 as que ON contract.id=que.cid AND que.pid=1 LEFT JOIN address_house as house ON house.id=address.hid LEFT JOIN temp_balance ON temp_balance.cid=contract.id LEFT JOIN contract_balance as b ON b.cid=contract.id AND b.mm = temp_balance.mm AND b.yy = temp_balance.yy LEFT JOIN temp_status ON temp_status.cid=contract.id LEFT JOIN contract_status as status on status.cid = contract.id AND (status.date1 <= ? OR status.date1 is NULL) AND (status.date2 >= ? OR status.date2 is NULL) AND status.date1 = temp_status.date AND (status.status = 3 OR status.status = 4) LEFT JOIN temp_service ON temp_service.cid=contract.id LEFT JOIN contract_service as service on service.cid = contract.id AND (service.date1 <= ? OR service.date1 is NULL) AND (service.date2 >= ? OR service.date2 is NULL) AND service.date1 = temp_service.date AND service.sid = 1 LEFT JOIN contract_parameter_type_1 as mobile ON contract.id=mobile.cid AND mobile.pid=1 LEFT JOIN contract_service as serviceCer ON serviceCer.cid = contract.id AND serviceCer.sid = 1 WHERE 1=1 AND contract_tariff.tpid IN (6, 7, 8, 9) ORDER BY contract.title
04.03.2009 10:07:43 getting results
114
04.03.2009 10:51:40 SELECT contract.title, contract.comment, address.address, phone.val as phone_number, contract.status, tariff_plan.title as tariff, contract.date1 as date_start, contract.date2 as date_end, que.val as queue, (b.summa1 + b.summa2 - b.summa3 - b.summa4) as balance, status.date1 as statusDate, status.status as statusN, status.comment as reason, service.date1 as serviceDate, mobile.val as mobile_number, serviceCer.date1 as cerDate FROM contract LEFT JOIN contract_parameter_type_1 as phone ON contract.id=phone.cid AND phone.pid=1 LEFT JOIN contract_parameter_type_2 as address ON contract.id=address.cid AND address.pid=3 LEFT JOIN contract_tariff on contract_tariff.cid = contract.id AND (contract_tariff.date1 <= ? OR contract_tariff.date1 is NULL) AND (contract_tariff.date2 >= ? OR contract_tariff.date2 is NULL) LEFT JOIN tariff_plan on contract_tariff.tpid= tariff_plan.id LEFT JOIN contract_parameter_type_1 as que ON contract.id=que.cid AND que.pid=1 LEFT JOIN address_house as house ON house.id=address.hid LEFT JOIN temp_balance ON temp_balance.cid=contract.id LEFT JOIN contract_balance as b ON b.cid=contract.id AND b.mm = temp_balance.mm AND b.yy = temp_balance.yy LEFT JOIN temp_status ON temp_status.cid=contract.id LEFT JOIN contract_status as status on status.cid = contract.id AND (status.date1 <= ? OR status.date1 is NULL) AND (status.date2 >= ? OR status.date2 is NULL) AND status.date1 = temp_status.date AND (status.status = 3 OR status.status = 4) LEFT JOIN temp_service ON temp_service.cid=contract.id LEFT JOIN contract_service as service on service.cid = contract.id AND (service.date1 <= ? OR service.date1 is NULL) AND (service.date2 >= ? OR service.date2 is NULL) AND service.date1 = temp_service.date AND service.sid = 1 LEFT JOIN contract_parameter_type_1 as mobile ON contract.id=mobile.cid AND mobile.pid=1 LEFT JOIN contract_service as serviceCer ON serviceCer.cid = contract.id AND serviceCer.sid = 1 WHERE 1=1 AND contract_tariff.tpid IN (6, 7, 8, 9, 10, 11, 12, 13) ORDER BY contract.title
04.03.2009 10:51:40 getting results
138
04.03.2009 11:02:12 SELECT contract.title, contract.comment, address.address, phone.val as phone_number, contract.status, tariff_plan.title as tariff, contract.date1 as date_start, contract.date2 as date_end, que.val as queue, (b.summa1 + b.summa2 - b.summa3 - b.summa4) as balance, status.date1 as statusDate, status.status as statusN, status.comment as reason, service.date1 as serviceDate, mobile.val as mobile_number, serviceCer.date1 as cerDate FROM contract LEFT JOIN contract_parameter_type_1 as phone ON contract.id=phone.cid AND phone.pid=1 LEFT JOIN contract_parameter_type_2 as address ON contract.id=address.cid AND address.pid=3 LEFT JOIN contract_tariff on contract_tariff.cid = contract.id AND (contract_tariff.date1 <= ? OR contract_tariff.date1 is NULL) AND (contract_tariff.date2 >= ? OR contract_tariff.date2 is NULL) LEFT JOIN tariff_plan on contract_tariff.tpid= tariff_plan.id LEFT JOIN contract_parameter_type_1 as que ON contract.id=que.cid AND que.pid=1 LEFT JOIN address_house as house ON house.id=address.hid LEFT JOIN temp_balance ON temp_balance.cid=contract.id LEFT JOIN contract_balance as b ON b.cid=contract.id AND b.mm = temp_balance.mm AND b.yy = temp_balance.yy LEFT JOIN temp_status ON temp_status.cid=contract.id LEFT JOIN contract_status as status on status.cid = contract.id AND (status.date1 <= ? OR status.date1 is NULL) AND (status.date2 >= ? OR status.date2 is NULL) AND status.date1 = temp_status.date AND (status.status = 3 OR status.status = 4) LEFT JOIN temp_service ON temp_service.cid=contract.id LEFT JOIN contract_service as service on service.cid = contract.id AND (service.date1 <= ? OR service.date1 is NULL) AND (service.date2 >= ? OR service.date2 is NULL) AND service.date1 = temp_service.date AND service.sid = 1 LEFT JOIN contract_parameter_type_1 as mobile ON contract.id=mobile.cid AND mobile.pid=1 LEFT JOIN contract_service as serviceCer ON serviceCer.cid = contract.id AND serviceCer.sid = 1 WHERE 1=1 AND contract_tariff.tpid IN (6, 7, 8, 9, 10, 11, 12, 13) ORDER BY contract.title
04.03.2009 11:02:12 getting results
125
04.03.2009 11:02:53 SELECT contract.title, contract.comment, address.address, phone.val as phone_number, contract.status, tariff_plan.title as tariff, contract.date1 as date_start, contract.date2 as date_end, que.val as queue, (b.summa1 + b.summa2 - b.summa3 - b.summa4) as balance, status.date1 as statusDate, status.status as statusN, status.comment as reason, service.date1 as serviceDate, mobile.val as mobile_number, serviceCer.date1 as cerDate FROM contract LEFT JOIN contract_parameter_type_1 as phone ON contract.id=phone.cid AND phone.pid=1 LEFT JOIN contract_parameter_type_2 as address ON contract.id=address.cid AND address.pid=3 LEFT JOIN contract_tariff on contract_tariff.cid = contract.id AND (contract_tariff.date1 <= ? OR contract_tariff.date1 is NULL) AND (contract_tariff.date2 >= ? OR contract_tariff.date2 is NULL) LEFT JOIN tariff_plan on contract_tariff.tpid= tariff_plan.id LEFT JOIN contract_parameter_type_1 as que ON contract.id=que.cid AND que.pid=1 LEFT JOIN address_house as house ON house.id=address.hid LEFT JOIN temp_balance ON temp_balance.cid=contract.id LEFT JOIN contract_balance as b ON b.cid=contract.id AND b.mm = temp_balance.mm AND b.yy = temp_balance.yy LEFT JOIN temp_status ON temp_status.cid=contract.id LEFT JOIN contract_status as status on status.cid = contract.id AND (status.date1 <= ? OR status.date1 is NULL) AND (status.date2 >= ? OR status.date2 is NULL) AND status.date1 = temp_status.date AND (status.status = 3 OR status.status = 4) LEFT JOIN temp_service ON temp_service.cid=contract.id LEFT JOIN contract_service as service on service.cid = contract.id AND (service.date1 <= ? OR service.date1 is NULL) AND (service.date2 >= ? OR service.date2 is NULL) AND service.date1 = temp_service.date AND service.sid = 1 LEFT JOIN contract_parameter_type_1 as mobile ON contract.id=mobile.cid AND mobile.pid=1 LEFT JOIN contract_service as serviceCer ON serviceCer.cid = contract.id AND serviceCer.sid = 1 WHERE 1=1 AND contract_tariff.tpid IN (6, 7, 8, 9, 10, 11, 12, 13) ORDER BY contract.title
04.03.2009 11:02:53 getting results
116
04.03.2009 11:03:08 SELECT contract.title, contract.comment, address.address, phone.val as phone_number, contract.status, tariff_plan.title as tariff, contract.date1 as date_start, contract.date2 as date_end, que.val as queue, (b.summa1 + b.summa2 - b.summa3 - b.summa4) as balance, status.date1 as statusDate, status.status as statusN, status.comment as reason, service.date1 as serviceDate, mobile.val as mobile_number, serviceCer.date1 as cerDate FROM contract LEFT JOIN contract_parameter_type_1 as phone ON contract.id=phone.cid AND phone.pid=1 LEFT JOIN contract_parameter_type_2 as address ON contract.id=address.cid AND address.pid=3 LEFT JOIN contract_tariff on contract_tariff.cid = contract.id AND (contract_tariff.date1 <= ? OR contract_tariff.date1 is NULL) AND (contract_tariff.date2 >= ? OR contract_tariff.date2 is NULL) LEFT JOIN tariff_plan on contract_tariff.tpid= tariff_plan.id LEFT JOIN contract_parameter_type_1 as que ON contract.id=que.cid AND que.pid=1 LEFT JOIN address_house as house ON house.id=address.hid LEFT JOIN temp_balance ON temp_balance.cid=contract.id LEFT JOIN contract_balance as b ON b.cid=contract.id AND b.mm = temp_balance.mm AND b.yy = temp_balance.yy LEFT JOIN temp_status ON temp_status.cid=contract.id LEFT JOIN contract_status as status on status.cid = contract.id AND (status.date1 <= ? OR status.date1 is NULL) AND (status.date2 >= ? OR status.date2 is NULL) AND status.date1 = temp_status.date AND (status.status = 3 OR status.status = 4) LEFT JOIN temp_service ON temp_service.cid=contract.id LEFT JOIN contract_service as service on service.cid = contract.id AND (service.date1 <= ? OR service.date1 is NULL) AND (service.date2 >= ? OR service.date2 is NULL) AND service.date1 = temp_service.date AND service.sid = 1 LEFT JOIN contract_parameter_type_1 as mobile ON contract.id=mobile.cid AND mobile.pid=1 LEFT JOIN contract_service as serviceCer ON serviceCer.cid = contract.id AND serviceCer.sid = 1 WHERE 1=1 AND contract_tariff.tpid IN (6, 7, 8, 9, 10, 11, 12, 13) ORDER BY contract.title
04.03.2009 11:03:08 getting results
114

Автор:	SVK [ 04 мар 2009, 10:58 ]
Заголовок сообщения:	В клиенте не отображаются поинты, адреса
Такое после обновления до BGBillingClient_4.5_289.zip и BGBillingServer_4.5_393.zip от 03.03.2009. Блин!!! Хорошо, что бакап оказался под рукой....

Автор:	skn [ 04 мар 2009, 12:53 ]
Заголовок сообщения:
что в логах

Автор:	SVK [ 04 мар 2009, 13:00 ]
Заголовок сообщения:
skn писал(а): что в логах Пусто вроде. Откатился на предыдущий клиент, в нем все отображается нормально.

Автор:	skn [ 04 мар 2009, 13:02 ]
Заголовок сообщения:
что именно не отображалось? поинты вроде в телефонии... я тему пишите в Ядро...

Автор:	SVK [ 04 мар 2009, 13:11 ]
Заголовок сообщения:
skn писал(а): что именно не отображалось? поинты вроде в телефонии... я тему пишите в Ядро... Я и так нахожусь в разделе "Ядро системы" Не отображается ни адреса от модуля IPN ни поинты от модуля PHONE, просто чистое окошко. Код: 04.03.2009 10:05:06 SELECT contract.title, contract.comment, address.address, phone.val as phone_number, contract.status, tariff_plan.title as tariff, contract.date1 as date_start, contract.date2 as date_end, que.val as queue, (b.summa1 + b.summa2 - b.summa3 - b.summa4) as balance, status.date1 as statusDate, status.status as statusN, status.comment as reason, service.date1 as serviceDate, mobile.val as mobile_number, serviceCer.date1 as cerDate FROM contract LEFT JOIN contract_parameter_type_1 as phone ON contract.id=phone.cid AND phone.pid=1 LEFT JOIN contract_parameter_type_2 as address ON contract.id=address.cid AND address.pid=3 LEFT JOIN contract_tariff on contract_tariff.cid = contract.id AND (contract_tariff.date1 <= ? OR contract_tariff.date1 is NULL) AND (contract_tariff.date2 >= ? OR contract_tariff.date2 is NULL) LEFT JOIN tariff_plan on contract_tariff.tpid= tariff_plan.id LEFT JOIN contract_parameter_type_1 as que ON contract.id=que.cid AND que.pid=1 LEFT JOIN address_house as house ON house.id=address.hid LEFT JOIN temp_balance ON temp_balance.cid=contract.id LEFT JOIN contract_balance as b ON b.cid=contract.id AND b.mm = temp_balance.mm AND b.yy = temp_balance.yy LEFT JOIN temp_status ON temp_status.cid=contract.id LEFT JOIN contract_status as status on status.cid = contract.id AND (status.date1 <= ? OR status.date1 is NULL) AND (status.date2 >= ? OR status.date2 is NULL) AND status.date1 = temp_status.date AND (status.status = 3 OR status.status = 4) LEFT JOIN temp_service ON temp_service.cid=contract.id LEFT JOIN contract_service as service on service.cid = contract.id AND (service.date1 <= ? OR service.date1 is NULL) AND (service.date2 >= ? OR service.date2 is NULL) AND service.date1 = temp_service.date AND service.sid = 1 LEFT JOIN contract_parameter_type_1 as mobile ON contract.id=mobile.cid AND mobile.pid=1 LEFT JOIN contract_service as serviceCer ON serviceCer.cid = contract.id AND serviceCer.sid = 1 WHERE 1=1 AND contract_tariff.tpid IN (6, 7, 8, 9) ORDER BY contract.title 04.03.2009 10:05:06 getting results 131 04.03.2009 10:05:44 SELECT contract.title, contract.comment, address.address, phone.val as phone_number, contract.status, tariff_plan.title as tariff, contract.date1 as date_start, contract.date2 as date_end, que.val as queue, (b.summa1 + b.summa2 - b.summa3 - b.summa4) as balance, status.date1 as statusDate, status.status as statusN, status.comment as reason, service.date1 as serviceDate, mobile.val as mobile_number, serviceCer.date1 as cerDate FROM contract LEFT JOIN contract_parameter_type_1 as phone ON contract.id=phone.cid AND phone.pid=1 LEFT JOIN contract_parameter_type_2 as address ON contract.id=address.cid AND address.pid=3 LEFT JOIN contract_tariff on contract_tariff.cid = contract.id AND (contract_tariff.date1 <= ? OR contract_tariff.date1 is NULL) AND (contract_tariff.date2 >= ? OR contract_tariff.date2 is NULL) LEFT JOIN tariff_plan on contract_tariff.tpid= tariff_plan.id LEFT JOIN contract_parameter_type_1 as que ON contract.id=que.cid AND que.pid=1 LEFT JOIN address_house as house ON house.id=address.hid LEFT JOIN temp_balance ON temp_balance.cid=contract.id LEFT JOIN contract_balance as b ON b.cid=contract.id AND b.mm = temp_balance.mm AND b.yy = temp_balance.yy LEFT JOIN temp_status ON temp_status.cid=contract.id LEFT JOIN contract_status as status on status.cid = contract.id AND (status.date1 <= ? OR status.date1 is NULL) AND (status.date2 >= ? OR status.date2 is NULL) AND status.date1 = temp_status.date AND (status.status = 3 OR status.status = 4) LEFT JOIN temp_service ON temp_service.cid=contract.id LEFT JOIN contract_service as service on service.cid = contract.id AND (service.date1 <= ? OR service.date1 is NULL) AND (service.date2 >= ? OR service.date2 is NULL) AND service.date1 = temp_service.date AND service.sid = 1 LEFT JOIN contract_parameter_type_1 as mobile ON contract.id=mobile.cid AND mobile.pid=1 LEFT JOIN contract_service as serviceCer ON serviceCer.cid = contract.id AND serviceCer.sid = 1 WHERE 1=1 AND contract_tariff.tpid IN (10) ORDER BY contract.title 04.03.2009 10:05:44 getting results 90 [Fatal Error] :1:1: Content is not allowed in prolog. [Fatal Error] :1:1: Content is not allowed in prolog. [Fatal Error] :1:1: Content is not allowed in prolog. [Fatal Error] :1:1: Content is not allowed in prolog. [Fatal Error] :1:1: Content is not allowed in prolog. 04.03.2009 10:07:43 SELECT contract.title, contract.comment, address.address, phone.val as phone_number, contract.status, tariff_plan.title as tariff, contract.date1 as date_start, contract.date2 as date_end, que.val as queue, (b.summa1 + b.summa2 - b.summa3 - b.summa4) as balance, status.date1 as statusDate, status.status as statusN, status.comment as reason, service.date1 as serviceDate, mobile.val as mobile_number, serviceCer.date1 as cerDate FROM contract LEFT JOIN contract_parameter_type_1 as phone ON contract.id=phone.cid AND phone.pid=1 LEFT JOIN contract_parameter_type_2 as address ON contract.id=address.cid AND address.pid=3 LEFT JOIN contract_tariff on contract_tariff.cid = contract.id AND (contract_tariff.date1 <= ? OR contract_tariff.date1 is NULL) AND (contract_tariff.date2 >= ? OR contract_tariff.date2 is NULL) LEFT JOIN tariff_plan on contract_tariff.tpid= tariff_plan.id LEFT JOIN contract_parameter_type_1 as que ON contract.id=que.cid AND que.pid=1 LEFT JOIN address_house as house ON house.id=address.hid LEFT JOIN temp_balance ON temp_balance.cid=contract.id LEFT JOIN contract_balance as b ON b.cid=contract.id AND b.mm = temp_balance.mm AND b.yy = temp_balance.yy LEFT JOIN temp_status ON temp_status.cid=contract.id LEFT JOIN contract_status as status on status.cid = contract.id AND (status.date1 <= ? OR status.date1 is NULL) AND (status.date2 >= ? OR status.date2 is NULL) AND status.date1 = temp_status.date AND (status.status = 3 OR status.status = 4) LEFT JOIN temp_service ON temp_service.cid=contract.id LEFT JOIN contract_service as service on service.cid = contract.id AND (service.date1 <= ? OR service.date1 is NULL) AND (service.date2 >= ? OR service.date2 is NULL) AND service.date1 = temp_service.date AND service.sid = 1 LEFT JOIN contract_parameter_type_1 as mobile ON contract.id=mobile.cid AND mobile.pid=1 LEFT JOIN contract_service as serviceCer ON serviceCer.cid = contract.id AND serviceCer.sid = 1 WHERE 1=1 AND contract_tariff.tpid IN (6, 7, 8, 9) ORDER BY contract.title 04.03.2009 10:07:43 getting results 114 04.03.2009 10:51:40 SELECT contract.title, contract.comment, address.address, phone.val as phone_number, contract.status, tariff_plan.title as tariff, contract.date1 as date_start, contract.date2 as date_end, que.val as queue, (b.summa1 + b.summa2 - b.summa3 - b.summa4) as balance, status.date1 as statusDate, status.status as statusN, status.comment as reason, service.date1 as serviceDate, mobile.val as mobile_number, serviceCer.date1 as cerDate FROM contract LEFT JOIN contract_parameter_type_1 as phone ON contract.id=phone.cid AND phone.pid=1 LEFT JOIN contract_parameter_type_2 as address ON contract.id=address.cid AND address.pid=3 LEFT JOIN contract_tariff on contract_tariff.cid = contract.id AND (contract_tariff.date1 <= ? OR contract_tariff.date1 is NULL) AND (contract_tariff.date2 >= ? OR contract_tariff.date2 is NULL) LEFT JOIN tariff_plan on contract_tariff.tpid= tariff_plan.id LEFT JOIN contract_parameter_type_1 as que ON contract.id=que.cid AND que.pid=1 LEFT JOIN address_house as house ON house.id=address.hid LEFT JOIN temp_balance ON temp_balance.cid=contract.id LEFT JOIN contract_balance as b ON b.cid=contract.id AND b.mm = temp_balance.mm AND b.yy = temp_balance.yy LEFT JOIN temp_status ON temp_status.cid=contract.id LEFT JOIN contract_status as status on status.cid = contract.id AND (status.date1 <= ? OR status.date1 is NULL) AND (status.date2 >= ? OR status.date2 is NULL) AND status.date1 = temp_status.date AND (status.status = 3 OR status.status = 4) LEFT JOIN temp_service ON temp_service.cid=contract.id LEFT JOIN contract_service as service on service.cid = contract.id AND (service.date1 <= ? OR service.date1 is NULL) AND (service.date2 >= ? OR service.date2 is NULL) AND service.date1 = temp_service.date AND service.sid = 1 LEFT JOIN contract_parameter_type_1 as mobile ON contract.id=mobile.cid AND mobile.pid=1 LEFT JOIN contract_service as serviceCer ON serviceCer.cid = contract.id AND serviceCer.sid = 1 WHERE 1=1 AND contract_tariff.tpid IN (6, 7, 8, 9, 10, 11, 12, 13) ORDER BY contract.title 04.03.2009 10:51:40 getting results 138 04.03.2009 11:02:12 SELECT contract.title, contract.comment, address.address, phone.val as phone_number, contract.status, tariff_plan.title as tariff, contract.date1 as date_start, contract.date2 as date_end, que.val as queue, (b.summa1 + b.summa2 - b.summa3 - b.summa4) as balance, status.date1 as statusDate, status.status as statusN, status.comment as reason, service.date1 as serviceDate, mobile.val as mobile_number, serviceCer.date1 as cerDate FROM contract LEFT JOIN contract_parameter_type_1 as phone ON contract.id=phone.cid AND phone.pid=1 LEFT JOIN contract_parameter_type_2 as address ON contract.id=address.cid AND address.pid=3 LEFT JOIN contract_tariff on contract_tariff.cid = contract.id AND (contract_tariff.date1 <= ? OR contract_tariff.date1 is NULL) AND (contract_tariff.date2 >= ? OR contract_tariff.date2 is NULL) LEFT JOIN tariff_plan on contract_tariff.tpid= tariff_plan.id LEFT JOIN contract_parameter_type_1 as que ON contract.id=que.cid AND que.pid=1 LEFT JOIN address_house as house ON house.id=address.hid LEFT JOIN temp_balance ON temp_balance.cid=contract.id LEFT JOIN contract_balance as b ON b.cid=contract.id AND b.mm = temp_balance.mm AND b.yy = temp_balance.yy LEFT JOIN temp_status ON temp_status.cid=contract.id LEFT JOIN contract_status as status on status.cid = contract.id AND (status.date1 <= ? OR status.date1 is NULL) AND (status.date2 >= ? OR status.date2 is NULL) AND status.date1 = temp_status.date AND (status.status = 3 OR status.status = 4) LEFT JOIN temp_service ON temp_service.cid=contract.id LEFT JOIN contract_service as service on service.cid = contract.id AND (service.date1 <= ? OR service.date1 is NULL) AND (service.date2 >= ? OR service.date2 is NULL) AND service.date1 = temp_service.date AND service.sid = 1 LEFT JOIN contract_parameter_type_1 as mobile ON contract.id=mobile.cid AND mobile.pid=1 LEFT JOIN contract_service as serviceCer ON serviceCer.cid = contract.id AND serviceCer.sid = 1 WHERE 1=1 AND contract_tariff.tpid IN (6, 7, 8, 9, 10, 11, 12, 13) ORDER BY contract.title 04.03.2009 11:02:12 getting results 125 04.03.2009 11:02:53 SELECT contract.title, contract.comment, address.address, phone.val as phone_number, contract.status, tariff_plan.title as tariff, contract.date1 as date_start, contract.date2 as date_end, que.val as queue, (b.summa1 + b.summa2 - b.summa3 - b.summa4) as balance, status.date1 as statusDate, status.status as statusN, status.comment as reason, service.date1 as serviceDate, mobile.val as mobile_number, serviceCer.date1 as cerDate FROM contract LEFT JOIN contract_parameter_type_1 as phone ON contract.id=phone.cid AND phone.pid=1 LEFT JOIN contract_parameter_type_2 as address ON contract.id=address.cid AND address.pid=3 LEFT JOIN contract_tariff on contract_tariff.cid = contract.id AND (contract_tariff.date1 <= ? OR contract_tariff.date1 is NULL) AND (contract_tariff.date2 >= ? OR contract_tariff.date2 is NULL) LEFT JOIN tariff_plan on contract_tariff.tpid= tariff_plan.id LEFT JOIN contract_parameter_type_1 as que ON contract.id=que.cid AND que.pid=1 LEFT JOIN address_house as house ON house.id=address.hid LEFT JOIN temp_balance ON temp_balance.cid=contract.id LEFT JOIN contract_balance as b ON b.cid=contract.id AND b.mm = temp_balance.mm AND b.yy = temp_balance.yy LEFT JOIN temp_status ON temp_status.cid=contract.id LEFT JOIN contract_status as status on status.cid = contract.id AND (status.date1 <= ? OR status.date1 is NULL) AND (status.date2 >= ? OR status.date2 is NULL) AND status.date1 = temp_status.date AND (status.status = 3 OR status.status = 4) LEFT JOIN temp_service ON temp_service.cid=contract.id LEFT JOIN contract_service as service on service.cid = contract.id AND (service.date1 <= ? OR service.date1 is NULL) AND (service.date2 >= ? OR service.date2 is NULL) AND service.date1 = temp_service.date AND service.sid = 1 LEFT JOIN contract_parameter_type_1 as mobile ON contract.id=mobile.cid AND mobile.pid=1 LEFT JOIN contract_service as serviceCer ON serviceCer.cid = contract.id AND serviceCer.sid = 1 WHERE 1=1 AND contract_tariff.tpid IN (6, 7, 8, 9, 10, 11, 12, 13) ORDER BY contract.title 04.03.2009 11:02:53 getting results 116 04.03.2009 11:03:08 SELECT contract.title, contract.comment, address.address, phone.val as phone_number, contract.status, tariff_plan.title as tariff, contract.date1 as date_start, contract.date2 as date_end, que.val as queue, (b.summa1 + b.summa2 - b.summa3 - b.summa4) as balance, status.date1 as statusDate, status.status as statusN, status.comment as reason, service.date1 as serviceDate, mobile.val as mobile_number, serviceCer.date1 as cerDate FROM contract LEFT JOIN contract_parameter_type_1 as phone ON contract.id=phone.cid AND phone.pid=1 LEFT JOIN contract_parameter_type_2 as address ON contract.id=address.cid AND address.pid=3 LEFT JOIN contract_tariff on contract_tariff.cid = contract.id AND (contract_tariff.date1 <= ? OR contract_tariff.date1 is NULL) AND (contract_tariff.date2 >= ? OR contract_tariff.date2 is NULL) LEFT JOIN tariff_plan on contract_tariff.tpid= tariff_plan.id LEFT JOIN contract_parameter_type_1 as que ON contract.id=que.cid AND que.pid=1 LEFT JOIN address_house as house ON house.id=address.hid LEFT JOIN temp_balance ON temp_balance.cid=contract.id LEFT JOIN contract_balance as b ON b.cid=contract.id AND b.mm = temp_balance.mm AND b.yy = temp_balance.yy LEFT JOIN temp_status ON temp_status.cid=contract.id LEFT JOIN contract_status as status on status.cid = contract.id AND (status.date1 <= ? OR status.date1 is NULL) AND (status.date2 >= ? OR status.date2 is NULL) AND status.date1 = temp_status.date AND (status.status = 3 OR status.status = 4) LEFT JOIN temp_service ON temp_service.cid=contract.id LEFT JOIN contract_service as service on service.cid = contract.id AND (service.date1 <= ? OR service.date1 is NULL) AND (service.date2 >= ? OR service.date2 is NULL) AND service.date1 = temp_service.date AND service.sid = 1 LEFT JOIN contract_parameter_type_1 as mobile ON contract.id=mobile.cid AND mobile.pid=1 LEFT JOIN contract_service as serviceCer ON serviceCer.cid = contract.id AND serviceCer.sid = 1 WHERE 1=1 AND contract_tariff.tpid IN (6, 7, 8, 9, 10, 11, 12, 13) ORDER BY contract.title 04.03.2009 11:03:08 getting results 114 А вообще задрали "кривые" обновления уже... Тестировать надо не на живых абонентах а на кроликах.

forum.bitel.ru http://forum.bitel.ru/

В клиенте не отображаются поинты, адреса http://forum.bitel.ru/viewtopic.php?f=22&t=1977	Страница 1 из 1

Автор:	skn [ 04 мар 2009, 13:44 ]
Заголовок сообщения:
обновляли только сервер и клиент? модули?

Автор:	SVK [ 04 мар 2009, 14:15 ]
Заголовок сообщения:
skn писал(а): обновляли только сервер и клиент? модули? ./bg_installer update на сервере скачивался только update_4_5.zip соответственно обновился только сервер и клиент.

Автор:	SVK [ 04 мар 2009, 15:56 ]
Заголовок сообщения:
skn писал(а): обновляли только сервер и клиент? модули? update такая фишка только на Vista, на XP все в порядке. принудительное обновление клиента не помогает. При попытка добавить адреса выскакивает ошибка. В логах пусто

Автор:	SVK [ 04 мар 2009, 16:12 ]
Заголовок сообщения:
update выбор даты из календаря не фурычет.

Автор:	skn [ 04 мар 2009, 17:19 ]
Заголовок сообщения:
1) а добавить где жмете в тулбаре или в свойствах? 2) с календарем была проблема при переходе на java6u12, но вроде исправили, у вас какая java и нет ли чего в лога клиента

Автор:	SVK [ 04 мар 2009, 17:27 ]
Заголовок сообщения:
skn писал(а): 1) а добавить где жмете в тулбаре или в свойствах? 2) с календарем была проблема при переходе на java6u12, но вроде исправили, у вас какая java и нет ли чего в лога клиента жму в свойствах, ява версия 12.

Автор:	skn [ 04 мар 2009, 17:32 ]
Заголовок сообщения:
1) что в логах клиента 2) есть ли возможность запустить под java6u11

Автор:	SVK [ 04 мар 2009, 17:34 ]
Заголовок сообщения:
skn писал(а): 1) что в логах клиента 2) есть ли возможность запустить под java6u11 в логах пусто. 11 явы нет. -- upd нашел, пробую

Автор:	skn [ 04 мар 2009, 17:37 ]
Заголовок сообщения:
запусти клиент start_debug.bat и выложите файл log

Автор:	SVK [ 04 мар 2009, 18:22 ]
Заголовок сообщения:
skn писал(а): SVK писал(а): дебаг сделать с 12? да Мыло в студию, не хочу светить клиентов и проч., пришлю дебаг.

Страница 1 из 1	Часовой пояс: UTC + 5 часов [ Летнее время ]
Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/

Автор:	SVK [ 04 мар 2009, 17:46 ]
Заголовок сообщения:
skn писал(а): запусти клиент start_debug.bat и выложите файл log 11 Ява - все работает. дебаг сделать с 12?

Автор:	skn [ 04 мар 2009, 17:59 ]
Заголовок сообщения:
SVK писал(а): дебаг сделать с 12? да

Автор:	SVK [ 04 мар 2009, 18:29 ]
Заголовок сообщения:
ушло

Автор:	skn [ 04 мар 2009, 20:31 ]
Заголовок сообщения:
Fixed. Проверьте.

Автор:	SVK [ 05 мар 2009, 09:14 ]
Заголовок сообщения:
skn писал(а): Fixed. Проверьте. Ушла ошибка, спасибо.