A summary of fixes to issues found with v1.5.1
Printable View
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.p...20#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:
Code:$checklist = array();
foreach ($quotes as $key=>$val) {
if ($val['methods'] == '') {
// skip
} else {
foreach($val['methods'] as $key2=>$method) {
$checklist[] = $val['id'] . '_' . $method['id'];
}
}
}
$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....log-into-admin