Troubleshooting nuBuilder Installation issues: Difference between revisions

From nuBuilderForte
Jump to navigation Jump to search
No edit summary
No edit summary
Line 20: Line 20:
</pre>
</pre>
The database has to be created manually first.
The database has to be created manually first.
== Troubleshooting techniques ==
=== Trace with <tt>nuDebug</tt> ===
* As a general debug technique add some <tt>nuDebug()</tt> calls in the code especially after each <tt>nuRunQuery()</tt>.
<pre>
    nuDebug($sql, "#RECORD_ID#");
</pre>
* 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).

Revision as of 18:54, 31 March 2021

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

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).