Jump to content


Member Since 21 Aug 2014
Offline Last Active May 14 2020 04:52 AM

Topics I've Started

Can't create a new module in Version 8

31 March 2020 - 02:14 AM

Hi guys,


I tried creating a new module in a brand new install. Has anyone gotten this error:


Error Code: 500
Error Message: CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1217 Cannot delete or update a parent row: a foreign key constraint fails
Stack Trace: [click to toggle display]
X2Engine Version: 8.0
PHP Version: 7.0.33-0ubuntu0.16.04.12


I tried various things during the creation process but end up with this 1217 error


Any advise?



X2Flow not running

03 March 2020 - 03:24 AM

Has anyone had issue with the crons after upgrading. My flows seem to have stopped due to the crons not firing.


I am using the internal web call method through the front-end. Using the X2 tool (API resolver test php) to test of the server can call itself shows it fails. It worked before the upgrade as we have crons running. Not sure what changed now.


Another concern is the UI shows the api web call to go to /index.php/api/x2cron but should that not be /index.php/api2/x2cron?


Looking at the logs available through the UI in crons also shows the server trying to send from a different IP all of a sudden. not sure if it can be that.


Any suggestions on what to check?

Help with Database Recovery download link after upgrading

22 February 2020 - 07:46 AM

Hi guys, 


when you are busy with upgrading, you can run a DB backup through the front-end before you upgrade. This creates a link to 'Download the backup' before you upgrade to your local machine from where it resides in the /backup folder on the server.


After upgrading, when you check X2 Upgrade, it says you are on the latest version and Go back.


MY PROBLEM: Is there anyway to access that 'DB Backup' from when you backed up during upgrade, after upgrading, BUT through the front-end and not FTP to the backup folder.


I have that scenario of having upgraded a client where I don't have FTP access. The upgrade was successful but I need that downloaded DB file now after upgrading.

Successful upgrading from 7.1 to 8.0

19 February 2020 - 09:59 AM

Hi X2'ers,


I have started upgrading my 45 odd X2CRM clients throughout South Africa. Still have to do about 10 but so far not one problem. Wow, well done. 


I have been playing with v8.0 on our own primary system since its release and haven't found issues. But still playing, holding thumbs as some of my customisations with client systems is quite intense. 


Still a super happy X2CRM user and advocate!

Grid View Column Dropdown list not displaying all fields

07 February 2020 - 04:11 AM

Hi guys,


on some of my instances I am running, in Grid-view for a module, selecting Column filter to display additional column in the grid, doesn't show all available columns field that are in the record available. These include the ID and Last Updated fields that are default on all records but not in the dropdown list as a column to display in Gridview.


The fields do exist in the DB itself and I can see the Last Updated field in the forms view. But not available on the Column filter Drop down.


Any suggestions?