The update 7102 does not run with the followin error

"DrupalUpdateException: A database error occurred during update: SQLSTATE[42S02]: Base table or view not found: 1146 Table search_api_page doesn't exist στην search_api_autocomplete_update_7102() (line 150 /home/sites/all/modules/search_api_autocomplete/search_api_autocomplete.install)."

There is no table search_api_page on my installation.

After creating the table using the definition http://drupalcode.org/project/search_api.git/blob/10f3f36c474f5b6016e3e9...

the update works.

Comments

merilainen’s picture

I got something similar using drush

search_api_autocomplete module :
  7102 -   Convert settings for search pages to use machine names instead of IDs.

Do you wish to run all pending updates? (y/n): y
A database error occurred during update: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'srvdev.search_api_page' doesn't exist                                                                                                             [error]
Performed update: search_api_autocomplete_update_7102                                                                                                                                                                                                                [ok]
Finished performing updates.

I'm using only Solr , so I assume this doesn't concern me, because I don't have any Search API search pages.

drunken monkey’s picture

Title: Database update failed (update.php) » Fix database update 7102 (Search page IDs)
Status: Active » Needs review
StatusFileSize
new488 bytes

Thanks a lot for reporting this, this was a very stupid mistake of me!
In the update code, I updated the autocomplete settings for search pages – but didn't actually check whether the Search Pages module is installed, resp., the {search_api_page} table exists.
For the numerous people who don't use that module, this will of course fail.

It's harmless, though, the update is in any case a no-op for that setup. But of course we shouldn't output ghastly database errors and confuse/worry users.

Patch attached, please see if the update works for you with it!
(Manually change the module version in the {system} table if you don't have a backup at hand. But of course only if this is a development/test site.)

drunken monkey’s picture

Version: 7.x-1.0-rc1 » 7.x-1.x-dev
drunken monkey’s picture

Priority: Normal » Major

Could you please test, so I can commit this and create the 1.0 release soon?

jantoine’s picture

Status: Needs review » Reviewed & tested by the community

The patch in #2 fixes the issue.

drunken monkey’s picture

Status: Reviewed & tested by the community » Fixed

Thanks for testing!
Committed.

aleada’s picture

nice ;)

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

aavgoustinos’s picture

Status: Closed (fixed) » Needs review
StatusFileSize
new27.39 KB

Please can you explain how i can fix this error, i do not understand what i have to do..

Thank you

drunken monkey’s picture

Status: Needs review » Fixed

If you aren't using the Search API pages module, simply ignore this error, it won't have any effect.

aavgoustinos’s picture

i am using the search api module....and i do not understand what i have to do in order to fix the problem..

thank you

drunken monkey’s picture

Do not do anything. Even if an error is displayed, it has no consequences.

aavgoustinos’s picture

Status: Fixed » Active

after implementing the changes Drupal works, however the search api auto complete giving an error: the website encountered an unexpected error. please try again later.can you please help..

drunken monkey’s picture

Status: Active » Fixed

Please open a new issue for that and provide some details.

aavgoustinos’s picture

Done fix
thank you all for your help
Avgoustinos

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

Anonymous’s picture

Issue summary: View changes

missing table