Troubleshooting nuBuilder Installation issues: Difference between revisions
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).