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

        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

Notice (8): Undefined index: summary [/home/pharma/website/releases/20120317114903/cakephp/app/common/controllers/deals_common_controller.php, line 61]

Code | Context

        $dealDetails = $this->Deal->find('first',array('conditions'=> array('Deal.uid' => $id),'fields'=> $fields));
        $this->set('title_for_layout', $this->name.': '.$dealDetails['Deal']['headline']);
        $this->pageDescription = $dealDetails['Deal']['headline'].' - '.$dealDetails['Deal']['summary'];

$id	=	"530903"
$fields	=	array(
	"Deal.uid",
	"Deal.headline",
	"Deal.slug"
)
$isPartneringtoolsSubscriber	=	false
$dealDetails	=	array(
	"Deal" => array(
	"uid" => "530903",
	"headline" => "SCOLR Pharma, Inc. Signs Agreement with The Emerson Group to Provide Sales Support for Nutritional & OTC Products",
	"slug" => "scolr-pharma-inc-signs-agreement-with-the-emerson-group-to-provide-sales-support-for-nutritional-otc-products"
),
	"Category" => array()
)

DealsCommonController::view() - /home/pharma/website/releases/20120317114903/cakephp/app/common/controllers/deals_common_controller.php, line 61
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - /home/pharma/website/releases/20120317114903/cakephp/webroot/pharmalicensing/index.php, line 107

Deals review

Deals review
Deal details

SCOLR Pharma, Inc. Signs Agreement with The Emerson Group to Provide Sales Support for Nutritional & OTC Products

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

SCOLR Pharma, Inc. Announces New Product Launch with Alliance Partner

SCOLR Pharma Secures Contract Manufacturer for Pseudoephedrine Tablets for Use in Q1 '05 Human Trials

SCOLR Pharma Secures Contract Manufacturer for Raloxifene Tablets to Use in Q2 '05 Human Trials

SCOLR Pharma Announces Research Collaboration with BioCryst Pharmaceuticals

SCOLR Pharma, Inc. and Dr. Reddy’s Laboratories Enter into Collaboration and License Agreement

SCOLR Pharma, Inc. Enters into Worldwide Licensing Agreement with RedHill Biopharma Ltd.

SCOLR Pharma secures contract manufacturer for 24 hour CDT Pseudoephedrine tablets

Omega Pharma acquires OTC organisations

Natrol, Inc. Enters into Joint Venture for China

More deals

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

