[Bug] Critical errors from class2.php immediately after install with UTF8 charset and collation

[dimmskii]

CRITICAL ERROR: Line 483 /var/www/www.signisoft.com/class2.php Error reported as: [3]: Core settings saved - backup made active. CRITICAL ERROR: Line 485 /var/www/www.signisoft.com/class2.php Error reported as: [4]: No core backup found. Check that your database has valid content.

Tested with regular MySQL charset/collation and it works.

Sucks.

[tgtje]

No offence please, but throughout time it a) very often appears when there are errors (mistakes) in credentials for/from host ; either on cpanel or config php has some mismatch. (general dbase related) Or b) language related when using another language during install (language files have errors).

[ChiellieNL]

Same issue here.. Tried to install it over and over again, but never works.. Tried the download from e107.org as well as the latest Git..

[Moc]

Same issue reported here: http://e107help.org/1648/problem-with-index-php-after-install

PHP 5.5.9 MySQL 5.5.46 Running on Ubuntu 14.04 LTS

[CaMer0n]

Tested working with Windows: PHP 5.4.17 MySQL 5.6.13

Wondering if it's a PHP 5.5 thing?

[dimmskii]

Yes, forgot to mention: it's PHP 5.6.13-pl0-gentoo (might have been a few subversions less at the time of the bug, since I have a co-user on the server who runs emerge updates once in a while. Probably not, though, as I don't see any PHP updates in the history) MySQL: 5.6.26-log

[CaMer0n]

Thanks @dmitripot - Could you also please share the value of "sql-mode" in your mysql config file? ( my.cnf ). Thanks.

 eg.    sql-mode = "STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

[CaMer0n]

Likely related to Issue #1102

[dimmskii]

Hey, sorry about the late response. I'm back at it (helping somebody set up a site, they upgraded to v2). So my sql-mode isn't set from the default location my.cnf, however I was able to get this:

mysql> SELECT @@GLOBAL.sql_mode;
+------------------------+
| @@GLOBAL.sql_mode      |
+------------------------+
| NO_ENGINE_SUBSTITUTION |
+------------------------+
1 row in set (0.00 sec)

mysql> SELECT @@SESSION.sql_mode;
+------------------------+
| @@SESSION.sql_mode     |
+------------------------+
| NO_ENGINE_SUBSTITUTION |
+------------------------+
1 row in set (0.00 sec)

So I'm guessing that STRICT_TRANS_TABLES and NO_AUTO_CREATE_USER aren't enabled. The connection that I have at hand myself for e107v2 is non-root.

All of my e107v2 install is updated to the most recent GitHub commit as of this comment, and the installation that I have is running seemingly after migrating manually from legacy.

[Moc]

Is this issue still present using the latest files on Github?

[Moc]

Closing due to lack of feedback. Presumed fixed. Let us know if this is still an issue and I'll re-open.