nuSetCollation()
Posted: Sun Jul 29, 2018 3:51 pm
Hi,
1. nuSetCollation() in nusystemupdate.php outputs some errors in "nuDebug Results" since the "ALTER TABLE..." does not work on views. I don't think that's critical, but views could be excluded. E.g. like this:
2. I'm not sure if only zzzz-tables should be altered or any other table (created by the user) that resides in the database.
E.g.
1. nuSetCollation() in nusystemupdate.php outputs some errors in "nuDebug Results" since the "ALTER TABLE..." does not work on views. I don't think that's critical, but views could be excluded. E.g. like this:
Code: Select all
$tbls = nuRunQuery("SHOW FULL Tables WHERE Table_type = "BASE TABLE"");E.g.
Code: Select all
[0] : ===USER========== globeadmin ===PDO MESSAGE=== SQLSTATE[HY000]: General error: 1347 'id4938527_nubuilder4.zzzzsys_report_data' is not BASE TABLE ===SQL=========== ALTER TABLE zzzzsys_report_data DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ===BACK TRACE==== /storage/ssd3/527/4938527/public_html/nusystemupdate.php - line 388 (nuRunQuery) /storage/ssd3/527/4938527/public_html/nusystemupdate.php - line 23 (nuSetCollation)