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.0008 | 413064 | {main}( ) | .../index.php:0 |
2 | 0.0959 | 4263688 | Joomla\CMS\Application\SiteApplication->execute( ) | .../index.php:49 |
3 | 0.0959 | 4263688 | Joomla\CMS\Application\SiteApplication->doExecute( ) | .../CMSApplication.php:196 |
4 | 0.4383 | 11454896 | Joomla\CMS\Application\SiteApplication->dispatch( ) | .../SiteApplication.php:233 |
5 | 0.4390 | 11479880 | Joomla\CMS\Component\ComponentHelper::renderComponent( ) | .../SiteApplication.php:194 |
6 | 0.4397 | 11535208 | Joomla\CMS\Component\ComponentHelper::executeComponent( ) | .../ComponentHelper.php:377 |
7 | 0.4400 | 11562608 | require_once( '/var/www/vhosts/shan.info/httpdocs/components/com_k2/k2.php' ) | .../ComponentHelper.php:402 |
8 | 0.4476 | 11962240 | K2ControllerItem->execute( ) | .../k2.php:64 |
9 | 0.4476 | 11962240 | K2ControllerItem->display( ) | .../BaseController.php:710 |
10 | 0.4571 | 12612944 | K2ControllerItem->display( ) | .../item.php:78 |
11 | 0.4571 | 12612944 | K2ControllerItem->display( ) | .../controller.php:19 |
12 | 0.4613 | 12983984 | Joomla\CMS\Cache\Controller\ViewController->get( ) | .../BaseController.php:663 |
13 | 0.4621 | 13004352 | K2ViewItem->display( ) | .../ViewController.php:102 |
14 | 0.5204 | 15834392 | K2ViewItem->display( ) | .../view.html.php:742 |
15 | 0.5204 | 15834392 | K2ViewItem->loadTemplate( ) | .../HtmlView.php:230 |
16 | 0.5220 | 16007328 | include( '/var/www/vhosts/shan.info/httpdocs/templates/gk_publisher/html/com_k2/templates/default/item.php' ) | .../HtmlView.php:701 |
- Published in MYSQL
- Read 1289 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.0008 | 413064 | {main}( ) | .../index.php:0 |
2 | 0.0959 | 4263688 | Joomla\CMS\Application\SiteApplication->execute( ) | .../index.php:49 |
3 | 0.0959 | 4263688 | Joomla\CMS\Application\SiteApplication->doExecute( ) | .../CMSApplication.php:196 |
4 | 0.4383 | 11454896 | Joomla\CMS\Application\SiteApplication->dispatch( ) | .../SiteApplication.php:233 |
5 | 0.4390 | 11479880 | Joomla\CMS\Component\ComponentHelper::renderComponent( ) | .../SiteApplication.php:194 |
6 | 0.4397 | 11535208 | Joomla\CMS\Component\ComponentHelper::executeComponent( ) | .../ComponentHelper.php:377 |
7 | 0.4400 | 11562608 | require_once( '/var/www/vhosts/shan.info/httpdocs/components/com_k2/k2.php' ) | .../ComponentHelper.php:402 |
8 | 0.4476 | 11962240 | K2ControllerItem->execute( ) | .../k2.php:64 |
9 | 0.4476 | 11962240 | K2ControllerItem->display( ) | .../BaseController.php:710 |
10 | 0.4571 | 12612944 | K2ControllerItem->display( ) | .../item.php:78 |
11 | 0.4571 | 12612944 | K2ControllerItem->display( ) | .../controller.php:19 |
12 | 0.4613 | 12983984 | Joomla\CMS\Cache\Controller\ViewController->get( ) | .../BaseController.php:663 |
13 | 0.4621 | 13004352 | K2ViewItem->display( ) | .../ViewController.php:102 |
14 | 0.5204 | 15834392 | K2ViewItem->display( ) | .../view.html.php:742 |
15 | 0.5204 | 15834392 | K2ViewItem->loadTemplate( ) | .../HtmlView.php:230 |
16 | 0.5220 | 16007328 | include( '/var/www/vhosts/shan.info/httpdocs/templates/gk_publisher/html/com_k2/templates/default/item.php' ) | .../HtmlView.php:701 |