Jump to content
X2Community Forums


  • Content Count

  • Joined

  • Last visited

  • Days Won


robert.keir last won the day on April 29 2019

robert.keir had the most liked content!

Community Reputation

7 Neutral

About robert.keir

  • Rank
    Advanced Member
  1. After updating a lead we get this error. Anyone know what this is about? Error Code: 500Error Message: CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'myagcovr_x2343.x2_actions.complete' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_byStack Trace: [click to toggle display]X2Engine Version: 7.1PHP Version: 7.3.33
  2. I've put it into the view.php and does not work. Do you perhaps have line number where I can put it?
  3. Hi All, Is there a way to protect the CRM from users from "Copy and Paste" from X2Leads and Contacts into a spreadsheet? I've found this code: ================ <script type="text/javascript" src="//ajax.googleapis.com/ajax/libs/jquery/1/jquery.min.js"></script> <script type="text/javascript"> $(function() { $(this).bind("contextmenu", function(e) { e.preventDefault(); }); }); </script> <script type="text/JavaScript"> function killCopy(e){ return false } function reEnable(){ return true } document.onselectstart=new Function ("return false"); if (window.si
  4. Hi Everyone, We have found a bug. When using X2crm's workflow and creating an email to a contact, the information required from the attributes drop down menu is blank / empty. Can anyone help? Please see screenshot.
  5. We also get this error. When we send multiple emails in a single workflow. It doubles the second email, then triples the third, then sends the fourth email 4 times over..., etc - very annoying. We are on version 7.0
  6. It turned out that it had nothing to do with .htaccess for us. Here is the sample code that I found on the community forum (http://community.x2crm.com/topic/2237-basic-test-for-web-lead-capture-missing-or-malformed-data-sent-to-server-400/) which I adapted for it to work from any server to our server. =============================================== //Assign values$firstName = $name;$lastName = "$lastname";etc... //create array$username = "USER";$password = "API_USER_KEY";$contact = array( "firstName" => $firstName, "lastName" => $lastName, "email" => $email,
  7. Hi All - I also cannot complete a process stage. Complete Process Stage (Failure: Stage does not exist)
  8. Hi All - I also cannot complete a process stage. Complete Process Stage (Failure: Stage does not exist)
  9. Hi Eugene, We use postman - works nicely with Get request. When we want to Put - error 400. We check that all mandatory fields are correct and have values. Would it be PHP not passing the request through from another location other than the server it is located on? I'll email X2crm and see if there is anything they can advise on. Do you know what setting would possibly be the culprit here? Deny-all or something like that? Will keep you posted.
  10. Hi All, We are trying to use restful API to create a new opportunity using version 7.0 of x2crm. Can someone comment on our PHP code below (I've changed the URL Address): <?php $request = new HttpRequest();$request->setUrl('http://xxxxxxx/index.php/api2/Opportunities/');$request->setMethod(HTTP_METH_POST); $request->setQueryData(array( 'assignedTo' => 'Anyone', 'c_Assigned_Dealer' => '1', 'Name' => '1', 'updatedBy' => 'Anyone', 'visibility' => '1')); $request->setHeaders(array( 'Connection' => 'keep-alive', 'content-length' => '', 'accept-encod
  11. Hi Eugene, This is great! We have a separate application that does not use GF. Do you perhaps have the PHP code for what you did in your example above? Nice to see you the other day! Thanks, Rob
  12. Hi Everyone, I'm sure you guys that are really using x2crm are starting to rack up a fair size database size. We are already approaching 20 000 contacts. The reason I'm bringing this up is that we are starting to have duplicate contacts in our system and it's causing problems with duplicate workflows, etc. Also what is happening if the internet is slow the user tends to hit the create button like 60 times and the poor guy is getting 60 welcome emails in the workflow. Is there no way that the system can be modified to first check for duplication and suggest to the user rather to use an exis
  13. I've just seen this. https://www.messengerpeople.com/This would be a great integration into X2CRM.
  • Create New...