Hello,

I want to upgrade from 6.x-3.x-dev 2012-Jan-27 to 7.x-3.x-dev 2012-Jun-29 and receive the following error message, update failed:

Update #7000
Failed: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table '1823651.drupal_field_data_advpoll_options' doesn't exist: DELETE FROM {field_data_advpoll_options} WHERE (advpoll_options_value = :db_condition_placeholder_0) ; Array ( [:db_condition_placeholder_0] => showvotes ) in advpoll_update_7000() (line 816 of /htdocs/drupal/sites/all/modules/advpoll/advpoll.install).

If I ignore the update error and enable advpoll module - the same problem like here:
field_data_advpoll_dates table not found

Whats wrong?

Greetings
Frank

CommentFileSizeAuthor
#2 advpoll_tables.png4.02 KBMichele Wickham

Comments

Michele Wickham’s picture

Michele Wickham commented
Assigned: Unassigned » Michele Wickham

If you have any additional information about what triggered this error message, please let me know. I have heard that there may be a problem with the dependency on the Date module and that I may need to set Date defaults during install. Maybe that caused the installation to skip writing that table.

I'll have a look at this over the weekend.

Michele Wickham’s picture

Michele Wickham commented
StatusFileSize
new advpoll_tables.png4.02 KB

Did you have any errors when you initially installed the d7 version of the module?

You should see the following tables after a successful install:
Advanced Poll 7 Tables

Can you let me know if you encountered any issues during this stage?

I posted a new build today. If you could try a fresh install with that build and let me know that would be very helpful.

frank.dev’s picture

frank.dev commented

Hi mishwick,

Also with the new dev version the mistake exists furthermore - even if with slightly changed text:

Update #7000

Failed: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'databasa.mywebsite_field_data_advpoll_options' doesn't exist: DELETE FROM {field_data_advpoll_options} WHERE (advpoll_options_value = :db_condition_placeholder_0) ; Array ( [:db_condition_placeholder_0] => showvotes ) in advpoll_update_7000() (line 816 of /drupal/sites/all/modules/advpoll/advpoll.install).

None of the "field_data_advpoll_xxx"-tables exists after upgrade in the database.

@date module: Before the upgrade I have put back the module on defaults.

Many thanks for your support . :-)
Frank

Michele Wickham’s picture

Michele Wickham commented

I'm pretty puzzled, I have done a few fresh installs in the last couple days and cannot get that error.

If there's any additional information you can send me that might be helpful I can try a couple other things - for instance, what version of php, apache, database etc. What version of Drupal?

Thanks,
Michele

philalonso’s picture

philalonso commented

I get the same error when upgrading from 6.x-3.x-dev to 7.x-3.x-dev:
Failed: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'example.field_data_advpoll_options' doesn't exist: DELETE FROM {field_data_advpoll_options} WHERE (advpoll_options_value = :db_condition_placeholder_0) ; Array ( [:db_condition_placeholder_0] => showvotes ) in advpoll_update_7000() (line 816 of C:\Desktop\example\httpdocs\sites\all\modules\advpoll\advpoll.install).
The Advanced Poll Field installs, but not Advanced Poll module.

akamaus’s picture

akamaus commented

I've stumbled upon a similar error while updating D6 site too. I used drush sup, the actual message was a bit different:

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'site.field_data_advpoll_options' doesn't [error]
exist

I tried disabling and uninstalling the module. After it successfully installed. Maybe the field table creation process executed only on fresh installation?

rkneale’s picture

rkneale commented

I also get this issue, but not as an upgrade, as a fresh install on a D7 site, today:

The following updates returned messages
advpoll module
Update #7000

Failed: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'atst.field_data_advpoll_options' doesn't exist: DELETE FROM {field_data_advpoll_options} WHERE (advpoll_options_value = :db_condition_placeholder_0) ; Array ( [:db_condition_placeholder_0] => showvotes ) in advpoll_update_7000() (line 816 of /var/www/html/sites/all/modules/advpoll/advpoll.install).

Marat’s picture

Marat commented

I got the same error, and I couldn't find a way to downgrade the upgrade.

This module one of the best and has so many great features but buggy. I hope someone can fix it!

savioret’s picture

savioret commented

I'm also trying to upgrade my site from drupal 6 to 7.
I get the mentioned table error.
I have zero tables named "field_data_advpoll_*"
Seems that the advpoll.install script is omitting the field table creation somehow in the update.php operation.

Version 7.x-3.x-dev (2013-Sep-30)

Is the advanced poll module able to migrate D6 tables to the new field_data tables ?

By the way, is this issue a duplicate?
#1579744: Upgrade from 6.x-3.x to 7.x-3.x

tripper54’s picture

tripper54 commented
Issue summary: View changes
Status: Active » Closed (duplicate)

Duplicate of #1579744: Upgrade from 6.x-3.x to 7.x-3.x