[Vtigercrm-developers] Error When Adding a New Services Record

[Jan Pisula]

Thats bug in vtiger 6.1 after fresh install – absent vtiger_service table

Try:


CREATE TABLE IF NOT EXISTS `vtiger_service` (
`serviceid` int(11) NOT NULL,
`service_no` varchar(100) NOT NULL,
`servicename` varchar(50) NOT NULL,
`servicecategory` varchar(200) DEFAULT NULL,
`qty_per_unit` decimal(11,2) DEFAULT '0.00',
`unit_price` decimal(25,8) DEFAULT NULL,
`sales_start_date` date DEFAULT NULL,
`sales_end_date` date DEFAULT NULL,
`start_date` date DEFAULT NULL,
`expiry_date` date DEFAULT NULL,
`discontinued` int(1) NOT NULL DEFAULT '0',
`service_usageunit` varchar(200) DEFAULT NULL,
`website` varchar(100) DEFAULT NULL,
`taxclass` varchar(200) DEFAULT NULL,
`currency_id` int(19) NOT NULL DEFAULT '1',
`commissionrate` decimal(7,3) DEFAULT NULL,
PRIMARY KEY (`serviceid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

 

Jan Pisula

www.netinteractive.pl <http://www.netinteractive.pl>  

 

From: vtigercrm-developers-bounces at lists.vtigercrm.com [mailto:vtigercrm-developers-bounces at lists.vtigercrm.com] On Behalf Of Conrado Maggi
Sent: Sunday, November 16, 2014 4:22 PM
To: vtigercrm-developers
Subject: Re: [Vtigercrm-developers] Error When Adding a New Services Record

 

You should enable the debug by following: https://wiki.vtiger.com/index.php/Developer_Debug_Techniques

 

That seems like a database error. Duplicate field, or similar.

 

Regards,

 

On Sat, Nov 15, 2014 at 11:32 PM, Rebecca Stanek <rlstanek at gmail.com <mailto:rlstanek at gmail.com> > wrote:

In trying to create a new Services record upon "save" the following error message is given:

 

{"success":false,"error":{"code":"result is not an object","message":"result is not an object"}}
Thanks.


_______________________________________________
http://www.vtiger.com/

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20141116/0242da43/attachment.html>