System Update Issue

[alf1976]

Hi Steven,

I have an a problem with the system update. Whenever i run it it changes the database engine of all my tables from InnoDB back to MyISAM.

I use transaction statements on some of the tables. MyISAM is not a transaction engine.

At them moment i have run an sql statement to generate an ALTER TABLE list to convert them back. I leave all the 'zzzz' systems tables as MyISAM

Is there any reason why it alters the db engine of non system tables?

Andrew

[admin]

Andrew,

I have put a fix on Github.


Steven

[alf1976]

Hi Steven,

I have run a couple of system update off the last couple of fixes and all my tables are still being converted to MyISAM

After each update im having to run

Code: Select all

SELECT  CONCAT('ALTER TABLE `', table_name, '` ENGINE=InnoDB;') AS sql_statements
FROM    information_schema.tables AS tb
WHERE   table_schema = **MY DATABASE NAME**
AND     `ENGINE` = 'MyISAM'
AND     `TABLE_TYPE` = 'BASE TABLE'
AND 	TABLE_NAME NOT LIKE '%zzzz%'

to generate an sql statement to convert them all back




Andrew

[Martin]

Strange, this shouldn't happen. nuSetCollation included only tables starting with "zzzzsys"

Code: Select all

if(substr($tab, 0, 8) == 'zzzzsys_'){

https://github.com/nuSoftware/nuBuilder ... telibs.php

[alf1976]

Hi

I've just down the latest pull from Github and ran the update. It hasn't done it on this pull.

Since Steven's post i havent paid much attention to the table structure and have done multiple updates since, so i'm not completely sure when this has happened.
I will monitor it from now on and if i have any more problems i will let you know

Andrew

[admin]

.