Import widget table when no border fails

  • bjornhjelle

    (@bjornhjelle)


    10 years, 1 month ago

    If use this widget with no widget border.
    When I export the wordpress database and import into another site, the import fails:
    ERROR 1265 (01000) at line 13443: Data truncated for column ‘widget_border’ at row 1

    This is because the insert statement tries to insert a record with an illegal value in the widget_border column. So, I need to change the insert statement from
    INSERT INTO wp_statigram_widget VALUES (‘hashtag’, ‘statigram’, ‘test’, ‘statigram’, ‘true’, 280, 320, ‘grid’, 10, 3, 4, 10, ‘true’, ‘FFFFFF’, ‘777777’, ”, 0, ‘DDDDDD’) ;
    to
    INSERT INTO wp_statigram_widget VALUES (‘hashtag’, ‘statigram’, ‘test’, ‘statigram’, ‘true’, 280, 320, ‘grid’, 10, 3, 4, 10, ‘true’, ‘FFFFFF’, ‘777777’, ‘false’, 0, ‘DDDDDD’) ;

    After this the import works fine.

    Hope this helps someone, and perhaps the author of the widget can look into why this happens?

    Otherwise the widget seems to work fine on WP 3.8.1
    B

    https://wordpress.org/plugins/instagram-image-gallery/

  • The topic ‘Import widget table when no border fails’ is closed to new replies.