I get:

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'metalface.field_data_field_postal' doesn't exist: ALTER TABLE field_data_field_postal ENGINE = MYISAM; Array ( ) in _similar_add_index() (line 92 of /home/administrator/metalface/sites/all/modules/similar/similar.module).

I see that my table field_data_field_postal is not myISAM, but it is InnoDB. But i will not need that table in similarity. I just need the title and body fields which are already myISAM.

Comments

tfranz’s picture

tfranz CreditAttribution: tfranz commented

After installing and enabling "Similar Entries" i added the text-field "field_data_field_untertitel" – now i get the same error:

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'tabelle.field_data_field_untertitel' doesn't exist: ALTER TABLE field_data_field_untertitel ENGINE = MYISAM; Array ( ) in _similar_add_index() (Zeile 92 von /home/wxyz/public_html/drupal/sites/all/modules/similar/similar.module).

I don't need "field_data_field_untertitel" for this module – how to solve this?

Thank you,

Tobias

Dr.Osd’s picture

Dr.Osd CreditAttribution: Dr.Osd commented

After 1 year sucessful using "Similar Entries" i added the text-field "field_first_name" on admin/config/people/accounts/fields. Now i get the same error in the all cron log:

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'gala.field_data_field_first_name' doesn't exist: ALTER TABLE field_data_field_first_name ENGINE = MYISAM; Array ( ) in _similar_add_index() (line 92 of /var/www/gala/sites/all/modules/similar/similar.module).

Module ultimate_cron have log massage about this errors:

exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'gala.field_data_field_first_name' doesn't exist' in /var/www/gala/includes/database/database.inc:2168 Stack trace: #0 /var/www/gala/includes/database/database.inc(2168): PDOStatement->execute(Array) #1 /var/www/gala/includes/database/database.inc(680): DatabaseStatementBase->execute(Array, Array) #2 /var/www/gala/includes/database/database.inc(2347): DatabaseConnection->query('ALTER TABLE fie...', Array, Array) #3 /var/www/gala/sites/all/modules/similar/similar.module(92): db_query('ALTER TABLE fie...') #4 /var/www/gala/sites/all/modules/similar/similar.module(57): _similar_add_index('field_data_fiel...', Array) #5 [internal function]: similar_cron() #6 /var/www/gala/sites/all/modules/ultimate_cron/ultimate_cron.module(924): call_user_func('similar_cron') #7 [internal function]: _ultimate_cron_run_hook('similar_cron', Array) #8 /var/www/gala/sites/all/modules/background_process/background_process.module(573): call_user_func_array('_ultimate_cron_...', Array) #9 /var/www/gala/sites/all/modules/background_process/background_process.module(502): background_process_service_execute('uc:similar_cron', false) #10 [internal function]: background_process_service_start('uc%3Asimilar_cr...') #11 /var/www/gala/includes/menu.inc(517): call_user_func_array('background_proc...', Array) #12 /var/www/gala/index.php(21): menu_execute_active_handler() #13 {main}

jenlampton’s picture

jenlampton
she / her
CreditAttribution: jenlampton commented
Issue summary: View changes
Status: Active » Closed (outdated)

I'm unable to reproduce this using the default Similar Entries view anymore. I wonder if this issue is still relevant since the last comment was in 2013. I'm going to close this as outdated, but if anyone is still having trouble please re-open.