nuSetCollation() Topic is solved

[toms]

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:

Code: Select all

$tbls		= nuRunQuery("SHOW FULL Tables WHERE Table_type = "BASE TABLE"");

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.

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)

[admin]

toms,

I've added it to....

Code: Select all

SHOW FULL Tables WHERE Table_type = "BASE TABLE"

Steven

[toms]

Thank, I guess this works all fine. (Can't test because I cannot update)

[admin]

.