Support » Plugin: ShortPixel Image Optimizer » WordPress database error: [Table wp_shortpixel_folders’ doesn’t exist]

  • Resolved iidbae

    (@iidbae)


    This morning I try to change my plugin image optimizer into Shortpixel and got error message in Settings > ShortPixel

    The complete error message.

    WordPress database error: [Table ‘tarjiemc_com.wp_shortpixel_folders’ doesn’t exist]
    SELECT * FROM wp_shortpixel_folders WHERE status <> -1

    WordPress database error: [Table ‘tarjiemc_com.wp_shortpixel_meta’ doesn’t exist]
    SELECT count(*) totalFiles, sum(CASE WHEN status = 2 THEN 1 ELSE 0 END) totalProcessedFiles, sum(CASE WHEN status = 2 AND compression_type = 1 THEN 1 ELSE 0 END) totalProcLossyFiles, sum(CASE WHEN status = 2 AND compression_type = 2 THEN 1 ELSE 0 END) totalProcGlossyFiles, sum(CASE WHEN status = 2 AND compression_type = 0 THEN 1 ELSE 0 END) totalProcLosslessFiles FROM wp_shortpixel_meta WHERE status <> -1

    WordPress database error: [Table ‘tarjiemc_com.wp_shortpixel_meta’ doesn’t exist]
    SELECT id, name, path, message FROM wp_shortpixel_meta WHERE status < -1 AND retries >= 3 LIMIT 30

    My website https://tarjiem.com/ .

    Thank you for your help.

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

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author ShortPixel

    (@shortpixel)

    Hello,

    Could you please check that you have a wp_option called: ‘wp-short-pixel-has-custom-folders’ set to 1? If this is the case, please set it to 0 and please let me know if this fixes.

    Did you previously uninstall ShortPixel and delete by hand the tables wp_shortpixel_folders and wp_shortpixel_meta? This would explain.

    Best regards,
    Simon.

    I just realize if I have asking a question previously here for support too. I am very embarrassed.

    Could you please check that you have a wp_option called: ‘wp-short-pixel-has-custom-folders’ set to 1? If this is the case, please set it to 0 and please let me know if this fixes.

    I can not find “wp-short-pixel-has-custom-folders” in my database via phpmyadmin.

    Did you previously uninstall ShortPixel and delete by hand the tables wp_shortpixel_folders and wp_shortpixel_meta? This would explain.

    I guess yes.

    Thank you for your reply.

    Plugin Author ShortPixel

    (@shortpixel)

    Hi, did you manage to fix? If you still encounter the problem, could you please contact us on our support form (https://shortpixel.com/contact) in order to be able to assist you further?

    Thank you for your reply.

    Hi, did you manage to fix?

    The problem still exist and I did not do anything. I am just waiting for your solution.

    This is the screenshot from the wp-admin.

    If you still encounter the problem, could you please contact us on our support form (https://shortpixel.com/contact) in order to be able to assist you further?

    I am not your premium user, but I will try this.
    thank you.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘WordPress database error: [Table wp_shortpixel_folders’ doesn’t exist]’ is closed to new replies.