Jump to content


Photo

fresh installation-->Error installing module "users". SQL statement


  • Please log in to reply
8 replies to this topic

#1 centoasa

centoasa

    Newbie

  • Members
  • Pip
  • 7 posts

Posted 15 November 2017 - 02:15 AM

I'm on https://x2.100asa.it...php?language=itpage and after testing my hosting with requirements.php test file, and ---> 

This webserver can run X2Engine!

 

on footer of installing page I've now:

Installing X2CRM
  • Completed: set up core database structure
  • Completed: set up role-based access control (RBAC) permissions system
  • Completed: insert time zone data
  • Error installing module "users". SQL statement "ALTER TABLE `x2_calendar_permissions` ADD CONSTRAI..." failed;HY000,1005,Can't create table `irnndaeb_x2`.`#sql-81be1_62d81` (errno: 150 "Foreign key constraint is incorrectly formed")


#2 X2Isaiah

X2Isaiah

    Advanced Member

  • Moderators
  • 195 posts

Posted 15 November 2017 - 11:26 AM

Hey centoasa,

 

A few questions to help understand the situation. What source are you installing X2CRM from (Github, Sourceforge, etc)? What operating system and PHP version are you using? Do you have Mysql installed?


Isaiah Solomon

Software Engineer

X2Engine Inc.


#3 centoasa

centoasa

    Newbie

  • Members
  • Pip
  • 7 posts

Posted 24 November 2017 - 06:51 AM

source by sourceforge, php 7 with apache + mysql



#4 centoasa

centoasa

    Newbie

  • Members
  • Pip
  • 7 posts

Posted 25 November 2017 - 02:39 PM

Also downloaded from github. With php 5.6. Same issue

#5 X2Isaiah

X2Isaiah

    Advanced Member

  • Moderators
  • 195 posts

Posted 27 November 2017 - 12:35 PM

Hey centoasa,

 

When you download from Sourceforge or Github, try setting the permissions to 755 for all files


Isaiah Solomon

Software Engineer

X2Engine Inc.


#6 centoasa

centoasa

    Newbie

  • Members
  • Pip
  • 7 posts

Posted 28 November 2017 - 05:52 AM

Hey centoasa,

 

When you download from Sourceforge or Github, try setting the permissions to 755 for all files

Sure!



#7 centoasa

centoasa

    Newbie

  • Members
  • Pip
  • 7 posts

Posted 28 November 2017 - 06:22 AM

I've just re-re-re tried with english language, with all files permission on 775: same error.

 

https://pasteboard.co/GVKmVHw.png



#8 rayd

rayd

    Member

  • Members
  • PipPip
  • 15 posts

Posted 29 November 2017 - 10:14 AM

HI,

 

I have installed several instances of x2crm and every time, as a workaround,  I modify protected/modules/users/data/install.sql (comment out alter line on line 35).

 

Has not been an issue for clients though to be honest, deleting a contact with items in the calendar would leave their calendar items left behind in the calendar table.

 

So, if there is a fix for this, instead of a "workaround", that would be great.

 

Ray



#9 centoasa

centoasa

    Newbie

  • Members
  • Pip
  • 7 posts

Posted 29 November 2017 - 10:16 AM

HI,

 

I have installed several instances of x2crm and every time, as a workaround,  I modify protected/modules/users/data/install.sql (comment out alter line on line 35).

 

Has not been an issue for clients though to be honest, deleting a contact with items in the calendar would leave their calendar items left behind in the calendar table.

 

So, if there is a fix for this, instead of a "workaround", that would be great.

 

Ray

Thank you

I thought it was just my problem.






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users