Thanks to avoid double posting issues. We should continue here.
No support using PM (Auto adding to IGNORE list!), use the forum.
How to ask
10$ free to start your VPS
How to ask
10$ free to start your VPS
How to update mySQL to version 5.6?
|
Thanks to avoid double posting issues. We should continue here.
No support using PM (Auto adding to IGNORE list!), use the forum.
How to ask 10$ free to start your VPS
This is the exact error.
How can we solve this? Application Error: [0204] - The form you attempted to submit had an invalid token!
Don't move forward or back in panel.
That's CSRF protection you would better get back to the module home URL. If error persist try removing cookies and login again. M B
No support using PM (Auto adding to IGNORE list!), use the forum.
How to ask 10$ free to start your VPS (12-05-2015, 01:34 AM)Me.B Wrote: Don't move forward or back in panel. that is not the issue... in Microsoft Edge does the same.. the must be something wrong with the sentora code.. how can we fix this?
This is what i get from the mysqld.log
2015-12-04 15:44:01 7fe9ceabd700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-12-04 15:44:01 7fe9ceabd700 InnoDB: Error: Fetch of persistent statistics requested for table "zadmin_liveagent"."qu_g_settings" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2015-12-04 15:44:33 7fe9ceabd700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-12-04 15:44:33 7fe9ceabd700 InnoDB: Error: Fetch of persistent statistics requested for table "zadmin_liveagent"."qu_g_file_links" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2015-12-04 15:44:48 7fe9cea3b700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-12-04 15:44:48 7fe9cea3b700 InnoDB: Error: Fetch of persistent statistics requested for table "zadmin_liveagent"."qu_la_browser_visits" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2015-12-04 15:45:01 7fe9cea3b700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-12-04 15:45:01 7fe9cea3b700 InnoDB: Error: Fetch of persistent statistics requested for table "sentora_core"."x_settings" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2015-12-04 15:45:01 7fe9cea3b700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-12-04 15:45:01 7fe9cea3b700 InnoDB: Error: Fetch of persistent statistics requested for table "sentora_core"."x_modules" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2015-12-04 15:45:01 7fe9cea3b700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-12-04 15:45:01 7fe9cea3b700 InnoDB: Error: Fetch of persistent statistics requested for table "sentora_core"."x_accounts" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2015-12-04 15:45:01 7fe9cea3b700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-12-04 15:45:01 7fe9cea3b700 InnoDB: Error: Fetch of persistent statistics requested for table "sentora_core"."x_profiles" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2015-12-04 15:45:01 7fe9cea3b700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-12-04 15:45:01 7fe9cea3b700 InnoDB: Error: Fetch of persistent statistics requested for table "sentora_core"."x_logs" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2015-12-04 15:45:01 7fe9ce9fa700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-12-04 15:45:01 7fe9ce9fa700 InnoDB: Error: Fetch of persistent statistics requested for table "zadmin_liveagent"."qu_g_eventqueues" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2015-12-04 15:45:01 7fe9ce9fa700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-12-04 15:45:01 7fe9ce9fa700 InnoDB: Error: Fetch of persistent statistics requested for table "zadmin_liveagent"."qu_g_eventsubscriptions" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2015-12-04 15:45:01 7fe9ce9fa700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-12-04 15:45:01 7fe9ce9fa700 InnoDB: Error: Fetch of persistent statistics requested for table "zadmin_liveagent"."qu_g_filecontents" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2015-12-04 15:45:01 7fe9ce9fa700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-12-04 15:45:01 7fe9ce9fa700 InnoDB: Error: Fetch of persistent statistics requested for table "zadmin_liveagent"."qu_g_mail_message_sources" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2015-12-04 15:45:01 7fe9ce9fa700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-12-04 15:45:01 7fe9ce9fa700 InnoDB: Error: Fetch of persistent statistics requested for table "zadmin_liveagent"."qu_g_translations" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2015-12-04 15:45:01 7fe9ce9fa700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-12-04 15:45:01 7fe9ce9fa700 InnoDB: Error: Fetch of persistent statistics requested for table "zadmin_liveagent"."qu_la_agent_phones" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2015-12-04 15:45:01 7fe9ce9fa700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-12-04 15:45:01 7fe9ce9fa700 InnoDB: Error: Fetch of persistent statistics requested for table "zadmin_liveagent"."qu_la_browsers" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2015-12-04 15:45:01 7fe9ce9fa700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-12-04 15:45:01 7fe9ce9fa700 InnoDB: Error: Fetch of persistent statistics requested for table "zadmin_liveagent"."qu_la_cloopen_accounts" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2015-12-04 15:45:01 7fe9ce9fa700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-12-04 15:45:01 7fe9ce9fa700 InnoDB: Error: Fetch of persistent statistics requested for table "zadmin_liveagent"."qu_la_conversation_sla_history" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2015-12-04 15:45:01 7fe9ce9fa700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-12-04 15:45:01 7fe9ce9fa700 InnoDB: Error: Fetch of persistent statistics requested for table "zadmin_liveagent"."qu_la_conversation_sla_reports_hourly" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2015-12-04 15:45:01 7fe9ce9fa700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-12-04 15:45:01 7fe9ce9fa700 InnoDB: Error: Fetch of persistent statistics requested for table "zadmin_liveagent"."qu_la_conversations_mass_actions" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2015-12-04 15:45:01 7fe9ce9fa700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-12-04 15:45:01 7fe9ce9fa700 InnoDB: Error: Fetch of persistent statistics requested for table "zadmin_liveagent"."qu_la_kb_entries_votes" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2015-12-04 15:45:01 7fe9ce9fa700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-12-04 15:45:01 7fe9ce9fa700 InnoDB: Error: Fetch of persistent statistics requested for table "zadmin_liveagent"."qu_la_phone_number_attributes" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2015-12-04 15:45:01 7fe9ce9fa700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-12-04 15:45:01 7fe9ce9fa700 InnoDB: Error: Fetch of persistent statistics requested for table "zadmin_liveagent"."qu_la_phones" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2015-12-04 15:45:05 7fe9c57fb700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-12-04 15:45:05 7fe9c57fb700 InnoDB: Recalculation of persistent statistics requested for table "zadmin_liveagent"."qu_la_browser_visits" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. 2015-12-04 15:46:59 7fe9c57fb700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-12-04 15:46:59 7fe9c57fb700 InnoDB: Recalculation of persistent statistics requested for table "zadmin_liveagent"."qu_g_eventsubscriptions" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. 2015-12-04 15:47:09 7fe9c57fb700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-12-04 15:47:09 7fe9c57fb700 InnoDB: Recalculation of persistent statistics requested for table "zadmin_liveagent"."qu_g_eventsubscriptions" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. 2015-12-04 15:47:20 7fe9c57fb700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-12-04 15:47:20 7fe9c57fb700 InnoDB: Recalculation of persistent statistics requested for table "zadmin_liveagent"."qu_g_eventqueues" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. 2015-12-04 15:47:30 7fe9c57fb700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-12-04 15:47:30 7fe9c57fb700 InnoDB: Recalculation of persistent statistics requested for table "zadmin_liveagent"."qu_g_eventsubscriptions" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. 2015-12-04 15:47:40 7fe9c57fb700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-12-04 15:47:40 7fe9c57fb700 InnoDB: Recalculation of persistent statistics requested for table "zadmin_liveagent"."qu_g_eventqueues" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. 2015-12-04 15:47:52 7fe9c57fb700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-12-04 15:47:52 7fe9c57fb700 InnoDB: Recalculation of persistent statistics requested for table "zadmin_liveagent"."qu_g_eventqueues" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. 2015-12-04 15:48:04 7fe9c57fb700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-12-04 15:48:04 7fe9c57fb700 InnoDB: Recalculation of persistent statistics requested for table "zadmin_liveagent"."qu_g_eventqueues" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. 2015-12-04 15:48:23 7fe9c57fb700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-12-04 15:48:23 7fe9c57fb700 InnoDB: Recalculation of persistent statistics requested for table "zadmin_liveagent"."qu_g_eventsubscriptions" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. 2015-12-04 15:48:30 7fe9ceb80700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-12-04 15:48:30 7fe9ceb80700 InnoDB: Error: Fetch of persistent statistics requested for table "sentora_core"."x_modcats" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2015-12-04 15:48:30 7fe9ceb80700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-12-04 15:48:30 7fe9ceb80700 InnoDB: Error: Fetch of persistent statistics requested for table "sentora_core"."x_mailboxes" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2015-12-04 15:48:30 7fe9ceb80700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-12-04 15:48:30 7fe9ceb80700 InnoDB: Error: Fetch of persistent statistics requested for table "sentora_core"."x_forwarders" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2015-12-04 15:48:30 7fe9ceb80700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-12-04 15:48:30 7fe9ceb80700 InnoDB: Error: Fetch of persistent statistics requested for table "sentora_core"."x_distlists" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2015-12-04 15:48:33 7fe9c57fb700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-12-04 15:48:33 7fe9c57fb700 InnoDB: Recalculation of persistent statistics requested for table "zadmin_liveagent"."qu_g_eventqueues" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. 2015-12-04 15:51:35 2026 [ERROR] Incorrect definition of table mysql.proc: expected column 'comment' at position 15 to have type text, found type char(64). 2015-12-04 15:51:35 2026 [ERROR] Missing system table mysql.proxies_priv; please run mysql_upgrade to create it 2015-12-04 15:51:41 2026 [ERROR] Missing system table mysql.proxies_priv; please run mysql_upgrade to create it
Well as nobody wanted to help me.. i fixed it myself.
Here is the Ultimate guide.. (REMEMBER after Each MySQL upgrade you should run mysql_upgrade!!) That was the ultimate fix for me everything works now. also in sentora. //Add Remi Repo # wget http://rpms.famillecollet.com/enterprise...ease-6.rpm # rpm -Uvh remi-release-6*.rpm // Update to PHP 5.6.8 # yum --enablerepo=remi-php56,remi update php\* Update to Mysql 5.5.43 # yum --enablerepo=remi install mysql mysql-server mysql_upgrade -uroot -ptheRootPassword update naar 5.6 wget https://repo.mysql.com/mysql-community-release-el6.rpm rpm -Uvh mysql-community-release-el6*.rpm yum update mysql Y chkconfig --level 345 mysqld on reboot mysql_upgrade -uroot -ptheRootPassword What do you mean 'Nobody wanted to help me'? We both were helping you! And we both said read the logs and when you finally did you found the problem! From me: Quote:Check the logs, 99% of the answers are in there. From your logs: Quote:2015-12-04 15:51:35 2026 [ERROR] Missing system table mysql.proxies_priv; please run mysql_upgrade to create it Your solution: Quote:(REMEMBER after Each MySQL upgrade you should run mysql_upgrade!!) You are welcome. Just remember this could cause issues down the road when we post patches or upgrades. On another note, you should repost your upgrade solution in the 'Community Guides' section so others xan find it if they want to try it also.
RE: How to update mySQL to version 5.6?
12-05-2015, 08:35 PM
(This post was last modified: 12-05-2015, 08:37 PM by Me.B.)
Ok good to see it fixed.
Also you should backup your DB every time you attempt such DB upgrades. And beside that I would rather opt for MySQL-community repo instead of remi as it exist here and it's an official repos from the software vendor: https://dev.mysql.com/doc/mysql-repo-exc...-repo.html For PHP we don't have such. M B
No support using PM (Auto adding to IGNORE list!), use the forum.
How to ask 10$ free to start your VPS
Estou tentando atualizar para php 5.6, mas sem sucesso
Meu php 5. 3. Sentora (1.0.3)! Gostaria que a ajuda urgente para a revisão 5,3-5,6 Ubuntu 12
use ubuntu 14 and you will get php 5.5.
No support using PM (Auto adding to IGNORE list!), use the forum.
How to ask 10$ free to start your VPS |
« Next Oldest | Next Newest »
|
Possibly Related Threads… | |||||
Thread | Author | Replies | Views | Last Post | |
How to upgrade php and mysql version? | davidlambda | 4 | 30 ,018 |
03-11-2020, 06:16 PM Last Post: davidlambda |
|
Official Upgrade php version? | visionix | 7 | 31 ,799 |
01-13-2020, 07:17 AM Last Post: Vedran B |
|
How to install older sentora with older mysql version | atomiq | 0 | 4 ,782 |
11-30-2019, 04:27 PM Last Post: atomiq |