>>> [!note] Migrated issue <!-- Drupal.org comment --> <!-- Migrated from issue #202385. --> Reported by: [kwikone](https://www.drupal.org/user/112236) >>> <p>Keep getting many warning about the folloing MySQL data types<br> # No Schema type for mysql type char. (Get dozens of these)<br> # No Schema type for mysql type timestamp. (Get many of these)<br> # No Schema type for mysql type decimal. (Get some of these)<br> # No Schema type for mysql type enum. (Get some of these)<br> # No Schema type for mysql type date. (Get some of these)<br> # No Schema type for mysql type set. (Get some of these)<br> # No Schema type for mysql type year. (Get a few of these)<br> # No Schema type for mysql type mediumblob. (Get a few of these)<br> # No Schema type for mysql type tinytext. (Get a few of these).</p> <p>PLUS,<br> The Schema comparison report shows:</p> <p> * 217 extra tables<br> * 22 module with missing tables<br> * 1 module with mis-matching tables</p> <p>Note that it IS seeing tables from other applications within the same database (Different table prefixes) which it should not be if it was using the installed database table prefix.</p> <p>The comparison report indicates (from a basically a fresh install):<br> Tables in the schema that are not present in the database.<br> forum</p> <p> * forum</p> <p>user</p> <p> * access<br> * authmap<br> * permission<br> * role<br> * users_roles</p> <p>upload</p> <p> * upload</p> <p>update</p> <p> * cache_update</p> <p>trigger</p> <p> * trigger_assignments</p> <p>taxonomy</p> <p> * term_data<br> * term_hierarchy<br> * term_node<br> * term_relation<br> * term_synonym<br> * vocabulary<br> * vocabulary_node_types</p> <p>system</p> <p> * variable<br> * actions<br> * actions_aid<br> * batch<br> * cache<br> * cache_form<br> * cache_page<br> * cache_menu<br> * files<br> * flood<br> * history<br> * menu_router<br> * menu_links<br> * sessions<br> * system<br> * url_alias</p> <p>statistics</p> <p> * accesslog</p> <p>search</p> <p> * search_dataset<br> * search_index<br> * search_total<br> * search_node_links</p> <p>profile</p> <p> * profile_fields<br> * profile_values</p> <p>poll</p> <p> * poll<br> * poll_choices<br> * poll_votes</p> <p>openid</p> <p> * openid_association</p> <p>node</p> <p> * node<br> * node_access<br> * node_counter<br> * node_revisions<br> * node_type</p> <p>menu</p> <p> * menu_custom</p> <p>locale</p> <p> * languages<br> * locales_source<br> * locales_target</p> <p>filter</p> <p> * filters<br> * filter_formats<br> * cache_filter</p> <p>dblog</p> <p> * watchdog</p> <p>contact</p> <p> * contact</p> <p>comment</p> <p> * comments<br> * node_comment_statistics</p> <p>book</p> <p> * book</p> <p>block</p> <p> * blocks<br> * blocks_roles<br> * boxes<br> * cache_block</p> <p>sections</p> <p> * sections_data</p> <p>And finally, ...<br> Tables where schema and database are different<br> *<br> users<br> o uid: not in database<br> o name: not in database<br> o pass: not in database<br> o mail: not in database<br> o mode: not in database<br> o sort: not in database<br> o threshold: not in database<br> o theme: not in database<br> o signature: not in database<br> o created: not in database<br> o access: not in database<br> o login: not in database<br> o status: not in database<br> o timezone: not in database<br> o language: not in database<br> o picture: not in database<br> o init: not in database<br> o data: not in database<br> o user_name: unexpected column in database<br> o user_group: unexpected column in database<br> o user_passwd: unexpected column in database<br> o user_pw: unexpected column in database<br> o ts: unexpected column in database<br> o user_id: unexpected column in database<br> o primary key:<br> declared: array('uid')<br> actual: array('user_name')<br> o unique keys name: missing in database<br> o indexes access: missing in database<br> o indexes created: missing in database<br> o unique keys fk_user_id: unexpected (not an error)<br> o indexes fk_user_group: unexpected (not an error)</p> <p>I suspect that this is probably due to not looking at the correct users table</p>