lennie_boy Posted November 27, 2013 Share Posted November 27, 2013 hi Gergely, my host OVH did the encoding automatically. How do I do change that?, I am a novice at this. Thanks for your advice kind regards Len Link to comment Share on other sites More sharing options...
tgely Posted November 27, 2013 Share Posted November 27, 2013 Use Search-Engine Safe URLs not the best for it. There are other URL SEO addons. osCommerce based shop owner with minimal design and focused on background works. When the less is more.Email managment with tracking pixel, package managment for shipping, stock management, warehouse managment with bar code reader, parcel shops management on 3000 pickup points without local store. Link to comment Share on other sites More sharing options...
Camelhmpz Posted July 28, 2014 Share Posted July 28, 2014 In the dashboard module, the date comes from this SQL call: greatest(o.date_purchased, ifnull(o.last_modified, 0)) as date_last_modifiedI wonder if, for some reason, this is failing on your version of MySQL. To test this, please change that part of the code to: o.date_purchased as date_last_modifiedsave the file and upload. View the index page module and see if the dates are now OK. I can confirm this also works for me. All I had done was upgrade from 2.3.2 to 2.3.3 IIRC Thanks Link to comment Share on other sites More sharing options...
greasemonkey Posted July 31, 2014 Share Posted July 31, 2014 Worked for me too... Link to comment Share on other sites More sharing options...
♥joli1811 Posted September 30, 2014 Share Posted September 30, 2014 In the dashboard module, the date comes from this SQL call: greatest(o.date_purchased, ifnull(o.last_modified, 0)) as date_last_modifiedI wonder if, for some reason, this is failing on your version of MySQL. To test this, please change that part of the code to: o.date_purchased as date_last_modifiedsave the file and upload. View the index page module and see if the dates are now OK. Fixed problem for me 2.3.3.4 site Thanks John To improve is to change; to be perfect is to change often. Link to comment Share on other sites More sharing options...
TomB01 Posted October 6, 2014 Share Posted October 6, 2014 In the dashboard module, the date comes from this SQL call: greatest(o.date_purchased, ifnull(o.last_modified, 0)) as date_last_modifiedI wonder if, for some reason, this is failing on your version of MySQL. To test this, please change that part of the code to: o.date_purchased as date_last_modifiedsave the file and upload. View the index page module and see if the dates are now OK. Ditto for me, too - with OsC 2.3.4. For any others having this issue, the file is "d_orders.php" in catalog/admin/includes/modules/dashboard. :thumbsup: Link to comment Share on other sites More sharing options...
varanka Posted February 18, 2015 Share Posted February 18, 2015 try this for better solution i think, without remove last_modified value greatest(o.date_purchased, COALESCE(o.last_modified,'1000-01-01')) as date_last_modified Link to comment Share on other sites More sharing options...
greasemonkey Posted May 31, 2015 Share Posted May 31, 2015 This fix also works in 2.3.4 BS GOLD..... Link to comment Share on other sites More sharing options...
tushee Posted June 1, 2015 Share Posted June 1, 2015 hello,after upgrading 2.3.3.3, disappeared letter "И", everything else is fine.My Site is on bulgarian (www.agrotehnika.bg). Even when edit it, again shows "@?"Any ideas? Link to comment Share on other sites More sharing options...
rwest Posted March 29, 2016 Share Posted March 29, 2016 Thanks, Burt. I was also see the dashboard order dates displaying 11/30/2036. Your SQL code change above worked for me. I am on mysql 5.5.42. Ron Link to comment Share on other sites More sharing options...
tgely Posted August 9, 2016 Share Posted August 9, 2016 Latest strict mode fix: greatest(o.date_purchased, COALESCE(o.last_modified, '1000-01-01 00:00:00')) as date_last_modified osCommerce based shop owner with minimal design and focused on background works. When the less is more.Email managment with tracking pixel, package managment for shipping, stock management, warehouse managment with bar code reader, parcel shops management on 3000 pickup points without local store. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.