Jump to content
Sign in to follow this  
Robo

upgrade to 6.2.3

Recommended Posts

Upgrade works ok, but issue time zone is no good and the error log is running full btw the time zone in the advanced settings is utc

Today, 19:10File: [controller.admin.pre_session.inc.php] Line: [24] "SET @@time_zone = 'UTC'" - Unknown or incorrect time zone: 'UTC'

Today, 19:10File: [controller.admin.pre_session.inc.php] Line: [24] "SET @@time_zone = 'UTC'" - Unknown or incorrect time zone: 'UTC'

Today, 19:09File: [controller.admin.pre_session.inc.php] Line: [24] "SET @@time_zone = 'UTC'" - Unknown or incorrect time zone: 'UTC'

Today, 19:09File: [controller.admin.pre_session.inc.php] Line: [24] "SET @@time_zone = 'UTC'" - Unknown or incorrect time zone: 'UTC'

Today, 19:09File: [controller.admin.pre_session.inc.php] Line: [24] "SET @@time_zone = 'UTC'" - Unknown or incorrect time zone: 'UTC'

Today, 19:09File: [controller.index.inc.php] Line: [25] "SET @@time_zone = 'UTC'" - Unknown or incorrect time zone: 'UTC'

Today, 19:09File: [controller.admin.pre_session.inc.php] Line: [24] "SET @@time_zone = 'UTC'" - Unknown or incorrect time zone: 'UTC'select_all.gifCheck/Uncheck allWith Selected:     Mark as Read    Mark as Unread      

database did get a orange line also, have reversed to 6.2.2 

Share this post


Link to post
Share on other sites

After reading up on this, I conclude the problem lies with your hosting provider's database master administrator not having pre-loaded an operational table to contain the operating system's timezone info.

Loading an operational table with timezones is not required.

Share this post


Link to post
Share on other sites
24 minutes ago, bsmither said:

After reading up on this, I conclude the problem lies with your hosting provider's database master administrator not having pre-loaded an operational table to contain the operating system's timezone info.

Loading an operational table with timezones is not required.

That's exactly right. Maybe after fail it should switch off trying. Best plan is to install the timezone databases.

@Robo better removing that one line of code than downgrade

Share this post


Link to post
Share on other sites

Ok what  line of code  ? this .. controller.admin.pre_session.inc.php] Line: [24]  why is the previous version working ok ? 

Share this post


Link to post
Share on other sites

The one in the error message. 

[controller.admin.pre_session.inc.php] Line: [24] "SET @@time_zone = 'UTC'"

Share this post


Link to post
Share on other sites
Posted (edited)

had to remove line 25 in controller index inc and line 24 in controller admin pre session, and my dbase gives orange line , CubeCart_order_summary.custom_oid has a key type KEY but expecting UNIQUE KEY.that is not so nice after a upgrade , btw the tool to clean or repair the database is not easy to use 

Edited by Robo

Share this post


Link to post
Share on other sites

The advisory that CubeCart_order_summary should have a UNIQUE KEY for custom_oid is correct.

We would ask you to check if the SQL statements in /setup/db/upgrade/6.2.3.sql are reflected in your database.

That is, for example, check CubeCart_order_inventory to determine if the columns 'cost_price' and 'tax_percent' are present.

If not, then perhaps this upgrade file was not processed during the setup upgrade procedure.

 

 

Share this post


Link to post
Share on other sites

Thanks for the answer, but it is easyer fro me to upload the maybe missing file what file should be used ? as i just design airplanes i am not a programmer a dbase makes my head spin

grts

Share this post


Link to post
Share on other sites

Our hosting platform will always be compatible with CubeCart. Right now it's only available to tech support customers but it will be launched in full at the end of this month. 

Share this post


Link to post
Share on other sites

My Server Administrator has Add the timezone Europ/Amsterdam in the table for the MySQL database. Wth this action was the problem solved.

Share this post


Link to post
Share on other sites

nou krijg dit antwoord

Alles staat standaard op Amsterdam / Europe
(elke server staat op deze tijd)
De time zone verschillen worden alleen in de database opgeslagen als het CMS daar een tabel voor heeft aangemaakt. De aanpassing van de time zone is dus vanuit het CMS in te stellen.

Share this post


Link to post
Share on other sites

They are wrong. Yes I have no doubt the server is set to Amsterdam / Europe by default but that doesn't give timezone support for changes. 

Say you need full MySQL timezone support.

https://dev.mysql.com/doc/refman/8.0/en/time-zone-support.html

This is partly why we have a hosted cubecart solution. We have struggled for year with hosting compatibility from generic web hosting providers. 

Share this post


Link to post
Share on other sites

Pay peanuts and get monkeys is always the case with hosting - it constantly amazes me that people have busy and sometimes very profitable E-Commerce stores and yet choose cheap hosting and then wonder why they have problems.

Full MySQL timezone support is not loaded by default on Linux servers but is a trivial thing to do and something that has always been part of our standard server setup and every single server we operate has this installed and kept updated.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...