search

piyushparkash / FamilyTree

Vanshavali:- FamilyTree is simple PHP Application targetting the collection of family data which can viewed with beautiful visualisation. You can add/update data, play with the visualisation, show you children their roots, add new members as they enter your family.
GNU General Public License v3.0
80 stars 40 forks source link

Cannot create Tables #39

Closed abubakergo closed 7 years ago

abubakergo commented 7 years ago

Error! All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead

Notice: Array to string conversion in /srv/disk6/2204896/www/familytree.biz.ht/template/template/compile/c06385065a6385f946f5059cadb6de60f90427fd.file.error_high.tpl.php on line 39

piyushparkash commented 7 years ago

Hi @abubakergo Can you please specify few details, which branch have you cloned? So that I can start investigating.

abubakergo commented 7 years ago

the master branche

piyushparkash commented 7 years ago

Okay. I will look into it. Will try to fix it within EOD.

abubakergo commented 7 years ago

the full error message

xError! Something went wrong! We'll get this fixed soon Error Details Message:Cannot create Tables File:/srv/disk6/2204896/www/familytree.biz.ht/install/install.php Line No:234 Context: Notice: Array to string conversion in /srv/disk6/2204896/www/familytree.biz.ht/template/template/compile/c06385065a6385f946f5059cadb6de60f90427fd.file.error_high.tpl.php on line 39 Array

abubakergo commented 7 years ago

the screenshot

img_6873

piyushparkash commented 7 years ago

Hi @abubakergo I did not see any issue with the SQL commands. Although I found one problem and fixed it. Can you please try the below steps and let me know the results.

git pull to get latest changes that I have made

drop database <your-database>; Drop database that you created for FamilyTree

rm config.php Remove the config file created and goto FamilyTree URL again to install it.

Let me know if you face problems again.

piyushparkash commented 7 years ago

Hi @abubakergo Were you able to resolve your issue?

cdiaz commented 7 years ago

I have the same problem

piyushparkash commented 7 years ago

@cdiaz See if there is config.php in Familytree root folder, delete it if it is there.

Make sure that there are no tables in database that you have mentioned in the FamilyTree.

cdiaz commented 7 years ago

The solution is add not null attribute on this line https://github.com/piyushparkash/FamilyTree/blob/master/install/install.php#L253

piyushparkash commented 7 years ago

Great work @cdiaz. I will update the same in the repository.