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
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.0021 | 416296 | {main}( ) | .../index.php:0 |
| 2 | 0.0891 | 4722208 | Joomla\CMS\Application\SiteApplication->execute( ) | .../index.php:49 |
| 3 | 0.0891 | 4722208 | Joomla\CMS\Application\SiteApplication->doExecute( ) | .../CMSApplication.php:196 |
| 4 | 0.2991 | 12450904 | Joomla\CMS\Application\SiteApplication->dispatch( ) | .../SiteApplication.php:233 |
| 5 | 0.2998 | 12475968 | Joomla\CMS\Component\ComponentHelper::renderComponent( ) | .../SiteApplication.php:194 |
| 6 | 0.3004 | 12531296 | Joomla\CMS\Component\ComponentHelper::executeComponent( ) | .../ComponentHelper.php:377 |
| 7 | 0.3007 | 12560120 | require_once( '/var/www/vhosts/shan.info/httpdocs/components/com_k2/k2.php' ) | .../ComponentHelper.php:402 |
| 8 | 0.3085 | 12995528 | K2ControllerItem->execute( ) | .../k2.php:64 |
| 9 | 0.3085 | 12995528 | K2ControllerItem->display( ) | .../BaseController.php:710 |
| 10 | 0.3179 | 13720728 | K2ControllerItem->display( ) | .../item.php:78 |
| 11 | 0.3179 | 13720728 | K2ControllerItem->display( ) | .../controller.php:19 |
| 12 | 0.3219 | 14117096 | Joomla\CMS\Cache\Controller\ViewController->get( ) | .../BaseController.php:663 |
| 13 | 0.3250 | 14137464 | K2ViewItem->display( ) | .../ViewController.php:102 |
| 14 | 0.3989 | 17101056 | K2ViewItem->display( ) | .../view.html.php:742 |
| 15 | 0.3989 | 17101056 | K2ViewItem->loadTemplate( ) | .../HtmlView.php:230 |
| 16 | 0.4009 | 17281256 | include( '/var/www/vhosts/shan.info/httpdocs/templates/gk_publisher/html/com_k2/templates/default/item.php' ) | .../HtmlView.php:701 |
- Published in MYSQL
- Read 1291 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.0021 | 416296 | {main}( ) | .../index.php:0 |
| 2 | 0.0891 | 4722208 | Joomla\CMS\Application\SiteApplication->execute( ) | .../index.php:49 |
| 3 | 0.0891 | 4722208 | Joomla\CMS\Application\SiteApplication->doExecute( ) | .../CMSApplication.php:196 |
| 4 | 0.2991 | 12450904 | Joomla\CMS\Application\SiteApplication->dispatch( ) | .../SiteApplication.php:233 |
| 5 | 0.2998 | 12475968 | Joomla\CMS\Component\ComponentHelper::renderComponent( ) | .../SiteApplication.php:194 |
| 6 | 0.3004 | 12531296 | Joomla\CMS\Component\ComponentHelper::executeComponent( ) | .../ComponentHelper.php:377 |
| 7 | 0.3007 | 12560120 | require_once( '/var/www/vhosts/shan.info/httpdocs/components/com_k2/k2.php' ) | .../ComponentHelper.php:402 |
| 8 | 0.3085 | 12995528 | K2ControllerItem->execute( ) | .../k2.php:64 |
| 9 | 0.3085 | 12995528 | K2ControllerItem->display( ) | .../BaseController.php:710 |
| 10 | 0.3179 | 13720728 | K2ControllerItem->display( ) | .../item.php:78 |
| 11 | 0.3179 | 13720728 | K2ControllerItem->display( ) | .../controller.php:19 |
| 12 | 0.3219 | 14117096 | Joomla\CMS\Cache\Controller\ViewController->get( ) | .../BaseController.php:663 |
| 13 | 0.3250 | 14137464 | K2ViewItem->display( ) | .../ViewController.php:102 |
| 14 | 0.3989 | 17101056 | K2ViewItem->display( ) | .../view.html.php:742 |
| 15 | 0.3989 | 17101056 | K2ViewItem->loadTemplate( ) | .../HtmlView.php:230 |
| 16 | 0.4009 | 17281256 | include( '/var/www/vhosts/shan.info/httpdocs/templates/gk_publisher/html/com_k2/templates/default/item.php' ) | .../HtmlView.php:701 |