Jump to content

upgrade to 6.2.3


Robo

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 

Link to comment
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.

Link to comment
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

Link to comment
Share on other sites

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 

Link to comment
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.

 

 

Link to comment
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.

Link to comment
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. 

Link to comment
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.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...