System Update Issue

Questions related to using nuBuilder Forte.

System Update Issue

Postby alf1976 » Thu Nov 08, 2018 9:39 am

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
alf1976
 
Posts: 74
Joined: Wed Dec 27, 2017 5:28 am

Re: System Update Issue

Postby admin » Thu Nov 08, 2018 11:32 am

Andrew,

I have put a fix on Github.


Steven
admin
Site Admin
 
Posts: 2970
Joined: Mon Jun 15, 2009 9:53 am

Re: System Update Issue

Postby alf1976 » Sat Nov 24, 2018 8:04 pm

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
alf1976
 
Posts: 74
Joined: Wed Dec 27, 2017 5:28 am

Re: System Update Issue

Postby Martin » Tue Nov 27, 2018 5:04 pm

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
Martin
 
Posts: 7
Joined: Sat Nov 10, 2018 2:12 am

Re: System Update Issue

Postby alf1976 » Fri Nov 30, 2018 7:01 am

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
alf1976
 
Posts: 74
Joined: Wed Dec 27, 2017 5:28 am

Re: System Update Issue

Postby admin » Thu Dec 06, 2018 6:04 am

.
admin
Site Admin
 
Posts: 2970
Joined: Mon Jun 15, 2009 9:53 am


Return to General



cron