A summary of fixes to issues found 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
Last edited by DrByte; 17 Oct 2012 at 07:06 PM. Reason: fixed attachment
.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
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
.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
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']);
Linda McGrath
If you have to think ... you haven't been zenned ...
Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!
Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
Officially PayPal-Certified! Just click here
Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!
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
.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
Bookmarks