Unable to Open File Message

Apache error logs reveal:

[Fri Oct 02 03:44:56 2020] [notice] [pid 103304] sapi_apache2.c(349): [client 146.96.33.242:54844] WordPress database error Table ‘library_wp.mrl365_alert_notice_boxes’ doesn’t exist for query SELECT * FROM mrl365_alert_notice_boxes ORDER BY delay DESC made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/hestia/404.php’), get_footer, locate_template, load_template, require_once(‘/themes/hestia-child/footer.php’), wp_footer, do_action(‘wp_footer’), WP_Hook->do_action, WP_Hook->apply_filters, YCanb->register_alert_notice_boxes

Any ideas?

Hi, can you send me the link to the page that gives you the message

When editing an alert:
https://library.gc.cuny.edu/new4/wp-admin/post-new.php?post_type=anb
then after clicking publish:
https://library.gc.cuny.edu/new4/wp-admin/post.php

I tried reinstalling.

Thank you!

Was able to publish, but does not show and current alert remains even after disabling. I disabled the alert and click update, but <Enabled> checkbox returns after clicking on <Update>. Stranger is I moved all into the trash, but the the old one remains on the site.

Questions: does Apache need write access to the plugin?

I gave Apache access to write to and execute the plugin, so not getting unabel to open file errors, but still not publishing. Here is a log entry when attempting to publish:

146.96.33.199 – – [06/Oct/2020:15:05:11 -0400] “POST /new4/wp-admin/admin-ajax.php HTTP/1.1” 200 1 “https://libdev.gc.cuny.edu/new4/wp-admin/post.php?post=3565&action=edit&#8221; “Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/85.0.4183.102 Safari/537.36” 21233 libdev.gc.cuny.edu

Here is the error log:

[Tue Oct 06 15:05:11 2020] [notice] [pid 13381] sapi_apache2.c(349): [client 146.96.33.199:56387] WordPress database error Table ‘library_wp.mrl365_alert_notice_boxes’ doesn’t exist for query SELECT * FROM mrl365_alert_notice_boxes ORDER BY delay DESC made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/hestia/front-page.php’), get_footer, locate_template, load_template, require_once(‘/themes/hestia-child/footer.php’), wp_footer, do_action(‘wp_footer’), WP_Hook->do_action, WP_Hook->apply_filters, YCanb->register_alert_notice_boxes
[Tue Oct 06 15:05:57 2020] [notice] [pid 5213] sapi_apache2.c(349): [client 146.96.33.199:56395] WordPress database error Table ‘library_wp.mrl365_alert_notice_boxes’ doesn’t exist for query SELECT * FROM mrl365_alert_notice_boxes WHERE post_ID = 3565 made by require(‘wp-admin/edit-form-advanced.php’), do_meta_boxes, anb_item_meta_box

Hi,
It appears that the data table was not created on your server.
This problem could be due to a number of antivirus component on the server or site that deletes the data table in your database (of course there could be other reasons).
Do you know how to check if the table exists in your database? If so, check that she looks like this https://nimb.ws/W7PX2e

Interesting, but it previously worked, so not sure, but I will ask IT as well as test on XAMPP.

yes, you are correct. I just installed on my local computer and the table was created. I wonder why it previously worked and not know.

Anyway, I will speak to IT and then get back to you if I continue to experience issues.

Thank you!

IT does not have underlying virus software running.

I ran a few tests:
Deleted plugin and re-installed.
An entire new fresh install.
Neither worked.

I then installed on my desktop using XAMP and worked.

Any other ideas?

IT jumped in and here is there response:

Based on the log, I think the plugin only allows creation of tables only using MyISAM storage engine but not InnoDB. MyISAM is an legacy storage engine that does not support MySQL galera clustering well. You may ask the developer to modify his code to support at least InnoDB storage engine.

WordPress database error Unknown storage engine ‘MyISAM’ for query CREATE TABLE wp_alert_notice_boxes (\n\t\tid int(11) NOT NULL AUTO_INCREMENT,\n\t\tpost_ID int(11) NOT NULL,\n\t\ttitle TEXT NULL,\n\t\tdisplay_in TEXT NULL,\n\t\tlocation_id VARCHAR(100) NULL,\n\t\tdesign_id VARCHAR(100) NULL,\n\t\tanimation_id VARCHAR(100) NULL,\n\t\tanimation_out_id VARCHAR(100) NULL,\n\t\tdelay int(11) DEFAULT ‘2000’,\n\t\tshow_time int(11) DEFAULT ‘8000’,\n\t\tenabled VARCHAR(100) NULL,\n\t\tuser_types VARCHAR(100) NULL,\n\t\tdevice_class VARCHAR(100) NULL,\n\t\tPRIMARY KEY (id)\n\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 made by require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘plugins_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, anb_update_db_check, alert_notice_boxes_install, dbDelta

I’ll check this out and see what I can do.
I will update soon

Thank you.
Please post to this forum when complete, so I get an email notifying me.

Thank you.

Hey,
I’ve uploaded a version update that needs to fix the problem,
Do the following:
1. Update the plugin to version 2.1.9
2. Turn off and delete the plugin
3. Install version 2.1.9

These steps will fix your database table