Jump to content


Photo

Unable to install sample data

sampledata install sql

  • Please log in to reply
5 replies to this topic

#1 bigbankclub

bigbankclub

    Newbie

  • Members
  • Pip
  • 7 posts

Posted 08 January 2018 - 08:34 AM

I am stumped.

 

I am getting:

 

 

Installing X2CRM

Completed: set up core database structure
Completed: set up role-based access control (RBAC) permissions system
Completed: insert time zone data
Completed: install modules
Completed: apply configuration
Could not insert sample data. SQL statement "INSERT INTO `x2_trigger_logs` (`id`, `flowId`, `tr..." from /home/atlan144/public_html/0001/x2engine/protected/data/dummy_data.sql failed; 23000,1452,Cannot add or update a child row: a foreign key constraint fails (`atlan144_3ew`.`x2_trigger_logs`, CONSTRAINT `x2_trigger_logs_ibfk_1` FOREIGN KEY (`flowId`) REFERENCES `x2_flows` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)

 

I can install x2crm 100% -- BUT when I try to install with sample data - it fails :(



#2 bigbankclub

bigbankclub

    Newbie

  • Members
  • Pip
  • 7 posts

Posted 08 January 2018 - 08:56 AM

I should have mentioned.

 

This is on the NEW version. 6.9

 

 



#3 X2Isaiah

X2Isaiah

    Advanced Member

  • Moderators
  • 218 posts

Posted 08 January 2018 - 09:48 AM

Hey bigbankclub,

 

Would you mind informing me of your OS, PHP version, and if this is with specifically 6.9 or with our newest version 6.9.3?


Isaiah Solomon

Software Engineer

X2Engine Inc.


#4 bigbankclub

bigbankclub

    Newbie

  • Members
  • Pip
  • 7 posts

Posted 08 January 2018 - 10:02 AM

Current: PHP 5.6

 

OS: Linux

 

6.9 download. 



#5 X2Isaiah

X2Isaiah

    Advanced Member

  • Moderators
  • 218 posts

Posted 08 January 2018 - 10:20 AM

Hey bigbankclub,

 

One solution I would suggest is to go to the line that error is happening and remove the line of code where the row that is trying to be added is failing. This may be a bug on our end that slipped past us in development. Otherwise, I would advise against using dummy data as if you plan to use the app in the future, without using MySQL the dummy data will be hard to remove later on.

 

Edit: This actually is fixed in the newest release, we will be updating the Github soon.


Isaiah Solomon

Software Engineer

X2Engine Inc.


#6 bigbankclub

bigbankclub

    Newbie

  • Members
  • Pip
  • 7 posts

Posted 08 January 2018 - 10:31 AM

Thank you :)







Also tagged with one or more of these keywords: sampledata, install, sql

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users