Advanced Poll fails to install properly depending on DB config

I am using the following versions and don't have any issues:
Drupal 7.26
Advanced Poll 7.x-3.x-dev
Voting API 7.x-2.11

I'm getting similar errors. However, running multisite (sites are running from identical codebase), I'm able to get Advanced Poll operating correctly on a fresh install.

Neither site will allow Decisions module to work correctly, or uninstall. I have already tried a complete uninstall/reinstall of AdvPoll with no luck.

I was able to get some functionality from AdvPoll at one point and the Content type was excluding all custom fields AdvPoll is suppose to supply. I simply had a content type called 'Advanced Poll' with title/body fields.

My errors are as follows:

WD php: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'ifcs14_dev.field_data_advpoll_dates' doesn't exist: SELECT n.title, n.nid FROM {node} n [error]
LEFT JOIN {field_data_advpoll_dates} d
ON d.revision_id = n.vid
LEFT JOIN {field_data_advpoll_closed} c
ON c.revision_id = n.vid
LEFT JOIN {field_data_advpoll_options} o
ON o.revision_id = n.vid
WHERE
n.type = 'advpoll' AND
o.advpoll_options_value = 'block' AND
n.status = 1 AND
c.advpoll_closed_value = 'open' AND
d.advpoll_dates_value < NOW()
AND d.advpoll_dates_value2 > NOW()
ORDER BY n.created DESC; Array
(
)
in advpoll_get_poll_info_blocks() (line 969 of ...sites/all/modules/contrib/advpoll/advpoll.module).
PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'ifcs14_dev.field_data_advpoll_dates' doesn't exist: SELECT n.title, n.nid FROM {node} n
LEFT JOIN {field_data_advpoll_dates} d
ON d.revision_id = n.vid
LEFT JOIN {field_data_advpoll_closed} c
ON c.revision_id = n.vid
LEFT JOIN {field_data_advpoll_options} o
ON o.revision_id = n.vid
WHERE
n.type = 'advpoll' AND
o.advpoll_options_value = 'block' AND
n.status = 1 AND
c.advpoll_closed_value = 'open' AND
d.advpoll_dates_value < NOW()
AND d.advpoll_dates_value2 > NOW()
ORDER BY n.created DESC; Array
(
)
in advpoll_get_poll_info_blocks() (line 969 of ...sites/all/modules/contrib/advpoll/advpoll.module).
Drush command terminated abnormally due to an unrecoverable error.

Confirmed a fresh install of Drupal and AdvPoll required modules does in fact create the field_data_* tables necessary for this to work.
field_data_advpoll_behavior
field_data_advpoll_choice
field_data_advpoll_closed
field_data_advpoll_cookie_duration
field_data_advpoll_dates
field_data_advpoll_max_choices
field_data_advpoll_mode
field_data_advpoll_options
field_data_advpoll_results

I exported the tables from working installation to the non-working installation. I no longer receive errors (considering the tables now exist). However, no functionality of AdvPoll is available.

Here is the SQL if you're interested:

-- phpMyAdmin SQL Dump
-- version 3.4.10.1deb1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Feb 12, 2014 at 11:33 AM
-- Server version: 5.5.24
-- PHP Version: 5.3.10-1ubuntu3.9

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `ccdemo_dev`
--

-- --------------------------------------------------------

--
-- Table structure for table `field_data_advpoll_behavior`
--

CREATE TABLE IF NOT EXISTS `field_data_advpoll_behavior` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned DEFAULT NULL COMMENT 'The entity revision id this data is attached to, or NULL if the entity type is not versioned',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `advpoll_behavior_value` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`entity_type`,`entity_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `advpoll_behavior_value` (`advpoll_behavior_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Data storage for field 7 (advpoll_behavior)';

--
-- Dumping data for table `field_data_advpoll_behavior`
--

INSERT INTO `field_data_advpoll_behavior` (`entity_type`, `bundle`, `deleted`, `entity_id`, `revision_id`, `language`, `delta`, `advpoll_behavior_value`) VALUES
('node', 'advpoll', 0, 3, 3, 'und', 0, 'approval');

-- --------------------------------------------------------

--
-- Table structure for table `field_data_advpoll_choice`
--

