Deals review

Warning (512): /home/pharma/website/current/cakephp/app/pharmalicensing/tmp/cache/ is not writable [CORE/cake/libs/cache/file.php, line 267]

Code

        if ($this->_init && !is_writable($this->settings['path'])) {
            $this->_init = false;
            trigger_error(sprintf(__('%s is not writable', true), $this->settings['path']), E_USER_WARNING);

FileEngine::__active() - CORE/cake/libs/cache/file.php, line 267
FileEngine::init() - CORE/cake/libs/cache/file.php, line 94
Cache::_buildEngine() - CORE/cake/libs/cache.php, line 151
Cache::config() - CORE/cake/libs/cache.php, line 126
include - /home/pharma/website/releases/20120317114903/cakephp/app/pharmalicensing/config/core.php, line 345
Configure::__loadBootstrap() - CORE/cake/libs/configure.php, line 391
Configure::getInstance() - CORE/cake/libs/configure.php, line 52
include - CORE/cake/bootstrap.php, line 38
[main] - /home/pharma/website/releases/20120317114903/cakephp/webroot/pharmalicensing/index.php, line 100

Deals review

Deals review
17th April 2012 to 17th May 2012

Deals

In order to access this content you must be logged in and have a subscription to Pharmalicensing Intelligence.

Pharmalicensing Intelligence is a one-stop environment for time-conscious executives. Keeping you abreast of the latest developments in the life sciences industry, saving you time and money when you need it most.

Subscribe now for instant access to the benefits Pharmalicensing Intelligence has to offer. Find out more.

Request a demo of
Pharmalicensing Intelligence

Products:	Partnering Search	Company Profiling	Pharmalicensing Intelligence	Reports	Comparision
In-licensing:	Latest records	Industry Sector	Therapeutic Target	Search	Profile your company	Pharma partnering
Out-licensing:	Latest records	Industry Sector	Therapeutic Target	Search	Profile your company	Pharma partnering
Companies:	Profiled companies	Industry Sector	Therapeutic Target	Geographic Location	Search	Add your company
Reports:	Biotechnology	Business Development	Management	Market & Sales	Medical Devices	Pharmaceuticals
News:	Deals & Alliances	Development	Financial Results	Financings	Intellectual Property	Regulatory
Events:	Pharma events	Calendar	Organizers	Featured events	Search
Articles:	Industrial Sector	Therapeutic Target	Articles date
Deals:	Industry Sector	Therapeutic Target	Deals Date	Search	Reports	Press releases
About us:	Our Audience	Case Studies	Newsletter	FAQ	Contact us	Site map

Products:

Partnering Search

Company Profiling

Pharmalicensing Intelligence

Intellectual Property

(website) 40 queries took 4263 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `story`	12	12	18
2	DESCRIBE `category`	14	14	1
3	DESCRIBE `categories_sites`	5	5	3
4	DESCRIBE `categorisation`	8	8	1
5	DESCRIBE `sites_stories`	5	5	1
6	DESCRIBE `sites`	5	5	1
7	DESCRIBE `user`	24	24	2
8	DESCRIBE `condet`	17	17	2
9	DESCRIBE `countrycode`	4	4	1
10	DESCRIBE `company`	27	27	2
11	DESCRIBE `person`	15	15	1
12	DESCRIBE `account`	29	29	1
13	DESCRIBE `product_legacy`	6	6	1
14	DESCRIBE `sales_people`	6	6	1
15	DESCRIBE `profile`	14	14	1
16	DESCRIBE `currencies`	7	7	1
17	DESCRIBE `update_rec`	7	7	1
18	DESCRIBE `dms_companies`	26	26	1
19	DESCRIBE `dms_releases`	10	10	1
20	DESCRIBE `dms_categories`	4	4	1
21	DESCRIBE `dms_clinical_areas`	4	4	1
22	DESCRIBE `dms_categories_dms_releases`	2	2	2
23	DESCRIBE `dms_clinical_areas_dms_releases`	2	2	1
24	DESCRIBE `dms_releases_sites`	5	5	4
25	DESCRIBE `licopp`	23	23	1
26	DESCRIBE `development_statuses`	5	5	0
27	DESCRIBE `licopps_sites`	3	3	1
28	DESCRIBE `service`	15	15	1
29	DESCRIBE `enquiry`	14	14	1
30	DESCRIBE `module_types`	6	6	1
31	DESCRIBE `press_release`	13	13	1
32	DESCRIBE `press_releases_sites`	5	5	1
33	DESCRIBE `story_assoc`	4	4	1
34	DESCRIBE `companies_sites`	3	3	4
35	DESCRIBE `categories_users`	2	2	1
36	DESCRIBE `authority`	3	3	1
37	DESCRIBE `sites_users`	5	5	1
38	SELECT `Site`.`id`, `Site`.`name`, `Site`.`email_domain`, `Site`.`short_name`, `Site`.`brand` FROM `sites` AS `Site` WHERE `Site`.`id` = 1 LIMIT 1	1	1	0
39	SELECT COUNT(*) AS `count` FROM `story` AS `Deal` LEFT JOIN `sites_stories` AS `DealSite` ON (`DealSite`.`story_id` = `Deal`.`uid`) WHERE `DealSite`.`site_id` = 1 AND (DATE(`Deal`.`issued`) BETWEEN "2012-04-17" AND "2012-05-17") AND is_live=1	1	1	3119
40	SELECT `Deal`.`uid`, `Deal`.`slug`, `Deal`.`created`, `Deal`.`lastmod`, `Deal`.`issued`, `Deal`.`author`, `Deal`.`author_email`, `Deal`.`headline`, `Deal`.`summary`, `Deal`.`body`, `Deal`.`is_live`, `Deal`.`viewed_counter`, `DealSite`.`id`, `DealSite`.`story_id`, `DealSite`.`created`, `DealSite`.`modified`, `DealSite`.`site_id` FROM `story` AS `Deal` LEFT JOIN `sites_stories` AS `DealSite` ON (`DealSite`.`story_id` = `Deal`.`uid`) WHERE `DealSite`.`site_id` = 1 AND (DATE(`Deal`.`issued`) BETWEEN "2012-04-17" AND "2012-05-17") AND is_live=1 ORDER BY `Deal`.`headline` ASC LIMIT 10	0	0	1079

(website) 40 queries took 4263 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `story`

DESCRIBE `category`

DESCRIBE `categories_sites`

DESCRIBE `categorisation`

DESCRIBE `sites_stories`

DESCRIBE `sites`

DESCRIBE `user`

DESCRIBE `condet`

DESCRIBE `countrycode`

DESCRIBE `company`

DESCRIBE `person`

DESCRIBE `account`

DESCRIBE `product_legacy`

DESCRIBE `sales_people`

DESCRIBE `profile`

DESCRIBE `currencies`

DESCRIBE `update_rec`

DESCRIBE `dms_companies`

DESCRIBE `dms_releases`

DESCRIBE `dms_categories`

DESCRIBE `dms_clinical_areas`

DESCRIBE `dms_categories_dms_releases`

DESCRIBE `dms_clinical_areas_dms_releases`

DESCRIBE `dms_releases_sites`

DESCRIBE `licopp`

DESCRIBE `development_statuses`

DESCRIBE `licopps_sites`

DESCRIBE `service`

DESCRIBE `enquiry`

DESCRIBE `module_types`

DESCRIBE `press_release`

DESCRIBE `press_releases_sites`

DESCRIBE `story_assoc`

DESCRIBE `companies_sites`

DESCRIBE `categories_users`

DESCRIBE `authority`

DESCRIBE `sites_users`

SELECT `Site`.`id`, `Site`.`name`, `Site`.`email_domain`, `Site`.`short_name`, `Site`.`brand` FROM `sites` AS `Site` WHERE `Site`.`id` = 1 LIMIT 1

SELECT COUNT(*) AS `count` FROM `story` AS `Deal` LEFT JOIN `sites_stories` AS `DealSite` ON (`DealSite`.`story_id` = `Deal`.`uid`) WHERE `DealSite`.`site_id` = 1 AND (DATE(`Deal`.`issued`) BETWEEN "2012-04-17" AND "2012-05-17") AND is_live=1

3119

SELECT `Deal`.`uid`, `Deal`.`slug`, `Deal`.`created`, `Deal`.`lastmod`, `Deal`.`issued`, `Deal`.`author`, `Deal`.`author_email`, `Deal`.`headline`, `Deal`.`summary`, `Deal`.`body`, `Deal`.`is_live`, `Deal`.`viewed_counter`, `DealSite`.`id`, `DealSite`.`story_id`, `DealSite`.`created`, `DealSite`.`modified`, `DealSite`.`site_id` FROM `story` AS `Deal` LEFT JOIN `sites_stories` AS `DealSite` ON (`DealSite`.`story_id` = `Deal`.`uid`) WHERE `DealSite`.`site_id` = 1 AND (DATE(`Deal`.`issued`) BETWEEN "2012-04-17" AND "2012-05-17") AND is_live=1 ORDER BY `Deal`.`headline` ASC LIMIT 10

1079