Error installing FlexSlider Picture on PostgreSQL

Created on 9 November 2015, over 8 years ago
Updated 19 September 2023, 9 months ago

I have a problem installing flexslider_picture in a new drupal 7 site.

Problem

I don't have any flexslider config, so the install process is trying to insert an empty Array.

PDOException: SQLSTATE[55000]: Object not in prerequisite state: 7 ERROR: currval of sequence "flexslider_picture_optionset_id_seq" is not yet defined in this session: INSERT INTO flexslider_picture_optionset (flexslider_optionset, imagestyle_type, mapping, fallback) SELECT f.name AS flexslider_optionset, 'image_style' AS imagestyle_type, '' AS mapping, '' AS fallback FROM flexslider_optionset f; Array ( ) en flexslider_picture_install() (lΓ­nea 82 de /sites/all/modules/picture/flexslider_picture/flexslider_picture.install)

Proposal solution:

a) Check if it is an empty Array
or
b) Modify insert line to db_insert('flexslider_picture_optionset', array('return' => Database::RETURN_NULL)) (maybe it return error if there is some flexslider config)

Drupal 7
Picture 7.x-2.13
PostgreSQL 9.2.13

Alek

πŸ› Bug report
Status

Closed: outdated

Version

2.13

Component

Code

Created by

πŸ‡¦πŸ‡·Argentina alek123

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

  • πŸ‡¬πŸ‡§United Kingdom lesleyfernandes

    I am closing all very old tickets that have not received comments for a long time. If someone is still facing these issues or thinks they are still relevant, please reopen it. Feel free to contribute with more info or a patch.

Production build 0.69.0 2024