c64girl Posted May 25, 2016 Share Posted May 25, 2016 I have prestashop 1.6.0.11 i cant update to newest because of template an multistore and some plugins that dont work on new PS. I have this kind of error in the log on server. If someone could help i will be very happy. 2016-05-18 14:20:35 7f5b64101b00 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch). 2016-05-18 14:20:35 7f5b64101b00 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch). 2016-05-18 14:20:35 7f5b63fd9b00 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch). 2016-05-18 14:20:35 7f5b63fd9b00 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch). 2016-05-18 14:20:35 7f5b63fd9b00 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch). 2016-05-18 14:20:35 7f5b64101b00 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch). 2016-05-18 14:20:35 7f5b64101b00 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch). 2016-05-18 14:20:35 7f5b64101b00 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch). 2016-05-18 14:20:36 7f5b64101b00 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch). 2016-05-18 14:20:36 7f5b64101b00 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch). 2016-05-18 14:20:36 7f5b64101b00 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch). 2016-05-18 14:20:37 7f5b63fd9b00 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch). 2016-05-18 14:20:37 7f5b63fd9b00 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch). 2016-05-18 14:20:39 7f5b5fd2db00 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch). 2016-05-18 14:20:39 7f5b5fd2db00 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch). 2016-05-18 14:20:39 7f5b5fd2db00 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch). 2016-05-18 14:20:39 7f5b5fd2db00 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch). 2016-05-18 14:20:39 7f5b5fd2db00 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch). 2016-05-18 14:20:39 7f5b5fd2db00 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch). 2016-05-18 14:20:39 7f5b5fd2db00 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch). 2016-05-18 14:20:39 7f5b5fd2db00 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch). 2016-05-18 14:20:39 7f5b5fd2db00 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch). 2016-05-18 14:20:41 7f5b64023b00 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch). 2016-05-18 14:20:41 7f5b64023b00 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch). 2016-05-18 14:20:44 7f5b6406db00 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch). 2016-05-18 14:20:44 7f5b6406db00 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch). 2016-05-18 14:20:44 7f5b6406db00 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch). 2016-05-18 14:20:47 7f5b5fe9fb00 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch). 2016-05-18 14:20:47 7f5b5fe9fb00 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch). 2016-05-18 14:20:47 7f5b5fe9fb00 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch). 2016-05-06 09:38:11 7f2986a1db00 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch). 2016-05-06 09:38:11 7f2986a1db00 InnoDB: Error: Fetch of persistent statistics requested for table "roundcubemail"."session" 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. 2016-05-06 09:38:11 7f2986a1db00 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch). 2016-05-06 09:38:11 7f2986a1db00 InnoDB: Error: Fetch of persistent statistics requested for table "roundcubemail"."users" 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. 2016-05-06 09:38:25 7f2985979b00 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch). 2016-05-06 09:38:25 7f2985979b00 InnoDB: Error: Fetch of persistent statistics requested for table "c1supermami"."ps_shop_url" 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. 2016-05-06 09:38:25 7f2985979b00 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch). 2016-05-06 09:38:25 7f2985979b00 InnoDB: Error: Fetch of persistent statistics requested for table "c1supermami"."ps_shop" 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. 2016-05-06 09:38:25 7f2985979b00 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch). 2016-05-06 09:38:25 7f2985979b00 InnoDB: Error: Fetch of persistent statistics requested for table "c1supermami"."ps_shop_group" 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. 2016-05-06 09:38:25 7f2985979b00 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch). 2016-05-06 09:38:25 7f2985979b00 InnoDB: Error: Fetch of persistent statistics requested for table "c1supermami"."ps_configuration" 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. 2016-05-06 09:38:25 7f2985979b00 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch). 2016-05-06 09:38:25 7f2985979b00 InnoDB: Error: Fetch of persistent statistics requested for table "c1supermami"."ps_configuration_lang" 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. 2016-05-06 09:38:25 7f2985979b00 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch). 2016-05-06 09:38:25 7f2985979b00 InnoDB: Error: Fetch of persistent statistics requested for table "c1supermami"."ps_theme" 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. 2016-05-06 09:38:25 7f2985979b00 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch). 2016-05-06 09:38:25 7f2985979b00 InnoDB: Error: Fetch of persistent statistics requested for table "c1supermami"."ps_lang" 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. 2016-05-06 09:38:25 7f2985979b00 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch). 2016-05-06 09:38:25 7f2985979b00 InnoDB: Error: Fetch of persistent statistics requested for table "c1supermami"."ps_lang_shop" 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. 2016-05-06 09:38:25 7f2985979b00 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch). 2016-05-06 09:38:25 7f2985979b00 InnoDB: Error: Fetch of persistent statistics requested for table "c1supermami"."ps_country" 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. 2016-05-06 09:38:25 7f2985979b00 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch). 2016-05-06 09:38:25 7f2985979b00 InnoDB: Error: Fetch of persistent statistics requested for table "c1supermami"."ps_country_lang" 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. 2016-05-06 09:38:25 7f2985979b00 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch). 2016-05-06 09:38:25 7f2985979b00 InnoDB: Error: Fetch of persistent statistics requested for table "c1supermami"."ps_country_shop" 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. 2016-05-06 09:38:25 7f2985979b00 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch). 2016-05-06 09:38:25 7f2985979b00 InnoDB: Error: Fetch of persistent statistics requested for table "c1supermami"."ps_module" 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. 2016-05-06 09:38:25 7f2985979b00 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch). 2016-05-06 09:38:25 7f2985979b00 InnoDB: Error: Fetch of persistent statistics requested for table "c1supermami"."ps_module_shop" 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. 2016-05-06 09:38:25 7f2985979b00 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch). 2016-05-06 09:38:25 7f2985979b00 InnoDB: Error: Fetch of persistent statistics requested for table "c1supermami"."ps_hook_module" 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. 2016-05-06 09:38:25 7f2985979b00 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch). 2016-05-06 09:38:25 7f2985979b00 InnoDB: Error: Fetch of persistent statistics requested for table "c1supermami"."ps_hook" 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. 2016-05-06 09:38:25 7f2985979b00 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch). 2016-05-06 09:38:25 7f2985979b00 InnoDB: Error: Fetch of persistent statistics requested for table "c1supermami"."ps_module_group" 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. 2016-05-06 09:38:25 7f2985979b00 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch). 2016-05-06 09:38:25 7f2985979b00 InnoDB: Error: Fetch of persistent statistics requested for table "c1supermami"."ps_hook_alias" 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. 2016-05-06 09:38:25 7f2985979b00 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch). 2016-05-06 09:38:25 7f2985979b00 InnoDB: Error: Fetch of persistent statistics requested for table "c1supermami"."ps_meta" 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. 2016-05-06 09:38:25 7f2985979b00 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch). 2016-05-06 09:38:25 7f2985979b00 InnoDB: Error: Fetch of persistent statistics requested for table "c1supermami"."ps_meta_lang" 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. 2016-05-06 09:38:25 7f2985979b00 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch). 2016-05-06 09:38:25 7f2985979b00 InnoDB: Error: Fetch of persistent statistics requested for table "c1supermami"."ps_theme_meta" 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. 2016-05-06 09:38:25 7f2985979b00 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch). 2016-05-06 09:38:25 7f2985979b00 InnoDB: Error: Fetch of persistent statistics requested for table "c1supermami"."ps_currency" 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. 2016-05-06 09:38:25 7f2985979b00 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch). 2016-05-06 09:38:25 7f2985979b00 InnoDB: Error: Fetch of persistent statistics requested for table "c1supermami"."ps_currency_shop" 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. 2016-05-06 09:38:25 7f2985979b00 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch). 2016-05-06 09:38:25 7f2985979b00 InnoDB: Error: Fetch of persistent statistics requested for table "c1supermami"."ps_group" 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. 2016-05-06 09:38:25 7f2985979b00 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch). 2016-05-06 09:38:25 7f2985979b00 InnoDB: Error: Fetch of persistent statistics requested for table "c1supermami"."ps_group_shop" 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. 2016-05-06 09:38:25 7f2985979b00 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch). 2016-05-06 09:38:25 7f2985979b00 InnoDB: Error: Fetch of persistent statistics requested for table "c1supermami"."ps_group_lang" 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. 2016-05-06 09:38:25 7f2985979b00 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch). 2016-05-06 09:38:25 7f2985979b00 InnoDB: Error: Fetch of persistent statistics requested for table "c1supermami"."ps_hook_module_exceptions" 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. Link to comment Share on other sites More sharing options...
bellini13 Posted May 25, 2016 Share Posted May 25, 2016 seems to me that your database is in a failed state. You should contact your hosting provider and have them review these errors and fix the problem. This is nothing to do with Prestashop. Link to comment Share on other sites More sharing options...
El Patron Posted May 25, 2016 Share Posted May 25, 2016 some helpful links about PS and what I assume is 1) an upgraded shop and 2) maria db https://github.com/WPN-XM/WPN-XM/issues/361 this is link to similar, hope this helps https://www.google.com/webhp?sourceid=chrome-instant&ion=1&espv=2&ie=UTF-8#q=mysql+INT+UNSIGNED+NOT+NULL+but+should+be+BINARY Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now