On a Debian8 server with PHP 5.6.14, php-mysql 5.6 with innodb, and a fresh openatrium 7.x-2.50-rc1 quickinstall in a virtualmin server, the install process failed after few seconds, the message above is displayed and 31 tables are created in the database.
I don't find any post, drupal or openatrium issue report about that.
The same configuration with openatrium 7.x-2.45 and the update with 7.x-2.50-rc1 work fine.
The same configuration with normal installl work to.
The error page is blanck.

The database import has encountered an error.
Please continue to the error page
An AJAX HTTP error occurred. HTTP Result Code: 200 Debugging information follows. Path: http://myserver/install.php?profile=openatrium&locale=en&db_import_filen... StatusText: OK ResponseText: Home | Drupal @import url("http://myserver/modules/system/system.messages.css?0"); @import url("http://myserver/modules/system/system.menus.css?0"); @import url("http://myserver/modules/system/system.theme.css?0"); @import url("http://myserver/modules/system/system.base.css?0"); @import url("http://myserver/modules/user/user.css?0"); @import url("http://myserver/modules/system/system.admin.css?0"); @import url("http://myserver/modules/system/system.maintenance.css?0"); @import url("http://myserver/profiles/openatrium/openatrium.css?0"); @import url("http://myserver/themes/seven/reset.css?0"); @import url("http://myserver/themes/seven/style.css?0"); Home Installation tasksChoose profile(done)Choose language(done)Verify requirements(done)Set up database(done)Choose installation method(done)Install profile(active)Configure siteVerify Apps supportInstall AppsFinished SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;/*!40101 SET @OLD_COLL' at line 1

Comments

ohmdesbois created an issue. See original summary.

ohmdesbois’s picture

Issue summary: View changes
Anonymous’s picture

same on an apache with php 5.6

mpotter’s picture

Yep, I can confirm that there is something wrong with the database dump being used for the Quick Install in the 2.50-rc1 release. Not sure what's wrong yet since we just the same automated scripts to generate this db dump as we always have and the 2.45 version was fine.

(This was with php 5.6 and a mariadb docker container)

Anonymous’s picture

i made a testaccount on pantheon and everything worked fine! and i've tried php 5.5.29 with better results. i was able to choose the sites admin name and password and stuff but it ended in a wsod.

Anonymous’s picture

what size is the db dumb?

mpotter’s picture

OK, narrowed this down to the following change in Drupal core:

- Prevented the database API from executing multiple queries at once on MySQL,
if the site's PHP version is new enough to do so. This is a secondary defense
against SQL injection (API change: https://www.drupal.org/node/2463973).

This is going to be a real pain to fix. Basically, newer versions of PHP will fail to handle the DB import. The DB import specifically executes multiple lines at a time for performance reasons.

Anonymous’s picture

jup... i have installed oa2 successful with php 5.4! i think changing php version after installation should work as long there is a fix...

  • mpotter committed 79dedda on 7.x-2.x
    Issue #2605776 by mpotter: quick install error because of multiple sql...
mpotter’s picture

Status: Active » Fixed

OK, this should be fixed in commit 79dedda. You can either wait till the 2.50-rc2 later this week or pull the dev version via git.

ohmdesbois’s picture

Ok for me, Thanks

ohmdesbois’s picture

On a Debian8 server with PHP 5.6.14, php-mysql 5.6 with innodb, and a fresh openatrium 7.x-2.50-rc2
quickinstall run normally
Thanks and felicitations for OpenAtrium

mpotter’s picture

Great! Thanks for confirming that the problem is fixed in rc2.

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.