6 replies to this topic

[nielss]

SQLSTATE[42000] [1231] Variable 'sql_mode' can't be set to the value of 'STRICT_ALL_TABLES'

This is the error I get when I want to install the DB... What is the problem? I am using mysql 4.1. Is that the problem ?

[jynxy]

i belive you need to have mysql5 installed, with all privalges.

[Harald Ponce de Leon]

Hi..

Thanks for bringing this to our attention! I just researched into the issue and found out STRICT_ALL_TABLES is available from MySQL v5.0.2, as stated on:

http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html

For a quick fix, please copy the following file:

osCommerce/OM/Core/PDO/MySQL/Standard.php

to:

osCommerce/OM/Custom/PDO/MySQL/Standard.php

and change line 33 to:

	  $this->_driver_options[PDO::MYSQL_ATTR_INIT_COMMAND] = 'set names utf8';

Thanks!

[Harald Ponce de Leon]

The following bug report has been created for this issue:

http://forums.oscommerce.com/tracker/issue-237-strict-all-tables-not-supported-in-mysql-41/

Kind regards,

[nielss]

Aha thanks man for the replay Great support ! it's working now

one more error after installing:

PHP Warning: strftime() [<a href='function.strftime'>function.strftime</a>]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Europe/Berlin' for 'CEST/2.0/DST' instead in /home/vhosts/ngwebs.com/subdomains/webwinkel/httpdocs/osCommerce/OM/Core/DateTime.php on line 37

This and some other related errors, am I getting...

Edited by nielss, 03 April 2011 - 09:47 AM.

[Harald Ponce de Leon]

Hi Niels..

The time zone issue will be fixed in v3.0.1. If you are able to, please set this value in your php.ini configuration to fix the issue.

The php.ini setting to fix is:

date.timezone

A list of timezones is available at:

http://www.php.net/manual/en/timezones.php

An example setting is:

date.timezone = "Europe/Berlin"

(Please be sure to restart your webserver after modifying the php.ini settings)

Kind regards,

[nielss]

nice to hear that it is fixed, I was testing it so there is no need for a good time and date. Still thanks!