CREATE TABLE IF NOT EXISTS `field_data_advpoll_choice` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned DEFAULT NULL COMMENT 'The entity revision id this data is attached to, or NULL if the entity type is not versioned',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `advpoll_choice_choice_id` varchar(10) NOT NULL,
  `advpoll_choice_choice` varchar(500) NOT NULL,
  `advpoll_choice_write_in` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`entity_type`,`entity_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `advpoll_choice_choice` (`advpoll_choice_choice`(255))
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Data storage for field 5 (advpoll_choice)';

--
-- Dumping data for table `field_data_advpoll_choice`
--

INSERT INTO `field_data_advpoll_choice` (`entity_type`, `bundle`, `deleted`, `entity_id`, `revision_id`, `language`, `delta`, `advpoll_choice_choice_id`, `advpoll_choice_choice`, `advpoll_choice_write_in`) VALUES
('node', 'advpoll', 0, 3, 3, 'und', 0, '4346bf38', 'Choice 1', 0),
('node', 'advpoll', 0, 3, 3, 'und', 1, 'd5b43826', 'Choice 2', 0);

-- --------------------------------------------------------

--
-- Table structure for table `field_data_advpoll_closed`
--

CREATE TABLE IF NOT EXISTS `field_data_advpoll_closed` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned DEFAULT NULL COMMENT 'The entity revision id this data is attached to, or NULL if the entity type is not versioned',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `advpoll_closed_value` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`entity_type`,`entity_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `advpoll_closed_value` (`advpoll_closed_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Data storage for field 8 (advpoll_closed)';

--
-- Dumping data for table `field_data_advpoll_closed`
--

INSERT INTO `field_data_advpoll_closed` (`entity_type`, `bundle`, `deleted`, `entity_id`, `revision_id`, `language`, `delta`, `advpoll_closed_value`) VALUES
('node', 'advpoll', 0, 3, 3, 'und', 0, 'open');

-- --------------------------------------------------------

--
-- Table structure for table `field_data_advpoll_cookie_duration`
--

CREATE TABLE IF NOT EXISTS `field_data_advpoll_cookie_duration` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned DEFAULT NULL COMMENT 'The entity revision id this data is attached to, or NULL if the entity type is not versioned',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `advpoll_cookie_duration_value` int(11) DEFAULT NULL,
  PRIMARY KEY (`entity_type`,`entity_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Data storage for field 9 (advpoll_cookie_duration)';

--
-- Dumping data for table `field_data_advpoll_cookie_duration`
--

INSERT INTO `field_data_advpoll_cookie_duration` (`entity_type`, `bundle`, `deleted`, `entity_id`, `revision_id`, `language`, `delta`, `advpoll_cookie_duration_value`) VALUES
('node', 'advpoll', 0, 3, 3, 'und', 0, 60);

-- --------------------------------------------------------

--
-- Table structure for table `field_data_advpoll_dates`
--

CREATE TABLE IF NOT EXISTS `field_data_advpoll_dates` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned DEFAULT NULL COMMENT 'The entity revision id this data is attached to, or NULL if the entity type is not versioned',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `advpoll_dates_value` datetime DEFAULT NULL,
  `advpoll_dates_value2` datetime DEFAULT NULL,
  PRIMARY KEY (`entity_type`,`entity_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Data storage for field 10 (advpoll_dates)';

--
-- Dumping data for table `field_data_advpoll_dates`
--

INSERT INTO `field_data_advpoll_dates` (`entity_type`, `bundle`, `deleted`, `entity_id`, `revision_id`, `language`, `delta`, `advpoll_dates_value`, `advpoll_dates_value2`) VALUES
('node', 'advpoll', 0, 3, 3, 'und', 0, '2014-02-12 00:00:00', '2014-03-14 00:00:00');

-- --------------------------------------------------------

--
-- Table structure for table `field_data_advpoll_max_choices`
--

CREATE TABLE IF NOT EXISTS `field_data_advpoll_max_choices` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned DEFAULT NULL COMMENT 'The entity revision id this data is attached to, or NULL if the entity type is not versioned',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `advpoll_max_choices_value` int(11) DEFAULT NULL,
  PRIMARY KEY (`entity_type`,`entity_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Data storage for field 6 (advpoll_max_choices)';

--
-- Dumping data for table `field_data_advpoll_max_choices`
--

INSERT INTO `field_data_advpoll_max_choices` (`entity_type`, `bundle`, `deleted`, `entity_id`, `revision_id`, `language`, `delta`, `advpoll_max_choices_value`) VALUES
('node', 'advpoll', 0, 3, 3, 'und', 0, 1);

-- --------------------------------------------------------

--
-- Table structure for table `field_data_advpoll_mode`
--

CREATE TABLE IF NOT EXISTS `field_data_advpoll_mode` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned DEFAULT NULL COMMENT 'The entity revision id this data is attached to, or NULL if the entity type is not versioned',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `advpoll_mode_value` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`entity_type`,`entity_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `advpoll_mode_value` (`advpoll_mode_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Data storage for field 11 (advpoll_mode)';

--
-- Dumping data for table `field_data_advpoll_mode`
--

INSERT INTO `field_data_advpoll_mode` (`entity_type`, `bundle`, `deleted`, `entity_id`, `revision_id`, `language`, `delta`, `advpoll_mode_value`) VALUES
('node', 'advpoll', 0, 3, 3, 'und', 0, 'normal');

-- --------------------------------------------------------

--
-- Table structure for table `field_data_advpoll_options`
--

CREATE TABLE IF NOT EXISTS `field_data_advpoll_options` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned DEFAULT NULL COMMENT 'The entity revision id this data is attached to, or NULL if the entity type is not versioned',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `advpoll_options_value` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`entity_type`,`entity_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `advpoll_options_value` (`advpoll_options_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Data storage for field 12 (advpoll_options)';

--
-- Dumping data for table `field_data_advpoll_options`
--

INSERT INTO `field_data_advpoll_options` (`entity_type`, `bundle`, `deleted`, `entity_id`, `revision_id`, `language`, `delta`, `advpoll_options_value`) VALUES
('node', 'advpoll', 0, 3, 3, 'und', 0, 'showvotes');

-- --------------------------------------------------------

--
-- Table structure for table `field_data_advpoll_results`
--

CREATE TABLE IF NOT EXISTS `field_data_advpoll_results` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned DEFAULT NULL COMMENT 'The entity revision id this data is attached to, or NULL if the entity type is not versioned',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `advpoll_results_value` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`entity_type`,`entity_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `advpoll_results_value` (`advpoll_results_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Data storage for field 13 (advpoll_results)';

--
-- Dumping data for table `field_data_advpoll_results`
--

INSERT INTO `field_data_advpoll_results` (`entity_type`, `bundle`, `deleted`, `entity_id`, `revision_id`, `language`, `delta`, `advpoll_results_value`) VALUES
('node', 'advpoll', 0, 3, 3, 'und', 0, 'aftervote');

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

Possible Solution
I was able to do a removal all advpoll tables, remove field bundles advpoll setup, reset the schema_version of all advpoll modules in the system table (-1) to get Drupal to see the module as uninstalled. Once I re-enabled the module it installed correctly.

What I meant was that I removed all rows in the 'field_config' and 'field_config_instance' tables where advpoll was set in the 'bundle' column.

The goal is to get the module completely uninstalled and reinstalled. I had errors uninstalling as the module wouldn't complete the uninstall because of database errors. The schema version shouldn't be set if the module is uninstalled. The schema version being set imply that the tables exist in the first place.

Since I have this module working ok for me, let me know if you need any DB or other information from me for troubleshooting or comparison purposes.
I am using the Zeropoint theme, not sure if that matters.

What I would also suggest to isolate the issue is to get a new domain with Drupal installed with the default theme and no other modules. If it works, then start adding the other modules one-by-one until you find which one of them might be causing the issue.

Unfortunately we aren't getting any help from the maintainer or other users of this module. It seems neglected.

Actually the best response you will get if you post this topic in the Post Installation area: https://drupal.org/forum/22 where it will be exposed to all and not only Advanced Poll users. Since it is a DB issue, you might get a solution.

I had the same PDOException as above regarding advpoll_dates not existing. I upgraded from 6.x-1.x-dev to 7.x.3.x-dev. This isn't an issue to do with dev versions is it?

Here's the message I got when I ran update.php:

dvpoll module
Update #7000

Failed: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'xxxx_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 /home/xxxxxxxxxx/public_html/sites/all/modules/advpoll/advpoll.install).

Similar problems here, after an upgrade from 6.35 to 7.36.
I had been using advpoll before the upgrade.After (re-)enabling advpoll, I found no way to put my Drupal 7 system in a state which did not require an (impossible) update.

The only way for me to get a functional system was to reload the upgraded data base and, using phpmyadmin, manually remove all entries relating to my (one and only !) ranking poll before dropping the advpoll tables. That cleanup done, I was pretty glad to have only to do it for one poll.

Now that I have a DB free of adv-poll entries or tables, I could try to install advpoll-7.x-3.x-dev, if it helps.

-rg-

hi, the solutions is, install this patch to core https://www.drupal.org/node/1812056 or install drupal core 7.37 this patch is commit in the next release, later install adv_poll and working.

dont forget uninstall advpoll before apply patch, and later install

It first looked very bad.

Started with a clean DB, no advpoll in sites/all/modules, Drupal @ 7.37.
Unpacked advpoll-7.x-3.x-dev.tar.gz; ran update.php - which ends with an error message. Sorry, message lost.

Tried to enable Advanced Poll itself - Date Popup was automatically enabled too.

Ran update.php, results in error message
==================================
PDOException : SQLSTATE[42S02]: Base table or view not found: 1146 Table 'edusatorg001.field_data_advpoll_dates' doesn't exist: SELECT n.title, n.nid FROM {node} n LEFT JOIN {field_data_advpoll_dates} d ON d.revision_id = n.vid LEFT JOIN {field_data_advpoll_closed} c ON c.revision_id = n.vid LEFT JOIN {field_data_advpoll_options} o ON o.revision_id = n.vid WHERE n.type = 'advpoll' AND o.advpoll_options_value = 'block' AND n.status = 1 AND c.advpoll_closed_value = 'open' AND d.advpoll_dates_value < NOW() AND d.advpoll_dates_value2 > NOW() ORDER BY n.created DESC; Array ( ) dans advpoll_get_poll_info_blocks() (ligne 969 dans /ligo/www/edu7xx/sites/all/modules/advpoll/advpoll.module).
==================================
and site gone off-line !!!

Time for a clean-up, now. Site off-line.

Successively disabling both modules. Attempting to de-install Advanced Poll, then Advanced Poll Field. Ah ! This works, now !
Running update.php - no nasties, *NO* update pending, this time.

Cannot install, but can now deinstall without hammer and wrench. Great !
Assuming the DB cleanup wasn't perhaps thorough enough, and the clean deinstallation had remedied that ...
Restarted the two-step module installation. Ran update.php without a hitch.

Truely, it worked ! Thanks a lot !

For me, this was all happening because the install hook failed.

It failed when creating a table "advpoll_choice_Array" which is obviously not the correct name. After lots of digging and hacking, I discovered the problem was occurring when the fields were being created and this one particular field 'advpoll_choice' was failing.

Rather than install the tables manually, as tempting as that was, I fixed the field definition in the install hook.

Simple, small issue but this has fixed the install process for me. Patch attached.

While my last patch *may* help some of you, its not a silver bullet.

It will get you past the field creation bug but you may run into another error;

PDOException: SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes

This is because the indexes combined in that table are greater that the limit imposed by MySQL (In this case 767 bytes.) (Note advpoll_choice_choice is a varchar(500), bundle is varchar(128), entity_type is varchar(128), language is varchar(32) which equals 788. (Please correct me if I'm wrong here as I believe this is how the limit is applied.)

http://mechanics.flite.com/blog/2014/07/29/using-innodb-large-prefix-to-... writes;

The 767 byte limit is per column, so you can include multiple columns (each 767 bytes or smaller) up to 3072 total bytes per index, but no column longer than 767 bytes

I was able to run the install locally but it fell over on dev. After some research I discovered that there is a variable in MySQL allowing larger limits for these indexes and that it was enabled on my local machine (MAMP default perhaps) and not enabled on dev & prod;

mysql> show variables like 'innodb_large_prefix';
+---------------------+-------+
| Variable_name       | Value |
+---------------------+-------+
| innodb_large_prefix | OFF   |
+---------------------+-------+
1 row in set (0.00 sec)

So, we could try to have fewer indexes with smaller sizes or we just increase this variable.

Also cleaned the patch and made sure all indexes were uniform in format.

My patch is against 7.x-3.x not 7.x-2.x hence it is failing.

ok, let's try that again shall we?

Considering this issue was about 7.x-2.x I didnt want to change the version merely for testing my patch, discussion was still regarding 2.x.

New patch.

I had to remove the 'choice' key entirely so I could install this across different instances. Changing the key length limit for me is just not a viable option.

Patch

The patch applies cleanly and does what it says. I'm reluctant to mark RTBC though as installation works fine for me with or without this patch.

Interestingly I'm using MAMP, and innodb_large_prefix is OFF.

Another user reported install errors at #2505491: Error at installation! and I have pointed them here. If the patch works for them, I'll RTBC it.

..and this patch fixed #2505491: Error at installation!. Committed.