Database prefix error
-
I am getting a php error in the server log when I change the resmush.it compression amount. I have a database table prefix set in my wp_config.php file using the variable
$table_prefix
But the error seems to suggest that the query is ignoring the table prefix and just using xxxxxxx.wp_posts (xxxxxxx is where my database name would be), when it should be
xxxxxxxxxx.wp_$table_prefix_posts
[Mon Dec 23 13:35:27.734468 2019] [proxy_fcgi:error] [pid 26081] [client 127.0.0.1:39940] AH01071: Got error ‘PHP message: WordPress database error Table ‘xxxxxxxxxx.wp_posts’ doesn’t exist for query SELECT ATTACHMENTS.* FROM (\n\t\t\t\tselect \n\t\t\t\t\tPOSTS.ID as ID, METAQLTY.meta_value as qlty, METADISABLED.meta_value as disabled\n\t\t\t\t\t,POSTS.guid as guid, METAATTACH.meta_value as file_meta\n\t\t\t\tfrom wp_posts as POSTS\n\t\t\t\tinner join \n\t\t\t\t\twp_postmeta as METAATTACH on POSTS.ID = METAATTACH.post_id \n\t\t\t\t\tand METAATTACH.meta_key = ‘_wp_attachment_metadata’ \n\t\t\t\tleft join \n\t\t\t\t\twp_postmeta as METAQLTY on POSTS.ID = METAQLTY.post_id \n\t\t\t\t\tand METAQLTY.meta_key = ‘resmushed_quality’\n\t\t\t\tleft join \n\t\t\t\t\twp_postmeta as METADISABLED on POSTS.ID = METADISABLED.post_id \n\t\t\t\t\tand METADISABLED.meta_key = ‘resmushed_disabled’\n\t\t\t\twhere \n\t\t\t\t\tPOSTS.post_type = ‘attachment’\n\t\t\t\t\tand (POSTS.post_mime_type = ‘image/jpeg’ OR POSTS.post_mime_type = ‘image/gif’ OR POSTS.post_mime_type = ‘image/png’)\n\t\t\t\t) as ATTACHMENTS\n\t\t\t\tWHERE \n\t\t\t\t\t(ATTACHMENTS.qlty != ’75’ OR ATTACHMENTS.qlty IS NULL)\n\t\t\t\t\tAND ATTACHMENTS.disabled IS NULL\n\t\t\t\tLI…’, referer: https://www.findingtheuniverse.com/wp-admin/upload.php?page=resmushit_options
The topic ‘Database prefix error’ is closed to new replies.