Known Bugs (and fixes) with v1.5.1

A summary of fixes to issues found with v1.5.1

**Symptom:
**PHP Fatal error: 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 'int)PRODUCTS_OPTIONS_VALUES_TEXT_ID, 1, 'TEXT')' at line 1 :: INSERT INTO products_options_values (products_options_values_id, language_id, products_options_values_name) VALUES ((int)PRODUCTS_OPTIONS_VALUES_TEXT_ID, 1, 'TEXT') in /home/myserver/public_html/mydomain.com/includes/classes/db/mysql/query_factory.php on line 120

when accessing either:

attributes controller
option names manager
option values manager

**Solution:
**FILES ATTACHED BELOW
Simple coding fix posted here: http://www.zen-cart.com/showthread.php?200551-Attributes-controller-fatal-error-after-upgrade&p=1153132#post1153132

**Symptom:
**When using the password_forgotten page, a log-file is generated with a number of the following entries:
PHP Warning: sha1_file(/includes/configure.php) [function.sha1-file]: failed to open stream: No such file or directory in \htdocs\mywebsite\includes\functions\password_funcs.php on line 118

**Solution:
**Simple coding change posted here: http://www.zen-cart.com/showthread.php?200616-password_forgotten-generates-log-file&p=1153920#post1153920

**NOTE: **not technically a bug but a known issue when a shipping processor such as UPS or USPS and the like fail to communicate
And may apply to versions older than v1.5.1 also.

**Symptom:
**A debug log is generated when an attempt to get quotes fails due to a failure by shipping processors such as UPS and USPS occurs

Solution:
Edit the file:
/includes/modules/pages/checkout_shipping/header_php.php

and add the code in RED around line 191:

    $checklist = array();
    foreach ($quotes as $key=>$val) {
[B]      if ($val['methods'] == '') {
        // skip
      } else {
[/B]        foreach($val['methods'] as $key2=>$method) {
          $checklist[] = $val['id'] . '_' . $method['id'];
        }
[B]      }
[/B]    }
    $checkval = (is_array($_SESSION['shipping']) ? $_SESSION['shipping']['id'] : $_SESSION['shipping']);

THIS MAY OR MAY NOT AFFECT various v1.5.0 implementations. We're posting it here "in case". Implementing this fix is safe either way.

Symptom: Admin Login "broken" in v1.5.0 - v1.5.5a with Google Chrome error: "Aw, snap"

Google Chrome 54.0.2840.59 is now forcefully disallowing the use of javascript function declarations of 'animate'. This interferes with the "spinner" that appears during admin login since v1.5.0

The fix is simple:

1. Open /admin/login.php in a code-safe text editor, such as Sublime Text:
2. Find and replace "animate(" with "waiting_spinner(". There will be 3 occurrences.
3. Save
   That's it. Login should now work again.

For a visual example of the changes, see: https://github.com/zencart/zencart/pull/1321/files
(exact position and line numbers may differ between Zen Cart versions)

Ref: https://www.zen-cart.com/showthread.php?221226-Chrome-Browser-54-0-2840-59-64-bit-windows-cannot-log-into-admin