NuBuildierPro Install Issues - Solved

NuBuildierPro Install Issues - Solved

Postby ibbwhobu » Mon Oct 24, 2016 12:49 am

I'm a newbe and know I must have missed something but I'm having issues trying to install NuBuilderPro on my Apache2 server. I've verified that I have PHP7 installed, and I have MySQL 5.7 setup with a nubuilder db, user and password.

Here is the output of my install attempt:

Done!
No Schema Changes!
SQL Errors:

Array
(
[0] => Array
(
[0] => INSERT INTO `template_zzzsys_access_level` VALUES ('nufastformlevel','FF','Fast Forms','nuhome','0000-00-00 00:00:00','','0000-00-00 00:00:00','','0000-00-00 00:00:00','')
)

)

No Warnings!
Full Output:

construct nuinstall
starting setDB() ::
completed setDB()
starting setDB() :: nuBuilder
completed setDB()
starting checkInstall()
starting checkDatabaseConnection()
completed checkDatabaseConnection()
starting checkTableExists(zzzsys_setup)
Forced override of zzzsys_setup table :: SCHEMA_INCOMPLETE
completed checkTableExists(zzzsys_setup)
completed checkInstall()
starting run()
starting importTemplate()
failed during run(), nuinstallExcepion:: error opening the file :: nu_template.sql
nuinstall unable to complete :: UNKOWN :: Unable to determine your error

Here is my config.php contents:

<?php

$nuConfigDBHost = "localhost";
$nuConfigDBName = "nuBuilder";
$nuConfigDBUser = "dbm";
$nuConfigDBPassword = "Pea...";
$nuConfigDBGlobeadminPassword = "nu"; //-- globeadmin password
$nuConfigtitle = "My nuBuilder Site";

?>

I have verified that all this info is correct and works when I access the db using PHPMyAdmin.

Can someone point me in the right direction fo get this installer to run?

Thanks,
Last edited by ibbwhobu on Tue Nov 08, 2016 11:01 am, edited 1 time in total.
ibbwhobu
 
Posts: 2
Joined: Mon Oct 24, 2016 12:40 am

Re: NuBuildierPro Install Issues

Postby lynx1105 » Sun Nov 06, 2016 3:57 am

I had the same problem which is caused by MySQL 5.7.
With mysql 5.7, date value like 0000-00-00 00:00:00 is not allowed.
Set sqlmode in MySQL as described here:
http://stackoverflow.com/questions/14625191/error-code-1292-incorrect-date-value-mysql
lynx1105
 
Posts: 1
Joined: Sun Nov 06, 2016 3:47 am

Re: NuBuildierPro Install Issues

Postby ibbwhobu » Tue Nov 08, 2016 10:59 am

Thanks so much for the hint! That was the issue and that fixed it for me.
ibbwhobu
 
Posts: 2
Joined: Mon Oct 24, 2016 12:40 am


Return to Installation



cron