Jump to content
X2Community Forums

Search the Community

Showing results for tags 'mysql'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • Information
    • Announcements
  • Support
    • Community Support
    • Installation Help
    • Feature Requests
    • Bug Reports
    • X2CRM Premium Support
  • Discussion
    • General Discussion
    • Development
    • X2 Webcasts
    • Web Lead Capture
    • Sales Force Automation
    • Customer Service
    • Marketing
    • Administration
    • Products & Quotes
  • International
    • Internationalization (I18N)
    • Language Packs
    • Deutsche
    • Portuguese
    • Francais
    • Russian
    • Español
    • Chinese


  • X2Engine Source
  • Internationalization (I18N) Packs

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start





Website URL







Found 10 results

  1. Is there a way to access the mysql database in the virtual appliance via mySQL workbench? Not sure how to access via the console. Thank you, John
  2. Hello, I have been dealing with a performance crippling situation with X2CRM related to MySQL queries to the 'x2_trigger_logs' table. This manifests specifically whenever we interact with tags on records, such as adding a single tag to a contact. I wrote a simple PHP script that uses X2CRM's API to test performance of Create, Lookup, Update, Delete and saw the following poor performance: 08-11-2017 22:28:33.190000 Creating contact. 08-11-2017 22:28:34.310000 Done. 08-11-2017 22:28:34.310000 Lookup contact. 08-11-2017 22:28:34.360000 Done. 08-11-2017 22:28:34.360000 Adding tag to contact.
  3. I did a fresh install last night (for testing purposes). It works fine for a few hours. Make a few test social posts, change the theme to black, upload a logo, walk away. Checked again today and now getting this error on login (nothing has changed with the install, and I have reproduced this problem 3x, each time happening on a fresh install, community version 6.9) Error Code: 500 Error Message: CDbCommand failed to execute the SQL statement: SQLSTATE[22007]: Invalid datetime format: 1292 Truncated incorrect DOUBLE value: '' Stack Trace: [click to toggle display] CDbException in /var/www/x2e
  4. Hello, I'm new to this forum and I'm also new to X2CRM. In fact I first heard about X2CRM for the first time a few days ago. What I'm trying to do with little success is to install X2CRM on XAMPP so that I can get some experience with it on localhost, but so far all attempts to complete the installation have failed. I have Windows 10 and downloaded the file X2CRM-master.zip from the Github link at https://www.x2crm.com/download/. I then unzipped it and copied the folder x2engine into the htdocs folder in XAMPP using the video at the link https://www.youtube.com/watch?v=6pBHkZM9C8I. For c
  5. This post cannot be displayed because it is in a password protected forum. Enter Password
  6. Hi, I have records of client purchases of service/product in another DB outside the CRM DB but within mysql host server only. So for a account record in X2 CRM I require a way to automatically create a quote and add data into the quote from external purchases records on every fortnight for example. Note: I already use the X2CRM Account id in my purchases records. Example of main columns of purchase records table in external DB made for all customers: `request_service_id`, `supplier_account_id`, `has_confirmed`, `when_confirmed`, 'service_name'So I need to insert all records in a quote f
  7. Hi, I've run the system requirements test and all is fine. I've created a database and I can login no problems via mySQLadmin. However while running the install script for X2CRM, I am not able to connect to the database. When testing the connection, I get "Could not connect to host or select database." If I proceed anyway, here is the full error that I get: SQLSTATE[42000] [1044] Access denied for user '35443427_xxdb_u33'@'%' to database '35443427_xxdb' Host Name: please check that it is correctDatabase Name: please check that it is correctUsername: please check that it is
  8. This post is obsolete. For the most recent and up-to-date installation information: see The X2CRM Installation Guide on the X2Engine Wiki Installing X2CRM The X2Contacts installation process couldn't be easier! Well, aside from our premium hosting/support services (which will be offered in the near future). All you have to do is copy the files onto your server, open the site and fill out one simple page of information. You can choose to install dummy data, which is a great way to get to know the software. Just one page, and you're ready to go! If you do get stuck, you can refer to the READM
  9. Note: the most up-to-date instructions can now be found in The X2CRM Installation Guide on our wiki. This forum post is no longer actively maintained. Use the requirements checker to determine if your system meets the minimum requirements. Before installing X2EngineCRM, you should first ascertain whether your hosting environment is properly configured. The following features are required for X2EngineCRM to function properly: PHP version 5.3 or later PHP's cURL library A password-protected MySQL database server connection, and a database on which the user of the connection has all rights (i.
  10. ok, I'm just starting to play with x2engine, works great on my win7 xampp, but now I'm trying to install it on my godaddy, linux shared hosting. I get this error when I run the install script: MySQL Error: Unable to create function x2_checkViewPermission.You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable) I do think it has something to do (and it's really annoying) with godaddy I don't have super privilege on mysql. Is there any work around and you can suggest? Godaddy is pretty popular, I
  • Create New...