ON INSTALLATION

PDOException: SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes: CREATE TABLE {instagram_rtb_media} ( `id` INT NOT NULL auto_increment COMMENT 'Primary Key: Unique picture ID.', `uid` INT NOT NULL COMMENT 'The id of the user.', `media_id` VARCHAR(256) NOT NULL COMMENT 'The media id.', `standard` VARCHAR(260) NOT NULL COMMENT 'URL of standard image.', PRIMARY KEY (`id`), INDEX `list` (`uid`, `media_id`) ) ENGINE = InnoDB DEFAULT CHARACTER SET utf8 COMMENT 'Stores pictures for the instagram block.'; Array ( ) in db_create_table() (line 2776 of /home/xxxx/public_html/includes/database/database.inc).

AFTER ADDING CREDENTIALS TO CONFIGURATION

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'xxxxxxx.instagram_rtb_media' doesn't exist: SELECT m.standard AS standard FROM {instagram_rtb_media} m ORDER BY RAND() ASC LIMIT 100 OFFSET 0; Array ( ) in instagram_real_time_block_get_recent_media() (line 461 of /home/xxxx/public_html/sites/all/modules/contrib/instagram_real_time_block/instagram_real_time_block.module).

Comments

Anonymous’s picture

weavingmedia created an issue. See original summary.

Cyclonecode’s picture

Status: Active » Needs review

@weavingmedia:

I think this now should be resolved. Would be very nice if you could add which mysql version you are running, since I didn't had the same problem running mysql 5.5.44.

Cyclonecode’s picture

Status: Needs review » Fixed

Status: Fixed » Closed (fixed)

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