Install problems on latest Github release

[feline]

I try to install 2.1 (download 1. july from github) but ..
On database install these will hang .. I luck at that and see .. all tables are not MySql, no the type was innoDB 

Well .. I make a small change on the installer php file and it works now, but these is not correct I think.

Sysinfo:
Version Information:
Forum version: SMF 2.1 Beta 1 (more detailed)
Current SMF version: SMF 2.1 Beta 1
GD version: bundled (2.1.0 compatible)
MySQL version: 5.6.20
PHP: 5.5.15 (more detailed)
Server version: Apache/2.4.10 (Win32) OpenSSL/1.0.1i PHP/5.5.15

Any hints?

[Kindred]

not quite sure what you are reporting, Feline...   but we have just run the installer yesterday on mySQL with no errors...

On database install these will hang ..

WHAT will hang?  you say "these" but, nowhere in your post do you indicate what "these" are...

Well .. I make a small change on the installer php file and it works now, but these is not correct I think.

What changes did you make and why do you think it is not correct?

[wintstar]

Maybe it has to do with:

https://github.com/SimpleMachines/SMF2.1/issues/2888

https://github.com/SimpleMachines/SMF2.1/issues/2890

[Kindred]

can't be...

the first one is reported on mySQLi  -- feline reported this on mySQL
the second one was patched a week ago.


Since I just installed (successfully) on 3-Jun,  we need more details -- because I can confirm that the build works just fine with installation on mySQL



also, I just realized...    Feline?   1.july?
July does not happen for another month - did you mean 1.june?

[feline]

Sorry .. yes i meam this month 😁
I'm not at home, i post what I habe change later ...

[Oldiesmann]

Any further updates on this?

[feline]

Not yet .. I will test this later on my Server ..
I'm comming back with clesr results. 😋

[margarett]

@feline, we now see the same problem you had. From our tests we could easily see that when InnoDB is available, the database population takes a lot of time and that "hangs" the installer in step 3 (in certain server configurations, related to php time limit). On the other hand, if the tables are (forced to be) created in MyISAM the database population takes just 3-5 seconds or less, depending on the server.

We are performing some tests to try to figure this out but we would appreciate if you could share your findings

[live627]

Can you run this query?

Code Select Expand

SHOW VARIABLES LIKE '%innodb%'

Edit: Bruno, can you also do that?

[feline]

Results .. See attached text file ...

What I have made to get it to run:
I change the line (1060) in the file intall.php from

Code Select Expand


$replaces['{$engine}'] = in_array('InnoDB', $engines) ? 'InnoDB' : 'MyISAM';

to

Code Select Expand


$replaces['{$engine}'] = 'MyISAM';


[margarett]

Yeah, that would do it... What you are doing is exactly to skip the usage of InnoDB.

I will run that query later when I'm at the computer

[Kindred]

thanks Feline...   the issue with that, of course, is that we actually WANT many tables to be InnoDB

[margarett]

Can you try this, please?
https://github.com/SimpleMachines/SMF2.1/pull/2900

[Illori]

tested, before took about a minute after took about half the time. [checked with stop watch]