wp-media / wp-media/imagify-plugin

Missing`wp_imagify_folders` database table

Open
#688 2 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

priority: medium severity: moderate type: bug
Dominant language
PHP
Stars
82
Forks
31
Avg merge
5d 10h
Merged PRs (30d)
9

Description

Before submitting an issue please check that you’ve completed the following steps:
Using version 2.0.
Yes, have search on the table name with and without wp_ prefix.

Describe the bug
There is a database table missing and can't seem to get it fixed

WordPress databasefout: [Table 'local.wp_imagify_folders' doesn't exist]
SELECT folder_id FROM wp_imagify_folders LIMIT 1;

WordPress databasefout: [Table 'local.wp_imagify_files' doesn't exist]
SELECT COUNT( file_id ) FROM wp_imagify_files

WordPress databasefout: [Table 'local.wp_imagify_files' doesn't exist]
SELECT COUNT( file_id ) FROM wp_imagify_files WHERE status IS NULL

WordPress databasefout: [Table 'local.wp_imagify_files' doesn't exist]
SELECT COUNT( file_id ) FROM wp_imagify_files WHERE status IN ('success','already_optimized')

WordPress databasefout: [Table 'local.wp_imagify_files' doesn't exist]
SELECT COUNT( file_id ) FROM wp_imagify_files WHERE status = 'error'

WordPress databasefout: [Table 'local.wp_imagify_files' doesn't exist]
SELECT COUNT( file_id ) FROM wp_imagify_files WHERE status = 'success'

WordPress databasefout: [Table 'local.wp_imagify_files' doesn't exist]
SELECT SUM( original_size ) FROM wp_imagify_files WHERE status = 'success'

WordPress databasefout: [Table 'local.wp_imagify_files' doesn't exist]
SELECT SUM( optimized_size ) FROM wp_imagify_files WHERE status = 'success'

To Reproduce
Steps to reproduce the behavior:

  1. Go to Bulk Optimizer screen http://wordpress.local/wp-admin/upload.php?page=imagify-bulk-optimization
  2. View debug info in to op screen.
  3. See error

Expected behavior
No errors.

Step to try and fix it
Deactivate and activate plugin - Still not working
Run bulk optimizer in hope it updates DB table - Still not working

I don't know when this error occured, but it's there and no option to fix it..

Backlog Grooming (for WP Media dev team use only)

  • Reproduce the problem
  • Identify the root cause
  • Scope a solution
  • Estimate the effort

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start by reproducing the error from the Bulk Optimizer screen at wp-admin/upload.php?page=imagify-bulk-optimization and inspect the reported wp_imagify_folders and wp_imagify_files queries. Determine why activation does not create the tables; done means the screen no longer reports missing-table database errors.

Written by the indexing model from the issue text.

Assessment

Tech stack
php, wordpress
Domain
database
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.