Hello All,
I just did the 7.4.5 Update and the dashboard page has no sales information on it and the dropdown columns don't work, you have to click on them to get the links.

The customer's box is gone and the top sellers has this information in the box. Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mn14754_kocdb.cart.cartProdID' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Fatal error: Uncaught Error: Call to a member function fetch_assoc() on boolean in /home/mn14754/public_html/vsadmin/inc/incfunctions.php:1930 Stack trace: #0 /home/mn14754/public_html/vsadmin/inc/incadmin.php(362): ect_fetch_assoc(false) #1 /home/mn14754/public_html/vsadmin/admin.php(43): include('/home/mn14754/p...') #2 {main} thrown in /home/mn14754/public_html/vsadmin/inc/incfunctions.php on line 1930

The store is visible and working but the dashboard is messed up. I hope it won't miss any sales.



Yours Truly,
Paul P.
Longtime ECT Customer

Hi Paul
I believe I've fixed this now so can you get a new copy of the updater and copy the incadmin.php script to your site and that should sort this out.

Vince

Click Here for Shopping Cart Software
Click Here to sign up for our newsletter
Click Here for the latest updater

Hi Vince,
That did it, Thank you.

Quick question, is there anyway to change the time zone of the order sales? My customers have asked if the time zone can be changed to reflect the store location time?

Yours Truly,
Paul P.
Longtime ECT Customer

Hi Paul

This should help you out

Date format

If you need the date to show depending on your locale, set the following...

$fordertimeformatstr='%d %B %Y %H:%M';

The available variables can be looked up here https://www.php.net/manual/en/function.strftime.php

Further time adjustments are as follow:

Adjust date

$dateadjust=3;

...would adjust the date the order status was updated by 3 hours.

$dateadjust=-4;

...would adjust it by minus 4 hours. This is so that if your server time is not the same as your local time then you can adjust for this.

$dateformatstr="d/m/Y";

...would show the European date format of day / month / year for packing slips

$dateformatstr="dS F Y";

..would show the date in the format for example 25th May 2004 20:17

Admin date
To set dates in your admin section to US style format (for instance mm/dd/yyyy), set the following
$admindateformat=1;

To set dates in your admin section to UK style format (for instance dd/mm/yyyy), set the following
$admindateformat=2;

Steve
Bolton Lancashire

Hi Steve,
Thanks for the help with the date format. I inserted this "$admindateformat=1;" on the includes.php page and the date is fine now.

I'm not sure how to set it for different time zones. I'm central time zone, I need to set it for Pacific time zones and ect...
Do I need a different script?

Yours Truly,
Paul P.
Longtime ECT Customer

Hi Paul,
The way I set the timezone is by adding an entry like this near top of your includes.php configuration file:

date_default_timezone_set('Australia/Sydney');

Find a list of PHP Supported Timezones here >>

Gary

Hi Gary,
I inserted this code "date_default_timezone_set('America/Los_Angeles');" on the includes.php page and nothing changed.

I inserted $date_default_timezone_set('America/Los_Angeles'); and the site won't display anything.

I'm trying to get the admin orders to display in west coast time instead of east coast time.

Yours Truly,
Paul P.
Longtime ECT Customer

This should cover it Paul

quote:

---

Further time adjustments are as follow:

Adjust date

$dateadjust=3;

...would adjust the date the order status was updated by 3 hours.

$dateadjust=-4;

...would adjust it by minus 4 hours. This is so that if your server time is not the same as your local time then you can adjust for this.

---

If you are showing east coast time, and you want west coast time, try $dateadjust=-3;

David

Hi Vince,
My original post was about the 7.4.5 Update Problems.
I followed the instructions, downloaded a newer updater and installed the incadmin.php all the information came back on the dashboard page.

However the shopping cart will not work. When you click to add a item into the cart the popup window comes up shows the item that your purchasing but it never goes into the shopping cart. this is what I see on the cart.php page Cookies seem to be currently disabled in your browser. This could mean that this shopping site will not function correctly. If you experience problems, please check that your browsers security settings are not set to too high a level and that you don't have a firewall blocking cookies or javascript.

All my other stores work fine.



Yours Truly,
Paul P.
Longtime ECT Customer

Hi Paul
Which site is it?

Vince

Click Here for Shopping Cart Software
Click Here to sign up for our newsletter
Click Here for the latest updater

Hi Vince,
Thank you for your help.

I ran the updater (7.4.5) and I still have the problem. But I think I know what’s happening, the shopping cart box under Navigation when you click the
“ Shopping cart” link or the “» Checkout link it takes you out of “https:” the secure side of the site to “http:” If you click the “SHOPPING CART” link on the top upper right of the page it takes you to the cart with the https: still in the url.

Site URL: https://koc14754.org/


Yours Truly,
Paul P.
Longtime ECT Customer

Hi Paul
Can you check what the store url is set to in the admin main settings page.

Vince

Click Here for Shopping Cart Software
Click Here to sign up for our newsletter
Click Here for the latest updater

Hi Vince,
In the admin section under “Main settings” / Store Settings
The store URL's are
Store URL: http://koc14754.org
HTTPS Store URL: https://koc14754.org

If I remove the “Store URL:”from the box it works. Do I need to have the non-https: Store URL: in the box or can I leave it blank?

Could that be it?



Yours Truly,
Paul P.
Longtime ECT Customer

Hi Paul

If you have an SSL installled then both URLs should be https

Steve
Bolton Lancashire

quote:

---

If you have an SSL installled then both URLs should be https

---

This would be the case if you could only navigate the site on HTTPS but as both can be used on this site cart contents are getting lost between HTTP and HTTPS. It is a good idea to go HTTPS only these days though, but add an entry to your .htaccess file to force everything on to HTTPS. And while you're there, choose one form of the URL, either with or without www. and force that too. If you need help with that let us know.

Vince

Click Here for Shopping Cart Software
Click Here to sign up for our newsletter
Click Here for the latest updater

Hi Vince,
Should I have both store URL's set to https://www.koc14754.org
What should I add to the .htaccess file to force everything on to HTTPS and www.

Yours Truly,
Paul P.
Longtime ECT Customer

Hi Paul, there is a thread here https://www.ecommercetemplates.com/support/topic.asp?TOPIC_ID=106851 and I believe that 2nd post is the one you want.

Thanks,
David