How to update mySQL to version 5.6?

[Me.B]

Thanks to avoid double posting issues. We should continue here.

[jeremyotten]

This is the exact error.

How can we solve this?

Application Error: [0204] - The form you attempted to submit had an invalid token!

[Me.B]

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

[jeremyotten]

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

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?

[jeremyotten]

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

[jeremyotten]

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

[TGates]

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:

Check the logs, 99% of the answers are in there.

From your logs:

2015-12-04 15:51:35 2026 [ERROR] Missing system table mysql.proxies_priv; please run mysql_upgrade to create it

Your solution:

(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.

[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

[claudiobiato]

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

[Me.B]

use ubuntu 14 and you will get php 5.5.