wp-media / wp-media/imagify-plugin
Missing`wp_imagify_folders` database table
Nobody has claimed this yet.
- 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:
- Go to Bulk Optimizer screen http://wordpress.local/wp-admin/upload.php?page=imagify-bulk-optimization
- View debug info in to op screen.
- 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
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- 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