(website) 45 queries took 644 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `story`	12	12	4
2	DESCRIBE `category`	14	14	2
3	DESCRIBE `categories_sites`	5	5	19
4	DESCRIBE `categorisation`	8	8	10
5	DESCRIBE `sites_stories`	5	5	1
6	DESCRIBE `sites`	5	5	12
7	DESCRIBE `user`	24	24	2
8	DESCRIBE `condet`	17	17	3
9	DESCRIBE `countrycode`	4	4	1
10	DESCRIBE `company`	27	27	4
11	DESCRIBE `person`	15	15	18
12	DESCRIBE `account`	29	29	7
13	DESCRIBE `product_legacy`	6	6	7
14	DESCRIBE `sales_people`	6	6	1
15	DESCRIBE `profile`	14	14	1
16	DESCRIBE `currencies`	7	7	6
17	DESCRIBE `update_rec`	7	7	6
18	DESCRIBE `dms_companies`	26	26	4
19	DESCRIBE `dms_releases`	10	10	3
20	DESCRIBE `dms_categories`	4	4	6
21	DESCRIBE `dms_clinical_areas`	4	4	7
22	DESCRIBE `dms_categories_dms_releases`	2	2	1
23	DESCRIBE `dms_clinical_areas_dms_releases`	2	2	2
24	DESCRIBE `dms_releases_sites`	5	5	2
25	DESCRIBE `licopp`	23	23	8
26	DESCRIBE `development_statuses`	5	5	5
27	DESCRIBE `licopps_sites`	3	3	4
28	DESCRIBE `service`	15	15	3
29	DESCRIBE `enquiry`	14	14	7
30	DESCRIBE `module_types`	6	6	4
31	DESCRIBE `press_release`	13	13	3
32	DESCRIBE `press_releases_sites`	5	5	8
33	DESCRIBE `story_assoc`	4	4	2
34	DESCRIBE `companies_sites`	3	3	5
35	DESCRIBE `categories_users`	2	2	1
36	DESCRIBE `authority`	3	3	5
37	DESCRIBE `sites_users`	5	5	2
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	11
39	SELECT `Deal`.`uid`, `Deal`.`headline`, `Deal`.`slug` FROM `story` AS `Deal` LEFT JOIN `sites_stories` AS `DealSite` ON (`DealSite`.`story_id` = `Deal`.`uid`) WHERE `DealSite`.`site_id` = 1 AND `Deal`.`uid` = '530903' LIMIT 1	1	1	1
40	SELECT `Category`.`uid`, `Category`.`name`, `Category`.`parent`, `Category`.`has_children`, `Category`.`show_children`, `Category`.`show_grandchildren`, `Category`.`members`, `Category`.`num_children`, `Category`.`root`, `Category`.`restricted`, `Category`.`clan`, `Category`.`lft`, `Category`.`rgt`, `Category`.`level`, `Categorisation`.`id`, `Categorisation`.`company_id`, `Categorisation`.`buysell`, `Categorisation`.`category_id`, `Categorisation`.`browse_category_id`, `Categorisation`.`cat_type`, `Categorisation`.`story_id`, `Categorisation`.`network_id` FROM `category` AS `Category` JOIN `categorisation` AS `Categorisation` ON (`Categorisation`.`story_id` = '530903' AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE `Categorisation`.`cat_type` = "S"	0	0	1
41	SELECT Deal.uid, Deal.headline, Deal.created, Deal.summary, Deal.slug, MATCH(Deal.headline, Deal.summary) AGAINST ("SCOLR Pharma, Inc. Signs Agreement with The Emerson Group to Provide Sales Support for Nutritional & OTC Products") AS score FROM story AS Deal WHERE MATCH(Deal.headline, Deal.summary) AGAINST ("SCOLR Pharma, Inc. Signs Agreement with The Emerson Group to Provide Sales Support for Nutritional & OTC Products") AND Deal.is_live = 1 AND Deal.uid != "530903" LIMIT 10	10	10	147
42	SELECT Category.uid, Category.parent, Category.root, Category.name, Category.level, Category.lft, CASE Category.root WHEN '560' THEN 0 WHEN '297' THEN 1 ELSE CASE Category.uid WHEN '560' THEN 0 WHEN '297' THEN 1 ELSE NULL END END AS root_order FROM category AS RootCategory LEFT JOIN categorisation AS Categorisation ON Categorisation.category_id=RootCategory.uid AND Categorisation.story_id='530903' AND Categorisation.cat_type='S' LEFT JOIN category AS Category ON (Category.lft <= RootCategory.lft AND Category.rgt >= RootCategory.rgt AND Category.level > 0) WHERE Categorisation.id IS NOT NULL AND RootCategory.root IN (560, 297) GROUP BY Category.uid ORDER BY root_order,lft	0	0	13
43	SELECT Deal.uid, Deal.slug, Deal.issued, Deal.headline, Deal.summary FROM story AS Deal WHERE Deal.is_live = 1 AND DATE(Deal.issued) <= DATE(now()) ORDER BY Deal.issued DESC LIMIT 5	5	5	2
44	SELECT `Deal`.`uid`, `Deal`.`issued`, `Deal`.`headline`, `Deal`.`slug` FROM `story` AS `Deal` LEFT JOIN `sites_stories` AS `DealSite` ON (`DealSite`.`story_id` = `Deal`.`uid`) WHERE `DealSite`.`site_id` = 1 AND `is_live` = 1 ORDER BY `Deal`.`viewed_counter` DESC, `Deal`.`issued` DESC LIMIT 5	5	5	246
45	UPDATE story SET viewed_counter = viewed_counter + 1 WHERE uid = "530903"	1		37

(website) 45 queries took 644 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 `Deal`.`uid`, `Deal`.`headline`, `Deal`.`slug` FROM `story` AS `Deal` LEFT JOIN `sites_stories` AS `DealSite` ON (`DealSite`.`story_id` = `Deal`.`uid`) WHERE `DealSite`.`site_id` = 1 AND `Deal`.`uid` = '530903' LIMIT 1

SELECT `Category`.`uid`, `Category`.`name`, `Category`.`parent`, `Category`.`has_children`, `Category`.`show_children`, `Category`.`show_grandchildren`, `Category`.`members`, `Category`.`num_children`, `Category`.`root`, `Category`.`restricted`, `Category`.`clan`, `Category`.`lft`, `Category`.`rgt`, `Category`.`level`, `Categorisation`.`id`, `Categorisation`.`company_id`, `Categorisation`.`buysell`, `Categorisation`.`category_id`, `Categorisation`.`browse_category_id`, `Categorisation`.`cat_type`, `Categorisation`.`story_id`, `Categorisation`.`network_id` FROM `category` AS `Category` JOIN `categorisation` AS `Categorisation` ON (`Categorisation`.`story_id` = '530903' AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE `Categorisation`.`cat_type` = "S"

SELECT Deal.uid, Deal.headline, Deal.created, Deal.summary, Deal.slug, MATCH(Deal.headline, Deal.summary) AGAINST ("SCOLR Pharma, Inc. Signs Agreement with The Emerson Group to Provide Sales Support for Nutritional & OTC Products") AS score FROM story AS Deal WHERE MATCH(Deal.headline, Deal.summary) AGAINST ("SCOLR Pharma, Inc. Signs Agreement with The Emerson Group to Provide Sales Support for Nutritional & OTC Products") AND Deal.is_live = 1 AND Deal.uid != "530903" LIMIT 10

147

SELECT Category.uid, Category.parent, Category.root, Category.name, Category.level, Category.lft, CASE Category.root WHEN '560' THEN 0 WHEN '297' THEN 1 ELSE CASE Category.uid WHEN '560' THEN 0 WHEN '297' THEN 1 ELSE NULL END END AS root_order FROM category AS RootCategory LEFT JOIN categorisation AS Categorisation ON Categorisation.category_id=RootCategory.uid AND Categorisation.story_id='530903' AND Categorisation.cat_type='S' LEFT JOIN category AS Category ON (Category.lft <= RootCategory.lft AND Category.rgt >= RootCategory.rgt AND Category.level > 0) WHERE Categorisation.id IS NOT NULL AND RootCategory.root IN (560, 297) GROUP BY Category.uid ORDER BY root_order,lft

SELECT Deal.uid, Deal.slug, Deal.issued, Deal.headline, Deal.summary FROM story AS Deal WHERE Deal.is_live = 1 AND DATE(Deal.issued) <= DATE(now()) ORDER BY Deal.issued DESC LIMIT 5

SELECT `Deal`.`uid`, `Deal`.`issued`, `Deal`.`headline`, `Deal`.`slug` FROM `story` AS `Deal` LEFT JOIN `sites_stories` AS `DealSite` ON (`DealSite`.`story_id` = `Deal`.`uid`) WHERE `DealSite`.`site_id` = 1 AND `is_live` = 1 ORDER BY `Deal`.`viewed_counter` DESC, `Deal`.`issued` DESC LIMIT 5

246

UPDATE story SET viewed_counter = viewed_counter + 1 WHERE uid = "530903"

Deals review

SCOLR Pharma, Inc. Signs Agreement with The Emerson Group to Provide Sales Support for Nutritional & OTC Products

Related deals

More deals

Latest deals

Most viewed deals

By month