Marcel_merged Posted January 12, 2023 Posted January 12, 2023 Anyone know how to fix these errors? I contacted my host, they replied "While checking we could see that the server is configured to use the current PST time and is accurate. Also the InnoDB MySQL engine is enabled and is running. Please see these can be rechecked." When I select "Fix This" I get: Your server is reporting the current time as 01/12/2023 03:51 PM UTC which seems to be inaccurate. This can cause problems with some services and security functionality. You should contact your hosting provider to ask for this problem to be resolved. and InnoDB database tables typically perform more efficiently and reliably than other database engines such as MyISAM on most modern hosts when configured correctly. It is strongly encouraged to ensure all of your database tables are using the InnoDB storage engine, and that your hosting provider has configured MySQL for InnoDB use.
Marc Posted January 12, 2023 Posted January 12, 2023 You would need to also check the time/timezone set on your mysql instance, which may be causing you that issue. With regards the INNODB tables, that would indeed be for your hosting company to correct. I believe they have read the comment incorrectly. YOu have tables that are using MyISAM that shuold be switched to using INNODB. It is not saying INNODB is not available there
Marcel_merged Posted January 12, 2023 Author Posted January 12, 2023 1 minute ago, Marc Stridgen said: ...also check the time/timezone set on your mysql instance, which may be causing you that issue. Thank you. This is something I can do, or the host?
Marc Posted January 12, 2023 Posted January 12, 2023 My colleague has just mentioned, it will actually be the server time there, not the mysql time causing issues, so your hosting company need to recheck this. Taking a look there, the time is out by a minute. It needs to be accurate, as there are items such as 2 factor authentication that would rely on the time.
Marcel_merged Posted January 12, 2023 Author Posted January 12, 2023 Okay, I will fill out another ticket with the hosting company. I'm assuming this is why I'm having an issue updating Version 4.7.6?
Marc Posted January 12, 2023 Posted January 12, 2023 What issue is it you are having when you try to upgrade?
Marcel_merged Posted January 12, 2023 Author Posted January 12, 2023 I download, but it will not extract.
Jim M Posted January 12, 2023 Posted January 12, 2023 Unfortunately, I am not seeing any logs in your file system for our software reporting an issue. You may wish to check with your hosting provider to see what is happening here to see why you're getting "Not Acceptable" when extracting the files. Checking permissions, file/folder ownership, and if the tmp directory is writable are some good checkpoints but may not completely encompass your issue.
Solution Mark H Posted January 12, 2023 Solution Posted January 12, 2023 Just a followup to what my colleague mentioned with some extra info... the error "Not Acceptable" is most often tied to the use of Mod Security on your server. Your host would need to confirm whether you are using it, but if you are using Mod Security, then it is likely the cause of that error, and they need to examine the logs to see what rule was being triggered during file extraction, then "whitelist" that rule for your account. Jim M 1
Marcel_merged Posted January 12, 2023 Author Posted January 12, 2023 3 hours ago, Marc Stridgen said: With regards the INNODB tables, that would indeed be for your hosting company to correct. I believe they have read the comment incorrectly. YOu have tables that are using MyISAM that shuold be switched to using INNODB. It is not saying INNODB is not available there From Eleven2.com "I could see the server supports InnoDB and which is the default one."
Jim M Posted January 12, 2023 Posted January 12, 2023 1 hour ago, Marcel_merged said: From Eleven2.com "I could see the server supports InnoDB and which is the default one." Believe they are still confused. The statement there is not stating anything about the server's capabilities. It is stating that there are tables in the database set to MyISAM and those tables will need to be switched to be using INNODB. Your hosting provider is responsible for assisting you with this change that is associated with your MySQL database.
Marcel_merged Posted January 13, 2023 Author Posted January 13, 2023 I also have an issue that Twitter will not embed into a post anymore.
Marcel_merged Posted January 13, 2023 Author Posted January 13, 2023 I get the below when trying to put a Twitter link in a post. Forbidden You don't have permission to access this resource.
Marc Posted January 13, 2023 Posted January 13, 2023 Again this is something either blocking you, or your server blocking them. As its in more than one location, its very very likely that the issue is your server itself. You would need to contact your hosting company on this
Marcel_merged Posted January 13, 2023 Author Posted January 13, 2023 Thanks Marc, you were correct. Twitter issue solved. 👍
Marcel_merged Posted January 14, 2023 Author Posted January 14, 2023 Is there a place to set time zone? Host is asking what time zone site is set to. This is referring to the original topic of "server time being inaccurate"
Jim M Posted January 14, 2023 Posted January 14, 2023 1 minute ago, Marcel_merged said: Is there a place to set time zone? Host is asking what time zone site is set to. This is referring to the original topic of "server time being inaccurate" It is not related to time zones. This would be on the server that the server time is inaccurate. This would mean your server time is off, even by a few seconds to a minute. Marcel_merged 1
Marcel_merged Posted January 14, 2023 Author Posted January 14, 2023 On 1/12/2023 at 3:37 PM, Jim M said: Believe they are still confused. The statement there is not stating anything about the server's capabilities. It is stating that there are tables in the database set to MyISAM and those tables will need to be switched to be using INNODB. Your hosting provider is responsible for assisting you with this change that is associated with your MySQL database. Below is from tech support at Eleven2.com. I'm not sure how to answer this, can you assist? Quote It sounds like you want to export data from one table type and import it to another. That is usually something handled by a developer or similar familiar with the software you are using. Do you have any documentation from the software developers on what they are looking to do?
AlexJ Posted January 14, 2023 Posted January 14, 2023 You need to convert your existing tables, which is very easy. Look here: https://phoenixnap.com/kb/myisam-vs-innodb Look at this topic on above link. How to Convert MyISAM and InnoDB
Marc Posted January 16, 2023 Posted January 16, 2023 The above is correct. You or your host would need to convert those which already exist
Recommended Posts