Troubleshooting nuBuilder Installation issues

Errors and Fixes

v4.5 SQLSTATE[HY000]: General error: 1786

• PHP v5.6 introduced some changes that may result in errors like:

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nubuilder4.___nu1604ddfc9e7288___' doesn't exist

• In my.cnf, make the following changes and restart MySQL

gtid_mode=OFF
enforce_gtid_consistency=OFF

• The long term solution
• Forum Post

No Database error

The following error occurs if the database does not exist:

Fatal error: Uncaught PDOException: SQLSTATE[HY000] [1049] Unknown database 'nubuilder4'

The database has to be created manually first.

Troubleshooting techniques

Trace with nuDebug

• As a general debug technique add some nuDebug() calls in the code especially after each nuRunQuery().

    nuDebug($sql, "#RECORD_ID#");

• Then view the nuDebug results (CTRL+SHIFT+D) after the queries have run.
• Also verify/run the queries in phpMyAdmin (replace ? with the record id).