Here's the LOG part from trying to save:
First off the bat I see there is a problem with inserting into the crmentity table concerning smownerid. This is inserted as null, but I don't know how to change this, or if I should setup this up somewhere in my fields. I'm not even sure what this is, is it the current user?
Apart from that I don't know why the record ID is showed as '#######', and if this is the record ID for the module or the system-wide record ID.
It also says 'rolled back' at some point, but the row in the vtiger-exactonline table is still there. I'm really not sure on how to fix this.
Code:
2015-12-19T19:01:36+00:00 DEBUG root ######## Module --> ExactOnline :: Action --> Save :: UserID --> 6 :: RecordID --> #######
2015-12-19T19:01:36+00:00 DEBUG index Entering isPermitted(ExactOnline,Save,) method ...
2015-12-19T19:01:36+00:00 DEBUG index Exiting isPermitted method ...
2015-12-19T19:01:36+00:00 DEBUG root ########### Pemitted ---> yes ##############
2015-12-19T19:01:36+00:00 DEBUG index Entering getColumnFields(ExactOnline) method ...
2015-12-19T19:01:36+00:00 DEBUG index Entering getTabid(ExactOnline) method ...
2015-12-19T19:01:36+00:00 DEBUG index Exiting getTabid method ...
2015-12-19T19:01:36+00:00 DEBUG index Entering getTabid(ExactOnline) method ...
2015-12-19T19:01:36+00:00 DEBUG index Exiting getTabid method ...
2015-12-19T19:01:36+00:00 DEBUG index Prepared sql query being executed : SELECT tabid, fieldname, fieldid, fieldlabel, columnname, tablename, uitype, typeofdata, presence
FROM vtiger_field WHERE tabid in (?)
2015-12-19T19:01:36+00:00 DEBUG index Prepared sql query parameters : [66]
2015-12-19T19:01:36+00:00 DEBUG index Entering getTabid(ExactOnline) method ...
2015-12-19T19:01:36+00:00 DEBUG index Exiting getTabid method ...
2015-12-19T19:01:36+00:00 DEBUG index Exiting getColumnFields method ...
2015-12-19T19:01:36+00:00 DEBUG index Entering getTabid(ExactOnline) method ...
2015-12-19T19:01:36+00:00 DEBUG index Exiting getTabid method ...
2015-12-19T19:01:36+00:00 DEBUG index Prepared sql query being executed : SELECT 1 FROM vtiger_field WHERE uitype=69 and tabid = ?
2015-12-19T19:01:36+00:00 DEBUG index Prepared sql query parameters : [66]
2015-12-19T19:01:36+00:00 DEBUG index Entering setObjectValuesFromRequest(ExactOnline) method ...
2015-12-19T19:01:36+00:00 DEBUG index Prepared sql query being executed : SELECT handler_path, handler_class FROM vtiger_eventhandlers WHERE is_active=true AND event_name = ?
2015-12-19T19:01:36+00:00 DEBUG index Prepared sql query parameters : [corebos.filter.editview.setObjectValues]
2015-12-19T19:01:36+00:00 INFO VT PearDatabase ->ADODB fetchByAssoc return null
2015-12-19T19:01:36+00:00 DEBUG index Exiting setObjectValuesFromRequest method ...
2015-12-19T19:01:36+00:00 DEBUG index Prepared sql query being executed : SELECT handler_path, handler_class FROM vtiger_eventhandlers WHERE is_active=true AND event_name = ?
2015-12-19T19:01:36+00:00 DEBUG index Prepared sql query parameters : [corebos.filter.preSaveCheck]
2015-12-19T19:01:36+00:00 INFO VT PearDatabase ->ADODB fetchByAssoc return null
2015-12-19T19:01:36+00:00 DEBUG index module name is ExactOnline
2015-12-19T19:01:36+00:00 DEBUG index Prepared sql query being executed : select * from vtiger_fieldformulas where modulename=?
2015-12-19T19:01:36+00:00 DEBUG index Prepared sql query parameters : [ExactOnline]
2015-12-19T19:01:36+00:00 INFO VT PearDatabase ->TRANS saveentity starts ExactOnline
2015-12-19T19:01:36+00:00 INFO VT PearDatabase ->TRANS Started
2015-12-19T19:01:36+00:00 DEBUG index Prepared sql query being executed : select ownedby from vtiger_tab where name=?
2015-12-19T19:01:36+00:00 DEBUG index Prepared sql query parameters : [ExactOnline]
2015-12-19T19:01:36+00:00 DEBUG index Prepared sql query being executed : insert into vtiger_crmentity (crmid,smcreatorid,smownerid,setype,description,modifiedby,createdtime,modifiedtime) values(?,?,?,?,?,?,?,?)
2015-12-19T19:01:36+00:00 DEBUG index Prepared sql query parameters : [36096,6,,ExactOnline,,6,2015-12-19 19:01:36,2015-12-19 19:01:36]
2015-12-19T19:01:36+00:00 INFO VT PearDatabase ->ADODB error Query Failed:insert into vtiger_crmentity (crmid,smcreatorid,smownerid,setype,description,modifiedby,createdtime,modifiedtime) values(?,?,?,?,?,?,?,?)::->[1048]Column 'smownerid' cannot be null
2015-12-19T19:01:36+00:00 INFO index function insertIntoEntityTable ExactOnline vtiger_table name vtiger_exactonline
2015-12-19T19:01:36+00:00 DEBUG index Entering getTabid(ExactOnline) method ...
2015-12-19T19:01:36+00:00 DEBUG index Exiting getTabid method ...
2015-12-19T19:01:36+00:00 DEBUG index Prepared sql query being executed : select * from vtiger_field where tabid=? and tablename=? and displaytype in (1,3,4) and vtiger_field.presence in (0,2)
2015-12-19T19:01:36+00:00 DEBUG index Prepared sql query parameters : [66,vtiger_exactonline]
2015-12-19T19:01:36+00:00 DEBUG index Prepared sql query being executed : SELECT handler_path, handler_class FROM vtiger_eventhandlers WHERE is_active=true AND event_name = ?
2015-12-19T19:01:36+00:00 DEBUG index Prepared sql query parameters : [corebos.filter.ModuleSeqNumber.increment]
2015-12-19T19:01:36+00:00 INFO VT PearDatabase ->ADODB fetchByAssoc return null
2015-12-19T19:01:36+00:00 DEBUG index Prepared sql query being executed : select cur_id,prefix from vtiger_modentity_num where semodule=? and active = 1
2015-12-19T19:01:36+00:00 DEBUG index Prepared sql query parameters : [ExactOnline]
2015-12-19T19:01:36+00:00 DEBUG index Prepared sql query being executed : UPDATE vtiger_modentity_num SET cur_id=? where cur_id=? and active=1 AND semodule=?
2015-12-19T19:01:36+00:00 DEBUG index Prepared sql query parameters : [0000011,0000010,ExactOnline]
2015-12-19T19:01:36+00:00 DEBUG index Entering function get_column_value (exactrecordname, , exactrecordname, 3, V='')
2015-12-19T19:01:36+00:00 DEBUG index Exiting function get_column_value
2015-12-19T19:01:36+00:00 DEBUG index Prepared sql query being executed : insert into vtiger_exactonline(exactonlineid,exactrecordno,exactrecordname,exactonlinereturn) values(?,?,?,?)
2015-12-19T19:01:36+00:00 DEBUG index Prepared sql query parameters : [36096,EO-0000010,,TEST]
2015-12-19T19:01:36+00:00 INFO index function insertIntoEntityTable ExactOnline vtiger_table name vtiger_exactonlinecf
2015-12-19T19:01:36+00:00 DEBUG index Entering getTabid(ExactOnline) method ...
2015-12-19T19:01:36+00:00 DEBUG index Exiting getTabid method ...
2015-12-19T19:01:36+00:00 DEBUG index Prepared sql query being executed : select * from vtiger_field where tabid=? and tablename=? and displaytype in (1,3,4) and vtiger_field.presence in (0,2)
2015-12-19T19:01:36+00:00 DEBUG index Prepared sql query parameters : [66,vtiger_exactonlinecf]
2015-12-19T19:01:36+00:00 DEBUG index Prepared sql query being executed : insert into vtiger_exactonlinecf(exactonlineid) values(?)
2015-12-19T19:01:36+00:00 DEBUG index Prepared sql query parameters : [36096]
2015-12-19T19:01:36+00:00 INFO VT PearDatabase ->TRANS Rolled Back
2015-12-19T19:01:36+00:00 INFO VT PearDatabase ->TRANS Completed
2015-12-19T19:01:36+00:00 INFO VT PearDatabase ->TRANS saveentity ends
2015-12-19T19:01:36+00:00 DEBUG index Prepared sql query being executed : select setype from vtiger_crmentity where crmid=?
2015-12-19T19:01:36+00:00 DEBUG index Prepared sql query parameters : [36096]First off the bat I see there is a problem with inserting into the crmentity table concerning smownerid. This is inserted as null, but I don't know how to change this, or if I should setup this up somewhere in my fields. I'm not even sure what this is, is it the current user?
Apart from that I don't know why the record ID is showed as '#######', and if this is the record ID for the module or the system-wide record ID.
It also says 'rolled back' at some point, but the row in the vtiger-exactonline table is still there. I'm really not sure on how to fix this.