This forum uses cookies
This forum makes use of cookies to store your login information if you are registered, and your last visit if you are not. Cookies are small text documents stored on your computer; the cookies set by this forum can only be used on this website and pose no security risk. Cookies on this forum also track the specific topics you have read and when you last read them. Please confirm whether you accept or reject these cookies being set.

A cookie will be stored in your browser regardless of choice to prevent you being asked this question again. You will be able to change your cookie settings at any time using the link in the footer.

How to update mySQL to version 5.6?
#11
RE: 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
Freelance AWS Certified Architect & SysOps// DevOps

10$ free to start your VPS
Reply
Thanks given by:
#12
RE: How to update mySQL to version 5.6?
This is the exact error.

How can we solve this?

Application Error: [0204] - The form you attempted to submit had an invalid token!
Reply
Thanks given by:
#13
RE: How to update mySQL to version 5.6?
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
Freelance AWS Certified Architect & SysOps// DevOps

10$ free to start your VPS
Reply
Thanks given by:
#14
RE: How to update mySQL to version 5.6?
(12-05-2015, 01:34 AM)Me.B Wrote: 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?
Reply
Thanks given by:
#15
RE: How to update mySQL to version 5.6?
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
Reply
Thanks given by:
#16
RE: How to update mySQL to version 5.6?
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
Reply
Thanks given by:
#17
RE: How to update mySQL to version 5.6?
Huh
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.
-TGates - Project Council

SEARCH the Forums or read the DOCUMENTATION before posting!
Support Sentora and Donate: HERE

Find my support or modules useful? Donate to TGates HERE
Developers and code testers needed!
Contact TGates for more information
Reply
Thanks given by:
#18
RE: How to update mySQL to version 5.6?
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
Freelance AWS Certified Architect & SysOps// DevOps

10$ free to start your VPS
Reply
Thanks given by:
#19
RE: How to update mySQL to version 5.6?
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
Reply
Thanks given by:
#20
RE: How to update mySQL to version 5.6?
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
Freelance AWS Certified Architect & SysOps// DevOps

10$ free to start your VPS
Reply
Thanks given by:


Possibly Related Threads…
Thread Author Replies Views Last Post
How to upgrade php and mysql version? davidlambda 4 28 ,531 03-11-2020, 06:16 PM
Last Post: davidlambda
Official Upgrade php version? visionix 7 29 ,712 01-13-2020, 07:17 AM
Last Post: Vedran B
How to install older sentora with older mysql version atomiq 0 4 ,453 11-30-2019, 04:27 PM
Last Post: atomiq

Forum Jump:


Users browsing this thread: 3 Guest(s)