Welcome to the nuBuilder forums!

Please register and login to view forums and other content only available to registered users.

NuBuildierPro Install Issues - Solved

Post Reply
ibbwhobu
Posts: 2
Joined: Sun Oct 23, 2016 5:10 pm

NuBuildierPro Install Issues - Solved

Unread post by ibbwhobu »

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 2:31 am, edited 1 time in total.
lynx1105
Posts: 1
Joined: Sat Nov 05, 2016 7:17 pm

Re: NuBuildierPro Install Issues

Unread post by lynx1105 »

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/1462 ... alue-mysql
ibbwhobu
Posts: 2
Joined: Sun Oct 23, 2016 5:10 pm

Re: NuBuildierPro Install Issues

Unread post by ibbwhobu »

Thanks so much for the hint! That was the issue and that fixed it for me.
Post Reply