mysqldump: Couldn’t execute ‘SHOW FUNCTION STATUS WHERE Db = ‘your-db-here”: Column count of mysql.proc is wrong. Expected 20, found 16. Created with MySQL 50077, now running 50152. Please use mysql_upgrade to fix this error. (1558)
- font size decrease font size increase font size
- Print Email
mysqldump: Couldn’t execute ‘SHOW FUNCTION STATUS WHERE Db = ‘your-db-here”: Column count of mysql.proc is wrong. Expected 20, found 16. Created with MySQL 50077, now running 50152. Please use mysql_upgrade to fix this error. (1558)
/usr/bin/mysql_upgrade -uxxxx -pxxxxxx
如果你的webmin/virtualmin自动备份出现下面的错误,那么,就是mysql升级后没有做mysql_upgrade 表修复。 在新版下执行mysql_upgrade命令,其实这个命令包含一下三个命令:
# mysqlcheck –check-upgrade –all-databases –auto-repai
# mysql_fix_privilege_tables
# mysqlcheck –all-databases –check-upgrade –fix-db-names –fix-table-names
Note: 在每一次的升级过程中,mysql_upgrade这个命令我们都应该去执行,它通过mysqlcheck命令帮我们去检查表是否兼容新版本的数据库同时作出修复,还有个很重要的作用就是使用mysql_fix_privilege_tables命令去升级权限表。
Last modified onSaturday, 05 January 2013 13:01
( ! ) Warning: count(): Parameter must be an array or an object that implements Countable in /var/www/vhosts/shan.info/httpdocs/templates/gk_publisher/html/com_k2/templates/default/item.php on line 169 | ||||
---|---|---|---|---|
Call Stack | ||||
# | Time | Memory | Function | Location |
1 | 0.0009 | 415472 | {main}( ) | .../index.php:0 |
2 | 0.2231 | 4720728 | Joomla\CMS\Application\SiteApplication->execute( ) | .../index.php:49 |
3 | 0.2231 | 4720728 | Joomla\CMS\Application\SiteApplication->doExecute( ) | .../CMSApplication.php:196 |
4 | 0.5203 | 12449216 | Joomla\CMS\Application\SiteApplication->dispatch( ) | .../SiteApplication.php:233 |
5 | 0.5212 | 12474280 | Joomla\CMS\Component\ComponentHelper::renderComponent( ) | .../SiteApplication.php:194 |
6 | 0.5223 | 12529608 | Joomla\CMS\Component\ComponentHelper::executeComponent( ) | .../ComponentHelper.php:377 |
7 | 0.5226 | 12558432 | require_once( '/var/www/vhosts/shan.info/httpdocs/components/com_k2/k2.php' ) | .../ComponentHelper.php:402 |
8 | 0.5389 | 12993840 | K2ControllerItem->execute( ) | .../k2.php:64 |
9 | 0.5389 | 12993840 | K2ControllerItem->display( ) | .../BaseController.php:710 |
10 | 0.5527 | 13719040 | K2ControllerItem->display( ) | .../item.php:78 |
11 | 0.5527 | 13719040 | K2ControllerItem->display( ) | .../controller.php:19 |
12 | 0.5587 | 14115408 | Joomla\CMS\Cache\Controller\ViewController->get( ) | .../BaseController.php:663 |
13 | 0.6151 | 14135776 | K2ViewItem->display( ) | .../ViewController.php:102 |
14 | 1.1638 | 17098824 | K2ViewItem->display( ) | .../view.html.php:742 |
15 | 1.1638 | 17098824 | K2ViewItem->loadTemplate( ) | .../HtmlView.php:230 |
16 | 1.1900 | 17279024 | include( '/var/www/vhosts/shan.info/httpdocs/templates/gk_publisher/html/com_k2/templates/default/item.php' ) | .../HtmlView.php:701 |
- Published in MYSQL
- Read 1290 times
( ! ) Notice: Only variables should be assigned by reference in /var/www/vhosts/shan.info/httpdocs/templates/gk_publisher/html/com_k2/templates/default/item.php on line 478 | ||||
---|---|---|---|---|
Call Stack | ||||
# | Time | Memory | Function | Location |
1 | 0.0009 | 415472 | {main}( ) | .../index.php:0 |
2 | 0.2231 | 4720728 | Joomla\CMS\Application\SiteApplication->execute( ) | .../index.php:49 |
3 | 0.2231 | 4720728 | Joomla\CMS\Application\SiteApplication->doExecute( ) | .../CMSApplication.php:196 |
4 | 0.5203 | 12449216 | Joomla\CMS\Application\SiteApplication->dispatch( ) | .../SiteApplication.php:233 |
5 | 0.5212 | 12474280 | Joomla\CMS\Component\ComponentHelper::renderComponent( ) | .../SiteApplication.php:194 |
6 | 0.5223 | 12529608 | Joomla\CMS\Component\ComponentHelper::executeComponent( ) | .../ComponentHelper.php:377 |
7 | 0.5226 | 12558432 | require_once( '/var/www/vhosts/shan.info/httpdocs/components/com_k2/k2.php' ) | .../ComponentHelper.php:402 |
8 | 0.5389 | 12993840 | K2ControllerItem->execute( ) | .../k2.php:64 |
9 | 0.5389 | 12993840 | K2ControllerItem->display( ) | .../BaseController.php:710 |
10 | 0.5527 | 13719040 | K2ControllerItem->display( ) | .../item.php:78 |
11 | 0.5527 | 13719040 | K2ControllerItem->display( ) | .../controller.php:19 |
12 | 0.5587 | 14115408 | Joomla\CMS\Cache\Controller\ViewController->get( ) | .../BaseController.php:663 |
13 | 0.6151 | 14135776 | K2ViewItem->display( ) | .../ViewController.php:102 |
14 | 1.1638 | 17098824 | K2ViewItem->display( ) | .../view.html.php:742 |
15 | 1.1638 | 17098824 | K2ViewItem->loadTemplate( ) | .../HtmlView.php:230 |
16 | 1.1900 | 17279024 | include( '/var/www/vhosts/shan.info/httpdocs/templates/gk_publisher/html/com_k2/templates/default/item.php' ) | .../HtmlView.php:701 |