09-23-2016, 06:12 PM
Hi,
got an old vt5.4 installation and yesterday i decided to migrate it to corebos
i just updated the code and apply all cbupdaters
when configuring the portal , i got always given user is not found
after debugging and research, i finally found that the vtiger_ws_operation and vtiger_ws_operation_parameters was not updated
i then applied the following sql : (the 2 updates are just only to keep old values, i think you can empty the tables first then insert the correct records)
update `vtiger_ws_operation` set operationid = operationid+1000;
update `vtiger_ws_operation_parameters` set operationid = operationid+1000;
INSERT INTO `vtiger_ws_operation` VALUES (1,'login','include/Webservices/Login.php','vtws_login','POST',1),(2,'retrieve','include/Webservices/Retrieve.php','vtws_retrieve','GET',0),(3,'create','include/Webservices/Create.php','vtws_create','POST',0),(4,'update','include/Webservices/Update.php','vtws_update','POST',0),(5,'delete','include/Webservices/Delete.php','vtws_delete','POST',0),(6,'sync','include/Webservices/GetUpdates.php','vtws_sync','GET',0),(7,'query','include/Webservices/Query.php','vtws_query','GET',0),(8,'logout','include/Webservices/Logout.php','vtws_logout','POST',0),(9,'listtypes','include/Webservices/ModuleTypes.php','vtws_listtypes','GET',0),(10,'getchallenge','include/Webservices/AuthToken.php','vtws_getchallenge','GET',1),(11,'describe','include/Webservices/DescribeObject.php','vtws_describe','GET',0),(12,'extendsession','include/Webservices/ExtendSession.php','vtws_extendSession','POST',1),(13,'convertlead','include/Webservices/ConvertLead.php','vtws_convertlead','POST',0),(14,'revise','include/Webservices/Revise.php','vtws_revise','POST',0),(15,'changePassword','include/Webservices/ChangePassword.php','vtws_changePassword','POST',0),(16,'deleteUser','include/Webservices/DeleteUser.php','vtws_deleteUser','POST',0),(17,'mobile.fetchallalerts','modules/Mobile/api/wsapi.php','mobile_ws_fetchAllAlerts','POST',0),(18,'mobile.alertdetailswithmessage','modules/Mobile/api/wsapi.php','mobile_ws_alertDetailsWithMessage','POST',0),(19,'mobile.fetchmodulefilters','modules/Mobile/api/wsapi.php','mobile_ws_fetchModuleFilters','POST',0),(20,'mobile.fetchrecord','modules/Mobile/api/wsapi.php','mobile_ws_fetchRecord','POST',0),(21,'mobile.fetchrecordwithgrouping','modules/Mobile/api/wsapi.php','mobile_ws_fetchRecordWithGrouping','POST',0),(22,'mobile.filterdetailswithcount','modules/Mobile/api/wsapi.php','mobile_ws_filterDetailsWithCount','POST',0),(23,'mobile.listmodulerecords','modules/Mobile/api/wsapi.php','mobile_ws_listModuleRecords','POST',0),(24,'mobile.saverecord','modules/Mobile/api/wsapi.php','mobile_ws_saveRecord','POST',0),(25,'mobile.syncModuleRecords','modules/Mobile/api/wsapi.php','mobile_ws_syncModuleRecords','POST',0),(26,'mobile.query','modules/Mobile/api/wsapi.php','mobile_ws_query','POST',0),(27,'mobile.querywithgrouping','modules/Mobile/api/wsapi.php','mobile_ws_queryWithGrouping','POST',0),(28,'wsapp_register','modules/WSAPP/api/ws/Register.php','wsapp_register','POST',0),(29,'wsapp_deregister','modules/WSAPP/api/ws/DeRegister.php','wsapp_deregister','POST',0),(30,'wsapp_get','modules/WSAPP/api/ws/Get.php','wsapp_get','POST',0),(31,'wsapp_put','modules/WSAPP/api/ws/Put.php','wsapp_put','POST',0),(32,'wsapp_map','modules/WSAPP/api/ws/Map.php','wsapp_map','POST',0),(33,'authenticateContact','include/Webservices/CustomerPortalWS.php','vtws_AuthenticateContact','POST',0),(34,'changePortalUserPassword','include/Webservices/CustomerPortalWS.php','vtws_changePortalUserPassword','POST',0),(35,'getPortalUserDateFormat','include/Webservices/CustomerPortalWS.php','vtws_getPortalUserDateFormat','POST',0),(36,'getPortalUserInfo','include/Webservices/CustomerPortalWS.php','vtws_getPortalUserInfo','POST',0),(37,'vtyiicpng_getWSEntityId','include/Webservices/CustomerPortalWS.php','vtyiicpng_getWSEntityId','POST',0),(38,'getReferenceValue','include/Webservices/CustomerPortalWS.php','vtws_getReferenceValue','POST',0),(39,'getSearchResults','include/Webservices/CustomerPortalWS.php','vtws_getSearchResults','POST',0),(40,'loginPortal','include/Webservices/LoginPortal.php','vtws_loginportal','GET',1),(41,'addTicketFaqComment','include/Webservices/addTicketFaqComment.php','vtws_addTicketFaqComment','POST',0),(42,'findByPortalUserName','include/Webservices/CustomerPortalWS.php','vtws_findByPortalUserName','POST',0),(43,'getfilterfields','include/Webservices/GetFilterFields.php','vtws_getfilterfields','POST',0),(44,'getPicklistValues','include/Webservices/CustomerPortalWS.php','vtws_getPicklistValues','POST',0),(45,'gettranslation','include/Webservices/GetTranslation.php','vtws_gettranslation','POST',0),(46,'getUItype','include/Webservices/CustomerPortalWS.php','vtws_getUItype','POST',0),(47,'getUsersInSameGroup','include/Webservices/CustomerPortalWS.php','vtws_getUsersInTheSameGroup','POST',0),(48,'getEntityNum','include/Webservices/getentitynum.php','vtws_get_entitynum','POST',0),(49,'sendRecoverPassword','include/Webservices/CustomerPortalWS.php','vtws_sendRecoverPassword','POST',0),(50,'retrievedocattachment','include/Webservices/RetrieveDocAttachment.php','vtws_retrievedocattachment','POST',0),(51,'getpdfdata','include/Webservices/GetPDFData.php','cbws_getpdfdata','POST',0),(52,'getRelatedRecords','include/Webservices/GetRelatedRecords.php','getRelatedRecords','POST',0),(53,'SetRelation','include/Webservices/SetRelation.php','vtws_setrelation','POST',0),(54,'getAssignedUserList','include/Webservices/CustomerPortalWS.php','vtws_getAssignedUserList','GET',0),(55,'getFieldAutocomplete','include/Webservices/CustomerPortalWS.php','getFieldAutocomplete','GET',0),(56,'getMaxLoadSize','include/Webservices/getmaxloadsize.php','get_maxloadsize','POST',0),(57,'getReferenceAutocomplete','include/Webservices/CustomerPortalWS.php','getReferenceAutocomplete','GET',0),(58,'SearchGlobalVar','modules/GlobalVariable/SearchGlobalVarws.php','cbws_SearchGlobalVar','GET',0);
INSERT INTO `vtiger_ws_operation_parameters` VALUES (1,'accessKey','String',2),(1,'username','String',1),(2,'id','String',1),(3,'element','encoded',2),(3,'elementType','String',1),(4,'element','encoded',1),(5,'id','String',1),(6,'elementType','String',2),(6,'modifiedTime','DateTime',1),(7,'query','String',1),(8,'sessionName','String',1),(9,'fieldTypeList','encoded',1),(10,'username','String',1),(11,'elementType','String',1),(13,'element','encoded',1),(14,'element','Encoded',1),(15,'confirmPassword','String',4),(15,'id','String',1),(15,'newPassword','String',3),(15,'oldPassword','String',2),(16,'id','String',1),(16,'newOwnerId','String',2),(18,'alertid','string',1),(19,'module','string',1),(20,'record','string',1),(21,'record','string',1),(22,'filterid','string',1),(23,'elements','encoded',1),(24,'module','string',1),(24,'record','string',2),(24,'values','encoded',3),(25,'module','string',1),(25,'page','string',3),(25,'syncToken','string',2),(26,'module','string',1),(26,'page','string',3),(26,'query','string',2),(27,'module','string',1),(27,'page','string',3),(27,'query','string',2),(28,'synctype','string',2),(28,'type','string',1),(29,'key','string',2),(29,'type','string',1),(30,'key','string',1),(30,'module','string',2),(30,'token','string',3),(31,'element','encoded',2),(31,'key','string',1),(32,'element','encoded',2),(32,'key','string',1),(33,'email','string',1),(33,'password','string',2),(34,'email','String',1),(34,'password','String',2),(37,'entityName','String',1),(38,'id','String',1),(39,'query','string',1),(39,'restrictionids','encoded',3),(39,'search_onlyin','string',2),(40,'password','string',2),(40,'username','string',1),(41,'id','string',1),(41,'values','encoded',2),(42,'username','string',1),(43,'module','string',1),(44,'module','string',1),(45,'language','string',2),(45,'module','string',3),(45,'totranslate','encoded',1),(46,'module','string',1),(47,'id','string',1),(49,'username','string',1),(50,'id','string',1),(50,'returnfile','string',2),(51,'id','String',1),(52,'id','String',1),(52,'module','String',2),(52,'queryParameters','encoded',4),(52,'relatedModule','String',3),(53,'relate_this_id','String',1),(53,'with_these_ids','encoded',2),(54,'module','string',1),(55,'fields','String',4),(55,'filter','String',2),(55,'limit','String',6),(55,'returnfields','String',5),(55,'searchinmodule','String',3),(55,'term','String',1),(57,'filter','String',2),(57,'limit','String',4),(57,'searchinmodules','String',3),(57,'term','String',1),(58,'defaultvalue','string',2),(58,'gvmodule','string',3),(58,'gvname','string',1);
got an old vt5.4 installation and yesterday i decided to migrate it to corebos
i just updated the code and apply all cbupdaters
when configuring the portal , i got always given user is not found
after debugging and research, i finally found that the vtiger_ws_operation and vtiger_ws_operation_parameters was not updated
i then applied the following sql : (the 2 updates are just only to keep old values, i think you can empty the tables first then insert the correct records)
update `vtiger_ws_operation` set operationid = operationid+1000;
update `vtiger_ws_operation_parameters` set operationid = operationid+1000;
INSERT INTO `vtiger_ws_operation` VALUES (1,'login','include/Webservices/Login.php','vtws_login','POST',1),(2,'retrieve','include/Webservices/Retrieve.php','vtws_retrieve','GET',0),(3,'create','include/Webservices/Create.php','vtws_create','POST',0),(4,'update','include/Webservices/Update.php','vtws_update','POST',0),(5,'delete','include/Webservices/Delete.php','vtws_delete','POST',0),(6,'sync','include/Webservices/GetUpdates.php','vtws_sync','GET',0),(7,'query','include/Webservices/Query.php','vtws_query','GET',0),(8,'logout','include/Webservices/Logout.php','vtws_logout','POST',0),(9,'listtypes','include/Webservices/ModuleTypes.php','vtws_listtypes','GET',0),(10,'getchallenge','include/Webservices/AuthToken.php','vtws_getchallenge','GET',1),(11,'describe','include/Webservices/DescribeObject.php','vtws_describe','GET',0),(12,'extendsession','include/Webservices/ExtendSession.php','vtws_extendSession','POST',1),(13,'convertlead','include/Webservices/ConvertLead.php','vtws_convertlead','POST',0),(14,'revise','include/Webservices/Revise.php','vtws_revise','POST',0),(15,'changePassword','include/Webservices/ChangePassword.php','vtws_changePassword','POST',0),(16,'deleteUser','include/Webservices/DeleteUser.php','vtws_deleteUser','POST',0),(17,'mobile.fetchallalerts','modules/Mobile/api/wsapi.php','mobile_ws_fetchAllAlerts','POST',0),(18,'mobile.alertdetailswithmessage','modules/Mobile/api/wsapi.php','mobile_ws_alertDetailsWithMessage','POST',0),(19,'mobile.fetchmodulefilters','modules/Mobile/api/wsapi.php','mobile_ws_fetchModuleFilters','POST',0),(20,'mobile.fetchrecord','modules/Mobile/api/wsapi.php','mobile_ws_fetchRecord','POST',0),(21,'mobile.fetchrecordwithgrouping','modules/Mobile/api/wsapi.php','mobile_ws_fetchRecordWithGrouping','POST',0),(22,'mobile.filterdetailswithcount','modules/Mobile/api/wsapi.php','mobile_ws_filterDetailsWithCount','POST',0),(23,'mobile.listmodulerecords','modules/Mobile/api/wsapi.php','mobile_ws_listModuleRecords','POST',0),(24,'mobile.saverecord','modules/Mobile/api/wsapi.php','mobile_ws_saveRecord','POST',0),(25,'mobile.syncModuleRecords','modules/Mobile/api/wsapi.php','mobile_ws_syncModuleRecords','POST',0),(26,'mobile.query','modules/Mobile/api/wsapi.php','mobile_ws_query','POST',0),(27,'mobile.querywithgrouping','modules/Mobile/api/wsapi.php','mobile_ws_queryWithGrouping','POST',0),(28,'wsapp_register','modules/WSAPP/api/ws/Register.php','wsapp_register','POST',0),(29,'wsapp_deregister','modules/WSAPP/api/ws/DeRegister.php','wsapp_deregister','POST',0),(30,'wsapp_get','modules/WSAPP/api/ws/Get.php','wsapp_get','POST',0),(31,'wsapp_put','modules/WSAPP/api/ws/Put.php','wsapp_put','POST',0),(32,'wsapp_map','modules/WSAPP/api/ws/Map.php','wsapp_map','POST',0),(33,'authenticateContact','include/Webservices/CustomerPortalWS.php','vtws_AuthenticateContact','POST',0),(34,'changePortalUserPassword','include/Webservices/CustomerPortalWS.php','vtws_changePortalUserPassword','POST',0),(35,'getPortalUserDateFormat','include/Webservices/CustomerPortalWS.php','vtws_getPortalUserDateFormat','POST',0),(36,'getPortalUserInfo','include/Webservices/CustomerPortalWS.php','vtws_getPortalUserInfo','POST',0),(37,'vtyiicpng_getWSEntityId','include/Webservices/CustomerPortalWS.php','vtyiicpng_getWSEntityId','POST',0),(38,'getReferenceValue','include/Webservices/CustomerPortalWS.php','vtws_getReferenceValue','POST',0),(39,'getSearchResults','include/Webservices/CustomerPortalWS.php','vtws_getSearchResults','POST',0),(40,'loginPortal','include/Webservices/LoginPortal.php','vtws_loginportal','GET',1),(41,'addTicketFaqComment','include/Webservices/addTicketFaqComment.php','vtws_addTicketFaqComment','POST',0),(42,'findByPortalUserName','include/Webservices/CustomerPortalWS.php','vtws_findByPortalUserName','POST',0),(43,'getfilterfields','include/Webservices/GetFilterFields.php','vtws_getfilterfields','POST',0),(44,'getPicklistValues','include/Webservices/CustomerPortalWS.php','vtws_getPicklistValues','POST',0),(45,'gettranslation','include/Webservices/GetTranslation.php','vtws_gettranslation','POST',0),(46,'getUItype','include/Webservices/CustomerPortalWS.php','vtws_getUItype','POST',0),(47,'getUsersInSameGroup','include/Webservices/CustomerPortalWS.php','vtws_getUsersInTheSameGroup','POST',0),(48,'getEntityNum','include/Webservices/getentitynum.php','vtws_get_entitynum','POST',0),(49,'sendRecoverPassword','include/Webservices/CustomerPortalWS.php','vtws_sendRecoverPassword','POST',0),(50,'retrievedocattachment','include/Webservices/RetrieveDocAttachment.php','vtws_retrievedocattachment','POST',0),(51,'getpdfdata','include/Webservices/GetPDFData.php','cbws_getpdfdata','POST',0),(52,'getRelatedRecords','include/Webservices/GetRelatedRecords.php','getRelatedRecords','POST',0),(53,'SetRelation','include/Webservices/SetRelation.php','vtws_setrelation','POST',0),(54,'getAssignedUserList','include/Webservices/CustomerPortalWS.php','vtws_getAssignedUserList','GET',0),(55,'getFieldAutocomplete','include/Webservices/CustomerPortalWS.php','getFieldAutocomplete','GET',0),(56,'getMaxLoadSize','include/Webservices/getmaxloadsize.php','get_maxloadsize','POST',0),(57,'getReferenceAutocomplete','include/Webservices/CustomerPortalWS.php','getReferenceAutocomplete','GET',0),(58,'SearchGlobalVar','modules/GlobalVariable/SearchGlobalVarws.php','cbws_SearchGlobalVar','GET',0);
INSERT INTO `vtiger_ws_operation_parameters` VALUES (1,'accessKey','String',2),(1,'username','String',1),(2,'id','String',1),(3,'element','encoded',2),(3,'elementType','String',1),(4,'element','encoded',1),(5,'id','String',1),(6,'elementType','String',2),(6,'modifiedTime','DateTime',1),(7,'query','String',1),(8,'sessionName','String',1),(9,'fieldTypeList','encoded',1),(10,'username','String',1),(11,'elementType','String',1),(13,'element','encoded',1),(14,'element','Encoded',1),(15,'confirmPassword','String',4),(15,'id','String',1),(15,'newPassword','String',3),(15,'oldPassword','String',2),(16,'id','String',1),(16,'newOwnerId','String',2),(18,'alertid','string',1),(19,'module','string',1),(20,'record','string',1),(21,'record','string',1),(22,'filterid','string',1),(23,'elements','encoded',1),(24,'module','string',1),(24,'record','string',2),(24,'values','encoded',3),(25,'module','string',1),(25,'page','string',3),(25,'syncToken','string',2),(26,'module','string',1),(26,'page','string',3),(26,'query','string',2),(27,'module','string',1),(27,'page','string',3),(27,'query','string',2),(28,'synctype','string',2),(28,'type','string',1),(29,'key','string',2),(29,'type','string',1),(30,'key','string',1),(30,'module','string',2),(30,'token','string',3),(31,'element','encoded',2),(31,'key','string',1),(32,'element','encoded',2),(32,'key','string',1),(33,'email','string',1),(33,'password','string',2),(34,'email','String',1),(34,'password','String',2),(37,'entityName','String',1),(38,'id','String',1),(39,'query','string',1),(39,'restrictionids','encoded',3),(39,'search_onlyin','string',2),(40,'password','string',2),(40,'username','string',1),(41,'id','string',1),(41,'values','encoded',2),(42,'username','string',1),(43,'module','string',1),(44,'module','string',1),(45,'language','string',2),(45,'module','string',3),(45,'totranslate','encoded',1),(46,'module','string',1),(47,'id','string',1),(49,'username','string',1),(50,'id','string',1),(50,'returnfile','string',2),(51,'id','String',1),(52,'id','String',1),(52,'module','String',2),(52,'queryParameters','encoded',4),(52,'relatedModule','String',3),(53,'relate_this_id','String',1),(53,'with_these_ids','encoded',2),(54,'module','string',1),(55,'fields','String',4),(55,'filter','String',2),(55,'limit','String',6),(55,'returnfields','String',5),(55,'searchinmodule','String',3),(55,'term','String',1),(57,'filter','String',2),(57,'limit','String',4),(57,'searchinmodules','String',3),(57,'term','String',1),(58,'defaultvalue','string',2),(58,'gvmodule','string',3),(58,'gvname','string',1);
