API error: Data too long for column location at row 1.

  • Resolved losttech

    (@losttech)


    4 years, 7 months ago

    On the free version of flow-flow and our instagram reel started to show deadlinks. In the feed settings, it shows this error:

    flow\db\SafeMySQL: Data too long for column location at row 1. Full query: [INSERT INTO `wp_ff_posts

    I saw another support thread where the user resolved the issue by deleting and reactivating the plugin. After doing this, now the instagram reel doesn’t show up at all on the website.

    • This topic was modified 4 years, 7 months ago by losttech.

    The page I need help with: [log in to see the link]

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter losttech

    (@losttech)

    error message no longer appears and feed says live but the instagram reel is not showing up on the front end.

    Plugin Contributor Oleksandr

    (@awesomeoman)

    Hello, sorry, you can fix it via this SQL query. Run it in your database management tool for “broken” websites:

    ALTER TABLE PREFIX_ff_posts
CHANGE user_pic user_pic text;

    Where PREFIX is your database tables prefix value.

    Otherwise, you can contact us at https://social-streams.com/contact and we will try to help.

    Hi,

    Same problem with the “user_bio” column. Switching the column to “text” type fixed the problem.

    ALTER TABLE PREFIX_ff_posts
CHANGE user_bio user_bio text;

    (Where PREFIX is your database tables prefix value.)

    thx

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘API error: Data too long for column location at row 1.’ is closed to new replies.