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.0020 | 417144 | {main}( ) | .../index.php:0 |
2 | 0.0967 | 4723056 | Joomla\CMS\Application\SiteApplication->execute( ) | .../index.php:49 |
3 | 0.0967 | 4723056 | Joomla\CMS\Application\SiteApplication->doExecute( ) | .../CMSApplication.php:196 |
4 | 0.3047 | 12451752 | Joomla\CMS\Application\SiteApplication->dispatch( ) | .../SiteApplication.php:233 |
5 | 0.3053 | 12476816 | Joomla\CMS\Component\ComponentHelper::renderComponent( ) | .../SiteApplication.php:194 |
6 | 0.3061 | 12532144 | Joomla\CMS\Component\ComponentHelper::executeComponent( ) | .../ComponentHelper.php:377 |
7 | 0.3064 | 12560968 | require_once( '/var/www/vhosts/shan.info/httpdocs/components/com_k2/k2.php' ) | .../ComponentHelper.php:402 |
8 | 0.3152 | 12996376 | K2ControllerItem->execute( ) | .../k2.php:64 |
9 | 0.3152 | 12996376 | K2ControllerItem->display( ) | .../BaseController.php:710 |
10 | 0.3269 | 13721576 | K2ControllerItem->display( ) | .../item.php:78 |
11 | 0.3269 | 13721576 | K2ControllerItem->display( ) | .../controller.php:19 |
12 | 0.3311 | 14117944 | Joomla\CMS\Cache\Controller\ViewController->get( ) | .../BaseController.php:663 |
13 | 0.3340 | 14138312 | K2ViewItem->display( ) | .../ViewController.php:102 |
14 | 0.4531 | 17101904 | K2ViewItem->display( ) | .../view.html.php:742 |
15 | 0.4531 | 17101904 | K2ViewItem->loadTemplate( ) | .../HtmlView.php:230 |
16 | 0.4613 | 17282104 | include( '/var/www/vhosts/shan.info/httpdocs/templates/gk_publisher/html/com_k2/templates/default/item.php' ) | .../HtmlView.php:701 |
- Published in MYSQL
- Read 1292 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.0020 | 417144 | {main}( ) | .../index.php:0 |
2 | 0.0967 | 4723056 | Joomla\CMS\Application\SiteApplication->execute( ) | .../index.php:49 |
3 | 0.0967 | 4723056 | Joomla\CMS\Application\SiteApplication->doExecute( ) | .../CMSApplication.php:196 |
4 | 0.3047 | 12451752 | Joomla\CMS\Application\SiteApplication->dispatch( ) | .../SiteApplication.php:233 |
5 | 0.3053 | 12476816 | Joomla\CMS\Component\ComponentHelper::renderComponent( ) | .../SiteApplication.php:194 |
6 | 0.3061 | 12532144 | Joomla\CMS\Component\ComponentHelper::executeComponent( ) | .../ComponentHelper.php:377 |
7 | 0.3064 | 12560968 | require_once( '/var/www/vhosts/shan.info/httpdocs/components/com_k2/k2.php' ) | .../ComponentHelper.php:402 |
8 | 0.3152 | 12996376 | K2ControllerItem->execute( ) | .../k2.php:64 |
9 | 0.3152 | 12996376 | K2ControllerItem->display( ) | .../BaseController.php:710 |
10 | 0.3269 | 13721576 | K2ControllerItem->display( ) | .../item.php:78 |
11 | 0.3269 | 13721576 | K2ControllerItem->display( ) | .../controller.php:19 |
12 | 0.3311 | 14117944 | Joomla\CMS\Cache\Controller\ViewController->get( ) | .../BaseController.php:663 |
13 | 0.3340 | 14138312 | K2ViewItem->display( ) | .../ViewController.php:102 |
14 | 0.4531 | 17101904 | K2ViewItem->display( ) | .../view.html.php:742 |
15 | 0.4531 | 17101904 | K2ViewItem->loadTemplate( ) | .../HtmlView.php:230 |
16 | 0.4613 | 17282104 | include( '/var/www/vhosts/shan.info/httpdocs/templates/gk_publisher/html/com_k2/templates/default/item.php' ) | .../HtmlView.php:701 |